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 1234: fnd_file.put (fnd_file.output,fnd_message.get );

1230: END IF;
1231:
1232: --FPBug#4991508 hard codes strings are seeded for NLS complaint
1233: fnd_message.set_name('GME','GME_INPUT_PARAM');
1234: fnd_file.put (fnd_file.output,fnd_message.get );
1235: fnd_file.new_line (fnd_file.output, 1);
1236: fnd_message.set_name('GME','GME_ORG_ID');
1237: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);
1238: fnd_file.new_line (fnd_file.output, 1);

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

1231:
1232: --FPBug#4991508 hard codes strings are seeded for NLS complaint
1233: fnd_message.set_name('GME','GME_INPUT_PARAM');
1234: fnd_file.put (fnd_file.output,fnd_message.get );
1235: fnd_file.new_line (fnd_file.output, 1);
1236: fnd_message.set_name('GME','GME_ORG_ID');
1237: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);
1238: fnd_file.new_line (fnd_file.output, 1);
1239: fnd_message.set_name('GME','GME_OLD_ITEM');

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

1233: fnd_message.set_name('GME','GME_INPUT_PARAM');
1234: fnd_file.put (fnd_file.output,fnd_message.get );
1235: fnd_file.new_line (fnd_file.output, 1);
1236: fnd_message.set_name('GME','GME_ORG_ID');
1237: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);
1238: fnd_file.new_line (fnd_file.output, 1);
1239: fnd_message.set_name('GME','GME_OLD_ITEM');
1240: fnd_file.put (fnd_file.output, fnd_message.get|| l_old_item_rec.concatenated_segments);
1241: fnd_file.new_line (fnd_file.output, 1);

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

1234: fnd_file.put (fnd_file.output,fnd_message.get );
1235: fnd_file.new_line (fnd_file.output, 1);
1236: fnd_message.set_name('GME','GME_ORG_ID');
1237: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);
1238: fnd_file.new_line (fnd_file.output, 1);
1239: fnd_message.set_name('GME','GME_OLD_ITEM');
1240: fnd_file.put (fnd_file.output, fnd_message.get|| l_old_item_rec.concatenated_segments);
1241: fnd_file.new_line (fnd_file.output, 1);
1242: l_start_date := TO_DATE (p_start_date, 'YYYY/MM/DD HH24:MI:SS');

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

1236: fnd_message.set_name('GME','GME_ORG_ID');
1237: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);
1238: fnd_file.new_line (fnd_file.output, 1);
1239: fnd_message.set_name('GME','GME_OLD_ITEM');
1240: fnd_file.put (fnd_file.output, fnd_message.get|| l_old_item_rec.concatenated_segments);
1241: fnd_file.new_line (fnd_file.output, 1);
1242: l_start_date := TO_DATE (p_start_date, 'YYYY/MM/DD HH24:MI:SS');
1243: l_end_date := TO_DATE (p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1244: fnd_message.set_name('GME','GME_DATE_RANGE');

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

1237: fnd_file.put (fnd_file.output, fnd_message.get || p_org_id);
1238: fnd_file.new_line (fnd_file.output, 1);
1239: fnd_message.set_name('GME','GME_OLD_ITEM');
1240: fnd_file.put (fnd_file.output, fnd_message.get|| l_old_item_rec.concatenated_segments);
1241: fnd_file.new_line (fnd_file.output, 1);
1242: l_start_date := TO_DATE (p_start_date, 'YYYY/MM/DD HH24:MI:SS');
1243: l_end_date := TO_DATE (p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1244: fnd_message.set_name('GME','GME_DATE_RANGE');
1245: fnd_file.put (fnd_file.output,

Line 1245: fnd_file.put (fnd_file.output,

1241: fnd_file.new_line (fnd_file.output, 1);
1242: l_start_date := TO_DATE (p_start_date, 'YYYY/MM/DD HH24:MI:SS');
1243: l_end_date := TO_DATE (p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1244: fnd_message.set_name('GME','GME_DATE_RANGE');
1245: fnd_file.put (fnd_file.output,
1246: fnd_message.get
1247: || TO_CHAR (l_start_date, 'DD-MON-YYYY HH24:MI:SS')
1248: || ' <-> '
1249: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')

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

1248: || ' <-> '
1249: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')
1250: );
1251: --Bug#4533850
1252: fnd_file.new_line (fnd_file.output, 1);
1253: fnd_message.set_name('GME','GME_FROM_BATCH');
1254: fnd_file.put (fnd_file.output, fnd_message.get|| p_from_batch_no);
1255: fnd_file.new_line (fnd_file.output, 1);
1256: fnd_message.set_name('GME','GME_TO_BATCH');

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

1250: );
1251: --Bug#4533850
1252: fnd_file.new_line (fnd_file.output, 1);
1253: fnd_message.set_name('GME','GME_FROM_BATCH');
1254: fnd_file.put (fnd_file.output, fnd_message.get|| p_from_batch_no);
1255: fnd_file.new_line (fnd_file.output, 1);
1256: fnd_message.set_name('GME','GME_TO_BATCH');
1257: fnd_file.put (fnd_file.output, fnd_message.get|| p_to_batch_no);
1258: fnd_file.new_line (fnd_file.output, 2);

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

1251: --Bug#4533850
1252: fnd_file.new_line (fnd_file.output, 1);
1253: fnd_message.set_name('GME','GME_FROM_BATCH');
1254: fnd_file.put (fnd_file.output, fnd_message.get|| p_from_batch_no);
1255: fnd_file.new_line (fnd_file.output, 1);
1256: fnd_message.set_name('GME','GME_TO_BATCH');
1257: fnd_file.put (fnd_file.output, fnd_message.get|| p_to_batch_no);
1258: fnd_file.new_line (fnd_file.output, 2);
1259:

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

1253: fnd_message.set_name('GME','GME_FROM_BATCH');
1254: fnd_file.put (fnd_file.output, fnd_message.get|| p_from_batch_no);
1255: fnd_file.new_line (fnd_file.output, 1);
1256: fnd_message.set_name('GME','GME_TO_BATCH');
1257: fnd_file.put (fnd_file.output, fnd_message.get|| p_to_batch_no);
1258: fnd_file.new_line (fnd_file.output, 2);
1259:
1260: 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
1261: IF rec.batch_type = 0 THEN

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

1254: fnd_file.put (fnd_file.output, fnd_message.get|| p_from_batch_no);
1255: fnd_file.new_line (fnd_file.output, 1);
1256: fnd_message.set_name('GME','GME_TO_BATCH');
1257: fnd_file.put (fnd_file.output, fnd_message.get|| p_to_batch_no);
1258: fnd_file.new_line (fnd_file.output, 2);
1259:
1260: 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
1261: IF rec.batch_type = 0 THEN
1262: OPEN get_msg('GME_BATCH');

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

1331: fnd_message.set_token('LINE',rec.line_no);
1332: fnd_message.set_token('ITEM',rec.item_no);
1333: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1334: fnd_message.set_token('MSG',l_message_list);
1335: fnd_file.put (fnd_file.output,fnd_message.get);
1336:
1337: fnd_file.new_line (fnd_file.output, 1);
1338: */
1339:

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

1333: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1334: fnd_message.set_token('MSG',l_message_list);
1335: fnd_file.put (fnd_file.output,fnd_message.get);
1336:
1337: fnd_file.new_line (fnd_file.output, 1);
1338: */
1339:
1340:
1341: --FPBug#4351032 used gme_common_pvt.log_message

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

1354: gme_common_pvt.count_and_get (x_count => l_message_count,
1355: p_encoded => fnd_api.g_false,
1356: x_data => l_message_list
1357: );
1358: fnd_file.put(fnd_file.output,l_message_list);
1359: fnd_file.new_line (fnd_file.output, 1);
1360: GOTO NEXT_RECORD; --GO to next record
1361: END IF;
1362:

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

1355: p_encoded => fnd_api.g_false,
1356: x_data => l_message_list
1357: );
1358: fnd_file.put(fnd_file.output,l_message_list);
1359: fnd_file.new_line (fnd_file.output, 1);
1360: GOTO NEXT_RECORD; --GO to next record
1361: END IF;
1362:
1363: -- nsinghi bug#5674398. Moved the code to here.

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

1381: fnd_message.set_token('LINE',rec.line_no);
1382: fnd_message.set_token('ITEM',rec.item_no);
1383: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1384: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1385: fnd_file.put (fnd_file.output,fnd_message.get);
1386:
1387: fnd_file.put(fnd_file.output,l_message_list);
1388: fnd_file.new_line (fnd_file.output, 1);
1389: */

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

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

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

1384: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1385: fnd_file.put (fnd_file.output,fnd_message.get);
1386:
1387: fnd_file.put(fnd_file.output,l_message_list);
1388: fnd_file.new_line (fnd_file.output, 1);
1389: */
1390:
1391: --FPBug#4351032 used gme_common_pvt.log_message
1392: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION_EXEC'

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

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

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

1405: p_encoded => fnd_api.g_false,
1406: x_data => l_message_list
1407: );
1408: fnd_file.put(fnd_file.output,l_message_list);
1409: fnd_file.new_line (fnd_file.output, 1);
1410: GOTO NEXT_RECORD; --GO to next record
1411: END IF;
1412:
1413: IF l_new_item_rec.eng_item_flag = 'Y' AND

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

1420: fnd_message.set_token('LINE',rec.line_no);
1421: fnd_message.set_token('ITEM',rec.item_no);
1422: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1423: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1424: fnd_file.put (fnd_file.output,fnd_message.get);
1425:
1426: fnd_file.put(fnd_file.output,l_message_list);
1427: fnd_file.new_line (fnd_file.output, 1);
1428: */

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

1422: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1423: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1424: fnd_file.put (fnd_file.output,fnd_message.get);
1425:
1426: fnd_file.put(fnd_file.output,l_message_list);
1427: fnd_file.new_line (fnd_file.output, 1);
1428: */
1429:
1430: --FPBug#4351032 used gme_common_pvt.log_message

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

1423: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1424: fnd_file.put (fnd_file.output,fnd_message.get);
1425:
1426: fnd_file.put(fnd_file.output,l_message_list);
1427: fnd_file.new_line (fnd_file.output, 1);
1428: */
1429:
1430: --FPBug#4351032 used gme_common_pvt.log_message
1431: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION_ENG'

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

1443: gme_common_pvt.count_and_get (x_count => l_message_count,
1444: p_encoded => fnd_api.g_false,
1445: x_data => l_message_list
1446: );
1447: fnd_file.put(fnd_file.output,l_message_list);
1448: fnd_file.new_line (fnd_file.output, 1);
1449: GOTO NEXT_RECORD; --GO to next record
1450: END IF;
1451:

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

1444: p_encoded => fnd_api.g_false,
1445: x_data => l_message_list
1446: );
1447: fnd_file.put(fnd_file.output,l_message_list);
1448: fnd_file.new_line (fnd_file.output, 1);
1449: GOTO NEXT_RECORD; --GO to next record
1450: END IF;
1451:
1452: SAVEPOINT create_trans;

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

1472: fnd_message.set_token('LINE',rec.line_no);
1473: fnd_message.set_token('ITEM',rec.item_no);
1474: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1475: fnd_message.set_token('MSG',l_message_list);
1476: fnd_file.put (fnd_file.output,fnd_message.get);
1477:
1478: fnd_file.put(fnd_file.output,l_message_list);
1479: fnd_file.new_line (fnd_file.output, 1);
1480: */

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

1474: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1475: fnd_message.set_token('MSG',l_message_list);
1476: fnd_file.put (fnd_file.output,fnd_message.get);
1477:
1478: fnd_file.put(fnd_file.output,l_message_list);
1479: fnd_file.new_line (fnd_file.output, 1);
1480: */
1481:
1482: --FPBug#4351032 used gme_common_pvt.log_message

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

1475: fnd_message.set_token('MSG',l_message_list);
1476: fnd_file.put (fnd_file.output,fnd_message.get);
1477:
1478: fnd_file.put(fnd_file.output,l_message_list);
1479: fnd_file.new_line (fnd_file.output, 1);
1480: */
1481:
1482: --FPBug#4351032 used gme_common_pvt.log_message
1483: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'

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

1495: gme_common_pvt.count_and_get (x_count => l_message_count,
1496: p_encoded => fnd_api.g_false,
1497: x_data => l_message_list
1498: );
1499: fnd_file.put(fnd_file.output,l_message_list);
1500: fnd_file.new_line (fnd_file.output, 1);
1501: GOTO NEXT_RECORD; --GO to next record
1502: END IF;
1503:

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

1496: p_encoded => fnd_api.g_false,
1497: x_data => l_message_list
1498: );
1499: fnd_file.put(fnd_file.output,l_message_list);
1500: fnd_file.new_line (fnd_file.output, 1);
1501: GOTO NEXT_RECORD; --GO to next record
1502: END IF;
1503:
1504: l_return_status := NULL;

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

1523: fnd_message.set_token('LINE',rec.line_no);
1524: fnd_message.set_token('ITEM',rec.item_no);
1525: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1526: fnd_message.set_token('MSG',l_message_list);
1527: fnd_file.put (fnd_file.output,fnd_message.get);
1528:
1529: fnd_file.put(fnd_file.output,l_message_list);
1530: fnd_file.new_line (fnd_file.output, 1);
1531: */

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

1525: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1526: fnd_message.set_token('MSG',l_message_list);
1527: fnd_file.put (fnd_file.output,fnd_message.get);
1528:
1529: fnd_file.put(fnd_file.output,l_message_list);
1530: fnd_file.new_line (fnd_file.output, 1);
1531: */
1532:
1533: --FPBug#4351032 used gme_common_pvt.log_message

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

1526: fnd_message.set_token('MSG',l_message_list);
1527: fnd_file.put (fnd_file.output,fnd_message.get);
1528:
1529: fnd_file.put(fnd_file.output,l_message_list);
1530: fnd_file.new_line (fnd_file.output, 1);
1531: */
1532:
1533: --FPBug#4351032 used gme_common_pvt.log_message
1534: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'

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

1546: gme_common_pvt.count_and_get (x_count => l_message_count,
1547: p_encoded => fnd_api.g_false,
1548: x_data => l_message_list
1549: );
1550: fnd_file.put(fnd_file.output,l_message_list);
1551: fnd_file.new_line (fnd_file.output, 1);
1552: GOTO NEXT_RECORD; --GO to next record
1553: END IF; --IF l_return_status <> fnd_api.g_ret_sts_success THEN
1554: END IF; --IF l_new_item_rec.mtl_transactions_enabled_flag = 'Y' THEN

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

1547: p_encoded => fnd_api.g_false,
1548: x_data => l_message_list
1549: );
1550: fnd_file.put(fnd_file.output,l_message_list);
1551: fnd_file.new_line (fnd_file.output, 1);
1552: GOTO NEXT_RECORD; --GO to next record
1553: END IF; --IF l_return_status <> fnd_api.g_ret_sts_success THEN
1554: END IF; --IF l_new_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
1555: END IF; -- l_batch_header_rec.update_inventory_ind = 'Y'

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

1603: fnd_message.set_token('LINE',rec.line_no);
1604: fnd_message.set_token('ITEM',rec.item_no);
1605: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1606: fnd_message.set_token('MSG',l_message_list);
1607: fnd_file.put (fnd_file.output,fnd_message.get);
1608:
1609: fnd_file.put(fnd_file.output,l_message_list);
1610: fnd_file.new_line (fnd_file.output, 1);
1611: */

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

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

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

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

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

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

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

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

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

1654: fnd_message.set_token('LINE',rec.line_no);
1655: fnd_message.set_token('ITEM',rec.item_no);
1656: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1657: fnd_message.set_token('MSG',l_message_list);
1658: fnd_file.put (fnd_file.output,fnd_message.get);
1659:
1660: fnd_file.put(fnd_file.output,l_message_list);
1661: fnd_file.new_line (fnd_file.output, 1);
1662: */

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

1656: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1657: fnd_message.set_token('MSG',l_message_list);
1658: fnd_file.put (fnd_file.output,fnd_message.get);
1659:
1660: fnd_file.put(fnd_file.output,l_message_list);
1661: fnd_file.new_line (fnd_file.output, 1);
1662: */
1663:
1664: --FPBug#4351032 used gme_common_pvt.log_message

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

1657: fnd_message.set_token('MSG',l_message_list);
1658: fnd_file.put (fnd_file.output,fnd_message.get);
1659:
1660: fnd_file.put(fnd_file.output,l_message_list);
1661: fnd_file.new_line (fnd_file.output, 1);
1662: */
1663:
1664: --FPBug#4351032 used gme_common_pvt.log_message
1665: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'

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

1677: gme_common_pvt.count_and_get (x_count => l_message_count,
1678: p_encoded => fnd_api.g_false,
1679: x_data => l_message_list
1680: );
1681: fnd_file.put(fnd_file.output,l_message_list);
1682: fnd_file.new_line (fnd_file.output, 1);
1683: ROLLBACK TO create_trans;
1684: GOTO NEXT_RECORD; --GO to next record
1685: END IF; -- IF (l_return = FALSE) THEN

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

1678: p_encoded => fnd_api.g_false,
1679: x_data => l_message_list
1680: );
1681: fnd_file.put(fnd_file.output,l_message_list);
1682: fnd_file.new_line (fnd_file.output, 1);
1683: ROLLBACK TO create_trans;
1684: GOTO NEXT_RECORD; --GO to next record
1685: END IF; -- IF (l_return = FALSE) THEN
1686:

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

1725: fnd_message.set_token('LINE',rec.line_no);
1726: fnd_message.set_token('ITEM',rec.item_no);
1727: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1728: fnd_message.set_token('MSG',l_message_list);
1729: fnd_file.put (fnd_file.output,fnd_message.get);
1730:
1731: fnd_file.put(fnd_file.output,l_message_list);
1732: fnd_file.new_line (fnd_file.output, 1);
1733: --FPBug#4351032 used gme_common_pvt.log_message

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

1727: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1728: fnd_message.set_token('MSG',l_message_list);
1729: fnd_file.put (fnd_file.output,fnd_message.get);
1730:
1731: fnd_file.put(fnd_file.output,l_message_list);
1732: fnd_file.new_line (fnd_file.output, 1);
1733: --FPBug#4351032 used gme_common_pvt.log_message
1734: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1735: ,p_token1_name => 'DOC'

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

1728: fnd_message.set_token('MSG',l_message_list);
1729: fnd_file.put (fnd_file.output,fnd_message.get);
1730:
1731: fnd_file.put(fnd_file.output,l_message_list);
1732: fnd_file.new_line (fnd_file.output, 1);
1733: --FPBug#4351032 used gme_common_pvt.log_message
1734: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'
1735: ,p_token1_name => 'DOC'
1736: ,P_token1_value => l_doc_str||' '||rec.batch_no

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

1746: gme_common_pvt.count_and_get (x_count => l_message_count,
1747: p_encoded => fnd_api.g_false,
1748: x_data => l_message_list
1749: );
1750: fnd_file.put(fnd_file.output,l_message_list);
1751: fnd_file.new_line (fnd_file.output, 1);
1752: ROLLBACK TO create_trans;
1753: GOTO NEXT_RECORD; --GO to next record
1754: END IF; -- IF l_return_status IN (fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error) THEN

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

1747: p_encoded => fnd_api.g_false,
1748: x_data => l_message_list
1749: );
1750: fnd_file.put(fnd_file.output,l_message_list);
1751: fnd_file.new_line (fnd_file.output, 1);
1752: ROLLBACK TO create_trans;
1753: GOTO NEXT_RECORD; --GO to next record
1754: END IF; -- IF l_return_status IN (fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error) THEN
1755:

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

1788: fnd_message.set_token('LINE',rec.line_no);
1789: fnd_message.set_token('ITEM',rec.item_no);
1790: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1791: fnd_message.set_token('MSG',l_message_list);
1792: fnd_file.put (fnd_file.output,fnd_message.get);
1793:
1794: fnd_file.put(fnd_file.output,l_message_list);
1795: fnd_file.new_line (fnd_file.output, 1);
1796: */

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

1790: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1791: fnd_message.set_token('MSG',l_message_list);
1792: fnd_file.put (fnd_file.output,fnd_message.get);
1793:
1794: fnd_file.put(fnd_file.output,l_message_list);
1795: fnd_file.new_line (fnd_file.output, 1);
1796: */
1797:
1798: --FPBug#4351032 used gme_common_pvt.log_message

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

1791: fnd_message.set_token('MSG',l_message_list);
1792: fnd_file.put (fnd_file.output,fnd_message.get);
1793:
1794: fnd_file.put(fnd_file.output,l_message_list);
1795: fnd_file.new_line (fnd_file.output, 1);
1796: */
1797:
1798: --FPBug#4351032 used gme_common_pvt.log_message
1799: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'

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

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

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

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

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

1851: fnd_message.set_token('LINE',rec.line_no);
1852: fnd_message.set_token('ITEM',rec.item_no);
1853: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1854: fnd_message.set_token('MSG',l_message_list);
1855: fnd_file.put (fnd_file.output,fnd_message.get);
1856:
1857: fnd_file.put(fnd_file.output,l_message_list);
1858: fnd_file.new_line (fnd_file.output, 1);
1859: */

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

1853: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1854: fnd_message.set_token('MSG',l_message_list);
1855: fnd_file.put (fnd_file.output,fnd_message.get);
1856:
1857: fnd_file.put(fnd_file.output,l_message_list);
1858: fnd_file.new_line (fnd_file.output, 1);
1859: */
1860:
1861: --FPBug#4351032 used gme_common_pvt.log_message

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

1854: fnd_message.set_token('MSG',l_message_list);
1855: fnd_file.put (fnd_file.output,fnd_message.get);
1856:
1857: fnd_file.put(fnd_file.output,l_message_list);
1858: fnd_file.new_line (fnd_file.output, 1);
1859: */
1860:
1861: --FPBug#4351032 used gme_common_pvt.log_message
1862: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'

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

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

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

1875: p_encoded => fnd_api.g_false,
1876: x_data => l_message_list
1877: );
1878: fnd_file.put(fnd_file.output,l_message_list);
1879: fnd_file.new_line (fnd_file.output, 1);
1880: ROLLBACK TO create_trans;
1881: GOTO NEXT_RECORD; --GO to next record
1882: END IF;
1883: END IF; -- ASQC

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

1911: fnd_message.set_token('LINE',rec.line_no);
1912: fnd_message.set_token('ITEM',rec.item_no);
1913: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1914: fnd_message.set_token('MSG',l_message_list);
1915: fnd_file.put (fnd_file.output,fnd_message.get);
1916:
1917: fnd_file.put(fnd_file.output,l_message_list);
1918: fnd_file.new_line (fnd_file.output, 1);
1919: */

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

1913: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1914: fnd_message.set_token('MSG',l_message_list);
1915: fnd_file.put (fnd_file.output,fnd_message.get);
1916:
1917: fnd_file.put(fnd_file.output,l_message_list);
1918: fnd_file.new_line (fnd_file.output, 1);
1919: */
1920:
1921: --FPBug#4351032 used gme_common_pvt.log_message

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

1914: fnd_message.set_token('MSG',l_message_list);
1915: fnd_file.put (fnd_file.output,fnd_message.get);
1916:
1917: fnd_file.put(fnd_file.output,l_message_list);
1918: fnd_file.new_line (fnd_file.output, 1);
1919: */
1920:
1921: --FPBug#4351032 used gme_common_pvt.log_message
1922: gme_common_pvt.log_message(p_message_code => 'GME_NO_SUBSTITUTION'

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

1934: gme_common_pvt.count_and_get (x_count => l_message_count,
1935: p_encoded => fnd_api.g_false,
1936: x_data => l_message_list
1937: );
1938: fnd_file.put(fnd_file.output,l_message_list);
1939: fnd_file.new_line (fnd_file.output, 1);
1940: ROLLBACK TO create_trans;
1941: GOTO NEXT_RECORD; --GO to next record
1942: END IF;

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

1935: p_encoded => fnd_api.g_false,
1936: x_data => l_message_list
1937: );
1938: fnd_file.put(fnd_file.output,l_message_list);
1939: fnd_file.new_line (fnd_file.output, 1);
1940: ROLLBACK TO create_trans;
1941: GOTO NEXT_RECORD; --GO to next record
1942: END IF;
1943: END IF; /* l_batch_header_rec.automatic_step_calculation = 1 */

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

1953: fnd_message.set_token('ITEM',rec.item_no);
1954: fnd_message.set_token('PLANQTY',rec.plan_qty||' '||rec.dtl_um);
1955: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1956: fnd_message.set_token('NEWQTY',l_formula_tbl (1).qty||' '||l_formula_tbl (1).detail_uom);
1957: fnd_file.put (fnd_file.output,fnd_message.get);
1958:
1959: fnd_file.put(fnd_file.output,l_message_list);
1960: fnd_file.new_line (fnd_file.output, 1);
1961: */

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

1955: fnd_message.set_token('NEWITEM',l_new_item_rec.concatenated_segments);
1956: fnd_message.set_token('NEWQTY',l_formula_tbl (1).qty||' '||l_formula_tbl (1).detail_uom);
1957: fnd_file.put (fnd_file.output,fnd_message.get);
1958:
1959: fnd_file.put(fnd_file.output,l_message_list);
1960: fnd_file.new_line (fnd_file.output, 1);
1961: */
1962:
1963: --FPBug#4351032 used gme_common_pvt.log_message

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

1956: fnd_message.set_token('NEWQTY',l_formula_tbl (1).qty||' '||l_formula_tbl (1).detail_uom);
1957: fnd_file.put (fnd_file.output,fnd_message.get);
1958:
1959: fnd_file.put(fnd_file.output,l_message_list);
1960: fnd_file.new_line (fnd_file.output, 1);
1961: */
1962:
1963: --FPBug#4351032 used gme_common_pvt.log_message
1964: gme_common_pvt.log_message(p_message_code => 'GME_SUBSTITUTION_SUCCESS'

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

1978: gme_common_pvt.count_and_get (x_count => l_message_count,
1979: p_encoded => fnd_api.g_false,
1980: x_data => l_message_list
1981: );
1982: fnd_file.put(fnd_file.output,l_message_list);
1983: fnd_file.new_line (fnd_file.output, 1);
1984:
1985: <>
1986: NULL;

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

1979: p_encoded => fnd_api.g_false,
1980: x_data => l_message_list
1981: );
1982: fnd_file.put(fnd_file.output,l_message_list);
1983: fnd_file.new_line (fnd_file.output, 1);
1984:
1985: <>
1986: NULL;
1987: END LOOP;

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

1985: <>
1986: NULL;
1987: END LOOP;
1988:
1989: fnd_file.new_line (fnd_file.output, 1);
1990:
1991: IF l_oneitem_success = TRUE AND l_oneitem_error = TRUE THEN
1992: gme_common_pvt.log_message('GME_ATLEAST_ONE_NOT_SUBSTITUTE');
1993: gme_common_pvt.count_and_get (x_count => l_message_count,

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

1993: gme_common_pvt.count_and_get (x_count => l_message_count,
1994: p_encoded => fnd_api.g_false,
1995: x_data => l_message_list
1996: );
1997: fnd_file.put(fnd_file.output,l_message_list);
1998:
1999: --FPBug#4991508 replaced hard coded output messages
2000: /*
2001: fnd_message.set_name('GME','GME_ATLEAST_ONE_NOT_SUBSTITUTE');

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

1998:
1999: --FPBug#4991508 replaced hard coded output messages
2000: /*
2001: fnd_message.set_name('GME','GME_ATLEAST_ONE_NOT_SUBSTITUTE');
2002: fnd_file.put_line (fnd_file.output, fnd_message.get);
2003: */
2004:
2005: errbuf := l_message_list;
2006: retcode := 1; --warning

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

2007: ELSIF l_oneitem_success = FALSE AND l_oneitem_error = TRUE THEN
2008: --FPBug#4991508 replaced hard coded output messages
2009: /*
2010: fnd_message.set_name('GME','GME_NONE_SUBSTITUTED');
2011: fnd_file.put_line (fnd_file.output, fnd_message.get);
2012: */
2013:
2014: gme_common_pvt.log_message('GME_NONE_SUBSTITUTED');
2015: gme_common_pvt.count_and_get (x_count => l_message_count,

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

2015: gme_common_pvt.count_and_get (x_count => l_message_count,
2016: p_encoded => fnd_api.g_false,
2017: x_data => l_message_list
2018: );
2019: fnd_file.put(fnd_file.output,l_message_list);
2020: errbuf := l_message_list;
2021: retcode := 2; --error
2022: ELSE
2023: --FPBug#4991508 replaced hard coded output messages

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

2022: ELSE
2023: --FPBug#4991508 replaced hard coded output messages
2024: /*
2025: fnd_message.set_name('GME','GME_SUBSTITUTION_SUCCESSFUL');
2026: fnd_file.put_line (fnd_file.output, fnd_message.get);
2027: */
2028:
2029: errbuf := 'Substitutions are successful';
2030: gme_common_pvt.log_message('GME_SUBSTITUTION_SUCCESSFUL');

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

2031: gme_common_pvt.count_and_get (x_count => l_message_count,
2032: p_encoded => fnd_api.g_false,
2033: x_data => l_message_list
2034: );
2035: fnd_file.put(fnd_file.output,l_message_list);
2036: errbuf := l_message_list;
2037: retcode := 0; --success
2038: END IF;
2039: EXCEPTION

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

2037: retcode := 0; --success
2038: END IF;
2039: EXCEPTION
2040: WHEN SETUP_FAILURE THEN
2041: fnd_file.put (fnd_file.LOG, 'Setup Failed for organization ID '||p_org_id);
2042: fnd_file.new_line (fnd_file.LOG, 1);
2043: errbuf := 'Setup Failed for organization ID '||p_org_id;
2044: WHEN OTHERS THEN
2045: fnd_file.put (fnd_file.LOG, SQLERRM);

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

2038: END IF;
2039: EXCEPTION
2040: WHEN SETUP_FAILURE THEN
2041: fnd_file.put (fnd_file.LOG, 'Setup Failed for organization ID '||p_org_id);
2042: fnd_file.new_line (fnd_file.LOG, 1);
2043: errbuf := 'Setup Failed for organization ID '||p_org_id;
2044: WHEN OTHERS THEN
2045: fnd_file.put (fnd_file.LOG, SQLERRM);
2046: fnd_file.new_line (fnd_file.LOG, 1);

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

2041: fnd_file.put (fnd_file.LOG, 'Setup Failed for organization ID '||p_org_id);
2042: fnd_file.new_line (fnd_file.LOG, 1);
2043: errbuf := 'Setup Failed for organization ID '||p_org_id;
2044: WHEN OTHERS THEN
2045: fnd_file.put (fnd_file.LOG, SQLERRM);
2046: fnd_file.new_line (fnd_file.LOG, 1);
2047: errbuf := SQLERRM;
2048: END substitute_ingredients;
2049:

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

2042: fnd_file.new_line (fnd_file.LOG, 1);
2043: errbuf := 'Setup Failed for organization ID '||p_org_id;
2044: WHEN OTHERS THEN
2045: fnd_file.put (fnd_file.LOG, SQLERRM);
2046: fnd_file.new_line (fnd_file.LOG, 1);
2047: errbuf := SQLERRM;
2048: END substitute_ingredients;
2049:
2050:

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

2231: WHEN invalid_batch_id THEN
2232: x_return_status := fnd_api.g_ret_sts_error;
2233: WHEN OTHERS THEN
2234: x_return_status := fnd_api.g_ret_sts_unexp_error;
2235: fnd_file.put (fnd_file.LOG, SQLERRM);
2236: fnd_file.new_line (fnd_file.LOG, 1);
2237: END get_total_qty;
2238:
2239: --siva FPBug# 4684029 End

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

2232: x_return_status := fnd_api.g_ret_sts_error;
2233: WHEN OTHERS THEN
2234: x_return_status := fnd_api.g_ret_sts_unexp_error;
2235: fnd_file.put (fnd_file.LOG, SQLERRM);
2236: fnd_file.new_line (fnd_file.LOG, 1);
2237: END get_total_qty;
2238:
2239: --siva FPBug# 4684029 End
2240: