How to prevent Outlook from sending an email with a blank Subject line

1.Open your outlook

2.Press Alt+F11 or Tools àMacro àVisual Basic Editor. This opens the Visual Basic editor

3.On the Left Pane, one can see "Microsoft Outlook Objects", expand this. Now one can see the "ThisOutLookSession".

4.Click on "ThisOutLookSession".

5.Copy and Paste the following code in the right pane.

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)

 Dim strSubject As String

 strSubject = Item.Subject

 If Len(strSubject) = 0

 Then

     Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?"

     If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Subject") = vbNo 

       Then

        Cancel = True

     End If

 End If

End Sub

6.Save this and Now close the VB Code editor.

7.In Outlook Go to Tools > Macros > Security > In the Security Level Tab > Select the option MEDIUM > OK

8.Now Restart the Outlook, a dialog box pops up to Disable / Enable the macros; select as Enable Macros (this option will pops up when ever you restart outlook.

9.From now on , this macro will make sure you do not make the mistake of sending a mail without subject

Submiting XMLP Report From Backend

DECLARE

    V_REQUEST_ID NUMBER;

    l_boolean    BOOLEAN;

    l_boolean1  BOOLEAN;

BEGIN

    l_boolean := FND_REQUEST.ADD_DELIVERY_OPTION

               (TYPE         => 'E', -- this one to speciy the delivery option as Email

                p_argument1  => 'Testing the Email option from back end', -- subject for the mail

                p_argument2  => 'raju.ch88@gmail.com', -- from address

                p_argument3  => 'raju.ch88@gmail.com', -- to address

                p_argument4  => 'raju.ch88@gmail.com', -- cc address to be specified here.

                nls_language => '' -- language option

               );        

      

    IF l_boolean = TRUE

    THEN

   

        FND_GLOBAL.APPS_INITIALIZE(8511,51272,20003);

        l_boolean1 := FND_REQUEST.add_layout

                        (template_appl_name   => 'XXAA'

                         ,template_code       => 'XXAAPTOSUEMP'

                         ,template_language   => 'en'

                         ,template_territory  => 'US'

                         ,output_format       => 'PDF'

                        );                    

         

        V_REQUEST_ID := FND_REQUEST.SUBMIT_REQUEST

                           (APPLICATION   => 'XXAA'

                            ,PROGRAM      => 'XXAAPTOSUEMP'

                           );  

                          

        COMMIT ;

        DBMS_OUTPUT.PUT_LINE('Request submitted. V_REQUEST_ID = ' || V_REQUEST_ID);

                      

    END IF;

EXCEPTION

  WHEN OTHERS THEN

    DBMS_OUTPUT.PUT_LINE('Request set submission failed - unknown error: ' ||SQLERRM);

END;

Query To Find Concurrent Program's Parameters and Value Sets

SELECT

  fcp.user_concurrent_program_name "Concurrent Program Name",

  fcp.concurrent_program_name "Short Name",

  fdfcuv.column_seq_num "Column Seq Number",

  fdfcuv.end_user_column_name "Parameter Name",

  fdfcuv.form_left_prompt "Prompt",

  fdfcuv.srw_param,

  ffvs.flex_value_set_name "Value Set Name",

  flv.meaning "Default Type",

  fdfcuv.DEFAULT_VALUE "Default Value"

FROM

  fnd_concurrent_programs_vl fcp,

  fnd_descr_flex_col_usage_vl fdfcuv,

  fnd_flex_value_sets ffvs,

  fnd_lookup_values flv

WHERE 1=1

  AND fdfcuv.descriptive_flexfield_name = '$SRS$.'||fcp.concurrent_program_name

  AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id

  AND flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'

  AND flv.lookup_code(+) = fdfcuv.default_type

--  AND fcp.user_concurrent_program_name like 'XXAA%Report'

--  AND ffvs.flex_value_set_name  LIKE '%JOB%'

ORDER BY

 fcp.user_concurrent_program_name

 ,fdfcuv.column_seq_num

;

More than One File Moving One folder to Another Folder in Command(CMD)

1. Move to Folder Ex:-

--> CD E:\RAJ

2. Run The below Command

--> move ap* E:\XX