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

Line 173: --fnd_file.put_line(fnd_file.log, 'line # : ' || to_char(l_line_num));

169: END IF;
170:
171: l_line_num := l_line_num + 1;
172:
173: --fnd_file.put_line(fnd_file.log, 'line # : ' || to_char(l_line_num));
174:
175: IF rec_line.amount >= 0 THEN
176: l_cr_dr_indicator := 'D';
177: ELSE

Line 265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error writing detail for PO #: ' || l_po_number || '. ' ||

261: WHEN NO_DATA_FOUND THEN
262: NULL;
263:
264: WHEN OTHERS THEN
265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error writing detail for PO #: ' || l_po_number || '. ' ||
266: SUBSTR(SQLERRM,1,300));
267:
268: END;
269:

Line 462: --fnd_file.put_line(fnd_file.log,'status: ' || l_order_status);

458: l_approved_date IS NULL THEN
459: raise e_do_not_send_po;
460: END IF;
461:
462: --fnd_file.put_line(fnd_file.log,'status: ' || l_order_status);
463:
464: --Determine the total number of distribution lines for the PO
465: SELECT count(*)
466: INTO l_total_distr_records

Line 625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error writing header for PO #: ' || l_po_number || '. ' ||

621: WHEN NO_DATA_FOUND THEN
622: NULL;
623:
624: WHEN OTHERS THEN
625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error writing header for PO #: ' || l_po_number || '. ' ||
626: SUBSTR(SQLERRM,1,300));
627:
628: END; --block
629:

Line 798: -- fnd_file.put_line(fnd_file.log,'Sum of all_PO amounts: ' || to_char(l_total_po_amount));

794: AND NVL(cancel_flag, 'N') = 'N'
795: AND nvl(error_flag, 'N') = 'N'
796: AND concurrent_request_id = g_conc_req_id;
797:
798: -- fnd_file.put_line(fnd_file.log,'Sum of all_PO amounts: ' || to_char(l_total_po_amount));
799: -- fnd_file.put_line(fnd_file.log,'Total header lines retrieved: ' || to_char(l_total_header_records));
800: -- fnd_file.put_line(fnd_file.log,'Total detail lines retrieved: ' || to_char(l_total_detail_records));
801:
802: IF l_total_po_amount >= 0 THEN

Line 799: -- fnd_file.put_line(fnd_file.log,'Total header lines retrieved: ' || to_char(l_total_header_records));

795: AND nvl(error_flag, 'N') = 'N'
796: AND concurrent_request_id = g_conc_req_id;
797:
798: -- fnd_file.put_line(fnd_file.log,'Sum of all_PO amounts: ' || to_char(l_total_po_amount));
799: -- fnd_file.put_line(fnd_file.log,'Total header lines retrieved: ' || to_char(l_total_header_records));
800: -- fnd_file.put_line(fnd_file.log,'Total detail lines retrieved: ' || to_char(l_total_detail_records));
801:
802: IF l_total_po_amount >= 0 THEN
803: l_cr_dr_indicator := 'D';

Line 800: -- fnd_file.put_line(fnd_file.log,'Total detail lines retrieved: ' || to_char(l_total_detail_records));

796: AND concurrent_request_id = g_conc_req_id;
797:
798: -- fnd_file.put_line(fnd_file.log,'Sum of all_PO amounts: ' || to_char(l_total_po_amount));
799: -- fnd_file.put_line(fnd_file.log,'Total header lines retrieved: ' || to_char(l_total_header_records));
800: -- fnd_file.put_line(fnd_file.log,'Total detail lines retrieved: ' || to_char(l_total_detail_records));
801:
802: IF l_total_po_amount >= 0 THEN
803: l_cr_dr_indicator := 'D';
804: ELSE

Line 1609: -- fnd_file.put_line(fnd_file.log, '# fetched : ' || to_char(cur_po_records%rowcount));

1605: l_hold_flag,
1606: l_line_cancel_flag,
1607: l_shipment_cancel_flag;
1608:
1609: -- fnd_file.put_line(fnd_file.log, '# fetched : ' || to_char(cur_po_records%rowcount));
1610:
1611: l_progress := '010';
1612:
1613: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1728: -- fnd_file.put_line(fnd_file.log, '# canceled fetched : ' || to_char(cur_canceled_POs%rowcount));

1724: l_contr_status,
1725: l_cancel_flag,
1726: l_hold_flag;
1727:
1728: -- fnd_file.put_line(fnd_file.log, '# canceled fetched : ' || to_char(cur_canceled_POs%rowcount));
1729:
1730: l_progress := '030';
1731:
1732: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1871: -- fnd_file.put_line(fnd_file.log, 'reformatted from date/time: ' || to_char(g_from_date_time,'DD-MON-YYYY HH24:MI:SS'));

1867: ' :: i_output_filename = ' || i_output_filename;
1868: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', l_log_msg);
1869: END IF;
1870:
1871: -- fnd_file.put_line(fnd_file.log, 'reformatted from date/time: ' || to_char(g_from_date_time,'DD-MON-YYYY HH24:MI:SS'));
1872: -- fnd_file.put_line(fnd_file.log, 'reformatted to date/time: ' || to_char(g_to_date_time,'DD-MON-YYYY HH24:MI:SS'));
1873:
1874: mo_global.set_policy_context('S', g_org_id);
1875:

Line 1872: -- fnd_file.put_line(fnd_file.log, 'reformatted to date/time: ' || to_char(g_to_date_time,'DD-MON-YYYY HH24:MI:SS'));

1868: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', l_log_msg);
1869: END IF;
1870:
1871: -- fnd_file.put_line(fnd_file.log, 'reformatted from date/time: ' || to_char(g_from_date_time,'DD-MON-YYYY HH24:MI:SS'));
1872: -- fnd_file.put_line(fnd_file.log, 'reformatted to date/time: ' || to_char(g_to_date_time,'DD-MON-YYYY HH24:MI:SS'));
1873:
1874: mo_global.set_policy_context('S', g_org_id);
1875:
1876: l_progress := '200';

Line 1990: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Output file has been created successfully.');

1986: l_dev_phase, --dev_phase out
1987: l_message --message out
1988: );
1989:
1990: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Output file has been created successfully.');
1991:
1992: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1993: l_log_msg := ' g_po_num_err = ' || g_po_num_err ||
1994: ' :: g_card_num_err = ' || g_card_num_err ||

Line 2003: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET_STRING('ICX','ICX_POR_HIST_FEED_PO_NUM_LONG'));

1999: l_progress := '1200';
2000:
2001: IF g_po_num_err IS NOT NULL THEN
2002: --Write to Conc Mgr log file
2003: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET_STRING('ICX','ICX_POR_HIST_FEED_PO_NUM_LONG'));
2004: FND_FILE.PUT_LINE (FND_FILE.LOG, g_po_num_err);
2005: ERRBUF := NULL; --appears to get truncated; might not be long enough for custom error to be assigned to it
2006: RETCODE := '1'; --forces warning status
2007: l_result :=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', FND_MESSAGE.GET_STRING('ICX','ICX_POR_HIST_FEED_COMP_TEXT')); --overwrite conc mgr status

Line 2004: FND_FILE.PUT_LINE (FND_FILE.LOG, g_po_num_err);

2000:
2001: IF g_po_num_err IS NOT NULL THEN
2002: --Write to Conc Mgr log file
2003: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET_STRING('ICX','ICX_POR_HIST_FEED_PO_NUM_LONG'));
2004: FND_FILE.PUT_LINE (FND_FILE.LOG, g_po_num_err);
2005: ERRBUF := NULL; --appears to get truncated; might not be long enough for custom error to be assigned to it
2006: RETCODE := '1'; --forces warning status
2007: l_result :=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', FND_MESSAGE.GET_STRING('ICX','ICX_POR_HIST_FEED_COMP_TEXT')); --overwrite conc mgr status
2008: END IF;

Line 2011: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET_STRING('ICX','ICX_POR_HIST_FEED_CARDNO_LONG'));

2007: l_result :=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', FND_MESSAGE.GET_STRING('ICX','ICX_POR_HIST_FEED_COMP_TEXT')); --overwrite conc mgr status
2008: END IF;
2009:
2010: IF g_card_num_err IS NOT NULL THEN
2011: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET_STRING('ICX','ICX_POR_HIST_FEED_CARDNO_LONG'));
2012: FND_FILE.PUT_LINE (FND_FILE.LOG, g_card_num_err);
2013: ERRBUF := NULL; --appears to get truncated; might not be long enough...
2014: RETCODE := '1'; --forces warning status
2015: l_result := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', FND_MESSAGE.GET_STRING('ICX','ICX_POR_HIST_FEED_COMP_TEXT')); --overwrite conc mgr status

Line 2012: FND_FILE.PUT_LINE (FND_FILE.LOG, g_card_num_err);

2008: END IF;
2009:
2010: IF g_card_num_err IS NOT NULL THEN
2011: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET_STRING('ICX','ICX_POR_HIST_FEED_CARDNO_LONG'));
2012: FND_FILE.PUT_LINE (FND_FILE.LOG, g_card_num_err);
2013: ERRBUF := NULL; --appears to get truncated; might not be long enough...
2014: RETCODE := '1'; --forces warning status
2015: l_result := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', FND_MESSAGE.GET_STRING('ICX','ICX_POR_HIST_FEED_COMP_TEXT')); --overwrite conc mgr status
2016: END IF;