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.IBE_M_MIGRATION_PVT dependencies on IBE_M_MIGRATION_PVT

Line 1: PACKAGE BODY IBE_M_MIGRATION_PVT AS

1: PACKAGE BODY IBE_M_MIGRATION_PVT AS
2: /* $Header: IBEVMMGB.pls 120.0 2005/05/30 02:37:07 appldev noship $ */
3: g_image_type CONSTANT VARCHAR2(30) := 'IBC_IMAGE';
4: g_html_type CONSTANT VARCHAR2(30) := 'IBE_HTML';
5: g_media_type CONSTANT VARCHAR2(30) := 'IBE_MEDIA';

Line 267: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

263: PROCEDURE printDebuglog(p_debug_str IN VARCHAR2)
264: IS
265: BEGIN
266: -- dbms_output.put_line(p_debug_str);
267: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
268: FND_FILE.PUT_LINE(FND_FILE.LOG,p_debug_str);
269: END IF;
270: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
271: IBE_UTIL.debug(p_debug_str);

Line 651: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

647: l_file_name VARCHAR2(240);
648: l_translate_flag VARCHAR2(1);
649: l_continue_flag VARCHAR2(1);
650: BEGIN
651: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
652: printDebuglog(' get_base_content begin');
653: printDebuglog(' p_item_id='||p_item_id||' p_msite_id='||p_msite_id||
654: ' p_default_msite='||p_default_msite||' p_language_code='||
655: p_language_code);

Line 732: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

728: x_width := l_width;
729: x_translate_flag := l_translate_flag;
730: x_file_name := l_file_name;
731: END IF;
732: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
733: printDebuglog(' x_file_id='||x_file_id||' x_height='||x_height||
734: ' x_width='||x_width||' x_translate_flag='||x_translate_flag||
735: ' x_file_name='||x_file_name);
736: printDebuglog(' get_base_content end');

Line 740: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

736: printDebuglog(' get_base_content end');
737: END IF;
738: EXCEPTION
739: WHEN OTHERS THEN
740: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
741: printDebuglog('get exception in get_base_content');
742: printDebuglog('sqlcode:'||SQLCODE||' sqlerr;'||SQLERRM);
743: END IF;
744: END get_base_content;

Line 779: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

775: l_width NUMBER;
776: l_file_id NUMBER;
777: l_file_name VARCHAR2(240);
778: BEGIN
779: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
780: printDebuglog(' get_trans_content begin');
781: printDebuglog(' p_item_id='||p_item_id||' p_msite_id='||p_msite_id||
782: ' p_default_msite='||p_default_msite||' p_language_code='||p_language_code||
783: ' p_translate_flag='||p_translate_flag);

Line 823: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

819: x_height := l_height;
820: x_width := l_width;
821: x_file_name := l_file_name;
822: END IF;
823: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
824: printDebuglog(' x_file_id='||x_file_id||' x_height='||x_height||
825: ' x_width='||x_width||' x_file_name='||x_file_name);
826: printDebuglog(' get_trans_content end');
827: END IF;

Line 830: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

826: printDebuglog(' get_trans_content end');
827: END IF;
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
831: printDebuglog('get exception in get_trans_content');
832: printDebuglog('sqlcode:'||SQLCODE||' sqlerr;'||SQLERRM);
833: END IF;
834: END get_trans_content;

Line 1018: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1014: l_label_associate_item VARCHAR2(1);
1015:
1016: BEGIN
1017: SAVEPOINT process_content_item;
1018: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1019: printDebugLog('Start processing item');
1020: END IF;
1021: l_upsert_item := 'Y';
1022: l_label_associate_item := 'Y';

Line 1048: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1044: END IF;
1045: CLOSE c_get_content_item_csr;
1046: ELSIF px_attachment_rec.duplicate_flag = 'Y' THEN
1047: */
1048: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1049: printDebuglog(' duplicate flag='||px_attachment_rec.duplicate_flag);
1050: END IF;
1051: IF px_attachment_rec.duplicate_flag = 'Y' THEN
1052: l_upsert_item := 'N';

Line 1062: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1058: OPEN c_get_content_item_csr(px_attachment_rec.content_item_code,
1059: l_label_code);
1060: FETCH c_get_content_item_csr INTO l_content_item_id, l_citem_version_id;
1061: IF (c_get_content_item_csr%NOTFOUND) THEN
1062: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1063: printDebuglog(' labeled version is not found for '
1064: ||px_attachment_rec.content_item_code||' label '||l_label_code);
1065: END IF;
1066: OPEN c_get_item_version_csr(px_attachment_rec.content_item_code);

Line 1069: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1065: END IF;
1066: OPEN c_get_item_version_csr(px_attachment_rec.content_item_code);
1067: FETCH c_get_item_version_csr INTO l_content_item_id, l_citem_version_id;
1068: IF (c_get_item_version_csr%NOTFOUND) THEN
1069: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1070: printDebuglog(' approved version is not found for '
1071: ||px_attachment_rec.content_item_code);
1072: END IF;
1073: l_upsert_item := 'Y';

Line 1079: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1075: l_citem_version_id := NULL;
1076: OPEN c_get_content_item(px_attachment_rec.content_item_code);
1077: FETCH c_get_content_item INTO l_content_item_id;
1078: IF (c_get_content_item%NOTFOUND) THEN
1079: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1080: printDebuglog(' content item not found for '
1081: ||px_attachment_rec.content_item_code);
1082: END IF;
1083: l_content_item_id := NULL;

Line 1087: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1083: l_content_item_id := NULL;
1084: END IF;
1085: CLOSE c_get_content_item;
1086: ELSE
1087: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1088: printDebuglog(' approved version is found for '
1089: ||px_attachment_rec.content_item_code);
1090: END IF;
1091: l_upsert_item := 'N';

Line 1096: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1092: l_label_associate_item := 'Y';
1093: END IF;
1094: CLOSE c_get_item_version_csr;
1095: ELSE
1096: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1097: printDebuglog(' labeled version is found for '
1098: ||px_attachment_rec.content_item_code||' label '||l_label_code);
1099: END IF;
1100: l_upsert_item := 'N';

Line 1105: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1101: l_label_associate_item := 'N';
1102: END IF;
1103: CLOSE c_get_content_item_csr;
1104: END IF;
1105: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1106: printDebugLog(' l_upsert_item='||l_upsert_item);
1107: printDebugLog(' l_label_associate_item='||l_label_associate_item);
1108: printDebugLog(' After finding content item id and citem version id');
1109: printDebugLog(' content item id:'||l_content_item_id

Line 1114: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1110: ||' Citem version id:'||l_citem_version_id);
1111: END IF;
1112:
1113: -- IF (l_content_item_id IS NULL) THEN
1114: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1115: printDebugLog(' upsert content item flag:'||l_upsert_item);
1116: END IF;
1117: IF (px_attachment_rec.duplicate_flag <> 'Y')
1118: AND (l_upsert_item = 'Y') THEN

Line 1128: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1124: l_attribute_type_codes.extend(1);
1125: l_attributes.extend(1);
1126: l_attribute_type_codes(l_attidx) := 'WIDTH';
1127: l_attributes(l_attidx) := px_attachment_rec.width;
1128: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1129: printDebugLog(' attribute index:'||l_attidx);
1130: printDebugLog(' attribute_type_code:'||l_attribute_type_codes(l_attidx));
1131: printDebugLog(' attribute_value:'||l_attributes(l_attidx));
1132: END IF;

Line 1140: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1136: l_attribute_type_codes.extend(1);
1137: l_attributes.extend(1);
1138: l_attribute_type_codes(l_attidx) := 'HEIGHT';
1139: l_attributes(l_attidx) := px_attachment_rec.height;
1140: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1141: printDebugLog(' attribute index:'||l_attidx);
1142: printDebugLog(' attribute_type_code:'||l_attribute_type_codes(l_attidx));
1143: printDebugLog(' attribute_value:'||l_attributes(l_attidx));
1144: END IF;

Line 1147: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1143: printDebugLog(' attribute_value:'||l_attributes(l_attidx));
1144: END IF;
1145: END IF;
1146: IF l_attidx = 0 THEN
1147: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1148: printDebugLog(' attribute type is null');
1149: printDebugLog(' attribute value is null');
1150: END IF;
1151: l_attribute_type_codes := NULL;

Line 1155: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1151: l_attribute_type_codes := NULL;
1152: l_attributes := NULL;
1153: END IF;
1154:
1155: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1156: printDebugLog(' Start upserting content item');
1157: printDebugLog(' type code:'||px_attachment_rec.content_type_code);
1158: printDebugLog(' name:'||px_attachment_rec.FILE_NAME);
1159: printDebugLog(' description:'||px_attachment_rec.FILE_NAME);

Line 1189: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1185: px_object_version_number => l_object_version_number,
1186: x_return_status => l_return_status,
1187: x_msg_count => l_msg_count,
1188: x_msg_data => l_msg_data);
1189: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1190: printDebugLog(' OCM base content item creation status:'||l_return_status);
1191: END IF;
1192: IF l_return_status <> FND_API.g_ret_sts_success THEN
1193: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 1193: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1189: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1190: printDebugLog(' OCM base content item creation status:'||l_return_status);
1191: END IF;
1192: IF l_return_status <> FND_API.g_ret_sts_success THEN
1193: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1194: printDebugLog(' Error in base content item creation:');
1195: END IF;
1196: for i in 1..l_msg_count loop
1197: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 1198: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1194: printDebugLog(' Error in base content item creation:');
1195: END IF;
1196: for i in 1..l_msg_count loop
1197: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1198: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1199: printDebugLog(' '||l_msg_data);
1200: END IF;
1201: end loop;
1202: x_msg_data := l_msg_data;

Line 1207: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1203: RAISE FND_API.g_exc_error;
1204: END IF;
1205: px_attachment_rec.content_item_id := l_content_item_id;
1206: px_attachment_rec.citem_version_id := l_citem_version_id;
1207: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1208: printDebugLog(' End upserting content item');
1209: printDebugLog(' content_item_id:'||l_content_item_id);
1210: printDebugLog(' citem_version_id:'||l_citem_version_id);
1211: printDebugLog(' object_version_num:'||l_object_version_number);

Line 1216: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1212: END IF;
1213: IF (px_attachment_rec.start_trans <> -1) THEN
1214: FOR l_j IN
1215: px_attachment_rec.start_trans..px_attachment_rec.end_trans LOOP
1216: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1217: printDebugLog(' Start upserting translation of content item');
1218: printDebugLog(' language:'||px_attachment_rec.language);
1219: END IF;
1220: IBC_CITEM_ADMIN_GRP.upsert_item(

Line 1242: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1238: px_object_version_number => l_object_version_number,
1239: x_return_status => l_return_status,
1240: x_msg_count => l_msg_count,
1241: x_msg_data => l_msg_data);
1242: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1243: printDebugLog(' OCM translating content item status:'||l_return_status);
1244: END IF;
1245: IF l_return_status <> FND_API.g_ret_sts_success THEN
1246: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 1246: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1242: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1243: printDebugLog(' OCM translating content item status:'||l_return_status);
1244: END IF;
1245: IF l_return_status <> FND_API.g_ret_sts_success THEN
1246: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1247: printDebugLog(' Error in translating content item!');
1248: END IF;
1249: for i in 1..l_msg_count loop
1250: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 1251: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1247: printDebugLog(' Error in translating content item!');
1248: END IF;
1249: for i in 1..l_msg_count loop
1250: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1251: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1252: printDebugLog(' '||l_msg_data);
1253: END IF;
1254: end loop;
1255: x_msg_data := l_msg_data;

Line 1262: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1258: END LOOP;
1259: END IF;
1260: END IF;
1261:
1262: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1263: printDebugLog('Label association flag:'|| l_label_associate_item);
1264: printDebugLog('Label flag:'|| p_label_flag);
1265: END IF;
1266: IF (p_label_flag = 'Y') AND (l_label_associate_item = 'Y') THEN

Line 1271: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1267: -- l_assoc_type_codes := JTF_VARCHAR2_TABLE_100();
1268: -- l_assoc_objects := JTF_VARCHAR2_TABLE_300();
1269: -- l_assoc_type_codes.extend(1);
1270: -- l_assoc_objects.extend(1);
1271: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1272: printDebugLog('Labeling starts');
1273: printDebugLog('p_new_content_item_id:'||l_content_item_id);
1274: printDebugLog('p_new_version_number:'||l_citem_version_id);
1275: printDebugLog('p_media_object_id:'||px_attachment_rec.item_id);

Line 1282: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1278: IF (l_content_item_id IS NOT NULL) AND (l_citem_version_id IS NOT NULL) THEN
1279: OPEN c_get_version_number(l_citem_version_id);
1280: FETCH c_get_version_number INTO l_version_number;
1281: CLOSE c_get_version_number;
1282: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1283: printDebugLog('p_new_version_number:'||l_version_number);
1284: END IF;
1285: IF (l_move_label = 1) THEN
1286: l_old_item := l_content_item_id;

Line 1290: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1286: l_old_item := l_content_item_id;
1287: OPEN c_get_version_number(l_old_version);
1288: FETCH c_get_version_number INTO l_old_ver_num;
1289: CLOSE c_get_version_number;
1290: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1291: printDebugLog('p_old_version_number:'||l_old_ver_num);
1292: END IF;
1293: ELSE
1294: l_old_item := NULL;

Line 1297: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1293: ELSE
1294: l_old_item := NULL;
1295: l_old_ver_num := NULL;
1296: END IF;
1297: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1298: printDebugLog('Update_Label_Association Starts');
1299: printDebugLog('p_old_content_item_id:'||l_old_item);
1300: printDebugLog('p_old_version_number:'||l_old_ver_num);
1301: printDebugLog('p_new_content_item_id:'||l_content_item_id);

Line 1320: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1316: p_association_type_code => l_association_type,
1317: x_return_status => l_return_status,
1318: x_msg_count => l_msg_count,
1319: x_msg_data => l_msg_data);
1320: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1321: printDebugLog(' Labeling ends:'||l_return_status);
1322: END IF;
1323: IF l_return_status <> FND_API.g_ret_sts_success THEN
1324: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 1324: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1320: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1321: printDebugLog(' Labeling ends:'||l_return_status);
1322: END IF;
1323: IF l_return_status <> FND_API.g_ret_sts_success THEN
1324: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1325: printDebugLog(' Error in labeling and associating content item!');
1326: END IF;
1327: for i in 1..l_msg_count loop
1328: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

Line 1329: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1325: printDebugLog(' Error in labeling and associating content item!');
1326: END IF;
1327: for i in 1..l_msg_count loop
1328: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1329: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1330: printDebugLog(' '||l_msg_data);
1331: END IF;
1332: end loop;
1333: x_msg_data := l_msg_data;

Line 1340: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1336: END IF;
1337: END IF;
1338: END IF;
1339:
1340: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1341: printDebugLog('id:'||l_lgl_phys_map_id);
1342: printDebugLog('msite:'||px_attachment_rec.msite_id);
1343: printDebugLog('item_id:'||px_attachment_rec.item_id);
1344: printDebugLog('def site:'||px_attachment_rec.default_site);

Line 1361: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1357: IF (l_j = 0) THEN
1358: OPEN c_get_lgl_phys_map_id_csr;
1359: FETCH c_get_lgl_phys_map_id_csr INTO l_lgl_phys_map_id;
1360: CLOSE c_get_lgl_phys_map_id_csr;
1361: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1362: printDebugLog('id:'||l_lgl_phys_map_id);
1363: printDebugLog('msite:'||px_attachment_rec.msite_id);
1364: printDebugLog('item_id:'||px_attachment_rec.item_id);
1365: printDebugLog('def site:'||px_attachment_rec.default_site);

Line 1386: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1382: x_return_status := FND_API.g_ret_sts_success;
1383: EXCEPTION
1384: WHEN OTHERS THEN
1385: ROLLBACK TO process_content_item;
1386: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1387: printDebugLog(' Exception in process_content_item:');
1388: printDebugLog(' '||SQLCODE||'-'||SQLERRM);
1389: END IF;
1390: x_return_status := FND_API.g_ret_sts_error;

Line 1419: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1415: BEGIN
1416: SAVEPOINT process_content_items;
1417: l_list_flag := 'Y';
1418: x_return_status := FND_API.g_ret_sts_success;
1419: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1420: printDebugLog(' process_content_items begin');
1421: END IF;
1422: IF px_attachment_tbl.count > 0 THEN
1423: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 1423: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1419: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1420: printDebugLog(' process_content_items begin');
1421: END IF;
1422: IF px_attachment_tbl.count > 0 THEN
1423: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1424: printDebugLog(' content item number='||px_attachment_tbl.count);
1425: END IF;
1426: FOR l_i IN 1..px_attachment_tbl.count LOOP
1427: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 1427: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1423: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1424: printDebugLog(' content item number='||px_attachment_tbl.count);
1425: END IF;
1426: FOR l_i IN 1..px_attachment_tbl.count LOOP
1427: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1428: printDebugLog(' Content item '||l_i
1429: ||' item code:'||px_attachment_tbl(l_i).content_item_code
1430: ||' file id:'||px_attachment_tbl(l_i).file_id
1431: ||' file name:'||px_attachment_tbl(l_i).file_name);

Line 1436: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1432: END IF;
1433: IF (px_attachment_tbl(l_i).file_id <> -1) AND
1434: (px_attachment_tbl(l_i).file_id IS NOT NULL) THEN
1435: px_attachment_tbl(l_i).duplicate_flag := 'N';
1436: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1437: printDebugLog('Check duplicate');
1438: END IF;
1439: FOR l_j IN 1..(l_i-1) LOOP
1440: l_duplicate := compareContentItem(l_src_att => px_attachment_tbl(l_i),

Line 1452: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1448: px_attachment_tbl(l_i).CONTENT_ITEM_CODE
1449: := px_attachment_tbl(l_j).content_item_code;
1450: END IF;
1451: END LOOP;
1452: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1453: printDebugLog(' Duplicate flag='
1454: || px_attachment_tbl(l_i).duplicate_flag);
1455: END IF;
1456: contentItemType(p_attachment_rec => px_attachment_tbl(l_i));

Line 1457: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1453: printDebugLog(' Duplicate flag='
1454: || px_attachment_tbl(l_i).duplicate_flag);
1455: END IF;
1456: contentItemType(p_attachment_rec => px_attachment_tbl(l_i));
1457: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1458: printDebugLog(' Content type='
1459: || px_attachment_tbl(l_i).content_type_code);
1460: END IF;
1461: -- Check list flag

Line 1462: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1458: printDebugLog(' Content type='
1459: || px_attachment_tbl(l_i).content_type_code);
1460: END IF;
1461: -- Check list flag
1462: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1463: printDebugLog(' Check list flag');
1464: END IF;
1465: OPEN c_get_content_item(px_attachment_tbl(l_i).CONTENT_ITEM_CODE);
1466: FETCH c_get_content_item INTO l_item_id, l_date;

Line 1473: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1469: l_list_flag := 'N';
1470: END IF;
1471: END IF;
1472: CLOSE c_get_content_item;
1473: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1474: printDebugLog(' List flag='||l_list_flag);
1475: END IF;
1476: l_return_status := FND_API.g_ret_sts_success;
1477: IF g_mode = 'EXECUTION' THEN

Line 1478: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1474: printDebugLog(' List flag='||l_list_flag);
1475: END IF;
1476: l_return_status := FND_API.g_ret_sts_success;
1477: IF g_mode = 'EXECUTION' THEN
1478: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1479: printDebugLog(' process_content_item start');
1480: printDebugLog(' p_label_flag='||p_label_flag);
1481: END IF;
1482: process_content_item(

Line 1488: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1484: px_attachment_rec => px_attachment_tbl(l_i),
1485: x_return_status => l_return_status,
1486: x_msg_count => l_msg_count,
1487: x_msg_data => l_msg_data);
1488: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1489: printDebugLog(' process_content_item return:'||l_return_status);
1490: END IF;
1491: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
1492: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 1492: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1488: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1489: printDebugLog(' process_content_item return:'||l_return_status);
1490: END IF;
1491: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
1492: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1493: printDebugLog(' Error in processing content item');
1494: printDebugLog(' '||l_msg_data);
1495: END IF;
1496: x_msg_data := l_msg_data;

Line 1592: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1588: END IF;
1589: END LOOP;
1590: COMMIT;
1591: END IF;
1592: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1593: printDebuglog(' process_content_items end');
1594: END IF;
1595: x_msg_data := '';
1596: EXCEPTION

Line 1599: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1595: x_msg_data := '';
1596: EXCEPTION
1597: WHEN OTHERS THEN
1598: ROLLBACK TO process_content_items;
1599: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1600: printDebuglog(' exception in process_content_items end');
1601: printDebuglog(' '||SQLCODE||'-'||SQLERRM);
1602: END IF;
1603: x_return_status := FND_API.g_ret_sts_error;

Line 1795: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1791: INSTALLED_LANGDESC(l_i) := l_langdesc;
1792: IF (l_lang = p_default_mig_lang) THEN
1793: l_default_langdesc := l_langdesc;
1794: END IF;
1795: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1796: printDebuglog('Installed language '||l_i||':'||l_lang);
1797: END IF;
1798: END LOOP;
1799: CLOSE c_get_installed_lang_csr;

Line 1814: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1810: l_index := 0;
1811: l_attachment_tbl.delete;
1812: l_trans_attachment_tbl.delete;
1813:
1814: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1815: printDebuglog('Item id:'||l_item_id||' Access name:'||l_access_name);
1816: END IF;
1817: -- Find all minisites this media object linked to
1818: OPEN c_get_item_sites_csr(l_item_id);

Line 1825: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1821: l_store_lang;
1822: EXIT WHEN c_get_item_sites_csr%NOTFOUND;
1823: l_i := l_i + 1;
1824: l_index := l_index + 1;
1825: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1826: printDebuglog(' Msite id:'||l_msite_id||' Store code:'||l_store_code||
1827: ' default site:'||l_default_site||' Store lang:'||l_store_lang);
1828: END IF;
1829: l_attachment_tbl(l_i).item_id := l_item_id;

Line 1853: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1849: END IF;
1850: ELSE
1851: l_attachment_tbl(l_i).language := l_store_lang;
1852: END IF;
1853: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1854: printDebuglog(' Seed data:'||l_attachment_tbl(l_i).seed_data_flag);
1855: printDebuglog(' Before get_base_content:');
1856: printDebuglog(' p_item_id='||l_attachment_tbl(l_i).item_id);
1857: printDebuglog(' p_msite_id='||l_attachment_tbl(l_i).msite_id);

Line 1870: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1866: x_file_name => l_attachment_tbl(l_i).file_name,
1867: x_height => l_attachment_tbl(l_i).height,
1868: x_width => l_attachment_tbl(l_i).width,
1869: x_translate_flag => l_translate_flag);
1870: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1871: printDebuglog(' After get_base_content:');
1872: printDebuglog(' x_file_id='||l_attachment_tbl(l_i).file_id);
1873: printDebuglog(' x_file_name='||l_attachment_tbl(l_i).file_name);
1874: printDebuglog(' x_height='||l_attachment_tbl(l_i).height);

Line 1885: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1881: FOR l_j IN 1..installed_languages.COUNT LOOP
1882: IF installed_languages(l_j)=l_attachment_tbl(l_i).language THEN
1883: l_attachment_tbl(l_i).langdesc := installed_langdesc(l_j);
1884: ELSE
1885: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1886: printDebuglog(' Before get_trans_content:');
1887: printDebuglog(' p_item_id='||l_attachment_tbl(l_i).item_id);
1888: printDebuglog(' p_msite_id='||l_attachment_tbl(l_i).msite_id);
1889: printDebuglog(' p_default_msite='||l_attachment_tbl(l_i).default_site);

Line 1902: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1898: x_file_id => l_file_id,
1899: x_file_name => l_file_name,
1900: x_height => l_height,
1901: x_width => l_width);
1902: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1903: printDebuglog(' After get_trans_content:');
1904: printDebuglog(' x_file_id='||l_file_id);
1905: printDebuglog(' x_file_name='||l_file_name);
1906: printDebuglog(' x_height='||l_height);

Line 1924: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1920: l_trans_attachment_tbl(l_k).HIGHTS := l_height;
1921: l_trans_attachment_tbl(l_k).WIDTHS := l_width;
1922: l_attachment_tbl(l_i).end_trans := l_k;
1923: END IF;
1924: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1925: printDebuglog(' tran start='||l_attachment_tbl(l_i).start_trans);
1926: printDebuglog(' tran end='||l_attachment_tbl(l_i).end_trans);
1927: END IF;
1928: END IF;

Line 1932: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1928: END IF;
1929: END LOOP;
1930: END LOOP;
1931: CLOSE c_get_item_sites_csr;
1932: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1933: printDebuglog(' Before process_content_items');
1934: END IF;
1935: process_content_items(
1936: p_label_flag => 'Y',

Line 1941: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1937: px_attachment_tbl => l_attachment_tbl,
1938: x_return_status => l_return_status,
1939: x_msg_count => l_msg_count,
1940: x_msg_data => l_msg_data);
1941: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1942: printDebuglog(' process_content_items return:'||l_return_status);
1943: END IF;
1944: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1945: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 1945: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1941: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1942: printDebuglog(' process_content_items return:'||l_return_status);
1943: END IF;
1944: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1945: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1946: printDebuglog(' exception in process_content_items');
1947: END IF;
1948: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1949: END IF;

Line 1958: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1954: l_k := 0;
1955: l_index := 0;
1956: l_attachment_tbl.delete;
1957: l_trans_attachment_tbl.delete;
1958: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1959: printDebuglog('Content repository migration');
1960: END IF;
1961: OPEN c_get_content_repository_csr;
1962: LOOP

Line 1984: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1980: l_attachment_tbl(l_i).file_name := l_file_name;
1981: l_attachment_tbl(l_i).height := l_height;
1982: l_attachment_tbl(l_i).width := l_width;
1983: END LOOP;
1984: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1985: printDebuglog(' Before process_content_items for content repository');
1986: END IF;
1987: process_content_items(
1988: p_label_flag => 'N',

Line 1993: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1989: px_attachment_tbl => l_attachment_tbl,
1990: x_return_status => l_return_status,
1991: x_msg_count => l_msg_count,
1992: x_msg_data => l_msg_data);
1993: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1994: printDebuglog(' After process_content_items for content repository:'||l_return_status);
1995: END IF;
1996: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1997: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 1997: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1993: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1994: printDebuglog(' After process_content_items for content repository:'||l_return_status);
1995: END IF;
1996: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1997: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
1998: printDebuglog(' exception in process_content_items for content repository:');
1999: printDebuglog(' '||l_msg_data);
2000: END IF;
2001: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 2003: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

1999: printDebuglog(' '||l_msg_data);
2000: END IF;
2001: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2002: END IF;
2003: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2004: printDebuglog('Content repository migration End');
2005: END IF;
2006: x_status := FND_API.g_ret_sts_success;
2007: EXCEPTION

Line 2035: IBE_M_MIGRATION_PVT.g_debug := p_debug_flag;

2031: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2032: END IF;
2033: END IF;
2034: IF p_debug_flag = 'Y' THEN
2035: IBE_M_MIGRATION_PVT.g_debug := p_debug_flag;
2036: END IF;
2037: g_mode := p_mode;
2038: g_language := p_default_lang;
2039: g_start_time := SYSDATE;

Line 2040: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2036: END IF;
2037: g_mode := p_mode;
2038: g_language := p_default_lang;
2039: g_start_time := SYSDATE;
2040: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2041: printDebuglog('Parameter list:');
2042: printDebuglog(' p_mode = '||p_mode);
2043: printDebuglog(' p_default_lang = '||p_default_lang);
2044: printDebuglog(' p_debug_flag = '||p_debug_flag);

Line 2051: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2047: ||to_char(g_start_time,'DD-MON-RRRR HH24:MI:SS'));
2048: END IF;
2049:
2050: IF (p_mode = 'EXECUTION') THEN
2051: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2052: printDebuglog('Set IBE directory node to be hidden');
2053: END IF;
2054: -- Ibc_Directory_Nodes_Pkg.UPDATE_ROW (
2055: -- p_DIRECTORY_NODE_ID => 9 ,

Line 2063: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2059: EXECUTE IMMEDIATE 'begin Ibc_Directory_Nodes_Pkg.UPDATE_ROW '||
2060: '(p_DIRECTORY_NODE_ID => 9 ,p_DIRECTORY_NODE_CODE => NULL, '||
2061: 'p_HIDDEN_FLAG => ''Y''); END;';
2062: END;
2063: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2064: printDebuglog('After setring IBE directory node to be hidden');
2065: END IF;
2066: END IF;
2067:

Line 2070: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2066: END IF;
2067:
2068: -- Check all attachment files to be migrated
2069: -- can be recognized by the program
2070: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2071: printDebuglog('Check the attachment file type');
2072: END IF;
2073: attachType;
2074: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 2074: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2070: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2071: printDebuglog('Check the attachment file type');
2072: END IF;
2073: attachType;
2074: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2075: printDebuglog('After checking the attachment file type');
2076: END IF;
2077: -- Migrate the attachments to OCM content item
2078: -- based on the logical items

Line 2079: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2075: printDebuglog('After checking the attachment file type');
2076: END IF;
2077: -- Migrate the attachments to OCM content item
2078: -- based on the logical items
2079: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2080: printDebuglog('Migrate attachment based on the mapping');
2081: printDebuglog(' p_mode = '||p_mode);
2082: printDebuglog(' p_default_mig_lang = '||p_default_lang);
2083: END IF;

Line 2087: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2083: END IF;
2084: attachment_mig(p_mode => p_mode,
2085: p_default_mig_lang => p_default_lang,
2086: x_status => l_msg_data);
2087: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2088: printDebuglog('After migrating attachment:');
2089: printDebuglog(' status_message='||l_msg_data);
2090: END IF;
2091: l_status := substr(l_msg_data,1,length(FND_API.G_RET_STS_SUCCESS));

Line 2096: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2092: IF (l_status <> FND_API.G_RET_STS_SUCCESS) THEN
2093: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2094: END IF;
2095: IF (p_mode = 'EXECUTION') THEN
2096: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2097: printDebuglog('Set the profile for iStore-OCM integration');
2098: END IF;
2099: l_msg_data := 'Error when setting up the profile';
2100: -- Set the integration profile to 'Y'

Line 2108: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2104: l_set_prof := FND_PROFILE.save('IBE_M_USE_CONTENT_INTEGRATION','Y','SITE');
2105:
2106: -- FND_PROFILE.put('IBE_M_USE_CONTENT_INTEGRATION', 'Y');
2107: l_msg_data := '';
2108: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2109: printDebuglog('After setting the profile for iStore-OCM integration');
2110: END IF;
2111: END IF;
2112: g_end_time := SYSDATE;

Line 2113: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2109: printDebuglog('After setting the profile for iStore-OCM integration');
2110: END IF;
2111: END IF;
2112: g_end_time := SYSDATE;
2113: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2114: printDebuglog('Print migration report');
2115: END IF;
2116: printReport;
2117: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 2117: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2113: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2114: printDebuglog('Print migration report');
2115: END IF;
2116: printReport;
2117: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2118: printDebuglog('After printing migration report');
2119: END IF;
2120: IF (p_mode = 'EXECUTION') THEN
2121: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 2121: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2117: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2118: printDebuglog('After printing migration report');
2119: END IF;
2120: IF (p_mode = 'EXECUTION') THEN
2121: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2122: printDebuglog('Set IBE directory node to be visible');
2123: END IF;
2124: --Ibc_Directory_Nodes_Pkg.UPDATE_ROW (
2125: -- p_DIRECTORY_NODE_ID => 9 , -- This is the Folder id of iStore

Line 2133: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2129: EXECUTE IMMEDIATE 'begin Ibc_Directory_Nodes_Pkg.UPDATE_ROW '||
2130: '(p_DIRECTORY_NODE_ID => 9 ,p_DIRECTORY_NODE_CODE => NULL, '||
2131: 'p_HIDDEN_FLAG => ''N''); END;';
2132: END;
2133: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2134: printDebuglog('After setting IBE directory node to be visible');
2135: END IF;
2136:
2137: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 2137: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2133: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2134: printDebuglog('After setting IBE directory node to be visible');
2135: END IF;
2136:
2137: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2138: printDebuglog('Update log for migration');
2139: END IF;
2140: update_log(p_code => 'IBE_OCM_MIG',
2141: p_old_status => 'START',

Line 2144: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2140: update_log(p_code => 'IBE_OCM_MIG',
2141: p_old_status => 'START',
2142: p_new_status => 'SUCCESS',
2143: x_status => l_status);
2144: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2145: printDebuglog('After updating log for migration:'||l_status);
2146: END IF;
2147: IF (l_status <> FND_API.G_RET_STS_SUCCESS) THEN
2148: l_msg_data := 'Error when updating log file';

Line 2155: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2151: END IF;
2152: END IF;
2153: -- Insert the log into IBE_MIGRATION_HISTORY
2154: IF (p_clean_flag = 'Y') THEN
2155: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2156: printDebuglog('Clean old data');
2157: END IF;
2158: clean_data(x_return_status => l_status);
2159: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

Line 2159: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2155: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2156: printDebuglog('Clean old data');
2157: END IF;
2158: clean_data(x_return_status => l_status);
2159: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2160: printDebuglog('After cleaning old data:'||l_status);
2161: END IF;
2162: IF (l_status <> FND_API.g_ret_sts_success) THEN
2163: l_msg_data := 'Error when cleaning old data';

Line 2173: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2169: COMMIT;
2170: EXCEPTION
2171: WHEN OTHERS THEN
2172: IF (p_mode = 'EXECUTION') THEN
2173: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2174: printDebuglog('Exception occurs, need to set the folder visible!');
2175: printDebuglog('Set IBE directory node to be visible');
2176: END IF;
2177: --Ibc_Directory_Nodes_Pkg.UPDATE_ROW (

Line 2187: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2183: '(p_DIRECTORY_NODE_ID => 9 ,p_DIRECTORY_NODE_CODE => NULL, '||
2184: 'p_HIDDEN_FLAG => ''N''); END;';
2185: COMMIT;
2186: END;
2187: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2188: printDebuglog('After setting IBE directory node to be visible');
2189: END IF;
2190: END IF;
2191: printOutput(l_msg_data||' '||SQLCODE||'-'||SQLERRM);

Line 2192: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN

2188: printDebuglog('After setting IBE directory node to be visible');
2189: END IF;
2190: END IF;
2191: printOutput(l_msg_data||' '||SQLCODE||'-'||SQLERRM);
2192: IF IBE_M_MIGRATION_PVT.g_debug = 'Y' THEN
2193: printDebuglog(l_msg_data||' '||SQLCODE||'-'||SQLERRM);
2194: END IF;
2195: retcode := -1;
2196: errbuf := l_msg_data||' '||SQLCODE||'-'||SQLERRM;

Line 2199: END IBE_M_MIGRATION_PVT;

2195: retcode := -1;
2196: errbuf := l_msg_data||' '||SQLCODE||'-'||SQLERRM;
2197: END ocmMigration;
2198:
2199: END IBE_M_MIGRATION_PVT;