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.INV_GMI_MIGRATION dependencies on GMA_COMMON_LOGGING

Line 312: GMA_COMMON_LOGGING.gma_migration_central_log (

308: BEGIN
309: x_failure_count := 0;
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',

Line 341: GMA_COMMON_LOGGING.gma_migration_central_log (

337:
338: IF (l_count > 0) THEN
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',

Line 415: GMA_COMMON_LOGGING.gma_migration_central_log (

411: END;
412: END LOOP;
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',

Line 432: GMA_COMMON_LOGGING.gma_migration_central_log (

428: EXCEPTION
429: WHEN OTHERS THEN
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',

Line 491: GMA_COMMON_LOGGING.gma_migration_central_log (

487: BEGIN
488: x_failure_count := 0;
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',

Line 519: GMA_COMMON_LOGGING.gma_migration_central_log (

515: l.lookup_code = s.functional_area_id;
516:
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',

Line 556: GMA_COMMON_LOGGING.gma_migration_central_log (

552: WHEN e_already_exists THEN
553: x_failure_count := x_failure_count + 1;
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',

Line 573: GMA_COMMON_LOGGING.gma_migration_central_log (

569: END;
570: END LOOP;
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',

Line 590: GMA_COMMON_LOGGING.gma_migration_central_log (

586: EXCEPTION
587: WHEN OTHERS THEN
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',

Line 657: GMA_COMMON_LOGGING.gma_migration_central_log (

653: BEGIN
654: x_failure_count := 0;
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',

Line 722: GMA_COMMON_LOGGING.gma_migration_central_log (

718: /* Select rows with error */
719: FOR r in c_item_cat_error LOOP
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',

Line 760: GMA_COMMON_LOGGING.gma_migration_central_log (

756: WHERE
757: rowid BETWEEN p_start_rowid AND p_end_rowid); */
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',

Line 777: GMA_COMMON_LOGGING.gma_migration_central_log (

773: EXCEPTION
774: WHEN OTHERS THEN
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',

Line 854: GMA_COMMON_LOGGING.gma_migration_central_log (

850: BEGIN
851: x_failure_count := 0;
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',

Line 908: GMA_COMMON_LOGGING.gma_migration_central_log (

904:
905:
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',

Line 1052: GMA_COMMON_LOGGING.gma_migration_central_log (

1048: END;
1049: END LOOP;
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',

Line 1070: GMA_COMMON_LOGGING.gma_migration_central_log (

1066: EXCEPTION
1067: WHEN OTHERS THEN
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',

Line 1129: GMA_COMMON_LOGGING.gma_migration_central_log (

1125: BEGIN
1126: x_failure_count := 0;
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',

Line 1152: GMA_COMMON_LOGGING.gma_migration_central_log (

1148: WHERE action_code = g.action_code;
1149:
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',

Line 1241: GMA_COMMON_LOGGING.gma_migration_central_log (

1237: END;
1238: END LOOP;
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',

Line 1258: GMA_COMMON_LOGGING.gma_migration_central_log (

1254: EXCEPTION
1255: WHEN OTHERS THEN
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',

Line 1317: GMA_COMMON_LOGGING.gma_migration_central_log (

1313: BEGIN
1314: x_failure_count := 0;
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',

Line 1340: GMA_COMMON_LOGGING.gma_migration_central_log (

1336: WHERE grade_code = g.qc_grade;
1337:
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',

Line 1429: GMA_COMMON_LOGGING.gma_migration_central_log (

1425: END;
1426: END LOOP;
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',

Line 1446: GMA_COMMON_LOGGING.gma_migration_central_log (

1442: EXCEPTION
1443: WHEN OTHERS THEN
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',

Line 1502: GMA_COMMON_LOGGING.gma_migration_central_log (

1498: BEGIN
1499: x_failure_count := 0;
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',

Line 1581: GMA_COMMON_LOGGING.gma_migration_central_log (

1577: END;
1578: END LOOP;
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',

Line 1598: GMA_COMMON_LOGGING.gma_migration_central_log (

1594: EXCEPTION
1595: WHEN OTHERS THEN
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',

Line 1691: GMA_COMMON_LOGGING.gma_migration_central_log (

1687: BEGIN
1688: x_failure_count := 0;
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',

Line 1719: GMA_COMMON_LOGGING.gma_migration_central_log (

1715: x_failure_count => l_failure_count);
1716: IF (l_failure_count > 0) THEN
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',

Line 1776: GMA_COMMON_LOGGING.gma_migration_central_log (

1772:
1773: IF (l_count > 0) THEN
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',

Line 1892: GMA_COMMON_LOGGING.gma_migration_central_log (

1888: WHERE
1889: whse_code = adetail.whse_code;
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',

Line 1929: GMA_COMMON_LOGGING.gma_migration_central_log (

1925: location = adetail.location;
1926:
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',

Line 1981: GMA_COMMON_LOGGING.gma_migration_central_log (

1977:
1978: IF (l_failure_count > 0) THEN
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',

Line 2060: GMA_COMMON_LOGGING.gma_migration_central_log (

2056: EXCEPTION
2057: WHEN NO_DATA_FOUND THEN
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',

Line 2082: GMA_COMMON_LOGGING.gma_migration_central_log (

2078: END;
2079: END LOOP;
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',

Line 2100: GMA_COMMON_LOGGING.gma_migration_central_log (

2096: WHEN OTHERS THEN
2097: ROLLBACK;
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',

Line 2342: GMA_COMMON_LOGGING.gma_migration_central_log (

2338: l_migrate_count := 0;
2339: l_skip_to_next_whse := 0;
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',

Line 2380: GMA_COMMON_LOGGING.gma_migration_central_log (

2376: whse_code = bal.whse_code;
2377:
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',

Line 2402: GMA_COMMON_LOGGING.gma_migration_central_log (

2398: l_open_past_period);
2399: invttmtx.G_ORG_ID := NULL;
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',

Line 2418: GMA_COMMON_LOGGING.gma_migration_central_log (

2414: p_app_short_name => 'INV');
2415: RAISE e_skip_whse; -- skip all rows for the warehouse
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',

Line 2453: GMA_COMMON_LOGGING.gma_migration_central_log (

2449: -- Open all future periods till the sysdate
2450: FOR fp IN c_future_periods LOOP
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',

Line 2487: GMA_COMMON_LOGGING.gma_migration_central_log (

2483: x_return_status => l_return_status );
2484:
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',

Line 2503: GMA_COMMON_LOGGING.gma_migration_central_log (

2499: p_app_short_name => 'INV');
2500: RAISE e_skip_whse; -- skip all rows for the warehouse
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',

Line 2519: GMA_COMMON_LOGGING.gma_migration_central_log (

2515: p_app_short_name => 'INV');
2516: RAISE e_skip_whse; -- skip all rows for the warehouse
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',

Line 2535: GMA_COMMON_LOGGING.gma_migration_central_log (

2531: p_app_short_name => 'INV');
2532: RAISE e_skip_whse; -- skip all rows for the warehouse
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',

Line 2572: GMA_COMMON_LOGGING.gma_migration_central_log (

2568: x_failure_count => l_failure_count);
2569: IF (l_failure_count > 0) THEN
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',

Line 2601: GMA_COMMON_LOGGING.gma_migration_central_log (

2597: */
2598: IF (bal.noninv_ind = 1) THEN
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',

Line 2637: GMA_COMMON_LOGGING.gma_migration_central_log (

2633:
2634: IF (l_failure_count > 0) THEN
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',

Line 2683: GMA_COMMON_LOGGING.gma_migration_central_log (

2679:
2680: IF (l_locator_id is NULL) THEN
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',

Line 2744: GMA_COMMON_LOGGING.gma_migration_central_log (

2740: p_segment20 => NULL);
2741: -- Log error
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',

Line 2842: GMA_COMMON_LOGGING.gma_migration_central_log (

2838: x_transaction_set_id => l_transaction_set_id);
2839:
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',

Line 2858: GMA_COMMON_LOGGING.gma_migration_central_log (

2854: p_app_short_name => 'GMI');
2855: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
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',

Line 2898: GMA_COMMON_LOGGING.gma_migration_central_log (

2894: END IF;
2895: EXCEPTION
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',

Line 2929: GMA_COMMON_LOGGING.gma_migration_central_log (

2925: END;
2926: END LOOP;
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',

Line 2946: GMA_COMMON_LOGGING.gma_migration_central_log (

2942: EXCEPTION
2943: WHEN OTHERS THEN
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',