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 1869: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1865: return l_total_new_line_amt;
1866:
1867: EXCEPTION
1868: WHEN OTHERS THEN
1869: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1870: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1871: g_module_prefix,
1872: x_progress || ':unexpected error' || Sqlerrm);
1873: END IF;

Line 1870: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1866:
1867: EXCEPTION
1868: WHEN OTHERS THEN
1869: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1870: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1871: g_module_prefix,
1872: x_progress || ':unexpected error' || Sqlerrm);
1873: END IF;
1874: raise;

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

2124: log_message('SHIP_AMOUNT_WITHIN_TOL','Result',resultout);
2125: END IF; -- IF ( funcmode = 'RUN' )
2126: EXCEPTION
2127: WHEN OTHERS THEN
2128: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2129: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2130: g_module_prefix,
2131: x_progress || ':unexpected error' || Sqlerrm);
2132: END IF;

Line 2129: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2125: END IF; -- IF ( funcmode = 'RUN' )
2126: EXCEPTION
2127: WHEN OTHERS THEN
2128: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2129: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2130: g_module_prefix,
2131: x_progress || ':unexpected error' || Sqlerrm);
2132: END IF;
2133: wf_core.context('POSCHORD', 'SHIP_AMOUNT_WITHIN_TOL', itemtype, itemkey, to_char(actid),funcmode);

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

2361: return l_new_ship_amt;
2362:
2363: EXCEPTION
2364: WHEN OTHERS THEN
2365: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2366: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2367: g_module_prefix,
2368: x_progress || ':unexpected error' || Sqlerrm);
2369: END IF;

Line 2366: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2362:
2363: EXCEPTION
2364: WHEN OTHERS THEN
2365: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2366: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2367: g_module_prefix,
2368: x_progress || ':unexpected error' || Sqlerrm);
2369: END IF;
2370: raise;

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

2434: return TRUE;
2435:
2436: EXCEPTION
2437: WHEN OTHERS THEN
2438: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2439: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2440: g_module_prefix,
2441: x_progress || ':unexpected error' || Sqlerrm);
2442: END IF;

Line 2439: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2435:
2436: EXCEPTION
2437: WHEN OTHERS THEN
2438: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2439: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2440: g_module_prefix,
2441: x_progress || ':unexpected error' || Sqlerrm);
2442: END IF;
2443: raise;

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

2485:
2486: return TRUE;
2487: EXCEPTION
2488: WHEN OTHERS THEN
2489: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2490: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2491: g_module_prefix,
2492: x_progress || ':unexpected error' || Sqlerrm);
2493: END IF;

Line 2490: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2486: return TRUE;
2487: EXCEPTION
2488: WHEN OTHERS THEN
2489: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2490: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2491: g_module_prefix,
2492: x_progress || ':unexpected error' || Sqlerrm);
2493: END IF;
2494: raise;

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

2578: x_progress := 'ROUTE_TO_REQUESTER:005';
2579: log_message('ROUTE_TO_REQUESTER','Result',resultout);
2580: EXCEPTION
2581: WHEN OTHERS THEN
2582: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2583: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2584: g_module_prefix,
2585: x_progress || ':unexpected error' || Sqlerrm);
2586: END IF;

Line 2583: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2579: log_message('ROUTE_TO_REQUESTER','Result',resultout);
2580: EXCEPTION
2581: WHEN OTHERS THEN
2582: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2583: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2584: g_module_prefix,
2585: x_progress || ':unexpected error' || Sqlerrm);
2586: END IF;
2587: wf_core.context('POSCHORD', 'ROUTE_TO_REQUESTER', itemtype, itemkey, to_char(actid),funcmode);

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

2730: END IF;
2731:
2732: EXCEPTION
2733: WHEN OTHERS THEN
2734: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2735: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2736: g_module_prefix,
2737: x_progress || ':unexpected error' || Sqlerrm);
2738: END IF;

Line 2735: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2731:
2732: EXCEPTION
2733: WHEN OTHERS THEN
2734: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2735: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2736: g_module_prefix,
2737: x_progress || ':unexpected error' || Sqlerrm);
2738: END IF;
2739: raise;

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

2877:
2878:
2879: EXCEPTION
2880: WHEN OTHERS THEN
2881: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2882: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2883: g_module_prefix,
2884: x_progress || ':unexpected error' || Sqlerrm);
2885: END IF;

Line 2882: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2878:
2879: EXCEPTION
2880: WHEN OTHERS THEN
2881: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2882: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2883: g_module_prefix,
2884: x_progress || ':unexpected error' || Sqlerrm);
2885: END IF;
2886: wf_core.context('POSCHORD', 'ROUTE_SCO_BIZ_RULES', itemtype, itemkey, to_char(actid),funcmode);

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

2964: log_message('AUTO_APP_BIZ_RULES','Result',resultout);
2965:
2966: EXCEPTION
2967: WHEN OTHERS THEN
2968: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2969: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2970: g_module_prefix,
2971: x_progress || ':unexpected error' || Sqlerrm);
2972: END IF;

Line 2969: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

2965:
2966: EXCEPTION
2967: WHEN OTHERS THEN
2968: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2969: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
2970: g_module_prefix,
2971: x_progress || ':unexpected error' || Sqlerrm);
2972: END IF;
2973: wf_core.context('POSCHORD', 'AUTO_APP_BIZ_RULES', itemtype, itemkey, to_char(actid),funcmode);

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

3277: END IF; -- IF p_doc_type = PO or RELEASE
3278:
3279: EXCEPTION
3280: WHEN OTHERS THEN
3281: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3283: g_module_prefix,
3284: x_progress || ':unexpected error' || Sqlerrm);
3285: END IF;

Line 3282: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

3278:
3279: EXCEPTION
3280: WHEN OTHERS THEN
3281: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3283: g_module_prefix,
3284: x_progress || ':unexpected error' || Sqlerrm);
3285: END IF;
3286: raise;

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

3637: END IF; -- If po_doc_type = PO or RELEASE
3638:
3639: EXCEPTION
3640: WHEN OTHERS THEN
3641: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3642: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3643: g_module_prefix,
3644: x_progress || ':unexpected error' || Sqlerrm);
3645: END IF;

Line 3642: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

3638:
3639: EXCEPTION
3640: WHEN OTHERS THEN
3641: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3642: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3643: g_module_prefix,
3644: x_progress || ':unexpected error' || Sqlerrm);
3645: END IF;
3646: raise;

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

3689: WHEN OTHERS THEN
3690: -- The line below records this function call INthe error
3691: -- system INthe case of an exception.
3692:
3693: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3694: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3695: g_module_prefix,
3696: x_progress || ':unexpected error' || Sqlerrm);
3697: END IF;

Line 3694: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

3690: -- The line below records this function call INthe error
3691: -- system INthe case of an exception.
3692:
3693: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3694: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3695: g_module_prefix,
3696: x_progress || ':unexpected error' || Sqlerrm);
3697: END IF;
3698:

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

3814: x_progress:='PROMISEDATECHANGE:004';
3815: return l_only_promised_date_change;
3816: exception
3817: when others THEN
3818: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3819: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3820: g_module_prefix,
3821: x_progress || ':unexpected error' || Sqlerrm);
3822: END IF;

Line 3819: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

3815: return l_only_promised_date_change;
3816: exception
3817: when others THEN
3818: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3819: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3820: g_module_prefix,
3821: x_progress || ':unexpected error' || Sqlerrm);
3822: END IF;
3823: raise;

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

3864: EXCEPTION
3865:
3866: when others THEN
3867:
3868: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3869: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3870: g_module_prefix,
3871: x_progress || ':unexpected error' || Sqlerrm);
3872: END IF;

Line 3869: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

3865:
3866: when others THEN
3867:
3868: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3869: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
3870: g_module_prefix,
3871: x_progress || ':unexpected error' || Sqlerrm);
3872: END IF;
3873: wf_core.context('POSCHORD', 'INITIATE_RCO_FLOW', itemtype, itemkey, to_char(actid), funcmode);

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

4171: x_retMsg ,
4172: x_errTable);
4173:
4174: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
4175: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4177: g_module_prefix,
4178: x_progress
4179: || 'x_return_status=' || x_return_status

Line 4176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4172: x_errTable);
4173:
4174: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
4175: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4177: g_module_prefix,
4178: x_progress
4179: || 'x_return_status=' || x_return_status
4180: || 'x_change_group_id = '|| x_change_group_id);

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

4180: || 'x_change_group_id = '|| x_change_group_id);
4181: END IF;
4182:
4183: ELSE
4184: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4185: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4186: g_module_prefix,
4187: x_progress
4188: ||'x_return_status = ' || x_return_status

Line 4185: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

4181: END IF;
4182:
4183: ELSE
4184: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4185: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4186: g_module_prefix,
4187: x_progress
4188: ||'x_return_status = ' || x_return_status
4189: ||'x_retMsg = ' || x_retMsg);

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

4200:
4201: Exception
4202:
4203: when others THEN
4204: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4205: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4206: g_module_prefix,
4207: x_progress || ':unexpected error' || Sqlerrm);
4208: END IF;

Line 4205: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

4201: Exception
4202:
4203: when others THEN
4204: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4205: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4206: g_module_prefix,
4207: x_progress || ':unexpected error' || Sqlerrm);
4208: END IF;
4209:

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

4248:
4249: exception
4250: when others THEN
4251:
4252: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4253: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4254: g_module_prefix,
4255: x_progress || ':unexpected error' || Sqlerrm);
4256: END IF;

Line 4253: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

4249: exception
4250: when others THEN
4251:
4252: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4253: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4254: g_module_prefix,
4255: x_progress || ':unexpected error' || Sqlerrm);
4256: END IF;
4257:

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

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

Line 4302: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

4305: || ' x_return_status=' || x_return_status);
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 4326: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4322:
4323: Exception
4324:
4325: when others THEN
4326: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4327: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4328: g_module_prefix,
4329: x_progress || ':unexpected error' || Sqlerrm);
4330: END IF;

Line 4327: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

4323: Exception
4324:
4325: when others THEN
4326: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4327: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4328: g_module_prefix,
4329: x_progress || ':unexpected error' || Sqlerrm);
4330: END IF;
4331:

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

4460: exception
4461:
4462: when others THEN
4463:
4464: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4465: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4466: g_module_prefix,
4467: x_progress || ':unexpected error' || Sqlerrm);
4468: END IF;

Line 4465: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

4461:
4462: when others THEN
4463:
4464: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4465: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
4466: g_module_prefix,
4467: x_progress || ':unexpected error' || Sqlerrm);
4468: END IF;
4469: wf_core.context('POSCHORD', 'MARK_SCO_FOR_REQ', itemtype, itemkey, to_char(actid), funcmode);