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

Line 70: fnd_file.put_line(fnd_file.log, 'Number of Payments Selected:'||l_pmt_count);

66: select count(*) into l_pmt_count FROM IBY_PYO_PAYMENT_GT;
67: SELECT COUNT(*) into l_doc_count FROM IBY_PYO_INVOICE_GT;
68:
69: IF (l_pmt_count = 0 OR l_doc_count = 0) THEN
70: fnd_file.put_line(fnd_file.log, 'Number of Payments Selected:'||l_pmt_count);
71: fnd_file.put_line(fnd_file.log, 'Number of Documents Selected:'||l_doc_count);
72: fnd_file.put_line(fnd_file.log, 'UnExpected Error. Payments/Documents could not be fetched');
73: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
74: return;

Line 71: fnd_file.put_line(fnd_file.log, 'Number of Documents Selected:'||l_doc_count);

67: SELECT COUNT(*) into l_doc_count FROM IBY_PYO_INVOICE_GT;
68:
69: IF (l_pmt_count = 0 OR l_doc_count = 0) THEN
70: fnd_file.put_line(fnd_file.log, 'Number of Payments Selected:'||l_pmt_count);
71: fnd_file.put_line(fnd_file.log, 'Number of Documents Selected:'||l_doc_count);
72: fnd_file.put_line(fnd_file.log, 'UnExpected Error. Payments/Documents could not be fetched');
73: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
74: return;
75: END IF;

Line 72: fnd_file.put_line(fnd_file.log, 'UnExpected Error. Payments/Documents could not be fetched');

68:
69: IF (l_pmt_count = 0 OR l_doc_count = 0) THEN
70: fnd_file.put_line(fnd_file.log, 'Number of Payments Selected:'||l_pmt_count);
71: fnd_file.put_line(fnd_file.log, 'Number of Documents Selected:'||l_doc_count);
72: fnd_file.put_line(fnd_file.log, 'UnExpected Error. Payments/Documents could not be fetched');
73: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
74: return;
75: END IF;
76:

Line 126: fnd_file.put_line(fnd_file.log, 'Calling EC Process Outbound :: START ::'||systimestamp);

122:
123: xProgress := 'PYO-10-1030';
124: ec_debug.pl ( 0, 'EC', 'ECE_PAYMENT_BATCH', 'PAYMENT INSTRUCTION ID ', p_payment_instruction_id );
125:
126: fnd_file.put_line(fnd_file.log, 'Calling EC Process Outbound :: START ::'||systimestamp);
127:
128: ec_document.process_outbound(
129: errbuf => p_errbuf,
130: retcode => p_retcode,

Line 138: fnd_file.put_line(fnd_file.log, 'Calling EC Process Outbound :: END ::'||systimestamp);

134: i_debug_mode => p_debug_mode,
135: parameter1 => p_payment_instruction_id
136: );
137:
138: fnd_file.put_line(fnd_file.log, 'Calling EC Process Outbound :: END ::'||systimestamp);
139:
140:
141: -- Standard check of p_commit
142: if fnd_api.to_Boolean(p_commit) then

Line 162: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);

158: ec_debug.disable_debug;
159: EXCEPTION
160: WHEN fnd_api.g_exc_error THEN
161: ROLLBACK;
162: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
163: x_return_status := fnd_api.g_ret_sts_error;
164: fnd_msg_pub.count_and_get(p_count => x_msg_count,
165: p_data => x_msg_data);
166: ec_debug.disable_debug;

Line 169: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);

165: p_data => x_msg_data);
166: ec_debug.disable_debug;
167: WHEN fnd_api.g_exc_unexpected_error THEN
168: ROLLBACK;
169: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
170: x_return_status := fnd_api.g_ret_sts_unexp_error;
171: fnd_msg_pub.count_and_get(p_count => x_msg_count,
172: p_data => x_msg_data);
173: ec_debug.disable_debug;

Line 176: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);

172: p_data => x_msg_data);
173: ec_debug.disable_debug;
174: WHEN OTHERS THEN
175: ROLLBACK;
176: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
177: x_return_status := fnd_api.g_ret_sts_unexp_error;
178: IF fnd_msg_pub.Check_Msg_Level
179: (fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
180: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

Line 195: fnd_file.put_line(fnd_file.log, 'Calling insert_into_gt :: START ::'||systimestamp);

191:
192: BEGIN
193: ec_debug.push('ECE_AP_TRANSACTION.insert_into_gt');
194: ec_debug.pl (3, 'Fetching Payment data for Instruction',p_payment_instruction_id);
195: fnd_file.put_line(fnd_file.log, 'Calling insert_into_gt :: START ::'||systimestamp);
196:
197: INSERT INTO IBY_PYO_PAYMENT_GT(COMMUNICATION_METHOD,
198: TEST_FLAG,
199: DOCUMENT_ID,

Line 781: fnd_file.put_line(fnd_file.log, 'Finished fetching Payment Data ::'||systimestamp);

777: OR (ipay.payment_status = 'FORMATTED' AND ipay.process_type = 'IMMEDIATE'));
778:
779: ec_debug.pl (3, 'Finished fetching Payment data');
780: ec_debug.pl (3, 'Fetching Invoice data');
781: fnd_file.put_line(fnd_file.log, 'Finished fetching Payment Data ::'||systimestamp);
782:
783: INSERT INTO IBY_PYO_INVOICE_GT(PAYMENT_ID,
784: PAYMENT_INSTRUCTION_ID,
785: PAY_SELECTED_CHECK_ID,

Line 956: fnd_file.put_line(fnd_file.log, 'Calling insert_into_gt :: END ::'||systimestamp);

952: AND idpa.document_status in ('PAYMENT_CREATED');
953:
954:
955: ec_debug.pop ( 'ECE_AP_TRANSACTION.insert_into_gt');
956: fnd_file.put_line(fnd_file.log, 'Calling insert_into_gt :: END ::'||systimestamp);
957: END insert_into_gt;
958:
959:
960: PROCEDURE delete_from_gt IS

Line 963: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: START ::'||systimestamp);

959:
960: PROCEDURE delete_from_gt IS
961: BEGIN
962: ec_debug.push('ECE_AP_TRANSACTION.delete_from_gt');
963: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: START ::'||systimestamp);
964: delete from IBY_PYO_PAYMENT_GT;
965: delete from IBY_PYO_INVOICE_GT;
966: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: END ::'||systimestamp);
967: ec_debug.pop ( 'ECE_AP_TRANSACTION.delete_from_gt');

Line 966: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: END ::'||systimestamp);

962: ec_debug.push('ECE_AP_TRANSACTION.delete_from_gt');
963: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: START ::'||systimestamp);
964: delete from IBY_PYO_PAYMENT_GT;
965: delete from IBY_PYO_INVOICE_GT;
966: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: END ::'||systimestamp);
967: ec_debug.pop ( 'ECE_AP_TRANSACTION.delete_from_gt');
968: END delete_from_gt;
969:
970: END IBY_PYO_TRANSACTION;