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 2087: okc_debug.log('100: Entered article_import', 2);

2083: BEGIN
2084:
2085:
2086: IF (l_debug = 'Y') THEN
2087: okc_debug.log('100: Entered article_import', 2);
2088: END IF;
2089:
2090:
2091: ------------------------------------------------------------------------

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

3102:
3103: EXCEPTION
3104: WHEN FND_API.G_EXC_ERROR THEN
3105: IF (l_debug = 'Y') THEN
3106: okc_debug.log('300: In Articles_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
3107: END IF;
3108: --l_return_status := G_RET_STS_ERROR ;
3109: build_error_array(
3110: p_msg_data => x_msg_data,

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

3122: -- Continue to next row
3123:
3124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3125: IF (l_debug = 'Y') THEN
3126: okc_debug.log('400: Leaving Articles_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3127: END IF;
3128:
3129: --
3130: -- Freeing temporary clobs

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

3175: exit; -- exit the current fetch
3176:
3177: WHEN OTHERS THEN
3178: IF (l_debug = 'Y') THEN
3179: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||sqlerrm, 2);
3180: END IF;
3181:
3182:
3183: --

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

3260: -------------------------
3261: EXCEPTION
3262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3263: IF (l_debug = 'Y') THEN
3264: okc_debug.log('400: Leaving Articles_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3265: END IF;
3266: --
3267: -- Freeing temporary clobs
3268: --

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

3294: exit; -- exit outermost loop
3295:
3296: WHEN OTHERS THEN
3297: IF (l_debug = 'Y') THEN
3298: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||sqlerrm, 2);
3299: END IF;
3300:
3301: --
3302: -- Freeing temporary clobs

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

3413:
3414: EXCEPTION
3415: WHEN OTHERS THEN
3416: IF (l_debug = 'Y') THEN
3417: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3418: END IF;
3419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3420: END;
3421:

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

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

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

3607: END IF;
3608: EXCEPTION
3609: WHEN OTHERS THEN
3610: IF (l_debug = 'Y') THEN
3611: okc_debug.log('500: Leaving Article Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3612: END IF;
3613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3614: END;
3615:

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

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

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

3673: AND article_id = inf_article_id_tbl(i);
3674: EXCEPTION
3675: WHEN OTHERS THEN
3676: IF (l_debug = 'Y') THEN
3677: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3678: END IF;
3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3680: END;
3681: ---

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

3701: AND article_version_id = inf_article_version_id_tbl(i);
3702: EXCEPTION
3703: WHEN OTHERS THEN
3704: IF (l_debug = 'Y') THEN
3705: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3706: END IF;
3707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3708: END;
3709:

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

3818:
3819: EXCEPTION
3820: WHEN OTHERS THEN
3821: IF (l_debug = 'Y') THEN
3822: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3823: END IF;
3824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3825: END;
3826: --

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

3893:
3894: EXCEPTION
3895: WHEN OTHERS THEN
3896: IF (l_debug = 'Y') THEN
3897: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
3898: END IF;
3899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3900: END;
3901: END IF; ---- If CURRENT_ORG_ID = GLOBAL_ORG_ID

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

3986: interface_id = inf_interface_id_tbl(i);
3987: EXCEPTION
3988: WHEN OTHERS THEN
3989: IF (l_debug = 'Y') THEN
3990: okc_debug.log('500: Leaving Article_Import because of EXCEPTION: '||sqlerrm, 2);
3991: END IF;
3992: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3993: p_msg_name => G_UNEXPECTED_ERROR,
3994: p_token1 => G_SQLCODE_TOKEN,

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

4153: EXCEPTION
4154:
4155: WHEN OTHERS THEN
4156: IF (l_debug = 'Y') THEN
4157: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION in workflow: '||sqlerrm, 2);
4158: END IF;
4159: Okc_API.Set_Message(p_app_name => G_APP_NAME,
4160: p_msg_name => 'OKC_ART_IMP_WF_FAILED');
4161:

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

4209: --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');
4210: commit; -- Final commit for status update
4211:
4212: IF (l_debug = 'Y') THEN
4213: okc_debug.log('200: Leaving articles import', 2);
4214: END IF;
4215: --x_return_status := l_return_status; this may cause to erase error x_return_status
4216:
4217: EXCEPTION

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

4217: EXCEPTION
4218:
4219: WHEN FND_API.G_EXC_ERROR THEN
4220: IF (l_debug = 'Y') THEN
4221: okc_debug.log('300: Leaving Articles_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
4222: END IF;
4223: --Insert Errors into Error table if there is any
4224: insert_error_array(
4225: x_return_status => x_return_status,

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

4230: x_return_status := G_RET_STS_ERROR ;
4231:
4232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4233: IF (l_debug = 'Y') THEN
4234: okc_debug.log('400: Leaving Articles_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
4235: END IF;
4236:
4237: --Insert Errors into Error table if there is any
4238:

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

4285: -- In this exception handling, we don't insert error array again
4286: -- because error happend in the module
4287: --
4288: IF (l_debug = 'Y') THEN
4289: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);
4290: END IF;
4291: --
4292: -- Freeing temporary clobs
4293: --

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

4334: commit;
4335:
4336: WHEN OTHERS THEN
4337: IF (l_debug = 'Y') THEN
4338: okc_debug.log('500: Leaving Articles_Import because of EXCEPTION: '||sqlerrm, 2);
4339: END IF;
4340: --Insert Errors into Error table if there is any
4341: insert_error_array(
4342: x_return_status => x_return_status,

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

4632: l_variable_datatype OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;
4633:
4634: BEGIN
4635: IF (l_debug = 'Y') THEN
4636: okc_debug.log('100: Entered variables_import', 2);
4637: END IF;
4638:
4639: ------------------------------------------------------------------------
4640: -- Variable Initialization

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

5081:
5082: EXCEPTION
5083: WHEN FND_API.G_EXC_ERROR THEN
5084: IF (l_debug = 'Y') THEN
5085: okc_debug.log('300: In Variables_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
5086: END IF;
5087: --l_return_status := G_RET_STS_ERROR ;
5088: build_error_array(
5089: p_msg_data => x_msg_data,

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

5101: -- Continue to next row
5102:
5103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5104: IF (l_debug = 'Y') THEN
5105: okc_debug.log('400: Leaving Variables_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
5106: END IF;
5107:
5108: IF l_var_interface_csr%ISOPEN THEN
5109: CLOSE l_var_interface_csr;

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

5129: exit; -- exit the current fetch
5130:
5131: WHEN OTHERS THEN
5132: IF (l_debug = 'Y') THEN
5133: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||sqlerrm, 2);
5134: END IF;
5135:
5136: IF l_var_interface_csr%ISOPEN THEN
5137: CLOSE l_var_interface_csr;

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

5187: -------------------------
5188: EXCEPTION
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: IF (l_debug = 'Y') THEN
5191: okc_debug.log('400: Leaving Variables_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
5192: END IF;
5193:
5194: IF l_var_interface_csr%ISOPEN THEN
5195: CLOSE l_var_interface_csr;

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

5199: exit; -- exit outermost loop
5200:
5201: WHEN OTHERS THEN
5202: IF (l_debug = 'Y') THEN
5203: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||sqlerrm, 2);
5204: END IF;
5205:
5206: IF l_var_interface_csr%ISOPEN THEN
5207: CLOSE l_var_interface_csr;

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

5335:
5336: EXCEPTION
5337: WHEN OTHERS THEN
5338: IF (l_debug = 'Y') THEN
5339: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
5340: END IF;
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5342: END;
5343:

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

5380:
5381: EXCEPTION
5382: WHEN OTHERS THEN
5383: IF (l_debug = 'Y') THEN
5384: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
5385: END IF;
5386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5387: END;
5388:

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

5407: AND vinf_existing_language_tbl(i) IS NOT NULL;
5408: EXCEPTION
5409: WHEN OTHERS THEN
5410: IF (l_debug = 'Y') THEN
5411: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
5412: END IF;
5413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5414: END;
5415:

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

5437: AND vinf_existing_language_tbl(i) IS NOT NULL;
5438: EXCEPTION
5439: WHEN OTHERS THEN
5440: IF (l_debug = 'Y') THEN
5441: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
5442: END IF;
5443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5444: END;
5445:

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

5483:
5484: EXCEPTION
5485: WHEN OTHERS THEN
5486: IF (l_debug = 'Y') THEN
5487: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
5488: END IF;
5489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5490: END;
5491:

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

5513: AND variable_code = vinf_variable_code_tbl(i);
5514: EXCEPTION
5515: WHEN OTHERS THEN
5516: IF (l_debug = 'Y') THEN
5517: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
5518: END IF;
5519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5520: END;
5521:

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

5605: interface_id = vinf_interface_id_tbl(i);
5606: EXCEPTION
5607: WHEN OTHERS THEN
5608: IF (l_debug = 'Y') THEN
5609: okc_debug.log('500: Leaving Variables_Import because of EXCEPTION: '||sqlerrm, 2);
5610: END IF;
5611: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5612: p_msg_name => G_UNEXPECTED_ERROR,
5613: p_token1 => G_SQLCODE_TOKEN,

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

5733: IF p_validate_only = 'N' THEN
5734: BEGIN
5735: SAVEPOINT bulklanginsert;
5736: IF (l_debug = 'Y') THEN
5737: okc_debug.log('1000: Entering Insert Missing Lang Records', 2);
5738: END IF;
5739:
5740: INSERT INTO OKC_BUS_VARIABLES_TL (
5741: VARIABLE_CODE,

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

5784: AND NVL(VARI1.PROCESS_STATUS,'*') = 'S');
5785: COMMIT;
5786:
5787: IF (l_debug = 'Y') THEN
5788: okc_debug.log('1100: Leaving Insert Missing Lang Records', 2);
5789: END IF;
5790:
5791: EXCEPTION
5792: WHEN OTHERS THEN

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

5790:
5791: EXCEPTION
5792: WHEN OTHERS THEN
5793: IF (l_debug = 'Y') THEN
5794: okc_debug.log('1200: Leaving Missing langauge Insert because of EXCEPTION: '||l_context||sqlerrm, 2);
5795: END IF;
5796: ROLLBACK TO SAVEPOINT bulklanginsert;
5797: END;
5798:

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

5835: --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');
5836: commit; -- Final commit for status update
5837:
5838: IF (l_debug = 'Y') THEN
5839: okc_debug.log('2000: Leaving variables import', 2);
5840: END IF;
5841: --x_return_status := l_return_status; this may cause to erase error x_return_status
5842:
5843: EXCEPTION

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

5843: EXCEPTION
5844:
5845: WHEN FND_API.G_EXC_ERROR THEN
5846: IF (l_debug = 'Y') THEN
5847: okc_debug.log('3000: Leaving Variables_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
5848: END IF;
5849: --Insert Errors into Error table if there is any
5850: insert_error_array(
5851: x_return_status => x_return_status,

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

5855: x_return_status := G_RET_STS_ERROR ;
5856:
5857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5858: IF (l_debug = 'Y') THEN
5859: okc_debug.log('4000: Leaving Variables_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
5860: END IF;
5861: --Insert Errors into Error table if there is any
5862:
5863: insert_error_array(

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

5882: -- In this exception handling, we don't insert error array again
5883: -- because error happend in the module
5884: --
5885: IF (l_debug = 'Y') THEN
5886: okc_debug.log('5000: Leaving Variables_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);
5887: END IF;
5888:
5889: IF l_var_interface_csr%ISOPEN THEN
5890: CLOSE l_var_interface_csr;

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

5899: commit;
5900:
5901: WHEN OTHERS THEN
5902: IF (l_debug = 'Y') THEN
5903: okc_debug.log('5000: Leaving Variables_Import because of EXCEPTION: '||sqlerrm, 2);
5904: END IF;
5905: --Insert Errors into Error table if there is any
5906: insert_error_array(
5907: x_return_status => x_return_status,

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

6068: l_target_provision VARCHAR2(1);
6069:
6070: BEGIN
6071: IF (l_debug = 'Y') THEN
6072: okc_debug.log('100: Entered relationships_import', 2);
6073: END IF;
6074:
6075: ------------------------------------------------------------------------
6076: -- Variable Initialization

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

6482:
6483: EXCEPTION
6484: WHEN FND_API.G_EXC_ERROR THEN
6485: IF (l_debug = 'Y') THEN
6486: okc_debug.log('300: In Relationships_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
6487: END IF;
6488: --l_return_status := G_RET_STS_ERROR ;
6489: build_error_array(
6490: p_msg_data => x_msg_data,

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

6502: -- Continue to next row
6503:
6504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6505: IF (l_debug = 'Y') THEN
6506: okc_debug.log('400: Leaving Relationships_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
6507: END IF;
6508:
6509: IF l_rel_interface_csr%ISOPEN THEN
6510: CLOSE l_rel_interface_csr;

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

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

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

6588: -------------------------
6589: EXCEPTION
6590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6591: IF (l_debug = 'Y') THEN
6592: okc_debug.log('400: Leaving Relationships_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
6593: END IF;
6594:
6595: IF l_rel_interface_csr%ISOPEN THEN
6596: CLOSE l_rel_interface_csr;

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

6600: exit; -- exit outermost loop
6601:
6602: WHEN OTHERS THEN
6603: IF (l_debug = 'Y') THEN
6604: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||sqlerrm, 2);
6605: END IF;
6606:
6607: IF l_rel_interface_csr%ISOPEN THEN
6608: CLOSE l_rel_interface_csr;

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

6691: rinf_process_status_tbl(i) in ('S', 'W') ;
6692: EXCEPTION
6693: WHEN OTHERS THEN
6694: IF (l_debug = 'Y') THEN
6695: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
6696: END IF;
6697: END;
6698:
6699: --

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

6730:
6731: EXCEPTION
6732: WHEN OTHERS THEN
6733: IF (l_debug = 'Y') THEN
6734: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
6735: END IF;
6736: END;
6737:
6738: --

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

6822: interface_id = rinf_interface_id_tbl(i);
6823: EXCEPTION
6824: WHEN OTHERS THEN
6825: IF (l_debug = 'Y') THEN
6826: okc_debug.log('500: Leaving Relationships_Import because of EXCEPTION: '||sqlerrm, 2);
6827: END IF;
6828: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6829: p_msg_name => G_UNEXPECTED_ERROR,
6830: p_token1 => G_SQLCODE_TOKEN,

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

6966: */
6967: commit; -- Final commit for status update
6968:
6969: IF (l_debug = 'Y') THEN
6970: okc_debug.log('2000: Leaving relationships import', 2);
6971: END IF;
6972: --x_return_status := l_return_status; this may cause to erase error x_return_status
6973:
6974: EXCEPTION

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

6974: EXCEPTION
6975:
6976: WHEN FND_API.G_EXC_ERROR THEN
6977: IF (l_debug = 'Y') THEN
6978: okc_debug.log('3000: Leaving Relationships_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
6979: END IF;
6980: --Insert Errors into Error table if there is any
6981: insert_error_array(
6982: x_return_status => x_return_status,

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

6986: x_return_status := G_RET_STS_ERROR ;
6987:
6988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6989: IF (l_debug = 'Y') THEN
6990: okc_debug.log('4000: Leaving Relationships_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
6991: END IF;
6992: --Insert Errors into Error table if there is any
6993:
6994: insert_error_array(

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

7013: -- In this exception handling, we don't insert error array again
7014: -- because error happend in the module
7015: --
7016: IF (l_debug = 'Y') THEN
7017: okc_debug.log('5000: Leaving Relationships_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);
7018: END IF;
7019:
7020: IF l_rel_interface_csr%ISOPEN THEN
7021: CLOSE l_rel_interface_csr;

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

7030: commit;
7031:
7032: WHEN OTHERS THEN
7033: IF (l_debug = 'Y') THEN
7034: okc_debug.log('5000: Leaving Relationships_Import because of EXCEPTION: '||sqlerrm, 2);
7035: END IF;
7036: --Insert Errors into Error table if there is any
7037: insert_error_array(
7038: x_return_status => x_return_status,

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

7156:
7157:
7158: BEGIN
7159: IF (l_debug = 'Y') THEN
7160: okc_debug.log('100: Entered valueset_import', 2);
7161: END IF;
7162:
7163:
7164: ------------------------------------------------------------------------

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

7528:
7529: EXCEPTION
7530: WHEN FND_API.G_EXC_ERROR THEN
7531: IF (l_debug = 'Y') THEN
7532: okc_debug.log('300: In Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
7533: END IF;
7534: --l_return_status := G_RET_STS_ERROR ;
7535: build_error_array(
7536: p_msg_data => x_msg_data,

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

7548: -- Continue to next row
7549:
7550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7551: IF (l_debug = 'Y') THEN
7552: okc_debug.log('400: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
7553: END IF;
7554:
7555: IF l_valset_interface_csr%ISOPEN THEN
7556: CLOSE l_valset_interface_csr;

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

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

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

7634: -------------------------
7635: EXCEPTION
7636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7637: IF (l_debug = 'Y') THEN
7638: okc_debug.log('400: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
7639: END IF;
7640:
7641: IF l_valset_interface_csr%ISOPEN THEN
7642: CLOSE l_valset_interface_csr;

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

7646: exit; -- exit outermost loop
7647:
7648: WHEN OTHERS THEN
7649: IF (l_debug = 'Y') THEN
7650: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
7651: END IF;
7652:
7653: IF l_valset_interface_csr%ISOPEN THEN
7654: CLOSE l_valset_interface_csr;

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

7729:
7730: EXCEPTION
7731: WHEN OTHERS THEN
7732: IF (l_debug = 'Y') THEN
7733: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
7734: END IF;
7735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
7736: END;
7737:

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

7821: interface_id = vsinf_interface_id_tbl(i);
7822: EXCEPTION
7823: WHEN OTHERS THEN
7824: IF (l_debug = 'Y') THEN
7825: okc_debug.log('500: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
7826: END IF;
7827:
7828: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7829: p_msg_name => G_UNEXPECTED_ERROR,

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

7954: --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');
7955: commit; -- Final commit for status update
7956:
7957: IF (l_debug = 'Y') THEN
7958: okc_debug.log('2000: Leaving Fnd_flex_value_sets import', 2);
7959: END IF;
7960: --x_return_status := l_return_status; this may cause to erase error x_return_status
7961:
7962: EXCEPTION

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

7962: EXCEPTION
7963:
7964: WHEN FND_API.G_EXC_ERROR THEN
7965: IF (l_debug = 'Y') THEN
7966: okc_debug.log('3000: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
7967: END IF;
7968: --Insert Errors into Error table if there is any
7969: insert_error_array(
7970: x_return_status => x_return_status,

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

7974: x_return_status := G_RET_STS_ERROR ;
7975:
7976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7977: IF (l_debug = 'Y') THEN
7978: okc_debug.log('4000: Leaving Fnd_flex_value_sets_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
7979: END IF;
7980: --Insert Errors into Error table if there is any
7981:
7982: insert_error_array(

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

8001: -- In this exception handling, we don't insert error array again
8002: -- because error happend in the module
8003: --
8004: IF (l_debug = 'Y') THEN
8005: okc_debug.log('5000: Leaving Fnd_flex_value_sets_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);
8006: END IF;
8007:
8008: IF l_valset_interface_csr%ISOPEN THEN
8009: CLOSE l_valset_interface_csr;

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

8018: commit;
8019:
8020: WHEN OTHERS THEN
8021: IF (l_debug = 'Y') THEN
8022: okc_debug.log('5000: Leaving Fnd_flex_value_sets_Import because of EXCEPTION: '||sqlerrm, 2);
8023: END IF;
8024: --Insert Errors into Error table if there is any
8025: insert_error_array(
8026: x_return_status => x_return_status,

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

8247:
8248:
8249: BEGIN
8250: IF (l_debug = 'Y') THEN
8251: okc_debug.log('100: Entered values_import', 2);
8252: END IF;
8253:
8254:
8255: ------------------------------------------------------------------------

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

8638:
8639: EXCEPTION
8640: WHEN FND_API.G_EXC_ERROR THEN
8641: IF (l_debug = 'Y') THEN
8642: okc_debug.log('300: In Fnd_flex_values_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
8643: END IF;
8644: IF l_val_exist_csr%ISOPEN THEN
8645: CLOSE l_val_exist_csr;
8646: END IF;

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

8661: -- Continue to next row
8662:
8663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8664: IF (l_debug = 'Y') THEN
8665: okc_debug.log('400: Leaving Fnd_flex_values_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
8666: END IF;
8667:
8668: IF l_val_exist_csr%ISOPEN THEN
8669: CLOSE l_val_exist_csr;

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

8692: exit; -- exit the current fetch
8693:
8694: WHEN OTHERS THEN
8695: IF (l_debug = 'Y') THEN
8696: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||sqlerrm, 2);
8697: END IF;
8698: IF l_val_exist_csr%ISOPEN THEN
8699: CLOSE l_val_exist_csr;
8700: END IF;

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

8752: -------------------------
8753: EXCEPTION
8754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8755: IF (l_debug = 'Y') THEN
8756: okc_debug.log('400: Leaving Fnd_flex_values_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
8757: END IF;
8758: IF l_val_exist_csr%ISOPEN THEN
8759: CLOSE l_val_exist_csr;
8760: END IF;

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

8767: exit; -- exit outermost loop
8768:
8769: WHEN OTHERS THEN
8770: IF (l_debug = 'Y') THEN
8771: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||sqlerrm, 2);
8772: END IF;
8773: IF l_val_exist_csr%ISOPEN THEN
8774: CLOSE l_val_exist_csr;
8775: END IF;

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

8826:
8827: EXCEPTION
8828: WHEN OTHERS THEN
8829: IF (l_debug = 'Y') THEN
8830: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
8831: END IF;
8832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
8833: END;
8834:

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

8863:
8864: EXCEPTION
8865: WHEN OTHERS THEN
8866: IF (l_debug = 'Y') THEN
8867: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||l_context||sqlerrm, 2);
8868: END IF;
8869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
8870: END;
8871:

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

8956: interface_id = vinf_interface_id_tbl(i);
8957: EXCEPTION
8958: WHEN OTHERS THEN
8959: IF (l_debug = 'Y') THEN
8960: okc_debug.log('500: Leaving Fnd_flex_values_Import because of EXCEPTION: '||sqlerrm, 2);
8961: END IF;
8962:
8963: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
8964: p_msg_name => G_UNEXPECTED_ERROR,

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

9100: --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');
9101: commit; -- Final commit for status update
9102:
9103: IF (l_debug = 'Y') THEN
9104: okc_debug.log('2000: Leaving Fnd_flex_values import', 2);
9105: END IF;
9106: --x_return_status := l_return_status; this may cause to erase error x_return_status
9107:
9108: EXCEPTION

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

9108: EXCEPTION
9109:
9110: WHEN FND_API.G_EXC_ERROR THEN
9111: IF (l_debug = 'Y') THEN
9112: okc_debug.log('3000: Leaving Fnd_flex_values_Import: OKC_API.G_EXCEPTION_ERROR Exception', 2);
9113: END IF;
9114: --Insert Errors into Error table if there is any
9115: insert_error_array(
9116: x_return_status => x_return_status,

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

9120: x_return_status := G_RET_STS_ERROR ;
9121:
9122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9123: IF (l_debug = 'Y') THEN
9124: okc_debug.log('4000: Leaving Fnd_flex_values_Import: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
9125: END IF;
9126: --Insert Errors into Error table if there is any
9127:
9128: insert_error_array(

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

9147: -- In this exception handling, we don't insert error array again
9148: -- because error happend in the module
9149: --
9150: IF (l_debug = 'Y') THEN
9151: okc_debug.log('5000: Leaving Fnd_flex_values_Import because of EXCEPTION in insert_error_array: '||sqlerrm, 2);
9152: END IF;
9153:
9154: IF l_val_interface_csr%ISOPEN THEN
9155: CLOSE l_val_interface_csr;

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

9164: commit;
9165:
9166: WHEN OTHERS THEN
9167: IF (l_debug = 'Y') THEN
9168: okc_debug.log('5000: Leaving Fnd_flex_values_Import because of EXCEPTION: '||sqlerrm, 2);
9169: END IF;
9170: --Insert Errors into Error table if there is any
9171: insert_error_array(
9172: x_return_status => x_return_status,

Line 9250: okc_debug.log('1100: Entered scn_import', 2);

9246: AND intf.variable_value = p_variable_value;
9247: */
9248: BEGIN
9249: IF (l_debug = 'Y') THEN
9250: okc_debug.log('1100: Entered scn_import', 2);
9251: END IF;
9252: x_return_status := G_RET_STS_SUCCESS ;
9253:
9254: /*OPEN l_scnmap_interface_csr ( p_batch_number );

Line 9288: okc_debug.log('1200: Leaving scn_map_import because of EXCEPTION: '||sqlerrm, 2);

9284: END LOOP;
9285: EXCEPTION
9286: WHEN OTHERS THEN
9287: IF (l_debug = 'Y') THEN
9288: okc_debug.log('1200: Leaving scn_map_import because of EXCEPTION: '||sqlerrm, 2);
9289: END IF;
9290: x_return_status := G_RET_STS_UNEXP_ERROR ;
9291: */
9292: