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.GME_API_GRP dependencies on FND_FILE

Line 1205: fnd_file.put (fnd_file.output,fnd_message.get );

1201: END IF;
1202:
1203: --FPBug#4991508 hard codes strings are seeded for NLS complaint
1204: fnd_message.set_name('GME','GME_INPUT_PARAM');
1205: fnd_file.put (fnd_file.output,fnd_message.get );
1206: fnd_file.new_line (fnd_file.output, 1);
1207: fnd_message.set_name('GME','GME_ORG_ID');
1208: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);
1209: fnd_file.new_line (fnd_file.output, 1);

Line 1206: fnd_file.new_line (fnd_file.output, 1);

1202:
1203: --FPBug#4991508 hard codes strings are seeded for NLS complaint
1204: fnd_message.set_name('GME','GME_INPUT_PARAM');
1205: fnd_file.put (fnd_file.output,fnd_message.get );
1206: fnd_file.new_line (fnd_file.output, 1);
1207: fnd_message.set_name('GME','GME_ORG_ID');
1208: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);
1209: fnd_file.new_line (fnd_file.output, 1);
1210: fnd_message.set_name('GME','GME_OLD_ITEM');

Line 1208: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);

1204: fnd_message.set_name('GME','GME_INPUT_PARAM');
1205: fnd_file.put (fnd_file.output,fnd_message.get );
1206: fnd_file.new_line (fnd_file.output, 1);
1207: fnd_message.set_name('GME','GME_ORG_ID');
1208: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);
1209: fnd_file.new_line (fnd_file.output, 1);
1210: fnd_message.set_name('GME','GME_OLD_ITEM');
1211: fnd_file.put (fnd_file.output, fnd_message.get|| l_old_item_rec.concatenated_segments);
1212: fnd_file.new_line (fnd_file.output, 1);

Line 1209: fnd_file.new_line (fnd_file.output, 1);

1205: fnd_file.put (fnd_file.output,fnd_message.get );
1206: fnd_file.new_line (fnd_file.output, 1);
1207: fnd_message.set_name('GME','GME_ORG_ID');
1208: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);
1209: fnd_file.new_line (fnd_file.output, 1);
1210: fnd_message.set_name('GME','GME_OLD_ITEM');
1211: fnd_file.put (fnd_file.output, fnd_message.get|| l_old_item_rec.concatenated_segments);
1212: fnd_file.new_line (fnd_file.output, 1);
1213: l_start_date := TO_DATE (p_start_date, 'YYYY/MM/DD HH24:MI:SS');

Line 1211: fnd_file.put (fnd_file.output, fnd_message.get|| l_old_item_rec.concatenated_segments);

1207: fnd_message.set_name('GME','GME_ORG_ID');
1208: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);
1209: fnd_file.new_line (fnd_file.output, 1);
1210: fnd_message.set_name('GME','GME_OLD_ITEM');
1211: fnd_file.put (fnd_file.output, fnd_message.get|| l_old_item_rec.concatenated_segments);
1212: fnd_file.new_line (fnd_file.output, 1);
1213: l_start_date := TO_DATE (p_start_date, 'YYYY/MM/DD HH24:MI:SS');
1214: l_end_date := TO_DATE (p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1215: fnd_message.set_name('GME','GME_DATE_RANGE');

Line 1212: fnd_file.new_line (fnd_file.output, 1);

1208: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);
1209: fnd_file.new_line (fnd_file.output, 1);
1210: fnd_message.set_name('GME','GME_OLD_ITEM');
1211: fnd_file.put (fnd_file.output, fnd_message.get|| l_old_item_rec.concatenated_segments);
1212: fnd_file.new_line (fnd_file.output, 1);
1213: l_start_date := TO_DATE (p_start_date, 'YYYY/MM/DD HH24:MI:SS');
1214: l_end_date := TO_DATE (p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1215: fnd_message.set_name('GME','GME_DATE_RANGE');
1216: fnd_file.put (fnd_file.output,

Line 1216: fnd_file.put (fnd_file.output,

1212: fnd_file.new_line (fnd_file.output, 1);
1213: l_start_date := TO_DATE (p_start_date, 'YYYY/MM/DD HH24:MI:SS');
1214: l_end_date := TO_DATE (p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1215: fnd_message.set_name('GME','GME_DATE_RANGE');
1216: fnd_file.put (fnd_file.output,
1217: fnd_message.get
1218: || TO_CHAR (l_start_date, 'DD-MON-YYYY HH24:MI:SS')
1219: || ' <-> '
1220: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')

Line 1223: fnd_file.new_line (fnd_file.output, 1);

1219: || ' <-> '
1220: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')
1221: );
1222: --Bug#4533850
1223: fnd_file.new_line (fnd_file.output, 1);
1224: fnd_message.set_name('GME','GME_FROM_BATCH');
1225: fnd_file.put (fnd_file.output, fnd_message.get|| p_from_batch_no);
1226: fnd_file.new_line (fnd_file.output, 1);
1227: fnd_message.set_name('GME','GME_TO_BATCH');

Line 1225: fnd_file.put (fnd_file.output, fnd_message.get|| p_from_batch_no);

1221: );
1222: --Bug#4533850
1223: fnd_file.new_line (fnd_file.output, 1);
1224: fnd_message.set_name('GME','GME_FROM_BATCH');
1225: fnd_file.put (fnd_file.output, fnd_message.get|| p_from_batch_no);
1226: fnd_file.new_line (fnd_file.output, 1);
1227: fnd_message.set_name('GME','GME_TO_BATCH');
1228: fnd_file.put (fnd_file.output, fnd_message.get|| p_to_batch_no);
1229: fnd_file.new_line (fnd_file.output, 2);

Line 1226: fnd_file.new_line (fnd_file.output, 1);

1222: --Bug#4533850
1223: fnd_file.new_line (fnd_file.output, 1);
1224: fnd_message.set_name('GME','GME_FROM_BATCH');
1225: fnd_file.put (fnd_file.output, fnd_message.get|| p_from_batch_no);
1226: fnd_file.new_line (fnd_file.output, 1);
1227: fnd_message.set_name('GME','GME_TO_BATCH');
1228: fnd_file.put (fnd_file.output, fnd_message.get|| p_to_batch_no);
1229: fnd_file.new_line (fnd_file.output, 2);
1230:

Line 1228: fnd_file.put (fnd_file.output, fnd_message.get|| p_to_batch_no);

1224: fnd_message.set_name('GME','GME_FROM_BATCH');
1225: fnd_file.put (fnd_file.output, fnd_message.get|| p_from_batch_no);
1226: fnd_file.new_line (fnd_file.output, 1);
1227: fnd_message.set_name('GME','GME_TO_BATCH');
1228: fnd_file.put (fnd_file.output, fnd_message.get|| p_to_batch_no);
1229: fnd_file.new_line (fnd_file.output, 2);
1230:
1231: FOR rec IN get_ingredients (p_org_id, p_item_id, l_start_date, l_end_date,p_from_batch_no,p_to_batch_no) LOOP
1232: IF rec.batch_type = 0 THEN

Line 1229: fnd_file.new_line (fnd_file.output, 2);

1225: fnd_file.put (fnd_file.output, fnd_message.get|| p_from_batch_no);
1226: fnd_file.new_line (fnd_file.output, 1);
1227: fnd_message.set_name('GME','GME_TO_BATCH');
1228: fnd_file.put (fnd_file.output, fnd_message.get|| p_to_batch_no);
1229: fnd_file.new_line (fnd_file.output, 2);
1230:
1231: FOR rec IN get_ingredients (p_org_id, p_item_id, l_start_date, l_end_date,p_from_batch_no,p_to_batch_no) LOOP
1232: IF rec.batch_type = 0 THEN
1233: OPEN get_msg('GME_BATCH');

Line 1305: fnd_file.put (fnd_file.output,fnd_message.get);

1301: fnd_message.set_token('LINE',rec.line_no);
1302: fnd_message.set_token('ITEM',rec.item_no);
1303: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1304: fnd_message.set_token('MSG',l_message_list);
1305: fnd_file.put (fnd_file.output,fnd_message.get);
1306:
1307: fnd_file.new_line (fnd_file.output, 1);
1308: --FPBug#4351032 used gme_common_pvt.log_message
1309: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'

Line 1307: fnd_file.new_line (fnd_file.output, 1);

1303: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1304: fnd_message.set_token('MSG',l_message_list);
1305: fnd_file.put (fnd_file.output,fnd_message.get);
1306:
1307: fnd_file.new_line (fnd_file.output, 1);
1308: --FPBug#4351032 used gme_common_pvt.log_message
1309: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1310: ,p_token1_name => 'DOC'
1311: ,P_token1_value => l_doc_str||' '||rec.batch_no

Line 1325: fnd_file.put(fnd_file.output,l_message_list);

1321: gme_common_pvt.count_and_get (x_count => l_message_count,
1322: p_encoded => fnd_api.g_false,
1323: x_data => l_message_list
1324: );
1325: fnd_file.put(fnd_file.output,l_message_list);
1326: fnd_file.new_line (fnd_file.output, 1);
1327: GOTO NEXT_RECORD; --GO to next record
1328: END IF;
1329:

Line 1326: fnd_file.new_line (fnd_file.output, 1);

1322: p_encoded => fnd_api.g_false,
1323: x_data => l_message_list
1324: );
1325: fnd_file.put(fnd_file.output,l_message_list);
1326: fnd_file.new_line (fnd_file.output, 1);
1327: GOTO NEXT_RECORD; --GO to next record
1328: END IF;
1329:
1330: -- nsinghi bug#5674398. Moved the code to here.

Line 1350: fnd_file.put (fnd_file.output,fnd_message.get);

1346: fnd_message.set_token('LINE',rec.line_no);
1347: fnd_message.set_token('ITEM',rec.item_no);
1348: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1349: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1350: fnd_file.put (fnd_file.output,fnd_message.get);
1351:
1352: fnd_file.put(fnd_file.output,l_message_list);
1353: fnd_file.new_line (fnd_file.output, 1);
1354: --FPBug#4351032 used gme_common_pvt.log_message

Line 1352: fnd_file.put(fnd_file.output,l_message_list);

1348: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1349: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1350: fnd_file.put (fnd_file.output,fnd_message.get);
1351:
1352: fnd_file.put(fnd_file.output,l_message_list);
1353: fnd_file.new_line (fnd_file.output, 1);
1354: --FPBug#4351032 used gme_common_pvt.log_message
1355: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION_EXEC'
1356: ,p_token1_name => 'DOC'

Line 1353: fnd_file.new_line (fnd_file.output, 1);

1349: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1350: fnd_file.put (fnd_file.output,fnd_message.get);
1351:
1352: fnd_file.put(fnd_file.output,l_message_list);
1353: fnd_file.new_line (fnd_file.output, 1);
1354: --FPBug#4351032 used gme_common_pvt.log_message
1355: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION_EXEC'
1356: ,p_token1_name => 'DOC'
1357: ,P_token1_value => l_doc_str||' '||rec.batch_no

Line 1371: fnd_file.put(fnd_file.output,l_message_list);

1367: gme_common_pvt.count_and_get (x_count => l_message_count,
1368: p_encoded => fnd_api.g_false,
1369: x_data => l_message_list
1370: );
1371: fnd_file.put(fnd_file.output,l_message_list);
1372: fnd_file.new_line (fnd_file.output, 1);
1373: GOTO NEXT_RECORD; --GO to next record
1374: END IF;
1375:

Line 1372: fnd_file.new_line (fnd_file.output, 1);

1368: p_encoded => fnd_api.g_false,
1369: x_data => l_message_list
1370: );
1371: fnd_file.put(fnd_file.output,l_message_list);
1372: fnd_file.new_line (fnd_file.output, 1);
1373: GOTO NEXT_RECORD; --GO to next record
1374: END IF;
1375:
1376: IF l_new_item_rec.eng_item_flag = 'Y' AND

Line 1386: fnd_file.put (fnd_file.output,fnd_message.get);

1382: fnd_message.set_token('LINE',rec.line_no);
1383: fnd_message.set_token('ITEM',rec.item_no);
1384: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1385: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1386: fnd_file.put (fnd_file.output,fnd_message.get);
1387:
1388: fnd_file.put(fnd_file.output,l_message_list);
1389: fnd_file.new_line (fnd_file.output, 1);
1390: --FPBug#4351032 used gme_common_pvt.log_message

Line 1388: fnd_file.put(fnd_file.output,l_message_list);

1384: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1385: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1386: fnd_file.put (fnd_file.output,fnd_message.get);
1387:
1388: fnd_file.put(fnd_file.output,l_message_list);
1389: fnd_file.new_line (fnd_file.output, 1);
1390: --FPBug#4351032 used gme_common_pvt.log_message
1391: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION_ENG'
1392: ,p_token1_name => 'DOC'

Line 1389: fnd_file.new_line (fnd_file.output, 1);

1385: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1386: fnd_file.put (fnd_file.output,fnd_message.get);
1387:
1388: fnd_file.put(fnd_file.output,l_message_list);
1389: fnd_file.new_line (fnd_file.output, 1);
1390: --FPBug#4351032 used gme_common_pvt.log_message
1391: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION_ENG'
1392: ,p_token1_name => 'DOC'
1393: ,P_token1_value => l_doc_str||' '||rec.batch_no

Line 1407: fnd_file.put(fnd_file.output,l_message_list);

1403: gme_common_pvt.count_and_get (x_count => l_message_count,
1404: p_encoded => fnd_api.g_false,
1405: x_data => l_message_list
1406: );
1407: fnd_file.put(fnd_file.output,l_message_list);
1408: fnd_file.new_line (fnd_file.output, 1);
1409: GOTO NEXT_RECORD; --GO to next record
1410: END IF;
1411:

Line 1408: fnd_file.new_line (fnd_file.output, 1);

1404: p_encoded => fnd_api.g_false,
1405: x_data => l_message_list
1406: );
1407: fnd_file.put(fnd_file.output,l_message_list);
1408: fnd_file.new_line (fnd_file.output, 1);
1409: GOTO NEXT_RECORD; --GO to next record
1410: END IF;
1411:
1412: SAVEPOINT create_trans;

Line 1435: fnd_file.put (fnd_file.output,fnd_message.get);

1431: fnd_message.set_token('LINE',rec.line_no);
1432: fnd_message.set_token('ITEM',rec.item_no);
1433: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1434: fnd_message.set_token('MSG',l_message_list);
1435: fnd_file.put (fnd_file.output,fnd_message.get);
1436:
1437: fnd_file.put(fnd_file.output,l_message_list);
1438: fnd_file.new_line (fnd_file.output, 1);
1439: --FPBug#4351032 used gme_common_pvt.log_message

Line 1437: fnd_file.put(fnd_file.output,l_message_list);

1433: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1434: fnd_message.set_token('MSG',l_message_list);
1435: fnd_file.put (fnd_file.output,fnd_message.get);
1436:
1437: fnd_file.put(fnd_file.output,l_message_list);
1438: fnd_file.new_line (fnd_file.output, 1);
1439: --FPBug#4351032 used gme_common_pvt.log_message
1440: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1441: ,p_token1_name => 'DOC'

Line 1438: fnd_file.new_line (fnd_file.output, 1);

1434: fnd_message.set_token('MSG',l_message_list);
1435: fnd_file.put (fnd_file.output,fnd_message.get);
1436:
1437: fnd_file.put(fnd_file.output,l_message_list);
1438: fnd_file.new_line (fnd_file.output, 1);
1439: --FPBug#4351032 used gme_common_pvt.log_message
1440: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1441: ,p_token1_name => 'DOC'
1442: ,P_token1_value => l_doc_str||' '||rec.batch_no

Line 1456: fnd_file.put(fnd_file.output,l_message_list);

1452: gme_common_pvt.count_and_get (x_count => l_message_count,
1453: p_encoded => fnd_api.g_false,
1454: x_data => l_message_list
1455: );
1456: fnd_file.put(fnd_file.output,l_message_list);
1457: fnd_file.new_line (fnd_file.output, 1);
1458: GOTO NEXT_RECORD; --GO to next record
1459: END IF;
1460:

Line 1457: fnd_file.new_line (fnd_file.output, 1);

1453: p_encoded => fnd_api.g_false,
1454: x_data => l_message_list
1455: );
1456: fnd_file.put(fnd_file.output,l_message_list);
1457: fnd_file.new_line (fnd_file.output, 1);
1458: GOTO NEXT_RECORD; --GO to next record
1459: END IF;
1460:
1461: l_return_status := NULL;

Line 1483: fnd_file.put (fnd_file.output,fnd_message.get);

1479: fnd_message.set_token('LINE',rec.line_no);
1480: fnd_message.set_token('ITEM',rec.item_no);
1481: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1482: fnd_message.set_token('MSG',l_message_list);
1483: fnd_file.put (fnd_file.output,fnd_message.get);
1484:
1485: fnd_file.put(fnd_file.output,l_message_list);
1486: fnd_file.new_line (fnd_file.output, 1);
1487: --FPBug#4351032 used gme_common_pvt.log_message

Line 1485: fnd_file.put(fnd_file.output,l_message_list);

1481: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1482: fnd_message.set_token('MSG',l_message_list);
1483: fnd_file.put (fnd_file.output,fnd_message.get);
1484:
1485: fnd_file.put(fnd_file.output,l_message_list);
1486: fnd_file.new_line (fnd_file.output, 1);
1487: --FPBug#4351032 used gme_common_pvt.log_message
1488: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1489: ,p_token1_name => 'DOC'

Line 1486: fnd_file.new_line (fnd_file.output, 1);

1482: fnd_message.set_token('MSG',l_message_list);
1483: fnd_file.put (fnd_file.output,fnd_message.get);
1484:
1485: fnd_file.put(fnd_file.output,l_message_list);
1486: fnd_file.new_line (fnd_file.output, 1);
1487: --FPBug#4351032 used gme_common_pvt.log_message
1488: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1489: ,p_token1_name => 'DOC'
1490: ,P_token1_value => l_doc_str||' '||rec.batch_no

Line 1504: fnd_file.put(fnd_file.output,l_message_list);

1500: gme_common_pvt.count_and_get (x_count => l_message_count,
1501: p_encoded => fnd_api.g_false,
1502: x_data => l_message_list
1503: );
1504: fnd_file.put(fnd_file.output,l_message_list);
1505: fnd_file.new_line (fnd_file.output, 1);
1506: GOTO NEXT_RECORD; --GO to next record
1507: END IF; --IF l_return_status <> fnd_api.g_ret_sts_success THEN
1508: END IF; --IF l_new_item_rec.mtl_transactions_enabled_flag = 'Y' THEN

Line 1505: fnd_file.new_line (fnd_file.output, 1);

1501: p_encoded => fnd_api.g_false,
1502: x_data => l_message_list
1503: );
1504: fnd_file.put(fnd_file.output,l_message_list);
1505: fnd_file.new_line (fnd_file.output, 1);
1506: GOTO NEXT_RECORD; --GO to next record
1507: END IF; --IF l_return_status <> fnd_api.g_ret_sts_success THEN
1508: END IF; --IF l_new_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
1509: END IF; -- l_batch_header_rec.update_inventory_ind = 'Y'

Line 1560: fnd_file.put (fnd_file.output,fnd_message.get);

1556: fnd_message.set_token('LINE',rec.line_no);
1557: fnd_message.set_token('ITEM',rec.item_no);
1558: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1559: fnd_message.set_token('MSG',l_message_list);
1560: fnd_file.put (fnd_file.output,fnd_message.get);
1561:
1562: fnd_file.put(fnd_file.output,l_message_list);
1563: fnd_file.new_line (fnd_file.output, 1);
1564: --FPBug#4351032 used gme_common_pvt.log_message

Line 1562: fnd_file.put(fnd_file.output,l_message_list);

1558: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1559: fnd_message.set_token('MSG',l_message_list);
1560: fnd_file.put (fnd_file.output,fnd_message.get);
1561:
1562: fnd_file.put(fnd_file.output,l_message_list);
1563: fnd_file.new_line (fnd_file.output, 1);
1564: --FPBug#4351032 used gme_common_pvt.log_message
1565: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1566: ,p_token1_name => 'DOC'

Line 1563: fnd_file.new_line (fnd_file.output, 1);

1559: fnd_message.set_token('MSG',l_message_list);
1560: fnd_file.put (fnd_file.output,fnd_message.get);
1561:
1562: fnd_file.put(fnd_file.output,l_message_list);
1563: fnd_file.new_line (fnd_file.output, 1);
1564: --FPBug#4351032 used gme_common_pvt.log_message
1565: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1566: ,p_token1_name => 'DOC'
1567: ,P_token1_value => l_doc_str||' '||rec.batch_no

Line 1581: fnd_file.put(fnd_file.output,l_message_list);

1577: gme_common_pvt.count_and_get (x_count => l_message_count,
1578: p_encoded => fnd_api.g_false,
1579: x_data => l_message_list
1580: );
1581: fnd_file.put(fnd_file.output,l_message_list);
1582: fnd_file.new_line (fnd_file.output, 1);
1583: ROLLBACK TO create_trans;
1584: GOTO NEXT_RECORD; --GO to next record
1585: END IF;

Line 1582: fnd_file.new_line (fnd_file.output, 1);

1578: p_encoded => fnd_api.g_false,
1579: x_data => l_message_list
1580: );
1581: fnd_file.put(fnd_file.output,l_message_list);
1582: fnd_file.new_line (fnd_file.output, 1);
1583: ROLLBACK TO create_trans;
1584: GOTO NEXT_RECORD; --GO to next record
1585: END IF;
1586: l_material_detail_rec.move_order_line_id := l_material_details_tbl_out(1).move_order_line_id;

Line 1608: fnd_file.put (fnd_file.output,fnd_message.get);

1604: fnd_message.set_token('LINE',rec.line_no);
1605: fnd_message.set_token('ITEM',rec.item_no);
1606: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1607: fnd_message.set_token('MSG',l_message_list);
1608: fnd_file.put (fnd_file.output,fnd_message.get);
1609:
1610: fnd_file.put(fnd_file.output,l_message_list);
1611: fnd_file.new_line (fnd_file.output, 1);
1612: --FPBug#4351032 used gme_common_pvt.log_message

Line 1610: fnd_file.put(fnd_file.output,l_message_list);

1606: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1607: fnd_message.set_token('MSG',l_message_list);
1608: fnd_file.put (fnd_file.output,fnd_message.get);
1609:
1610: fnd_file.put(fnd_file.output,l_message_list);
1611: fnd_file.new_line (fnd_file.output, 1);
1612: --FPBug#4351032 used gme_common_pvt.log_message
1613: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1614: ,p_token1_name => 'DOC'

Line 1611: fnd_file.new_line (fnd_file.output, 1);

1607: fnd_message.set_token('MSG',l_message_list);
1608: fnd_file.put (fnd_file.output,fnd_message.get);
1609:
1610: fnd_file.put(fnd_file.output,l_message_list);
1611: fnd_file.new_line (fnd_file.output, 1);
1612: --FPBug#4351032 used gme_common_pvt.log_message
1613: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1614: ,p_token1_name => 'DOC'
1615: ,P_token1_value => l_doc_str||' '||rec.batch_no

Line 1629: fnd_file.put(fnd_file.output,l_message_list);

1625: gme_common_pvt.count_and_get (x_count => l_message_count,
1626: p_encoded => fnd_api.g_false,
1627: x_data => l_message_list
1628: );
1629: fnd_file.put(fnd_file.output,l_message_list);
1630: fnd_file.new_line (fnd_file.output, 1);
1631: ROLLBACK TO create_trans;
1632: GOTO NEXT_RECORD; --GO to next record
1633: END IF; -- IF (l_return = FALSE) THEN

Line 1630: fnd_file.new_line (fnd_file.output, 1);

1626: p_encoded => fnd_api.g_false,
1627: x_data => l_message_list
1628: );
1629: fnd_file.put(fnd_file.output,l_message_list);
1630: fnd_file.new_line (fnd_file.output, 1);
1631: ROLLBACK TO create_trans;
1632: GOTO NEXT_RECORD; --GO to next record
1633: END IF; -- IF (l_return = FALSE) THEN
1634:

Line 1676: fnd_file.put (fnd_file.output,fnd_message.get);

1672: fnd_message.set_token('LINE',rec.line_no);
1673: fnd_message.set_token('ITEM',rec.item_no);
1674: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1675: fnd_message.set_token('MSG',l_message_list);
1676: fnd_file.put (fnd_file.output,fnd_message.get);
1677:
1678: fnd_file.put(fnd_file.output,l_message_list);
1679: fnd_file.new_line (fnd_file.output, 1);
1680: --FPBug#4351032 used gme_common_pvt.log_message

Line 1678: fnd_file.put(fnd_file.output,l_message_list);

1674: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1675: fnd_message.set_token('MSG',l_message_list);
1676: fnd_file.put (fnd_file.output,fnd_message.get);
1677:
1678: fnd_file.put(fnd_file.output,l_message_list);
1679: fnd_file.new_line (fnd_file.output, 1);
1680: --FPBug#4351032 used gme_common_pvt.log_message
1681: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1682: ,p_token1_name => 'DOC'

Line 1679: fnd_file.new_line (fnd_file.output, 1);

1675: fnd_message.set_token('MSG',l_message_list);
1676: fnd_file.put (fnd_file.output,fnd_message.get);
1677:
1678: fnd_file.put(fnd_file.output,l_message_list);
1679: fnd_file.new_line (fnd_file.output, 1);
1680: --FPBug#4351032 used gme_common_pvt.log_message
1681: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1682: ,p_token1_name => 'DOC'
1683: ,P_token1_value => l_doc_str||' '||rec.batch_no

Line 1697: fnd_file.put(fnd_file.output,l_message_list);

1693: gme_common_pvt.count_and_get (x_count => l_message_count,
1694: p_encoded => fnd_api.g_false,
1695: x_data => l_message_list
1696: );
1697: fnd_file.put(fnd_file.output,l_message_list);
1698: fnd_file.new_line (fnd_file.output, 1);
1699: ROLLBACK TO create_trans;
1700: GOTO NEXT_RECORD; --GO to next record
1701: END IF; -- IF l_return_status IN (fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error) THEN

Line 1698: fnd_file.new_line (fnd_file.output, 1);

1694: p_encoded => fnd_api.g_false,
1695: x_data => l_message_list
1696: );
1697: fnd_file.put(fnd_file.output,l_message_list);
1698: fnd_file.new_line (fnd_file.output, 1);
1699: ROLLBACK TO create_trans;
1700: GOTO NEXT_RECORD; --GO to next record
1701: END IF; -- IF l_return_status IN (fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error) THEN
1702:

Line 1736: fnd_file.put (fnd_file.output,fnd_message.get);

1732: fnd_message.set_token('LINE',rec.line_no);
1733: fnd_message.set_token('ITEM',rec.item_no);
1734: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1735: fnd_message.set_token('MSG',l_message_list);
1736: fnd_file.put (fnd_file.output,fnd_message.get);
1737:
1738: fnd_file.put(fnd_file.output,l_message_list);
1739: fnd_file.new_line (fnd_file.output, 1);
1740: --FPBug#4351032 used gme_common_pvt.log_message

Line 1738: fnd_file.put(fnd_file.output,l_message_list);

1734: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1735: fnd_message.set_token('MSG',l_message_list);
1736: fnd_file.put (fnd_file.output,fnd_message.get);
1737:
1738: fnd_file.put(fnd_file.output,l_message_list);
1739: fnd_file.new_line (fnd_file.output, 1);
1740: --FPBug#4351032 used gme_common_pvt.log_message
1741: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1742: ,p_token1_name => 'DOC'

Line 1739: fnd_file.new_line (fnd_file.output, 1);

1735: fnd_message.set_token('MSG',l_message_list);
1736: fnd_file.put (fnd_file.output,fnd_message.get);
1737:
1738: fnd_file.put(fnd_file.output,l_message_list);
1739: fnd_file.new_line (fnd_file.output, 1);
1740: --FPBug#4351032 used gme_common_pvt.log_message
1741: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1742: ,p_token1_name => 'DOC'
1743: ,P_token1_value => l_doc_str||' '||rec.batch_no

Line 1757: fnd_file.put(fnd_file.output,l_message_list);

1753: gme_common_pvt.count_and_get (x_count => l_message_count,
1754: p_encoded => fnd_api.g_false,
1755: x_data => l_message_list
1756: );
1757: fnd_file.put(fnd_file.output,l_message_list);
1758: fnd_file.new_line (fnd_file.output, 1);
1759: ROLLBACK TO create_trans;
1760: GOTO NEXT_RECORD; --GO to next record
1761: END IF;

Line 1758: fnd_file.new_line (fnd_file.output, 1);

1754: p_encoded => fnd_api.g_false,
1755: x_data => l_message_list
1756: );
1757: fnd_file.put(fnd_file.output,l_message_list);
1758: fnd_file.new_line (fnd_file.output, 1);
1759: ROLLBACK TO create_trans;
1760: GOTO NEXT_RECORD; --GO to next record
1761: END IF;
1762:

Line 1796: fnd_file.put (fnd_file.output,fnd_message.get);

1792: fnd_message.set_token('LINE',rec.line_no);
1793: fnd_message.set_token('ITEM',rec.item_no);
1794: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1795: fnd_message.set_token('MSG',l_message_list);
1796: fnd_file.put (fnd_file.output,fnd_message.get);
1797:
1798: fnd_file.put(fnd_file.output,l_message_list);
1799: fnd_file.new_line (fnd_file.output, 1);
1800: --FPBug#4351032 used gme_common_pvt.log_message

Line 1798: fnd_file.put(fnd_file.output,l_message_list);

1794: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1795: fnd_message.set_token('MSG',l_message_list);
1796: fnd_file.put (fnd_file.output,fnd_message.get);
1797:
1798: fnd_file.put(fnd_file.output,l_message_list);
1799: fnd_file.new_line (fnd_file.output, 1);
1800: --FPBug#4351032 used gme_common_pvt.log_message
1801: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1802: ,p_token1_name => 'DOC'

Line 1799: fnd_file.new_line (fnd_file.output, 1);

1795: fnd_message.set_token('MSG',l_message_list);
1796: fnd_file.put (fnd_file.output,fnd_message.get);
1797:
1798: fnd_file.put(fnd_file.output,l_message_list);
1799: fnd_file.new_line (fnd_file.output, 1);
1800: --FPBug#4351032 used gme_common_pvt.log_message
1801: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1802: ,p_token1_name => 'DOC'
1803: ,P_token1_value => l_doc_str||' '||rec.batch_no

Line 1817: fnd_file.put(fnd_file.output,l_message_list);

1813: gme_common_pvt.count_and_get (x_count => l_message_count,
1814: p_encoded => fnd_api.g_false,
1815: x_data => l_message_list
1816: );
1817: fnd_file.put(fnd_file.output,l_message_list);
1818: fnd_file.new_line (fnd_file.output, 1);
1819: ROLLBACK TO create_trans;
1820: GOTO NEXT_RECORD; --GO to next record
1821: END IF;

Line 1818: fnd_file.new_line (fnd_file.output, 1);

1814: p_encoded => fnd_api.g_false,
1815: x_data => l_message_list
1816: );
1817: fnd_file.put(fnd_file.output,l_message_list);
1818: fnd_file.new_line (fnd_file.output, 1);
1819: ROLLBACK TO create_trans;
1820: GOTO NEXT_RECORD; --GO to next record
1821: END IF;
1822: END IF; -- ASQC

Line 1853: fnd_file.put (fnd_file.output,fnd_message.get);

1849: fnd_message.set_token('LINE',rec.line_no);
1850: fnd_message.set_token('ITEM',rec.item_no);
1851: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1852: fnd_message.set_token('MSG',l_message_list);
1853: fnd_file.put (fnd_file.output,fnd_message.get);
1854:
1855: fnd_file.put(fnd_file.output,l_message_list);
1856: fnd_file.new_line (fnd_file.output, 1);
1857: --FPBug#4351032 used gme_common_pvt.log_message

Line 1855: fnd_file.put(fnd_file.output,l_message_list);

1851: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1852: fnd_message.set_token('MSG',l_message_list);
1853: fnd_file.put (fnd_file.output,fnd_message.get);
1854:
1855: fnd_file.put(fnd_file.output,l_message_list);
1856: fnd_file.new_line (fnd_file.output, 1);
1857: --FPBug#4351032 used gme_common_pvt.log_message
1858: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1859: ,p_token1_name => 'DOC'

Line 1856: fnd_file.new_line (fnd_file.output, 1);

1852: fnd_message.set_token('MSG',l_message_list);
1853: fnd_file.put (fnd_file.output,fnd_message.get);
1854:
1855: fnd_file.put(fnd_file.output,l_message_list);
1856: fnd_file.new_line (fnd_file.output, 1);
1857: --FPBug#4351032 used gme_common_pvt.log_message
1858: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1859: ,p_token1_name => 'DOC'
1860: ,P_token1_value => l_doc_str||' '||rec.batch_no

Line 1874: fnd_file.put(fnd_file.output,l_message_list);

1870: gme_common_pvt.count_and_get (x_count => l_message_count,
1871: p_encoded => fnd_api.g_false,
1872: x_data => l_message_list
1873: );
1874: fnd_file.put(fnd_file.output,l_message_list);
1875: fnd_file.new_line (fnd_file.output, 1);
1876: ROLLBACK TO create_trans;
1877: GOTO NEXT_RECORD; --GO to next record
1878: END IF;

Line 1875: fnd_file.new_line (fnd_file.output, 1);

1871: p_encoded => fnd_api.g_false,
1872: x_data => l_message_list
1873: );
1874: fnd_file.put(fnd_file.output,l_message_list);
1875: fnd_file.new_line (fnd_file.output, 1);
1876: ROLLBACK TO create_trans;
1877: GOTO NEXT_RECORD; --GO to next record
1878: END IF;
1879: END IF; /* l_batch_header_rec.automatic_step_calculation = 1 */

Line 1892: fnd_file.put (fnd_file.output,fnd_message.get);

1888: fnd_message.set_token('ITEM',rec.item_no);
1889: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1890: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1891: fnd_message.set_token('NEWQTY',l_formula_tbl (1).qty||' '||l_formula_tbl (1).detail_uom);
1892: fnd_file.put (fnd_file.output,fnd_message.get);
1893:
1894: fnd_file.put(fnd_file.output,l_message_list);
1895: fnd_file.new_line (fnd_file.output, 1);
1896: --FPBug#4351032 used gme_common_pvt.log_message

Line 1894: fnd_file.put(fnd_file.output,l_message_list);

1890: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1891: fnd_message.set_token('NEWQTY',l_formula_tbl (1).qty||' '||l_formula_tbl (1).detail_uom);
1892: fnd_file.put (fnd_file.output,fnd_message.get);
1893:
1894: fnd_file.put(fnd_file.output,l_message_list);
1895: fnd_file.new_line (fnd_file.output, 1);
1896: --FPBug#4351032 used gme_common_pvt.log_message
1897: gme_common_pvt.log_message(p_message_code => 'GME_SUBSTITUTION_SUCCESS'
1898: ,p_token1_name => 'DOC'

Line 1895: fnd_file.new_line (fnd_file.output, 1);

1891: fnd_message.set_token('NEWQTY',l_formula_tbl (1).qty||' '||l_formula_tbl (1).detail_uom);
1892: fnd_file.put (fnd_file.output,fnd_message.get);
1893:
1894: fnd_file.put(fnd_file.output,l_message_list);
1895: fnd_file.new_line (fnd_file.output, 1);
1896: --FPBug#4351032 used gme_common_pvt.log_message
1897: gme_common_pvt.log_message(p_message_code => 'GME_SUBSTITUTION_SUCCESS'
1898: ,p_token1_name => 'DOC'
1899: ,P_token1_value => l_doc_str||' '||rec.batch_no

Line 1915: fnd_file.put(fnd_file.output,l_message_list);

1911: gme_common_pvt.count_and_get (x_count => l_message_count,
1912: p_encoded => fnd_api.g_false,
1913: x_data => l_message_list
1914: );
1915: fnd_file.put(fnd_file.output,l_message_list);
1916: fnd_file.new_line (fnd_file.output, 1);
1917:
1918: <>
1919: NULL;

Line 1916: fnd_file.new_line (fnd_file.output, 1);

1912: p_encoded => fnd_api.g_false,
1913: x_data => l_message_list
1914: );
1915: fnd_file.put(fnd_file.output,l_message_list);
1916: fnd_file.new_line (fnd_file.output, 1);
1917:
1918: <>
1919: NULL;
1920: END LOOP;

Line 1922: fnd_file.new_line (fnd_file.output, 1);

1918: <>
1919: NULL;
1920: END LOOP;
1921:
1922: fnd_file.new_line (fnd_file.output, 1);
1923:
1924: IF l_oneitem_success = TRUE AND l_oneitem_error = TRUE THEN
1925: gme_common_pvt.log_message('GME_ATLEAST_ONE_NOT_SUBSTITUTE');
1926: gme_common_pvt.count_and_get (x_count => l_message_count,

Line 1930: fnd_file.put(fnd_file.output,l_message_list);

1926: gme_common_pvt.count_and_get (x_count => l_message_count,
1927: p_encoded => fnd_api.g_false,
1928: x_data => l_message_list
1929: );
1930: fnd_file.put(fnd_file.output,l_message_list);
1931:
1932: --FPBug#4991508 replaced hard coded output messages
1933: fnd_message.set_name('GME','GME_ATLEAST_ONE_NOT_SUBSTITUTE');
1934: fnd_file.put_line (fnd_file.output, fnd_message.get);

Line 1934: fnd_file.put_line (fnd_file.output, fnd_message.get);

1930: fnd_file.put(fnd_file.output,l_message_list);
1931:
1932: --FPBug#4991508 replaced hard coded output messages
1933: fnd_message.set_name('GME','GME_ATLEAST_ONE_NOT_SUBSTITUTE');
1934: fnd_file.put_line (fnd_file.output, fnd_message.get);
1935:
1936: errbuf := l_message_list;
1937: retcode := 1; --warning
1938: ELSIF l_oneitem_success = FALSE AND l_oneitem_error = TRUE THEN

Line 1941: fnd_file.put_line (fnd_file.output, fnd_message.get);

1937: retcode := 1; --warning
1938: ELSIF l_oneitem_success = FALSE AND l_oneitem_error = TRUE THEN
1939: --FPBug#4991508 replaced hard coded output messages
1940: fnd_message.set_name('GME','GME_NONE_SUBSTITUTED');
1941: fnd_file.put_line (fnd_file.output, fnd_message.get);
1942:
1943: gme_common_pvt.log_message('GME_NONE_SUBSTITUTED');
1944: gme_common_pvt.count_and_get (x_count => l_message_count,
1945: p_encoded => fnd_api.g_false,

Line 1948: fnd_file.put(fnd_file.output,l_message_list);

1944: gme_common_pvt.count_and_get (x_count => l_message_count,
1945: p_encoded => fnd_api.g_false,
1946: x_data => l_message_list
1947: );
1948: fnd_file.put(fnd_file.output,l_message_list);
1949: errbuf := l_message_list;
1950: retcode := 2; --error
1951: ELSE
1952: --FPBug#4991508 replaced hard coded output messages

Line 1954: fnd_file.put_line (fnd_file.output, fnd_message.get);

1950: retcode := 2; --error
1951: ELSE
1952: --FPBug#4991508 replaced hard coded output messages
1953: fnd_message.set_name('GME','GME_SUBSTITUTION_SUCCESSFUL');
1954: fnd_file.put_line (fnd_file.output, fnd_message.get);
1955:
1956: errbuf := 'Substitutions are successful';
1957: gme_common_pvt.log_message('GME_SUBSTITUTION_SUCCESSFUL');
1958: gme_common_pvt.count_and_get (x_count => l_message_count,

Line 1962: fnd_file.put(fnd_file.output,l_message_list);

1958: gme_common_pvt.count_and_get (x_count => l_message_count,
1959: p_encoded => fnd_api.g_false,
1960: x_data => l_message_list
1961: );
1962: fnd_file.put(fnd_file.output,l_message_list);
1963: errbuf := l_message_list;
1964: retcode := 0; --success
1965: END IF;
1966: EXCEPTION

Line 1968: fnd_file.put (fnd_file.LOG, 'Setup Failed for organization ID '||p_org_id);

1964: retcode := 0; --success
1965: END IF;
1966: EXCEPTION
1967: WHEN SETUP_FAILURE THEN
1968: fnd_file.put (fnd_file.LOG, 'Setup Failed for organization ID '||p_org_id);
1969: fnd_file.new_line (fnd_file.LOG, 1);
1970: errbuf := 'Setup Failed for organization ID '||p_org_id;
1971: WHEN OTHERS THEN
1972: fnd_file.put (fnd_file.LOG, SQLERRM);

Line 1969: fnd_file.new_line (fnd_file.LOG, 1);

1965: END IF;
1966: EXCEPTION
1967: WHEN SETUP_FAILURE THEN
1968: fnd_file.put (fnd_file.LOG, 'Setup Failed for organization ID '||p_org_id);
1969: fnd_file.new_line (fnd_file.LOG, 1);
1970: errbuf := 'Setup Failed for organization ID '||p_org_id;
1971: WHEN OTHERS THEN
1972: fnd_file.put (fnd_file.LOG, SQLERRM);
1973: fnd_file.new_line (fnd_file.LOG, 1);

Line 1972: fnd_file.put (fnd_file.LOG, SQLERRM);

1968: fnd_file.put (fnd_file.LOG, 'Setup Failed for organization ID '||p_org_id);
1969: fnd_file.new_line (fnd_file.LOG, 1);
1970: errbuf := 'Setup Failed for organization ID '||p_org_id;
1971: WHEN OTHERS THEN
1972: fnd_file.put (fnd_file.LOG, SQLERRM);
1973: fnd_file.new_line (fnd_file.LOG, 1);
1974: errbuf := SQLERRM;
1975: END substitute_ingredients;
1976:

Line 1973: fnd_file.new_line (fnd_file.LOG, 1);

1969: fnd_file.new_line (fnd_file.LOG, 1);
1970: errbuf := 'Setup Failed for organization ID '||p_org_id;
1971: WHEN OTHERS THEN
1972: fnd_file.put (fnd_file.LOG, SQLERRM);
1973: fnd_file.new_line (fnd_file.LOG, 1);
1974: errbuf := SQLERRM;
1975: END substitute_ingredients;
1976:
1977:

Line 2150: fnd_file.put (fnd_file.LOG, SQLERRM);

2146: WHEN invalid_batch_id THEN
2147: x_return_status := fnd_api.g_ret_sts_error;
2148: WHEN OTHERS THEN
2149: x_return_status := fnd_api.g_ret_sts_unexp_error;
2150: fnd_file.put (fnd_file.LOG, SQLERRM);
2151: fnd_file.new_line (fnd_file.LOG, 1);
2152: END get_total_qty;
2153:
2154: --siva FPBug# 4684029 End

Line 2151: fnd_file.new_line (fnd_file.LOG, 1);

2147: x_return_status := fnd_api.g_ret_sts_error;
2148: WHEN OTHERS THEN
2149: x_return_status := fnd_api.g_ret_sts_unexp_error;
2150: fnd_file.put (fnd_file.LOG, SQLERRM);
2151: fnd_file.new_line (fnd_file.LOG, 1);
2152: END get_total_qty;
2153:
2154: --siva FPBug# 4684029 End
2155: