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

141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN
143: -- Log error
144: -- dbms_output.put_line ('Invalid Lot id : '||to_char(p_lot_id));
145: GMA_COMMON_LOGGING.gma_migration_central_log (
146: p_run_id => p_migration_run_id,
147: p_log_level => FND_LOG.LEVEL_ERROR,
148: p_message_token => 'GMI_MIG_INVALID_LOT_ID',
149: p_table_name => 'IC_LOTS_MST',

Line 175: GMA_COMMON_LOGGING.gma_migration_central_log (

171: x_failure_count => x_failure_count);
172: IF (x_failure_count > 0) THEN
173: -- Log Error
174: -- dbms_output.put_line ('Item migration failed for Item id : '||to_char(p_item_id));
175: GMA_COMMON_LOGGING.gma_migration_central_log (
176: p_run_id => p_migration_run_id,
177: p_log_level => FND_LOG.LEVEL_ERROR,
178: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
179: p_table_name => 'IC_LOTS_MST',

Line 304: GMA_COMMON_LOGGING.gma_migration_central_log (

300:
301: EXCEPTION
302: WHEN NO_DATA_FOUND THEN
303: -- dbms_output.put_line ('Could not find '||l_field_name||' for '||l_field_value);
304: GMA_COMMON_LOGGING.gma_migration_central_log (
305: p_run_id => p_migration_run_id,
306: p_log_level => FND_LOG.LEVEL_ERROR,
307: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
308: p_table_name => 'IC_LOTS_MST',

Line 411: GMA_COMMON_LOGGING.gma_migration_central_log (

407:
408: IF (l_count > 0) THEN
409: -- Log error (warning)
410: -- 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);
411: GMA_COMMON_LOGGING.gma_migration_central_log (
412: p_run_id => p_migration_run_id,
413: p_log_level => FND_LOG.LEVEL_PROCEDURE,
414: p_message_token => 'GMI_MIG_LOT_ALREADY_EXISTS',
415: p_table_name => 'IC_LOTS_MST',

Line 443: GMA_COMMON_LOGGING.gma_migration_central_log (

439: -- Log Error
440: x_failure_count := x_failure_count + 1;
441: FOR i in 1..l_msg_count LOOP
442: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
443: GMA_COMMON_LOGGING.gma_migration_central_log (
444: p_run_id => p_migration_run_id,
445: p_log_level => FND_LOG.LEVEL_ERROR,
446: p_message_token => 'GMI_UNEXPECTED_ERROR',
447: p_table_name => 'IC_LOTS_MST',

Line 601: GMA_COMMON_LOGGING.gma_migration_central_log (

597: IF (l_opm_context is not NULL and l_odm_context is not NULL) THEN
598: g_desc_flex_conflict := 1;
599: -- Log Error
600: -- dbms_output.put_line ('Desc flexfield conflict. OPM context: '|| l_opm_context ||', ODM context: '|| l_odm_context);
601: GMA_COMMON_LOGGING.gma_migration_central_log (
602: p_run_id => p_migration_run_id,
603: p_log_level => FND_LOG.LEVEL_ERROR,
604: p_message_token => 'GMI_MIG_DFLEX_CONTEXT_CONFLICT',
605: p_table_name => 'IC_LOTS_MST',

Line 624: GMA_COMMON_LOGGING.gma_migration_central_log (

620: -- If we are here, that means we have a conflict
621: g_desc_flex_conflict := 1;
622:
623: -- dbms_output.put_line ('Desc flexfield column conflict.');
624: GMA_COMMON_LOGGING.gma_migration_central_log (
625: p_run_id => p_migration_run_id,
626: p_log_level => FND_LOG.LEVEL_ERROR,
627: p_message_token => 'GMI_MIG_DFLEX_CONTEXT_CONFLICT',
628: p_table_name => 'IC_LOTS_MST',

Line 791: GMA_COMMON_LOGGING.gma_migration_central_log (

787:
788: IF (l_location_whse <> l_whse_code) THEN
789: -- Log Error
790: -- 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);
791: GMA_COMMON_LOGGING.gma_migration_central_log (
792: p_run_id => p_migration_run_id,
793: p_log_level => FND_LOG.LEVEL_ERROR,
794: p_message_token => 'GMI_MIG_DIFF_ORG_LOC_WHSE',
795: p_table_name => 'IC_LOTS_MST',

Line 824: GMA_COMMON_LOGGING.gma_migration_central_log (

820: x_failure_count => x_failure_count);
821: EXCEPTION
822: WHEN NO_DATA_FOUND THEN
823: -- dbms_output.put_line ('Could not find '||l_field_name||' for '||l_field_value);
824: GMA_COMMON_LOGGING.gma_migration_central_log (
825: p_run_id => p_migration_run_id,
826: p_log_level => FND_LOG.LEVEL_ERROR,
827: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
828: p_table_name => 'IC_LOTS_MST',

Line 931: GMA_COMMON_LOGGING.gma_migration_central_log (

927: EXCEPTION
928: WHEN NO_DATA_FOUND THEN
929: -- Log error
930: -- dbms_output.put_line ('Invalid OPM lot. Item id, lot no, sublot no : '||to_char(p_item_id)||', '||p_lot_no||', '||p_sublot_no);
931: GMA_COMMON_LOGGING.gma_migration_central_log (
932: p_run_id => p_migration_run_id,
933: p_log_level => FND_LOG.LEVEL_ERROR,
934: p_message_token => 'GMI_MIG_INVALID_LOT',
935: p_table_name => 'IC_LOTS_MST',

Line 960: GMA_COMMON_LOGGING.gma_migration_central_log (

956: migrated_ind = 1;
957: IF (l_count = 0) THEN
958: -- Log error
959: -- 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);
960: GMA_COMMON_LOGGING.gma_migration_central_log (
961: p_run_id => p_migration_run_id,
962: p_log_level => FND_LOG.LEVEL_ERROR,
963: p_message_token => 'GMI_MIG_NO_PARENT_LOT',
964: p_table_name => 'IC_LOTS_MST',

Line 1059: GMA_COMMON_LOGGING.gma_migration_central_log (

1055: or ( p_orgn_code is not NULL and p_location is not NULL)
1056: or ( p_organization_id is not NULL and p_location is not NULL)) THEN
1057: -- Log validation error
1058: -- dbms_output.put_line ('Invalid parameters');
1059: GMA_COMMON_LOGGING.gma_migration_central_log (
1060: p_run_id => p_migration_run_id,
1061: p_log_level => FND_LOG.LEVEL_ERROR,
1062: p_message_token => 'GMI_MIG_INVALID_PARAMS',
1063: p_table_name => 'IC_LOTS_MST',

Line 1114: GMA_COMMON_LOGGING.gma_migration_central_log (

1110:
1111: IF (l_organization_id is NULL or l_whse_migrated_ind = 0) THEN
1112: -- Log error
1113: -- dbms_output.put_line ('Warehouse not migrated : '||p_whse_code);
1114: GMA_COMMON_LOGGING.gma_migration_central_log (
1115: p_run_id => p_migration_run_id,
1116: p_log_level => FND_LOG.LEVEL_ERROR,
1117: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
1118: p_table_name => 'IC_LOTS_MST',

Line 1134: GMA_COMMON_LOGGING.gma_migration_central_log (

1130: EXCEPTION
1131: WHEN NO_DATA_FOUND THEN
1132: -- Log error
1133: -- dbms_output.put_line ('Invalid warehouse : '||p_whse_code);
1134: GMA_COMMON_LOGGING.gma_migration_central_log (
1135: p_run_id => p_migration_run_id,
1136: p_log_level => FND_LOG.LEVEL_ERROR,
1137: p_message_token => 'GMI_MIG_INVALID_WHSE',
1138: p_table_name => 'IC_LOTS_MST',

Line 1161: GMA_COMMON_LOGGING.gma_migration_central_log (

1157:
1158: IF (l_organization_id is NULL or l_orgn_migrated_ind = 0) THEN
1159: -- Log error
1160: -- dbms_output.put_line ('Organization not migrated : '||p_orgn_code);
1161: GMA_COMMON_LOGGING.gma_migration_central_log (
1162: p_run_id => p_migration_run_id,
1163: p_log_level => FND_LOG.LEVEL_ERROR,
1164: p_message_token => 'GMI_MIG_ORGN_NOT_MIGRATED',
1165: p_table_name => 'IC_LOTS_MST',

Line 1181: GMA_COMMON_LOGGING.gma_migration_central_log (

1177: EXCEPTION
1178: WHEN NO_DATA_FOUND THEN
1179: -- Log error
1180: -- dbms_output.put_line ('Invalid organization : '||p_orgn_code);
1181: GMA_COMMON_LOGGING.gma_migration_central_log (
1182: p_run_id => p_migration_run_id,
1183: p_log_level => FND_LOG.LEVEL_ERROR,
1184: p_message_token => 'GMI_MIG_INVALID_ORGN',
1185: p_table_name => 'IC_LOTS_MST',

Line 1271: GMA_COMMON_LOGGING.gma_migration_central_log (

1267: x_parent_lot_number,
1268: x_failure_count);
1269: IF (x_failure_count > 0) THEN
1270: -- 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);
1271: GMA_COMMON_LOGGING.gma_migration_central_log (
1272: p_run_id => p_migration_run_id,
1273: p_log_level => FND_LOG.LEVEL_ERROR,
1274: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
1275: p_table_name => 'IC_LOTS_MST',

Line 1295: GMA_COMMON_LOGGING.gma_migration_central_log (

1291: x_failure_count := x_failure_count + 1;
1292: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1293: FOR i in 1..l_msg_count LOOP
1294: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1295: GMA_COMMON_LOGGING.gma_migration_central_log (
1296: p_run_id => P_migration_run_id,
1297: p_log_level => FND_LOG.LEVEL_ERROR,
1298: p_message_token => 'GMI_UNEXPECTED_ERROR',
1299: p_table_name => 'IC_LOTS_MST',

Line 1316: GMA_COMMON_LOGGING.gma_migration_central_log (

1312: x_failure_count := x_failure_count + 1;
1313: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1314: FOR i in 1..l_msg_count LOOP
1315: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1316: GMA_COMMON_LOGGING.gma_migration_central_log (
1317: p_run_id => P_migration_run_id,
1318: p_log_level => FND_LOG.LEVEL_ERROR,
1319: p_message_token => 'GMI_UNEXPECTED_ERROR',
1320: p_table_name => 'IC_LOTS_MST',

Line 1337: GMA_COMMON_LOGGING.gma_migration_central_log (

1333: x_failure_count := x_failure_count + 1;
1334: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1335: FOR i in 1..l_msg_count LOOP
1336: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1337: GMA_COMMON_LOGGING.gma_migration_central_log (
1338: p_run_id => P_migration_run_id,
1339: p_log_level => FND_LOG.LEVEL_ERROR,
1340: p_message_token => 'GMI_UNEXPECTED_ERROR',
1341: p_table_name => 'IC_LOTS_MST',

Line 1353: GMA_COMMON_LOGGING.gma_migration_central_log (

1349: p_db_error => NULL,
1350: p_app_short_name => 'GMI');
1351: END LOOP;
1352: -- dbms_output.put_line (substr(SQLERRM,1,255));
1353: GMA_COMMON_LOGGING.gma_migration_central_log (
1354: p_run_id => P_migration_run_id,
1355: p_log_level => FND_LOG.LEVEL_ERROR,
1356: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1357: p_table_name => 'IC_LOTS_MST',