[Home] [Help]
PACKAGE BODY: APPS.ECE_AP_PAYMENT
Source
1 PACKAGE BODY ece_ap_payment AS
2 -- $Header: ECEPYOB.pls 120.17 2010/12/21 20:04:12 vkarlapu ship $
3 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ECE_AP_PAYMENT';
4
5 PROCEDURE insert_into_gt (
6 p_payment_instruction_id IN number
7 );
8
9 PROCEDURE delete_from_gt;
10
11 /*===========================================================================
12
13 PROCEDURE NAME: Extract_PYO_Outbound
14
15 PURPOSE: This procedure initiates the concurrent process to
16 extract the eligible transactions.
17
18 ===========================================================================*/
19 PROCEDURE Extract_PYO_Outbound ( p_api_version IN number,
20 p_init_msg_list IN varchar2,
21 p_commit IN varchar2,
22 x_return_status OUT NOCOPY varchar2,
23 x_msg_count OUT NOCOPY number,
24 x_msg_data OUT NOCOPY varchar2,
25 p_payment_instruction_id IN number
26 ) IS
27
28 xProgress VARCHAR2(80);
29 i_file_id PLS_INTEGER;
30 cOutput_Path VARCHAR2(120);
31 i_Filename VARCHAR2(50);
32 i_Transaction_Type VARCHAR2(50);
33 p_errbuf VARCHAR2(32767);
34 p_retcode VARCHAR2(32767);
35 l_api_version CONSTANT NUMBER := 1.0;
36 l_api_name CONSTANT VARCHAR2(30) := 'Extract_PYO_Outbound';
37 p_debug_mode NUMBER;
38 BEGIN
39
40 fnd_profile.get('ECE_PYO_DEBUG_MODE', p_Debug_Mode);
41 --p_debug_mode := 3;
42
43 IF p_Debug_mode IS NULL THEN
44 p_Debug_Mode := 3;
45 END IF;
46
47
48 ec_debug.enable_debug(p_debug_mode);
49 ec_debug.pl ( 0, 'EC', 'ECE_PYO_START', NULL );
50 ec_debug.push('ECE_AP_TRANSACTION.Extract_PYO_Outbound');
51 ec_debug.pl(3,'Payment Instruction ID ',p_payment_instruction_id );
52 ec_debug.pl(3,'Debug Mode: ',p_debug_mode );
53
54 i_Transaction_Type := 'PYO';
55
56 /*
57 * Inserting values from iby view to Global Temporary table
58 * For performance.
59 */
60
61 insert_into_gt(p_payment_instruction_id);
62
63
64 ec_debug.pl (3, 'comes here');
65
66 /*
67 IF NOT fnd_api.Compatible_API_Call(l_api_version,
68 p_api_version,
69 l_api_name,
70 G_PKG_NAME)
71 THEN
72 ec_debug.pl (3, 'comes here');
73 RAISE fnd_api.g_exc_unexpected_error;
74 END IF;
75
76 IF fnd_api.to_Boolean(p_init_msg_list) THEN
77 fnd_msg_pub.initialize;
78 END IF;
79
80 x_return_status := fnd_api.g_ret_sts_success;
81 ec_debug.pl (3, 'comes here');
82 */
83
84 x_return_status := fnd_api.g_ret_sts_success; -- bug:5512623
85
86 xProgress := 'PYO-10-1004';
87
88 -- Derive output filename
89 -- IF fnd_global.conc_request_id IS NOT NULL THEN
90
91 i_file_id := IBY_EC_OP_FILE_NAME_EXT_PUB.get_File_Id(p_payment_instruction_id);
92 ec_debug.pl(3,'File Id returned from ext pub::',i_file_id );
93
94
95 IF i_file_id is null THEN
96 BEGIN
97 SELECT ece_output_runs_s.NEXTVAL INTO i_file_id
98 FROM DUAL;
99 EXCEPTION
100 WHEN NO_DATA_FOUND THEN
101 ec_debug.pl ( 0,
102 'EC',
103 'ECE_GET_NEXT_SEQ_FAILED',
104 'PROGRESS_LEVEL',
105 xProgress,
106 'SEQ',
107 'ECE_OUTPUT_RUNS_S'
108 );
109 END;
110 END IF;
111
112 ec_debug.pl (3, 'comes here');
113
114 ec_debug.pl ( 3, 'File ID ',i_file_id);
115
116
117 i_Filename := i_Transaction_Type || i_file_id || '.dat';
118
119
120 xProgress := 'PYO-10-1005';
121 fnd_profile.get ( 'ECE_OUT_FILE_PATH',
122 cOutput_path );
123 ec_debug.pl ( 3, 'cOutput_Path: ',cOutput_Path );
124
125
126
127
128
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,
138 i_Output_Path => cOutput_Path,
139 i_Output_Filename => i_Filename,
140 i_Transaction_Type => i_Transaction_Type,
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
150 COMMIT WORK;
151 end if;
152
153 -- Standard call to get message count and if count is 1, get message info.
154 fnd_msg_pub.count_and_get(
155 p_count => x_msg_count,
156 p_data => x_msg_data);
157
158
159 IF ec_mapping_utils.ec_get_trans_upgrade_status(i_Transaction_Type) = 'U' THEN
160 ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);
161 END IF;
162
163 delete_from_gt;
164 ec_debug.pop ( 'ECE_AP_TRANSACTION.Extract_PYO_Outbound' );
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;
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;
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);
188 END IF;
189 fnd_msg_pub.count_and_get(p_count => x_msg_count,
190 p_data => x_msg_data);
191
192 ec_debug.disable_debug;
193 END Extract_PYO_Outbound;
194
195
196 PROCEDURE insert_into_gt(p_payment_instruction_id IN NUMBER)
197 IS
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,
207 DOCUMENT_CODE,
208 BK_TP_TRANSLATOR_CODE,
209 BK_TP_LOCATION_CODE_EXT,
210 BK_TP_DESCRIPTION,
211 BK_TP_REFERENCE_EXT1,
212 BK_TP_REFERENCE_EXT2,
213 TRANSACTION_DATE,
214 TPH_ATTRIBUTE_CATEGORY,
215 TPH_ATTRIBUTE1,
216 TPH_ATTRIBUTE2,
217 TPH_ATTRIBUTE3,
218 TPH_ATTRIBUTE4,
219 TPH_ATTRIBUTE5,
220 TPH_ATTRIBUTE6,
221 TPH_ATTRIBUTE7,
222 TPH_ATTRIBUTE8,
223 TPH_ATTRIBUTE9,
224 TPH_ATTRIBUTE10,
225 TPH_ATTRIBUTE11,
226 TPH_ATTRIBUTE12,
227 TPH_ATTRIBUTE13,
228 TPH_ATTRIBUTE14,
229 TPH_ATTRIBUTE15,
230 TPD_ATTRIBUTE_CATEGORY,
231 TPD_ATTRIBUTE1,
232 TPD_ATTRIBUTE2,
233 TPD_ATTRIBUTE3,
234 TPD_ATTRIBUTE4,
235 TPD_ATTRIBUTE5,
236 DOCUMENT_STANDARD,
237 TRANSACTION_HANDLING_CODE,
238 CHECK_AMOUNT,
239 CURRENCY_CODE,
240 EDI_PAYMENT_METHOD,
241 EDI_PAYMENT_FORMAT,
242 BANK_BRANCH_TYPE,
243 BANK_ACCOUNT_TYPE,
244 BANK_ACCOUNT_NUM,
245 BANK_EDI_ID_NUMBER,
246 VENDOR_BANK_BRANCH_TYPE,
247 VENDOR_BANK_ACCOUNT_TYPE,
248 VENDOR_BANK_ACCOUNT_NUM,
249 PAYMENT_DATE,
250 BANK_NUM,
251 VENDOR_BANK_NUM,
252 EDI_REMITTANCE_METHOD,
253 EDI_REMITTANCE_INSTRUCTION,
254 PAYMENT_INSTRUCTION_ID,
255 CHECK_VOUCHER_NUM,
256 SELECTED_CHECK_ID,
257 CHECK_NUMBER,
258 CUSTOMER_NUM,
259 SEGMENT1,
260 VENDOR_EDI_ID_NUMBER,
261 SEGMENT2,
262 SEGMENT3,
263 SEGMENT4,
264 SEGMENT5,
265 BANK_BRANCH_ID,
266 BK_BANK_BRANCH_NAME,
267 BK_ADDRESS_LINE1,
268 BK_ADDRESS_LINE2,
269 BK_ADDRESS_LINE3,
270 BK_CITY,
271 BK_ZIP,
272 BK_COUNTRY,
273 BK_STATE,
274 BK_PROVINCE,
275 BK_CONTACT_FIRST_NAME,
276 BK_CONTACT_MIDDLE_NAME,
277 BK_CONTACT_LAST_NAME,
278 BK_CONTACT_TITLE,
279 BK_CONTACT_PREFIX,
280 BK_CONTACT_AREA_CODE,
281 BK_CONTACT_PHONE,
282 VENDOR_SITE_CODE,
283 VENDOR_NAME,
284 ADDRESS_LINE1,
285 ADDRESS_LINE2,
286 ADDRESS_LINE3,
287 ADDRESS_LINE4,
288 CITY,
289 ZIP,
290 COUNTRY,
291 STATE,
292 PROVINCE,
293 ABA_GLOBAL_ATTRIBUTE_CATEGORY,
294 ABA_GLOBAL_ATTRIBUTE1,
295 ABA_GLOBAL_ATTRIBUTE2,
296 ABA_GLOBAL_ATTRIBUTE3,
297 ABA_GLOBAL_ATTRIBUTE4,
298 ABA_GLOBAL_ATTRIBUTE5,
299 ABA_GLOBAL_ATTRIBUTE6,
300 ABA_GLOBAL_ATTRIBUTE7,
301 ABA_GLOBAL_ATTRIBUTE8,
302 ABA_GLOBAL_ATTRIBUTE9,
303 ABA_GLOBAL_ATTRIBUTE10,
304 ABA_GLOBAL_ATTRIBUTE11,
305 ABA_GLOBAL_ATTRIBUTE12,
306 ABA_GLOBAL_ATTRIBUTE13,
307 ABA_GLOBAL_ATTRIBUTE14,
308 ABA_GLOBAL_ATTRIBUTE15,
309 ABA_GLOBAL_ATTRIBUTE16,
310 ABA_GLOBAL_ATTRIBUTE17,
311 ABA_GLOBAL_ATTRIBUTE18,
312 ABA_GLOBAL_ATTRIBUTE19,
313 ABA_GLOBAL_ATTRIBUTE20,
314 ABAS_GLOBAL_ATTRIBUTE_CATEGORY,
315 ABAS_GLOBAL_ATTRIBUTE1,
316 ABAS_GLOBAL_ATTRIBUTE2,
317 ABAS_GLOBAL_ATTRIBUTE3,
318 ABAS_GLOBAL_ATTRIBUTE4,
319 ABAS_GLOBAL_ATTRIBUTE5,
320 ABAS_GLOBAL_ATTRIBUTE6,
321 ABAS_GLOBAL_ATTRIBUTE7,
322 ABAS_GLOBAL_ATTRIBUTE8,
323 ABAS_GLOBAL_ATTRIBUTE9,
324 ABAS_GLOBAL_ATTRIBUTE10,
325 ABAS_GLOBAL_ATTRIBUTE11,
326 ABAS_GLOBAL_ATTRIBUTE12,
327 ABAS_GLOBAL_ATTRIBUTE13,
328 ABAS_GLOBAL_ATTRIBUTE14,
329 ABAS_GLOBAL_ATTRIBUTE15,
330 ABAS_GLOBAL_ATTRIBUTE16,
331 ABAS_GLOBAL_ATTRIBUTE17,
332 ABAS_GLOBAL_ATTRIBUTE18,
333 ABAS_GLOBAL_ATTRIBUTE19,
334 ABAS_GLOBAL_ATTRIBUTE20,
335 PVS_GLOBAL_ATTRIBUTE_CATEGORY,
336 PVS_GLOBAL_ATTRIBUTE1,
337 PVS_GLOBAL_ATTRIBUTE2,
338 PVS_GLOBAL_ATTRIBUTE3,
339 PVS_GLOBAL_ATTRIBUTE4,
340 PVS_GLOBAL_ATTRIBUTE5,
341 PVS_GLOBAL_ATTRIBUTE6,
342 PVS_GLOBAL_ATTRIBUTE7,
343 PVS_GLOBAL_ATTRIBUTE8,
344 PVS_GLOBAL_ATTRIBUTE9,
345 PVS_GLOBAL_ATTRIBUTE10,
346 PVS_GLOBAL_ATTRIBUTE11,
347 PVS_GLOBAL_ATTRIBUTE12,
348 PVS_GLOBAL_ATTRIBUTE13,
349 PVS_GLOBAL_ATTRIBUTE14,
350 PVS_GLOBAL_ATTRIBUTE15,
351 PVS_GLOBAL_ATTRIBUTE16,
352 PVS_GLOBAL_ATTRIBUTE17,
353 PVS_GLOBAL_ATTRIBUTE18,
354 PVS_GLOBAL_ATTRIBUTE19,
355 PVS_GLOBAL_ATTRIBUTE20,
356 BK_EFT_SWIFT_CODE,
357 SBK_BANK_BRANCH_NUMBER,
358 SBK_BANK_BRANCH_NAME,
359 SBK_ADDRESS_LINE1,
360 SBK_ADDRESS_LINE2,
361 SBK_ADDRESS_LINE3,
362 SBK_CITY,
363 SBK_STATE,
364 SBK_ZIP,
365 SBK_PROVINCE,
366 SBK_COUNTRY,
367 SBK_EFT_SWIFT_CODE,
368 BILL_TO_INT_LOCATION_NAME,
369 BILL_TO_INT_ADDRESS1,
370 BILL_TO_INT_ADDRESS2,
371 BILL_TO_INT_ADDRESS3,
372 BILL_TO_INT_CITY,
373 BILL_TO_INT_POSTAL_CODE,
374 BILL_TO_INT_COUNTRY,
375 FI_VAT_REGISTRATION_NUM,
376 BILL_TO_INT_LOCATION_ID,
377 ECE_TP_LOCATION_CODE,
378 BILL_TO_INT_REGION1,
379 BILL_TO_INT_REGION2,
380 BILL_TO_INT_REGION3,
381 MAP_ID,
382 FUTURE_PAY_DUE_DATE,
383 VENDOR_ALTERNATE_NAME,
384 VENDOR_ALTERNATE_SITE_CODE,
385 SUPPLIER_CHECK_DIGITS,
386 SBK_BANK_NAME,
387 IBAN_NUMBER,
388 VENDOR_IBAN_NUMBER,
389 PAYMENT_MEAN,
390 PAYMENT_CHANNEL,
391 VENDOR_ID,
392 VENDOR_SITE_ID,
393 PAYMENT_REFERENCE_NUMBER,
394 SBK_BANK_CODE,
395 PAYMENT_PROCESS_REQUEST_NAME,
396 PAYMENT_ORG_ID,
397 BANK_NAME,
398 BRANCH_NUMBER,
399 BANK_ACCOUNT_ID,
400 BANK_ACCOUNT_NAME,
401 BK_ACCT_ATTRIBUTE_CATEGORY,
402 BK_ACCT_ATTRIBUTE1,
403 BK_ACCT_ATTRIBUTE2,
404 BK_ACCT_ATTRIBUTE3,
405 BK_ACCT_ATTRIBUTE4,
406 BK_ACCT_ATTRIBUTE5,
407 BK_ACCT_ATTRIBUTE6,
408 BK_ACCT_ATTRIBUTE7,
409 BK_ACCT_ATTRIBUTE8,
410 BK_ACCT_ATTRIBUTE9,
411 BK_ACCT_ATTRIBUTE10,
412 BK_ACCT_ATTRIBUTE11,
413 BK_ACCT_ATTRIBUTE12,
414 BK_ACCT_ATTRIBUTE13,
415 BK_ACCT_ATTRIBUTE14,
416 BK_ACCT_ATTRIBUTE15,
417 VENDOR_BANK_ACCOUNT_ID,
418 SBK_ACCT_ATTRIBUTE_CATEGORY,
419 SBK_ACCT_ATTRIBUTE1,
420 SBK_ACCT_ATTRIBUTE2,
421 SBK_ACCT_ATTRIBUTE3,
422 SBK_ACCT_ATTRIBUTE4,
423 SBK_ACCT_ATTRIBUTE5,
424 SBK_ACCT_ATTRIBUTE6,
425 SBK_ACCT_ATTRIBUTE7,
426 SBK_ACCT_ATTRIBUTE8,
427 SBK_ACCT_ATTRIBUTE9,
428 SBK_ACCT_ATTRIBUTE10,
429 SBK_ACCT_ATTRIBUTE11,
430 SBK_ACCT_ATTRIBUTE12,
431 SBK_ACCT_ATTRIBUTE13,
432 SBK_ACCT_ATTRIBUTE14,
433 SBK_ACCT_ATTRIBUTE15,
434 VEND_SITE_COUNTY,
435 VEND_SITE_ATTRIBUTE_CATEGORY,
436 VEND_SITE_ATTRIBUTE1,
437 VEND_SITE_ATTRIBUTE2,
438 VEND_SITE_ATTRIBUTE3,
439 VEND_SITE_ATTRIBUTE4,
440 VEND_SITE_ATTRIBUTE5,
441 VEND_SITE_ATTRIBUTE6,
442 VEND_SITE_ATTRIBUTE7,
443 VEND_SITE_ATTRIBUTE8,
444 VEND_SITE_ATTRIBUTE9,
445 VEND_SITE_ATTRIBUTE10,
446 VEND_SITE_ATTRIBUTE11,
447 VEND_SITE_ATTRIBUTE12,
448 VEND_SITE_ATTRIBUTE13,
449 VEND_SITE_ATTRIBUTE14,
450 VEND_SITE_ATTRIBUTE15,
451 VENDOR_TYPE_LOOKUP_CODE,
452 VENDOR_ATTRIBUTE_CATEGORY,
453 VENDOR_ATTRIBUTE1,
454 VENDOR_ATTRIBUTE2,
455 VENDOR_ATTRIBUTE3,
456 VENDOR_ATTRIBUTE4,
457 VENDOR_ATTRIBUTE5,
458 VENDOR_ATTRIBUTE6,
459 VENDOR_ATTRIBUTE7,
460 VENDOR_ATTRIBUTE8,
461 VENDOR_ATTRIBUTE9,
462 VENDOR_ATTRIBUTE10,
463 VENDOR_ATTRIBUTE11,
464 VENDOR_ATTRIBUTE12,
465 VENDOR_ATTRIBUTE13,
466 VENDOR_ATTRIBUTE14,
467 VENDOR_ATTRIBUTE15
468 )
469 SELECT 'EDI' communication_method ,
470 bktpd.test_flag test_flag ,
471 'PYO' document_id ,
472 ipay.payment_id document_code ,
473 bktpd.translator_code bk_tp_translator_code ,
474 hcp.edi_ece_tp_location_code bk_tp_location_code_ext ,
475 bktph.tp_description bk_tp_description ,
476 bktph.tp_reference_ext1 bk_tp_reference_ext1 ,
477 bktph.tp_reference_ext2 bk_tp_reference_ext2 ,
478 sysdate transaction_date ,
479 bktph.attribute_category tph_attribute_category ,
480 bktph.attribute1 tph_attribute1 ,
481 bktph.attribute2 tph_attribute2 ,
482 bktph.attribute3 tph_attribute3 ,
483 bktph.attribute4 tph_attribute4 ,
484 bktph.attribute5 tph_attribute5 ,
485 bktph.attribute6 tph_attribute6 ,
486 bktph.attribute7 tph_attribute7 ,
487 bktph.attribute8 tph_attribute8 ,
488 bktph.attribute9 tph_attribute9 ,
489 bktph.attribute10 tph_attribute10 ,
490 bktph.attribute11 tph_attribute11 ,
491 bktph.attribute12 tph_attribute12 ,
492 bktph.attribute13 tph_attribute13 ,
493 bktph.attribute14 tph_attribute14 ,
494 bktph.attribute15 tph_attribute15 ,
495 bktpd.attribute_category tpd_attribute_category ,
496 bktpd.attribute1 tpd_attribute1 ,
497 bktpd.attribute2 tpd_attribute2 ,
498 bktpd.attribute3 tpd_attribute3 ,
499 bktpd.attribute4 tpd_attribute4 ,
500 bktpd.attribute5 tpd_attribute5 ,
501 bktpd.document_standard document_standard ,
502 ipay.bank_instruction2_code transaction_handling_code ,
503 ipay.payment_amount check_amount ,
504 ipay.payment_currency_code currency_code ,
505 ipay.payment_method_code edi_payment_method ,
506 ipay.bank_instruction1_code edi_payment_format ,
507 hca1.class_code bank_branch_type ,
508 cba.bank_account_type bank_account_type ,
509 ipay.int_bank_account_number bank_account_num ,
510 hcp.edi_id_number bank_edi_id_number ,
511 hca.class_code vendor_bank_branch_type ,
512 ipay.ext_bank_account_type vendor_bank_account_type ,
513 ipay.ext_bank_account_number vendor_bank_account_num ,
514 ipay.payment_date payment_date ,
515 ipay.int_bank_branch_number bank_num , -- Bug 9365065
516 ipay.ext_branch_number vendor_bank_num , -- Bug 9365065
517 ipay.delivery_channel_code edi_remittance_method ,
518 ipay.payment_text_message1 edi_remittance_instruction ,
519 ipay.payment_instruction_id payment_instruction_id ,
520 NULL check_voucher_num ,
521 NULL selected_check_id ,
522 nvl(ipay.paper_document_number, ipay.payment_reference_number) check_number, -- Bug 9365065
523 aps.customer_num customer_num ,
524 aps.segment1 segment1 ,
525 apss.edi_id_number vendor_edi_id_number ,
526 aps.segment2 segment2 ,
527 aps.segment3 segment3 ,
528 aps.segment4 segment4 ,
529 aps.segment5 segment5 ,
530 ipay.int_bank_branch_party_id bank_branch_id ,
531 ipay.int_bank_branch_name bk_bank_branch_name ,
532 ibl.address1 bk_address_line1 ,
533 ibl.address2 bk_address_line2 ,
534 ibl.address3 bk_address_line3 ,
535 ibl.city bk_city ,
536 ibl.postal_code bk_zip ,
537 ibl.country bk_country ,
538 ibl.state bk_state ,
539 ibl.province bk_province ,
540 NULL bk_contact_first_name ,
541 NULL bk_contact_middle_name ,
542 NULL bk_contact_last_name ,
543 NULL bk_contact_title ,
544 NULL bk_contact_prefix ,
545 NULL bk_contact_area_code ,
546 NULL bk_contact_phone ,
547 apss.vendor_site_code vendor_site_code ,
548 ipay.payee_name vendor_name ,
549 ipay.payee_address1 address_line1 ,
550 ipay.payee_address2 address_line2 ,
551 ipay.payee_address3 address_line3 ,
552 ipay.payee_address4 address_line4 ,
553 ipay.payee_city city ,
554 ipay.payee_postal_code zip ,
555 ipay.payee_country country ,
556 ipay.payee_state state ,
557 ipay.payee_province province ,
558 NULL aba_global_attribute_category ,
559 NULL aba_global_attribute1 ,
560 NULL aba_global_attribute2 ,
561 NULL aba_global_attribute3 ,
562 NULL aba_global_attribute4 ,
563 NULL aba_global_attribute5 ,
564 NULL aba_global_attribute6 ,
565 NULL aba_global_attribute7 ,
566 NULL aba_global_attribute8 ,
567 NULL aba_global_attribute9 ,
568 NULL aba_global_attribute10 ,
569 NULL aba_global_attribute11 ,
570 NULL aba_global_attribute12 ,
571 NULL aba_global_attribute13 ,
572 NULL aba_global_attribute14 ,
573 NULL aba_global_attribute15 ,
574 NULL aba_global_attribute16 ,
575 NULL aba_global_attribute17 ,
576 NULL aba_global_attribute18 ,
577 NULL aba_global_attribute19 ,
578 NULL aba_global_attribute20 ,
579 NULL abas_global_attribute_category ,
580 NULL abas_global_attribute1 ,
581 NULL abas_global_attribute2 ,
582 ipay.payee_country abas_global_attribute3 ,
583 NULL abas_global_attribute4 ,
584 ipay.payment_reason_code abas_global_attribute5 ,
585 NULL abas_global_attribute6 ,
586 NULL abas_global_attribute7 ,
587 ipay.bank_charge_bearer abas_global_attribute8 ,
588 NULL abas_global_attribute9 ,
589 NULL abas_global_attribute10 ,
590 NULL abas_global_attribute11 ,
591 NULL abas_global_attribute12 ,
592 NULL abas_global_attribute13 ,
593 NULL abas_global_attribute14 ,
594 NULL abas_global_attribute15 ,
595 NULL abas_global_attribute16 ,
596 NULL abas_global_attribute17 ,
597 NULL abas_global_attribute18 ,
598 NULL abas_global_attribute19 ,
599 NULL abas_global_attribute20 ,
600 apss.global_attribute_category pvs_global_attribute_category,
601 apss.global_attribute1 pvs_global_attribute1 ,
602 apss.global_attribute2 pvs_global_attribute2 ,
603 apss.global_attribute3 pvs_global_attribute3 ,
604 apss.global_attribute4 pvs_global_attribute4 ,
605 apss.global_attribute5 pvs_global_attribute5 ,
606 apss.global_attribute6 pvs_global_attribute6 ,
607 apss.global_attribute7 pvs_global_attribute7 ,
608 apss.global_attribute8 pvs_global_attribute8 ,
609 apss.global_attribute9 pvs_global_attribute9 ,
610 apss.global_attribute10 pvs_global_attribute10 ,
611 apss.global_attribute11 pvs_global_attribute11 ,
612 apss.global_attribute12 pvs_global_attribute12 ,
613 apss.global_attribute13 pvs_global_attribute13 ,
614 apss.global_attribute14 pvs_global_attribute14 ,
615 apss.global_attribute15 pvs_global_attribute15 ,
616 apss.global_attribute16 pvs_global_attribute16 ,
617 apss.global_attribute17 pvs_global_attribute17 ,
618 apss.global_attribute18 pvs_global_attribute18 ,
619 apss.global_attribute19 pvs_global_attribute19 ,
620 apss.global_attribute20 pvs_global_attribute20 ,
621 ipay.int_eft_swift_code bk_eft_swift_code ,
622 ipay.ext_branch_number sbk_bank_branch_number ,
623 ipay.ext_bank_branch_name sbk_bank_branch_name ,
624 ebl.address1 sbk_address_line1 ,
625 ebl.address2 sbk_address_line2 ,
626 ebl.address3 sbk_address_line3 ,
627 ebl.city sbk_city ,
628 ebl.state sbk_state ,
629 ebl.postal_code sbk_zip ,
630 ebl.province sbk_province ,
631 ebl.country sbk_country ,
632 ipay.ext_eft_swift_code sbk_eft_swift_code ,
633 hr.location_code bill_to_int_location_name ,
634 hr.address_line_1 bill_to_int_address1 ,
635 hr.address_line_2 bill_to_int_address2 ,
636 hr.address_line_3 bill_to_int_address3 ,
637 hr.town_or_city bill_to_int_city ,
638 hr.postal_code bill_to_int_postal_code ,
639 hr.country bill_to_int_country ,
640 ipay.payer_tax_registration_num fi_vat_registration_num ,
641 hr.location_id bill_to_int_location_id ,
642 hr.ece_tp_location_code ece_tp_location_code ,
643 hr.region_1 bill_to_int_region1 ,
644 hr.region_2 bill_to_int_region2 ,
645 hr.region_3 bill_to_int_region3 ,
646 bktpd.map_id map_id ,
647 ipay.payment_due_date future_pay_due_date ,
648 aps.vendor_name_alt vendor_alternate_name ,
649 apss.vendor_site_code_alt vendor_alternate_site_code ,
650 ipay.uri_check_digit supplier_check_digits ,
651 ipay.ext_bank_name sbk_bank_name ,
652 ipay.int_bank_account_iban iban_number ,
653 ipay.ext_bank_account_iban_number vendor_iban_number ,
654 ipm.attribute1 payment_mean ,
655 ipm.attribute2 payment_channel ,
656 aps.vendor_id vendor_id ,
657 apss.vendor_site_id vendor_site_id ,
658 ipay.payment_reference_number payment_reference_number ,
659 bapr.bank_code sbk_bank_code ,
660 ipay.PAYMENT_PROCESS_REQUEST_NAME PAYMENT_PROCESS_REQUEST_NAME,
661 ipay.ORG_ID PAYMENT_ORG_ID ,
662 ipay.INT_BANK_NAME BANK_NAME ,
663 ipay.INT_BANK_BRANCH_NUMBER BRANCH_NUMBER ,
664 cba.BANK_ACCOUNT_ID BANK_ACCOUNT_ID ,
665 cba.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME ,
666 cba.ATTRIBUTE_CATEGORY BK_ACCT_ATTRIBUTE_CATEGORY ,
667 cba.ATTRIBUTE1 BK_ACCT_ATTRIBUTE1 ,
668 cba.ATTRIBUTE2 BK_ACCT_ATTRIBUTE2 ,
669 cba.ATTRIBUTE3 BK_ACCT_ATTRIBUTE3 ,
670 cba.ATTRIBUTE4 BK_ACCT_ATTRIBUTE4 ,
671 cba.ATTRIBUTE5 BK_ACCT_ATTRIBUTE5 ,
672 cba.ATTRIBUTE6 BK_ACCT_ATTRIBUTE6 ,
673 cba.ATTRIBUTE7 BK_ACCT_ATTRIBUTE7 ,
674 cba.ATTRIBUTE8 BK_ACCT_ATTRIBUTE8 ,
675 cba.ATTRIBUTE9 BK_ACCT_ATTRIBUTE9 ,
676 cba.ATTRIBUTE10 BK_ACCT_ATTRIBUTE10 ,
677 cba.ATTRIBUTE11 BK_ACCT_ATTRIBUTE11 ,
678 cba.ATTRIBUTE12 BK_ACCT_ATTRIBUTE12 ,
679 cba.ATTRIBUTE13 BK_ACCT_ATTRIBUTE13 ,
680 cba.ATTRIBUTE14 BK_ACCT_ATTRIBUTE14 ,
681 cba.ATTRIBUTE15 BK_ACCT_ATTRIBUTE15 ,
682 ieba.EXT_BANK_ACCOUNT_ID VENDOR_BANK_ACCOUNT_ID ,
683 ieba.ATTRIBUTE_CATEGORY SBK_ACCT_ATTRIBUTE_CATEGORY ,
684 ieba.ATTRIBUTE1 SBK_ACCT_ATTRIBUTE1 ,
685 ieba.ATTRIBUTE2 SBK_ACCT_ATTRIBUTE2 ,
686 ieba.ATTRIBUTE3 SBK_ACCT_ATTRIBUTE3 ,
687 ieba.ATTRIBUTE4 SBK_ACCT_ATTRIBUTE4 ,
688 ieba.ATTRIBUTE5 SBK_ACCT_ATTRIBUTE5 ,
689 ieba.ATTRIBUTE6 SBK_ACCT_ATTRIBUTE6 ,
690 ieba.ATTRIBUTE7 SBK_ACCT_ATTRIBUTE7 ,
691 ieba.ATTRIBUTE8 SBK_ACCT_ATTRIBUTE8 ,
692 ieba.ATTRIBUTE9 SBK_ACCT_ATTRIBUTE9 ,
693 ieba.ATTRIBUTE10 SBK_ACCT_ATTRIBUTE10 ,
694 ieba.ATTRIBUTE11 SBK_ACCT_ATTRIBUTE11 ,
695 ieba.ATTRIBUTE12 SBK_ACCT_ATTRIBUTE12 ,
696 ieba.ATTRIBUTE13 SBK_ACCT_ATTRIBUTE13 ,
697 ieba.ATTRIBUTE14 SBK_ACCT_ATTRIBUTE14 ,
698 ieba.ATTRIBUTE15 SBK_ACCT_ATTRIBUTE15 ,
699 apss.COUNTY VEND_SITE_COUNTY ,
700 apss.ATTRIBUTE_CATEGORY VEND_SITE_ATTRIBUTE_CATEGORY,
701 apss.ATTRIBUTE1 VEND_SITE_ATTRIBUTE1 ,
702 apss.ATTRIBUTE2 VEND_SITE_ATTRIBUTE2 ,
703 apss.ATTRIBUTE3 VEND_SITE_ATTRIBUTE3 ,
704 apss.ATTRIBUTE4 VEND_SITE_ATTRIBUTE4 ,
705 apss.ATTRIBUTE5 VEND_SITE_ATTRIBUTE5 ,
706 apss.ATTRIBUTE6 VEND_SITE_ATTRIBUTE6 ,
707 apss.ATTRIBUTE7 VEND_SITE_ATTRIBUTE7 ,
708 apss.ATTRIBUTE8 VEND_SITE_ATTRIBUTE8 ,
709 apss.ATTRIBUTE9 VEND_SITE_ATTRIBUTE9 ,
710 apss.ATTRIBUTE10 VEND_SITE_ATTRIBUTE10 ,
711 apss.ATTRIBUTE11 VEND_SITE_ATTRIBUTE11 ,
712 apss.ATTRIBUTE12 VEND_SITE_ATTRIBUTE12 ,
713 apss.ATTRIBUTE13 VEND_SITE_ATTRIBUTE13 ,
714 apss.ATTRIBUTE14 VEND_SITE_ATTRIBUTE14 ,
715 apss.ATTRIBUTE15 VEND_SITE_ATTRIBUTE15 ,
716 aps.VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE ,
717 aps.ATTRIBUTE_CATEGORY VENDOR_ATTRIBUTE_CATEGORY ,
718 aps.ATTRIBUTE1 VENDOR_ATTRIBUTE1 ,
719 aps.ATTRIBUTE2 VENDOR_ATTRIBUTE2 ,
720 aps.ATTRIBUTE3 VENDOR_ATTRIBUTE3 ,
721 aps.ATTRIBUTE4 VENDOR_ATTRIBUTE4 ,
722 aps.ATTRIBUTE5 VENDOR_ATTRIBUTE5 ,
723 aps.ATTRIBUTE6 VENDOR_ATTRIBUTE6 ,
724 aps.ATTRIBUTE7 VENDOR_ATTRIBUTE7 ,
725 aps.ATTRIBUTE8 VENDOR_ATTRIBUTE8 ,
726 aps.ATTRIBUTE9 VENDOR_ATTRIBUTE9 ,
727 aps.ATTRIBUTE10 VENDOR_ATTRIBUTE10 ,
728 aps.ATTRIBUTE11 VENDOR_ATTRIBUTE11 ,
729 aps.ATTRIBUTE12 VENDOR_ATTRIBUTE12 ,
730 aps.ATTRIBUTE13 VENDOR_ATTRIBUTE13 ,
731 aps.ATTRIBUTE14 VENDOR_ATTRIBUTE14 ,
732 aps.ATTRIBUTE15 VENDOR_ATTRIBUTE15
733 FROM iby_payments_all ipay,
734 ce_bank_accounts cba ,
735 ap_suppliers aps ,
736 ap_supplier_sites apss ,
737 hz_contact_points hcp ,
738 ece_tp_headers bktph ,
739 ece_tp_details bktpd ,
740 hr_locations hr ,
741 hz_locations ebl ,
742 hz_code_assignments hca ,
743 hz_locations ibl ,
744 hz_code_assignments hca1 ,
745 iby_payment_methods_b ipm ,
746 iby_ext_bank_accounts ieba ,
747 (SELECT party_id ,
748 bank_code
749 FROM hz_organization_profiles
750 WHERE sysdate >= effective_start_date
751 AND(effective_end_date IS NULL
752 OR effective_end_date > sysdate)
753 ) bapr,
754 financials_system_params_all fi
755 WHERE apss.vendor_site_id = ipay.supplier_site_id
756 AND cba.bank_account_id = ipay.internal_bank_account_id
757 AND apss.vendor_id = aps.vendor_id
758 AND bktph.tp_header_id = hcp.edi_tp_header_id
759 AND bktpd.tp_header_id = bktph.tp_header_id
760 AND bktpd.document_id = 'PYO'
761 AND hcp.owner_table_id = ipay.int_bank_branch_party_id
762 AND hcp.owner_table_name = 'HZ_PARTIES'
763 AND hcp.contact_point_type = 'EDI'
764 AND bktpd.edi_flag = 'Y'
765 AND ipay.org_id = fi.org_id
766 AND hr.location_id = fi.bill_to_location_id
767 AND ebl.location_id(+) = ipay.ext_bank_branch_location_id
768 AND hca.owner_table_id(+) = ipay.ext_bank_branch_party_id
769 AND hca.owner_table_name(+) = 'HZ_PARTIES'
770 AND hca.class_category(+) = 'BANK_BRANCH_TYPE'
771 AND hca.status(+) = 'A'
772 AND sysdate BETWEEN NVL(hca.start_date_active(+), sysdate -1) AND NVL(hca.end_date_active(+), sysdate + 1)
773 AND ibl.location_id(+) = ipay.int_bank_branch_location_id
774 AND hca1.owner_table_id(+) = ipay.int_bank_branch_party_id
775 AND hca1.owner_table_name(+) = 'HZ_PARTIES'
776 AND hca1.class_category(+) = 'BANK_BRANCH_TYPE'
777 AND hca1.status(+) = 'A'
778 AND sysdate BETWEEN NVL(hca1.start_date_active(+), sysdate -1) AND NVL(hca1.end_date_active(+), sysdate + 1)
779 AND ipay.payment_method_code = ipm.payment_method_code
780 AND ipay.external_bank_account_id = ieba.ext_bank_account_id(+)
781 AND ieba.branch_id = bapr.party_id(+)
782 AND ipay.payment_instruction_id = p_payment_instruction_id
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,
792 VENDOR_NUM,
793 CUSTOMER_NUM,
794 INVOICE_NUM,
795 INVOICE_DATE,
796 INVOICE_DESCRIPTION,
797 PROPOSED_PAYMENT_AMOUNT,
798 INVOICE_AMOUNT,
799 DISCOUNT_AMOUNT,
800 PRINT_SELECTED_CHECK_ID,
801 ATTRIBUTE_CATEGORY,
802 ATTRIBUTE1,
803 ATTRIBUTE2,
804 ATTRIBUTE3,
805 ATTRIBUTE4,
806 ATTRIBUTE5,
807 ATTRIBUTE6,
808 ATTRIBUTE7,
809 ATTRIBUTE8,
810 ATTRIBUTE9,
811 ATTRIBUTE10,
812 ATTRIBUTE11,
813 ATTRIBUTE12,
814 ATTRIBUTE13,
815 ATTRIBUTE14,
816 ATTRIBUTE15,
817 INV_GLOBAL_ATTRIBUTE_CATEGORY,
818 INV_GLOBAL_ATTRIBUTE1,
819 INV_GLOBAL_ATTRIBUTE2,
820 INV_GLOBAL_ATTRIBUTE3,
821 INV_GLOBAL_ATTRIBUTE4,
822 INV_GLOBAL_ATTRIBUTE5,
823 INV_GLOBAL_ATTRIBUTE6,
824 INV_GLOBAL_ATTRIBUTE7,
825 INV_GLOBAL_ATTRIBUTE8,
826 INV_GLOBAL_ATTRIBUTE9,
827 INV_GLOBAL_ATTRIBUTE10,
828 INV_GLOBAL_ATTRIBUTE11,
829 INV_GLOBAL_ATTRIBUTE12,
830 INV_GLOBAL_ATTRIBUTE13,
831 INV_GLOBAL_ATTRIBUTE14,
832 INV_GLOBAL_ATTRIBUTE15,
833 INV_GLOBAL_ATTRIBUTE16,
834 INV_GLOBAL_ATTRIBUTE17,
835 INV_GLOBAL_ATTRIBUTE18,
836 INV_GLOBAL_ATTRIBUTE19,
837 INV_GLOBAL_ATTRIBUTE20,
838 BANK_CHARGE_BEARER,
839 PAYMENT_REASON_CODE,
840 PAYMENT_REASON_COMMENTS,
841 REMITTANCE_MESSAGE1,
842 REMITTANCE_MESSAGE2,
843 REMITTANCE_MESSAGE3,
844 UNIQUE_REMITTANCE_IDENTIFIER,
845 URI_CHECK_DIGIT,
846 DELIVERY_CHANNEL_CODE,
847 SETTLEMENT_PRIORITY,
848 EXTERNAL_BANK_ACCOUNT_ID,
849 PAYMENT_METHOD_CODE,
850 VENDOR_ID,
851 VENDOR_SITE_ID,
852 PAYMENT_MEAN,
853 PAYMENT_CHANNEL,
854 COUNTRY,
855 PAYMENT_PROCESS_REQUEST_NAME,
856 BANK_ACCOUNT_ID,
857 VENDOR_BANK_ACCOUNT_ID,
858 PAYMENT_REFERENCE_NUMBER,
859 CHECK_NUMBER,
860 AMOUNT_WITHHELD,
861 CALLING_APP_ID,
862 CALLING_APP_DOC_UNIQUE_REF1,
863 CALLING_APP_DOC_UNIQUE_REF2,
864 CALLING_APP_DOC_UNIQUE_REF3,
865 CALLING_APP_DOC_UNIQUE_REF4,
866 CALLING_APP_DOC_UNIQUE_REF5,
867 document_sequence_id,
868 document_sequence_value,
869 document_category_code
870 )
871 SELECT idpa.payment_id payment_id
872 , ipa.payment_instruction_id payment_instruction_id
873 , NULL pay_selected_check_id
874 , ipa.payee_supplier_number vendor_num
875 , NULL customer_num
876 , idpa.calling_app_doc_ref_number invoice_num
877 , idpa.document_date invoice_date
878 , idpa.document_description invoice_description
879 , idpa.payment_amount proposed_payment_amount
880 , idpa.document_amount invoice_amount
881 , idpa.PAYMENT_CURR_DISCOUNT_TAKEN
882 , NULL print_selected_check_id
883 , idpa.attribute_category attribute_category
884 , idpa.attribute1 attribute1
885 , idpa.attribute2 attribute2
886 , idpa.attribute3 attribute3
887 , idpa.attribute4 attribute4
888 , idpa.attribute5 attribute5
889 , idpa.attribute6 attribute6
890 , idpa.attribute7 attribute7
891 , idpa.attribute8 attribute8
892 , idpa.attribute9 attribute9
893 , idpa.attribute10 attribute10
894 , idpa.attribute11 attribute11
895 , idpa.attribute12 attribute12
896 , idpa.attribute13 attribute13
897 , idpa.attribute14 attribute14
898 , idpa.attribute15 attribute15
899 , idpa.global_attribute_category inv_global_attribute_category
900 , idpa.global_attribute1 inv_global_attribute1
901 , idpa.global_attribute2 inv_global_attribute2
902 , idpa.global_attribute3 inv_global_attribute3
903 , idpa.global_attribute4 inv_global_attribute4
904 , idpa.global_attribute5 inv_global_attribute5
905 , idpa.global_attribute6 inv_global_attribute6
906 , idpa.global_attribute7 inv_global_attribute7
907 , idpa.global_attribute8 inv_global_attribute8
908 , idpa.global_attribute9 inv_global_attribute9
909 , idpa.global_attribute10 inv_global_attribute10
910 , idpa.global_attribute11 inv_global_attribute11
911 , idpa.global_attribute12 inv_global_attribute12
912 , idpa.global_attribute13 inv_global_attribute13
913 , idpa.global_attribute14 inv_global_attribute14
914 , idpa.global_attribute15 inv_global_attribute15
915 , idpa.global_attribute16 inv_global_attribute16
916 , idpa.global_attribute17 inv_global_attribute17
917 , idpa.global_attribute18 inv_global_attribute18
918 , idpa.global_attribute19 inv_global_attribute19
919 , idpa.global_attribute20 inv_global_attribute20
920 , idpa.bank_charge_bearer bank_charge_bearer
921 , idpa.payment_reason_code payment_reason_code
922 , idpa.payment_reason_comments payment_reason_comments
923 , idpa.remittance_message1 remittance_message1
924 , idpa.remittance_message2 remittance_message2
925 , idpa.remittance_message3 remittance_message3
926 , idpa.unique_remittance_identifier unique_remittance_identifier
927 , idpa.uri_check_digit uri_check_digit
928 , idpa.delivery_channel_code delivery_channel_code
929 , idpa.settlement_priority settlement_priority
930 , idpa.external_bank_account_id external_bank_account_id
931 , idpa.payment_method_code payment_method_code
932 , ipa.payee_supplier_id vendor_id
933 , ipa.supplier_site_id vendor_site_id
934 , ipm.attribute1 payment_mean
935 , ipm.attribute2 payment_channel
936 , ipa.payee_country country
937 , ipa.PAYMENT_PROCESS_REQUEST_NAME
938 , ipa.INTERNAL_BANK_ACCOUNT_ID
939 , ipa.EXTERNAL_BANK_ACCOUNT_ID
940 , ipa.PAYMENT_REFERENCE_NUMBER
941 , ipa.PAPER_DOCUMENT_NUMBER
942 , idpa.AMOUNT_WITHHELD
943 , idpa.CALLING_APP_ID
944 , idpa.CALLING_APP_DOC_UNIQUE_REF1
945 , idpa.CALLING_APP_DOC_UNIQUE_REF2
946 , idpa.CALLING_APP_DOC_UNIQUE_REF3
947 , idpa.CALLING_APP_DOC_UNIQUE_REF4
948 , idpa.CALLING_APP_DOC_UNIQUE_REF5
949 , idpa.document_sequence_id
950 , idpa.document_sequence_value
951 , idpa.document_category_code
952 FROM iby_docs_payable_all idpa
953 , iby_payments_all ipa
954 , iby_payment_methods_b ipm
955 WHERE idpa.payment_id = ipa.payment_id
956 AND idpa.payment_method_code = ipm.payment_method_code
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
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');
973 END delete_from_gt;
974
975 END ece_ap_payment;
976