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_ARTICLES_IMPORT_GRP dependencies on OKC_DEBUG

Line 390: okc_debug.log('500: Leaving post_wrap_up because of EXCEPTION: '||sqlerrm, 2);

386:
387: EXCEPTION
388: WHEN OTHERS THEN
389: IF (l_debug = 'Y') THEN
390: okc_debug.log('500: Leaving post_wrap_up because of EXCEPTION: '||sqlerrm, 2);
391: END IF;
392: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
393: p_msg_name => G_UNEXPECTED_ERROR,
394: p_token1 => G_SQLCODE_TOKEN,

Line 559: okc_debug.Set_Indentation(l_api_name);

555:
556: BEGIN
557:
558: IF (l_debug = 'Y') THEN
559: okc_debug.Set_Indentation(l_api_name);
560: okc_debug.Log('10: Entering ',2);
561: END IF;
562:
563: mo_global.set_policy_context('M', NULL);

Line 560: okc_debug.Log('10: Entering ',2);

556: BEGIN
557:
558: IF (l_debug = 'Y') THEN
559: okc_debug.Set_Indentation(l_api_name);
560: okc_debug.Log('10: Entering ',2);
561: END IF;
562:
563: mo_global.set_policy_context('M', NULL);
564:

Line 680: okc_debug.Log('1000: Leaving ',2);

676: END LOOP;
677:
678:
679: IF (l_debug = 'Y') THEN
680: okc_debug.Log('1000: Leaving ',2);
681: okc_debug.Reset_Indentation;
682: END IF;
683:
684: EXCEPTION

Line 681: okc_debug.Reset_Indentation;

677:
678:
679: IF (l_debug = 'Y') THEN
680: okc_debug.Log('1000: Leaving ',2);
681: okc_debug.Reset_Indentation;
682: END IF;
683:
684: EXCEPTION
685: WHEN FND_API.G_EXC_ERROR THEN

Line 696: okc_debug.Log('3000: Leaving ',2);

692: END IF;
693: FND_MSG_PUB.initialize;
694:
695: IF (l_debug = 'Y') THEN
696: okc_debug.Log('3000: Leaving ',2);
697: okc_debug.Reset_Indentation;
698: END IF;
699: WHEN OTHERS THEN
700: retcode := 2;

Line 697: okc_debug.Reset_Indentation;

693: FND_MSG_PUB.initialize;
694:
695: IF (l_debug = 'Y') THEN
696: okc_debug.Log('3000: Leaving ',2);
697: okc_debug.Reset_Indentation;
698: END IF;
699: WHEN OTHERS THEN
700: retcode := 2;
701: errbuf := substr(sqlerrm,1,200);

Line 704: okc_debug.Log('5000: Leaving due to an Unexpected Exception',2);

700: retcode := 2;
701: errbuf := substr(sqlerrm,1,200);
702: rollback;
703: IF (l_debug = 'Y') THEN
704: okc_debug.Log('5000: Leaving due to an Unexpected Exception',2);
705: okc_debug.Reset_Indentation;
706: END IF;
707: END conc_purge_interface;
708:

Line 705: okc_debug.Reset_Indentation;

701: errbuf := substr(sqlerrm,1,200);
702: rollback;
703: IF (l_debug = 'Y') THEN
704: okc_debug.Log('5000: Leaving due to an Unexpected Exception',2);
705: okc_debug.Reset_Indentation;
706: END IF;
707: END conc_purge_interface;
708:
709:

Line 780: okc_debug.Set_Indentation(l_api_name);

776:
777:
778: BEGIN
779: IF (l_debug = 'Y') THEN
780: okc_debug.Set_Indentation(l_api_name);
781: okc_debug.Log('10: Entering ',2);
782: END IF;
783:
784: mo_global.set_policy_context('M', NULL);

Line 781: okc_debug.Log('10: Entering ',2);

777:
778: BEGIN
779: IF (l_debug = 'Y') THEN
780: okc_debug.Set_Indentation(l_api_name);
781: okc_debug.Log('10: Entering ',2);
782: END IF;
783:
784: mo_global.set_policy_context('M', NULL);
785:

Line 922: okc_debug.Log('1000: Leaving conc_import_articles',2);

918: RAISE OKC_API.G_EXCEPTION_ERROR;
919: END IF;
920:
921: IF (l_debug = 'Y') THEN
922: okc_debug.Log('1000: Leaving conc_import_articles',2);
923: okc_debug.Reset_Indentation;
924: END IF;
925: x_return_status := G_RET_STS_SUCCESS;
926:

Line 923: okc_debug.Reset_Indentation;

919: END IF;
920:
921: IF (l_debug = 'Y') THEN
922: okc_debug.Log('1000: Leaving conc_import_articles',2);
923: okc_debug.Reset_Indentation;
924: END IF;
925: x_return_status := G_RET_STS_SUCCESS;
926:
927: EXCEPTION

Line 938: okc_debug.Log('3000: Leaving conc_import_articles',2);

934: END IF;
935: FND_MSG_PUB.initialize;
936:
937: IF (l_debug = 'Y') THEN
938: okc_debug.Log('3000: Leaving conc_import_articles',2);
939: okc_debug.Reset_Indentation;
940: END IF;
941: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
942: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 939: okc_debug.Reset_Indentation;

935: FND_MSG_PUB.initialize;
936:
937: IF (l_debug = 'Y') THEN
938: okc_debug.Log('3000: Leaving conc_import_articles',2);
939: okc_debug.Reset_Indentation;
940: END IF;
941: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
942: x_return_status := G_RET_STS_UNEXP_ERROR;
943: IF FND_MSG_PUB.Count_Msg > 0 Then

Line 950: okc_debug.Log('4000: Leaving conc_import_articles',2);

946: END LOOP;
947: END IF;
948: FND_MSG_PUB.initialize;
949: IF (l_debug = 'Y') THEN
950: okc_debug.Log('4000: Leaving conc_import_articles',2);
951: okc_debug.Reset_Indentation;
952: END IF;
953:
954: WHEN OTHERS THEN

Line 951: okc_debug.Reset_Indentation;

947: END IF;
948: FND_MSG_PUB.initialize;
949: IF (l_debug = 'Y') THEN
950: okc_debug.Log('4000: Leaving conc_import_articles',2);
951: okc_debug.Reset_Indentation;
952: END IF;
953:
954: WHEN OTHERS THEN
955: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 963: okc_debug.Log('5000: Leaving conc_import_articles',2);

959: END LOOP;
960: END IF;
961: FND_MSG_PUB.initialize;
962: IF (l_debug = 'Y') THEN
963: okc_debug.Log('5000: Leaving conc_import_articles',2);
964: okc_debug.Reset_Indentation;
965: END IF;
966: END ;
967: BEGIN

Line 964: okc_debug.Reset_Indentation;

960: END IF;
961: FND_MSG_PUB.initialize;
962: IF (l_debug = 'Y') THEN
963: okc_debug.Log('5000: Leaving conc_import_articles',2);
964: okc_debug.Reset_Indentation;
965: END IF;
966: END ;
967: BEGIN
968: OKC_ARTICLES_IMPORT_GRP.import_fnd_flex_values(

Line 985: okc_debug.Log('1000: Leaving conc_import_articles',2);

981: RAISE OKC_API.G_EXCEPTION_ERROR;
982: END IF;
983:
984: IF (l_debug = 'Y') THEN
985: okc_debug.Log('1000: Leaving conc_import_articles',2);
986: okc_debug.Reset_Indentation;
987: END IF;
988: x_return_status := G_RET_STS_SUCCESS;
989:

Line 986: okc_debug.Reset_Indentation;

982: END IF;
983:
984: IF (l_debug = 'Y') THEN
985: okc_debug.Log('1000: Leaving conc_import_articles',2);
986: okc_debug.Reset_Indentation;
987: END IF;
988: x_return_status := G_RET_STS_SUCCESS;
989:
990: EXCEPTION

Line 1001: okc_debug.Log('3000: Leaving conc_import_articles',2);

997: END IF;
998: FND_MSG_PUB.initialize;
999:
1000: IF (l_debug = 'Y') THEN
1001: okc_debug.Log('3000: Leaving conc_import_articles',2);
1002: okc_debug.Reset_Indentation;
1003: END IF;
1004: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1005: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1002: okc_debug.Reset_Indentation;

998: FND_MSG_PUB.initialize;
999:
1000: IF (l_debug = 'Y') THEN
1001: okc_debug.Log('3000: Leaving conc_import_articles',2);
1002: okc_debug.Reset_Indentation;
1003: END IF;
1004: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1005: x_return_status := G_RET_STS_UNEXP_ERROR;
1006: IF FND_MSG_PUB.Count_Msg > 0 Then

Line 1013: okc_debug.Log('4000: Leaving conc_import_articles',2);

1009: END LOOP;
1010: END IF;
1011: FND_MSG_PUB.initialize;
1012: IF (l_debug = 'Y') THEN
1013: okc_debug.Log('4000: Leaving conc_import_articles',2);
1014: okc_debug.Reset_Indentation;
1015: END IF;
1016:
1017: WHEN OTHERS THEN

Line 1014: okc_debug.Reset_Indentation;

1010: END IF;
1011: FND_MSG_PUB.initialize;
1012: IF (l_debug = 'Y') THEN
1013: okc_debug.Log('4000: Leaving conc_import_articles',2);
1014: okc_debug.Reset_Indentation;
1015: END IF;
1016:
1017: WHEN OTHERS THEN
1018: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1026: okc_debug.Log('5000: Leaving conc_import_articles',2);

1022: END LOOP;
1023: END IF;
1024: FND_MSG_PUB.initialize;
1025: IF (l_debug = 'Y') THEN
1026: okc_debug.Log('5000: Leaving conc_import_articles',2);
1027: okc_debug.Reset_Indentation;
1028: END IF;
1029: END ;
1030: BEGIN

Line 1027: okc_debug.Reset_Indentation;

1023: END IF;
1024: FND_MSG_PUB.initialize;
1025: IF (l_debug = 'Y') THEN
1026: okc_debug.Log('5000: Leaving conc_import_articles',2);
1027: okc_debug.Reset_Indentation;
1028: END IF;
1029: END ;
1030: BEGIN
1031: OKC_ARTICLES_IMPORT_GRP.import_variables(

Line 1048: okc_debug.Log('1000: Leaving conc_import_articles',2);

1044: RAISE OKC_API.G_EXCEPTION_ERROR;
1045: END IF;
1046:
1047: IF (l_debug = 'Y') THEN
1048: okc_debug.Log('1000: Leaving conc_import_articles',2);
1049: okc_debug.Reset_Indentation;
1050: END IF;
1051: x_return_status := G_RET_STS_SUCCESS;
1052:

Line 1049: okc_debug.Reset_Indentation;

1045: END IF;
1046:
1047: IF (l_debug = 'Y') THEN
1048: okc_debug.Log('1000: Leaving conc_import_articles',2);
1049: okc_debug.Reset_Indentation;
1050: END IF;
1051: x_return_status := G_RET_STS_SUCCESS;
1052:
1053: EXCEPTION

Line 1064: okc_debug.Log('3000: Leaving conc_import_articles',2);

1060: END IF;
1061: FND_MSG_PUB.initialize;
1062:
1063: IF (l_debug = 'Y') THEN
1064: okc_debug.Log('3000: Leaving conc_import_articles',2);
1065: okc_debug.Reset_Indentation;
1066: END IF;
1067: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1068: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1065: okc_debug.Reset_Indentation;

1061: FND_MSG_PUB.initialize;
1062:
1063: IF (l_debug = 'Y') THEN
1064: okc_debug.Log('3000: Leaving conc_import_articles',2);
1065: okc_debug.Reset_Indentation;
1066: END IF;
1067: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1068: x_return_status := G_RET_STS_UNEXP_ERROR;
1069: IF FND_MSG_PUB.Count_Msg > 0 Then

Line 1076: okc_debug.Log('4000: Leaving conc_import_articles',2);

1072: END LOOP;
1073: END IF;
1074: FND_MSG_PUB.initialize;
1075: IF (l_debug = 'Y') THEN
1076: okc_debug.Log('4000: Leaving conc_import_articles',2);
1077: okc_debug.Reset_Indentation;
1078: END IF;
1079:
1080: WHEN OTHERS THEN

Line 1077: okc_debug.Reset_Indentation;

1073: END IF;
1074: FND_MSG_PUB.initialize;
1075: IF (l_debug = 'Y') THEN
1076: okc_debug.Log('4000: Leaving conc_import_articles',2);
1077: okc_debug.Reset_Indentation;
1078: END IF;
1079:
1080: WHEN OTHERS THEN
1081: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1089: okc_debug.Log('5000: Leaving conc_import_articles',2);

1085: END LOOP;
1086: END IF;
1087: FND_MSG_PUB.initialize;
1088: IF (l_debug = 'Y') THEN
1089: okc_debug.Log('5000: Leaving conc_import_articles',2);
1090: okc_debug.Reset_Indentation;
1091: END IF;
1092: END ;
1093: END IF; -- If l_first_time = 'Y'

Line 1090: okc_debug.Reset_Indentation;

1086: END IF;
1087: FND_MSG_PUB.initialize;
1088: IF (l_debug = 'Y') THEN
1089: okc_debug.Log('5000: Leaving conc_import_articles',2);
1090: okc_debug.Reset_Indentation;
1091: END IF;
1092: END ;
1093: END IF; -- If l_first_time = 'Y'
1094: BEGIN

Line 1123: okc_debug.Log('1000: Leaving conc_import_articles',2);

1119: RAISE OKC_API.G_EXCEPTION_ERROR;
1120: END IF;
1121:
1122: IF (l_debug = 'Y') THEN
1123: okc_debug.Log('1000: Leaving conc_import_articles',2);
1124: okc_debug.Reset_Indentation;
1125: END IF;
1126: x_return_status := G_RET_STS_SUCCESS;
1127:

Line 1124: okc_debug.Reset_Indentation;

1120: END IF;
1121:
1122: IF (l_debug = 'Y') THEN
1123: okc_debug.Log('1000: Leaving conc_import_articles',2);
1124: okc_debug.Reset_Indentation;
1125: END IF;
1126: x_return_status := G_RET_STS_SUCCESS;
1127:
1128: EXCEPTION

Line 1139: okc_debug.Log('3000: Leaving conc_import_articles',2);

1135: END IF;
1136: FND_MSG_PUB.initialize;
1137:
1138: IF (l_debug = 'Y') THEN
1139: okc_debug.Log('3000: Leaving conc_import_articles',2);
1140: okc_debug.Reset_Indentation;
1141: END IF;
1142: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1143: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1140: okc_debug.Reset_Indentation;

1136: FND_MSG_PUB.initialize;
1137:
1138: IF (l_debug = 'Y') THEN
1139: okc_debug.Log('3000: Leaving conc_import_articles',2);
1140: okc_debug.Reset_Indentation;
1141: END IF;
1142: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1143: x_return_status := G_RET_STS_UNEXP_ERROR;
1144: IF FND_MSG_PUB.Count_Msg > 0 Then

Line 1151: okc_debug.Log('4000: Leaving conc_import_articles',2);

1147: END LOOP;
1148: END IF;
1149: FND_MSG_PUB.initialize;
1150: IF (l_debug = 'Y') THEN
1151: okc_debug.Log('4000: Leaving conc_import_articles',2);
1152: okc_debug.Reset_Indentation;
1153: END IF;
1154:
1155: WHEN OTHERS THEN

Line 1152: okc_debug.Reset_Indentation;

1148: END IF;
1149: FND_MSG_PUB.initialize;
1150: IF (l_debug = 'Y') THEN
1151: okc_debug.Log('4000: Leaving conc_import_articles',2);
1152: okc_debug.Reset_Indentation;
1153: END IF;
1154:
1155: WHEN OTHERS THEN
1156: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1164: okc_debug.Log('5000: Leaving conc_import_articles',2);

1160: END LOOP;
1161: END IF;
1162: FND_MSG_PUB.initialize;
1163: IF (l_debug = 'Y') THEN
1164: okc_debug.Log('5000: Leaving conc_import_articles',2);
1165: okc_debug.Reset_Indentation;
1166: END IF;
1167: END ;
1168: BEGIN

Line 1165: okc_debug.Reset_Indentation;

1161: END IF;
1162: FND_MSG_PUB.initialize;
1163: IF (l_debug = 'Y') THEN
1164: okc_debug.Log('5000: Leaving conc_import_articles',2);
1165: okc_debug.Reset_Indentation;
1166: END IF;
1167: END ;
1168: BEGIN
1169: l_part_rel_rows_processed := 0;

Line 1196: okc_debug.Log('1000: Leaving conc_import_articles',2);

1192: RAISE OKC_API.G_EXCEPTION_ERROR;
1193: END IF;
1194:
1195: IF (l_debug = 'Y') THEN
1196: okc_debug.Log('1000: Leaving conc_import_articles',2);
1197: okc_debug.Reset_Indentation;
1198: END IF;
1199: x_return_status := G_RET_STS_SUCCESS;
1200:

Line 1197: okc_debug.Reset_Indentation;

1193: END IF;
1194:
1195: IF (l_debug = 'Y') THEN
1196: okc_debug.Log('1000: Leaving conc_import_articles',2);
1197: okc_debug.Reset_Indentation;
1198: END IF;
1199: x_return_status := G_RET_STS_SUCCESS;
1200:
1201: EXCEPTION

Line 1212: okc_debug.Log('3000: Leaving conc_import_articles',2);

1208: END IF;
1209: FND_MSG_PUB.initialize;
1210:
1211: IF (l_debug = 'Y') THEN
1212: okc_debug.Log('3000: Leaving conc_import_articles',2);
1213: okc_debug.Reset_Indentation;
1214: END IF;
1215: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1216: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1213: okc_debug.Reset_Indentation;

1209: FND_MSG_PUB.initialize;
1210:
1211: IF (l_debug = 'Y') THEN
1212: okc_debug.Log('3000: Leaving conc_import_articles',2);
1213: okc_debug.Reset_Indentation;
1214: END IF;
1215: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1216: x_return_status := G_RET_STS_UNEXP_ERROR;
1217: IF FND_MSG_PUB.Count_Msg > 0 Then

Line 1224: okc_debug.Log('4000: Leaving conc_import_articles',2);

1220: END LOOP;
1221: END IF;
1222: FND_MSG_PUB.initialize;
1223: IF (l_debug = 'Y') THEN
1224: okc_debug.Log('4000: Leaving conc_import_articles',2);
1225: okc_debug.Reset_Indentation;
1226: END IF;
1227:
1228: WHEN OTHERS THEN

Line 1225: okc_debug.Reset_Indentation;

1221: END IF;
1222: FND_MSG_PUB.initialize;
1223: IF (l_debug = 'Y') THEN
1224: okc_debug.Log('4000: Leaving conc_import_articles',2);
1225: okc_debug.Reset_Indentation;
1226: END IF;
1227:
1228: WHEN OTHERS THEN
1229: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1237: okc_debug.Log('5000: Leaving conc_import_articles',2);

1233: END LOOP;
1234: END IF;
1235: FND_MSG_PUB.initialize;
1236: IF (l_debug = 'Y') THEN
1237: okc_debug.Log('5000: Leaving conc_import_articles',2);
1238: okc_debug.Reset_Indentation;
1239: END IF;
1240: END ;
1241: l_first_time := 'N';

Line 1238: okc_debug.Reset_Indentation;

1234: END IF;
1235: FND_MSG_PUB.initialize;
1236: IF (l_debug = 'Y') THEN
1237: okc_debug.Log('5000: Leaving conc_import_articles',2);
1238: okc_debug.Reset_Indentation;
1239: END IF;
1240: END ;
1241: l_first_time := 'N';
1242: ELSE

Line 1339: Okc_Debug.Log('100: Entered get_seq_id', 2);

1335: CURSOR l_ver_csr IS
1336: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;
1337: BEGIN
1338: IF (l_debug = 'Y') THEN
1339: Okc_Debug.Log('100: Entered get_seq_id', 2);
1340: END IF;
1341:
1342: IF p_object_type = 'ART' THEN
1343: OPEN l_art_csr;

Line 1359: Okc_Debug.Log('200: Leaving get_seq_id', 2);

1355: CLOSE l_ver_csr;
1356: END IF;
1357:
1358: IF (l_debug = 'Y') THEN
1359: Okc_Debug.Log('200: Leaving get_seq_id', 2);
1360: END IF;
1361: RETURN G_RET_STS_SUCCESS;
1362: EXCEPTION
1363: WHEN OTHERS THEN

Line 1366: Okc_Debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm, 2);

1362: EXCEPTION
1363: WHEN OTHERS THEN
1364:
1365: IF (l_debug = 'Y') THEN
1366: Okc_Debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm, 2);
1367: END IF;
1368:
1369: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1370: p_msg_name => G_UNEXPECTED_ERROR,

Line 1515: okc_debug.log('500: Leaving insert_error_array because of EXCEPTION: '||sqlerrm, 2);

1511:
1512: EXCEPTION
1513: WHEN OTHERS THEN
1514: IF (l_debug = 'Y') THEN
1515: okc_debug.log('500: Leaving insert_error_array because of EXCEPTION: '||sqlerrm, 2);
1516: END IF;
1517: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1518: p_msg_name => G_UNEXPECTED_ERROR,
1519: p_token1 => G_SQLCODE_TOKEN,

Line 2073: okc_debug.log('100: Entered article_import', 2);

2069: BEGIN
2070:
2071:
2072: IF (l_debug = 'Y') THEN
2073: okc_debug.log('100: Entered article_import', 2);
2074: END IF;
2075:
2076:
2077: ------------------------------------------------------------------------

Line 3055: okc_debug.log('300: In Articles_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);

3051:
3052: EXCEPTION
3053: WHEN FND_API.G_EXC_ERROR THEN
3054: IF (l_debug = 'Y') THEN
3055: okc_debug.log('300: In Articles_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
3056: END IF;
3057: --l_return_status := G_RET_STS_ERROR ;
3058: build_error_array(
3059: p_msg_data => x_msg_data,

Line 3075: okc_debug.log('400: Leaving Articles_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3071: -- Continue to next row
3072:
3073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3074: IF (l_debug = 'Y') THEN
3075: okc_debug.log('400: Leaving Articles_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3076: END IF;
3077:
3078: --
3079: -- Freeing temporary clobs

Line 3128: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||sqlerrm, 2);

3124: exit; -- exit the current fetch
3125:
3126: WHEN OTHERS THEN
3127: IF (l_debug = 'Y') THEN
3128: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||sqlerrm, 2);
3129: END IF;
3130:
3131:
3132: --

Line 3213: okc_debug.log('400: Leaving Articles_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3209: -------------------------
3210: EXCEPTION
3211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3212: IF (l_debug = 'Y') THEN
3213: okc_debug.log('400: Leaving Articles_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3214: END IF;
3215: --
3216: -- Freeing temporary clobs
3217: --

Line 3247: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||sqlerrm, 2);

3243: exit; -- exit outermost loop
3244:
3245: WHEN OTHERS THEN
3246: IF (l_debug = 'Y') THEN
3247: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||sqlerrm, 2);
3248: END IF;
3249:
3250: --
3251: -- Freeing temporary clobs

Line 3366: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

3362:
3363: EXCEPTION
3364: WHEN OTHERS THEN
3365: IF (l_debug = 'Y') THEN
3366: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3367: END IF;
3368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3369: END;
3370:

Line 3499: okc_debug.log('500: Leaving Article Import because of EXCEPTION: '||l_context||sqlerrm, 2);

3495:
3496: EXCEPTION
3497: WHEN OTHERS THEN
3498: IF (l_debug = 'Y') THEN
3499: okc_debug.log('500: Leaving Article Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3500: END IF;
3501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3502: END;
3503:

Line 3554: okc_debug.log('500: Leaving Article Import because of EXCEPTION: '||l_context||sqlerrm, 2);

3550: END IF;
3551: EXCEPTION
3552: WHEN OTHERS THEN
3553: IF (l_debug = 'Y') THEN
3554: okc_debug.log('500: Leaving Article Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3555: END IF;
3556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3557: END;
3558:

Line 3590: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

3586: AND article_version_id = inf_earlier_version_id_tbl(i);
3587: EXCEPTION
3588: WHEN OTHERS THEN
3589: IF (l_debug = 'Y') THEN
3590: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3591: END IF;
3592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3593: END;
3594: --

Line 3620: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

3616: AND article_id = inf_article_id_tbl(i);
3617: EXCEPTION
3618: WHEN OTHERS THEN
3619: IF (l_debug = 'Y') THEN
3620: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3621: END IF;
3622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3623: END;
3624: ---

Line 3648: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

3644: AND article_version_id = inf_article_version_id_tbl(i);
3645: EXCEPTION
3646: WHEN OTHERS THEN
3647: IF (l_debug = 'Y') THEN
3648: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3649: END IF;
3650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3651: END;
3652:

Line 3759: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

3755:
3756: EXCEPTION
3757: WHEN OTHERS THEN
3758: IF (l_debug = 'Y') THEN
3759: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3760: END IF;
3761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3762: END;
3763: --

Line 3834: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

3830:
3831: EXCEPTION
3832: WHEN OTHERS THEN
3833: IF (l_debug = 'Y') THEN
3834: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3835: END IF;
3836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3837: END;
3838: END IF; ---- If CURRENT_ORG_ID = GLOBAL_ORG_ID

Line 3927: okc_debug.log('500: Leaving Article_Import because of EXCEPTION: '||sqlerrm, 2);

3923: interface_id = inf_interface_id_tbl(i);
3924: EXCEPTION
3925: WHEN OTHERS THEN
3926: IF (l_debug = 'Y') THEN
3927: okc_debug.log('500: Leaving Article_Import because of EXCEPTION: '||sqlerrm, 2);
3928: END IF;
3929: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3930: p_msg_name => G_UNEXPECTED_ERROR,
3931: p_token1 => G_SQLCODE_TOKEN,

Line 4091: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION in workflow: '||sqlerrm, 2);

4087: EXCEPTION
4088:
4089: WHEN OTHERS THEN
4090: IF (l_debug = 'Y') THEN
4091: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION in workflow: '||sqlerrm, 2);
4092: END IF;
4093: Okc_API.Set_Message(p_app_name => G_APP_NAME,
4094: p_msg_name => 'OKC_ART_IMP_WF_FAILED');
4095:

Line 4147: okc_debug.log('200: Leaving articles import', 2);

4143: --wrap_up(p_validate_only,p_batch_number,l_tot_rows_processed,l_tot_rows_failed,l_tot_rows_warned,l_batch_process_id,'CLAUSE');
4144: commit; -- Final commit for status update
4145:
4146: IF (l_debug = 'Y') THEN
4147: okc_debug.log('200: Leaving articles import', 2);
4148: END IF;
4149: --x_return_status := l_return_status; this may cause to erase error x_return_status
4150:
4151: EXCEPTION

Line 4155: okc_debug.log('300: Leaving Articles_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);

4151: EXCEPTION
4152:
4153: WHEN FND_API.G_EXC_ERROR THEN
4154: IF (l_debug = 'Y') THEN
4155: okc_debug.log('300: Leaving Articles_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
4156: END IF;
4157: --Insert Errors into Error table if there is any
4158: insert_error_array(
4159: x_return_status => x_return_status,

Line 4168: okc_debug.log('400: Leaving Articles_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

4164: x_return_status := G_RET_STS_ERROR ;
4165:
4166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4167: IF (l_debug = 'Y') THEN
4168: okc_debug.log('400: Leaving Articles_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
4169: END IF;
4170:
4171: --Insert Errors into Error table if there is any
4172:

Line 4223: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);

4219: -- In this exception handling, we don't insert error array again
4220: -- because error happend in the module
4221: --
4222: IF (l_debug = 'Y') THEN
4223: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);
4224: END IF;
4225: --
4226: -- Freeing temporary clobs
4227: --

Line 4272: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||sqlerrm, 2);

4268: commit;
4269:
4270: WHEN OTHERS THEN
4271: IF (l_debug = 'Y') THEN
4272: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||sqlerrm, 2);
4273: END IF;
4274: --Insert Errors into Error table if there is any
4275: insert_error_array(
4276: x_return_status => x_return_status,

Line 4570: okc_debug.log('100: Entered variables_import', 2);

4566: l_variable_datatype OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;
4567:
4568: BEGIN
4569: IF (l_debug = 'Y') THEN
4570: okc_debug.log('100: Entered variables_import', 2);
4571: END IF;
4572:
4573: ------------------------------------------------------------------------
4574: -- Variable Initialization

Line 5019: okc_debug.log('300: In Variables_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);

5015:
5016: EXCEPTION
5017: WHEN FND_API.G_EXC_ERROR THEN
5018: IF (l_debug = 'Y') THEN
5019: okc_debug.log('300: In Variables_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
5020: END IF;
5021: --l_return_status := G_RET_STS_ERROR ;
5022: build_error_array(
5023: p_msg_data => x_msg_data,

Line 5039: okc_debug.log('400: Leaving Variables_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

5035: -- Continue to next row
5036:
5037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5038: IF (l_debug = 'Y') THEN
5039: okc_debug.log('400: Leaving Variables_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
5040: END IF;
5041:
5042: IF l_var_interface_csr%ISOPEN THEN
5043: CLOSE l_var_interface_csr;

Line 5067: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||sqlerrm, 2);

5063: exit; -- exit the current fetch
5064:
5065: WHEN OTHERS THEN
5066: IF (l_debug = 'Y') THEN
5067: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||sqlerrm, 2);
5068: END IF;
5069:
5070: IF l_var_interface_csr%ISOPEN THEN
5071: CLOSE l_var_interface_csr;

Line 5125: okc_debug.log('400: Leaving Variables_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

5121: -------------------------
5122: EXCEPTION
5123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5124: IF (l_debug = 'Y') THEN
5125: okc_debug.log('400: Leaving Variables_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
5126: END IF;
5127:
5128: IF l_var_interface_csr%ISOPEN THEN
5129: CLOSE l_var_interface_csr;

Line 5137: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||sqlerrm, 2);

5133: exit; -- exit outermost loop
5134:
5135: WHEN OTHERS THEN
5136: IF (l_debug = 'Y') THEN
5137: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||sqlerrm, 2);
5138: END IF;
5139:
5140: IF l_var_interface_csr%ISOPEN THEN
5141: CLOSE l_var_interface_csr;

Line 5271: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

5267:
5268: EXCEPTION
5269: WHEN OTHERS THEN
5270: IF (l_debug = 'Y') THEN
5271: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
5272: END IF;
5273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5274: END;
5275:

Line 5316: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

5312:
5313: EXCEPTION
5314: WHEN OTHERS THEN
5315: IF (l_debug = 'Y') THEN
5316: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
5317: END IF;
5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5319: END;
5320:

Line 5343: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

5339: AND vinf_existing_language_tbl(i) IS NOT NULL;
5340: EXCEPTION
5341: WHEN OTHERS THEN
5342: IF (l_debug = 'Y') THEN
5343: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
5344: END IF;
5345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5346: END;
5347:

Line 5373: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

5369: AND vinf_existing_language_tbl(i) IS NOT NULL;
5370: EXCEPTION
5371: WHEN OTHERS THEN
5372: IF (l_debug = 'Y') THEN
5373: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
5374: END IF;
5375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5376: END;
5377:

Line 5419: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

5415:
5416: EXCEPTION
5417: WHEN OTHERS THEN
5418: IF (l_debug = 'Y') THEN
5419: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
5420: END IF;
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5422: END;
5423:

Line 5449: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

5445: AND variable_code = vinf_variable_code_tbl(i);
5446: EXCEPTION
5447: WHEN OTHERS THEN
5448: IF (l_debug = 'Y') THEN
5449: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
5450: END IF;
5451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5452: END;
5453:

Line 5541: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||sqlerrm, 2);

5537: interface_id = vinf_interface_id_tbl(i);
5538: EXCEPTION
5539: WHEN OTHERS THEN
5540: IF (l_debug = 'Y') THEN
5541: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||sqlerrm, 2);
5542: END IF;
5543: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5544: p_msg_name => G_UNEXPECTED_ERROR,
5545: p_token1 => G_SQLCODE_TOKEN,

Line 5669: okc_debug.log('1000: Entering Insert Missing Lang Records', 2);

5665: IF p_validate_only = 'N' THEN
5666: BEGIN
5667: SAVEPOINT bulklanginsert;
5668: IF (l_debug = 'Y') THEN
5669: okc_debug.log('1000: Entering Insert Missing Lang Records', 2);
5670: END IF;
5671:
5672: INSERT INTO OKC_BUS_VARIABLES_TL (
5673: VARIABLE_CODE,

Line 5720: okc_debug.log('1100: Leaving Insert Missing Lang Records', 2);

5716: AND NVL(VARI1.PROCESS_STATUS,'*') = 'S');
5717: COMMIT;
5718:
5719: IF (l_debug = 'Y') THEN
5720: okc_debug.log('1100: Leaving Insert Missing Lang Records', 2);
5721: END IF;
5722:
5723: EXCEPTION
5724: WHEN OTHERS THEN

Line 5726: okc_debug.log('1200: Leaving Missing langauge Insert because of EXCEPTION: '||l_context||sqlerrm, 2);

5722:
5723: EXCEPTION
5724: WHEN OTHERS THEN
5725: IF (l_debug = 'Y') THEN
5726: okc_debug.log('1200: Leaving Missing langauge Insert because of EXCEPTION: '||l_context||sqlerrm, 2);
5727: END IF;
5728: ROLLBACK TO SAVEPOINT bulklanginsert;
5729: END;
5730:

Line 5771: okc_debug.log('2000: Leaving variables import', 2);

5767: --wrap_up(p_validate_only,p_batch_number,l_tot_rows_processed,l_tot_rows_failed,l_tot_rows_warned,l_batch_process_id,'VARIABLE');
5768: commit; -- Final commit for status update
5769:
5770: IF (l_debug = 'Y') THEN
5771: okc_debug.log('2000: Leaving variables import', 2);
5772: END IF;
5773: --x_return_status := l_return_status; this may cause to erase error x_return_status
5774:
5775: EXCEPTION

Line 5779: okc_debug.log('3000: Leaving Variables_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);

5775: EXCEPTION
5776:
5777: WHEN FND_API.G_EXC_ERROR THEN
5778: IF (l_debug = 'Y') THEN
5779: okc_debug.log('3000: Leaving Variables_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
5780: END IF;
5781: --Insert Errors into Error table if there is any
5782: insert_error_array(
5783: x_return_status => x_return_status,

Line 5791: okc_debug.log('4000: Leaving Variables_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

5787: x_return_status := G_RET_STS_ERROR ;
5788:
5789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5790: IF (l_debug = 'Y') THEN
5791: okc_debug.log('4000: Leaving Variables_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
5792: END IF;
5793: --Insert Errors into Error table if there is any
5794:
5795: insert_error_array(

Line 5818: okc_debug.log('5000: Leaving Variables_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);

5814: -- In this exception handling, we don't insert error array again
5815: -- because error happend in the module
5816: --
5817: IF (l_debug = 'Y') THEN
5818: okc_debug.log('5000: Leaving Variables_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);
5819: END IF;
5820:
5821: IF l_var_interface_csr%ISOPEN THEN
5822: CLOSE l_var_interface_csr;

Line 5835: okc_debug.log('5000: Leaving Variables_Import because of EXCEPTION: '||sqlerrm, 2);

5831: commit;
5832:
5833: WHEN OTHERS THEN
5834: IF (l_debug = 'Y') THEN
5835: okc_debug.log('5000: Leaving Variables_Import because of EXCEPTION: '||sqlerrm, 2);
5836: END IF;
5837: --Insert Errors into Error table if there is any
5838: insert_error_array(
5839: x_return_status => x_return_status,

Line 6004: okc_debug.log('100: Entered relationships_import', 2);

6000: l_target_provision VARCHAR2(1);
6001:
6002: BEGIN
6003: IF (l_debug = 'Y') THEN
6004: okc_debug.log('100: Entered relationships_import', 2);
6005: END IF;
6006:
6007: ------------------------------------------------------------------------
6008: -- Variable Initialization

Line 6418: okc_debug.log('300: In Relationships_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);

6414:
6415: EXCEPTION
6416: WHEN FND_API.G_EXC_ERROR THEN
6417: IF (l_debug = 'Y') THEN
6418: okc_debug.log('300: In Relationships_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
6419: END IF;
6420: --l_return_status := G_RET_STS_ERROR ;
6421: build_error_array(
6422: p_msg_data => x_msg_data,

Line 6438: okc_debug.log('400: Leaving Relationships_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

6434: -- Continue to next row
6435:
6436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6437: IF (l_debug = 'Y') THEN
6438: okc_debug.log('400: Leaving Relationships_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
6439: END IF;
6440:
6441: IF l_rel_interface_csr%ISOPEN THEN
6442: CLOSE l_rel_interface_csr;

Line 6466: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||sqlerrm, 2);

6462: exit; -- exit the current fetch
6463:
6464: WHEN OTHERS THEN
6465: IF (l_debug = 'Y') THEN
6466: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||sqlerrm, 2);
6467: END IF;
6468:
6469: IF l_rel_interface_csr%ISOPEN THEN
6470: CLOSE l_rel_interface_csr;

Line 6524: okc_debug.log('400: Leaving Relationships_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

6520: -------------------------
6521: EXCEPTION
6522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6523: IF (l_debug = 'Y') THEN
6524: okc_debug.log('400: Leaving Relationships_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
6525: END IF;
6526:
6527: IF l_rel_interface_csr%ISOPEN THEN
6528: CLOSE l_rel_interface_csr;

Line 6536: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||sqlerrm, 2);

6532: exit; -- exit outermost loop
6533:
6534: WHEN OTHERS THEN
6535: IF (l_debug = 'Y') THEN
6536: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||sqlerrm, 2);
6537: END IF;
6538:
6539: IF l_rel_interface_csr%ISOPEN THEN
6540: CLOSE l_rel_interface_csr;

Line 6627: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

6623: rinf_process_status_tbl(i) in ('S', 'W') ;
6624: EXCEPTION
6625: WHEN OTHERS THEN
6626: IF (l_debug = 'Y') THEN
6627: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
6628: END IF;
6629: END;
6630:
6631: --

Line 6666: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

6662:
6663: EXCEPTION
6664: WHEN OTHERS THEN
6665: IF (l_debug = 'Y') THEN
6666: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
6667: END IF;
6668: END;
6669:
6670: --

Line 6758: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||sqlerrm, 2);

6754: interface_id = rinf_interface_id_tbl(i);
6755: EXCEPTION
6756: WHEN OTHERS THEN
6757: IF (l_debug = 'Y') THEN
6758: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||sqlerrm, 2);
6759: END IF;
6760: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6761: p_msg_name => G_UNEXPECTED_ERROR,
6762: p_token1 => G_SQLCODE_TOKEN,

Line 6902: okc_debug.log('2000: Leaving relationships import', 2);

6898: */
6899: commit; -- Final commit for status update
6900:
6901: IF (l_debug = 'Y') THEN
6902: okc_debug.log('2000: Leaving relationships import', 2);
6903: END IF;
6904: --x_return_status := l_return_status; this may cause to erase error x_return_status
6905:
6906: EXCEPTION

Line 6910: okc_debug.log('3000: Leaving Relationships_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);

6906: EXCEPTION
6907:
6908: WHEN FND_API.G_EXC_ERROR THEN
6909: IF (l_debug = 'Y') THEN
6910: okc_debug.log('3000: Leaving Relationships_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
6911: END IF;
6912: --Insert Errors into Error table if there is any
6913: insert_error_array(
6914: x_return_status => x_return_status,

Line 6922: okc_debug.log('4000: Leaving Relationships_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

6918: x_return_status := G_RET_STS_ERROR ;
6919:
6920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6921: IF (l_debug = 'Y') THEN
6922: okc_debug.log('4000: Leaving Relationships_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
6923: END IF;
6924: --Insert Errors into Error table if there is any
6925:
6926: insert_error_array(

Line 6949: okc_debug.log('5000: Leaving Relationships_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);

6945: -- In this exception handling, we don't insert error array again
6946: -- because error happend in the module
6947: --
6948: IF (l_debug = 'Y') THEN
6949: okc_debug.log('5000: Leaving Relationships_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);
6950: END IF;
6951:
6952: IF l_rel_interface_csr%ISOPEN THEN
6953: CLOSE l_rel_interface_csr;

Line 6966: okc_debug.log('5000: Leaving Relationships_Import because of EXCEPTION: '||sqlerrm, 2);

6962: commit;
6963:
6964: WHEN OTHERS THEN
6965: IF (l_debug = 'Y') THEN
6966: okc_debug.log('5000: Leaving Relationships_Import because of EXCEPTION: '||sqlerrm, 2);
6967: END IF;
6968: --Insert Errors into Error table if there is any
6969: insert_error_array(
6970: x_return_status => x_return_status,

Line 7092: okc_debug.log('100: Entered valueset_import', 2);

7088:
7089:
7090: BEGIN
7091: IF (l_debug = 'Y') THEN
7092: okc_debug.log('100: Entered valueset_import', 2);
7093: END IF;
7094:
7095:
7096: ------------------------------------------------------------------------

Line 7464: okc_debug.log('300: In Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);

7460:
7461: EXCEPTION
7462: WHEN FND_API.G_EXC_ERROR THEN
7463: IF (l_debug = 'Y') THEN
7464: okc_debug.log('300: In Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
7465: END IF;
7466: --l_return_status := G_RET_STS_ERROR ;
7467: build_error_array(
7468: p_msg_data => x_msg_data,

Line 7484: okc_debug.log('400: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

7480: -- Continue to next row
7481:
7482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7483: IF (l_debug = 'Y') THEN
7484: okc_debug.log('400: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
7485: END IF;
7486:
7487: IF l_valset_interface_csr%ISOPEN THEN
7488: CLOSE l_valset_interface_csr;

Line 7512: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);

7508: exit; -- exit the current fetch
7509:
7510: WHEN OTHERS THEN
7511: IF (l_debug = 'Y') THEN
7512: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
7513: END IF;
7514:
7515: IF l_valset_interface_csr%ISOPEN THEN
7516: CLOSE l_valset_interface_csr;

Line 7570: okc_debug.log('400: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

7566: -------------------------
7567: EXCEPTION
7568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7569: IF (l_debug = 'Y') THEN
7570: okc_debug.log('400: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
7571: END IF;
7572:
7573: IF l_valset_interface_csr%ISOPEN THEN
7574: CLOSE l_valset_interface_csr;

Line 7582: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);

7578: exit; -- exit outermost loop
7579:
7580: WHEN OTHERS THEN
7581: IF (l_debug = 'Y') THEN
7582: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
7583: END IF;
7584:
7585: IF l_valset_interface_csr%ISOPEN THEN
7586: CLOSE l_valset_interface_csr;

Line 7665: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

7661:
7662: EXCEPTION
7663: WHEN OTHERS THEN
7664: IF (l_debug = 'Y') THEN
7665: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
7666: END IF;
7667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
7668: END;
7669:

Line 7757: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);

7753: interface_id = vsinf_interface_id_tbl(i);
7754: EXCEPTION
7755: WHEN OTHERS THEN
7756: IF (l_debug = 'Y') THEN
7757: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
7758: END IF;
7759:
7760: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7761: p_msg_name => G_UNEXPECTED_ERROR,

Line 7890: okc_debug.log('2000: Leaving Fnd_flex_value_sets import', 2);

7886: --wrap_up(p_validate_only,p_batch_number,l_tot_rows_processed,l_tot_rows_failed,l_tot_rows_warned,l_batch_process_id,'VALUESET');
7887: commit; -- Final commit for status update
7888:
7889: IF (l_debug = 'Y') THEN
7890: okc_debug.log('2000: Leaving Fnd_flex_value_sets import', 2);
7891: END IF;
7892: --x_return_status := l_return_status; this may cause to erase error x_return_status
7893:
7894: EXCEPTION

Line 7898: okc_debug.log('3000: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);

7894: EXCEPTION
7895:
7896: WHEN FND_API.G_EXC_ERROR THEN
7897: IF (l_debug = 'Y') THEN
7898: okc_debug.log('3000: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
7899: END IF;
7900: --Insert Errors into Error table if there is any
7901: insert_error_array(
7902: x_return_status => x_return_status,

Line 7910: okc_debug.log('4000: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

7906: x_return_status := G_RET_STS_ERROR ;
7907:
7908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7909: IF (l_debug = 'Y') THEN
7910: okc_debug.log('4000: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
7911: END IF;
7912: --Insert Errors into Error table if there is any
7913:
7914: insert_error_array(

Line 7937: okc_debug.log('5000: Leaving Fnd_flex_value_sets_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);

7933: -- In this exception handling, we don't insert error array again
7934: -- because error happend in the module
7935: --
7936: IF (l_debug = 'Y') THEN
7937: okc_debug.log('5000: Leaving Fnd_flex_value_sets_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);
7938: END IF;
7939:
7940: IF l_valset_interface_csr%ISOPEN THEN
7941: CLOSE l_valset_interface_csr;

Line 7954: okc_debug.log('5000: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);

7950: commit;
7951:
7952: WHEN OTHERS THEN
7953: IF (l_debug = 'Y') THEN
7954: okc_debug.log('5000: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
7955: END IF;
7956: --Insert Errors into Error table if there is any
7957: insert_error_array(
7958: x_return_status => x_return_status,

Line 8183: okc_debug.log('100: Entered values_import', 2);

8179:
8180:
8181: BEGIN
8182: IF (l_debug = 'Y') THEN
8183: okc_debug.log('100: Entered values_import', 2);
8184: END IF;
8185:
8186:
8187: ------------------------------------------------------------------------

Line 8574: okc_debug.log('300: In Fnd_flex_values_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);

8570:
8571: EXCEPTION
8572: WHEN FND_API.G_EXC_ERROR THEN
8573: IF (l_debug = 'Y') THEN
8574: okc_debug.log('300: In Fnd_flex_values_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
8575: END IF;
8576: IF l_val_exist_csr%ISOPEN THEN
8577: CLOSE l_val_exist_csr;
8578: END IF;

Line 8597: okc_debug.log('400: Leaving Fnd_flex_values_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

8593: -- Continue to next row
8594:
8595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8596: IF (l_debug = 'Y') THEN
8597: okc_debug.log('400: Leaving Fnd_flex_values_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
8598: END IF;
8599:
8600: IF l_val_exist_csr%ISOPEN THEN
8601: CLOSE l_val_exist_csr;

Line 8628: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||sqlerrm, 2);

8624: exit; -- exit the current fetch
8625:
8626: WHEN OTHERS THEN
8627: IF (l_debug = 'Y') THEN
8628: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||sqlerrm, 2);
8629: END IF;
8630: IF l_val_exist_csr%ISOPEN THEN
8631: CLOSE l_val_exist_csr;
8632: END IF;

Line 8688: okc_debug.log('400: Leaving Fnd_flex_values_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

8684: -------------------------
8685: EXCEPTION
8686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8687: IF (l_debug = 'Y') THEN
8688: okc_debug.log('400: Leaving Fnd_flex_values_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
8689: END IF;
8690: IF l_val_exist_csr%ISOPEN THEN
8691: CLOSE l_val_exist_csr;
8692: END IF;

Line 8703: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||sqlerrm, 2);

8699: exit; -- exit outermost loop
8700:
8701: WHEN OTHERS THEN
8702: IF (l_debug = 'Y') THEN
8703: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||sqlerrm, 2);
8704: END IF;
8705: IF l_val_exist_csr%ISOPEN THEN
8706: CLOSE l_val_exist_csr;
8707: END IF;

Line 8762: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

8758:
8759: EXCEPTION
8760: WHEN OTHERS THEN
8761: IF (l_debug = 'Y') THEN
8762: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
8763: END IF;
8764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
8765: END;
8766:

Line 8799: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||l_context||sqlerrm, 2);

8795:
8796: EXCEPTION
8797: WHEN OTHERS THEN
8798: IF (l_debug = 'Y') THEN
8799: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
8800: END IF;
8801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
8802: END;
8803:

Line 8892: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||sqlerrm, 2);

8888: interface_id = vinf_interface_id_tbl(i);
8889: EXCEPTION
8890: WHEN OTHERS THEN
8891: IF (l_debug = 'Y') THEN
8892: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||sqlerrm, 2);
8893: END IF;
8894:
8895: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
8896: p_msg_name => G_UNEXPECTED_ERROR,

Line 9036: okc_debug.log('2000: Leaving Fnd_flex_values import', 2);

9032: --wrap_up(p_validate_only,p_batch_number,l_tot_rows_processed,l_tot_rows_failed,l_tot_rows_warned,l_batch_process_id,'VALUE');
9033: commit; -- Final commit for status update
9034:
9035: IF (l_debug = 'Y') THEN
9036: okc_debug.log('2000: Leaving Fnd_flex_values import', 2);
9037: END IF;
9038: --x_return_status := l_return_status; this may cause to erase error x_return_status
9039:
9040: EXCEPTION

Line 9044: okc_debug.log('3000: Leaving Fnd_flex_values_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);

9040: EXCEPTION
9041:
9042: WHEN FND_API.G_EXC_ERROR THEN
9043: IF (l_debug = 'Y') THEN
9044: okc_debug.log('3000: Leaving Fnd_flex_values_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
9045: END IF;
9046: --Insert Errors into Error table if there is any
9047: insert_error_array(
9048: x_return_status => x_return_status,

Line 9056: okc_debug.log('4000: Leaving Fnd_flex_values_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

9052: x_return_status := G_RET_STS_ERROR ;
9053:
9054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9055: IF (l_debug = 'Y') THEN
9056: okc_debug.log('4000: Leaving Fnd_flex_values_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
9057: END IF;
9058: --Insert Errors into Error table if there is any
9059:
9060: insert_error_array(

Line 9083: okc_debug.log('5000: Leaving Fnd_flex_values_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);

9079: -- In this exception handling, we don't insert error array again
9080: -- because error happend in the module
9081: --
9082: IF (l_debug = 'Y') THEN
9083: okc_debug.log('5000: Leaving Fnd_flex_values_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);
9084: END IF;
9085:
9086: IF l_val_interface_csr%ISOPEN THEN
9087: CLOSE l_val_interface_csr;

Line 9100: okc_debug.log('5000: Leaving Fnd_flex_values_Import because of EXCEPTION: '||sqlerrm, 2);

9096: commit;
9097:
9098: WHEN OTHERS THEN
9099: IF (l_debug = 'Y') THEN
9100: okc_debug.log('5000: Leaving Fnd_flex_values_Import because of EXCEPTION: '||sqlerrm, 2);
9101: END IF;
9102: --Insert Errors into Error table if there is any
9103: insert_error_array(
9104: x_return_status => x_return_status,