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_OPM_LOT_MIGRATION dependencies on GMA_COMMON_LOGGING

Line 156: GMA_COMMON_LOGGING.gma_migration_central_log (

152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN
154: -- Log error
155: -- dbms_output.put_line ('Invalid Lot id : '||to_char(p_lot_id));
156: GMA_COMMON_LOGGING.gma_migration_central_log (
157: p_run_id => p_migration_run_id,
158: p_log_level => FND_LOG.LEVEL_ERROR,
159: p_message_token => 'GMI_MIG_INVALID_LOT_ID',
160: p_table_name => 'IC_LOTS_MST',

Line 186: GMA_COMMON_LOGGING.gma_migration_central_log (

182: x_failure_count => x_failure_count);
183: IF (x_failure_count > 0) THEN
184: -- Log Error
185: -- dbms_output.put_line ('Item migration failed for Item id : '||to_char(p_item_id));
186: GMA_COMMON_LOGGING.gma_migration_central_log (
187: p_run_id => p_migration_run_id,
188: p_log_level => FND_LOG.LEVEL_ERROR,
189: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
190: p_table_name => 'IC_LOTS_MST',

Line 315: GMA_COMMON_LOGGING.gma_migration_central_log (

311:
312: EXCEPTION
313: WHEN NO_DATA_FOUND THEN
314: -- dbms_output.put_line ('Could not find '||l_field_name||' for '||l_field_value);
315: GMA_COMMON_LOGGING.gma_migration_central_log (
316: p_run_id => p_migration_run_id,
317: p_log_level => FND_LOG.LEVEL_ERROR,
318: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
319: p_table_name => 'IC_LOTS_MST',

Line 373: GMA_COMMON_LOGGING.gma_migration_central_log (

369:
370:
371: IF (l_lot_rec.vendor_id is null ) THEN
372:
373: GMA_COMMON_LOGGING.gma_migration_central_log (
374: p_run_id => p_migration_run_id,
375: p_log_level => FND_LOG.LEVEL_PROCEDURE,
376: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
377: p_table_name => 'IC_LOTS_MST',

Line 392: GMA_COMMON_LOGGING.gma_migration_central_log (

388: EXCEPTION
389:
390: WHEN NO_DATA_FOUND then
391:
392: GMA_COMMON_LOGGING.gma_migration_central_log (
393: p_run_id => p_migration_run_id,
394: p_log_level => FND_LOG.LEVEL_PROCEDURE,
395: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
396: p_table_name => 'IC_LOTS_MST',

Line 487: GMA_COMMON_LOGGING.gma_migration_central_log (

483:
484: IF (l_count > 0) THEN
485: -- Log error (warning)
486: -- dbms_output.put_line ('Lot already exists for org id, item id, lot num : '||to_char(p_organization_id)||', '||to_char(l_inventory_item_id)||', '||x_lot_number);
487: GMA_COMMON_LOGGING.gma_migration_central_log (
488: p_run_id => p_migration_run_id,
489: p_log_level => FND_LOG.LEVEL_PROCEDURE,
490: p_message_token => 'GMI_MIG_LOT_ALREADY_EXISTS',
491: p_table_name => 'IC_LOTS_MST',

Line 535: GMA_COMMON_LOGGING.gma_migration_central_log (

531: -- Log Error
532: x_failure_count := x_failure_count + 1;
533: FOR i in 1..l_msg_count LOOP
534: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
535: GMA_COMMON_LOGGING.gma_migration_central_log (
536: p_run_id => p_migration_run_id,
537: p_log_level => FND_LOG.LEVEL_ERROR,
538: p_message_token => 'GMI_UNEXPECTED_ERROR',
539: p_table_name => 'IC_LOTS_MST',

Line 695: GMA_COMMON_LOGGING.gma_migration_central_log (

691: IF (l_opm_context is not NULL and l_odm_context is not NULL) THEN
692: g_desc_flex_conflict := 1;
693: -- Log Error
694: -- dbms_output.put_line ('Desc flexfield conflict. OPM context: '|| l_opm_context ||', ODM context: '|| l_odm_context);
695: GMA_COMMON_LOGGING.gma_migration_central_log (
696: p_run_id => p_migration_run_id,
697: p_log_level => FND_LOG.LEVEL_ERROR,
698: p_message_token => 'GMI_MIG_DFLEX_COL_CONFLICT', -- Bug 5720001
699: p_table_name => 'IC_LOTS_MST',

Line 718: GMA_COMMON_LOGGING.gma_migration_central_log (

714: -- If we are here, that means we have a conflict
715: g_desc_flex_conflict := 1;
716:
717: -- dbms_output.put_line ('Desc flexfield column conflict.');
718: GMA_COMMON_LOGGING.gma_migration_central_log (
719: p_run_id => p_migration_run_id,
720: p_log_level => FND_LOG.LEVEL_ERROR,
721: p_message_token => 'GMI_MIG_DFLEX_COL_CONFLICT', -- Bug 5720001
722: p_table_name => 'IC_LOTS_MST',

Line 885: GMA_COMMON_LOGGING.gma_migration_central_log (

881:
882: IF (l_location_whse <> l_whse_code) THEN
883: -- Log Error
884: -- dbms_output.put_line ('Warehouse for the orgnization and loctor id do not match. org id, org_whse, locator id, whse :'||to_char(p_organization_id)||', '||l_whse_code||', '||to_char(p_locator_id)||', '||l_location_whse);
885: GMA_COMMON_LOGGING.gma_migration_central_log (
886: p_run_id => p_migration_run_id,
887: p_log_level => FND_LOG.LEVEL_ERROR,
888: p_message_token => 'GMI_MIG_DIFF_ORG_LOC_WHSE',
889: p_table_name => 'IC_LOTS_MST',

Line 918: GMA_COMMON_LOGGING.gma_migration_central_log (

914: x_failure_count => x_failure_count);
915: EXCEPTION
916: WHEN NO_DATA_FOUND THEN
917: -- dbms_output.put_line ('Could not find '||l_field_name||' for '||l_field_value);
918: GMA_COMMON_LOGGING.gma_migration_central_log (
919: p_run_id => p_migration_run_id,
920: p_log_level => FND_LOG.LEVEL_ERROR,
921: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
922: p_table_name => 'IC_LOTS_MST',

Line 1025: GMA_COMMON_LOGGING.gma_migration_central_log (

1021: EXCEPTION
1022: WHEN NO_DATA_FOUND THEN
1023: -- Log error
1024: -- dbms_output.put_line ('Invalid OPM lot. Item id, lot no, sublot no : '||to_char(p_item_id)||', '||p_lot_no||', '||p_sublot_no);
1025: GMA_COMMON_LOGGING.gma_migration_central_log (
1026: p_run_id => p_migration_run_id,
1027: p_log_level => FND_LOG.LEVEL_ERROR,
1028: p_message_token => 'GMI_MIG_INVALID_LOT',
1029: p_table_name => 'IC_LOTS_MST',

Line 1054: GMA_COMMON_LOGGING.gma_migration_central_log (

1050: migrated_ind = 1;
1051: IF (l_count = 0) THEN
1052: -- Log error
1053: -- dbms_output.put_line ('No parent lot found for item id, whse_code, lot no : '||to_char(p_item_id)||', '||p_whse_code||', '||p_lot_no);
1054: GMA_COMMON_LOGGING.gma_migration_central_log (
1055: p_run_id => p_migration_run_id,
1056: p_log_level => FND_LOG.LEVEL_ERROR,
1057: p_message_token => 'GMI_MIG_NO_PARENT_LOT',
1058: p_table_name => 'IC_LOTS_MST',

Line 1153: GMA_COMMON_LOGGING.gma_migration_central_log (

1149: or ( p_orgn_code is not NULL and p_location is not NULL)
1150: or ( p_organization_id is not NULL and p_location is not NULL)) THEN
1151: -- Log validation error
1152: -- dbms_output.put_line ('Invalid parameters');
1153: GMA_COMMON_LOGGING.gma_migration_central_log (
1154: p_run_id => p_migration_run_id,
1155: p_log_level => FND_LOG.LEVEL_ERROR,
1156: p_message_token => 'GMI_MIG_INVALID_PARAMS',
1157: p_table_name => 'IC_LOTS_MST',

Line 1208: GMA_COMMON_LOGGING.gma_migration_central_log (

1204:
1205: IF (l_organization_id is NULL or l_whse_migrated_ind = 0) THEN
1206: -- Log error
1207: -- dbms_output.put_line ('Warehouse not migrated : '||p_whse_code);
1208: GMA_COMMON_LOGGING.gma_migration_central_log (
1209: p_run_id => p_migration_run_id,
1210: p_log_level => FND_LOG.LEVEL_ERROR,
1211: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
1212: p_table_name => 'IC_LOTS_MST',

Line 1228: GMA_COMMON_LOGGING.gma_migration_central_log (

1224: EXCEPTION
1225: WHEN NO_DATA_FOUND THEN
1226: -- Log error
1227: -- dbms_output.put_line ('Invalid warehouse : '||p_whse_code);
1228: GMA_COMMON_LOGGING.gma_migration_central_log (
1229: p_run_id => p_migration_run_id,
1230: p_log_level => FND_LOG.LEVEL_ERROR,
1231: p_message_token => 'GMI_MIG_INVALID_WHSE',
1232: p_table_name => 'IC_LOTS_MST',

Line 1255: GMA_COMMON_LOGGING.gma_migration_central_log (

1251:
1252: IF (l_organization_id is NULL or l_orgn_migrated_ind = 0) THEN
1253: -- Log error
1254: -- dbms_output.put_line ('Organization not migrated : '||p_orgn_code);
1255: GMA_COMMON_LOGGING.gma_migration_central_log (
1256: p_run_id => p_migration_run_id,
1257: p_log_level => FND_LOG.LEVEL_ERROR,
1258: p_message_token => 'GMI_MIG_ORGN_NOT_MIGRATED',
1259: p_table_name => 'IC_LOTS_MST',

Line 1275: GMA_COMMON_LOGGING.gma_migration_central_log (

1271: EXCEPTION
1272: WHEN NO_DATA_FOUND THEN
1273: -- Log error
1274: -- dbms_output.put_line ('Invalid organization : '||p_orgn_code);
1275: GMA_COMMON_LOGGING.gma_migration_central_log (
1276: p_run_id => p_migration_run_id,
1277: p_log_level => FND_LOG.LEVEL_ERROR,
1278: p_message_token => 'GMI_MIG_INVALID_ORGN',
1279: p_table_name => 'IC_LOTS_MST',

Line 1365: GMA_COMMON_LOGGING.gma_migration_central_log (

1361: x_parent_lot_number,
1362: x_failure_count);
1363: IF (x_failure_count > 0) THEN
1364: -- dbms_output.put_line ('OPM Lot migration failed. item id, lot id, whse, location : '||to_char(p_item_id)||', '||to_char(p_lot_id)||', '||p_whse_code||', '||p_location);
1365: GMA_COMMON_LOGGING.gma_migration_central_log (
1366: p_run_id => p_migration_run_id,
1367: p_log_level => FND_LOG.LEVEL_ERROR,
1368: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
1369: p_table_name => 'IC_LOTS_MST',

Line 1389: GMA_COMMON_LOGGING.gma_migration_central_log (

1385: x_failure_count := x_failure_count + 1;
1386: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1387: FOR i in 1..l_msg_count LOOP
1388: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1389: GMA_COMMON_LOGGING.gma_migration_central_log (
1390: p_run_id => P_migration_run_id,
1391: p_log_level => FND_LOG.LEVEL_ERROR,
1392: p_message_token => 'GMI_UNEXPECTED_ERROR',
1393: p_table_name => 'IC_LOTS_MST',

Line 1410: GMA_COMMON_LOGGING.gma_migration_central_log (

1406: x_failure_count := x_failure_count + 1;
1407: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1408: FOR i in 1..l_msg_count LOOP
1409: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1410: GMA_COMMON_LOGGING.gma_migration_central_log (
1411: p_run_id => P_migration_run_id,
1412: p_log_level => FND_LOG.LEVEL_ERROR,
1413: p_message_token => 'GMI_UNEXPECTED_ERROR',
1414: p_table_name => 'IC_LOTS_MST',

Line 1431: GMA_COMMON_LOGGING.gma_migration_central_log (

1427: x_failure_count := x_failure_count + 1;
1428: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1429: FOR i in 1..l_msg_count LOOP
1430: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1431: GMA_COMMON_LOGGING.gma_migration_central_log (
1432: p_run_id => P_migration_run_id,
1433: p_log_level => FND_LOG.LEVEL_ERROR,
1434: p_message_token => 'GMI_UNEXPECTED_ERROR',
1435: p_table_name => 'IC_LOTS_MST',

Line 1447: GMA_COMMON_LOGGING.gma_migration_central_log (

1443: p_db_error => NULL,
1444: p_app_short_name => 'GMI');
1445: END LOOP;
1446: -- dbms_output.put_line (substr(SQLERRM,1,255));
1447: GMA_COMMON_LOGGING.gma_migration_central_log (
1448: p_run_id => P_migration_run_id,
1449: p_log_level => FND_LOG.LEVEL_ERROR,
1450: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1451: p_table_name => 'IC_LOTS_MST',