DBA Data[Home] [Help]

APPS.ECE_AP_PAYMENT dependencies on FND_FILE

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

129:
130: xProgress := 'PYO-10-1030';
131: ec_debug.pl ( 0, 'EC', 'ECE_PAYMENT_BATCH', 'PAYMENT INSTRUCTION ID ', p_payment_instruction_id );
132:
133: fnd_file.put_line(fnd_file.log, 'Calling EC Process Outbound :: START ::'||systimestamp);
134:
135: ec_document.process_outbound(
136: errbuf => p_errbuf,
137: retcode => p_retcode,

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

141: i_debug_mode => p_debug_mode,
142: parameter1 => p_payment_instruction_id
143: );
144:
145: fnd_file.put_line(fnd_file.log, 'Calling EC Process Outbound :: END ::'||systimestamp);
146:
147:
148: -- Standard check of p_commit
149: if fnd_api.to_Boolean(p_commit) then

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

165: ec_debug.disable_debug;
166: EXCEPTION
167: WHEN fnd_api.g_exc_error THEN
168: ROLLBACK;
169: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
170: x_return_status := fnd_api.g_ret_sts_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 fnd_api.g_exc_unexpected_error 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: fnd_msg_pub.count_and_get(p_count => x_msg_count,
179: p_data => x_msg_data);
180: ec_debug.disable_debug;

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

179: p_data => x_msg_data);
180: ec_debug.disable_debug;
181: WHEN OTHERS THEN
182: ROLLBACK;
183: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
184: x_return_status := fnd_api.g_ret_sts_unexp_error;
185: IF fnd_msg_pub.Check_Msg_Level
186: (fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
187: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

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

198:
199: BEGIN
200: ec_debug.push('ECE_AP_TRANSACTION.insert_into_gt');
201: ec_debug.pl (3, 'Fetching Payment data for Instruction',p_payment_instruction_id);
202: fnd_file.put_line(fnd_file.log, 'Calling insert_into_gt :: START ::'||systimestamp);
203:
204: INSERT INTO IBY_PYO_PAYMENT_GT(COMMUNICATION_METHOD,
205: TEST_FLAG,
206: DOCUMENT_ID,

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

783: AND ipay.payment_status = 'INSTRUCTION_CREATED';
784:
785: ec_debug.pl (3, 'Finished fetching Payment data');
786: ec_debug.pl (3, 'Fetching Invoice data');
787: fnd_file.put_line(fnd_file.log, 'Finished fetching Payment Data ::'||systimestamp);
788:
789: INSERT INTO IBY_PYO_INVOICE_GT(PAYMENT_ID,
790: PAYMENT_INSTRUCTION_ID,
791: PAY_SELECTED_CHECK_ID,

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

957: AND ipa.payment_instruction_id = p_payment_instruction_id
958: AND idpa.document_status in ('PAYMENT_CREATED');
959:
960: ec_debug.pop ( 'ECE_AP_TRANSACTION.insert_into_gt');
961: fnd_file.put_line(fnd_file.log, 'Calling insert_into_gt :: END ::'||systimestamp);
962: END insert_into_gt;
963:
964:
965: PROCEDURE delete_from_gt IS

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

964:
965: PROCEDURE delete_from_gt IS
966: BEGIN
967: ec_debug.push('ECE_AP_TRANSACTION.delete_from_gt');
968: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: START ::'||systimestamp);
969: delete from IBY_PYO_PAYMENT_GT;
970: delete from IBY_PYO_INVOICE_GT;
971: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: END ::'||systimestamp);
972: ec_debug.pop ( 'ECE_AP_TRANSACTION.delete_from_gt');

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

967: ec_debug.push('ECE_AP_TRANSACTION.delete_from_gt');
968: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: START ::'||systimestamp);
969: delete from IBY_PYO_PAYMENT_GT;
970: delete from IBY_PYO_INVOICE_GT;
971: fnd_file.put_line(fnd_file.log, 'Calling delete_from_gt :: END ::'||systimestamp);
972: ec_debug.pop ( 'ECE_AP_TRANSACTION.delete_from_gt');
973: END delete_from_gt;
974:
975: END ece_ap_payment;