APPS.OKS_INSERT_ROW_UPG dependencies on OKC_DEBUG

Line 35: okc_debug.Set_Indentation('OKS_CTZ_PVT');

31:
32: BEGIN
33: x_return_status := OKC_API.G_RET_STS_SUCCESS;
34: IF (l_debug = 'Y') THEN
35: okc_debug.Set_Indentation('OKS_CTZ_PVT');
36: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
37: END IF;
38:
39: WHILE i IS NOT NULL LOOP

Line 36: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

32: BEGIN
33: x_return_status := OKC_API.G_RET_STS_SUCCESS;
34: IF (l_debug = 'Y') THEN
35: okc_debug.Set_Indentation('OKS_CTZ_PVT');
36: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
37: END IF;
38:
39: WHILE i IS NOT NULL LOOP
40:

Line 100: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

96: in_REQUEST_ID(i),
97: in_OBJECT_VERSION_NUMBER(i));
98:
99: IF (l_debug = 'Y') THEN
100: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
101: okc_debug.Reset_Indentation;
102: END IF;
103:
104: EXCEPTION

Line 101: okc_debug.Reset_Indentation;

97: in_OBJECT_VERSION_NUMBER(i));
98:
99: IF (l_debug = 'Y') THEN
100: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
101: okc_debug.Reset_Indentation;
102: END IF;
103:
104: EXCEPTION
105: WHEN OTHERS THEN

Line 107: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

103:
104: EXCEPTION
105: WHEN OTHERS THEN
106: IF (l_debug = 'Y') THEN
107: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
108: okc_debug.Reset_Indentation;
109: END IF;
110:
111: OKC_API.SET_MESSAGE(

Line 108: okc_debug.Reset_Indentation;

104: EXCEPTION
105: WHEN OTHERS THEN
106: IF (l_debug = 'Y') THEN
107: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
108: okc_debug.Reset_Indentation;
109: END IF;
110:
111: OKC_API.SET_MESSAGE(
112: p_app_name => G_APP_NAME,

Line 161: okc_debug.Set_Indentation('OKS_CVT_PVT');

157:
158: BEGIN
159: x_return_status := OKC_API.G_RET_STS_SUCCESS;
160: IF (l_debug = 'Y') THEN
161: okc_debug.Set_Indentation('OKS_CVT_PVT');
162: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
163: END IF;
164:
165: WHILE i IS NOT NULL LOOP

Line 162: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

158: BEGIN
159: x_return_status := OKC_API.G_RET_STS_SUCCESS;
160: IF (l_debug = 'Y') THEN
161: okc_debug.Set_Indentation('OKS_CVT_PVT');
162: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
163: END IF;
164:
165: WHILE i IS NOT NULL LOOP
166: j := j +1;

Line 250: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

246: in_REQUEST_ID(i),
247: in_Object_Version_Number(i));
248:
249: IF (l_debug = 'Y') THEN
250: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
251: okc_debug.Reset_Indentation;
252: END IF;
253: EXCEPTION
254: WHEN OTHERS THEN

Line 251: okc_debug.Reset_Indentation;

247: in_Object_Version_Number(i));
248:
249: IF (l_debug = 'Y') THEN
250: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
251: okc_debug.Reset_Indentation;
252: END IF;
253: EXCEPTION
254: WHEN OTHERS THEN
255: IF (l_debug = 'Y') THEN

Line 256: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

252: END IF;
253: EXCEPTION
254: WHEN OTHERS THEN
255: IF (l_debug = 'Y') THEN
256: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
257: okc_debug.Reset_Indentation;
258: END IF;
259:
260: OKC_API.SET_MESSAGE(

Line 257: okc_debug.Reset_Indentation;

253: EXCEPTION
254: WHEN OTHERS THEN
255: IF (l_debug = 'Y') THEN
256: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
257: okc_debug.Reset_Indentation;
258: END IF;
259:
260: OKC_API.SET_MESSAGE(
261: p_app_name => G_APP_NAME,

Line 307: okc_debug.Set_Indentation('OKS_ACM_PVT');

303: BEGIN
304: x_return_status := OKC_API.G_RET_STS_SUCCESS;
305:
306: IF (l_debug = 'Y') THEN
307: okc_debug.Set_Indentation('OKS_ACM_PVT');
308: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
309: END IF;
310:
311: WHILE i IS NOT NULL LOOP

Line 308: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

304: x_return_status := OKC_API.G_RET_STS_SUCCESS;
305:
306: IF (l_debug = 'Y') THEN
307: okc_debug.Set_Indentation('OKS_ACM_PVT');
308: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
309: END IF;
310:
311: WHILE i IS NOT NULL LOOP
312: j := j +1;

Line 390: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

386: in_LAST_UPDATE_DATE(i),
387: in_LAST_UPDATE_LOGIN(i));
388:
389: IF (l_debug = 'Y') THEN
390: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
391: okc_debug.Reset_Indentation;
392: END IF;
393:
394: EXCEPTION

Line 391: okc_debug.Reset_Indentation;

387: in_LAST_UPDATE_LOGIN(i));
388:
389: IF (l_debug = 'Y') THEN
390: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
391: okc_debug.Reset_Indentation;
392: END IF;
393:
394: EXCEPTION
395: WHEN OTHERS THEN

Line 397: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

393:
394: EXCEPTION
395: WHEN OTHERS THEN
396: IF (l_debug = 'Y') THEN
397: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
398: okc_debug.Reset_Indentation;
399: END IF;
400:
401: OKC_API.SET_MESSAGE(

Line 398: okc_debug.Reset_Indentation;

394: EXCEPTION
395: WHEN OTHERS THEN
396: IF (l_debug = 'Y') THEN
397: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
398: okc_debug.Reset_Indentation;
399: END IF;
400:
401: OKC_API.SET_MESSAGE(
402: p_app_name => G_APP_NAME,

Line 441: okc_debug.Set_Indentation('OKS_ACT_PVT');

437: BEGIN
438: x_return_status := OKC_API.G_RET_STS_SUCCESS;
439:
440: IF (l_debug = 'Y') THEN
441: okc_debug.Set_Indentation('OKS_ACT_PVT');
442: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
443: END IF;
444:
445: WHILE i IS NOT NULL LOOP

Line 442: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

438: x_return_status := OKC_API.G_RET_STS_SUCCESS;
439:
440: IF (l_debug = 'Y') THEN
441: okc_debug.Set_Indentation('OKS_ACT_PVT');
442: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
443: END IF;
444:
445: WHILE i IS NOT NULL LOOP
446: j := j +1;

Line 500: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

496: in_LAST_UPDATE_LOGIN(i),
497: in_OBJECT_VERSION_NUMBER(i));
498:
499: IF (l_debug = 'Y') THEN
500: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
501: okc_debug.Reset_Indentation;
502: END IF;
503:
504: EXCEPTION

Line 501: okc_debug.Reset_Indentation;

497: in_OBJECT_VERSION_NUMBER(i));
498:
499: IF (l_debug = 'Y') THEN
500: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
501: okc_debug.Reset_Indentation;
502: END IF;
503:
504: EXCEPTION
505: WHEN OTHERS THEN

Line 507: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

503:
504: EXCEPTION
505: WHEN OTHERS THEN
506: IF (l_debug = 'Y') THEN
507: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
508: okc_debug.Reset_Indentation;
509: END IF;
510:
511: OKC_API.SET_MESSAGE(

Line 508: okc_debug.Reset_Indentation;

504: EXCEPTION
505: WHEN OTHERS THEN
506: IF (l_debug = 'Y') THEN
507: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
508: okc_debug.Reset_Indentation;
509: END IF;
510:
511: OKC_API.SET_MESSAGE(
512: p_app_name => G_APP_NAME,

Line 630: okc_debug.Set_Indentation('OKS_KLN_PVT');

626: BEGIN
627: x_return_status := OKC_API.G_RET_STS_SUCCESS;
628:
629: IF (l_debug = 'Y') THEN
630: okc_debug.Set_Indentation('OKS_KLN_PVT');
631: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
632: END IF;
633:
634: WHILE i IS NOT NULL LOOP

Line 631: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

627: x_return_status := OKC_API.G_RET_STS_SUCCESS;
628:
629: IF (l_debug = 'Y') THEN
630: okc_debug.Set_Indentation('OKS_KLN_PVT');
631: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
632: END IF;
633:
634: WHILE i IS NOT NULL LOOP
635: j := j +1;

Line 945: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

941: in_LAST_UPDATE_LOGIN(i));
942: END LOOP;
943:
944: IF (l_debug = 'Y') THEN
945: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
946: okc_debug.Reset_Indentation;
947: END IF;
948: EXCEPTION
949: WHEN OTHERS THEN

Line 946: okc_debug.Reset_Indentation;

942: END LOOP;
943:
944: IF (l_debug = 'Y') THEN
945: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
946: okc_debug.Reset_Indentation;
947: END IF;
948: EXCEPTION
949: WHEN OTHERS THEN
950: IF (l_debug = 'Y') THEN

Line 951: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

947: END IF;
948: EXCEPTION
949: WHEN OTHERS THEN
950: IF (l_debug = 'Y') THEN
951: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
952: okc_debug.Reset_Indentation;
953: END IF;
954: OKC_API.SET_MESSAGE(
955: p_app_name => G_APP_NAME,

Line 952: okc_debug.Reset_Indentation;

948: EXCEPTION
949: WHEN OTHERS THEN
950: IF (l_debug = 'Y') THEN
951: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
952: okc_debug.Reset_Indentation;
953: END IF;
954: OKC_API.SET_MESSAGE(
955: p_app_name => G_APP_NAME,
956: p_msg_name => G_UNEXPECTED_ERROR,

Line 1010: okc_debug.Set_Indentation('OKS_BRS_PVT');

1006: j NUMBER := 0;
1007: BEGIN
1008: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1009: IF (l_debug = 'Y') THEN
1010: okc_debug.Set_Indentation('OKS_BRS_PVT');
1011: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
1012: END IF;
1013: WHILE i IS NOT NULL
1014: LOOP

Line 1011: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

1007: BEGIN
1008: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1009: IF (l_debug = 'Y') THEN
1010: okc_debug.Set_Indentation('OKS_BRS_PVT');
1011: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
1012: END IF;
1013: WHILE i IS NOT NULL
1014: LOOP
1015: j := j +1;

Line 1128: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

1124: in_SECURITY_GROUP_ID(i),
1125: in_OBJECT_VERSION_NUMBER(i));
1126:
1127: IF (l_debug = 'Y') THEN
1128: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
1129: okc_debug.Reset_Indentation;
1130: END IF;
1131: EXCEPTION
1132: WHEN OTHERS THEN

Line 1129: okc_debug.Reset_Indentation;

1125: in_OBJECT_VERSION_NUMBER(i));
1126:
1127: IF (l_debug = 'Y') THEN
1128: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
1129: okc_debug.Reset_Indentation;
1130: END IF;
1131: EXCEPTION
1132: WHEN OTHERS THEN
1133: IF (l_debug = 'Y') THEN

Line 1134: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

1130: END IF;
1131: EXCEPTION
1132: WHEN OTHERS THEN
1133: IF (l_debug = 'Y') THEN
1134: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
1135: okc_debug.Reset_Indentation;
1136: END IF;
1137: OKC_API.SET_MESSAGE(
1138: p_app_name => G_APP_NAME,

Line 1135: okc_debug.Reset_Indentation;

1131: EXCEPTION
1132: WHEN OTHERS THEN
1133: IF (l_debug = 'Y') THEN
1134: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
1135: okc_debug.Reset_Indentation;
1136: END IF;
1137: OKC_API.SET_MESSAGE(
1138: p_app_name => G_APP_NAME,
1139: p_msg_name => G_UNEXPECTED_ERROR,

Line 1228: okc_debug.Set_Indentation('OKS_KHR_PVT');

1224: j NUMBER := 0;
1225: BEGIN
1226: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1227: IF (l_debug = 'Y') THEN
1228: okc_debug.Set_Indentation('OKS_KHR_PVT');
1229: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
1230: END IF;
1231: WHILE i IS NOT NULL
1232: LOOP

Line 1229: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

1225: BEGIN
1226: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1227: IF (l_debug = 'Y') THEN
1228: okc_debug.Set_Indentation('OKS_KHR_PVT');
1229: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
1230: END IF;
1231: WHILE i IS NOT NULL
1232: LOOP
1233: j := j +1;

Line 1444: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

1440: in_LAST_UPDATE_DATE(i),
1441: in_LAST_UPDATE_LOGIN(i),
1442: in_COMMITMENT_ID(i));
1443: IF (l_debug = 'Y') THEN
1444: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
1445: okc_debug.Reset_Indentation;
1446: END IF;
1447: EXCEPTION
1448: WHEN OTHERS THEN

Line 1445: okc_debug.Reset_Indentation;

1441: in_LAST_UPDATE_LOGIN(i),
1442: in_COMMITMENT_ID(i));
1443: IF (l_debug = 'Y') THEN
1444: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
1445: okc_debug.Reset_Indentation;
1446: END IF;
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: IF (l_debug = 'Y') THEN

Line 1450: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

1446: END IF;
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: IF (l_debug = 'Y') THEN
1450: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
1451: okc_debug.Reset_Indentation;
1452: END IF;
1453: OKC_API.SET_MESSAGE(
1454: p_app_name => G_APP_NAME,

Line 1451: okc_debug.Reset_Indentation;

1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: IF (l_debug = 'Y') THEN
1450: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
1451: okc_debug.Reset_Indentation;
1452: END IF;
1453: OKC_API.SET_MESSAGE(
1454: p_app_name => G_APP_NAME,
1455: p_msg_name => G_UNEXPECTED_ERROR,

Line 1499: okc_debug.Set_Indentation('OKS_SLL_PVT');

1495:
1496: BEGIN
1497: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1498: IF (l_debug = 'Y') THEN
1499: okc_debug.Set_Indentation('OKS_SLL_PVT');
1500: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
1501: END IF;
1502: WHILE i IS NOT NULL
1503: LOOP

Line 1500: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

1496: BEGIN
1497: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1498: IF (l_debug = 'Y') THEN
1499: okc_debug.Set_Indentation('OKS_SLL_PVT');
1500: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
1501: END IF;
1502: WHILE i IS NOT NULL
1503: LOOP
1504: j := j +1;

Line 1588: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

1584: in_LAST_UPDATED_BY(i),
1585: in_LAST_UPDATE_DATE(i),
1586: in_LAST_UPDATE_LOGIN(i));
1587: IF (l_debug = 'Y') THEN
1588: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
1589: okc_debug.Reset_Indentation;
1590: END IF;
1591: EXCEPTION
1592: WHEN OTHERS THEN

Line 1589: okc_debug.Reset_Indentation;

1585: in_LAST_UPDATE_DATE(i),
1586: in_LAST_UPDATE_LOGIN(i));
1587: IF (l_debug = 'Y') THEN
1588: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
1589: okc_debug.Reset_Indentation;
1590: END IF;
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: IF (l_debug = 'Y') THEN

Line 1594: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

1590: END IF;
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: IF (l_debug = 'Y') THEN
1594: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
1595: okc_debug.Reset_Indentation;
1596: END IF;
1597: OKC_API.SET_MESSAGE(
1598: p_app_name => G_APP_NAME,

Line 1595: okc_debug.Reset_Indentation;

1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: IF (l_debug = 'Y') THEN
1594: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
1595: okc_debug.Reset_Indentation;
1596: END IF;
1597: OKC_API.SET_MESSAGE(
1598: p_app_name => G_APP_NAME,
1599: p_msg_name => G_UNEXPECTED_ERROR,

Line 1640: okc_debug.Set_Indentation('OKS_BILL_LEVEL_ELEMENTS_PVT');

1636:
1637: BEGIN
1638: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1639: IF (l_debug = 'Y') THEN
1640: okc_debug.Set_Indentation('OKS_BILL_LEVEL_ELEMENTS_PVT');
1641: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
1642: END IF;
1643: WHILE i IS NOT NULL
1644: LOOP

Line 1641: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

1637: BEGIN
1638: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1639: IF (l_debug = 'Y') THEN
1640: okc_debug.Set_Indentation('OKS_BILL_LEVEL_ELEMENTS_PVT');
1641: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
1642: END IF;
1643: WHILE i IS NOT NULL
1644: LOOP
1645: j := j +1;

Line 1718: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);

1714: in_DNZ_CHR_ID(i),
1715: in_DATE_END(i),
1716: in_PARENT_CLE_ID(i));
1717: IF (l_debug = 'Y') THEN
1718: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
1719: okc_debug.Reset_Indentation;
1720: END IF;
1721: EXCEPTION
1722: WHEN OTHERS THEN

Line 1719: okc_debug.Reset_Indentation;

1715: in_DATE_END(i),
1716: in_PARENT_CLE_ID(i));
1717: IF (l_debug = 'Y') THEN
1718: okc_debug.log('23500: Exiting INSERT_ROW_UPG', 2);
1719: okc_debug.Reset_Indentation;
1720: END IF;
1721: EXCEPTION
1722: WHEN OTHERS THEN
1723: IF (l_debug = 'Y') THEN

Line 1724: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);

1720: END IF;
1721: EXCEPTION
1722: WHEN OTHERS THEN
1723: IF (l_debug = 'Y') THEN
1724: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
1725: okc_debug.Reset_Indentation;
1726: END IF;
1727:
1728: OKC_API.SET_MESSAGE(

Line 1725: okc_debug.Reset_Indentation;

1721: EXCEPTION
1722: WHEN OTHERS THEN
1723: IF (l_debug = 'Y') THEN
1724: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
1725: okc_debug.Reset_Indentation;
1726: END IF;
1727:
1728: OKC_API.SET_MESSAGE(
1729: p_app_name => G_APP_NAME,

Line 1785: okc_debug.Set_Indentation('OKS_SUBSCR_HDR_PVT');

1781: BEGIN
1782: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1783:
1784: IF (l_debug = 'Y') THEN
1785: okc_debug.Set_Indentation('OKS_SUBSCR_HDR_PVT');
1786: okc_debug.log('23400: Entered INSERT_ROW_SUBHDR_UPG', 2);
1787: END IF;
1788: tbl_idx := P_SUBHDR_TBL.FIRST;
1789:

Line 1786: okc_debug.log('23400: Entered INSERT_ROW_SUBHDR_UPG', 2);

1782: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1783:
1784: IF (l_debug = 'Y') THEN
1785: okc_debug.Set_Indentation('OKS_SUBSCR_HDR_PVT');
1786: okc_debug.log('23400: Entered INSERT_ROW_SUBHDR_UPG', 2);
1787: END IF;
1788: tbl_idx := P_SUBHDR_TBL.FIRST;
1789:
1790: WHILE tbl_idx IS NOT NULL LOOP

Line 1895: okc_debug.log('23500: Exiting INSERT_ROW_SUBHDR_UPG', 2);

1891:
1892: END LOOP;
1893:
1894: IF (l_debug = 'Y') THEN
1895: okc_debug.log('23500: Exiting INSERT_ROW_SUBHDR_UPG', 2);
1896: okc_debug.Reset_Indentation;
1897: END IF;
1898:
1899: EXCEPTION

Line 1896: okc_debug.Reset_Indentation;

1892: END LOOP;
1893:
1894: IF (l_debug = 'Y') THEN
1895: okc_debug.log('23500: Exiting INSERT_ROW_SUBHDR_UPG', 2);
1896: okc_debug.Reset_Indentation;
1897: END IF;
1898:
1899: EXCEPTION
1900: WHEN OTHERS THEN

Line 1902: okc_debug.log('23600: Exiting INSERT_ROW_SUBHDR_UPG:OTHERS Exception', 2);

1898:
1899: EXCEPTION
1900: WHEN OTHERS THEN
1901: IF (l_debug = 'Y') THEN
1902: okc_debug.log('23600: Exiting INSERT_ROW_SUBHDR_UPG:OTHERS Exception', 2);
1903: okc_debug.Reset_Indentation;
1904: END IF;
1905:
1906: OKC_API.SET_MESSAGE(

Line 1903: okc_debug.Reset_Indentation;

1899: EXCEPTION
1900: WHEN OTHERS THEN
1901: IF (l_debug = 'Y') THEN
1902: okc_debug.log('23600: Exiting INSERT_ROW_SUBHDR_UPG:OTHERS Exception', 2);
1903: okc_debug.Reset_Indentation;
1904: END IF;
1905:
1906: OKC_API.SET_MESSAGE(
1907: p_app_name => G_APP_NAME,

Line 1954: okc_debug.Set_Indentation('OKS_SUBSCR_HDR_PVT');

1950: BEGIN
1951: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1952:
1953: IF (l_debug = 'Y') THEN
1954: okc_debug.Set_Indentation('OKS_SUBSCR_HDR_PVT');
1955: okc_debug.log('23400: Entered INSERT_BY_TBL_SUBPTNS', 2);
1956: END IF;
1957:
1958: WHILE tbl_idx IS NOT NULL LOOP

Line 1955: okc_debug.log('23400: Entered INSERT_BY_TBL_SUBPTNS', 2);

1951: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1952:
1953: IF (l_debug = 'Y') THEN
1954: okc_debug.Set_Indentation('OKS_SUBSCR_HDR_PVT');
1955: okc_debug.log('23400: Entered INSERT_BY_TBL_SUBPTNS', 2);
1956: END IF;
1957:
1958: WHILE tbl_idx IS NOT NULL LOOP
1959: j := j +1;

Line 2020: okc_debug.log('23500: Exiting INSERT_BY_TBL_SUBPTNS', 2);

2016: ,l_in_last_update_login(x) );
2017:
2018:
2019: IF (l_debug = 'Y') THEN
2020: okc_debug.log('23500: Exiting INSERT_BY_TBL_SUBPTNS', 2);
2021: okc_debug.Reset_Indentation;
2022: END IF;
2023:
2024: EXCEPTION

Line 2021: okc_debug.Reset_Indentation;

2017:
2018:
2019: IF (l_debug = 'Y') THEN
2020: okc_debug.log('23500: Exiting INSERT_BY_TBL_SUBPTNS', 2);
2021: okc_debug.Reset_Indentation;
2022: END IF;
2023:
2024: EXCEPTION
2025: WHEN OTHERS THEN

Line 2027: okc_debug.log('23600: Exiting INSERT_BY_TBL_SUBPTNS:OTHERS Exception', 2);

2023:
2024: EXCEPTION
2025: WHEN OTHERS THEN
2026: IF (l_debug = 'Y') THEN
2027: okc_debug.log('23600: Exiting INSERT_BY_TBL_SUBPTNS:OTHERS Exception', 2);
2028: okc_debug.Reset_Indentation;
2029: END IF;
2030:
2031: OKC_API.SET_MESSAGE(

Line 2028: okc_debug.Reset_Indentation;

2024: EXCEPTION
2025: WHEN OTHERS THEN
2026: IF (l_debug = 'Y') THEN
2027: okc_debug.log('23600: Exiting INSERT_BY_TBL_SUBPTNS:OTHERS Exception', 2);
2028: okc_debug.Reset_Indentation;
2029: END IF;
2030:
2031: OKC_API.SET_MESSAGE(
2032: p_app_name => G_APP_NAME,

Line 2090: okc_debug.Set_Indentation('OKS_SUBSCR_ELEMS_PVT');

2086: BEGIN
2087: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2088:
2089: IF (l_debug = 'Y') THEN
2090: okc_debug.Set_Indentation('OKS_SUBSCR_ELEMS_PVT');
2091: okc_debug.log('23400: Entered INSERT_BY_TBL_SUBELMNTS', 2);
2092: END IF;
2093:
2094: WHILE tbl_idx IS NOT NULL LOOP

Line 2091: okc_debug.log('23400: Entered INSERT_BY_TBL_SUBELMNTS', 2);

2087: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2088:
2089: IF (l_debug = 'Y') THEN
2090: okc_debug.Set_Indentation('OKS_SUBSCR_ELEMS_PVT');
2091: okc_debug.log('23400: Entered INSERT_BY_TBL_SUBELMNTS', 2);
2092: END IF;
2093:
2094: WHILE tbl_idx IS NOT NULL LOOP
2095: j := j +1;

Line 2167: okc_debug.log('23500: Exiting INSERT_BY_TBL_SUBELMNTS', 2);

2163: ,l_in_last_update_date(x)
2164: ,l_in_last_update_login(x));
2165:
2166: IF (l_debug = 'Y') THEN
2167: okc_debug.log('23500: Exiting INSERT_BY_TBL_SUBELMNTS', 2);
2168: okc_debug.Reset_Indentation;
2169: END IF;
2170:
2171: EXCEPTION

Line 2168: okc_debug.Reset_Indentation;

2164: ,l_in_last_update_login(x));
2165:
2166: IF (l_debug = 'Y') THEN
2167: okc_debug.log('23500: Exiting INSERT_BY_TBL_SUBELMNTS', 2);
2168: okc_debug.Reset_Indentation;
2169: END IF;
2170:
2171: EXCEPTION
2172: WHEN OTHERS THEN

Line 2174: okc_debug.log('23600: Exiting INSERT_BY_TBL_SUBELMNTS:OTHERS Exception', 2);

2170:
2171: EXCEPTION
2172: WHEN OTHERS THEN
2173: IF (l_debug = 'Y') THEN
2174: okc_debug.log('23600: Exiting INSERT_BY_TBL_SUBELMNTS:OTHERS Exception', 2);
2175: okc_debug.Reset_Indentation;
2176: END IF;
2177:
2178: OKC_API.SET_MESSAGE(

Line 2175: okc_debug.Reset_Indentation;

2171: EXCEPTION
2172: WHEN OTHERS THEN
2173: IF (l_debug = 'Y') THEN
2174: okc_debug.log('23600: Exiting INSERT_BY_TBL_SUBELMNTS:OTHERS Exception', 2);
2175: okc_debug.Reset_Indentation;
2176: END IF;
2177:
2178: OKC_API.SET_MESSAGE(
2179: p_app_name => G_APP_NAME,