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.

[Home] [Help]

APPS.INV_OPM_LOT_MIGRATION dependencies on FND_LOG

Line 158: p_log_level => FND_LOG.LEVEL_ERROR,

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',
161: p_context => 'LOTS',
162: p_param1 => INV_GMI_Migration.lot(p_lot_id),

Line 188: p_log_level => FND_LOG.LEVEL_ERROR,

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',
191: p_context => 'LOTS',
192: p_param1 => INV_GMI_Migration.org(p_organization_id),

Line 317: p_log_level => FND_LOG.LEVEL_ERROR,

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',
320: p_context => 'LOTS',
321: p_param1 => l_field_name,

Line 375: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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',
378: p_context => 'LOTS',
379: p_param1 => 'Supplier Id/Name' ,

Line 394: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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',
397: p_context => 'LOTS',
398: p_param1 => 'Supplier Id/Name' ,

Line 489: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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',
492: p_context => 'LOTS',
493: p_param1 => INV_GMI_Migration.org(p_organization_id),

Line 537: p_log_level => FND_LOG.LEVEL_ERROR,

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',
540: p_context => 'LOTS',
541: p_token1 => 'ERROR',

Line 697: p_log_level => FND_LOG.LEVEL_ERROR,

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',
700: p_context => 'LOTS',
701: p_param1 => l_opm_context,

Line 720: p_log_level => FND_LOG.LEVEL_ERROR,

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',
723: p_context => 'LOTS',
724: p_param1 => conflict_columns.descriptive_flex_context_code,

Line 887: p_log_level => FND_LOG.LEVEL_ERROR,

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',
890: p_context => 'LOTS',
891: p_param1 => INV_GMI_Migration.org(p_organization_id),

Line 920: p_log_level => FND_LOG.LEVEL_ERROR,

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',
923: p_context => 'LOTS',
924: p_param1 => l_field_name,

Line 1027: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1030: p_context => 'LOTS',
1031: p_param1 => p_lot_no,

Line 1056: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1059: p_context => 'LOTS',
1060: p_param1 => INV_GMI_Migration.item(p_item_id),

Line 1155: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1158: p_context => 'LOTS',
1159: p_param1 => NULL,

Line 1210: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1213: p_context => 'LOTS',
1214: p_param1 => p_whse_code,

Line 1230: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1233: p_context => 'LOTS',
1234: p_param1 => p_whse_code,

Line 1257: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1260: p_context => 'LOTS',
1261: p_param1 => p_orgn_code,

Line 1277: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1280: p_context => 'LOTS',
1281: p_param1 => p_orgn_code,

Line 1367: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1370: p_context => 'LOTS',
1371: p_param1 => INV_GMI_Migration.item(p_item_id),

Line 1391: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1394: p_context => 'LOTS',
1395: p_token1 => 'ERROR',

Line 1412: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1415: p_context => 'LOTS',
1416: p_token1 => 'ERROR',

Line 1433: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1436: p_context => 'LOTS',
1437: p_token1 => 'ERROR',

Line 1449: p_log_level => FND_LOG.LEVEL_ERROR,

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',
1452: p_context => 'LOTS',
1453: p_param1 => NULL,