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.OKC_ART_BLK_PVT dependencies on OKC_DEBUG

Line 111: okc_debug.log('201: Leaving get_uniq_id: Unknown error');

107: EXCEPTION
108: WHEN OTHERS THEN
109:
110: IF (l_debug = 'Y') THEN
111: okc_debug.log('201: Leaving get_uniq_id: Unknown error');
112: END IF;
113:
114: IF (c1%ISOPEN) THEN
115: CLOSE c1;

Line 152: okc_debug.log('100: Entering get_version_details: p_org_id='||p_org_id);

148:
149: BEGIN
150:
151: IF (l_debug = 'Y') THEN
152: okc_debug.log('100: Entering get_version_details: p_org_id='||p_org_id);
153: END IF;
154:
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156: IF (p_art_ver_tbl IS NULL ) THEN

Line 277: okc_debug.log('198: l_total_count='||l_total_count||' p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);

273:
274: IF (l_total_count <> p_art_ver_tbl.COUNT) THEN
275:
276: IF (l_debug = 'Y') THEN
277: okc_debug.log('198: l_total_count='||l_total_count||' p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
278: okc_debug.log('199: This indicates that some article versions belonged to an org other than input org='||p_org_id);
279: END IF;
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);

Line 278: okc_debug.log('199: This indicates that some article versions belonged to an org other than input org='||p_org_id);

274: IF (l_total_count <> p_art_ver_tbl.COUNT) THEN
275:
276: IF (l_debug = 'Y') THEN
277: okc_debug.log('198: l_total_count='||l_total_count||' p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
278: okc_debug.log('199: This indicates that some article versions belonged to an org other than input org='||p_org_id);
279: END IF;
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
282: FND_MESSAGE.set_token('ARG_NAME', 'p_org_id');

Line 289: okc_debug.log('200: Leaving get_version_details: Success, x_id='||x_id||' x_adopt_asis_count='|| x_adopt_asis_count||' x_global_count='|| x_global_count|| ' x_localized_count='||x_localized_count);

285: RAISE fnd_api.g_exc_error;
286: END IF;
287:
288: IF (l_debug = 'Y') THEN
289: okc_debug.log('200: Leaving get_version_details: Success, x_id='||x_id||' x_adopt_asis_count='|| x_adopt_asis_count||' x_global_count='|| x_global_count|| ' x_localized_count='||x_localized_count);
290: END IF;
291:
292: EXCEPTION
293:

Line 301: okc_debug.log('201: Leaving get_version_details: Error');

297: CLOSE l_count_csr;
298: END IF;
299:
300: IF (l_debug = 'Y') THEN
301: okc_debug.log('201: Leaving get_version_details: Error');
302: END IF;
303:
304: WHEN OTHERS THEN
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 311: okc_debug.log('202: Leaving get_version_details: Unknown error');

307: CLOSE l_count_csr;
308: END IF;
309:
310: IF (l_debug = 'Y') THEN
311: okc_debug.log('202: Leaving get_version_details: Unknown error');
312: END IF;
313:
314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
315: THEN

Line 391: okc_debug.log('100: Entering status_check_blk: p_id='||p_id||' p_to_status='||p_to_status);

387:
388: BEGIN
389:
390: IF (l_debug = 'Y') THEN
391: okc_debug.log('100: Entering status_check_blk: p_id='||p_id||' p_to_status='||p_to_status);
392: END IF;
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394: x_qa_return_status := FND_API.G_RET_STS_SUCCESS;
395:

Line 474: okc_debug.log('200: Leaving status_check_blk: Success, x_qa_return_status='||x_qa_return_status);

470: x_qa_return_status := FND_API.G_RET_STS_ERROR;
471: END IF;
472:
473: IF (l_debug = 'Y') THEN
474: okc_debug.log('200: Leaving status_check_blk: Success, x_qa_return_status='||x_qa_return_status);
475: END IF;
476:
477: EXCEPTION
478:

Line 482: okc_debug.log('201: Leaving status_check_blk: Error');

478:
479: WHEN FND_API.G_EXC_ERROR THEN
480: x_return_status := FND_API.G_RET_STS_ERROR ;
481: IF (l_debug = 'Y') THEN
482: okc_debug.log('201: Leaving status_check_blk: Error');
483: END IF;
484: IF (l_pend_app_csr%ISOPEN) THEN
485: CLOSE l_pend_app_csr;
486: END IF;

Line 498: okc_debug.log('202: Leaving status_check_blk: Unknown Error');

494: WHEN OTHERS THEN
495:
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: IF (l_debug = 'Y') THEN
498: okc_debug.log('202: Leaving status_check_blk: Unknown Error');
499: END IF;
500: IF (l_pend_app_csr%ISOPEN) THEN
501: CLOSE l_pend_app_csr;
502: END IF;

Line 575: okc_debug.log('100: Entering variable_check_blk: p_id='||p_id);

571:
572: BEGIN
573:
574: IF (l_debug = 'Y') THEN
575: okc_debug.log('100: Entering variable_check_blk: p_id='||p_id);
576: END IF;
577: x_return_status := FND_API.G_RET_STS_SUCCESS;
578: x_qa_return_status := FND_API.G_RET_STS_SUCCESS;
579:

Line 642: okc_debug.log('200: Leaving variable_check_blk: Success, x_qa_return_status='||x_qa_return_status);

638: x_qa_return_status := FND_API.G_RET_STS_ERROR;
639: END IF;
640:
641: IF (l_debug = 'Y') THEN
642: okc_debug.log('200: Leaving variable_check_blk: Success, x_qa_return_status='||x_qa_return_status);
643: END IF;
644:
645: EXCEPTION
646:

Line 651: okc_debug.log('202: Leaving variable_check_blk: Unknown Error');

647: WHEN OTHERS THEN
648:
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: IF (l_debug = 'Y') THEN
651: okc_debug.log('202: Leaving variable_check_blk: Unknown Error');
652: END IF;
653: IF (l_disabled_var_csr%ISOPEN) THEN
654: CLOSE l_disabled_var_csr;
655: END IF;

Line 720: okc_debug.log('100: Entering section_type_check_blk: p_id='||p_id);

716:
717: BEGIN
718:
719: IF (l_debug = 'Y') THEN
720: okc_debug.log('100: Entering section_type_check_blk: p_id='||p_id);
721: END IF;
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723: x_qa_return_status := FND_API.G_RET_STS_SUCCESS;
724:

Line 783: okc_debug.log('200: Leaving section_type_check_blk: Success, x_qa_return_status='||x_qa_return_status);

779: x_qa_return_status := FND_API.G_RET_STS_ERROR;
780: END IF;
781:
782: IF (l_debug = 'Y') THEN
783: okc_debug.log('200: Leaving section_type_check_blk: Success, x_qa_return_status='||x_qa_return_status);
784: END IF;
785:
786: EXCEPTION
787:

Line 792: okc_debug.log('201: Leaving section_type_check_blk: Unknown Error');

788: WHEN OTHERS THEN
789:
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: IF (l_debug = 'Y') THEN
792: okc_debug.log('201: Leaving section_type_check_blk: Unknown Error');
793: END IF;
794: IF (l_art_typ_csr%ISOPEN) THEN
795: CLOSE l_art_typ_csr;
796: END IF;

Line 821: okc_debug.log('100: Entering update_art_version_status_blk: p_id='||p_id||' p_status='||p_status);

817:
818: BEGIN
819:
820: IF (l_debug = 'Y') THEN
821: okc_debug.log('100: Entering update_art_version_status_blk: p_id='||p_id||' p_status='||p_status);
822: END IF;
823:
824: x_return_status := FND_API.G_RET_STS_SUCCESS;
825:

Line 858: okc_debug.log('200: Leaving update_art_version_status_blk: Success');

854:
855: END IF;
856:
857: IF (l_debug = 'Y') THEN
858: okc_debug.log('200: Leaving update_art_version_status_blk: Success');
859: END IF;
860:
861: EXCEPTION
862:

Line 866: okc_debug.log('201: Leaving update_art_version_status_blk: Unknown Error');

862:
863: WHEN OTHERS THEN
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: IF (l_debug = 'Y') THEN
866: okc_debug.log('201: Leaving update_art_version_status_blk: Unknown Error');
867: END IF;
868:
869: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
870: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );

Line 892: okc_debug.log('100: Entering update_adp_status_type_blk: p_id='||p_id||' p_local_org_id='||p_local_org_id||' p_adoption_status='||p_adoption_status||' p_adoption_type='||p_adoption_type||' p_type='||p_type);

888:
889: BEGIN
890:
891: IF (l_debug = 'Y') THEN
892: okc_debug.log('100: Entering update_adp_status_type_blk: p_id='||p_id||' p_local_org_id='||p_local_org_id||' p_adoption_status='||p_adoption_status||' p_adoption_type='||p_adoption_type||' p_type='||p_type);
893: END IF;
894:
895: x_return_status := FND_API.G_RET_STS_SUCCESS;
896:

Line 941: okc_debug.log('200: Leaving update_adp_status_type_blk: Success');

937:
938: END IF;
939:
940: IF (l_debug = 'Y') THEN
941: okc_debug.log('200: Leaving update_adp_status_type_blk: Success');
942: END IF;
943:
944: EXCEPTION
945:

Line 949: okc_debug.log('201: Leaving update_adp_status_type_blk: Error');

945:
946: WHEN FND_API.G_EXC_ERROR THEN
947: x_return_status := FND_API.G_RET_STS_ERROR;
948: IF (l_debug = 'Y') THEN
949: okc_debug.log('201: Leaving update_adp_status_type_blk: Error');
950: END IF;
951:
952: WHEN OTHERS THEN
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 955: okc_debug.log('202: Leaving update_adp_status_type_blk: Unknown Error');

951:
952: WHEN OTHERS THEN
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: IF (l_debug = 'Y') THEN
955: okc_debug.log('202: Leaving update_adp_status_type_blk: Unknown Error');
956: END IF;
957:
958: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
959: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );

Line 997: okc_debug.log('100: Entering update_prev_vers_enddate_blk: p_id='||p_id);

993:
994: BEGIN
995:
996: IF (l_debug = 'Y') THEN
997: okc_debug.log('100: Entering update_prev_vers_enddate_blk: p_id='||p_id);
998: END IF;
999:
1000: x_return_status := FND_API.G_RET_STS_SUCCESS;
1001:

Line 1027: okc_debug.log('200: Leaving update_prev_vers_enddate_blk: Success');

1023: l_prev_ver_id_tbl.DELETE;
1024: l_start_date_tbl.DELETE;
1025:
1026: IF (l_debug = 'Y') THEN
1027: okc_debug.log('200: Leaving update_prev_vers_enddate_blk: Success');
1028: END IF;
1029:
1030: EXCEPTION
1031:

Line 1038: okc_debug.log('201: Leaving update_prev_vers_enddate_blk: Unknown Error');

1034: IF (l_prev_ver_csr%ISOPEN) THEN
1035: CLOSE l_prev_ver_csr;
1036: END IF;
1037: IF (l_debug = 'Y') THEN
1038: okc_debug.log('201: Leaving update_prev_vers_enddate_blk: Unknown Error');
1039: END IF;
1040:
1041: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1042: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );

Line 1072: okc_debug.log('100: Entering adopt_relationships_blk: p_id='||p_id);

1068:
1069: BEGIN
1070:
1071: IF (l_debug = 'Y') THEN
1072: okc_debug.log('100: Entering adopt_relationships_blk: p_id='||p_id);
1073: END IF;
1074: x_return_status := FND_API.G_RET_STS_SUCCESS;
1075:
1076: INSERT INTO OKC_ARTICLE_RELATNS_ALL

Line 1158: okc_debug.log('200: Leaving adopt_relationships_blk: Success');

1154: ARL1.org_id = TMP.org_id);
1155:
1156:
1157: IF (l_debug = 'Y') THEN
1158: okc_debug.log('200: Leaving adopt_relationships_blk: Success');
1159: END IF;
1160:
1161: EXCEPTION
1162:

Line 1167: okc_debug.log('201: Leaving adopt_relationships_blk: Unknown Error');

1163: WHEN OTHERS THEN
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165:
1166: IF (l_debug = 'Y') THEN
1167: okc_debug.log('201: Leaving adopt_relationships_blk: Unknown Error');
1168: END IF;
1169:
1170: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1171: THEN

Line 1199: okc_debug.log('100: Entering delete_relationships_blk: p_id='||p_id||' p_org_id='||p_org_id);

1195:
1196: BEGIN
1197:
1198: IF (l_debug = 'Y') THEN
1199: okc_debug.log('100: Entering delete_relationships_blk: p_id='||p_id||' p_org_id='||p_org_id);
1200: END IF;
1201:
1202: x_return_status := FND_API.G_RET_STS_SUCCESS;
1203:

Line 1251: okc_debug.log('200: Leaving delete_relationships_blk: Success');

1247: l_art_id_tbl.DELETE;
1248: l_art_ver_id_tbl.DELETE;
1249:
1250: IF (l_debug = 'Y') THEN
1251: okc_debug.log('200: Leaving delete_relationships_blk: Success');
1252: END IF;
1253:
1254: EXCEPTION
1255:

Line 1263: okc_debug.log('201: Leaving delete_relationships_blk: Unknown error');

1259: CLOSE l_art_id_csr;
1260: END IF;
1261:
1262: IF (l_debug = 'Y') THEN
1263: okc_debug.log('201: Leaving delete_relationships_blk: Unknown error');
1264: END IF;
1265:
1266: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1267: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );

Line 1327: okc_debug.log('100: Entering validate_article_versions_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit);

1323:
1324: BEGIN
1325:
1326: IF (l_debug = 'Y') THEN
1327: okc_debug.log('100: Entering validate_article_versions_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit);
1328:
1329: okc_debug.log('101: In validate_article_versions_blk: p_validation_level='|| p_validation_level||' p_org_id='||p_org_id||' p_id='||p_id);
1330:
1331: IF (p_art_ver_tbl IS NOT NULL) THEN

Line 1329: okc_debug.log('101: In validate_article_versions_blk: p_validation_level='|| p_validation_level||' p_org_id='||p_org_id||' p_id='||p_id);

1325:
1326: IF (l_debug = 'Y') THEN
1327: okc_debug.log('100: Entering validate_article_versions_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit);
1328:
1329: okc_debug.log('101: In validate_article_versions_blk: p_validation_level='|| p_validation_level||' p_org_id='||p_org_id||' p_id='||p_id);
1330:
1331: IF (p_art_ver_tbl IS NOT NULL) THEN
1332: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
1333: FOR i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST LOOP

Line 1332: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);

1328:
1329: okc_debug.log('101: In validate_article_versions_blk: p_validation_level='|| p_validation_level||' p_org_id='||p_org_id||' p_id='||p_id);
1330:
1331: IF (p_art_ver_tbl IS NOT NULL) THEN
1332: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
1333: FOR i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST LOOP
1334: okc_debug.log('103: p_art_ver_tbl['||i||']='||p_art_ver_tbl(i));
1335: END LOOP;
1336: END IF;

Line 1334: okc_debug.log('103: p_art_ver_tbl['||i||']='||p_art_ver_tbl(i));

1330:
1331: IF (p_art_ver_tbl IS NOT NULL) THEN
1332: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
1333: FOR i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST LOOP
1334: okc_debug.log('103: p_art_ver_tbl['||i||']='||p_art_ver_tbl(i));
1335: END LOOP;
1336: END IF;
1337: END IF;
1338:

Line 1433: okc_debug.log('104: Calling OKC_ADOPTIONS_GRP.check_adoption_details p_global_article_version_id='||l_adopt_asis_art_ver_id_tbl(i)|| ' p_adoption_type=ADOPTED p_local_org_id='||p_org_id);

1429: l_msg_data := 0;
1430: l_earlier_local_version_id := 0;
1431:
1432: IF (l_debug = 'Y') THEN
1433: okc_debug.log('104: Calling OKC_ADOPTIONS_GRP.check_adoption_details p_global_article_version_id='||l_adopt_asis_art_ver_id_tbl(i)|| ' p_adoption_type=ADOPTED p_local_org_id='||p_org_id);
1434: END IF;
1435:
1436: OKC_ADOPTIONS_GRP.check_adoption_details(
1437: p_api_version => 1.0,

Line 1450: okc_debug.log('105: After OKC_ADOPTIONS_GRP.check_adoption_details x_return_status='||l_local_result_status);

1446: p_local_org_id => p_org_id
1447: );
1448:
1449: IF (l_debug = 'Y') THEN
1450: okc_debug.log('105: After OKC_ADOPTIONS_GRP.check_adoption_details x_return_status='||l_local_result_status);
1451: END IF;
1452:
1453: IF (l_local_result_status = FND_API.G_RET_STS_ERROR) THEN -- the check failed
1454: x_qa_return_status := FND_API.G_RET_STS_ERROR;

Line 1508: okc_debug.log('200: Leaving validate_article_versions_blk: Success');

1504: COMMIT WORK;
1505: END IF;
1506:
1507: IF (l_debug = 'Y') THEN
1508: okc_debug.log('200: Leaving validate_article_versions_blk: Success');
1509: END IF;
1510:
1511:
1512: EXCEPTION

Line 1520: okc_debug.log('201: Leaving validate_article_versions_blk: Error');

1516: ROLLBACK TO val_article_versions_blk_PVT;
1517: x_return_status := FND_API.G_RET_STS_ERROR ;
1518:
1519: IF (l_debug = 'Y') THEN
1520: okc_debug.log('201: Leaving validate_article_versions_blk: Error');
1521: END IF;
1522:
1523: IF (l_adopt_as_is_csr%ISOPEN) THEN
1524: CLOSE l_adopt_as_is_csr;

Line 1534: okc_debug.log('202: Leaving validate_article_versions_blk: Unexpected Error');

1530: ROLLBACK TO val_article_versions_blk_PVT;
1531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1532:
1533: IF (l_debug = 'Y') THEN
1534: okc_debug.log('202: Leaving validate_article_versions_blk: Unexpected Error');
1535: END IF;
1536:
1537: IF (l_adopt_as_is_csr%ISOPEN) THEN
1538: CLOSE l_adopt_as_is_csr;

Line 1548: okc_debug.log('203: Leaving validate_article_versions_blk: Unknown Error');

1544: ROLLBACK TO val_article_versions_blk_PVT;
1545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1546:
1547: IF (l_debug = 'Y') THEN
1548: okc_debug.log('203: Leaving validate_article_versions_blk: Unknown Error');
1549: END IF;
1550:
1551: IF (l_adopt_as_is_csr%ISOPEN) THEN
1552: CLOSE l_adopt_as_is_csr;

Line 1608: okc_debug.log('100: Entering auto_adopt_articles_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit||' p_id='||p_id);

1604:
1605: BEGIN
1606:
1607: IF (l_debug = 'Y') THEN
1608: okc_debug.log('100: Entering auto_adopt_articles_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit||' p_id='||p_id);
1609: END IF;
1610:
1611: -- standard initialization code
1612: SAVEPOINT auto_adopt_articles_blk_PVT;

Line 1728: okc_debug.log('200: Leaving auto_adopt_articles_blk: Success');

1724: COMMIT;
1725: END IF;
1726:
1727: IF (l_debug = 'Y') THEN
1728: okc_debug.log('200: Leaving auto_adopt_articles_blk: Success');
1729: END IF;
1730:
1731: EXCEPTION
1732:

Line 1738: okc_debug.log('201: Leaving auto_adopt_articles_blk: Error');

1734: ROLLBACK TO auto_adopt_articles_blk_PVT;
1735: x_return_status := FND_API.G_RET_STS_ERROR ;
1736:
1737: IF (l_debug = 'Y') THEN
1738: okc_debug.log('201: Leaving auto_adopt_articles_blk: Error');
1739: END IF;
1740: IF (l_org_info_csr%ISOPEN) THEN
1741: CLOSE l_org_info_csr;
1742: END IF;

Line 1753: okc_debug.log('202: Leaving auto_adopt_articles_blk: Unexpected Error');

1749: ROLLBACK TO auto_adopt_articles_blk_PVT;
1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1751:
1752: IF (l_debug = 'Y') THEN
1753: okc_debug.log('202: Leaving auto_adopt_articles_blk: Unexpected Error');
1754: END IF;
1755: IF (l_org_info_csr%ISOPEN) THEN
1756: CLOSE l_org_info_csr;
1757: END IF;

Line 1768: okc_debug.log('203: Leaving auto_adopt_articles_blk: Unknown Error');

1764: ROLLBACK TO auto_adopt_articles_blk_PVT;
1765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1766:
1767: IF (l_debug = 'Y') THEN
1768: okc_debug.log('203: Leaving auto_adopt_articles_blk: Unknown Error');
1769: END IF;
1770: IF (l_org_info_csr%ISOPEN) THEN
1771: CLOSE l_org_info_csr;
1772: END IF;

Line 1818: okc_debug.log('100: Entering pending_approval_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit);

1814:
1815: BEGIN
1816:
1817: IF (l_debug = 'Y') THEN
1818: okc_debug.log('100: Entering pending_approval_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit);
1819:
1820: okc_debug.log('101: In pending_approval_blk: p_validation_level='|| p_validation_level||' p_org_id='||p_org_id);
1821:
1822: IF (p_art_ver_tbl IS NOT NULL) THEN

Line 1820: okc_debug.log('101: In pending_approval_blk: p_validation_level='|| p_validation_level||' p_org_id='||p_org_id);

1816:
1817: IF (l_debug = 'Y') THEN
1818: okc_debug.log('100: Entering pending_approval_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit);
1819:
1820: okc_debug.log('101: In pending_approval_blk: p_validation_level='|| p_validation_level||' p_org_id='||p_org_id);
1821:
1822: IF (p_art_ver_tbl IS NOT NULL) THEN
1823: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
1824: FOR i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST LOOP

Line 1823: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);

1819:
1820: okc_debug.log('101: In pending_approval_blk: p_validation_level='|| p_validation_level||' p_org_id='||p_org_id);
1821:
1822: IF (p_art_ver_tbl IS NOT NULL) THEN
1823: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
1824: FOR i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST LOOP
1825: okc_debug.log('103: p_art_ver_tbl['||i||']='||p_art_ver_tbl(i));
1826: END LOOP;
1827: END IF;

Line 1825: okc_debug.log('103: p_art_ver_tbl['||i||']='||p_art_ver_tbl(i));

1821:
1822: IF (p_art_ver_tbl IS NOT NULL) THEN
1823: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
1824: FOR i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST LOOP
1825: okc_debug.log('103: p_art_ver_tbl['||i||']='||p_art_ver_tbl(i));
1826: END LOOP;
1827: END IF;
1828: END IF;
1829:

Line 2020: okc_debug.log('200: Leaving pending_approval_blk: Success');

2016: COMMIT;
2017: END IF;
2018:
2019: IF (l_debug = 'Y') THEN
2020: okc_debug.log('200: Leaving pending_approval_blk: Success');
2021: END IF;
2022:
2023: EXCEPTION
2024:

Line 2030: okc_debug.log('201: Leaving pending_approval_blk: Error');

2026: ROLLBACK TO pending_approval_blk_PVT;
2027: x_return_status := FND_API.G_RET_STS_ERROR ;
2028:
2029: IF (l_debug = 'Y') THEN
2030: okc_debug.log('201: Leaving pending_approval_blk: Error');
2031: END IF;
2032: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2033:
2034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2039: okc_debug.log('202: Leaving pending_approval_blk: Unexpected Error');

2035: ROLLBACK TO pending_approval_blk_PVT;
2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2037:
2038: IF (l_debug = 'Y') THEN
2039: okc_debug.log('202: Leaving pending_approval_blk: Unexpected Error');
2040: END IF;
2041:
2042: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2043:

Line 2049: okc_debug.log('203: Leaving pending_approval_blk: Unknown Error');

2045: ROLLBACK TO pending_approval_blk_PVT;
2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2047:
2048: IF (l_debug = 'Y') THEN
2049: okc_debug.log('203: Leaving pending_approval_blk: Unknown Error');
2050: END IF;
2051:
2052: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2053: THEN

Line 2088: okc_debug.log('100: Entering approve_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit);

2084:
2085: BEGIN
2086:
2087: IF (l_debug = 'Y') THEN
2088: okc_debug.log('100: Entering approve_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit);
2089:
2090: okc_debug.log('101: In approve_blk: p_org_id='||p_org_id);
2091:
2092: IF (p_art_ver_tbl IS NOT NULL) THEN

Line 2090: okc_debug.log('101: In approve_blk: p_org_id='||p_org_id);

2086:
2087: IF (l_debug = 'Y') THEN
2088: okc_debug.log('100: Entering approve_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit);
2089:
2090: okc_debug.log('101: In approve_blk: p_org_id='||p_org_id);
2091:
2092: IF (p_art_ver_tbl IS NOT NULL) THEN
2093: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
2094: FOR i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST LOOP

Line 2093: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);

2089:
2090: okc_debug.log('101: In approve_blk: p_org_id='||p_org_id);
2091:
2092: IF (p_art_ver_tbl IS NOT NULL) THEN
2093: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
2094: FOR i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST LOOP
2095: okc_debug.log('103: p_art_ver_tbl['||i||']='||p_art_ver_tbl(i));
2096: END LOOP;
2097: END IF;

Line 2095: okc_debug.log('103: p_art_ver_tbl['||i||']='||p_art_ver_tbl(i));

2091:
2092: IF (p_art_ver_tbl IS NOT NULL) THEN
2093: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
2094: FOR i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST LOOP
2095: okc_debug.log('103: p_art_ver_tbl['||i||']='||p_art_ver_tbl(i));
2096: END LOOP;
2097: END IF;
2098: END IF;
2099:

Line 2257: okc_debug.log('200: Leaving approve_blk: Success');

2253: COMMIT;
2254: END IF;
2255:
2256: IF (l_debug = 'Y') THEN
2257: okc_debug.log('200: Leaving approve_blk: Success');
2258: END IF;
2259:
2260:
2261: EXCEPTION

Line 2268: okc_debug.log('201: Leaving approve_blk: Error');

2264: ROLLBACK TO approve_blk_PVT;
2265: x_return_status := FND_API.G_RET_STS_ERROR ;
2266:
2267: IF (l_debug = 'Y') THEN
2268: okc_debug.log('201: Leaving approve_blk: Error');
2269: END IF;
2270: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2271:
2272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2277: okc_debug.log('202: Leaving approve_blk: Unexpected Error');

2273: ROLLBACK TO approve_blk_PVT;
2274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2275:
2276: IF (l_debug = 'Y') THEN
2277: okc_debug.log('202: Leaving approve_blk: Unexpected Error');
2278: END IF;
2279: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2280:
2281: WHEN OTHERS THEN

Line 2286: okc_debug.log('203: Leaving approve_blk: Unknown Error');

2282: ROLLBACK TO approve_blk_PVT;
2283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2284:
2285: IF (l_debug = 'Y') THEN
2286: okc_debug.log('203: Leaving approve_blk: Unknown Error');
2287: END IF;
2288:
2289: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2290: THEN

Line 2325: okc_debug.log('100: Entering reject_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit);

2321:
2322: BEGIN
2323:
2324: IF (l_debug = 'Y') THEN
2325: okc_debug.log('100: Entering reject_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit);
2326:
2327: okc_debug.log('101: In reject_blk: p_org_id='||p_org_id);
2328:
2329: IF (p_art_ver_tbl IS NOT NULL) THEN

Line 2327: okc_debug.log('101: In reject_blk: p_org_id='||p_org_id);

2323:
2324: IF (l_debug = 'Y') THEN
2325: okc_debug.log('100: Entering reject_blk: p_api_version='||p_api_version||' p_init_msg_list='||p_init_msg_list||' p_commit='||p_commit);
2326:
2327: okc_debug.log('101: In reject_blk: p_org_id='||p_org_id);
2328:
2329: IF (p_art_ver_tbl IS NOT NULL) THEN
2330: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
2331: FOR i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST LOOP

Line 2330: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);

2326:
2327: okc_debug.log('101: In reject_blk: p_org_id='||p_org_id);
2328:
2329: IF (p_art_ver_tbl IS NOT NULL) THEN
2330: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
2331: FOR i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST LOOP
2332: okc_debug.log('103: p_art_ver_tbl['||i||']='||p_art_ver_tbl(i));
2333: END LOOP;
2334: END IF;

Line 2332: okc_debug.log('103: p_art_ver_tbl['||i||']='||p_art_ver_tbl(i));

2328:
2329: IF (p_art_ver_tbl IS NOT NULL) THEN
2330: okc_debug.log('102: p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
2331: FOR i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST LOOP
2332: okc_debug.log('103: p_art_ver_tbl['||i||']='||p_art_ver_tbl(i));
2333: END LOOP;
2334: END IF;
2335: END IF;
2336:

Line 2472: okc_debug.log('200: Leaving reject_blk: Success');

2468: COMMIT;
2469: END IF;
2470:
2471: IF (l_debug = 'Y') THEN
2472: okc_debug.log('200: Leaving reject_blk: Success');
2473: END IF;
2474:
2475:
2476: EXCEPTION

Line 2483: okc_debug.log('201: Leaving reject_blk: Error');

2479: ROLLBACK TO reject_blk_PVT;
2480: x_return_status := FND_API.G_RET_STS_ERROR ;
2481:
2482: IF (l_debug = 'Y') THEN
2483: okc_debug.log('201: Leaving reject_blk: Error');
2484: END IF;
2485:
2486: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2487:

Line 2493: okc_debug.log('202: Leaving reject_blk: Unexpected Error');

2489: ROLLBACK TO reject_blk_PVT;
2490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2491:
2492: IF (l_debug = 'Y') THEN
2493: okc_debug.log('202: Leaving reject_blk: Unexpected Error');
2494: END IF;
2495:
2496: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2497:

Line 2503: okc_debug.log('203: Leaving reject_blk: Unknown Error');

2499: ROLLBACK TO reject_blk_PVT;
2500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2501:
2502: IF (l_debug = 'Y') THEN
2503: okc_debug.log('203: Leaving reject_blk: Unknown Error');
2504: END IF;
2505:
2506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2507: THEN