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

Line 948: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)

944: || TO_CHAR (l_chunk_size)
945: );
946: END IF;
947:
948: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
949: || ' > Chunk Size Profile Value is '
950: || TO_CHAR (l_chunk_size));
951:
952: IF ((l_chunk_size = 0) OR (l_chunk_size IS NULL))

Line 6844: fnd_file.put_line (fnd_file.LOG, l_message_text);

6840: IF (chk_a_and_r_overlap%FOUND)
6841: THEN
6842: fnd_message.set_name ('HXC', 'HXC_RET_ARCHIVE_DATA');
6843: l_message_text := SUBSTR (fnd_message.get (), 1, 2000);
6844: fnd_file.put_line (fnd_file.LOG, l_message_text);
6845: END IF;
6846:
6847: CLOSE chk_a_and_r_overlap;
6848:

Line 6948: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)

6944: hr_utility.TRACE ('Conc Req ID is ' || TO_CHAR (g_conc_request_id)
6945: );
6946: END IF;
6947:
6948: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
6949: || ' > maintain_globals > Conc Req ID is ' || TO_CHAR (g_conc_request_id));
6950:
6951: g_params.p_process := NULL;
6952: g_params.p_transaction_code := NULL;

Line 7093: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)

7089: hxc_generic_retrieval_pkg.g_no_timecards := TRUE;
7090: hxc_generic_retrieval_pkg.g_overall_no_timecards := TRUE;
7091: END IF;
7092:
7093: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
7094: || ' ******** OTL Processing Starts ******');
7095:
7096: maintain_globals;
7097:

Line 7658: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)

7654: -- ( hxc_generic_retrieval_pkg.G_IN_LOOP AND hxc_generic_retrieval_pkg.G_LAST_CHUNK );
7655:
7656: -- before we pass control to the recipient application check to make sure the conc
7657: -- process has not been terminated
7658: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
7659: || ' > SKIPPED Blocks COUNT > ' || hxc_generic_retrieval_pkg.g_detail_skipped.COUNT);
7660:
7661: IF(hxc_generic_retrieval_pkg.g_detail_skipped.COUNT > 0) THEN
7662:

Line 7663: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)

7659: || ' > SKIPPED Blocks COUNT > ' || hxc_generic_retrieval_pkg.g_detail_skipped.COUNT);
7660:
7661: IF(hxc_generic_retrieval_pkg.g_detail_skipped.COUNT > 0) THEN
7662:
7663: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
7664: || ' > ******* Printing SKIPPED Detail Blocks *******');
7665:
7666: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7667:

Line 7666: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

7662:
7663: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
7664: || ' > ******* Printing SKIPPED Detail Blocks *******');
7665:
7666: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7667:
7668: fnd_file.put_line(fnd_file.log, ' RESOURCE ID '
7669: || ' TIMECARD '
7670: || ' DETAIL '

Line 7668: fnd_file.put_line(fnd_file.log, ' RESOURCE ID '

7664: || ' > ******* Printing SKIPPED Detail Blocks *******');
7665:
7666: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7667:
7668: fnd_file.put_line(fnd_file.log, ' RESOURCE ID '
7669: || ' TIMECARD '
7670: || ' DETAIL '
7671: || ' REMARKS ');
7672: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 7672: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

7668: fnd_file.put_line(fnd_file.log, ' RESOURCE ID '
7669: || ' TIMECARD '
7670: || ' DETAIL '
7671: || ' REMARKS ');
7672: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7673:
7674: FOR i IN hxc_generic_retrieval_pkg.g_detail_skipped.FIRST .. hxc_generic_retrieval_pkg.g_detail_skipped.LAST
7675: LOOP
7676:

Line 7677: fnd_file.put_line(fnd_file.log, ' '

7673:
7674: FOR i IN hxc_generic_retrieval_pkg.g_detail_skipped.FIRST .. hxc_generic_retrieval_pkg.g_detail_skipped.LAST
7675: LOOP
7676:
7677: fnd_file.put_line(fnd_file.log, ' '
7678: ||hxc_generic_retrieval_pkg.g_detail_skipped(i).resource_id
7679: || ' '
7680: || hxc_generic_retrieval_pkg.g_detail_skipped(i).timecard_id
7681: || ' ['

Line 7691: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

7687: || '] '
7688: || hxc_generic_retrieval_pkg.g_detail_skipped(i).description);
7689:
7690: END LOOP;
7691: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7692: END IF;
7693:
7694: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
7695: || ' > Blocks COUNT being passed to RECIPIENT APPLICATION > ' || hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT);

Line 7694: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)

7690: END LOOP;
7691: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7692: END IF;
7693:
7694: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
7695: || ' > Blocks COUNT being passed to RECIPIENT APPLICATION > ' || hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT);
7696:
7697: IF(hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT > 0) THEN
7698:

Line 7699: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)

7695: || ' > Blocks COUNT being passed to RECIPIENT APPLICATION > ' || hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT);
7696:
7697: IF(hxc_generic_retrieval_pkg.t_detail_bld_blks.COUNT > 0) THEN
7698:
7699: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
7700: || ' > ******* Passing the following blocks for RETRIEVAL *******');
7701:
7702: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7703: fnd_file.put_line(fnd_file.log, ' RESOURCE ID '

Line 7702: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

7698:
7699: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
7700: || ' > ******* Passing the following blocks for RETRIEVAL *******');
7701:
7702: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7703: fnd_file.put_line(fnd_file.log, ' RESOURCE ID '
7704: || ' TIMECARD '
7705: || ' DETAIL ');
7706: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 7703: fnd_file.put_line(fnd_file.log, ' RESOURCE ID '

7699: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
7700: || ' > ******* Passing the following blocks for RETRIEVAL *******');
7701:
7702: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7703: fnd_file.put_line(fnd_file.log, ' RESOURCE ID '
7704: || ' TIMECARD '
7705: || ' DETAIL ');
7706: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7707:

Line 7706: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

7702: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7703: fnd_file.put_line(fnd_file.log, ' RESOURCE ID '
7704: || ' TIMECARD '
7705: || ' DETAIL ');
7706: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7707:
7708: FOR i IN hxc_generic_retrieval_pkg.t_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_detail_bld_blks.LAST
7709: LOOP
7710:

Line 7711: fnd_file.put_line(fnd_file.log, ' '

7707:
7708: FOR i IN hxc_generic_retrieval_pkg.t_detail_bld_blks.FIRST .. hxc_generic_retrieval_pkg.t_detail_bld_blks.LAST
7709: LOOP
7710:
7711: fnd_file.put_line(fnd_file.log, ' '
7712: || hxc_generic_retrieval_pkg.t_detail_bld_blks(i).resource_id
7713: || ' '
7714: || hxc_generic_retrieval_pkg.t_detail_bld_blks(i).timecard_bb_id
7715: || ' ['

Line 7724: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

7720: || hxc_generic_retrieval_pkg.t_detail_bld_blks(i).ovn
7721: || '] ');
7722:
7723: END LOOP;
7724: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
7725:
7726: END IF;
7727:
7728: IF (hxc_generic_retrieval_utils.chk_terminated (g_conc_request_id))

Line 8185: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)

8181: fnd_message.raise_error;
8182: END IF;
8183:
8184:
8185: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
8186: || ' > Blocks COUNT of TRANSACTION DETAILS > ' || hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.COUNT);
8187:
8188: IF(hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.COUNT > 0) THEN
8189:

Line 8190: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)

8186: || ' > Blocks COUNT of TRANSACTION DETAILS > ' || hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.COUNT);
8187:
8188: IF(hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.COUNT > 0) THEN
8189:
8190: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
8191: || ' > ******* Details Recevied from the RECIPIENT APPLICATION *******');
8192:
8193: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
8194: fnd_file.put_line(fnd_file.log, ' DETAIL '

Line 8193: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

8189:
8190: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
8191: || ' > ******* Details Recevied from the RECIPIENT APPLICATION *******');
8192:
8193: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
8194: fnd_file.put_line(fnd_file.log, ' DETAIL '
8195: || ' TRANSACTON ID '
8196: || ' STATUS '
8197: || ' DESCRIPTION ');

Line 8194: fnd_file.put_line(fnd_file.log, ' DETAIL '

8190: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
8191: || ' > ******* Details Recevied from the RECIPIENT APPLICATION *******');
8192:
8193: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
8194: fnd_file.put_line(fnd_file.log, ' DETAIL '
8195: || ' TRANSACTON ID '
8196: || ' STATUS '
8197: || ' DESCRIPTION ');
8198: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 8198: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

8194: fnd_file.put_line(fnd_file.log, ' DETAIL '
8195: || ' TRANSACTON ID '
8196: || ' STATUS '
8197: || ' DESCRIPTION ');
8198: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
8199:
8200: FOR i IN hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.LAST
8201: LOOP
8202:

Line 8203: fnd_file.put_line(fnd_file.log,

8199:
8200: FOR i IN hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.LAST
8201: LOOP
8202:
8203: fnd_file.put_line(fnd_file.log,
8204: ' '
8205: || hxc_generic_retrieval_pkg.t_tx_detail_bb_id(i)
8206: || ' ['
8207: || hxc_generic_retrieval_pkg.t_tx_detail_bb_ovn(i)

Line 8217: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

8213: || hxc_generic_retrieval_pkg.t_tx_detail_exception(i));
8214:
8215: END LOOP;
8216:
8217: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
8218:
8219: END IF;
8220:
8221: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)

Line 8221: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)

8217: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
8218:
8219: END IF;
8220:
8221: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
8222: || ' > ERRORed BLOCK count > ' || hxc_generic_retrieval_pkg.t_tx_error_transaction_id.COUNT);
8223:
8224: IF(hxc_generic_retrieval_pkg.t_tx_error_transaction_id.COUNT > 0) THEN
8225:

Line 8226: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)

8222: || ' > ERRORed BLOCK count > ' || hxc_generic_retrieval_pkg.t_tx_error_transaction_id.COUNT);
8223:
8224: IF(hxc_generic_retrieval_pkg.t_tx_error_transaction_id.COUNT > 0) THEN
8225:
8226: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
8227: || ' > ******* The following blocks are in ERROR *******');
8228:
8229: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
8230: fnd_file.put_line(fnd_file.log, ' DETAIL '

Line 8229: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

8225:
8226: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
8227: || ' > ******* The following blocks are in ERROR *******');
8228:
8229: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
8230: fnd_file.put_line(fnd_file.log, ' DETAIL '
8231: || ' TRANSACTON ID '
8232: || ' STATUS '
8233: || ' DESCRIPTION ');

Line 8230: fnd_file.put_line(fnd_file.log, ' DETAIL '

8226: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)
8227: || ' > ******* The following blocks are in ERROR *******');
8228:
8229: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
8230: fnd_file.put_line(fnd_file.log, ' DETAIL '
8231: || ' TRANSACTON ID '
8232: || ' STATUS '
8233: || ' DESCRIPTION ');
8234: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 8234: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

8230: fnd_file.put_line(fnd_file.log, ' DETAIL '
8231: || ' TRANSACTON ID '
8232: || ' STATUS '
8233: || ' DESCRIPTION ');
8234: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
8235:
8236: FOR i IN hxc_generic_retrieval_pkg.t_tx_error_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_error_transaction_id.LAST
8237: LOOP
8238:

Line 8239: fnd_file.put_line(fnd_file.log,

8235:
8236: FOR i IN hxc_generic_retrieval_pkg.t_tx_error_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_error_transaction_id.LAST
8237: LOOP
8238:
8239: fnd_file.put_line(fnd_file.log,
8240: ' '
8241: || hxc_generic_retrieval_pkg.t_tx_error_bb_id(i)
8242: || ' ['
8243: || hxc_generic_retrieval_pkg.t_tx_error_bb_ovn(i)

Line 8253: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

8249: || hxc_generic_retrieval_pkg.t_tx_error_exception(i));
8250:
8251: END LOOP;
8252:
8253: fnd_file.put_line(fnd_file.log, ' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
8254:
8255: END IF;
8256:
8257: IF g_debug