eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_AUTOALLOC_WF_PKG dependencies on UTL_FILE

Line 2869: If utl_file.Is_Open(G_FILE_PTR) Then

2865: v_err_stack := 'Initialize_Debug';
2866: Set_PA_WF_Stack(PA_Item_Type,PA_Item_Key,v_err_stack);
2867: G_FILE := 'PA'||PA_item_key ||'.dbg';
2868: G_Err_Stage := 'Debug File IS '||G_FILE;
2869: If utl_file.Is_Open(G_FILE_PTR) Then
2870: utl_file.fclose(G_FILE_PTR);
2871: End If;
2872: G_DIR := wf_engine.GetItemAttrText( itemtype => PA_item_type,
2873: itemkey => PA_item_key,

Line 2870: utl_file.fclose(G_FILE_PTR);

2866: Set_PA_WF_Stack(PA_Item_Type,PA_Item_Key,v_err_stack);
2867: G_FILE := 'PA'||PA_item_key ||'.dbg';
2868: G_Err_Stage := 'Debug File IS '||G_FILE;
2869: If utl_file.Is_Open(G_FILE_PTR) Then
2870: utl_file.fclose(G_FILE_PTR);
2871: End If;
2872: G_DIR := wf_engine.GetItemAttrText( itemtype => PA_item_type,
2873: itemkey => PA_item_key,
2874: aname => 'DEBUG_FILE_DIR');

Line 2875: G_FILE_PTR := utl_file.fopen(G_DIR,G_FILE,'a');

2871: End If;
2872: G_DIR := wf_engine.GetItemAttrText( itemtype => PA_item_type,
2873: itemkey => PA_item_key,
2874: aname => 'DEBUG_FILE_DIR');
2875: G_FILE_PTR := utl_file.fopen(G_DIR,G_FILE,'a');
2876: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2877: G_Err_Stage := 'Exitting Initialize_Debug';
2878: --WriteDebugMsg(G_Err_Stage);
2879:

Line 2882: WHEN UTL_FILE.INVALID_PATH THEN

2878: --WriteDebugMsg(G_Err_Stage);
2879:
2880: Exception
2881:
2882: WHEN UTL_FILE.INVALID_PATH THEN
2883: v_err_stack := wf_engine.GetItemAttrText
2884: ( itemtype => PA_item_type,
2885: itemkey => PA_item_key,
2886: aname => 'WF_STACK');

Line 2888: raise_application_error(-20020,'INVALID PATH exception from UTL_FILE !!'

2884: ( itemtype => PA_item_type,
2885: itemkey => PA_item_key,
2886: aname => 'WF_STACK');
2887:
2888: raise_application_error(-20020,'INVALID PATH exception from UTL_FILE !!'
2889: || v_err_stack||'-'||G_Err_Stage);
2890: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2891:
2892: WHEN UTL_FILE.INVALID_MODE THEN

Line 2892: WHEN UTL_FILE.INVALID_MODE THEN

2888: raise_application_error(-20020,'INVALID PATH exception from UTL_FILE !!'
2889: || v_err_stack||'-'||G_Err_Stage);
2890: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2891:
2892: WHEN UTL_FILE.INVALID_MODE THEN
2893: v_err_stack := wf_engine.GetItemAttrText
2894: ( itemtype => PA_item_type,
2895: itemkey => PA_item_key,
2896: aname => 'WF_STACK');

Line 2897: raise_application_error(-20020,'INVALID MODE exception from UTL_FILE !!'

2893: v_err_stack := wf_engine.GetItemAttrText
2894: ( itemtype => PA_item_type,
2895: itemkey => PA_item_key,
2896: aname => 'WF_STACK');
2897: raise_application_error(-20020,'INVALID MODE exception from UTL_FILE !!'
2898: || v_Err_Stack ||' - '||G_Err_Stage);
2899: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2900:
2901: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 2901: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

2897: raise_application_error(-20020,'INVALID MODE exception from UTL_FILE !!'
2898: || v_Err_Stack ||' - '||G_Err_Stage);
2899: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2900:
2901: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
2902: v_err_stack := wf_engine.GetItemAttrText
2903: ( itemtype => PA_item_type,
2904: itemkey => PA_item_key,
2905: aname => 'WF_STACK');

Line 2911: WHEN UTL_FILE.INVALID_OPERATION THEN

2907: E !!'
2908: || G_Err_Stack ||' - '||G_Err_Stage);
2909: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2910:
2911: WHEN UTL_FILE.INVALID_OPERATION THEN
2912: v_err_stack := wf_engine.GetItemAttrText
2913: ( itemtype => PA_item_type,
2914: itemkey => PA_item_key,
2915: aname => 'WF_STACK');

Line 2916: raise_application_error(-20020,'INVALID OPERATION exception from UTL_FILE

2912: v_err_stack := wf_engine.GetItemAttrText
2913: ( itemtype => PA_item_type,
2914: itemkey => PA_item_key,
2915: aname => 'WF_STACK');
2916: raise_application_error(-20020,'INVALID OPERATION exception from UTL_FILE
2917: !!'
2918: || v_Err_Stack ||' - '||G_Err_Stage);
2919: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2920:

Line 2921: WHEN UTL_FILE.READ_ERROR THEN

2917: !!'
2918: || v_Err_Stack ||' - '||G_Err_Stage);
2919: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2920:
2921: WHEN UTL_FILE.READ_ERROR THEN
2922: v_err_stack := wf_engine.GetItemAttrText
2923: ( itemtype => PA_item_type,
2924: itemkey => PA_item_key,
2925: aname => 'WF_STACK');

Line 2926: raise_application_error(-20020,'READ ERROR exception from UTL_FILE !!'

2922: v_err_stack := wf_engine.GetItemAttrText
2923: ( itemtype => PA_item_type,
2924: itemkey => PA_item_key,
2925: aname => 'WF_STACK');
2926: raise_application_error(-20020,'READ ERROR exception from UTL_FILE !!'
2927: || v_Err_Stack ||' - '||G_Err_Stage);
2928: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2929:
2930: WHEN UTL_FILE.WRITE_ERROR THEN

Line 2930: WHEN UTL_FILE.WRITE_ERROR THEN

2926: raise_application_error(-20020,'READ ERROR exception from UTL_FILE !!'
2927: || v_Err_Stack ||' - '||G_Err_Stage);
2928: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2929:
2930: WHEN UTL_FILE.WRITE_ERROR THEN
2931: v_err_stack := wf_engine.GetItemAttrText
2932: ( itemtype => PA_item_type,
2933: itemkey => PA_item_key,
2934: aname => 'WF_STACK');

Line 2935: raise_application_error(-20020,'WRITE ERROR exception from UTL_FILE !!'

2931: v_err_stack := wf_engine.GetItemAttrText
2932: ( itemtype => PA_item_type,
2933: itemkey => PA_item_key,
2934: aname => 'WF_STACK');
2935: raise_application_error(-20020,'WRITE ERROR exception from UTL_FILE !!'
2936: || v_Err_Stack ||' - '||G_Err_Stage);
2937: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2938:
2939: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 2939: WHEN UTL_FILE.INTERNAL_ERROR THEN

2935: raise_application_error(-20020,'WRITE ERROR exception from UTL_FILE !!'
2936: || v_Err_Stack ||' - '||G_Err_Stage);
2937: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2938:
2939: WHEN UTL_FILE.INTERNAL_ERROR THEN
2940: v_err_stack := wf_engine.GetItemAttrText
2941: ( itemtype => PA_item_type,
2942: itemkey => PA_item_key,
2943: aname => 'WF_STACK');

Line 2944: raise_application_error(-20020,'INTERNAL ERROR exception from UTL_FILE !!

2940: v_err_stack := wf_engine.GetItemAttrText
2941: ( itemtype => PA_item_type,
2942: itemkey => PA_item_key,
2943: aname => 'WF_STACK');
2944: raise_application_error(-20020,'INTERNAL ERROR exception from UTL_FILE !!
2945: '
2946: || v_Err_Stack ||' - '||G_Err_Stage);
2947: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2948:

Line 2974: If NOT utl_file.Is_Open(G_FILE_PTR) OR

2970: Set_PA_WF_Stack (PA_Item_Type,PA_Item_Key,v_err_stack);
2971:
2972: If (DebugFlag) then
2973: If debug_message is not null then
2974: If NOT utl_file.Is_Open(G_FILE_PTR) OR
2975: G_FILE <> 'PA'||PA_item_key ||'.dbg' OR
2976: G_FILE IS NULL Then
2977: G_Err_Stage := 'Calling Initialize Debug from WriteDebugMsg';
2978: /* dbms_output.put_line(G_Err_Stage); */

Line 2981: utl_file.put_line(G_FILE_PTR, debug_message);

2977: G_Err_Stage := 'Calling Initialize Debug from WriteDebugMsg';
2978: /* dbms_output.put_line(G_Err_Stage); */
2979: initialize_debug;
2980: End If;
2981: utl_file.put_line(G_FILE_PTR, debug_message);
2982: utl_file.fflush(G_FILE_PTR);
2983: End if;
2984: End If;
2985: Reset_PA_WF_Stack (PA_Item_Type,PA_Item_Key);

Line 2982: utl_file.fflush(G_FILE_PTR);

2978: /* dbms_output.put_line(G_Err_Stage); */
2979: initialize_debug;
2980: End If;
2981: utl_file.put_line(G_FILE_PTR, debug_message);
2982: utl_file.fflush(G_FILE_PTR);
2983: End if;
2984: End If;
2985: Reset_PA_WF_Stack (PA_Item_Type,PA_Item_Key);
2986:

Line 2989: WHEN UTL_FILE.INVALID_PATH THEN

2985: Reset_PA_WF_Stack (PA_Item_Type,PA_Item_Key);
2986:
2987: Exception
2988:
2989: WHEN UTL_FILE.INVALID_PATH THEN
2990: v_err_stack := wf_engine.GetItemAttrText
2991: ( itemtype => PA_item_type,
2992: itemkey => PA_item_key,
2993: aname => 'WF_STACK');

Line 2995: raise_application_error(-20020,'INVALID PATH exception from UTL_FILE !!'

2991: ( itemtype => PA_item_type,
2992: itemkey => PA_item_key,
2993: aname => 'WF_STACK');
2994:
2995: raise_application_error(-20020,'INVALID PATH exception from UTL_FILE !!'
2996: || v_err_stack||'-'||G_Err_Stage);
2997: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2998:
2999: WHEN UTL_FILE.INVALID_MODE THEN

Line 2999: WHEN UTL_FILE.INVALID_MODE THEN

2995: raise_application_error(-20020,'INVALID PATH exception from UTL_FILE !!'
2996: || v_err_stack||'-'||G_Err_Stage);
2997: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
2998:
2999: WHEN UTL_FILE.INVALID_MODE THEN
3000: v_err_stack := wf_engine.GetItemAttrText
3001: ( itemtype => PA_item_type,
3002: itemkey => PA_item_key,
3003: aname => 'WF_STACK');

Line 3004: raise_application_error(-20020,'INVALID MODE exception from UTL_FILE !!'

3000: v_err_stack := wf_engine.GetItemAttrText
3001: ( itemtype => PA_item_type,
3002: itemkey => PA_item_key,
3003: aname => 'WF_STACK');
3004: raise_application_error(-20020,'INVALID MODE exception from UTL_FILE !!'
3005: || v_Err_Stack ||' - '||G_Err_Stage);
3006: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
3007:
3008: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 3008: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

3004: raise_application_error(-20020,'INVALID MODE exception from UTL_FILE !!'
3005: || v_Err_Stack ||' - '||G_Err_Stage);
3006: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
3007:
3008: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
3009: v_err_stack := wf_engine.GetItemAttrText
3010: ( itemtype => PA_item_type,
3011: itemkey => PA_item_key,
3012: aname => 'WF_STACK');

Line 3018: WHEN UTL_FILE.INVALID_OPERATION THEN

3014: 'INVALID FILEHANDLE exception from UTL_FIL E !!'
3015: || v_Err_Stack ||' - '||G_Err_Stage);
3016: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
3017:
3018: WHEN UTL_FILE.INVALID_OPERATION THEN
3019: v_err_stack := wf_engine.GetItemAttrText
3020: ( itemtype => PA_item_type,
3021: itemkey => PA_item_key,
3022: aname => 'WF_STACK');

Line 3024: 'INVALID OPERATION exception from UTL_FILE !!'

3020: ( itemtype => PA_item_type,
3021: itemkey => PA_item_key,
3022: aname => 'WF_STACK');
3023: raise_application_error(-20020,
3024: 'INVALID OPERATION exception from UTL_FILE !!'
3025: || v_Err_Stack ||' - '||G_Err_Stage);
3026: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
3027:
3028: WHEN UTL_FILE.READ_ERROR THEN

Line 3028: WHEN UTL_FILE.READ_ERROR THEN

3024: 'INVALID OPERATION exception from UTL_FILE !!'
3025: || v_Err_Stack ||' - '||G_Err_Stage);
3026: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
3027:
3028: WHEN UTL_FILE.READ_ERROR THEN
3029: v_err_stack := wf_engine.GetItemAttrText
3030: ( itemtype => PA_item_type,
3031: itemkey => PA_item_key,
3032: aname => 'WF_STACK');

Line 3033: raise_application_error(-20020,'READ ERROR exception from UTL_FILE !!'

3029: v_err_stack := wf_engine.GetItemAttrText
3030: ( itemtype => PA_item_type,
3031: itemkey => PA_item_key,
3032: aname => 'WF_STACK');
3033: raise_application_error(-20020,'READ ERROR exception from UTL_FILE !!'
3034: || v_Err_Stack ||' - '||G_Err_Stage);
3035: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
3036:
3037: WHEN UTL_FILE.WRITE_ERROR THEN

Line 3037: WHEN UTL_FILE.WRITE_ERROR THEN

3033: raise_application_error(-20020,'READ ERROR exception from UTL_FILE !!'
3034: || v_Err_Stack ||' - '||G_Err_Stage);
3035: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
3036:
3037: WHEN UTL_FILE.WRITE_ERROR THEN
3038: v_err_stack := wf_engine.GetItemAttrText
3039: ( itemtype => PA_item_type,
3040: itemkey => PA_item_key,
3041: aname => 'WF_STACK');

Line 3042: raise_application_error(-20020,'WRITE ERROR exception from UTL_FILE !!'

3038: v_err_stack := wf_engine.GetItemAttrText
3039: ( itemtype => PA_item_type,
3040: itemkey => PA_item_key,
3041: aname => 'WF_STACK');
3042: raise_application_error(-20020,'WRITE ERROR exception from UTL_FILE !!'
3043: || v_Err_Stack ||' - '||G_Err_Stage);
3044: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
3045:
3046: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 3046: WHEN UTL_FILE.INTERNAL_ERROR THEN

3042: raise_application_error(-20020,'WRITE ERROR exception from UTL_FILE !!'
3043: || v_Err_Stack ||' - '||G_Err_Stage);
3044: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
3045:
3046: WHEN UTL_FILE.INTERNAL_ERROR THEN
3047: v_err_stack := wf_engine.GetItemAttrText
3048: ( itemtype => PA_item_type,
3049: itemkey => PA_item_key,
3050: aname => 'WF_STACK');

Line 3052: 'INTERNAL ERROR exception from UTL_FILE !! '

3048: ( itemtype => PA_item_type,
3049: itemkey => PA_item_key,
3050: aname => 'WF_STACK');
3051: raise_application_error(-20020,
3052: 'INTERNAL ERROR exception from UTL_FILE !! '
3053: || v_Err_Stack ||' - '||G_Err_Stage);
3054: Reset_PA_WF_Stack(PA_Item_Type,PA_Item_Key);
3055:
3056: When Others Then

Line 3193: -- use first entry of utl_file_dir as the TEMP_DIR

3189: TEMP_UTL VARCHAR2(512);
3190: TEMP_DIR VARCHAR2(255);
3191:
3192: BEGIN
3193: -- use first entry of utl_file_dir as the TEMP_DIR
3194: -- if there is no entry then do not even construct file names
3195: SELECT TRANSLATE(LTRIM(value),',',' ')
3196: INTO TEMP_UTL
3197: FROM v$parameter

Line 3198: WHERE name = 'utl_file_dir';

3194: -- if there is no entry then do not even construct file names
3195: SELECT TRANSLATE(LTRIM(value),',',' ')
3196: INTO TEMP_UTL
3197: FROM v$parameter
3198: WHERE name = 'utl_file_dir';
3199:
3200: IF (INSTR(TEMP_UTL,' ') > 0 AND TEMP_UTL IS NOT NULL) THEN
3201: SELECT SUBSTRB(TEMP_UTL, 1, INSTR(TEMP_UTL,' ') - 1)
3202: INTO TEMP_DIR