DBA Data[Home] [Help]

APPS.OKC_OC_INT_PUB dependencies on FND_PROFILE

Line 3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: PACKAGE BODY OKC_OC_INT_PUB AS
2: /* $Header: OKCPORDB.pls 120.1 2005/12/13 03:07:29 npalepu noship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: -------------------------------------------------------------------------------
6: --
7: -- global package structures

Line 182: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' OR

178: null;
179:
180: -- trace mode initialization turned ON
181: IF p_trace_mode = okc_api.g_true OR
182: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' OR
183: p_trace_mode = okc_oc_int_ktq_pvt.g_support THEN
184: l_trace_mode := okc_api.g_true;
185: okc_util.init_trace;
186: ELSE

Line 210: IF l_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

206: ,x_quote_id => x_quote_id
207: );
208:
209: -- trace mode initialization turned OFF
210: IF l_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
211: okc_util.stop_trace;
212: END IF;
213:
214: -- check return status

Line 400: ** FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' OR

396: ** null;
397: **
398: ** -- trace mode initialization turned ON
399: ** IF p_trace_mode = okc_api.g_true OR
400: ** FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' OR
401: ** p_trace_mode = okc_oc_int_ktq_pvt.g_support THEN
402: ** l_trace_mode := okc_api.g_true;
403: ** okc_util.init_trace;
404: ** ELSE

Line 423: ** IF l_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

419: ** ,x_msg_count => lx_msg_count
420: ** ,x_msg_data => lx_msg_data );
421: **
422: ** -- trace mode initialization turned OFF
423: ** IF l_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
424: ** okc_util.stop_trace;
425: ** END IF;
426: **
427: ** -- check return status

Line 601: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' OR

597: null;
598:
599: -- trace mode initialization turned ON
600: IF p_trace_mode = okc_api.g_true OR
601: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' OR
602: p_trace_mode = okc_oc_int_ktq_pvt.g_support THEN
603: l_trace_mode := okc_api.g_true;
604: okc_util.init_trace;
605: ELSE

Line 629: IF l_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

625: ,x_order_id => x_order_id
626: );
627:
628: -- trace mode initialization turned OFF
629: IF l_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
630: okc_util.stop_trace;
631: END IF;
632:
633: -- check return status

Line 813: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

809: null;
810:
811: -- trace mode initialization turned ON
812: IF p_trace_mode = okc_api.g_true OR
813: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
814: okc_util.init_trace;
815: END IF;
816:
817: -- call the main routine

Line 833: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

829: ,x_msg_data => lx_msg_data
830: );
831:
832: -- trace mode initialization turned OFF
833: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
834: okc_util.stop_trace;
835: END IF;
836:
837: -- check return status

Line 987: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'

983: null;
984:
985: -- trace mode initialization turned ON
986: IF p_trace_mode = okc_api.g_true OR
987: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'
988: THEN
989: l_trace_mode := okc_api.g_true;
990: okc_util.init_trace;
991: ELSE

Line 1011: IF l_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

1007: );
1008:
1009:
1010: -- trace mode initialization turned OFF
1011: IF l_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
1012: okc_util.stop_trace;
1013: END IF;
1014:
1015: -- check return status

Line 1153: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'

1149: null;
1150:
1151: -- trace mode initialization turned ON
1152: IF p_trace_mode = okc_api.g_true OR
1153: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'
1154: THEN
1155: l_trace_mode := okc_api.g_true;
1156: okc_util.init_trace;
1157: ELSE

Line 1175: IF l_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

1171: ,x_msg_data => lx_msg_data
1172: );
1173:
1174: -- trace mode initialization turned OFF
1175: IF l_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
1176: okc_util.stop_trace;
1177: END IF;
1178:
1179: -- check return status

Line 1288: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'

1284: null;
1285:
1286: -- trace mode initialization turned ON
1287: IF p_trace_mode = okc_api.g_true OR
1288: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'
1289: THEN
1290: okc_util.init_trace;
1291: END IF;
1292:

Line 1320: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

1316: ,x_msg_data => lx_msg_data
1317: );
1318:
1319: -- trace mode initialization turned OFF
1320: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
1321: okc_util.stop_trace;
1322: END IF;
1323:
1324:

Line 1429: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'

1425: null;
1426:
1427: -- trace mode initialization turned ON
1428: IF p_trace_mode = okc_api.g_true OR
1429: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'
1430: THEN
1431: okc_util.init_trace;
1432: END IF;
1433:

Line 1447: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

1443: ,x_msg_data => lx_msg_data
1444: );
1445:
1446: -- trace mode initialization turned OFF
1447: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
1448: okc_util.stop_trace;
1449: END IF;
1450:
1451:

Line 1546: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'

1542: null;
1543:
1544: -- trace mode initialization turned ON
1545: IF p_trace_mode = okc_api.g_true OR
1546: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'
1547: THEN
1548: okc_util.init_trace;
1549: END IF;
1550:

Line 1565: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

1561: ,x_msg_data => lx_msg_data
1562: );
1563:
1564: -- trace mode initialization turned OFF
1565: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
1566: okc_util.stop_trace;
1567: END IF;
1568:
1569:

Line 1671: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'

1667: null;
1668:
1669: -- trace mode initialization turned ON
1670: IF p_trace_mode = okc_api.g_true OR
1671: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'
1672: THEN
1673: okc_util.init_trace;
1674: END IF;
1675:

Line 1683: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

1679: ,p_date_signed => p_date_signed
1680: ,x_return_status => lx_return_status);
1681:
1682: -- trace mode initialization turned OFF
1683: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
1684: okc_util.stop_trace;
1685: END IF;
1686:
1687: -- check return status

Line 1770: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'

1766: null;
1767:
1768: -- trace mode initialization turned ON
1769: IF p_trace_mode = okc_api.g_true OR
1770: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'
1771: THEN
1772: okc_util.init_trace;
1773: END IF;
1774:

Line 1845: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

1841: RAISE OKC_API.G_EXCEPTION_ERROR;
1842: END IF;
1843:
1844: -- trace mode initialization turned OFF
1845: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
1846: okc_util.stop_trace;
1847: END IF;
1848:
1849: -- call AFTER user hook

Line 1944: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'

1940: null;
1941:
1942: -- trace mode initialization turned ON
1943: IF p_trace_mode = okc_api.g_true OR
1944: FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y'
1945: THEN
1946: okc_util.init_trace;
1947: END IF;
1948:

Line 1963: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN

1959: ,x_msg_data => lx_msg_data
1960: );
1961:
1962: -- trace mode initialization turned OFF
1963: IF p_trace_mode = okc_api.g_true OR FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y' THEN
1964: okc_util.stop_trace;
1965: END IF;
1966:
1967: