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

Line 228: fnd_file.put_line(fnd_file.log, 'Operating unit ln_org_id is -> '||ln_org_id);

224: || Added by aiyer for the bug 5490479
225: || Get the operating unit (org_id)
226: */
227: ln_org_id := mo_global.get_current_org_id;
228: fnd_file.put_line(fnd_file.log, 'Operating unit ln_org_id is -> '||ln_org_id);
229:
230: /*End of bug 5490479 */
231: /* This is to identify the path in SQL TRACE file if any problem occured */
232: SELECT 'jai_rcv_third_party_pkg.process_pending_receipts' INTO lv_temp FROM DUAL;

Line 239: Fnd_File.put_line(Fnd_File.LOG, ' Debug Level 1 : Start of procedure jai_rcv_third_party_pkg.process_pending_receipts ');

235: fetch c_get_tp_batch_id into ln_batch_id;
236: close c_get_tp_batch_id;
237:
238: if p_debug >= 1 then
239: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 1 : Start of procedure jai_rcv_third_party_pkg.process_pending_receipts ****');
240: end if;
241:
242: /* Get all receipts where third party needs to be processed. Here only
243: RECEIVE or CORRECT to RECEIVE type of transactions are considered */

Line 264: Fnd_File.put_line(Fnd_File.LOG,

260: )
261:
262: loop
263:
264: Fnd_File.put_line(Fnd_File.LOG,
265: 'Debug Msg 1 : Inside org definition and processing org '||
266: c_sel_org.organization_id);
267:
268:

Line 354: Fnd_File.put_line(Fnd_File.LOG,

350: if ln_no_of_invoice_generated > 0 and nvl(p_simulation, 'N') <> 'Y' then
351:
352: /* Processing has created some invoices, invoking the payable open interface for their import */
353: if p_debug >= 1 then
354: Fnd_File.put_line(Fnd_File.LOG,
355: 'Debug Level 1 : Invoking APXIIMPT as no of invoices created is :'
356: || to_char(ln_no_of_invoice_generated) );
357: end if;
358:

Line 393: Fnd_File.put_line(Fnd_File.LOG, ' Debug Level 1 : End of procedure jai_rcv_third_party_pkg.process_pending_receipts ');

389:
390: << exit_from_procedure >>
391:
392: if p_debug >= 1 then
393: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 1 : End of procedure jai_rcv_third_party_pkg.process_pending_receipts ****');
394: end if;
395:
396: return;
397:

Line 402: FND_FILE.put_line(FND_FILE.log, 'Error in jai_rcv_third_party_pkg.process_pending_receipts :'||sqlerrm);

398: exception
399: when others then
400: retcode := 2;
401: errbuf := 'jai_rcv_third_party_pkg.process_pending_receipts:' || sqlerrm;
402: FND_FILE.put_line(FND_FILE.log, 'Error in jai_rcv_third_party_pkg.process_pending_receipts :'||sqlerrm);
403: return;
404: end process_batch;
405: /****************************** End process_pending_receipts ****************************/
406:

Line 755: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||

751: select 'jai_rcv_third_party_pkg.process_receipt : shipment header - ' || to_char(p_shipment_header_id)
752: into lv_temp from dual;
753:
754: if p_debug >= 1 then
755: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||
756: 'Start of procedure jai_rcv_third_party_pkg.process_receipt for shipment header :' ||
757: to_char(p_shipment_header_id)
758: );
759: end if;

Line 782: Fnd_File.put_line(Fnd_File.LOG,

778:
779: if r_rcv_transactions.vendor_id is null then
780:
781: if p_debug >= 1 then
782: Fnd_File.put_line(Fnd_File.LOG,
783: ' Debug Level 1 : Details from rcv_transactions are not found for this shipment header, cannot process' );
784: end if;
785:
786: p_process_flag := 'E';

Line 806: Fnd_File.put_line(Fnd_File.LOG,

802: if nvl(ln_thirdparty_count, 0) = 0 then
803: /* Not an error condition, but no need to process */
804:
805: if p_debug >= 1 then
806: Fnd_File.put_line(Fnd_File.LOG,
807: ' Debug Level 1 : There does not exist any third party tax for this shipment, no need to process' );
808: end if;
809:
810: goto exit_from_procedure;

Line 827: Fnd_File.put_line(Fnd_File.LOG,

823:
824: if nvl(ln_thirdparty_null_site_cnt, 0) > 0 then
825:
826: if p_debug >= 1 then
827: Fnd_File.put_line(Fnd_File.LOG,
828: ' Debug Level 1 : Error : Third party tax for this shipment exists without site, cannot process ' );
829: end if;
830:
831: p_process_flag := 'E';

Line 850: Fnd_File.put_line(Fnd_File.LOG,

846:
847: if nvl(ln_tparty_invalid_comb_cnt, 0) > 0 then
848:
849: if p_debug >= 1 then
850: Fnd_File.put_line(Fnd_File.LOG,
851: ' Debug Level 1 : Error : ' ||
852: 'Third party tax for this shipment exists with invalid vendor and site combination, cannot process ' );
853: end if;
854:

Line 951: Fnd_File.put_line(Fnd_File.LOG, ' ');

947: -- , NVL(jcta.inclusive_tax_flag,'N') --deleted by eric for bug#6997730 on Apr-24,2008
948: having sum(nvl(jrtv.tax_amount,0)) > 0 /* added to take care of complete CORRECTION */
949: )
950: loop
951: Fnd_File.put_line(Fnd_File.LOG, ' ');
952: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop Begin');
953: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : c_thirdparty_tax_rec.vendor_id,c_thirdparty_tax_rec.vendor_site_id,c_thirdparty_tax_rec.currency,c_thirdparty_tax_rec.inc_tax_flag :'
954: || c_thirdparty_tax_rec.vendor_id ||' , '||c_thirdparty_tax_rec.vendor_site_id ||' , '||c_thirdparty_tax_rec.currency ||' , '||c_thirdparty_tax_rec.inc_tax_flag );
955: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : ln_vendor_id,ln_vendor_site,lv_currency :'|| ln_vendor_id||' , '||ln_vendor_site||' , '||lv_currency );

Line 952: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop Begin');

948: having sum(nvl(jrtv.tax_amount,0)) > 0 /* added to take care of complete CORRECTION */
949: )
950: loop
951: Fnd_File.put_line(Fnd_File.LOG, ' ');
952: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop Begin');
953: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : c_thirdparty_tax_rec.vendor_id,c_thirdparty_tax_rec.vendor_site_id,c_thirdparty_tax_rec.currency,c_thirdparty_tax_rec.inc_tax_flag :'
954: || c_thirdparty_tax_rec.vendor_id ||' , '||c_thirdparty_tax_rec.vendor_site_id ||' , '||c_thirdparty_tax_rec.currency ||' , '||c_thirdparty_tax_rec.inc_tax_flag );
955: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : ln_vendor_id,ln_vendor_site,lv_currency :'|| ln_vendor_id||' , '||ln_vendor_site||' , '||lv_currency );
956:

Line 953: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : c_thirdparty_tax_rec.vendor_id,c_thirdparty_tax_rec.vendor_site_id,c_thirdparty_tax_rec.currency,c_thirdparty_tax_rec.inc_tax_flag :'

949: )
950: loop
951: Fnd_File.put_line(Fnd_File.LOG, ' ');
952: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop Begin');
953: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : c_thirdparty_tax_rec.vendor_id,c_thirdparty_tax_rec.vendor_site_id,c_thirdparty_tax_rec.currency,c_thirdparty_tax_rec.inc_tax_flag :'
954: || c_thirdparty_tax_rec.vendor_id ||' , '||c_thirdparty_tax_rec.vendor_site_id ||' , '||c_thirdparty_tax_rec.currency ||' , '||c_thirdparty_tax_rec.inc_tax_flag );
955: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : ln_vendor_id,ln_vendor_site,lv_currency :'|| ln_vendor_id||' , '||ln_vendor_site||' , '||lv_currency );
956:
957: IF ln_vendor_id <> c_thirdparty_tax_rec.vendor_id OR ln_vendor_site <> c_thirdparty_tax_rec.vendor_site_id OR lv_currency <> c_thirdparty_tax_rec.currency

Line 955: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : ln_vendor_id,ln_vendor_site,lv_currency :'|| ln_vendor_id||' , '||ln_vendor_site||' , '||lv_currency );

951: Fnd_File.put_line(Fnd_File.LOG, ' ');
952: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop Begin');
953: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : c_thirdparty_tax_rec.vendor_id,c_thirdparty_tax_rec.vendor_site_id,c_thirdparty_tax_rec.currency,c_thirdparty_tax_rec.inc_tax_flag :'
954: || c_thirdparty_tax_rec.vendor_id ||' , '||c_thirdparty_tax_rec.vendor_site_id ||' , '||c_thirdparty_tax_rec.currency ||' , '||c_thirdparty_tax_rec.inc_tax_flag );
955: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : ln_vendor_id,ln_vendor_site,lv_currency :'|| ln_vendor_id||' , '||ln_vendor_site||' , '||lv_currency );
956:
957: IF ln_vendor_id <> c_thirdparty_tax_rec.vendor_id OR ln_vendor_site <> c_thirdparty_tax_rec.vendor_site_id OR lv_currency <> c_thirdparty_tax_rec.currency
958: THEN
959: lv_vendor_has_changed := 'TRUE';

Line 968: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_vendor_has_changed :'|| lv_vendor_has_changed );

964: ELSE
965: lv_vendor_has_changed := 'FALSE';
966: END IF;
967:
968: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_vendor_has_changed :'|| lv_vendor_has_changed );
969:
970: if lv_vendor_has_changed = 'TRUE' THEN
971:
972: lv_description := null;

Line 1004: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an exclusive tax.Only one AP invoice will be created');

1000: -----------------------------------------------------------------------
1001: IF (c_thirdparty_tax_rec.inc_tax_flag = 'N') --exclusive tax case
1002: THEN
1003: ln_lines_to_insert :=1 ;
1004: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an exclusive tax.Only one AP invoice will be created');
1005: ELSE
1006: ln_lines_to_insert :=2 ;
1007: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an inclusive tax. Two AP invoices will be created');
1008: END IF;--(c_thirdparty_tax_rec.inc_tax_flag = 'N')

Line 1007: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an inclusive tax. Two AP invoices will be created');

1003: ln_lines_to_insert :=1 ;
1004: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an exclusive tax.Only one AP invoice will be created');
1005: ELSE
1006: ln_lines_to_insert :=2 ;
1007: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an inclusive tax. Two AP invoices will be created');
1008: END IF;--(c_thirdparty_tax_rec.inc_tax_flag = 'N')
1009:
1010: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :c_thirdparty_tax_rec.inc_tax_flag :'|| c_thirdparty_tax_rec.inc_tax_flag);
1011: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :ln_lines_to_insert: ' || ln_lines_to_insert );

Line 1010: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :c_thirdparty_tax_rec.inc_tax_flag :'|| c_thirdparty_tax_rec.inc_tax_flag);

1006: ln_lines_to_insert :=2 ;
1007: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an inclusive tax. Two AP invoices will be created');
1008: END IF;--(c_thirdparty_tax_rec.inc_tax_flag = 'N')
1009:
1010: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :c_thirdparty_tax_rec.inc_tax_flag :'|| c_thirdparty_tax_rec.inc_tax_flag);
1011: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :ln_lines_to_insert: ' || ln_lines_to_insert );
1012: Fnd_File.put_line(Fnd_File.LOG, ' ');
1013:
1014: FOR i in 1 .. ln_lines_to_insert

Line 1011: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :ln_lines_to_insert: ' || ln_lines_to_insert );

1007: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an inclusive tax. Two AP invoices will be created');
1008: END IF;--(c_thirdparty_tax_rec.inc_tax_flag = 'N')
1009:
1010: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :c_thirdparty_tax_rec.inc_tax_flag :'|| c_thirdparty_tax_rec.inc_tax_flag);
1011: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :ln_lines_to_insert: ' || ln_lines_to_insert );
1012: Fnd_File.put_line(Fnd_File.LOG, ' ');
1013:
1014: FOR i in 1 .. ln_lines_to_insert
1015: LOOP

Line 1012: Fnd_File.put_line(Fnd_File.LOG, ' ');

1008: END IF;--(c_thirdparty_tax_rec.inc_tax_flag = 'N')
1009:
1010: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :c_thirdparty_tax_rec.inc_tax_flag :'|| c_thirdparty_tax_rec.inc_tax_flag);
1011: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :ln_lines_to_insert: ' || ln_lines_to_insert );
1012: Fnd_File.put_line(Fnd_File.LOG, ' ');
1013:
1014: FOR i in 1 .. ln_lines_to_insert
1015: LOOP
1016: -----------------------------------------------------------------------

Line 1032: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num begin:');

1028:
1029:
1030: --added by eric for inclusive tax on 20-dec,2007, Begin
1031: -----------------------------------------------------------------------
1032: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num begin:');
1033: IF (i =1 ) --normal third party invoice
1034: THEN
1035: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch :');
1036:

Line 1035: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch :');

1031: -----------------------------------------------------------------------
1032: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num begin:');
1033: IF (i =1 ) --normal third party invoice
1034: THEN
1035: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch :');
1036:
1037:
1038: lv_description := 'Invoice for vendor '
1039: || r_get_vendor_details.vendor_name

Line 1044: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_description :' || lv_description);

1040: ||' against receipt no. '|| lv_receipt_num;
1041: lv_invoice_num := 'RECEIPT/'||lv_receipt_num || '/'
1042: || to_char(ln_inv_run_no);
1043:
1044: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_description :' || lv_description);
1045: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_invoice_num :' || lv_invoice_num);
1046: ELSE --(i =2 ),normal third party invoice--debit memo invoice
1047: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : i =2 Branch :');
1048:

Line 1045: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_invoice_num :' || lv_invoice_num);

1041: lv_invoice_num := 'RECEIPT/'||lv_receipt_num || '/'
1042: || to_char(ln_inv_run_no);
1043:
1044: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_description :' || lv_description);
1045: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_invoice_num :' || lv_invoice_num);
1046: ELSE --(i =2 ),normal third party invoice--debit memo invoice
1047: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : i =2 Branch :');
1048:
1049: lv_description := 'Credit Memo for inclusive 3rd party taxes for'

Line 1047: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : i =2 Branch :');

1043:
1044: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_description :' || lv_description);
1045: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_invoice_num :' || lv_invoice_num);
1046: ELSE --(i =2 ),normal third party invoice--debit memo invoice
1047: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : i =2 Branch :');
1048:
1049: lv_description := 'Credit Memo for inclusive 3rd party taxes for'
1050: ||' receipt No. ' || lv_receipt_num;
1051: lv_invoice_num := 'ITP-CM/'|| lv_receipt_num || '/'

Line 1054: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_description :' || lv_description);

1050: ||' receipt No. ' || lv_receipt_num;
1051: lv_invoice_num := 'ITP-CM/'|| lv_receipt_num || '/'
1052: ||to_char(ln_inv_run_no);
1053:
1054: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_description :' || lv_description);
1055: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_invoice_num :' || lv_invoice_num);
1056: END IF;--(i =1 )
1057:
1058: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num end:');

Line 1055: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_invoice_num :' || lv_invoice_num);

1051: lv_invoice_num := 'ITP-CM/'|| lv_receipt_num || '/'
1052: ||to_char(ln_inv_run_no);
1053:
1054: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_description :' || lv_description);
1055: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_invoice_num :' || lv_invoice_num);
1056: END IF;--(i =1 )
1057:
1058: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num end:');
1059: Fnd_File.put_line(Fnd_File.LOG, ' ');

Line 1058: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num end:');

1054: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_description :' || lv_description);
1055: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_invoice_num :' || lv_invoice_num);
1056: END IF;--(i =1 )
1057:
1058: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num end:');
1059: Fnd_File.put_line(Fnd_File.LOG, ' ');
1060: -----------------------------------------------------------------------
1061: --added by eric for inclusive tax on 20-dec,2007, end
1062:

Line 1059: Fnd_File.put_line(Fnd_File.LOG, ' ');

1055: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_invoice_num :' || lv_invoice_num);
1056: END IF;--(i =1 )
1057:
1058: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num end:');
1059: Fnd_File.put_line(Fnd_File.LOG, ' ');
1060: -----------------------------------------------------------------------
1061: --added by eric for inclusive tax on 20-dec,2007, end
1062:
1063:

Line 1090: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : jai_rcv_tp_invoice stable insert beign:');

1086: --added by eric for inclusive tax on 20-dec,2007, Begin
1087: -----------------------------------------------------------------------
1088: IF (i =1 )
1089: THEN
1090: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : jai_rcv_tp_invoice stable insert beign:');
1091: -----------------------------------------------------------------------
1092: --added by eric for inclusive tax on 20-dec,2007, end
1093: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,jai_rcv_tp_invoice table insert : i =1 Branch :');
1094: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1. Before insert into jai_rcv_tp_invoices ' );

Line 1093: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,jai_rcv_tp_invoice table insert : i =1 Branch :');

1089: THEN
1090: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : jai_rcv_tp_invoice stable insert beign:');
1091: -----------------------------------------------------------------------
1092: --added by eric for inclusive tax on 20-dec,2007, end
1093: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,jai_rcv_tp_invoice table insert : i =1 Branch :');
1094: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1. Before insert into jai_rcv_tp_invoices ' );
1095:
1096:
1097: -- start for bug 13528285 by anupgupt

Line 1094: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1. Before insert into jai_rcv_tp_invoices ' );

1090: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : jai_rcv_tp_invoice stable insert beign:');
1091: -----------------------------------------------------------------------
1092: --added by eric for inclusive tax on 20-dec,2007, end
1093: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,jai_rcv_tp_invoice table insert : i =1 Branch :');
1094: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1. Before insert into jai_rcv_tp_invoices ' );
1095:
1096:
1097: -- start for bug 13528285 by anupgupt
1098: /* Code changes done to calculate third party invoice header amount as per the correction done on receipt */

Line 1133: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1.1. before apportion v_third_party_trans.transaction_id > '||v_third_party_trans.transaction_id

1129: SELECT transaction_type INTO v_transaction_type
1130: FROM jai_rcv_transactions
1131: WHERE transaction_id = v_third_party_trans.transaction_id;
1132:
1133: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1.1. before apportion v_third_party_trans.transaction_id > '||v_third_party_trans.transaction_id
1134: ||' > v_third_party_trans.tax_name > '||v_third_party_trans.tax_name||' > v_third_party_trans.tax_type > '||v_third_party_trans.tax_type ||' > v_third_party_trans.tax_amount > '
1135: ||v_third_party_trans.tax_amount||' > v_third_party_trans.adhoc_flag > '||v_third_party_trans.adhoc_flag||' > v_third_party_trans.vat_flag > '||v_third_party_trans.vat_flag
1136: ||' > v_third_party_trans.tax_type > '||v_third_party_trans.tax_type||' > v_transaction_type > '||v_transaction_type);
1137:

Line 1157: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1.2. apportioning v_corrected_quantity > '||v_corrected_quantity||' > v_original_quantity > '||v_original_quantity

1153:
1154: /* apportion tax amount based on before correction quantity and corrected quantity and add it to invoice header amount */
1155: ln_tax_amount := ln_tax_amount + v_third_party_trans.tax_amount * ((v_original_quantity + v_corrected_quantity) / v_original_quantity);
1156:
1157: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1.2. apportioning v_corrected_quantity > '||v_corrected_quantity||' > v_original_quantity > '||v_original_quantity
1158: ||' > tax_amount > '||v_third_party_trans.tax_amount * ((v_original_quantity + v_corrected_quantity) / v_original_quantity));
1159: ELSE
1160: /* as apportion is not required, add tax amount to invoice header amount */
1161: ln_tax_amount := ln_tax_amount + v_third_party_trans.tax_amount;

Line 1163: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1.3. after apportion v_third_party_trans.transaction_id > '||v_third_party_trans.transaction_id

1159: ELSE
1160: /* as apportion is not required, add tax amount to invoice header amount */
1161: ln_tax_amount := ln_tax_amount + v_third_party_trans.tax_amount;
1162: END IF;
1163: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1.3. after apportion v_third_party_trans.transaction_id > '||v_third_party_trans.transaction_id
1164: ||' > v_third_party_trans.tax_name > '||v_third_party_trans.tax_name||' > v_third_party_trans.tax_type > '||v_third_party_trans.tax_type ||' > ln_tax_amount > '||ln_tax_amount);
1165: END LOOP;
1166: END;
1167: -- end for bug 13528285 by anupgupt

Line 1210: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );

1206: fnd_profile.value('CONC_LOGIN_ID'),
1207: fnd_profile.value('CONC_REQUEST_ID')
1208: );
1209:
1210: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );
1211: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :jai_rcv_tp_invoice table insert end:');
1212: Fnd_File.put_line(Fnd_File.LOG, ' ');
1213: --added by eric for inclusive tax on 20-dec,2007, Begin
1214: -----------------------------------------------------------------------

Line 1211: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :jai_rcv_tp_invoice table insert end:');

1207: fnd_profile.value('CONC_REQUEST_ID')
1208: );
1209:
1210: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );
1211: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :jai_rcv_tp_invoice table insert end:');
1212: Fnd_File.put_line(Fnd_File.LOG, ' ');
1213: --added by eric for inclusive tax on 20-dec,2007, Begin
1214: -----------------------------------------------------------------------
1215: END IF;--(i =1 )

Line 1212: Fnd_File.put_line(Fnd_File.LOG, ' ');

1208: );
1209:
1210: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );
1211: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :jai_rcv_tp_invoice table insert end:');
1212: Fnd_File.put_line(Fnd_File.LOG, ' ');
1213: --added by eric for inclusive tax on 20-dec,2007, Begin
1214: -----------------------------------------------------------------------
1215: END IF;--(i =1 )
1216: -----------------------------------------------------------------------

Line 1230: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : insertface table insert begin:');

1226: --Ap invoice interface table need to be inserted twice if necessary
1227: --the first time is for the normal third party inv
1228: --the second time is for the credit memo ,in case of inclusive tax
1229:
1230: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : insertface table insert begin:');
1231:
1232: --added by eric for inclusive tax on 20-dec,2007, Begin
1233: -----------------------------------------------------------------------
1234: IF (i =1 )

Line 1238: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,insertface table : i =1 Branch :');

1234: IF (i =1 )
1235: THEN
1236: -----------------------------------------------------------------------
1237: --added by eric for inclusive tax on 20-dec,2007, end
1238: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,insertface table : i =1 Branch :');
1239: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 3. Before insert into insert_ap_inv_interface for Standard Invoice' );
1240:
1241: jai_ap_utils_pkg.insert_ap_inv_interface
1242: (

Line 1239: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 3. Before insert into insert_ap_inv_interface for Standard Invoice' );

1235: THEN
1236: -----------------------------------------------------------------------
1237: --added by eric for inclusive tax on 20-dec,2007, end
1238: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,insertface table : i =1 Branch :');
1239: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 3. Before insert into insert_ap_inv_interface for Standard Invoice' );
1240:
1241: jai_ap_utils_pkg.insert_ap_inv_interface
1242: (
1243: p_jai_source => 'Third Party Invoices',

Line 1270: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 4. After insert Standard third party Invoice :' || lv_invoice_num ||' into insert_ap_inv_interface');

1266: p_last_update_login => null,
1267: p_org_id => ln_org_id -- added by csahoo for bug#6139899
1268: );
1269:
1270: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 4. After insert Standard third party Invoice :' || lv_invoice_num ||' into insert_ap_inv_interface');
1271: --added by eric for inclusive tax on 20-dec,2007, Begin
1272: -----------------------------------------------------------------------
1273: ELSIF (i =2 )
1274: THEN

Line 1275: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,insertface table : i =2 Branch :');

1271: --added by eric for inclusive tax on 20-dec,2007, Begin
1272: -----------------------------------------------------------------------
1273: ELSIF (i =2 )
1274: THEN
1275: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,insertface table : i =2 Branch :');
1276: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 5. Before insert into insert_ap_inv_interface for CM ' );
1277:
1278: --added by eric for BUG#6988610 on Apr-24,2008, Begin
1279: -----------------------------------------------------------------------

Line 1276: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 5. Before insert into insert_ap_inv_interface for CM ' );

1272: -----------------------------------------------------------------------
1273: ELSIF (i =2 )
1274: THEN
1275: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,insertface table : i =2 Branch :');
1276: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 5. Before insert into insert_ap_inv_interface for CM ' );
1277:
1278: --added by eric for BUG#6988610 on Apr-24,2008, Begin
1279: -----------------------------------------------------------------------
1280: OPEN get_totl_incl_tax_amount

Line 1354: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 6. After insert Credit Memo of third party Invoice :' || lv_invoice_num ||' into insert_ap_inv_interface');

1350: p_last_update_login => null,
1351: p_org_id => ln_org_id -- added by csahoo for bug#6139899
1352: );
1353:
1354: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 6. After insert Credit Memo of third party Invoice :' || lv_invoice_num ||' into insert_ap_inv_interface');
1355: --added by eric for inclusive tax on 20-dec,2007, Begin
1356: -----------------------------------------------------------------------
1357: END IF; --(i =1 )
1358: -----------------------------------------------------------------------

Line 1359: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : insertface table insert end:');

1355: --added by eric for inclusive tax on 20-dec,2007, Begin
1356: -----------------------------------------------------------------------
1357: END IF; --(i =1 )
1358: -----------------------------------------------------------------------
1359: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : insertface table insert end:');
1360: Fnd_File.put_line(Fnd_File.LOG, ' ');
1361: --added by eric for inclusive tax on 20-dec,2007, end
1362: end if; /* if p_simulation <> 'Y' then */
1363:

Line 1360: Fnd_File.put_line(Fnd_File.LOG, ' ');

1356: -----------------------------------------------------------------------
1357: END IF; --(i =1 )
1358: -----------------------------------------------------------------------
1359: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : insertface table insert end:');
1360: Fnd_File.put_line(Fnd_File.LOG, ' ');
1361: --added by eric for inclusive tax on 20-dec,2007, end
1362: end if; /* if p_simulation <> 'Y' then */
1363:
1364:

Line 1419: Fnd_File.put_line(Fnd_File.LOG, ' ');

1415: AND jrlt.tax_id = jcta.tax_id --added by eric for inclusive tax
1416: )
1417: LOOP
1418:
1419: Fnd_File.put_line(Fnd_File.LOG, ' ');
1420: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop Begin');
1421: --SELECT jai_rcv_tp_inv_details_s.nextval INTO ln_batch_line_id FROM DUAL;
1422:
1423: --tax table need to be populated once only

Line 1420: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop Begin');

1416: )
1417: LOOP
1418:
1419: Fnd_File.put_line(Fnd_File.LOG, ' ');
1420: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop Begin');
1421: --SELECT jai_rcv_tp_inv_details_s.nextval INTO ln_batch_line_id FROM DUAL;
1422:
1423: --tax table need to be populated once only
1424: --added by eric for inclusive tax on 20-dec,2007, Begin

Line 1430: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 3 ,jai_rcv_tp_inv_details table : i =1 Branch :');

1426: IF (i =1 )
1427: THEN
1428: -----------------------------------------------------------------------
1429: --added by eric for inclusive tax on 20-dec,2007, end
1430: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 3 ,jai_rcv_tp_inv_details table : i =1 Branch :');
1431: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7. Before insert into jai_rcv_tp_inv_details' );
1432:
1433: -- start for bug 13528285 by anupgupt
1434: /* code added to apportioning of third party invoice lines amounts based on correction of quantity in receipt*/

Line 1431: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7. Before insert into jai_rcv_tp_inv_details' );

1427: THEN
1428: -----------------------------------------------------------------------
1429: --added by eric for inclusive tax on 20-dec,2007, end
1430: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 3 ,jai_rcv_tp_inv_details table : i =1 Branch :');
1431: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7. Before insert into jai_rcv_tp_inv_details' );
1432:
1433: -- start for bug 13528285 by anupgupt
1434: /* code added to apportioning of third party invoice lines amounts based on correction of quantity in receipt*/
1435: DECLARE

Line 1447: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7.1. before apportion tax_rec.transaction_id > '||tax_rec.transaction_id||' > tax_rec.tax_name > '||tax_rec.tax_name||' > tax_rec.tax_type > '

1443: SELECT transaction_type INTO v_transaction_type
1444: FROM jai_rcv_transactions
1445: WHERE transaction_id = tax_rec.transaction_id;
1446:
1447: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7.1. before apportion tax_rec.transaction_id > '||tax_rec.transaction_id||' > tax_rec.tax_name > '||tax_rec.tax_name||' > tax_rec.tax_type > '
1448: ||tax_rec.tax_type ||' > tax_Rec.tax_amount > '||tax_Rec.tax_amount||' > tax_rec.adhoc_flag > '||tax_rec.adhoc_flag||' > tax_rec.vat_flag > '||tax_rec.vat_flag||' > tax_rec.tax_type > '||tax_rec.tax_type
1449: ||' > v_transaction_type > '||v_transaction_type);
1450:
1451: /* check if tax line is applicable for apportioning */

Line 1469: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7.2. apportioning v_corrected_quantity > '||v_corrected_quantity||' > v_original_quantity > '||v_original_quantity||' > tax_Rec.tax_amount > '||tax_Rec.tax_amount);

1465: AND transaction_type = lv_ttype_correct;
1466:
1467: /* apportion tax amount based on quantity of receive before correction and quantity correccted */
1468: tax_Rec.tax_amount := tax_Rec.tax_amount * ((v_original_quantity + v_corrected_quantity) / v_original_quantity);
1469: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7.2. apportioning v_corrected_quantity > '||v_corrected_quantity||' > v_original_quantity > '||v_original_quantity||' > tax_Rec.tax_amount > '||tax_Rec.tax_amount);
1470: END IF;
1471: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7.3. after apportion tax_rec.transaction_id > '||tax_rec.transaction_id||' > tax_rec.tax_name > '||tax_rec.tax_name||' > tax_rec.tax_type > '
1472: ||tax_rec.tax_type ||' > tax_Rec.tax_amount > '||tax_Rec.tax_amount);
1473: END;

Line 1471: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7.3. after apportion tax_rec.transaction_id > '||tax_rec.transaction_id||' > tax_rec.tax_name > '||tax_rec.tax_name||' > tax_rec.tax_type > '

1467: /* apportion tax amount based on quantity of receive before correction and quantity correccted */
1468: tax_Rec.tax_amount := tax_Rec.tax_amount * ((v_original_quantity + v_corrected_quantity) / v_original_quantity);
1469: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7.2. apportioning v_corrected_quantity > '||v_corrected_quantity||' > v_original_quantity > '||v_original_quantity||' > tax_Rec.tax_amount > '||tax_Rec.tax_amount);
1470: END IF;
1471: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7.3. after apportion tax_rec.transaction_id > '||tax_rec.transaction_id||' > tax_rec.tax_name > '||tax_rec.tax_name||' > tax_rec.tax_type > '
1472: ||tax_rec.tax_type ||' > tax_Rec.tax_amount > '||tax_Rec.tax_amount);
1473: END;
1474: -- end for bug 13528285 by anupgupt
1475:

Line 1509: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 8. After insert into jai_rcv_tp_inv_details' );

1505: sysdate ,
1506: fnd_global.user_id ,
1507: fnd_global.login_id
1508: ) returning BATCH_LINE_ID into ln_BATCH_LINE_ID;
1509: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 8. After insert into jai_rcv_tp_inv_details' );
1510: --added by eric for inclusive tax on 20-dec,2007, Begin
1511: -----------------------------------------------------------------------
1512: END IF; --(i =1 )
1513: -----------------------------------------------------------------------

Line 1567: Fnd_File.put_line(Fnd_File.LOG, 'Interim Acct CCID for the Transaction id ' || Tax_rec.transaction_id ||' is: '||ln_accrual_account);

1563: p_tax_type => tax_rec.tax_type,
1564: p_account_name => jai_constants.recovery_interim
1565: );
1566:
1567: Fnd_File.put_line(Fnd_File.LOG, 'Interim Acct CCID for the Transaction id ' || Tax_rec.transaction_id ||' is: '||ln_accrual_account);
1568: END IF;
1569: /* end of changes for bug 8238608 */
1570:
1571: jai_ap_utils_pkg.insert_ap_inv_lines_interface

Line 1593: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 10. After insert into insert_ap_inv_lines_interface' );

1589: p_last_update_date => sysdate,
1590: p_last_update_login => null,
1591: p_org_id => ln_org_id -- added by csahoo for bug#139899
1592: );
1593: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 10. After insert into insert_ap_inv_lines_interface' );
1594: --added by eric for bug 6971486 on 20-Apr,2008, Begin
1595: -----------------------------------------------------------------------
1596: ln_line_number:=ln_line_number+1; /* added by vumaasha for bug 8965721 */
1597: END IF;

Line 1605: Fnd_File.put_line(Fnd_File.LOG, ' ');

1601: ln_line_number := 1; /* modified by vumaasha for bug 8965721 */
1602: --Added by eric for inclusive tax on Dec 14,2007 Begin
1603: ------------------------------------------------------------------------------
1604:
1605: Fnd_File.put_line(Fnd_File.LOG, ' ');
1606: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop end');
1607: END LOOP;--( i in 1 .. ln_lines_to_insert)
1608: END IF; /* END IF FOR if lv_vendor_has_changed = 'TRUE' THEN */
1609: ------------------------------------------------------------------------------

Line 1606: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop end');

1602: --Added by eric for inclusive tax on Dec 14,2007 Begin
1603: ------------------------------------------------------------------------------
1604:
1605: Fnd_File.put_line(Fnd_File.LOG, ' ');
1606: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop end');
1607: END LOOP;--( i in 1 .. ln_lines_to_insert)
1608: END IF; /* END IF FOR if lv_vendor_has_changed = 'TRUE' THEN */
1609: ------------------------------------------------------------------------------
1610: --Added by eric for inclusive tax on Dec 14,2007 End

Line 1611: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop end');

1607: END LOOP;--( i in 1 .. ln_lines_to_insert)
1608: END IF; /* END IF FOR if lv_vendor_has_changed = 'TRUE' THEN */
1609: ------------------------------------------------------------------------------
1610: --Added by eric for inclusive tax on Dec 14,2007 End
1611: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop end');
1612: Fnd_File.put_line(Fnd_File.LOG, ' ');
1613: end loop; --(For c_thirdparty_tax_rec IN)
1614:
1615:

Line 1612: Fnd_File.put_line(Fnd_File.LOG, ' ');

1608: END IF; /* END IF FOR if lv_vendor_has_changed = 'TRUE' THEN */
1609: ------------------------------------------------------------------------------
1610: --Added by eric for inclusive tax on Dec 14,2007 End
1611: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop end');
1612: Fnd_File.put_line(Fnd_File.LOG, ' ');
1613: end loop; --(For c_thirdparty_tax_rec IN)
1614:
1615:
1616: << exit_from_procedure >>

Line 1622: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||

1618: p_process_flag := 'Y';
1619: end if;
1620:
1621: if p_debug >= 1 then
1622: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||
1623: 'End of procedure jai_rcv_third_party_pkg.process_receipt for shipment header :' ||
1624: to_char(p_shipment_header_id)
1625: );
1626: end if;

Line 1634: fnd_file.put_line( fnd_file.log, '******** Error in '||p_process_message);

1630: exception
1631: when others then
1632: p_process_flag := 'E';
1633: p_process_message := 'jai_rcv_third_party_pkg.process_receipt:' || sqlerrm;
1634: fnd_file.put_line( fnd_file.log, '******** Error in '||p_process_message);
1635: raise;
1636:
1637: end process_receipt;
1638: /****************************** End process_receipt ****************************/