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

Line 65: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_CHANGE_REQUEST';

61: lv_orig_chr_id okc_k_headers_b.id%TYPE;
62:
63: l_api_version CONSTANT NUMBER DEFAULT 1.0;
64: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_CHANGE_REQUEST';
65: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_CHANGE_REQUEST';
66: l_debug_enabled VARCHAR2(10);
67:
68: BEGIN
69: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 74: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_change_request');

70:
71: l_debug_enabled := okl_debug_pub.check_log_enabled;
72:
73: IF(l_debug_enabled='Y') THEN
74: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_change_request');
75: END IF;
76:
77: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
78: x_return_status := OKL_API.START_ACTIVITY(

Line 114: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT, l_module, 'p_orig_chr_id '|| lv_orig_chr_id||' p_creq_chr_id '||lv_creq_chr_id);

110: OPEN c_get_creq_chr_id (p_change_request_id); FETCH c_get_creq_chr_id INTO lv_creq_chr_id;
111: CLOSE c_get_creq_chr_id;
112:
113: IF(l_debug_enabled='Y') THEN
114: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT, l_module, 'p_orig_chr_id '|| lv_orig_chr_id||' p_creq_chr_id '||lv_creq_chr_id);
115: END IF;
116:
117: -- there are some steps common between AGREEMENT and PROGRAM, perform them first
118: IF(G_OPERATING_SCS_CODE = cv_get_cr_details.agreement_category OR G_PROGRAM_SCS_CODE = cv_get_cr_details.agreement_category)THEN

Line 130: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

126: ,p_orig_chr_id => lv_orig_chr_id
127: ,p_creq_chr_id => lv_creq_chr_id
128: );
129: IF(l_debug_enabled='Y') THEN
130: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
131: l_module,
132: 'sync_agr_header returned with status '||x_return_status
133: );
134: END IF;

Line 151: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

147: ,p_orig_chr_id => lv_orig_chr_id
148: ,p_creq_chr_id => lv_creq_chr_id
149: );
150: IF(l_debug_enabled='Y') THEN
151: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
152: l_module,
153: 'sync_non_primary_parties returned with status '||x_return_status
154: );
155: END IF;

Line 172: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

168: ,p_orig_chr_id => lv_orig_chr_id
169: ,p_creq_chr_id => lv_creq_chr_id
170: );
171: IF(l_debug_enabled='Y') THEN
172: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
173: l_module,
174: 'sync_party_contacts returned with status '||x_return_status
175: );
176: END IF;

Line 193: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

189: ,p_orig_chr_id => lv_orig_chr_id
190: ,p_creq_chr_id => lv_creq_chr_id
191: );
192: IF(l_debug_enabled='Y') THEN
193: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
194: l_module,
195: 'sync_article_changes returned with status '||x_return_status
196: );
197: END IF;

Line 214: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

210: ,p_orig_chr_id => lv_orig_chr_id
211: ,p_creq_chr_id => lv_creq_chr_id
212: );
213: IF(l_debug_enabled='Y') THEN
214: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
215: l_module,
216: 'sync_vendor_billing returned with status '||x_return_status
217: );
218: END IF;

Line 240: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

236: ,p_creq_chr_id => lv_creq_chr_id
237: ,p_change_request_id => p_change_request_id
238: );
239: IF(l_debug_enabled='Y') THEN
240: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
241: l_module,
242: 'sync_agr_associations returned with status '||x_return_status
243: );
244: END IF;

Line 261: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

257: ,p_orig_chr_id => lv_orig_chr_id
258: ,p_creq_chr_id => lv_creq_chr_id
259: );
260: IF(l_debug_enabled='Y') THEN
261: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
262: l_module,
263: 'sync_elig_criteria returned with status '||x_return_status
264: );
265: END IF;

Line 283: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

279: ,p_orig_chr_id => lv_orig_chr_id
280: ,p_creq_chr_id => lv_creq_chr_id
281: );
282: IF(l_debug_enabled='Y') THEN
283: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
284: l_module,
285: 'sync_terms returned with status '||x_return_status
286: );
287: END IF;

Line 305: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

301: ,p_orig_chr_id => lv_orig_chr_id
302: ,p_creq_chr_id => lv_creq_chr_id
303: );
304: IF(l_debug_enabled='Y') THEN
305: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
306: l_module,
307: 'sync_vendor_disb_setup returned with status '||x_return_status
308: );
309: END IF;

Line 327: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

323: ,p_khr_status => G_ABANDONED_STS_CODE
324: ,p_chr_id => lv_creq_chr_id
325: );
326: IF(l_debug_enabled='Y') THEN
327: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
328: l_module,
329: 'okl_contract_status_pub.update_contract_status G_ABANDONED_STS_CODE returned with status '||x_return_status
330: );
331: END IF;

Line 349: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

345: ,p_creq_chr_id => lv_orig_chr_id -- for ASSOCIATION type of change request, there is no additional agreement created
346: ,p_change_request_id => p_change_request_id
347: );
348: IF(l_debug_enabled='Y') THEN
349: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
350: l_module,
351: 'sync_associations for ASSOCIATION returned with status '||x_return_status
352: );
353: END IF;

Line 375: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

371: ,p_vcrv_rec => lv_vcrv_rec
372: ,x_vcrv_rec => x_vcrv_rec
373: );
374: IF(l_debug_enabled='Y') THEN
375: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
376: l_module,
377: 'okl_vp_change_request_pvt.update_change_request_header returned with status '||x_return_status
378: );
379: END IF;

Line 390: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_change_request');

386:
387: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
388:
389: IF(l_debug_enabled='Y') THEN
390: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_change_request');
391: END IF;
392: EXCEPTION
393: WHEN OKL_API.G_EXCEPTION_ERROR THEN
394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 467: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_AGR_HEADER';

463: l_agr_hdr_rec okl_vendor_program_pvt.program_header_rec_type;
464:
465: l_api_version CONSTANT NUMBER DEFAULT 1.0;
466: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_AGR_HEADER';
467: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_AGR_HEADER';
468: l_debug_enabled VARCHAR2(10);
469:
470: BEGIN
471: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 476: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_agr_header');

472:
473: l_debug_enabled := okl_debug_pub.check_log_enabled;
474:
475: IF(l_debug_enabled='Y') THEN
476: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_agr_header');
477: END IF;
478:
479: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
480: x_return_status := OKL_API.START_ACTIVITY(

Line 554: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

550: ,p_program_id => p_orig_chr_id
551: ,p_parent_agreement_id => cv_hdr_attribs_new.chr_id_referred
552: );
553: IF(l_debug_enabled='Y') THEN
554: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
555: l_module,
556: 'okl_vendor_program_pvt.update_program returned with status '||x_return_status||' x_msg_data '||x_msg_data
557: );
558: END IF;

Line 571: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_agr_header');

567:
568: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
569:
570: IF(l_debug_enabled='Y') THEN
571: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_agr_header');
572: END IF;
573: EXCEPTION
574: WHEN OKL_API.G_EXCEPTION_ERROR THEN
575: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 699: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_NON_PRIMARY_PARTIES';

695:
696: x_cpl_id okc_k_party_roles_b.cpl_id%TYPE;
697: l_api_version CONSTANT NUMBER DEFAULT 1.0;
698: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_NON_PRIMARY_PARTIES';
699: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_NON_PRIMARY_PARTIES';
700: l_debug_enabled VARCHAR2(10);
701:
702: BEGIN
703: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 708: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_non_primary_parties');

704:
705: l_debug_enabled := okl_debug_pub.check_log_enabled;
706:
707: IF(l_debug_enabled='Y') THEN
708: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_non_primary_parties');
709: END IF;
710:
711: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
712: x_return_status := OKL_API.START_ACTIVITY(

Line 789: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

785: ,p_cplv_rec => lv_cplv_rec
786: ,x_cplv_rec => x_cplv_rec
787: );
788: IF(l_debug_enabled='Y') THEN
789: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
790: l_module,
791: 'okl_contract_party_pub.update_k_party_role returned with status '||x_return_status
792: );
793: END IF;

Line 819: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

815: ,x_msg_data => x_msg_data
816: ,p_ctcv_tbl => lv_ctcv_tbl
817: );
818: IF(l_debug_enabled='Y') THEN
819: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
820: l_module,
821: 'okl_contract_party_pub.delete_contact returned with status '||x_return_status||' contact_tbl_idx '||contact_tbl_idx
822: );
823: END IF;

Line 840: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

836: ,x_msg_data => x_msg_data
837: ,p_cplv_rec => lv_cplv_rec
838: );
839: IF(l_debug_enabled='Y') THEN
840: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
841: l_module,
842: 'okl_contract_party_pub.delete_k_party_role returned with status '||x_return_status
843: );
844: END IF;

Line 868: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

864: ,p_rle_code => new_parties_rec.rle_code
865: ,x_cpl_id => x_cpl_id
866: );
867: IF(l_debug_enabled='Y') THEN
868: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
869: l_module,
870: 'okl_copy_contract_pub.copy_party_roles returned with status '||x_return_status
871: );
872: END IF;

Line 883: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_non_primary_parties');

879:
880: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
881:
882: IF(l_debug_enabled='Y') THEN
883: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_non_primary_parties');
884: END IF;
885: EXCEPTION
886: WHEN OKL_API.G_EXCEPTION_ERROR THEN
887: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 922: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_PARTY_CONTACTS';

918: ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
919: ) IS
920: l_api_version CONSTANT NUMBER DEFAULT 1.0;
921: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_PARTY_CONTACTS';
922: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_PARTY_CONTACTS';
923: l_debug_enabled VARCHAR2(10);
924:
925: CURSOR c_get_diff_contact_csr(cp_chr_id_1 okc_k_headers_b.id%TYPE
926: ,cp_chr_id_2 okc_k_headers_b.id%TYPE)IS

Line 982: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_party_contacts');

978:
979: l_debug_enabled := okl_debug_pub.check_log_enabled;
980:
981: IF(l_debug_enabled='Y') THEN
982: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_party_contacts');
983: END IF;
984:
985: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
986: x_return_status := OKL_API.START_ACTIVITY(

Line 1026: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1022: ,x_msg_data => x_msg_data
1023: ,p_ctcv_tbl => lv_ctcv_tbl
1024: );
1025: IF(l_debug_enabled='Y') THEN
1026: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1027: l_module,
1028: 'okl_contract_party_pub.delete_contact returned with status '||x_return_status
1029: );
1030: END IF;

Line 1066: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1062: ,p_ctcv_tbl => lv_ctcv_tbl
1063: ,x_ctcv_tbl => x_ctcv_tbl
1064: );
1065: IF(l_debug_enabled='Y') THEN
1066: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1067: l_module,
1068: 'okl_contract_party_pub.create_contact returned with status '||x_return_status
1069: );
1070: END IF;

Line 1081: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_party_contacts');

1077:
1078: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1079:
1080: IF(l_debug_enabled='Y') THEN
1081: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_party_contacts');
1082: END IF;
1083: EXCEPTION
1084: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1085: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1137: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_ARTICLE_CHANGES';

1133: lv_catv_rec catv_rec_type;
1134: x_catv_rec catv_rec_type;
1135: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1136: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_ARTICLE_CHANGES';
1137: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_ARTICLE_CHANGES';
1138: l_debug_enabled VARCHAR2(10);
1139:
1140: BEGIN
1141: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1146: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_article_changes');

1142:
1143: l_debug_enabled := okl_debug_pub.check_log_enabled;
1144:
1145: IF(l_debug_enabled='Y') THEN
1146: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_article_changes');
1147: END IF;
1148:
1149: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1150: x_return_status := OKL_API.START_ACTIVITY(

Line 1184: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1180: ,x_msg_data => x_msg_data
1181: ,p_catv_rec => lv_catv_rec
1182: );
1183: IF(l_debug_enabled='Y') THEN
1184: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1185: l_module,
1186: 'okl_vp_k_article_pub.delete_k_article returned with status '||x_return_status
1187: );
1188: END IF;

Line 1227: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1223: x_msg_data => x_msg_data,
1224: p_catv_rec => lv_catv_rec,
1225: x_catv_rec => x_catv_rec);
1226: IF(l_debug_enabled='Y') THEN
1227: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1228: l_module,
1229: 'okl_okc_migration_a_pvt.insert_row returned with status '||x_return_status
1230: );
1231: END IF;

Line 1260: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1256: ,p_catv_rec => lv_catv_rec
1257: ,x_catv_rec => x_catv_rec
1258: );
1259: IF(l_debug_enabled='Y') THEN
1260: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1261: l_module,
1262: 'okl_vp_k_article_pub.create_k_article returned with status '||x_return_status
1263: );
1264: END IF;

Line 1276: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_article_changes');

1272:
1273: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1274:
1275: IF(l_debug_enabled='Y') THEN
1276: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_article_changes');
1277: END IF;
1278: EXCEPTION
1279: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1280: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1315: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_VENDOR_BILLING';

1311: ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
1312: ) IS
1313: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1314: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_VENDOR_BILLING';
1315: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_VENDOR_BILLING';
1316: l_debug_enabled VARCHAR2(10);
1317:
1318: -- cursor to fetch the rule group role definitions id for the source Vendor
1319: CURSOR c_get_rrd_id_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS

Line 1446: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_vendor_billing');

1442:
1443: l_debug_enabled := okl_debug_pub.check_log_enabled;
1444:
1445: IF(l_debug_enabled='Y') THEN
1446: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_vendor_billing');
1447: END IF;
1448:
1449: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1450: x_return_status := OKL_API.START_ACTIVITY(

Line 1512: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1508: ,p_cplv_rec => lv_cplv_rec
1509: ,x_cplv_rec => x_cplv_rec
1510: );
1511: IF(l_debug_enabled='Y') THEN
1512: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1513: l_module,
1514: 'okl_contract_party_pub.update_k_party_role returned with status '||x_return_status
1515: );
1516: END IF;

Line 1566: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1562: ,p_rrd_id => lv_orig_rrd_id
1563: ,p_rgr_tbl => lv_rgr_tbl
1564: );
1565: IF(l_debug_enabled='Y') THEN
1566: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1567: l_module,
1568: 'okl_rgrp_rules_process_pvt.process_rule_group_rules for customer info returned with status '||x_return_status
1569: );
1570: END IF;

Line 1709: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1705: ,p_rrd_id => lv_orig_rrd_id
1706: ,p_rgr_tbl => lv_rgr_tbl
1707: );
1708: IF(l_debug_enabled='Y') THEN
1709: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1710: l_module,
1711: 'okl_rgrp_rules_process_pvt.process_rule_group_rules for billing info returned with status '||x_return_status
1712: );
1713: END IF;

Line 1724: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_vendor_billing');

1720:
1721: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1722:
1723: IF(l_debug_enabled='Y') THEN
1724: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_vendor_billing');
1725: END IF;
1726:
1727: EXCEPTION
1728: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1829: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_ASSOCIATIONS';

1825: lv_vasv_rec vasv_rec_type;
1826: x_vasv_rec vasv_rec_type;
1827: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1828: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_ASSOCIATIONS';
1829: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_ASSOCIATIONS';
1830: l_debug_enabled VARCHAR2(10);
1831:
1832: BEGIN
1833: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1838: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_associations');

1834:
1835: l_debug_enabled := okl_debug_pub.check_log_enabled;
1836:
1837: IF(l_debug_enabled='Y') THEN
1838: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_associations');
1839: END IF;
1840:
1841: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1842: x_return_status := OKL_API.START_ACTIVITY(

Line 1898: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1894: ,p_vasv_rec => lv_vasv_rec
1895: ,x_vasv_rec => x_vasv_rec
1896: );
1897: IF(l_debug_enabled='Y') THEN
1898: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1899: l_module,
1900: 'okl_vp_associations_pvt.update_vp_associations returned with status '||x_return_status
1901: );
1902: END IF;

Line 1922: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1918: ,x_msg_data => x_msg_data
1919: ,p_vasv_rec => lv_vasv_rec
1920: );
1921: IF(l_debug_enabled='Y') THEN
1922: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1923: l_module,
1924: 'okl_vp_associations_pvt.delete_vp_associations returned with status '||x_return_status
1925: );
1926: END IF;

Line 1955: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1951: ,p_vasv_rec => lv_vasv_rec
1952: ,x_vasv_rec => x_vasv_rec
1953: );
1954: IF(l_debug_enabled='Y') THEN
1955: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1956: l_module,
1957: 'okl_vp_associations_pvt.create_vp_associations returned with status '||x_return_status
1958: );
1959: END IF;

Line 1970: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_associations');

1966:
1967: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1968:
1969: IF(l_debug_enabled='Y') THEN
1970: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_associations');
1971: END IF;
1972: EXCEPTION
1973: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1974: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2072: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_ASSOCIATIONS';

2068: lv_vasv_rec vasv_rec_type;
2069: x_vasv_rec vasv_rec_type;
2070: l_api_version CONSTANT NUMBER DEFAULT 1.0;
2071: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_ASSOCIATIONS';
2072: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_ASSOCIATIONS';
2073: l_debug_enabled VARCHAR2(10);
2074:
2075: BEGIN
2076: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2081: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_associations');

2077:
2078: l_debug_enabled := okl_debug_pub.check_log_enabled;
2079:
2080: IF(l_debug_enabled='Y') THEN
2081: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_associations');
2082: END IF;
2083:
2084: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
2085: x_return_status := OKL_API.START_ACTIVITY(

Line 2135: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2131: ,p_vasv_rec => lv_vasv_rec
2132: ,x_vasv_rec => x_vasv_rec
2133: );
2134: IF(l_debug_enabled='Y') THEN
2135: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2136: l_module,
2137: 'okl_vp_associations_pvt.update_vp_associations returned with status '||x_return_status
2138: );
2139: END IF;

Line 2159: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2155: ,x_msg_data => x_msg_data
2156: ,p_vasv_rec => lv_vasv_rec
2157: );
2158: IF(l_debug_enabled='Y') THEN
2159: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2160: l_module,
2161: 'okl_vp_associations_pvt.delete_vp_associations returned with status '||x_return_status
2162: );
2163: END IF;

Line 2192: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2188: ,p_vasv_rec => lv_vasv_rec
2189: ,x_vasv_rec => x_vasv_rec
2190: );
2191: IF(l_debug_enabled='Y') THEN
2192: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2193: l_module,
2194: 'okl_vp_associations_pvt.create_vp_associations returned with status '||x_return_status
2195: );
2196: END IF;

Line 2207: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_associations');

2203:
2204: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2205:
2206: IF(l_debug_enabled='Y') THEN
2207: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_associations');
2208: END IF;
2209: EXCEPTION
2210: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2211: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2262: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_ELIG_CRITERIA';

2258: x_ecv_tbl ecv_tbl_type;
2259:
2260: l_api_version CONSTANT NUMBER DEFAULT 1.0;
2261: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_ELIG_CRITERIA';
2262: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_ELIG_CRITERIA';
2263: l_debug_enabled VARCHAR2(10);
2264:
2265: BEGIN
2266: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2271: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_elig_criteria');

2267:
2268: l_debug_enabled := okl_debug_pub.check_log_enabled;
2269:
2270: IF(l_debug_enabled='Y') THEN
2271: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_elig_criteria');
2272: END IF;
2273:
2274: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
2275: x_return_status := OKL_API.START_ACTIVITY(

Line 2307: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2303: ,p_source_id => p_orig_chr_id
2304: ,p_source_type => G_VENDOR_PROGRAM_CODE
2305: );
2306: IF(l_debug_enabled='Y') THEN
2307: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2308: l_module,
2309: 'okl_ecc_values_pvt.delete_eligibility_criteria returned with status '||x_return_status
2310: );
2311: END IF;

Line 2332: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2328: ,x_ecl_tbl => lx_ecl_tbl
2329: ,x_ecv_tbl => lx_ecv_tbl
2330: );
2331: IF(l_debug_enabled='Y') THEN
2332: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2333: l_module,
2334: 'okl_ecc_values_pvt.get_eligibility_criteria returned with status '||x_return_status
2335: );
2336: END IF;

Line 2381: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2377: ,p_ecl_tbl => lx_ecl_tbl -- IN
2378: ,p_ecv_tbl => lx_ecv_tbl -- IN
2379: );
2380: IF(l_debug_enabled='Y') THEN
2381: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2382: l_module,
2383: 'okl_ecc_values_pvt.handle_eligibility_criteria returned with status '||x_return_status
2384: );
2385: END IF;

Line 2396: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_elig_criteria');

2392:
2393: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2394:
2395: IF(l_debug_enabled='Y') THEN
2396: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_elig_criteria');
2397: END IF;
2398: EXCEPTION
2399: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2400: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2537: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_TERMS';

2533: lx_new_rg_count NUMBER;
2534:
2535: l_api_version CONSTANT NUMBER DEFAULT 1.0;
2536: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_TERMS';
2537: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_TERMS';
2538: l_debug_enabled VARCHAR2(10);
2539:
2540: FUNCTION get_original_cpl_id(p_new_cpl_id okc_k_party_roles_b.id%TYPE
2541: ,p_orig_chr_id okc_k_headers_b.id%TYPE

Line 2577: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_terms');

2573:
2574: l_debug_enabled := okl_debug_pub.check_log_enabled;
2575:
2576: IF(l_debug_enabled='Y') THEN
2577: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_terms');
2578: END IF;
2579:
2580: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
2581: x_return_status := OKL_API.START_ACTIVITY(

Line 2670: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2666: ,x_rulv_tbl => lx_rulv1_tbl
2667: ,x_rule_count => lx_rulv_count
2668: );
2669: IF(l_debug_enabled='Y') THEN
2670: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2671: l_module,
2672: 'okl_rule_apis_pvt.get_contract_rules returned with status '||x_return_status
2673: );
2674: END IF;

Line 2706: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2702: ,p_chr_id => p_orig_chr_id
2703: ,p_rgd_code => cv_get_comm_rl_rec.rgd_code
2704: );
2705: IF(l_debug_enabled='Y') THEN
2706: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2707: l_module,
2708: 'okl_rgrp_rules_process_pvt.get_header_rule_group_id returned with status '||x_return_status||' lv_rgp_id '||lv_rgp_id
2709: );
2710: END IF;

Line 2774: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2770: ,p_rrd_id => null
2771: ,p_rgr_tbl => lv_rule_info_tbl
2772: );
2773: IF(l_debug_enabled='Y') THEN
2774: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2775: l_module,
2776: 'okl_rgrp_rules_process_pvt.process_rule_group_rules returned with status '||x_return_status
2777: );
2778: END IF;

Line 2802: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2798: ,x_rgpv_tbl => lx_new_rgp_tbl
2799: ,x_rg_count => lx_new_rg_count
2800: );
2801: IF(l_debug_enabled='Y') THEN
2802: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2803: l_module,
2804: 'okl_rule_apis_pvt.get_contract_rgs returned with status '||x_return_status
2805: );
2806: END IF;

Line 2828: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2824: ,p_rgpv_rec => lv_new_rgp_tbl(i)
2825: ,x_rgpv_rec => x_new_rgp_rec
2826: );
2827: IF(l_debug_enabled='Y') THEN
2828: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2829: l_module,
2830: 'okl_okc_migration_pvt.create_rule_group returned with status '||x_return_status
2831: );
2832: END IF;

Line 2859: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2855: ,x_rulv_tbl => lx_rulv2_tbl
2856: ,x_rule_count => lv_rulv2_count
2857: );
2858: IF(l_debug_enabled='Y') THEN
2859: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2860: l_module,
2861: 'okl_rule_apis_pvt.get_contract_rules1 returned with status '||x_return_status
2862: );
2863: END IF;

Line 2897: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

2893: ,p_rulv_tbl => lx_rulv2_tbl
2894: ,x_rulv_tbl => x_rulv2_tbl
2895: );
2896: IF(l_debug_enabled='Y') THEN
2897: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2898: l_module,
2899: 'okl_rule_pub.create_rule returned with status '||x_return_status
2900: );
2901: END IF;

Line 2915: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_terms');

2911:
2912: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2913:
2914: IF(l_debug_enabled='Y') THEN
2915: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_terms');
2916: END IF;
2917: EXCEPTION
2918: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2919: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3014: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_VENDOR_DISB_SETUP';

3010: lv_party_role_id okc_k_party_roles_b.id%TYPE;
3011:
3012: l_api_version CONSTANT NUMBER DEFAULT 1.0;
3013: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_VENDOR_DISB_SETUP';
3014: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_VENDOR_DISB_SETUP';
3015: l_debug_enabled VARCHAR2(10);
3016:
3017: BEGIN
3018: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3023: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_vendor_disb_setup');

3019:
3020: l_debug_enabled := okl_debug_pub.check_log_enabled;
3021:
3022: IF(l_debug_enabled='Y') THEN
3023: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCRSB.pls call sync_vendor_disb_setup');
3024: END IF;
3025:
3026: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
3027: x_return_status := OKL_API.START_ACTIVITY(

Line 3078: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT, l_module, 'okl_subsidy_rfnd_dtls_pvt.update_refund_dtls '|| x_return_status);

3074: ,p_srfvv_rec => lv_srfvv_rec
3075: ,x_srfvv_rec => x_srfvv_rec
3076: );
3077: IF(l_debug_enabled='Y') THEN
3078: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT, l_module, 'okl_subsidy_rfnd_dtls_pvt.update_refund_dtls '|| x_return_status);
3079: END IF;
3080:
3081: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3118: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT, l_module, 'okl_subsidy_rfnd_dtls_pvt.create_refund_dtls '|| x_return_status);

3114: ,p_srfvv_rec => lv_srfvv_rec
3115: ,x_srfvv_rec => x_srfvv_rec
3116: );
3117: IF(l_debug_enabled='Y') THEN
3118: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT, l_module, 'okl_subsidy_rfnd_dtls_pvt.create_refund_dtls '|| x_return_status);
3119: END IF;
3120:
3121: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3129: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT, l_module, 'could not determine the original party on the parent pa '||

3125: END IF;
3126: ELSE
3127: CLOSE c_get_party_role_csr;
3128: IF(l_debug_enabled='Y') THEN
3129: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT, l_module, 'could not determine the original party on the parent pa '||
3130: creq_disb_rec.rle_code||' '||creq_disb_rec.object1_id1||' '||creq_disb_rec.object1_id2||' '||creq_disb_rec.jtot_object1_code );
3131: END IF;
3132: -- need to log here because this is an exception case - unable to find the original party on the PA
3133: END IF; -- end of c_get_party_role_csr%FOUND

Line 3141: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_vendor_disb_setup');

3137:
3138: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
3139:
3140: IF(l_debug_enabled='Y') THEN
3141: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCRSB.pls call sync_vendor_disb_setup');
3142: END IF;
3143:
3144: EXCEPTION
3145: WHEN OKL_API.G_EXCEPTION_ERROR THEN