[Home] [Help]
1: PACKAGE BODY OKL_INS_QUOTE_PVT AS
2: /* $Header: OKLRINQB.pls 120.55.12010000.2 2008/09/10 17:46:40 rkuttiya ship $ */
3: -- Start of wraper code generated automatically by Debug code generator
4: L_MODULE VARCHAR2(40) := 'LEASE.INSURANCE';
5: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: L_LEVEL_PROCEDURE NUMBER;
7: IS_DEBUG_PROCEDURE_ON BOOLEAN;
8: -- End of wraper code generated automatically by Debug code generator
9:
77: l_cplv_rec_type.JTOT_OBJECT1_CODE := 'OKX_PARTY' ;
78: -- Start of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
79: IF(L_DEBUG_ENABLED='Y') THEN
80: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
81: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
82: END IF;
83: IF(IS_DEBUG_PROCEDURE_ON) THEN
84: BEGIN
85: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
81: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
82: END IF;
83: IF(IS_DEBUG_PROCEDURE_ON) THEN
84: BEGIN
85: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
86: END;
87: END IF;
88: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
89: okl_k_party_roles_pvt.create_k_party_role(
100: -- gboomina 26-Oct-05 Bug#4558486 End - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
101:
102: IF(IS_DEBUG_PROCEDURE_ON) THEN
103: BEGIN
104: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
105: END;
106: END IF;
107: -- End of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
108: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
117:
118: -- Start of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
119: IF(L_DEBUG_ENABLED='Y') THEN
120: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
121: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
122: END IF;
123: IF(IS_DEBUG_PROCEDURE_ON) THEN
124: BEGIN
125: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
121: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
122: END IF;
123: IF(IS_DEBUG_PROCEDURE_ON) THEN
124: BEGIN
125: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
126: END;
127: END IF;
128: -- Payment Call Temp
129:
139:
140:
141: IF(IS_DEBUG_PROCEDURE_ON) THEN
142: BEGIN
143: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
144: END;
145: END IF;
146:
147:
251: -- Code for Debug Messages
252: IF(L_DEBUG_ENABLED='Y')
253: THEN
254: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
255: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
256: END IF;
257: IF(IS_DEBUG_PROCEDURE_ON)
258: THEN
259: BEGIN
256: END IF;
257: IF(IS_DEBUG_PROCEDURE_ON)
258: THEN
259: BEGIN
260: OKL_DEBUG_PUB.LOG_DEBUG(
261: L_LEVEL_PROCEDURE
262: ,L_MODULE
263: ,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies');
264: END;
273: x_ipyv_rec => x_ipyv_rec);
274: IF(IS_DEBUG_PROCEDURE_ON)
275: THEN
276: BEGIN
277: OKL_DEBUG_PUB.LOG_DEBUG(
278: L_LEVEL_PROCEDURE
279: ,L_MODULE
280: ,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies');
281: END;
429: --Code for Debug Messages
430: IF(L_DEBUG_ENABLED='Y')
431: THEN
432: L_LEVEL_PROCEDURE := FND_LOG.LEVEL_PROCEDURE;
433: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
434: END IF;
435: IF(IS_DEBUG_PROCEDURE_ON)
436: THEN
437: BEGIN
434: END IF;
435: IF(IS_DEBUG_PROCEDURE_ON)
436: THEN
437: BEGIN
438: OKL_DEBUG_PUB.LOG_DEBUG(
439: L_LEVEL_PROCEDURE
440: ,L_MODULE
441: ,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role');
442: END;
456: -- gboomina 26-Oct-05 Bug#4558486 End - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
457: IF(IS_DEBUG_PROCEDURE_ON)
458: THEN
459: BEGIN
460: OKL_DEBUG_PUB.LOG_DEBUG(
461: L_LEVEL_PROCEDURE
462: ,L_MODULE
463: ,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role');
464: END;
479: -- Start of code for debug messages
480: IF(L_DEBUG_ENABLED='Y')
481: THEN
482: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
483: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
484: END IF;
485: IF(IS_DEBUG_PROCEDURE_ON)
486: THEN
487: BEGIN
484: END IF;
485: IF(IS_DEBUG_PROCEDURE_ON)
486: THEN
487: BEGIN
488: OKL_DEBUG_PUB.LOG_DEBUG(
489: L_LEVEL_PROCEDURE
490: ,L_MODULE
491: ,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies');
492: END;
502: x_ipyv_rec => x_ipyv_rec);
503: IF(IS_DEBUG_PROCEDURE_ON)
504: THEN
505: BEGIN
506: OKL_DEBUG_PUB.LOG_DEBUG(
507: L_LEVEL_PROCEDURE
508: ,L_MODULE
509: ,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies');
510: END;
686: -- Create Stream and Stream Elements
687: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
688: IF(L_DEBUG_ENABLED='Y') THEN
689: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
690: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
691: END IF;
692:
693: -- Bug 5408689 : Start
694: IF(IS_DEBUG_PROCEDURE_ON)
692:
693: -- Bug 5408689 : Start
694: IF(IS_DEBUG_PROCEDURE_ON)
695: THEN
696: OKL_DEBUG_PUB.LOG_DEBUG(
697: L_LEVEL_PROCEDURE
698: ,L_MODULE
699: ,'Begin Debug OKLRSULB.pls call Okl_Streams_Util.round_streams_amount ' );
700: END IF;
707: ,p_selv_tbl => p_selv_tbl
708: ,x_selv_tbl => x_selv_tbl);
709: IF(IS_DEBUG_PROCEDURE_ON)
710: THEN
711: OKL_DEBUG_PUB.LOG_DEBUG(
712: L_LEVEL_PROCEDURE
713: ,L_MODULE
714: ,'End Debug OKLRSULB.pls call Okl_Streams_Util.round_streams_amount');
715: END IF;
728:
729:
730: IF(IS_DEBUG_PROCEDURE_ON) THEN
731: BEGIN
732: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
733: END;
734: END IF;
735: OKL_STREAMS_PUB.create_streams(
736: p_api_version
743: ,x_stmv_rec
744: ,x_selv_tbl);
745: IF(IS_DEBUG_PROCEDURE_ON) THEN
746: BEGIN
747: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
748: END;
749: END IF;
750: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
751:
1131: -- Create Stream and Stream Elements
1132: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1133: IF(L_DEBUG_ENABLED='Y') THEN
1134: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1135: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1136: END IF;
1137:
1138: -- Bug 5408689 : Start
1139: IF(IS_DEBUG_PROCEDURE_ON)
1137:
1138: -- Bug 5408689 : Start
1139: IF(IS_DEBUG_PROCEDURE_ON)
1140: THEN
1141: OKL_DEBUG_PUB.LOG_DEBUG(
1142: L_LEVEL_PROCEDURE
1143: ,L_MODULE
1144: ,'Begin Debug OKLRSULB.pls call Okl_Streams_Util.round_streams_amount ' );
1145: END IF;
1152: ,p_selv_tbl => p_selv_tbl
1153: ,x_selv_tbl => x_selv_tbl);
1154: IF(IS_DEBUG_PROCEDURE_ON)
1155: THEN
1156: OKL_DEBUG_PUB.LOG_DEBUG(
1157: L_LEVEL_PROCEDURE
1158: ,L_MODULE
1159: ,'End Debug OKLRSULB.pls call Okl_Streams_Util.round_streams_amount');
1160: END IF;
1173:
1174:
1175: IF(IS_DEBUG_PROCEDURE_ON) THEN
1176: BEGIN
1177: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1178: END;
1179: END IF;
1180: OKL_STREAMS_PUB.create_streams(
1181: p_api_version
1188: ,x_stmv_rec
1189: ,x_selv_tbl );
1190: IF(IS_DEBUG_PROCEDURE_ON) THEN
1191: BEGIN
1192: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1193: END;
1194: END IF;
1195: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1196:
1258:
1259: -- Start of wraper code generated automatically by Debug code generator for OKL_SETUPPRODUCTS_PVT.Getpdt_parameters
1260: IF(IS_DEBUG_PROCEDURE_ON) THEN
1261: BEGIN
1262: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_SETUPPRODUCTS_PVT.Getpdt_parameters ');
1263: END;
1264: END IF;
1265: OKL_SETUPPRODUCTS_PVT.Getpdt_parameters(
1266: l_api_version
1274: ,l_pdt_parameters_rec
1275: );
1276: IF(IS_DEBUG_PROCEDURE_ON) THEN
1277: BEGIN
1278: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_SETUPPRODUCTS_PVT.Getpdt_parameters ');
1279: END;
1280: END IF;
1281: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPRODUCTS_PVT.Getpdt_parameters
1282:
1336:
1337: -- Bug 5408689 : Start
1338: IF(IS_DEBUG_PROCEDURE_ON)
1339: THEN
1340: OKL_DEBUG_PUB.LOG_DEBUG(
1341: L_LEVEL_PROCEDURE
1342: ,L_MODULE
1343: ,'Begin Debug OKLRSULB.pls call Okl_Streams_Util.round_streams_amount ' );
1344: END IF;
1351: ,p_selv_tbl => p_selv_tbl
1352: ,x_selv_tbl => x_selv_tbl);
1353: IF(IS_DEBUG_PROCEDURE_ON)
1354: THEN
1355: OKL_DEBUG_PUB.LOG_DEBUG(
1356: L_LEVEL_PROCEDURE
1357: ,L_MODULE
1358: ,'End Debug OKLRSULB.pls call Okl_Streams_Util.round_streams_amount');
1359: END IF;
1373:
1374: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1375: IF(IS_DEBUG_PROCEDURE_ON) THEN
1376: BEGIN
1377: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1378: END;
1379: END IF;
1380: OKL_STREAMS_PUB.create_streams(
1381: p_api_version
1389: ,x_selv_tbl
1390: );
1391: IF(IS_DEBUG_PROCEDURE_ON) THEN
1392: BEGIN
1393: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1394: END;
1395: END IF;
1396: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1397:
1566: -- Create Stream and Stream Elements
1567: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1568: IF(L_DEBUG_ENABLED='Y') THEN
1569: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1570: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1571: END IF;
1572:
1573: -- Bug 5408689 : Start
1574: IF(IS_DEBUG_PROCEDURE_ON)
1572:
1573: -- Bug 5408689 : Start
1574: IF(IS_DEBUG_PROCEDURE_ON)
1575: THEN
1576: OKL_DEBUG_PUB.LOG_DEBUG(
1577: L_LEVEL_PROCEDURE
1578: ,L_MODULE
1579: ,'Begin Debug OKLRSULB.pls call Okl_Streams_Util.round_streams_amount ' );
1580: END IF;
1587: ,p_selv_tbl => p_selv_tbl
1588: ,x_selv_tbl => x_selv_tbl);
1589: IF(IS_DEBUG_PROCEDURE_ON)
1590: THEN
1591: OKL_DEBUG_PUB.LOG_DEBUG(
1592: L_LEVEL_PROCEDURE
1593: ,L_MODULE
1594: ,'End Debug OKLRSULB.pls call Okl_Streams_Util.round_streams_amount');
1595: END IF;
1608:
1609:
1610: IF(IS_DEBUG_PROCEDURE_ON) THEN
1611: BEGIN
1612: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1613: END;
1614: END IF;
1615: OKL_STREAMS_PUB.create_streams(
1616: p_api_version
1624: ,x_selv_tbl
1625: );
1626: IF(IS_DEBUG_PROCEDURE_ON) THEN
1627: BEGIN
1628: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1629: END;
1630: END IF;
1631: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1632: l_return_status := x_return_status ;
1693: END;
1694: -- Start of wraper code generated automatically by Debug code generator for OKL_SETUPPRODUCTS_PVT.Getpdt_parameters
1695: IF(IS_DEBUG_PROCEDURE_ON) THEN
1696: BEGIN
1697: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_SETUPPRODUCTS_PVT.Getpdt_parameters ');
1698: END;
1699: END IF;
1700: OKL_SETUPPRODUCTS_PVT.Getpdt_parameters(
1701: p_api_version
1708: , SYSDATE
1709: ,l_pdt_parameter_rec );
1710: IF(IS_DEBUG_PROCEDURE_ON) THEN
1711: BEGIN
1712: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_SETUPPRODUCTS_PVT.Getpdt_parameters ');
1713: END;
1714: END IF;
1715: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPRODUCTS_PVT.Getpdt_parameters
1716:
1772:
1773: -- Bug 5408689 : Start
1774: IF(IS_DEBUG_PROCEDURE_ON)
1775: THEN
1776: OKL_DEBUG_PUB.LOG_DEBUG(
1777: L_LEVEL_PROCEDURE
1778: ,L_MODULE
1779: ,'Begin Debug OKLRSULB.pls call Okl_Streams_Util.round_streams_amount ' );
1780: END IF;
1787: ,p_selv_tbl => p_selv_tbl
1788: ,x_selv_tbl => x_selv_tbl);
1789: IF(IS_DEBUG_PROCEDURE_ON)
1790: THEN
1791: OKL_DEBUG_PUB.LOG_DEBUG(
1792: L_LEVEL_PROCEDURE
1793: ,L_MODULE
1794: ,'End Debug OKLRSULB.pls call Okl_Streams_Util.round_streams_amount');
1795: END IF;
1809:
1810: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1811: IF(IS_DEBUG_PROCEDURE_ON) THEN
1812: BEGIN
1813: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1814: END;
1815: END IF;
1816: OKL_STREAMS_PUB.create_streams(
1817: p_api_version
1825: ,x_selv_tbl
1826: );
1827: IF(IS_DEBUG_PROCEDURE_ON) THEN
1828: BEGIN
1829: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
1830: END;
1831: END IF;
1832: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
1833:
2789: -- Create Stream and Stream Elements
2790: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
2791: IF(L_DEBUG_ENABLED='Y') THEN
2792: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2793: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2794: END IF;
2795:
2796: -- Bug 5408689 : Start
2797: IF(IS_DEBUG_PROCEDURE_ON)
2795:
2796: -- Bug 5408689 : Start
2797: IF(IS_DEBUG_PROCEDURE_ON)
2798: THEN
2799: OKL_DEBUG_PUB.LOG_DEBUG(
2800: L_LEVEL_PROCEDURE
2801: ,L_MODULE
2802: ,'Begin Debug OKLRSULB.pls call Okl_Streams_Util.round_streams_amount ' );
2803: END IF;
2810: ,p_selv_tbl => p_selv_tbl
2811: ,x_selv_tbl => x_selv_tbl);
2812: IF(IS_DEBUG_PROCEDURE_ON)
2813: THEN
2814: OKL_DEBUG_PUB.LOG_DEBUG(
2815: L_LEVEL_PROCEDURE
2816: ,L_MODULE
2817: ,'End Debug OKLRSULB.pls call Okl_Streams_Util.round_streams_amount');
2818: END IF;
2831:
2832:
2833: IF(IS_DEBUG_PROCEDURE_ON) THEN
2834: BEGIN
2835: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
2836: END;
2837: END IF;
2838: OKL_STREAMS_PUB.create_streams(
2839: p_api_version
2847: ,x_selv_tbl
2848: );
2849: IF(IS_DEBUG_PROCEDURE_ON) THEN
2850: BEGIN
2851: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.create_streams ');
2852: END;
2853: END IF;
2854: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.create_streams
2855: l_return_status := x_return_status ;
2995: --Procedures pertaining to versioning a contract
2996: -- Start of wraper code generated automatically by Debug code generator for OKL_VERSION_PUB.version_contract
2997: IF(L_DEBUG_ENABLED='Y') THEN
2998: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2999: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3000: END IF;
3001: IF(IS_DEBUG_PROCEDURE_ON) THEN
3002: BEGIN
3003: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_VERSION_PUB.version_contract ');
2999: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3000: END IF;
3001: IF(IS_DEBUG_PROCEDURE_ON) THEN
3002: BEGIN
3003: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_VERSION_PUB.version_contract ');
3004: END;
3005: END IF;
3006: OKL_VERSION_PUB.version_contract( p_api_version => l_api_version ,
3007: p_init_msg_list => OKC_API.G_FALSE,
3013: x_cvmv_rec => lx_cvmv_rec
3014: );
3015: IF(IS_DEBUG_PROCEDURE_ON) THEN
3016: BEGIN
3017: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_VERSION_PUB.version_contract ');
3018: END;
3019: END IF;
3020: -- End of wraper code generated automatically by Debug code generator for OKL_VERSION_PUB.version_contract
3021:
3449: l_inav_rec.LAST_UPDATE_LOGIN := l_okl_inav_pk_csr.LAST_UPDATE_LOGIN ;
3450: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Assets_Pub.insert_ins_assets
3451: IF(L_DEBUG_ENABLED='Y') THEN
3452: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
3453: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3454: END IF;
3455: IF(IS_DEBUG_PROCEDURE_ON) THEN
3456: BEGIN
3457: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Assets_Pub.insert_ins_assets ');
3453: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3454: END IF;
3455: IF(IS_DEBUG_PROCEDURE_ON) THEN
3456: BEGIN
3457: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Assets_Pub.insert_ins_assets ');
3458: END;
3459: END IF;
3460: Okl_Ins_Assets_Pub.insert_ins_assets(
3461: p_api_version => p_api_version,
3467: x_inav_rec => lx_inav_rec
3468: );
3469: IF(IS_DEBUG_PROCEDURE_ON) THEN
3470: BEGIN
3471: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Assets_Pub.insert_ins_assets ');
3472: END;
3473: END IF;
3474: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Assets_Pub.insert_ins_assets
3475: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3638: -- Insert Policy
3639: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
3640: IF(IS_DEBUG_PROCEDURE_ON) THEN
3641: BEGIN
3642: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3643: END;
3644: END IF;
3645: Okl_Ins_Policies_Pub.insert_ins_policies(
3646: p_api_version => p_api_version,
3652: x_ipyv_rec => lx_ipyv_rec
3653: );
3654: IF(IS_DEBUG_PROCEDURE_ON) THEN
3655: BEGIN
3656: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3657: END;
3658: END IF;
3659: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
3660:
3722:
3723: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
3724: IF(IS_DEBUG_PROCEDURE_ON) THEN
3725: BEGIN
3726: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3727: END;
3728: END IF;
3729: Okl_Ins_Policies_Pub.update_ins_policies(
3730: p_api_version => p_api_version,
3736: x_ipyv_rec => lx_ipyv_rec
3737: );
3738: IF(IS_DEBUG_PROCEDURE_ON) THEN
3739: BEGIN
3740: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3741: END;
3742: END IF;
3743: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
3744: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3777: l_inqv_rec.IPY_ID := lx_ipyv_rec.ID;
3778: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
3779: IF(IS_DEBUG_PROCEDURE_ON) THEN
3780: BEGIN
3781: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3782: END;
3783: END IF;
3784: Okl_Ins_Policies_Pub.update_ins_policies(
3785: p_api_version => p_api_version,
3790: p_ipyv_rec => l_inqv_rec,
3791: x_ipyv_rec => lx_inqv_rec );
3792: IF(IS_DEBUG_PROCEDURE_ON) THEN
3793: BEGIN
3794: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3795: END;
3796: END IF;
3797: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
3798:
3922: x_message := px_ipyv_rec.ADJUSTMENT;
3923: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
3924: IF(L_DEBUG_ENABLED='Y') THEN
3925: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
3926: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3927: END IF;
3928: IF(IS_DEBUG_PROCEDURE_ON) THEN
3929: BEGIN
3930: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3926: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3927: END IF;
3928: IF(IS_DEBUG_PROCEDURE_ON) THEN
3929: BEGIN
3930: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3931: END;
3932: END IF;
3933: Okl_Ins_Policies_Pub.insert_ins_policies(
3934: p_api_version => l_api_version,
3940: x_ipyv_rec => lx_ipyv_rec
3941: );
3942: IF(IS_DEBUG_PROCEDURE_ON) THEN
3943: BEGIN
3944: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3945: END;
3946: END IF;
3947: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
3948:
4010: x_message := px_ipyv_rec.ADJUSTMENT;
4011: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
4012: IF(IS_DEBUG_PROCEDURE_ON) THEN
4013: BEGIN
4014: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
4015: END;
4016: END IF;
4017: Okl_Ins_Policies_Pub.insert_ins_policies(
4018: p_api_version => l_api_version,
4024: x_ipyv_rec => lx_ipyv_rec
4025: );
4026: IF(IS_DEBUG_PROCEDURE_ON) THEN
4027: BEGIN
4028: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
4029: END;
4030: END IF;
4031: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
4032:
4051: END LOOP;
4052: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Assets_Pub.insert_ins_assets
4053: IF(IS_DEBUG_PROCEDURE_ON) THEN
4054: BEGIN
4055: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Assets_Pub.insert_ins_assets ');
4056: END;
4057: END IF;
4058: Okl_Ins_Assets_Pub.insert_ins_assets(
4059: p_api_version => l_api_version,
4065: x_inav_tbl => lx_inav_tbl
4066: );
4067: IF(IS_DEBUG_PROCEDURE_ON) THEN
4068: BEGIN
4069: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Assets_Pub.insert_ins_assets ');
4070: END;
4071: END IF;
4072: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Assets_Pub.insert_ins_assets
4073:
5946:
5947: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
5948: IF(IS_DEBUG_PROCEDURE_ON) THEN
5949: BEGIN
5950: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
5951: END;
5952: END IF;
5953: Okl_Ins_Policies_Pub.update_ins_policies(
5954: p_api_version => p_api_version,
5960: x_ipyv_rec => lx_ipyv_rec
5961: );
5962: IF(IS_DEBUG_PROCEDURE_ON) THEN
5963: BEGIN
5964: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
5965: END;
5966: END IF;
5967: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
5968:
6336: l_stmv_rec.SAY_CODE := 'CURR' ;
6337: -- Start of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
6338: IF(L_DEBUG_ENABLED='Y') THEN
6339: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
6340: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
6341: END IF;
6342: IF(IS_DEBUG_PROCEDURE_ON) THEN
6343: BEGIN
6344: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Streams_Pub.update_streams ');
6340: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
6341: END IF;
6342: IF(IS_DEBUG_PROCEDURE_ON) THEN
6343: BEGIN
6344: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Streams_Pub.update_streams ');
6345: END;
6346: END IF;
6347: Okl_Streams_Pub.update_streams (
6348: p_api_version => l_api_version,
6353: p_stmv_rec => l_stmv_rec,
6354: x_stmv_rec => x_stmv_rec);
6355: IF(IS_DEBUG_PROCEDURE_ON) THEN
6356: BEGIN
6357: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Streams_Pub.update_streams ');
6358: END;
6359: END IF;
6360: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
6361:
6371:
6372: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
6373: IF(IS_DEBUG_PROCEDURE_ON) THEN
6374: BEGIN
6375: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
6376: END;
6377: END IF;
6378: Okl_Ins_Policies_Pub.update_ins_policies(
6379: p_api_version => p_api_version,
6385: x_ipyv_rec => lx_ipyv_rec
6386: );
6387: IF(IS_DEBUG_PROCEDURE_ON) THEN
6388: BEGIN
6389: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
6390: END;
6391: END IF;
6392: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
6393:
7033: l_cplv_rec_type.JTOT_OBJECT1_CODE := 'OKX_VENDOR' ;
7034: -- Start of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
7035: IF(L_DEBUG_ENABLED='Y') THEN
7036: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
7037: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
7038: END IF;
7039: IF(IS_DEBUG_PROCEDURE_ON) THEN
7040: BEGIN
7041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7037: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
7038: END IF;
7039: IF(IS_DEBUG_PROCEDURE_ON) THEN
7040: BEGIN
7041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7042: END;
7043: END IF;
7044: -- gboomina 26-Oct-05 Bug#4558486 Start - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
7045: okl_k_party_roles_pvt.create_k_party_role(
7055:
7056: -- gboomina 26-Oct-05 Bug#4558486 End - Changed okl_okc_migration_pvt.create_k_party_role to okl_k_party_roles_pvt.create_k_party_role
7057: IF(IS_DEBUG_PROCEDURE_ON) THEN
7058: BEGIN
7059: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call okl_k_party_roles_pvt.create_k_party_role ');
7060: END;
7061: END IF;
7062: -- End of wraper code generated automatically by Debug code generator for okl_k_party_roles_pvt.create_k_party_role
7063: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7092: l_ipyv_rec.ACTIVATION_DATE := SYSDATE ;
7093: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7094: IF(IS_DEBUG_PROCEDURE_ON) THEN
7095: BEGIN
7096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7097: END;
7098: END IF;
7099: Okl_Ins_Policies_Pub.update_ins_policies(
7100: p_api_version => p_api_version,
7105: p_ipyv_rec => l_ipyv_rec,
7106: x_ipyv_rec => lx_ipyv_rec );
7107: IF(IS_DEBUG_PROCEDURE_ON) THEN
7108: BEGIN
7109: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7110: END;
7111: END IF;
7112: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7113:
7159:
7160: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7161: IF(IS_DEBUG_PROCEDURE_ON) THEN
7162: BEGIN
7163: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7164: END;
7165: END IF;
7166: OKL_STREAMS_PUB.update_streams(
7167: p_api_version
7173: ,x_stmv_rec
7174: );
7175: IF(IS_DEBUG_PROCEDURE_ON) THEN
7176: BEGIN
7177: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7178: END;
7179: END IF;
7180: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7181:
7215:
7216: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7217: IF(IS_DEBUG_PROCEDURE_ON) THEN
7218: BEGIN
7219: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7220: END;
7221: END IF;
7222: OKL_STREAMS_PUB.update_streams(
7223: p_api_version
7229: ,x_stmv_rec
7230: );
7231: IF(IS_DEBUG_PROCEDURE_ON) THEN
7232: BEGIN
7233: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7234: END;
7235: END IF;
7236: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7237:
7287:
7288: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7289: IF(IS_DEBUG_PROCEDURE_ON) THEN
7290: BEGIN
7291: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7292: END;
7293: END IF;
7294: OKL_STREAMS_PUB.update_streams(
7295: p_api_version
7301: ,x_stmv_rec
7302: );
7303: IF(IS_DEBUG_PROCEDURE_ON) THEN
7304: BEGIN
7305: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7306: END;
7307: END IF;
7308: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7309:
7343:
7344: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7345: IF(IS_DEBUG_PROCEDURE_ON) THEN
7346: BEGIN
7347: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7348: END;
7349: END IF;
7350: OKL_STREAMS_PUB.update_streams(
7351: p_api_version
7357: ,x_stmv_rec
7358: );
7359: IF(IS_DEBUG_PROCEDURE_ON) THEN
7360: BEGIN
7361: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call OKL_STREAMS_PUB.update_streams ');
7362: END;
7363: END IF;
7364: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
7365:
7539: -- Insert Policy
7540: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
7541: IF(L_DEBUG_ENABLED='Y') THEN
7542: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
7543: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
7544: END IF;
7545: IF(IS_DEBUG_PROCEDURE_ON) THEN
7546: BEGIN
7547: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
7543: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
7544: END IF;
7545: IF(IS_DEBUG_PROCEDURE_ON) THEN
7546: BEGIN
7547: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
7548: END;
7549: END IF;
7550: Okl_Ins_Policies_Pub.insert_ins_policies(
7551: p_api_version => p_api_version,
7557: x_ipyv_rec => lx_ipyv_rec
7558: );
7559: IF(IS_DEBUG_PROCEDURE_ON) THEN
7560: BEGIN
7561: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
7562: END;
7563: END IF;
7564: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
7565: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7664: l_inqv_rec.IPY_ID := l_ipyv_rec.ID;
7665: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7666: IF(IS_DEBUG_PROCEDURE_ON) THEN
7667: BEGIN
7668: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7669: END;
7670: END IF;
7671: Okl_Ins_Policies_Pub.update_ins_policies(
7672: p_api_version => p_api_version,
7678: x_ipyv_rec => lx_inqv_rec
7679: );
7680: IF(IS_DEBUG_PROCEDURE_ON) THEN
7681: BEGIN
7682: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7683: END;
7684: END IF;
7685: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7686: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN