[Home] [Help]
271: l_migrate_count := 0;
272: -- dbms_output.put_line ('Started INVENTORY TYPES migration');
273: GMA_COMMON_LOGGING.gma_migration_central_log (
274: p_run_id => p_migration_run_id,
275: p_log_level => FND_LOG.LEVEL_PROCEDURE,
276: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
277: p_table_name => 'IC_INVN_TYP',
278: p_context => 'INVENTORY TYPES',
279: p_param1 => NULL,
300: -- No migration needed, skip it.
301: -- dbms_output.put_line ('Inventory type '||l_inv_type.inv_type||' already exist in discrete.');
302: GMA_COMMON_LOGGING.gma_migration_central_log (
303: p_run_id => p_migration_run_id,
304: p_log_level => FND_LOG.LEVEL_PROCEDURE,
305: p_message_token => 'GMI_MIG_TYPE_EXISTS',
306: p_table_name => 'IC_INVN_TYP',
307: p_context => 'INVENTORY TYPES',
308: p_param1 => l_inv_type.inv_type,
374:
375: -- dbms_output.put_line ('Completed INVENTORY TYPES migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
376: GMA_COMMON_LOGGING.gma_migration_central_log (
377: p_run_id => p_migration_run_id,
378: p_log_level => FND_LOG.LEVEL_PROCEDURE,
379: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
380: p_table_name => 'IC_INVN_TYP',
381: p_context => 'INVENTORY TYPES',
382: p_param1 => l_migrate_count,
391: x_failure_count := x_failure_count + 1;
392: -- dbms_output.put_line (substr(SQLERRM,1,255));
393: GMA_COMMON_LOGGING.gma_migration_central_log (
394: p_run_id => p_migration_run_id,
395: p_log_level => FND_LOG.LEVEL_ERROR,
396: p_message_token => 'GMA_MIGRATION_DB_ERROR',
397: p_table_name => 'IC_INVN_TYP',
398: p_context => 'INVENTORY TYPES',
399: p_param1 => NULL,
450: l_migrate_count := 0;
451: -- dbms_output.put_line ('Started CATEGORY SETS migration');
452: GMA_COMMON_LOGGING.gma_migration_central_log (
453: p_run_id => p_migration_run_id,
454: p_log_level => FND_LOG.LEVEL_PROCEDURE,
455: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
456: p_table_name => 'GMI_CATEGORY_SETS',
457: p_context => 'CATEGORY SETS',
458: p_param1 => NULL,
478: IF (l_category_set_id <> -1) THEN
479: -- dbms_output.put_line ('Default category set already assigned for '||c.user_opm_class);
480: GMA_COMMON_LOGGING.gma_migration_central_log (
481: p_run_id => p_migration_run_id,
482: p_log_level => FND_LOG.LEVEL_PROCEDURE,
483: p_message_token => 'GMI_MIG_CAT_SET_ASSIGNED',
484: p_table_name => 'GMI_CATEGORY_SETS',
485: p_context => 'CATEGORY SETS',
486: p_param1 => c.user_opm_class,
515: WHEN NO_DATA_FOUND THEN
516: -- dbms_output.put_line ('Functional area does not exist in discrete : '||c.user_opm_class);
517: GMA_COMMON_LOGGING.gma_migration_central_log (
518: p_run_id => p_migration_run_id,
519: p_log_level => FND_LOG.LEVEL_PROCEDURE,
520: p_message_token => 'GMI_MIG_NO_FUNC_AREA',
521: p_table_name => 'GMI_CATEGORY_SETS',
522: p_context => 'CATEGORY SETS',
523: p_param1 => c.user_opm_class,
532:
533: -- dbms_output.put_line ('Completed CATEGORY SETS migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
534: GMA_COMMON_LOGGING.gma_migration_central_log (
535: p_run_id => p_migration_run_id,
536: p_log_level => FND_LOG.LEVEL_PROCEDURE,
537: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
538: p_table_name => 'GMI_CATEGORY_SETS',
539: p_context => 'CATEGORY SETS',
540: p_param1 => NULL,
549: x_failure_count := x_failure_count + 1;
550: -- dbms_output.put_line (substr(SQLERRM,1,255));
551: GMA_COMMON_LOGGING.gma_migration_central_log (
552: p_run_id => p_migration_run_id,
553: p_log_level => FND_LOG.LEVEL_ERROR,
554: p_message_token => 'GMA_MIGRATION_DB_ERROR',
555: p_table_name => 'GMI_CATEGORY_SETS',
556: p_context => 'CATEGORY SETS',
557: p_param1 => NULL,
616: l_migrate_count := 0;
617: -- dbms_output.put_line ('Started ITEM CATEGORIES migration');
618: GMA_COMMON_LOGGING.gma_migration_central_log (
619: p_run_id => p_migration_run_id,
620: p_log_level => FND_LOG.LEVEL_PROCEDURE,
621: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
622: p_table_name => 'GMI_ITEM_CATEGORIES',
623: p_context => 'ITEM CATEGORIES',
624: p_param1 => NULL,
681: -- Log warning message
682: -- 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));
683: GMA_COMMON_LOGGING.gma_migration_central_log (
684: p_run_id => p_migration_run_id,
685: p_log_level => FND_LOG.LEVEL_PROCEDURE,
686: p_message_token => 'GMI_MIG_ITEM_CAT_EXISTS',
687: p_table_name => 'GMI_ITEM_CATEGORIES',
688: p_context => 'ITEM CATEGORIES',
689: p_param1 => INV_GMI_Migration.org(r.organization_id),
709:
710: -- dbms_output.put_line ('Completed ITEM CATEGORIES migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
711: GMA_COMMON_LOGGING.gma_migration_central_log (
712: p_run_id => p_migration_run_id,
713: p_log_level => FND_LOG.LEVEL_PROCEDURE,
714: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
715: p_table_name => 'GMI_ITEM_CATEGORIES',
716: p_context => 'ITEM CATEGORIES',
717: p_param1 => l_migrate_count,
726: x_failure_count := x_failure_count + 1;
727: -- dbms_output.put_line (substr(SQLERRM,1,255));
728: GMA_COMMON_LOGGING.gma_migration_central_log (
729: p_run_id => p_migration_run_id,
730: p_log_level => FND_LOG.LEVEL_ERROR,
731: p_message_token => 'GMA_MIGRATION_DB_ERROR',
732: p_table_name => 'GMI_ITEM_CATEGORIES',
733: p_context => 'ITEM CATEGORIES',
734: p_param1 => NULL,
794: l_migrate_count := 0;
795: -- dbms_output.put_line ('Started LOT STATUS migration');
796: GMA_COMMON_LOGGING.gma_migration_central_log (
797: p_run_id => p_migration_run_id,
798: p_log_level => FND_LOG.LEVEL_PROCEDURE,
799: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
800: p_table_name => 'IC_LOTS_STS',
801: p_context => 'LOT STATUS',
802: p_param1 => NULL,
820: -- No migration needed, skip it.
821: -- dbms_output.put_line ('Lot status already exists: '||l_lot_status.lot_status);
822: GMA_COMMON_LOGGING.gma_migration_central_log (
823: p_run_id => p_migration_run_id,
824: p_log_level => FND_LOG.LEVEL_ERROR,
825: p_message_token => 'GMI_MIG_STATUS_EXISTS',
826: p_table_name => 'IC_LOTS_STS',
827: p_context => 'LOT STATUS',
828: p_param1 => l_lot_status.lot_status,
958:
959: -- dbms_output.put_line ('Completed LOT STATUS migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
960: GMA_COMMON_LOGGING.gma_migration_central_log (
961: p_run_id => p_migration_run_id,
962: p_log_level => FND_LOG.LEVEL_PROCEDURE,
963: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
964: p_table_name => 'IC_LOTS_STS',
965: p_context => 'LOT STATUS',
966: p_param1 => l_migrate_count,
976: x_failure_count := x_failure_count + 1;
977: -- dbms_output.put_line (substr(SQLERRM,1,255));
978: GMA_COMMON_LOGGING.gma_migration_central_log (
979: p_run_id => p_migration_run_id,
980: p_log_level => FND_LOG.LEVEL_ERROR,
981: p_message_token => 'GMA_MIGRATION_DB_ERROR',
982: p_table_name => 'IC_LOTS_STS',
983: p_context => 'LOT STATUS',
984: p_param1 => NULL,
1035: l_migrate_count := 0;
1036: -- dbms_output.put_line ('Started ACTIONS migration');
1037: GMA_COMMON_LOGGING.gma_migration_central_log (
1038: p_run_id => p_migration_run_id,
1039: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1040: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1041: p_table_name => 'GMD_ACTIONS',
1042: p_context => 'ACTIONS',
1043: p_param1 => NULL,
1058: IF (l_count > 0) THEN
1059: -- dbms_output.put_line ('Action already exists: '||g.action_code);
1060: GMA_COMMON_LOGGING.gma_migration_central_log (
1061: p_run_id => p_migration_run_id,
1062: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1063: p_message_token => 'GMI_MIG_ACTION_EXISTS',
1064: p_table_name => 'GMD_ACTIONS',
1065: p_context => 'ACTIONS',
1066: p_param1 => g.action_code,
1147:
1148: -- dbms_output.put_line ('Completed ACTIONS migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
1149: GMA_COMMON_LOGGING.gma_migration_central_log (
1150: p_run_id => p_migration_run_id,
1151: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1152: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1153: p_table_name => 'GMD_ACTIONS',
1154: p_context => 'ACTIONS',
1155: p_param1 => NULL,
1164: x_failure_count := x_failure_count + 1;
1165: -- dbms_output.put_line (substr(SQLERRM,1,255));
1166: GMA_COMMON_LOGGING.gma_migration_central_log (
1167: p_run_id => p_migration_run_id,
1168: p_log_level => FND_LOG.LEVEL_ERROR,
1169: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1170: p_table_name => 'GMD_ACTIONS',
1171: p_context => 'ACTIONS',
1172: p_param1 => NULL,
1223: l_migrate_count := 0;
1224: -- dbms_output.put_line ('Started GRADES migration');
1225: GMA_COMMON_LOGGING.gma_migration_central_log (
1226: p_run_id => p_migration_run_id,
1227: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1228: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1229: p_table_name => 'GMD_GRADES',
1230: p_context => 'GRADES',
1231: p_param1 => NULL,
1246: IF (l_count > 0) THEN
1247: -- dbms_output.put_line ('Grade already exists: '||g.qc_grade);
1248: GMA_COMMON_LOGGING.gma_migration_central_log (
1249: p_run_id => p_migration_run_id,
1250: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1251: p_message_token => 'GMI_MIG_GRADE_EXISTS',
1252: p_table_name => 'GMD_GRADES',
1253: p_context => 'GRADES',
1254: p_param1 => g.qc_grade,
1335:
1336: -- dbms_output.put_line ('Completed GRADES migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
1337: GMA_COMMON_LOGGING.gma_migration_central_log (
1338: p_run_id => p_migration_run_id,
1339: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1340: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1341: p_table_name => 'GMD_GRADES',
1342: p_context => 'GRADES',
1343: p_param1 => l_migrate_count,
1352: x_failure_count := x_failure_count + 1;
1353: -- dbms_output.put_line (substr(SQLERRM,1,255));
1354: GMA_COMMON_LOGGING.gma_migration_central_log (
1355: p_run_id => p_migration_run_id,
1356: p_log_level => FND_LOG.LEVEL_ERROR,
1357: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1358: p_table_name => 'GMD_GRADES',
1359: p_context => 'GRADES',
1360: p_param1 => NULL,
1408: l_migrate_count := 0;
1409: -- dbms_output.put_line ('Started GRADES migration');
1410: GMA_COMMON_LOGGING.gma_migration_central_log (
1411: p_run_id => p_migration_run_id,
1412: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1413: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1414: p_table_name => 'MTL_LOT_NUMBERS',
1415: p_context => 'GRADES',
1416: p_param1 => NULL,
1487:
1488: -- dbms_output.put_line ('Completed GRADES migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
1489: GMA_COMMON_LOGGING.gma_migration_central_log (
1490: p_run_id => p_migration_run_id,
1491: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1492: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1493: p_table_name => 'MTL_LOT_NUMBERS',
1494: p_context => 'GRADES',
1495: p_param1 => NULL,
1504: x_failure_count := x_failure_count + 1;
1505: -- dbms_output.put_line (substr(SQLERRM,1,255));
1506: GMA_COMMON_LOGGING.gma_migration_central_log (
1507: p_run_id => p_migration_run_id,
1508: p_log_level => FND_LOG.LEVEL_ERROR,
1509: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1510: p_table_name => 'MTL_LOT_NUMBERS',
1511: p_context => 'GRADES',
1512: p_param1 => NULL,
1597: l_migrate_count := 0;
1598: -- dbms_output.put_line ('Started LOT CONVERSION migration');
1599: GMA_COMMON_LOGGING.gma_migration_central_log (
1600: p_run_id => p_migration_run_id,
1601: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1602: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1603: p_table_name => 'IC_LOTS_CNV',
1604: p_context => 'LOT CONVERSION',
1605: p_param1 => NULL,
1625: -- Log Error
1626: -- dbms_output.put_line ('Failed to get discrete item. Item id :'||to_char(c.item_id));
1627: GMA_COMMON_LOGGING.gma_migration_central_log (
1628: p_run_id => p_migration_run_id,
1629: p_log_level => FND_LOG.LEVEL_ERROR,
1630: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
1631: p_table_name => 'IC_ITEM_CNV',
1632: p_context => 'LOT CONVERSION',
1633: p_param1 => INV_GMI_Migration.org(c.organization_id),
1682: -- No migration needed, skip it.
1683: -- 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);
1684: GMA_COMMON_LOGGING.gma_migration_central_log (
1685: p_run_id => p_migration_run_id,
1686: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1687: p_message_token => 'GMI_MIG_LOT_CONV_EXISTS',
1688: p_table_name => 'IC_ITEM_CNV',
1689: p_context => 'LOT CONVERSIONS',
1690: p_param1 => INV_GMI_Migration.org(c.organization_id),
1798: IF (nvl(l_migrated_ind,0) <> 1) THEN
1799: -- dbms_output.put_line ('Warehouse not mmigrated: '||adetail.whse_code);
1800: GMA_COMMON_LOGGING.gma_migration_central_log (
1801: p_run_id => p_migration_run_id,
1802: p_log_level => FND_LOG.LEVEL_ERROR,
1803: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
1804: p_table_name => 'IC_ITEM_CNV',
1805: p_context => 'LOT CONVERSION',
1806: p_param1 => adetail.whse_code,
1835: IF (l_locator_id is NULL) THEN
1836: -- dbms_output.put_line ('Location not migrated for whse, loc :'||adetail.whse_code||', '||adetail.location);
1837: GMA_COMMON_LOGGING.gma_migration_central_log (
1838: p_run_id => p_migration_run_id,
1839: p_log_level => FND_LOG.LEVEL_ERROR,
1840: p_message_token => 'GMI_MIG_LOC_NOT_MIGRATED',
1841: p_table_name => 'IC_ITEM_CNV',
1842: p_context => 'LOT CONVERSION',
1843: p_param1 => adetail.whse_code,
1887: -- Log error
1888: -- dbms_output.put_line ( 'Unable to create the locator for dynamic OPM location :' || adetail.whse_code ||', '||adetail.location );
1889: GMA_COMMON_LOGGING.gma_migration_central_log (
1890: p_run_id => p_migration_run_id,
1891: p_log_level => FND_LOG.LEVEL_ERROR,
1892: p_message_token => 'GMI_LOC_CREATION_FAILED',
1893: p_table_name => 'IC_LOCT_INV',
1894: p_context => 'INVENTORY BALANCE',
1895: p_param1 => adetail.whse_code,
1966: -- dbms_output.put_line ('Cannot find '||l_field_name||' for '||l_field_value);
1967: ROLLBACK;
1968: GMA_COMMON_LOGGING.gma_migration_central_log (
1969: p_run_id => p_migration_run_id,
1970: p_log_level => FND_LOG.LEVEL_ERROR,
1971: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
1972: p_table_name => 'IC_ITEM_CNV',
1973: p_context => 'LOT CONVERSION',
1974: p_param1 => l_field_name,
1988:
1989: -- dbms_output.put_line ('Completed LOT CONVERSION migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
1990: GMA_COMMON_LOGGING.gma_migration_central_log (
1991: p_run_id => p_migration_run_id,
1992: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1993: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1994: p_table_name => 'IC_ITEM_CNV',
1995: p_context => 'LOT CONVERSION',
1996: p_param1 => l_migrate_count,
2006: x_failure_count := x_failure_count + 1;
2007: -- dbms_output.put_line (substr(SQLERRM,1,255));
2008: GMA_COMMON_LOGGING.gma_migration_central_log (
2009: p_run_id => p_migration_run_id,
2010: p_log_level => FND_LOG.LEVEL_ERROR,
2011: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2012: p_table_name => 'IC_ITEM_CNV',
2013: p_context => 'LOT CONVERSION',
2014: p_param1 => NULL,
2226:
2227: -- dbms_output.put_line ('Started INVENTORY BALANCE migration');
2228: GMA_COMMON_LOGGING.gma_migration_central_log (
2229: p_run_id => p_migration_run_id,
2230: p_log_level => FND_LOG.LEVEL_ERROR,
2231: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2232: p_table_name => 'IC_LOCT_INV',
2233: p_context => 'INVENTORY BALANCE',
2234: p_param1 => NULL,
2264: IF (l_migrated_ind is NULL or l_organization_id is NULL) THEN
2265: -- dbms_output.put_line ('Warehouse not migrated :'||bal.whse_code);
2266: GMA_COMMON_LOGGING.gma_migration_central_log (
2267: p_run_id => p_migration_run_id,
2268: p_log_level => FND_LOG.LEVEL_ERROR,
2269: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
2270: p_table_name => 'IC_LOCT_INV',
2271: p_context => 'INVENTORY BALANCE',
2272: p_param1 => bal.whse_code,
2286: IF (l_period_id = -1) THEN
2287: -- dbms_output.put_line ('Error retrieving open period for org :' ||to_char(l_organization_id));
2288: GMA_COMMON_LOGGING.gma_migration_central_log (
2289: p_run_id => p_migration_run_id,
2290: p_log_level => FND_LOG.LEVEL_ERROR,
2291: p_message_token => 'INV_RETRIEVE_PERIOD',
2292: p_table_name => 'IC_LOCT_INV',
2293: p_context => 'INVENTORY BALANCE',
2294: p_param1 => NULL,
2302: ELSIF (l_period_id = 0) THEN
2303: -- dbms_output.put_line ('No open period for org :' ||to_char(l_organization_id));
2304: GMA_COMMON_LOGGING.gma_migration_central_log (
2305: p_run_id => p_migration_run_id,
2306: p_log_level => FND_LOG.LEVEL_ERROR,
2307: p_message_token => 'GMI_MIG_NO_ODM_OPEN_PERIOD',
2308: p_table_name => 'IC_LOCT_INV',
2309: p_context => 'INVENTORY BALANCE',
2310: p_param1 => INV_GMI_Migration.org(l_organization_id),
2337: -- Open the period
2338: -- dbms_output.put_line ('Opening period year/num/name' || fp.period_year ||'/'||fp.period_number||'/'||fp.period_name);
2339: GMA_COMMON_LOGGING.gma_migration_central_log (
2340: p_run_id => p_migration_run_id,
2341: p_log_level => FND_LOG.LEVEL_ERROR,
2342: p_message_token => 'GMI_MIG_OPENING_ODM_PERIOD',
2343: p_table_name => 'IC_LOCT_INV',
2344: p_context => 'INVENTORY BALANCE',
2345: p_param1 => INV_GMI_Migration.org(l_organization_id),
2371: IF (NOT l_prior_period_open) THEN
2372: -- dbms_output.put_line ('Prior period is not open');
2373: GMA_COMMON_LOGGING.gma_migration_central_log (
2374: p_run_id => p_migration_run_id,
2375: p_log_level => FND_LOG.LEVEL_ERROR,
2376: p_message_token => 'INV_PREV_PD_NOT_OPEN_10G',
2377: p_table_name => 'IC_LOCT_INV',
2378: p_context => 'INVENTORY BALANCE',
2379: p_param1 => NULL,
2387: ELSIF (l_new_acct_period_id = 0) THEN
2388: -- dbms_output.put_line ('Cannot get next period');
2389: GMA_COMMON_LOGGING.gma_migration_central_log (
2390: p_run_id => p_migration_run_id,
2391: p_log_level => FND_LOG.LEVEL_ERROR,
2392: p_message_token => 'INV_CANNOT_GET_NEXT_PERIOD',
2393: p_table_name => 'IC_LOCT_INV',
2394: p_context => 'INVENTORY BALANCE',
2395: p_param1 => NULL,
2403: ELSIF (l_duplicate_open_period) THEN
2404: -- dbms_output.put_line ('Period opened by another user');
2405: GMA_COMMON_LOGGING.gma_migration_central_log (
2406: p_run_id => p_migration_run_id,
2407: p_log_level => FND_LOG.LEVEL_ERROR,
2408: p_message_token => 'INV_DUPLICATE_OPEN_PERIOD',
2409: p_table_name => 'IC_LOCT_INV',
2410: p_context => 'INVENTORY BALANCE',
2411: p_param1 => NULL,
2419: ELSIF (NOT l_commit_complete) THEN
2420: -- dbms_output.put_line ('No Change made for period opening');
2421: GMA_COMMON_LOGGING.gma_migration_central_log (
2422: p_run_id => p_migration_run_id,
2423: p_log_level => FND_LOG.LEVEL_ERROR,
2424: p_message_token => 'INV_NO_CHANGES',
2425: p_table_name => 'IC_LOCT_INV',
2426: p_context => 'INVENTORY BALANCE',
2427: p_param1 => NULL,
2456: -- Log Error
2457: -- dbms_output.put_line ('Failed to migrate item,org = '||to_char(bal.item_id)||', '||to_char(l_organization_id));
2458: GMA_COMMON_LOGGING.gma_migration_central_log (
2459: p_run_id => p_migration_run_id,
2460: p_log_level => FND_LOG.LEVEL_ERROR,
2461: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
2462: p_table_name => 'IC_LOCT_INV',
2463: p_context => 'INVENTORY BALANCE',
2464: p_param1 => INV_GMI_Migration.org(l_organization_id),
2484: -- Log Error
2485: -- dbms_output.put_line ('Cannot migrate balances for non-inventory item '|| l_item_no);
2486: GMA_COMMON_LOGGING.gma_migration_central_log (
2487: p_run_id => p_migration_run_id,
2488: p_log_level => FND_LOG.LEVEL_ERROR,
2489: p_message_token => 'GMI_MIG_NONINV_ITEM',
2490: p_table_name => 'IC_LOCT_INV',
2491: p_context => 'INVENTORY BALANCE',
2492: p_param1 => l_item_no,
2520: -- Log Error
2521: -- dbms_output.put_line ('Failed to migrate lot = '||to_char(bal.lot_id)||', '||bal.whse_code||', '||bal.location);
2522: GMA_COMMON_LOGGING.gma_migration_central_log (
2523: p_run_id => p_migration_run_id,
2524: p_log_level => FND_LOG.LEVEL_ERROR,
2525: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
2526: p_table_name => 'IC_LOCT_INV',
2527: p_context => 'INVENTORY BALANCE',
2528: p_param1 => INV_GMI_Migration.item(bal.item_id),
2561: -- Log error
2562: -- dbms_output.put_line ( 'Warehouse location not migrated :' || bal.whse_code ||', '||bal.location );
2563: GMA_COMMON_LOGGING.gma_migration_central_log (
2564: p_run_id => p_migration_run_id,
2565: p_log_level => FND_LOG.LEVEL_ERROR,
2566: p_message_token => 'GMI_MIG_LOC_NOT_MIGRATED',
2567: p_table_name => 'IC_LOCT_INV',
2568: p_context => 'INVENTORY BALANCE',
2569: p_param1 => bal.whse_code,
2622: IF (l_failure_count > 0) THEN
2623: -- dbms_output.put_line ( 'Warehouse location not migrated :' || bal.whse_code ||', '||bal.location );
2624: GMA_COMMON_LOGGING.gma_migration_central_log (
2625: p_run_id => p_migration_run_id,
2626: p_log_level => FND_LOG.LEVEL_ERROR,
2627: p_message_token => 'GMI_LOC_CREATION_FAILED',
2628: p_table_name => 'IC_LOCT_INV',
2629: p_context => 'INVENTORY BALANCE',
2630: p_param1 => bal.whse_code,
2720: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2721: -- dbms_output.put_line ('Balance migration failed for item, whse, lot, location'||l_item_no||', '||bal.whse_code||', '||l_lot_number||', '||bal.location);
2722: GMA_COMMON_LOGGING.gma_migration_central_log (
2723: p_run_id => p_migration_run_id,
2724: p_log_level => FND_LOG.LEVEL_ERROR,
2725: p_message_token => 'GMI_MIG_BALANCE_MIG_FAILED',
2726: p_table_name => 'IC_LOCT_INV',
2727: p_context => 'INVENTORY BALANCE',
2728: p_param1 => INV_GMI_Migration.item(bal.item_id),
2736: FOR i in 1..l_msg_count LOOP
2737: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
2738: GMA_COMMON_LOGGING.gma_migration_central_log (
2739: p_run_id => p_migration_run_id,
2740: p_log_level => FND_LOG.LEVEL_ERROR,
2741: p_message_token => 'GMI_UNEXPECTED_ERROR',
2742: p_table_name => 'IC_LOCT_INV',
2743: p_context => 'INVENTORY BALANCE',
2744: p_token1 => 'ERROR',
2776: WHEN NO_DATA_FOUND THEN
2777: -- dbms_output.put_line ('Cannot find '||l_field_name||' for '||l_field_value);
2778: GMA_COMMON_LOGGING.gma_migration_central_log (
2779: p_run_id => p_migration_run_id,
2780: p_log_level => FND_LOG.LEVEL_ERROR,
2781: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
2782: p_table_name => 'IC_LOCT_INV',
2783: p_context => 'INVENTORY BALANCE',
2784: p_param1 => l_field_name,
2807: -- dbms_output.put_line ('Completed INVENTORY BALANCE migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
2808: -- dbms_output.put_line ('Migrated ' || to_char(l_migrate_count) ||' rows');
2809: GMA_COMMON_LOGGING.gma_migration_central_log (
2810: p_run_id => p_migration_run_id,
2811: p_log_level => FND_LOG.LEVEL_ERROR,
2812: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2813: p_table_name => 'IC_LOCT_INV',
2814: p_context => 'INVENTORY BALANCE',
2815: p_param1 => l_migrate_count,
2824: x_failure_count := x_failure_count + 1;
2825: -- dbms_output.put_line (substr(SQLERRM,1,255));
2826: GMA_COMMON_LOGGING.gma_migration_central_log (
2827: p_run_id => p_migration_run_id,
2828: p_log_level => FND_LOG.LEVEL_ERROR,
2829: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2830: p_table_name => 'IC_LOCT_INV',
2831: p_context => 'INVENTORY BALANCE',
2832: p_param1 => NULL,