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 273: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 302: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 376: GMA_COMMON_LOGGING.gma_migration_central_log (

372: END;
373: END LOOP;
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',

Line 393: GMA_COMMON_LOGGING.gma_migration_central_log (

389: EXCEPTION
390: WHEN OTHERS THEN
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',

Line 452: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 480: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 517: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 534: GMA_COMMON_LOGGING.gma_migration_central_log (

530: END;
531: END LOOP;
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',

Line 551: GMA_COMMON_LOGGING.gma_migration_central_log (

547: EXCEPTION
548: WHEN OTHERS THEN
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',

Line 618: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 683: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 711: GMA_COMMON_LOGGING.gma_migration_central_log (

707: WHERE
708: rowid BETWEEN p_start_rowid AND p_end_rowid);
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',

Line 728: GMA_COMMON_LOGGING.gma_migration_central_log (

724: EXCEPTION
725: WHEN OTHERS THEN
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',

Line 796: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 822: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 960: GMA_COMMON_LOGGING.gma_migration_central_log (

956: END;
957: END LOOP;
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',

Line 978: GMA_COMMON_LOGGING.gma_migration_central_log (

974: EXCEPTION
975: WHEN OTHERS THEN
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',

Line 1037: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1060: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1149: GMA_COMMON_LOGGING.gma_migration_central_log (

1145: END;
1146: END LOOP;
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',

Line 1166: GMA_COMMON_LOGGING.gma_migration_central_log (

1162: EXCEPTION
1163: WHEN OTHERS THEN
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',

Line 1225: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1248: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1337: GMA_COMMON_LOGGING.gma_migration_central_log (

1333: END;
1334: END LOOP;
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',

Line 1354: GMA_COMMON_LOGGING.gma_migration_central_log (

1350: EXCEPTION
1351: WHEN OTHERS THEN
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',

Line 1410: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1489: GMA_COMMON_LOGGING.gma_migration_central_log (

1485: END;
1486: END LOOP;
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',

Line 1506: GMA_COMMON_LOGGING.gma_migration_central_log (

1502: EXCEPTION
1503: WHEN OTHERS THEN
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',

Line 1599: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1627: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1684: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1800: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1837: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1889: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1968: GMA_COMMON_LOGGING.gma_migration_central_log (

1964: EXCEPTION
1965: WHEN NO_DATA_FOUND THEN
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',

Line 1990: GMA_COMMON_LOGGING.gma_migration_central_log (

1986: END;
1987: END LOOP;
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',

Line 2008: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2228: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2266: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2288: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2304: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2339: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2373: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2389: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2405: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2421: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2458: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2486: GMA_COMMON_LOGGING.gma_migration_central_log (

2482:
2483: IF (l_noninv_ind = 1) THEN
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',

Line 2522: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2563: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2624: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2722: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2738: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2778: GMA_COMMON_LOGGING.gma_migration_central_log (

2774: END IF;
2775: EXCEPTION
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',

Line 2809: GMA_COMMON_LOGGING.gma_migration_central_log (

2805: END;
2806: END LOOP;
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',

Line 2826: GMA_COMMON_LOGGING.gma_migration_central_log (

2822: EXCEPTION
2823: WHEN OTHERS THEN
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',