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.POS_SCO_TOLERANCE_PVT dependencies on FND_LOG

Line 18: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

14:
15: IS
16: BEGIN
17:
18: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
19: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
20: 'POS_SCO_TOLERANCE_PVT',
21: p_proc_name || ': '
22: || p_text || ': '

Line 19: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

15: IS
16: BEGIN
17:
18: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
19: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
20: 'POS_SCO_TOLERANCE_PVT',
21: p_proc_name || ': '
22: || p_text || ': '
23: || p_log_data);

Line 100: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

96: x_msg_data VARCHAR2(2000);
97: x_progress VARCHAR2(1000);
98: BEGIN
99:
100: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
101: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
102: g_module_prefix,
103: 'Enter Initialize Tol Proc'
104: );

Line 101: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

97: x_progress VARCHAR2(1000);
98: BEGIN
99:
100: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
101: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
102: g_module_prefix,
103: 'Enter Initialize Tol Proc'
104: );
105: END IF;

Line 205: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

201: x_msg_count,
202: x_msg_data);
203:
204: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
205: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
206: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
207: g_module_prefix,
208: x_progress
209: || 'x_return_status=' || x_return_status);

Line 206: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

202: x_msg_data);
203:
204: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
205: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
206: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
207: g_module_prefix,
208: x_progress
209: || 'x_return_status=' || x_return_status);
210: END IF;

Line 213: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

209: || 'x_return_status=' || x_return_status);
210: END IF;
211:
212: ELSE
213: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
214: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
215: g_module_prefix,
216: x_progress
217: ||'x_return_status = ' || x_return_status

Line 214: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

210: END IF;
211:
212: ELSE
213: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
214: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
215: g_module_prefix,
216: x_progress
217: ||'x_return_status = ' || x_return_status
218: ||'x_msg_count = ' || x_msg_count

Line 467: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

463: END IF;
464:
465: EXCEPTION
466: WHEN OTHERS THEN
467: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
468: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
469: g_module_prefix,
470: x_progress || ':unexpected error' || Sqlerrm);
471: END IF;

Line 468: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

464:
465: EXCEPTION
466: WHEN OTHERS THEN
467: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
468: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
469: g_module_prefix,
470: x_progress || ':unexpected error' || Sqlerrm);
471: END IF;
472: wf_core.context('POSCHORD', 'INITIALIZE_TOL_VALUES', itemtype, itemkey, to_char(actid),funcmode);

Line 609: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

605:
606:
607: EXCEPTION
608: WHEN OTHERS THEN
609: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
610: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
611: g_module_prefix,
612: x_progress || ':unexpected error' || Sqlerrm);
613: END IF;

Line 610: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

606:
607: EXCEPTION
608: WHEN OTHERS THEN
609: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
610: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
611: g_module_prefix,
612: x_progress || ':unexpected error' || Sqlerrm);
613: END IF;
614: wf_core.context('POSCHORD', 'PROMISE_DATE_WITHIN_TOL', itemtype, itemkey, to_char(actid),funcmode);

Line 805: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

801:
802: EXCEPTION
803: WHEN OTHERS THEN
804:
805: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
806: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
807: g_module_prefix,
808: x_progress || ':unexpected error' || Sqlerrm);
809: END IF;

Line 806: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

802: EXCEPTION
803: WHEN OTHERS THEN
804:
805: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
806: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
807: g_module_prefix,
808: x_progress || ':unexpected error' || Sqlerrm);
809: END IF;
810:

Line 928: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

924: END IF; -- IF ( funcmode = 'RUN' )
925:
926: EXCEPTION
927: WHEN OTHERS THEN
928: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
929: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
930: g_module_prefix,
931: x_progress || ':unexpected error' || Sqlerrm);
932: END IF;

Line 929: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

925:
926: EXCEPTION
927: WHEN OTHERS THEN
928: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
929: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
930: g_module_prefix,
931: x_progress || ':unexpected error' || Sqlerrm);
932: END IF;
933: wf_core.context('POSCHORD', 'SHIP_QUANTITY_WITHIN_TOL', itemtype, itemkey, to_char(actid),funcmode);

Line 1147: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1143: END IF; -- IF ( funcmode = 'RUN' )
1144:
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1149: g_module_prefix,
1150: x_progress || ':unexpected error' || Sqlerrm);
1151: END IF;

Line 1148: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1144:
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1149: g_module_prefix,
1150: x_progress || ':unexpected error' || Sqlerrm);
1151: END IF;
1152: wf_core.context('POSCHORD', 'DOC_AMOUNT_WITHIN_TOL', itemtype, itemkey, to_char(actid),funcmode);

Line 1367: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1363: return l_total_new_doc_amt;
1364:
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1368: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1369: g_module_prefix,
1370: x_progress || ':unexpected error' || Sqlerrm);
1371: END IF;

Line 1368: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1364:
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1368: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1369: g_module_prefix,
1370: x_progress || ':unexpected error' || Sqlerrm);
1371: END IF;
1372: raise;

Line 1628: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1624: END IF; -- IF ( funcmode = 'RUN' )
1625:
1626: EXCEPTION
1627: WHEN OTHERS THEN
1628: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1629: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1630: g_module_prefix,
1631: x_progress || ':unexpected error' || Sqlerrm);
1632: END IF;

Line 1629: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1625:
1626: EXCEPTION
1627: WHEN OTHERS THEN
1628: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1629: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1630: g_module_prefix,
1631: x_progress || ':unexpected error' || Sqlerrm);
1632: END IF;
1633: wf_core.context('POSCHORD', 'LINE_AMOUNT_WITHIN_TOL', itemtype, itemkey, to_char(actid),funcmode);

Line 1878: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1874: return l_total_new_line_amt;
1875:
1876: EXCEPTION
1877: WHEN OTHERS THEN
1878: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1879: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1880: g_module_prefix,
1881: x_progress || ':unexpected error' || Sqlerrm);
1882: END IF;

Line 1879: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1875:
1876: EXCEPTION
1877: WHEN OTHERS THEN
1878: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1879: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1880: g_module_prefix,
1881: x_progress || ':unexpected error' || Sqlerrm);
1882: END IF;
1883: raise;

Line 2137: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2133: log_message('SHIP_AMOUNT_WITHIN_TOL','Result',resultout);
2134: END IF; -- IF ( funcmode = 'RUN' )
2135: EXCEPTION
2136: WHEN OTHERS THEN
2137: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2138: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2139: g_module_prefix,
2140: x_progress || ':unexpected error' || Sqlerrm);
2141: END IF;

Line 2138: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2134: END IF; -- IF ( funcmode = 'RUN' )
2135: EXCEPTION
2136: WHEN OTHERS THEN
2137: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2138: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2139: g_module_prefix,
2140: x_progress || ':unexpected error' || Sqlerrm);
2141: END IF;
2142: wf_core.context('POSCHORD', 'SHIP_AMOUNT_WITHIN_TOL', itemtype, itemkey, to_char(actid),funcmode);

Line 2384: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2380: return l_new_ship_amt;
2381:
2382: EXCEPTION
2383: WHEN OTHERS THEN
2384: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2385: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2386: g_module_prefix,
2387: x_progress || ':unexpected error' || Sqlerrm);
2388: END IF;

Line 2385: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2381:
2382: EXCEPTION
2383: WHEN OTHERS THEN
2384: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2385: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2386: g_module_prefix,
2387: x_progress || ':unexpected error' || Sqlerrm);
2388: END IF;
2389: raise;

Line 2463: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2459: return TRUE;
2460:
2461: EXCEPTION
2462: WHEN OTHERS THEN
2463: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2464: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2465: g_module_prefix,
2466: x_progress || ':unexpected error' || Sqlerrm);
2467: END IF;

Line 2464: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2460:
2461: EXCEPTION
2462: WHEN OTHERS THEN
2463: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2464: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2465: g_module_prefix,
2466: x_progress || ':unexpected error' || Sqlerrm);
2467: END IF;
2468: raise;

Line 2514: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2510:
2511: return TRUE;
2512: EXCEPTION
2513: WHEN OTHERS THEN
2514: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2515: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2516: g_module_prefix,
2517: x_progress || ':unexpected error' || Sqlerrm);
2518: END IF;

Line 2515: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2511: return TRUE;
2512: EXCEPTION
2513: WHEN OTHERS THEN
2514: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2515: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2516: g_module_prefix,
2517: x_progress || ':unexpected error' || Sqlerrm);
2518: END IF;
2519: raise;

Line 2607: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2603: x_progress := 'ROUTE_TO_REQUESTER:005';
2604: log_message('ROUTE_TO_REQUESTER','Result',resultout);
2605: EXCEPTION
2606: WHEN OTHERS THEN
2607: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2608: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2609: g_module_prefix,
2610: x_progress || ':unexpected error' || Sqlerrm);
2611: END IF;

Line 2608: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2604: log_message('ROUTE_TO_REQUESTER','Result',resultout);
2605: EXCEPTION
2606: WHEN OTHERS THEN
2607: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2608: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2609: g_module_prefix,
2610: x_progress || ':unexpected error' || Sqlerrm);
2611: END IF;
2612: wf_core.context('POSCHORD', 'ROUTE_TO_REQUESTER', itemtype, itemkey, to_char(actid),funcmode);

Line 2799: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2795: END IF;
2796:
2797: EXCEPTION
2798: WHEN OTHERS THEN
2799: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2800: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2801: g_module_prefix,
2802: x_progress || ':unexpected error' || Sqlerrm);
2803: END IF;

Line 2800: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2796:
2797: EXCEPTION
2798: WHEN OTHERS THEN
2799: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2800: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2801: g_module_prefix,
2802: x_progress || ':unexpected error' || Sqlerrm);
2803: END IF;
2804: raise;

Line 2946: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2942:
2943:
2944: EXCEPTION
2945: WHEN OTHERS THEN
2946: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2947: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2948: g_module_prefix,
2949: x_progress || ':unexpected error' || Sqlerrm);
2950: END IF;

Line 2947: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2943:
2944: EXCEPTION
2945: WHEN OTHERS THEN
2946: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2947: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2948: g_module_prefix,
2949: x_progress || ':unexpected error' || Sqlerrm);
2950: END IF;
2951: wf_core.context('POSCHORD', 'ROUTE_SCO_BIZ_RULES', itemtype, itemkey, to_char(actid),funcmode);

Line 3033: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3029: log_message('AUTO_APP_BIZ_RULES','Result',resultout);
3030:
3031: EXCEPTION
3032: WHEN OTHERS THEN
3033: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3034: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3035: g_module_prefix,
3036: x_progress || ':unexpected error' || Sqlerrm);
3037: END IF;

Line 3034: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

3030:
3031: EXCEPTION
3032: WHEN OTHERS THEN
3033: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3034: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3035: g_module_prefix,
3036: x_progress || ':unexpected error' || Sqlerrm);
3037: END IF;
3038: wf_core.context('POSCHORD', 'AUTO_APP_BIZ_RULES', itemtype, itemkey, to_char(actid),funcmode);

Line 3393: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3389: END IF; -- IF p_doc_type = PO or RELEASE
3390: RETURN TRUE;
3391: EXCEPTION
3392: WHEN OTHERS THEN
3393: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3394: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3395: g_module_prefix,
3396: x_progress || ':unexpected error' || Sqlerrm);
3397: END IF;

Line 3394: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

3390: RETURN TRUE;
3391: EXCEPTION
3392: WHEN OTHERS THEN
3393: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3394: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3395: g_module_prefix,
3396: x_progress || ':unexpected error' || Sqlerrm);
3397: END IF;
3398: raise;

Line 3758: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3754: END IF; -- If po_doc_type = PO or RELEASE
3755:
3756: EXCEPTION
3757: WHEN OTHERS THEN
3758: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3759: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3760: g_module_prefix,
3761: x_progress || ':unexpected error' || Sqlerrm);
3762: END IF;

Line 3759: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

3755:
3756: EXCEPTION
3757: WHEN OTHERS THEN
3758: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3759: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3760: g_module_prefix,
3761: x_progress || ':unexpected error' || Sqlerrm);
3762: END IF;
3763: raise;

Line 3810: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3806: WHEN OTHERS THEN
3807: -- The line below records this function call INthe error
3808: -- system INthe case of an exception.
3809:
3810: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3811: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3812: g_module_prefix,
3813: x_progress || ':unexpected error' || Sqlerrm);
3814: END IF;

Line 3811: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

3807: -- The line below records this function call INthe error
3808: -- system INthe case of an exception.
3809:
3810: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3811: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3812: g_module_prefix,
3813: x_progress || ':unexpected error' || Sqlerrm);
3814: END IF;
3815:

Line 3935: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3931: x_progress:='PROMISEDATECHANGE:004';
3932: return l_only_promised_date_change;
3933: exception
3934: when others THEN
3935: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3936: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3937: g_module_prefix,
3938: x_progress || ':unexpected error' || Sqlerrm);
3939: END IF;

Line 3936: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

3932: return l_only_promised_date_change;
3933: exception
3934: when others THEN
3935: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3936: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3937: g_module_prefix,
3938: x_progress || ':unexpected error' || Sqlerrm);
3939: END IF;
3940: raise;

Line 3985: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3981: EXCEPTION
3982:
3983: when others THEN
3984:
3985: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3986: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3987: g_module_prefix,
3988: x_progress || ':unexpected error' || Sqlerrm);
3989: END IF;

Line 3986: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

3982:
3983: when others THEN
3984:
3985: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3986: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3987: g_module_prefix,
3988: x_progress || ':unexpected error' || Sqlerrm);
3989: END IF;
3990: wf_core.context('POSCHORD', 'INITIATE_RCO_FLOW', itemtype, itemkey, to_char(actid), funcmode);

Line 4300: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4296: x_retMsg ,
4297: x_errTable);
4298:
4299: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
4300: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4302: g_module_prefix,
4303: x_progress
4304: || 'x_return_status=' || x_return_status

Line 4301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4297: x_errTable);
4298:
4299: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
4300: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4302: g_module_prefix,
4303: x_progress
4304: || 'x_return_status=' || x_return_status
4305: || 'x_change_group_id = '|| x_change_group_id);

Line 4309: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4305: || 'x_change_group_id = '|| x_change_group_id);
4306: END IF;
4307:
4308: ELSE
4309: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4310: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4311: g_module_prefix,
4312: x_progress
4313: ||'x_return_status = ' || x_return_status

Line 4310: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

4306: END IF;
4307:
4308: ELSE
4309: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4310: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4311: g_module_prefix,
4312: x_progress
4313: ||'x_return_status = ' || x_return_status
4314: ||'x_retMsg = ' || x_retMsg);

Line 4331: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4327: document_subtype = 'REQUISITION';
4328:
4329: if(l_ame_transaction_type is not null) then
4330:
4331: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4332: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','l_ame_transaction_type = ' ||l_ame_transaction_type);
4333: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','l_requisition_header_id = ' ||l_requisition_header_id);
4334: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','applicationId = ' ||l_application_id);
4335: END IF;

Line 4332: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','l_ame_transaction_type = ' ||l_ame_transaction_type);

4328:
4329: if(l_ame_transaction_type is not null) then
4330:
4331: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4332: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','l_ame_transaction_type = ' ||l_ame_transaction_type);
4333: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','l_requisition_header_id = ' ||l_requisition_header_id);
4334: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','applicationId = ' ||l_application_id);
4335: END IF;
4336:

Line 4333: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','l_requisition_header_id = ' ||l_requisition_header_id);

4329: if(l_ame_transaction_type is not null) then
4330:
4331: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4332: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','l_ame_transaction_type = ' ||l_ame_transaction_type);
4333: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','l_requisition_header_id = ' ||l_requisition_header_id);
4334: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','applicationId = ' ||l_application_id);
4335: END IF;
4336:
4337: ame_api2.clearAllApprovals( applicationIdIn => l_application_id,

Line 4334: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','applicationId = ' ||l_application_id);

4330:
4331: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4332: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','l_ame_transaction_type = ' ||l_ame_transaction_type);
4333: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','l_requisition_header_id = ' ||l_requisition_header_id);
4334: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'POS_SCO_TOLERANCE_PVT.INITIATERCOFLOW.invoked','applicationId = ' ||l_application_id);
4335: END IF;
4336:
4337: ame_api2.clearAllApprovals( applicationIdIn => l_application_id,
4338: transactionIdIn => l_requisition_header_id,

Line 4351: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4347:
4348: Exception
4349:
4350: when others THEN
4351: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4352: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4353: g_module_prefix,
4354: x_progress || ':unexpected error' || Sqlerrm);
4355: END IF;

Line 4352: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

4348: Exception
4349:
4350: when others THEN
4351: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4352: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4353: g_module_prefix,
4354: x_progress || ':unexpected error' || Sqlerrm);
4355: END IF;
4356:

Line 4399: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4395:
4396: exception
4397: when others THEN
4398:
4399: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4400: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4401: g_module_prefix,
4402: x_progress || ':unexpected error' || Sqlerrm);
4403: END IF;

Line 4400: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

4396: exception
4397: when others THEN
4398:
4399: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4400: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4401: g_module_prefix,
4402: x_progress || ':unexpected error' || Sqlerrm);
4403: END IF;
4404:

Line 4448: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4444: x_errCode ,
4445: x_errTable );
4446:
4447: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
4448: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4450: g_module_prefix,
4451: x_progress
4452: || ' x_return_status=' || x_return_status);

Line 4449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4445: x_errTable );
4446:
4447: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
4448: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4450: g_module_prefix,
4451: x_progress
4452: || ' x_return_status=' || x_return_status);
4453: END IF;

Line 4456: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4452: || ' x_return_status=' || x_return_status);
4453: END IF;
4454:
4455: ELSE
4456: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4457: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4458: g_module_prefix,
4459: x_progress
4460: ||' x_return_status = ' || x_return_status

Line 4457: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

4453: END IF;
4454:
4455: ELSE
4456: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4457: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4458: g_module_prefix,
4459: x_progress
4460: ||' x_return_status = ' || x_return_status
4461: ||' x_retMsg = ' || x_retMsg

Line 4473: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4469:
4470: Exception
4471:
4472: when others THEN
4473: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4474: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4475: g_module_prefix,
4476: x_progress || ':unexpected error' || Sqlerrm);
4477: END IF;

Line 4474: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

4470: Exception
4471:
4472: when others THEN
4473: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4474: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4475: g_module_prefix,
4476: x_progress || ':unexpected error' || Sqlerrm);
4477: END IF;
4478:

Line 4626: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4622: exception
4623:
4624: when others THEN
4625:
4626: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4627: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4628: g_module_prefix,
4629: x_progress || ':unexpected error' || Sqlerrm);
4630: END IF;

Line 4627: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

4623:
4624: when others THEN
4625:
4626: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4627: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4628: g_module_prefix,
4629: x_progress || ':unexpected error' || Sqlerrm);
4630: END IF;
4631: wf_core.context('POSCHORD', 'MARK_SCO_FOR_REQ', itemtype, itemkey, to_char(actid), funcmode);