[Home] [Help]
310: l_migrate_count := 0;
311: -- dbms_output.put_line ('Started INVENTORY TYPES migration');
312: GMA_COMMON_LOGGING.gma_migration_central_log (
313: p_run_id => p_migration_run_id,
314: p_log_level => FND_LOG.LEVEL_PROCEDURE,
315: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
316: p_table_name => 'IC_INVN_TYP',
317: p_context => 'INVENTORY TYPES',
318: p_param1 => NULL,
339: -- No migration needed, skip it.
340: -- dbms_output.put_line ('Inventory type '||l_inv_type.inv_type||' already exist in discrete.');
341: GMA_COMMON_LOGGING.gma_migration_central_log (
342: p_run_id => p_migration_run_id,
343: p_log_level => FND_LOG.LEVEL_PROCEDURE,
344: p_message_token => 'GMI_MIG_TYPE_EXISTS',
345: p_table_name => 'IC_INVN_TYP',
346: p_context => 'INVENTORY TYPES',
347: p_param1 => l_inv_type.inv_type,
413:
414: -- dbms_output.put_line ('Completed INVENTORY TYPES migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
415: GMA_COMMON_LOGGING.gma_migration_central_log (
416: p_run_id => p_migration_run_id,
417: p_log_level => FND_LOG.LEVEL_PROCEDURE,
418: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
419: p_table_name => 'IC_INVN_TYP',
420: p_context => 'INVENTORY TYPES',
421: p_param1 => l_migrate_count,
430: x_failure_count := x_failure_count + 1;
431: -- dbms_output.put_line (substr(SQLERRM,1,255));
432: GMA_COMMON_LOGGING.gma_migration_central_log (
433: p_run_id => p_migration_run_id,
434: p_log_level => FND_LOG.LEVEL_ERROR,
435: p_message_token => 'GMA_MIGRATION_DB_ERROR',
436: p_table_name => 'IC_INVN_TYP',
437: p_context => 'INVENTORY TYPES',
438: p_param1 => NULL,
489: l_migrate_count := 0;
490: -- dbms_output.put_line ('Started CATEGORY SETS migration');
491: GMA_COMMON_LOGGING.gma_migration_central_log (
492: p_run_id => p_migration_run_id,
493: p_log_level => FND_LOG.LEVEL_PROCEDURE,
494: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
495: p_table_name => 'GMI_CATEGORY_SETS',
496: p_context => 'CATEGORY SETS',
497: p_param1 => NULL,
517: IF (l_category_set_id <> -1) THEN
518: -- dbms_output.put_line ('Default category set already assigned for '||c.user_opm_class);
519: GMA_COMMON_LOGGING.gma_migration_central_log (
520: p_run_id => p_migration_run_id,
521: p_log_level => FND_LOG.LEVEL_PROCEDURE,
522: p_message_token => 'GMI_MIG_CAT_SET_ASSIGNED',
523: p_table_name => 'GMI_CATEGORY_SETS',
524: p_context => 'CATEGORY SETS',
525: p_param1 => c.user_opm_class,
554: WHEN NO_DATA_FOUND THEN
555: -- dbms_output.put_line ('Functional area does not exist in discrete : '||c.user_opm_class);
556: GMA_COMMON_LOGGING.gma_migration_central_log (
557: p_run_id => p_migration_run_id,
558: p_log_level => FND_LOG.LEVEL_PROCEDURE,
559: p_message_token => 'GMI_MIG_NO_FUNC_AREA',
560: p_table_name => 'GMI_CATEGORY_SETS',
561: p_context => 'CATEGORY SETS',
562: p_param1 => c.user_opm_class,
571:
572: -- dbms_output.put_line ('Completed CATEGORY SETS migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
573: GMA_COMMON_LOGGING.gma_migration_central_log (
574: p_run_id => p_migration_run_id,
575: p_log_level => FND_LOG.LEVEL_PROCEDURE,
576: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
577: p_table_name => 'GMI_CATEGORY_SETS',
578: p_context => 'CATEGORY SETS',
579: p_param1 => NULL,
588: x_failure_count := x_failure_count + 1;
589: -- dbms_output.put_line (substr(SQLERRM,1,255));
590: GMA_COMMON_LOGGING.gma_migration_central_log (
591: p_run_id => p_migration_run_id,
592: p_log_level => FND_LOG.LEVEL_ERROR,
593: p_message_token => 'GMA_MIGRATION_DB_ERROR',
594: p_table_name => 'GMI_CATEGORY_SETS',
595: p_context => 'CATEGORY SETS',
596: p_param1 => NULL,
655: l_migrate_count := 0;
656: -- dbms_output.put_line ('Started ITEM CATEGORIES migration');
657: GMA_COMMON_LOGGING.gma_migration_central_log (
658: p_run_id => p_migration_run_id,
659: p_log_level => FND_LOG.LEVEL_PROCEDURE,
660: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
661: p_table_name => 'GMI_ITEM_CATEGORIES',
662: p_context => 'ITEM CATEGORIES',
663: p_param1 => NULL,
720: -- Log warning message
721: -- dbms_output.put_line ('A different category already assigned in discrete. Org id, Item, category set id' || to_char(r.organization_id)||', '||to_char(v_inventory_item_id)||', '||to_char(r.category_set_id));
722: GMA_COMMON_LOGGING.gma_migration_central_log (
723: p_run_id => p_migration_run_id,
724: p_log_level => FND_LOG.LEVEL_PROCEDURE,
725: p_message_token => 'GMI_MIG_ITEM_CAT_EXISTS',
726: p_table_name => 'GMI_ITEM_CATEGORIES',
727: p_context => 'ITEM CATEGORIES',
728: p_param1 => INV_GMI_Migration.org(r.organization_id),
758:
759: -- dbms_output.put_line ('Completed ITEM CATEGORIES migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
760: GMA_COMMON_LOGGING.gma_migration_central_log (
761: p_run_id => p_migration_run_id,
762: p_log_level => FND_LOG.LEVEL_PROCEDURE,
763: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
764: p_table_name => 'GMI_ITEM_CATEGORIES',
765: p_context => 'ITEM CATEGORIES',
766: p_param1 => l_migrate_count,
775: x_failure_count := x_failure_count + 1;
776: -- dbms_output.put_line (substr(SQLERRM,1,255));
777: GMA_COMMON_LOGGING.gma_migration_central_log (
778: p_run_id => p_migration_run_id,
779: p_log_level => FND_LOG.LEVEL_ERROR,
780: p_message_token => 'GMA_MIGRATION_DB_ERROR',
781: p_table_name => 'GMI_ITEM_CATEGORIES',
782: p_context => 'ITEM CATEGORIES',
783: p_param1 => NULL,
852: l_migrate_count := 0;
853: -- dbms_output.put_line ('Started LOT STATUS migration');
854: GMA_COMMON_LOGGING.gma_migration_central_log (
855: p_run_id => p_migration_run_id,
856: p_log_level => FND_LOG.LEVEL_PROCEDURE,
857: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
858: p_table_name => 'IC_LOTS_STS',
859: p_context => 'LOT STATUS',
860: p_param1 => NULL,
906: -- No migration needed, skip it.
907: -- dbms_output.put_line ('Lot status already exists: '||l_lot_status.lot_status);
908: GMA_COMMON_LOGGING.gma_migration_central_log (
909: p_run_id => p_migration_run_id,
910: p_log_level => FND_LOG.LEVEL_ERROR,
911: p_message_token => 'GMI_MIG_STATUS_EXISTS',
912: p_table_name => 'IC_LOTS_STS',
913: p_context => 'LOT STATUS',
914: p_param1 => l_lot_status.lot_status,
1050:
1051: -- dbms_output.put_line ('Completed LOT STATUS migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
1052: GMA_COMMON_LOGGING.gma_migration_central_log (
1053: p_run_id => p_migration_run_id,
1054: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1055: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1056: p_table_name => 'IC_LOTS_STS',
1057: p_context => 'LOT STATUS',
1058: p_param1 => l_migrate_count,
1068: x_failure_count := x_failure_count + 1;
1069: -- dbms_output.put_line (substr(SQLERRM,1,255));
1070: GMA_COMMON_LOGGING.gma_migration_central_log (
1071: p_run_id => p_migration_run_id,
1072: p_log_level => FND_LOG.LEVEL_ERROR,
1073: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1074: p_table_name => 'IC_LOTS_STS',
1075: p_context => 'LOT STATUS',
1076: p_param1 => NULL,
1127: l_migrate_count := 0;
1128: -- dbms_output.put_line ('Started ACTIONS migration');
1129: GMA_COMMON_LOGGING.gma_migration_central_log (
1130: p_run_id => p_migration_run_id,
1131: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1132: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1133: p_table_name => 'GMD_ACTIONS',
1134: p_context => 'ACTIONS',
1135: p_param1 => NULL,
1150: IF (l_count > 0) THEN
1151: -- dbms_output.put_line ('Action already exists: '||g.action_code);
1152: GMA_COMMON_LOGGING.gma_migration_central_log (
1153: p_run_id => p_migration_run_id,
1154: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1155: p_message_token => 'GMI_MIG_ACTION_EXISTS',
1156: p_table_name => 'GMD_ACTIONS',
1157: p_context => 'ACTIONS',
1158: p_param1 => g.action_code,
1239:
1240: -- dbms_output.put_line ('Completed ACTIONS migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
1241: GMA_COMMON_LOGGING.gma_migration_central_log (
1242: p_run_id => p_migration_run_id,
1243: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1244: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1245: p_table_name => 'GMD_ACTIONS',
1246: p_context => 'ACTIONS',
1247: p_param1 => NULL,
1256: x_failure_count := x_failure_count + 1;
1257: -- dbms_output.put_line (substr(SQLERRM,1,255));
1258: GMA_COMMON_LOGGING.gma_migration_central_log (
1259: p_run_id => p_migration_run_id,
1260: p_log_level => FND_LOG.LEVEL_ERROR,
1261: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1262: p_table_name => 'GMD_ACTIONS',
1263: p_context => 'ACTIONS',
1264: p_param1 => NULL,
1315: l_migrate_count := 0;
1316: -- dbms_output.put_line ('Started GRADES migration');
1317: GMA_COMMON_LOGGING.gma_migration_central_log (
1318: p_run_id => p_migration_run_id,
1319: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1320: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1321: p_table_name => 'GMD_GRADES',
1322: p_context => 'GRADES',
1323: p_param1 => NULL,
1338: IF (l_count > 0) THEN
1339: -- dbms_output.put_line ('Grade already exists: '||g.qc_grade);
1340: GMA_COMMON_LOGGING.gma_migration_central_log (
1341: p_run_id => p_migration_run_id,
1342: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1343: p_message_token => 'GMI_MIG_GRADE_EXISTS',
1344: p_table_name => 'GMD_GRADES',
1345: p_context => 'GRADES',
1346: p_param1 => g.qc_grade,
1427:
1428: -- dbms_output.put_line ('Completed GRADES migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
1429: GMA_COMMON_LOGGING.gma_migration_central_log (
1430: p_run_id => p_migration_run_id,
1431: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1432: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1433: p_table_name => 'GMD_GRADES',
1434: p_context => 'GRADES',
1435: p_param1 => l_migrate_count,
1444: x_failure_count := x_failure_count + 1;
1445: -- dbms_output.put_line (substr(SQLERRM,1,255));
1446: GMA_COMMON_LOGGING.gma_migration_central_log (
1447: p_run_id => p_migration_run_id,
1448: p_log_level => FND_LOG.LEVEL_ERROR,
1449: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1450: p_table_name => 'GMD_GRADES',
1451: p_context => 'GRADES',
1452: p_param1 => NULL,
1500: l_migrate_count := 0;
1501: -- dbms_output.put_line ('Started GRADES migration');
1502: GMA_COMMON_LOGGING.gma_migration_central_log (
1503: p_run_id => p_migration_run_id,
1504: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1505: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1506: p_table_name => 'MTL_LOT_NUMBERS',
1507: p_context => 'GRADES',
1508: p_param1 => NULL,
1579:
1580: -- dbms_output.put_line ('Completed GRADES migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
1581: GMA_COMMON_LOGGING.gma_migration_central_log (
1582: p_run_id => p_migration_run_id,
1583: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1584: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1585: p_table_name => 'MTL_LOT_NUMBERS',
1586: p_context => 'GRADES',
1587: p_param1 => NULL,
1596: x_failure_count := x_failure_count + 1;
1597: -- dbms_output.put_line (substr(SQLERRM,1,255));
1598: GMA_COMMON_LOGGING.gma_migration_central_log (
1599: p_run_id => p_migration_run_id,
1600: p_log_level => FND_LOG.LEVEL_ERROR,
1601: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1602: p_table_name => 'MTL_LOT_NUMBERS',
1603: p_context => 'GRADES',
1604: p_param1 => NULL,
1689: l_migrate_count := 0;
1690: -- dbms_output.put_line ('Started LOT CONVERSION migration');
1691: GMA_COMMON_LOGGING.gma_migration_central_log (
1692: p_run_id => p_migration_run_id,
1693: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1694: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1695: p_table_name => 'IC_LOTS_CNV',
1696: p_context => 'LOT CONVERSION',
1697: p_param1 => NULL,
1717: -- Log Error
1718: -- dbms_output.put_line ('Failed to get discrete item. Item id :'||to_char(c.item_id));
1719: GMA_COMMON_LOGGING.gma_migration_central_log (
1720: p_run_id => p_migration_run_id,
1721: p_log_level => FND_LOG.LEVEL_ERROR,
1722: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
1723: p_table_name => 'IC_ITEM_CNV',
1724: p_context => 'LOT CONVERSION',
1725: p_param1 => INV_GMI_Migration.org(c.organization_id),
1774: -- No migration needed, skip it.
1775: -- dbms_output.put_line ('Lot conversion already exist. org_id, inventory_item_id, lot num, from class, to class'||to_char(c.organization_id)||', '||to_char(l_inventory_item_id)||', '||c.lot_number||', '||l_from_uom_class||', '||c.um_type);
1776: GMA_COMMON_LOGGING.gma_migration_central_log (
1777: p_run_id => p_migration_run_id,
1778: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1779: p_message_token => 'GMI_MIG_LOT_CONV_EXISTS',
1780: p_table_name => 'IC_ITEM_CNV',
1781: p_context => 'LOT CONVERSIONS',
1782: p_param1 => INV_GMI_Migration.org(c.organization_id),
1890: IF (nvl(l_migrated_ind,0) <> 1) THEN
1891: -- dbms_output.put_line ('Warehouse not mmigrated: '||adetail.whse_code);
1892: GMA_COMMON_LOGGING.gma_migration_central_log (
1893: p_run_id => p_migration_run_id,
1894: p_log_level => FND_LOG.LEVEL_ERROR,
1895: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
1896: p_table_name => 'IC_ITEM_CNV',
1897: p_context => 'LOT CONVERSION',
1898: p_param1 => adetail.whse_code,
1927: IF (l_locator_id is NULL) THEN
1928: -- dbms_output.put_line ('Location not migrated for whse, loc :'||adetail.whse_code||', '||adetail.location);
1929: GMA_COMMON_LOGGING.gma_migration_central_log (
1930: p_run_id => p_migration_run_id,
1931: p_log_level => FND_LOG.LEVEL_ERROR,
1932: p_message_token => 'GMI_MIG_LOC_NOT_MIGRATED',
1933: p_table_name => 'IC_ITEM_CNV',
1934: p_context => 'LOT CONVERSION',
1935: p_param1 => adetail.whse_code,
1979: -- Log error
1980: -- dbms_output.put_line ( 'Unable to create the locator for dynamic OPM location :' || adetail.whse_code ||', '||adetail.location );
1981: GMA_COMMON_LOGGING.gma_migration_central_log (
1982: p_run_id => p_migration_run_id,
1983: p_log_level => FND_LOG.LEVEL_ERROR,
1984: p_message_token => 'GMI_LOC_CREATION_FAILED',
1985: p_table_name => 'IC_LOCT_INV',
1986: p_context => 'INVENTORY BALANCE',
1987: p_param1 => adetail.whse_code,
2058: -- dbms_output.put_line ('Cannot find '||l_field_name||' for '||l_field_value);
2059: ROLLBACK;
2060: GMA_COMMON_LOGGING.gma_migration_central_log (
2061: p_run_id => p_migration_run_id,
2062: p_log_level => FND_LOG.LEVEL_ERROR,
2063: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
2064: p_table_name => 'IC_ITEM_CNV',
2065: p_context => 'LOT CONVERSION',
2066: p_param1 => l_field_name,
2080:
2081: -- dbms_output.put_line ('Completed LOT CONVERSION migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
2082: GMA_COMMON_LOGGING.gma_migration_central_log (
2083: p_run_id => p_migration_run_id,
2084: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2085: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2086: p_table_name => 'IC_ITEM_CNV',
2087: p_context => 'LOT CONVERSION',
2088: p_param1 => l_migrate_count,
2098: x_failure_count := x_failure_count + 1;
2099: -- dbms_output.put_line (substr(SQLERRM,1,255));
2100: GMA_COMMON_LOGGING.gma_migration_central_log (
2101: p_run_id => p_migration_run_id,
2102: p_log_level => FND_LOG.LEVEL_ERROR,
2103: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2104: p_table_name => 'IC_ITEM_CNV',
2105: p_context => 'LOT CONVERSION',
2106: p_param1 => NULL,
2340:
2341: -- dbms_output.put_line ('Started INVENTORY BALANCE migration');
2342: GMA_COMMON_LOGGING.gma_migration_central_log (
2343: p_run_id => p_migration_run_id,
2344: p_log_level => FND_LOG.LEVEL_ERROR,
2345: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2346: p_table_name => 'IC_LOCT_INV',
2347: p_context => 'INVENTORY BALANCE',
2348: p_param1 => NULL,
2378: IF (l_migrated_ind is NULL or l_organization_id is NULL) THEN
2379: -- dbms_output.put_line ('Warehouse not migrated :'||bal.whse_code);
2380: GMA_COMMON_LOGGING.gma_migration_central_log (
2381: p_run_id => p_migration_run_id,
2382: p_log_level => FND_LOG.LEVEL_ERROR,
2383: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
2384: p_table_name => 'IC_LOCT_INV',
2385: p_context => 'INVENTORY BALANCE',
2386: p_param1 => bal.whse_code,
2400: IF (l_period_id = -1) THEN
2401: -- dbms_output.put_line ('Error retrieving open period for org :' ||to_char(l_organization_id));
2402: GMA_COMMON_LOGGING.gma_migration_central_log (
2403: p_run_id => p_migration_run_id,
2404: p_log_level => FND_LOG.LEVEL_ERROR,
2405: p_message_token => 'INV_RETRIEVE_PERIOD',
2406: p_table_name => 'IC_LOCT_INV',
2407: p_context => 'INVENTORY BALANCE',
2408: p_param1 => NULL,
2416: ELSIF (l_period_id = 0) THEN
2417: -- dbms_output.put_line ('No open period for org :' ||to_char(l_organization_id));
2418: GMA_COMMON_LOGGING.gma_migration_central_log (
2419: p_run_id => p_migration_run_id,
2420: p_log_level => FND_LOG.LEVEL_ERROR,
2421: p_message_token => 'GMI_MIG_NO_ODM_OPEN_PERIOD',
2422: p_table_name => 'IC_LOCT_INV',
2423: p_context => 'INVENTORY BALANCE',
2424: p_param1 => INV_GMI_Migration.org(l_organization_id),
2451: -- Open the period
2452: -- dbms_output.put_line ('Opening period year/num/name' || fp.period_year ||'/'||fp.period_number||'/'||fp.period_name);
2453: GMA_COMMON_LOGGING.gma_migration_central_log (
2454: p_run_id => p_migration_run_id,
2455: p_log_level => FND_LOG.LEVEL_ERROR,
2456: p_message_token => 'GMI_MIG_OPENING_ODM_PERIOD',
2457: p_table_name => 'IC_LOCT_INV',
2458: p_context => 'INVENTORY BALANCE',
2459: p_param1 => INV_GMI_Migration.org(l_organization_id),
2485: IF (NOT l_prior_period_open) THEN
2486: -- dbms_output.put_line ('Prior period is not open');
2487: GMA_COMMON_LOGGING.gma_migration_central_log (
2488: p_run_id => p_migration_run_id,
2489: p_log_level => FND_LOG.LEVEL_ERROR,
2490: p_message_token => 'INV_PREV_PD_NOT_OPEN_10G',
2491: p_table_name => 'IC_LOCT_INV',
2492: p_context => 'INVENTORY BALANCE',
2493: p_param1 => NULL,
2501: ELSIF (l_new_acct_period_id = 0) THEN
2502: -- dbms_output.put_line ('Cannot get next period');
2503: GMA_COMMON_LOGGING.gma_migration_central_log (
2504: p_run_id => p_migration_run_id,
2505: p_log_level => FND_LOG.LEVEL_ERROR,
2506: p_message_token => 'INV_CANNOT_GET_NEXT_PERIOD',
2507: p_table_name => 'IC_LOCT_INV',
2508: p_context => 'INVENTORY BALANCE',
2509: p_param1 => NULL,
2517: ELSIF (l_duplicate_open_period) THEN
2518: -- dbms_output.put_line ('Period opened by another user');
2519: GMA_COMMON_LOGGING.gma_migration_central_log (
2520: p_run_id => p_migration_run_id,
2521: p_log_level => FND_LOG.LEVEL_ERROR,
2522: p_message_token => 'INV_DUPLICATE_OPEN_PERIOD',
2523: p_table_name => 'IC_LOCT_INV',
2524: p_context => 'INVENTORY BALANCE',
2525: p_param1 => NULL,
2533: ELSIF (NOT l_commit_complete) THEN
2534: -- dbms_output.put_line ('No Change made for period opening');
2535: GMA_COMMON_LOGGING.gma_migration_central_log (
2536: p_run_id => p_migration_run_id,
2537: p_log_level => FND_LOG.LEVEL_ERROR,
2538: p_message_token => 'INV_NO_CHANGES',
2539: p_table_name => 'IC_LOCT_INV',
2540: p_context => 'INVENTORY BALANCE',
2541: p_param1 => NULL,
2570: -- Log Error
2571: -- dbms_output.put_line ('Failed to migrate item,org = '||to_char(bal.item_id)||', '||to_char(l_organization_id));
2572: GMA_COMMON_LOGGING.gma_migration_central_log (
2573: p_run_id => p_migration_run_id,
2574: p_log_level => FND_LOG.LEVEL_ERROR,
2575: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
2576: p_table_name => 'IC_LOCT_INV',
2577: p_context => 'INVENTORY BALANCE',
2578: p_param1 => INV_GMI_Migration.org(l_organization_id),
2599: -- Log Error
2600: -- dbms_output.put_line ('Cannot migrate balances for non-inventory item '|| l_item_no);
2601: GMA_COMMON_LOGGING.gma_migration_central_log (
2602: p_run_id => p_migration_run_id,
2603: p_log_level => FND_LOG.LEVEL_ERROR,
2604: p_message_token => 'GMI_MIG_NONINV_ITEM',
2605: p_table_name => 'IC_LOCT_INV',
2606: p_context => 'INVENTORY BALANCE',
2607: p_param1 => bal.item_no,
2635: -- Log Error
2636: -- dbms_output.put_line ('Failed to migrate lot = '||to_char(bal.lot_id)||', '||bal.whse_code||', '||bal.location);
2637: GMA_COMMON_LOGGING.gma_migration_central_log (
2638: p_run_id => p_migration_run_id,
2639: p_log_level => FND_LOG.LEVEL_ERROR,
2640: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
2641: p_table_name => 'IC_LOCT_INV',
2642: p_context => 'INVENTORY BALANCE',
2643: p_param1 => INV_GMI_Migration.item(bal.item_id),
2681: -- Log error
2682: -- dbms_output.put_line ( 'Warehouse location not migrated :' || bal.whse_code ||', '||bal.location );
2683: GMA_COMMON_LOGGING.gma_migration_central_log (
2684: p_run_id => p_migration_run_id,
2685: p_log_level => FND_LOG.LEVEL_ERROR,
2686: p_message_token => 'GMI_MIG_LOC_NOT_MIGRATED',
2687: p_table_name => 'IC_LOCT_INV',
2688: p_context => 'INVENTORY BALANCE',
2689: p_param1 => bal.whse_code,
2742: IF (l_failure_count > 0) THEN
2743: -- dbms_output.put_line ( 'Warehouse location not migrated :' || bal.whse_code ||', '||bal.location );
2744: GMA_COMMON_LOGGING.gma_migration_central_log (
2745: p_run_id => p_migration_run_id,
2746: p_log_level => FND_LOG.LEVEL_ERROR,
2747: p_message_token => 'GMI_LOC_CREATION_FAILED',
2748: p_table_name => 'IC_LOCT_INV',
2749: p_context => 'INVENTORY BALANCE',
2750: p_param1 => bal.whse_code,
2840: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2841: -- dbms_output.put_line ('Balance migration failed for item, whse, lot, location'||l_item_no||', '||bal.whse_code||', '||l_lot_number||', '||bal.location);
2842: GMA_COMMON_LOGGING.gma_migration_central_log (
2843: p_run_id => p_migration_run_id,
2844: p_log_level => FND_LOG.LEVEL_ERROR,
2845: p_message_token => 'GMI_MIG_BALANCE_MIG_FAILED',
2846: p_table_name => 'IC_LOCT_INV',
2847: p_context => 'INVENTORY BALANCE',
2848: p_param1 => INV_GMI_Migration.item(bal.item_id),
2856: FOR i in 1..l_msg_count LOOP
2857: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
2858: GMA_COMMON_LOGGING.gma_migration_central_log (
2859: p_run_id => p_migration_run_id,
2860: p_log_level => FND_LOG.LEVEL_ERROR,
2861: p_message_token => 'GMI_UNEXPECTED_ERROR',
2862: p_table_name => 'IC_LOCT_INV',
2863: p_context => 'INVENTORY BALANCE',
2864: p_token1 => 'ERROR',
2896: WHEN NO_DATA_FOUND THEN
2897: -- dbms_output.put_line ('Cannot find '||l_field_name||' for '||l_field_value);
2898: GMA_COMMON_LOGGING.gma_migration_central_log (
2899: p_run_id => p_migration_run_id,
2900: p_log_level => FND_LOG.LEVEL_ERROR,
2901: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
2902: p_table_name => 'IC_LOCT_INV',
2903: p_context => 'INVENTORY BALANCE',
2904: p_param1 => l_field_name,
2927: -- dbms_output.put_line ('Completed INVENTORY BALANCE migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
2928: -- dbms_output.put_line ('Migrated ' || to_char(l_migrate_count) ||' rows');
2929: GMA_COMMON_LOGGING.gma_migration_central_log (
2930: p_run_id => p_migration_run_id,
2931: p_log_level => FND_LOG.LEVEL_ERROR,
2932: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2933: p_table_name => 'IC_LOCT_INV',
2934: p_context => 'INVENTORY BALANCE',
2935: p_param1 => l_migrate_count,
2944: x_failure_count := x_failure_count + 1;
2945: -- dbms_output.put_line (substr(SQLERRM,1,255));
2946: GMA_COMMON_LOGGING.gma_migration_central_log (
2947: p_run_id => p_migration_run_id,
2948: p_log_level => FND_LOG.LEVEL_ERROR,
2949: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2950: p_table_name => 'IC_LOCT_INV',
2951: p_context => 'INVENTORY BALANCE',
2952: p_param1 => NULL,