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.XDP_AQ_UTILITIES dependencies on FND_FILE

Line 2567: fnd_file.put_line(fnd_file.output,'Total Number of Events Dequeued : '||l_dq_count );

2563: DBMS_LOCK.SLEEP(g_sleep_time);
2564:
2565: END LOOP ;
2566:
2567: fnd_file.put_line(fnd_file.output,'Total Number of Events Dequeued : '||l_dq_count );
2568:
2569:
2570: EXCEPTION
2571: WHEN others THEN

Line 2574: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);

2570: EXCEPTION
2571: WHEN others THEN
2572: p_return_code := sqlcode ;
2573: p_error_description := sqlerrm ;
2574: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2575: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2576:
2577: END DQ_XNP_EVT_Q ;
2578:

Line 2575: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);

2571: WHEN others THEN
2572: p_return_code := sqlcode ;
2573: p_error_description := sqlerrm ;
2574: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2575: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2576:
2577: END DQ_XNP_EVT_Q ;
2578:
2579: /*

Line 2611: fnd_file.put_line(fnd_file.output,'Total Number of Messages Dequeued : '||l_dq_count );

2607: DBMS_LOCK.SLEEP(g_sleep_time);
2608:
2609: END LOOP ;
2610:
2611: fnd_file.put_line(fnd_file.output,'Total Number of Messages Dequeued : '||l_dq_count );
2612:
2613:
2614: EXCEPTION
2615: WHEN others THEN

Line 2618: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);

2614: EXCEPTION
2615: WHEN others THEN
2616: p_return_code := sqlcode ;
2617: p_error_description := sqlerrm ;
2618: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2619: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2620:
2621: END DQ_XNP_IN_MSG_Q ;
2622:

Line 2619: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);

2615: WHEN others THEN
2616: p_return_code := sqlcode ;
2617: p_error_description := sqlerrm ;
2618: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2619: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2620:
2621: END DQ_XNP_IN_MSG_Q ;
2622:
2623: /*

Line 2654: fnd_file.put_line(fnd_file.output,'Total Number of Timers Dequeued: '||l_dq_count );

2650: l_dq_count := l_dq_count + 1 ;
2651: DBMS_LOCK.SLEEP(g_sleep_time);
2652:
2653: END LOOP ;
2654: fnd_file.put_line(fnd_file.output,'Total Number of Timers Dequeued: '||l_dq_count );
2655:
2656: EXCEPTION
2657: WHEN others THEN
2658: p_return_code := sqlcode ;

Line 2660: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);

2656: EXCEPTION
2657: WHEN others THEN
2658: p_return_code := sqlcode ;
2659: p_error_description := sqlerrm ;
2660: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2661: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2662:
2663: END DQ_XNP_IN_TMR_Q ;
2664:

Line 2661: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);

2657: WHEN others THEN
2658: p_return_code := sqlcode ;
2659: p_error_description := sqlerrm ;
2660: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2661: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2662:
2663: END DQ_XNP_IN_TMR_Q ;
2664:
2665: /*

Line 2696: fnd_file.put_line(fnd_file.output,'Total Number of Orders Dequeued : '||l_dq_count );

2692: l_dq_count := l_dq_count + 1 ;
2693: DBMS_LOCK.SLEEP(g_sleep_time);
2694:
2695: END LOOP ;
2696: fnd_file.put_line(fnd_file.output,'Total Number of Orders Dequeued : '||l_dq_count );
2697:
2698: EXCEPTION
2699: WHEN others THEN
2700: p_return_code := sqlcode ;

Line 2702: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);

2698: EXCEPTION
2699: WHEN others THEN
2700: p_return_code := sqlcode ;
2701: p_error_description := sqlerrm ;
2702: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2703: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2704:
2705: END DQ_XDP_ORDER_PROC_QUEUE;
2706:

Line 2703: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);

2699: WHEN others THEN
2700: p_return_code := sqlcode ;
2701: p_error_description := sqlerrm ;
2702: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2703: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2704:
2705: END DQ_XDP_ORDER_PROC_QUEUE;
2706:
2707: /*

Line 2738: fnd_file.put_line(fnd_file.output,'Total Number of Fulfillment Actions Dequeued : '||l_dq_count );

2734: l_dq_count := l_dq_count + 1 ;
2735: DBMS_LOCK.SLEEP(g_sleep_time);
2736:
2737: END LOOP ;
2738: fnd_file.put_line(fnd_file.output,'Total Number of Fulfillment Actions Dequeued : '||l_dq_count );
2739:
2740: EXCEPTION
2741: WHEN others THEN
2742: p_return_code := sqlcode ;

Line 2744: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);

2740: EXCEPTION
2741: WHEN others THEN
2742: p_return_code := sqlcode ;
2743: p_error_description := sqlerrm ;
2744: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2745: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2746:
2747: END DQ_XDP_FA_QUEUE;
2748:

Line 2745: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);

2741: WHEN others THEN
2742: p_return_code := sqlcode ;
2743: p_error_description := sqlerrm ;
2744: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2745: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2746:
2747: END DQ_XDP_FA_QUEUE;
2748:
2749: /*

Line 2782: fnd_file.put_line(fnd_file.output,'Total Number FulFillment Element Ready Queue Dequeued : '||l_dq_count );

2778: l_dq_count := l_dq_count + 1 ;
2779: DBMS_LOCK.SLEEP(g_sleep_time);
2780:
2781: END LOOP ;
2782: fnd_file.put_line(fnd_file.output,'Total Number FulFillment Element Ready Queue Dequeued : '||l_dq_count );
2783:
2784: EXCEPTION
2785: WHEN others THEN
2786: p_return_code := sqlcode ;

Line 2788: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);

2784: EXCEPTION
2785: WHEN others THEN
2786: p_return_code := sqlcode ;
2787: p_error_description := sqlerrm ;
2788: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2789: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2790:
2791: END DQ_XDP_WF_CHANNEL_Q;
2792:

Line 2789: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);

2785: WHEN others THEN
2786: p_return_code := sqlcode ;
2787: p_error_description := sqlerrm ;
2788: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2789: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2790:
2791: END DQ_XDP_WF_CHANNEL_Q;
2792:
2793: /*

Line 2824: fnd_file.put_line(fnd_file.output,'Total Number of Workitems Dequeued : '||l_dq_count );

2820: l_dq_count := l_dq_count + 1 ;
2821: DBMS_LOCK.SLEEP(g_sleep_time);
2822:
2823: END LOOP ;
2824: fnd_file.put_line(fnd_file.output,'Total Number of Workitems Dequeued : '||l_dq_count );
2825:
2826: EXCEPTION
2827: WHEN others THEN
2828: p_return_code := sqlcode ;

Line 2830: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);

2826: EXCEPTION
2827: WHEN others THEN
2828: p_return_code := sqlcode ;
2829: p_error_description := sqlerrm ;
2830: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2831: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2832:
2833: END DQ_XDP_WORKITEM_QUEUE;
2834:

Line 2831: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);

2827: WHEN others THEN
2828: p_return_code := sqlcode ;
2829: p_error_description := sqlerrm ;
2830: fnd_file.put_line(fnd_file.log,'Error Code : ' ||p_return_code);
2831: fnd_file.put_line(fnd_file.log,'Error Message : ' ||p_error_description);
2832:
2833: END DQ_XDP_WORKITEM_QUEUE;
2834:
2835:

Line 2860: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_ORDER_PROC_REENQ');

2856: EXCEPTION
2857: WHEN others THEN
2858: p_return_code := sqlcode ;
2859: p_error_description := sqlerrm ;
2860: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_ORDER_PROC_REENQ');
2861: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2862: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2863:
2864: END;

Line 2861: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);

2857: WHEN others THEN
2858: p_return_code := sqlcode ;
2859: p_error_description := sqlerrm ;
2860: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_ORDER_PROC_REENQ');
2861: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2862: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2863:
2864: END;
2865:

Line 2862: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);

2858: p_return_code := sqlcode ;
2859: p_error_description := sqlerrm ;
2860: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_ORDER_PROC_REENQ');
2861: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2862: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2863:
2864: END;
2865:
2866: /* Work Item */

Line 2876: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_WORKITEM_REENQ');

2872: EXCEPTION
2873: WHEN others THEN
2874: p_return_code := p_return_code ||':'|| sqlcode ;
2875: p_error_description := p_error_description ||':'|| sqlerrm ;
2876: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_WORKITEM_REENQ');
2877: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2878: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2879: END;
2880:

Line 2877: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);

2873: WHEN others THEN
2874: p_return_code := p_return_code ||':'|| sqlcode ;
2875: p_error_description := p_error_description ||':'|| sqlerrm ;
2876: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_WORKITEM_REENQ');
2877: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2878: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2879: END;
2880:
2881: /* Fulfillment Actions */

Line 2878: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);

2874: p_return_code := p_return_code ||':'|| sqlcode ;
2875: p_error_description := p_error_description ||':'|| sqlerrm ;
2876: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_WORKITEM_REENQ');
2877: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2878: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2879: END;
2880:
2881: /* Fulfillment Actions */
2882: BEGIN

Line 2891: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_FA_REENQ');

2887: EXCEPTION
2888: WHEN others THEN
2889: p_return_code := p_return_code ||':'|| sqlcode ;
2890: p_error_description := p_error_description ||':'|| sqlerrm ;
2891: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_FA_REENQ');
2892: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2893: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2894: END;
2895:

Line 2892: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);

2888: WHEN others THEN
2889: p_return_code := p_return_code ||':'|| sqlcode ;
2890: p_error_description := p_error_description ||':'|| sqlerrm ;
2891: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_FA_REENQ');
2892: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2893: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2894: END;
2895:
2896: /* Fulfillment Actions Ready */

Line 2893: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);

2889: p_return_code := p_return_code ||':'|| sqlcode ;
2890: p_error_description := p_error_description ||':'|| sqlerrm ;
2891: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_FA_REENQ');
2892: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2893: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2894: END;
2895:
2896: /* Fulfillment Actions Ready */
2897: BEGIN

Line 2906: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_WF_CHANNEL_REENQ');

2902: EXCEPTION
2903: WHEN others THEN
2904: p_return_code := p_return_code ||':'|| sqlcode ;
2905: p_error_description := p_error_description ||':'|| sqlerrm ;
2906: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_WF_CHANNEL_REENQ');
2907: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2908: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2909: END;
2910:

Line 2907: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);

2903: WHEN others THEN
2904: p_return_code := p_return_code ||':'|| sqlcode ;
2905: p_error_description := p_error_description ||':'|| sqlerrm ;
2906: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_WF_CHANNEL_REENQ');
2907: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2908: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2909: END;
2910:
2911: /* Inbound Message */

Line 2908: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);

2904: p_return_code := p_return_code ||':'|| sqlcode ;
2905: p_error_description := p_error_description ||':'|| sqlerrm ;
2906: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XDP_WF_CHANNEL_REENQ');
2907: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2908: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2909: END;
2910:
2911: /* Inbound Message */
2912: BEGIN

Line 2920: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_IN_MSG_REENQ');

2916: EXCEPTION
2917: WHEN others THEN
2918: p_return_code := p_return_code ||':'|| sqlcode ;
2919: p_error_description := p_error_description ||':'|| sqlerrm ;
2920: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_IN_MSG_REENQ');
2921: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2922: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2923: END;
2924:

Line 2921: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);

2917: WHEN others THEN
2918: p_return_code := p_return_code ||':'|| sqlcode ;
2919: p_error_description := p_error_description ||':'|| sqlerrm ;
2920: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_IN_MSG_REENQ');
2921: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2922: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2923: END;
2924:
2925: /* Internal Event */

Line 2922: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);

2918: p_return_code := p_return_code ||':'|| sqlcode ;
2919: p_error_description := p_error_description ||':'|| sqlerrm ;
2920: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_IN_MSG_REENQ');
2921: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2922: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2923: END;
2924:
2925: /* Internal Event */
2926: BEGIN

Line 2934: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_IN_EVT_REENQ');

2930: EXCEPTION
2931: WHEN others THEN
2932: p_return_code := p_return_code ||':'|| sqlcode ;
2933: p_error_description := p_error_description ||':'|| sqlerrm ;
2934: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_IN_EVT_REENQ');
2935: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2936: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2937: END;
2938:

Line 2935: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);

2931: WHEN others THEN
2932: p_return_code := p_return_code ||':'|| sqlcode ;
2933: p_error_description := p_error_description ||':'|| sqlerrm ;
2934: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_IN_EVT_REENQ');
2935: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2936: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2937: END;
2938:
2939: /* Timer */

Line 2936: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);

2932: p_return_code := p_return_code ||':'|| sqlcode ;
2933: p_error_description := p_error_description ||':'|| sqlerrm ;
2934: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_IN_EVT_REENQ');
2935: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2936: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2937: END;
2938:
2939: /* Timer */
2940: BEGIN

Line 2948: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_IN_TMR_REENQ');

2944: EXCEPTION
2945: WHEN others THEN
2946: p_return_code := p_return_code ||':'|| sqlcode ;
2947: p_error_description := p_error_description ||':'|| sqlerrm ;
2948: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_IN_TMR_REENQ');
2949: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2950: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2951: END;
2952:

Line 2949: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);

2945: WHEN others THEN
2946: p_return_code := p_return_code ||':'|| sqlcode ;
2947: p_error_description := p_error_description ||':'|| sqlerrm ;
2948: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_IN_TMR_REENQ');
2949: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2950: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2951: END;
2952:
2953: /* Outbound */

Line 2950: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);

2946: p_return_code := p_return_code ||':'|| sqlcode ;
2947: p_error_description := p_error_description ||':'|| sqlerrm ;
2948: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_IN_TMR_REENQ');
2949: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2950: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2951: END;
2952:
2953: /* Outbound */
2954: BEGIN

Line 2962: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_OUT_MSG_REENQ');

2958: EXCEPTION
2959: WHEN others THEN
2960: p_return_code := p_return_code ||':'|| sqlcode ;
2961: p_error_description := p_error_description ||':'|| sqlerrm ;
2962: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_OUT_MSG_REENQ');
2963: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2964: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2965: END;
2966:

Line 2963: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);

2959: WHEN others THEN
2960: p_return_code := p_return_code ||':'|| sqlcode ;
2961: p_error_description := p_error_description ||':'|| sqlerrm ;
2962: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_OUT_MSG_REENQ');
2963: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2964: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2965: END;
2966:
2967: END DQ_EXCP_REENQ;

Line 2964: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);

2960: p_return_code := p_return_code ||':'|| sqlcode ;
2961: p_error_description := p_error_description ||':'|| sqlerrm ;
2962: fnd_file.put_line(fnd_file.log,'Error in DQ_EXCP_REENQ: DQ_XNP_OUT_MSG_REENQ');
2963: fnd_file.put_line(fnd_file.log,'Error Code : ' ||sqlcode);
2964: fnd_file.put_line(fnd_file.log,'Error Message : ' ||sqlerrm);
2965: END;
2966:
2967: END DQ_EXCP_REENQ;
2968:

Line 3027: fnd_file.put_line(fnd_file.output,'Total Number of Orders Dequeued from Order Exception Queue : '||l_dq_count );

3023: l_dq_count := l_dq_count + 1 ;
3024: DBMS_LOCK.SLEEP(g_sleep_time);
3025:
3026: END LOOP ;
3027: fnd_file.put_line(fnd_file.output,'Total Number of Orders Dequeued from Order Exception Queue : '||l_dq_count );
3028:
3029: EXCEPTION
3030: WHEN OTHERS THEN
3031: ROLLBACK TO order_q_tag;

Line 3093: fnd_file.put_line(fnd_file.log, 'Could not ReEnqueue Fulfillment Action - Error: ' ||lv_error_description);

3089: p_return_code => lv_return_code ,
3090: p_error_description => lv_error_description );
3091:
3092: IF( lv_return_code <> 0 ) THEN
3093: fnd_file.put_line(fnd_file.log, 'Could not ReEnqueue Fulfillment Action - Error: ' ||lv_error_description);
3094: ROLLBACK TO fa_q_tag;
3095: RETURN;
3096: END IF;
3097:

Line 3103: fnd_file.put_line(fnd_file.output,'Total Number of Fulfillment Actions Dequeued from Fulfillment Actions Exception Queue : '||l_dq_count );

3099: l_dq_count := l_dq_count + 1 ;
3100: DBMS_LOCK.SLEEP(g_sleep_time);
3101:
3102: END LOOP ;
3103: fnd_file.put_line(fnd_file.output,'Total Number of Fulfillment Actions Dequeued from Fulfillment Actions Exception Queue : '||l_dq_count );
3104:
3105: EXCEPTION
3106: WHEN OTHERS THEN
3107: ROLLBACK TO fa_q_tag;

Line 3169: fnd_file.put_line(fnd_file.log, 'Could not ReEnqueue WorkItem - Error: ' ||lv_error_description);

3165: p_return_code => lv_return_code ,
3166: p_error_description => lv_error_description );
3167:
3168: IF( lv_return_code <> 0 ) THEN
3169: fnd_file.put_line(fnd_file.log, 'Could not ReEnqueue WorkItem - Error: ' ||lv_error_description);
3170: ROLLBACK TO workitem_q_tag;
3171: RETURN;
3172: END IF;
3173:

Line 3179: fnd_file.put_line(fnd_file.output,'Total Number of WorkItems dequeued from WorkItem Exception Queue : '||l_dq_count );

3175: l_dq_count := l_dq_count + 1 ;
3176: DBMS_LOCK.SLEEP(g_sleep_time);
3177:
3178: END LOOP ;
3179: fnd_file.put_line(fnd_file.output,'Total Number of WorkItems dequeued from WorkItem Exception Queue : '||l_dq_count );
3180:
3181: EXCEPTION
3182: WHEN OTHERS THEN
3183: ROLLBACK TO workitem_q_tag;

Line 3202: fnd_file.put_line(fnd_file.log,'Could not get the provisioning date for WorkItem Instance Id');

3198: WHERE workitem_instance_id = p_workitem_instance_id ;
3199: RETURN l_prov_date;
3200: EXCEPTION
3201: WHEN OTHERS THEN
3202: fnd_file.put_line(fnd_file.log,'Could not get the provisioning date for WorkItem Instance Id');
3203: RAISE;
3204:
3205: END GetWIProvisioningDate ;
3206:

Line 3264: fnd_file.put_line(fnd_file.log, 'Could not ReEnqueue from FE Ready - Error: ' ||lv_error_description);

3260: p_return_code => lv_return_code ,
3261: p_error_description => lv_error_description );
3262:
3263: IF( lv_return_code <> 0 ) THEN
3264: fnd_file.put_line(fnd_file.log, 'Could not ReEnqueue from FE Ready - Error: ' ||lv_error_description);
3265: ROLLBACK TO resume_wf;
3266: RETURN;
3267: END IF;
3268:

Line 3274: fnd_file.put_line(fnd_file.output,'Total Number dequeued from FE Ready Exception Queue : '||l_dq_count );

3270: l_dq_count := l_dq_count + 1 ;
3271: DBMS_LOCK.SLEEP(g_sleep_time);
3272:
3273: END LOOP ;
3274: fnd_file.put_line(fnd_file.output,'Total Number dequeued from FE Ready Exception Queue : '||l_dq_count );
3275:
3276: EXCEPTION
3277: WHEN OTHERS THEN
3278: ROLLBACK TO resume_wf;

Line 3337: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Inbound Messages Exception Queue : '||l_dq_count );

3333: DBMS_LOCK.SLEEP(g_sleep_time);
3334:
3335: END LOOP ;
3336:
3337: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Inbound Messages Exception Queue : '||l_dq_count );
3338:
3339: EXCEPTION
3340: WHEN OTHERS THEN
3341: fnd_file.put_line(fnd_file.output,' Could not Re-enqueue from Inbound Messages Exception Queue: '||SQLCODE||':'||SQLERRM);

Line 3341: fnd_file.put_line(fnd_file.output,' Could not Re-enqueue from Inbound Messages Exception Queue: '||SQLCODE||':'||SQLERRM);

3337: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Inbound Messages Exception Queue : '||l_dq_count );
3338:
3339: EXCEPTION
3340: WHEN OTHERS THEN
3341: fnd_file.put_line(fnd_file.output,' Could not Re-enqueue from Inbound Messages Exception Queue: '||SQLCODE||':'||SQLERRM);
3342: ROLLBACK TO before_msg_pop;
3343: RAISE;
3344:
3345: END DQ_XNP_IN_MSG_REENQ;

Line 3399: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Events Exception Queue : '||l_dq_count );

3395: l_dq_count := l_dq_count + 1 ;
3396: DBMS_LOCK.SLEEP(g_sleep_time);
3397:
3398: END LOOP ;
3399: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Events Exception Queue : '||l_dq_count );
3400:
3401: EXCEPTION
3402: WHEN OTHERS THEN
3403: fnd_file.put_line(fnd_file.output,' Could not Re-enqueue from Events Exception Queue: '||SQLCODE||':'||SQLERRM);

Line 3403: fnd_file.put_line(fnd_file.output,' Could not Re-enqueue from Events Exception Queue: '||SQLCODE||':'||SQLERRM);

3399: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Events Exception Queue : '||l_dq_count );
3400:
3401: EXCEPTION
3402: WHEN OTHERS THEN
3403: fnd_file.put_line(fnd_file.output,' Could not Re-enqueue from Events Exception Queue: '||SQLCODE||':'||SQLERRM);
3404: ROLLBACK TO before_evt_pop;
3405: RAISE;
3406:
3407: END DQ_XNP_IN_EVT_REENQ;

Line 3461: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Timer Exception Queue : '||l_dq_count );

3457: l_dq_count := l_dq_count + 1 ;
3458: DBMS_LOCK.SLEEP(g_sleep_time);
3459:
3460: END LOOP ;
3461: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Timer Exception Queue : '||l_dq_count );
3462:
3463: EXCEPTION
3464: WHEN OTHERS THEN
3465: fnd_file.put_line(fnd_file.output,' Could not Re-enqueue from Timer Exception Queue: '||SQLCODE||':'||SQLERRM);

Line 3465: fnd_file.put_line(fnd_file.output,' Could not Re-enqueue from Timer Exception Queue: '||SQLCODE||':'||SQLERRM);

3461: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Timer Exception Queue : '||l_dq_count );
3462:
3463: EXCEPTION
3464: WHEN OTHERS THEN
3465: fnd_file.put_line(fnd_file.output,' Could not Re-enqueue from Timer Exception Queue: '||SQLCODE||':'||SQLERRM);
3466: ROLLBACK TO before_tmr_pop;
3467: RAISE;
3468:
3469: END DQ_XNP_IN_TMR_REENQ;

Line 3565: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Outbound Msg Exception Queue : '||l_dq_count );

3561: DBMS_LOCK.SLEEP(g_sleep_time);
3562:
3563: END LOOP ;
3564:
3565: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Outbound Msg Exception Queue : '||l_dq_count );
3566:
3567: EXCEPTION
3568: WHEN OTHERS THEN
3569: fnd_file.put_line(fnd_file.output,'Could not Re-enqueue from Outbound Msg Exception Queue: '||SQLCODE||':'||SQLERRM);

Line 3569: fnd_file.put_line(fnd_file.output,'Could not Re-enqueue from Outbound Msg Exception Queue: '||SQLCODE||':'||SQLERRM);

3565: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Outbound Msg Exception Queue : '||l_dq_count );
3566:
3567: EXCEPTION
3568: WHEN OTHERS THEN
3569: fnd_file.put_line(fnd_file.output,'Could not Re-enqueue from Outbound Msg Exception Queue: '||SQLCODE||':'||SQLERRM);
3570: ROLLBACK TO before_out_msg_pop;
3571: RAISE;
3572:
3573: END DQ_XNP_OUT_MSG_REENQ;

Line 3707: fnd_file.put_line(fnd_file.log,

3703:
3704: BEGIN
3705: IF IS_AVAILABLE(object_id, object_key) = false THEN
3706: COMMIT;
3707: fnd_file.put_line(fnd_file.log,
3708: 'SET_CONTEXT: Do not process further for '||object_key||' '||object_id);
3709: RAISE stop_processing;
3710: END IF;
3711:

Line 3869: fnd_file.put_names('XDPAQUTB'||to_char(g_logdate, 'YYYYMMDDHHMISS')||'.log',

3865: WHERE name = 'utl_file_dir';
3866:
3867: select sysdate into g_logdate from dual;
3868:
3869: fnd_file.put_names('XDPAQUTB'||to_char(g_logdate, 'YYYYMMDDHHMISS')||'.log',
3870: 'XDPAQUTB'||to_char(g_logdate, 'YYYYMMDDHHMISS')||'.out',
3871: g_logdir);
3872: END IF;
3873: