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 207: fnd_file.put_line(fnd_file.log, 'Operating unit ln_org_id is -> '||ln_org_id);

203: || Added by aiyer for the bug 5490479
204: || Get the operating unit (org_id)
205: */
206: ln_org_id := mo_global.get_current_org_id;
207: fnd_file.put_line(fnd_file.log, 'Operating unit ln_org_id is -> '||ln_org_id);
208:
209: /*End of bug 5490479 */
210: /* This is to identify the path in SQL TRACE file if any problem occured */
211: SELECT 'jai_rcv_third_party_pkg.process_pending_receipts' INTO lv_temp FROM DUAL;

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

214: fetch c_get_tp_batch_id into ln_batch_id;
215: close c_get_tp_batch_id;
216:
217: if p_debug >= 1 then
218: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 1 : Start of procedure jai_rcv_third_party_pkg.process_pending_receipts ****');
219: end if;
220:
221: /* Get all receipts where third party needs to be processed. Here only
222: RECEIVE or CORRECT to RECEIVE type of transactions are considered */

Line 243: Fnd_File.put_line(Fnd_File.LOG,

239: )
240:
241: loop
242:
243: Fnd_File.put_line(Fnd_File.LOG,
244: 'Debug Msg 1 : Inside org definition and processing org '||
245: c_sel_org.organization_id);
246:
247:

Line 333: Fnd_File.put_line(Fnd_File.LOG,

329: if ln_no_of_invoice_generated > 0 and nvl(p_simulation, 'N') <> 'Y' then
330:
331: /* Processing has created some invoices, invoking the payable open interface for their import */
332: if p_debug >= 1 then
333: Fnd_File.put_line(Fnd_File.LOG,
334: 'Debug Level 1 : Invoking APXIIMPT as no of invoices created is :'
335: || to_char(ln_no_of_invoice_generated) );
336: end if;
337:

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

368:
369: << exit_from_procedure >>
370:
371: if p_debug >= 1 then
372: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 1 : End of procedure jai_rcv_third_party_pkg.process_pending_receipts ****');
373: end if;
374:
375: return;
376:

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

377: exception
378: when others then
379: retcode := 2;
380: errbuf := 'jai_rcv_third_party_pkg.process_pending_receipts:' || sqlerrm;
381: FND_FILE.put_line(FND_FILE.log, 'Error in jai_rcv_third_party_pkg.process_pending_receipts :'||sqlerrm);
382: return;
383: end process_batch;
384: /****************************** End process_pending_receipts ****************************/
385:

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

709: select 'jai_rcv_third_party_pkg.process_receipt : shipment header - ' || to_char(p_shipment_header_id)
710: into lv_temp from dual;
711:
712: if p_debug >= 1 then
713: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||
714: 'Start of procedure jai_rcv_third_party_pkg.process_receipt for shipment header :' ||
715: to_char(p_shipment_header_id)
716: );
717: end if;

Line 740: Fnd_File.put_line(Fnd_File.LOG,

736:
737: if r_rcv_transactions.vendor_id is null then
738:
739: if p_debug >= 1 then
740: Fnd_File.put_line(Fnd_File.LOG,
741: ' Debug Level 1 : Details from rcv_transactions are not found for this shipment header, cannot process' );
742: end if;
743:
744: p_process_flag := 'E';

Line 764: Fnd_File.put_line(Fnd_File.LOG,

760: if nvl(ln_thirdparty_count, 0) = 0 then
761: /* Not an error condition, but no need to process */
762:
763: if p_debug >= 1 then
764: Fnd_File.put_line(Fnd_File.LOG,
765: ' Debug Level 1 : There does not exist any third party tax for this shipment, no need to process' );
766: end if;
767:
768: goto exit_from_procedure;

Line 785: Fnd_File.put_line(Fnd_File.LOG,

781:
782: if nvl(ln_thirdparty_null_site_cnt, 0) > 0 then
783:
784: if p_debug >= 1 then
785: Fnd_File.put_line(Fnd_File.LOG,
786: ' Debug Level 1 : Error : Third party tax for this shipment exists without site, cannot process ' );
787: end if;
788:
789: p_process_flag := 'E';

Line 808: Fnd_File.put_line(Fnd_File.LOG,

804:
805: if nvl(ln_tparty_invalid_comb_cnt, 0) > 0 then
806:
807: if p_debug >= 1 then
808: Fnd_File.put_line(Fnd_File.LOG,
809: ' Debug Level 1 : Error : ' ||
810: 'Third party tax for this shipment exists with invalid vendor and site combination, cannot process ' );
811: end if;
812:

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

905: -- , NVL(jcta.inclusive_tax_flag,'N') --deleted by eric for bug#6997730 on Apr-24,2008
906: having sum(nvl(jrtv.tax_amount,0)) > 0 /* added to take care of complete CORRECTION */
907: )
908: loop
909: Fnd_File.put_line(Fnd_File.LOG, ' ');
910: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop Begin');
911: 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 :'
912: || 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 );
913: 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 910: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop Begin');

906: having sum(nvl(jrtv.tax_amount,0)) > 0 /* added to take care of complete CORRECTION */
907: )
908: loop
909: Fnd_File.put_line(Fnd_File.LOG, ' ');
910: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop Begin');
911: 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 :'
912: || 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 );
913: 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 );
914:

Line 911: 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 :'

907: )
908: loop
909: Fnd_File.put_line(Fnd_File.LOG, ' ');
910: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop Begin');
911: 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 :'
912: || 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 );
913: 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 );
914:
915: 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 913: 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 );

909: Fnd_File.put_line(Fnd_File.LOG, ' ');
910: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop Begin');
911: 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 :'
912: || 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 );
913: 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 );
914:
915: 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
916: THEN
917: lv_vendor_has_changed := 'TRUE';

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

922: ELSE
923: lv_vendor_has_changed := 'FALSE';
924: END IF;
925:
926: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_vendor_has_changed :'|| lv_vendor_has_changed );
927:
928: if lv_vendor_has_changed = 'TRUE' THEN
929:
930: lv_description := null;

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

958: -----------------------------------------------------------------------
959: IF (c_thirdparty_tax_rec.inc_tax_flag = 'N') --exclusive tax case
960: THEN
961: ln_lines_to_insert :=1 ;
962: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an exclusive tax.Only one AP invoice will be created');
963: ELSE
964: ln_lines_to_insert :=2 ;
965: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an inclusive tax. Two AP invoices will be created');
966: END IF;--(c_thirdparty_tax_rec.inc_tax_flag = 'N')

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

961: ln_lines_to_insert :=1 ;
962: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an exclusive tax.Only one AP invoice will be created');
963: ELSE
964: ln_lines_to_insert :=2 ;
965: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an inclusive tax. Two AP invoices will be created');
966: END IF;--(c_thirdparty_tax_rec.inc_tax_flag = 'N')
967:
968: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :c_thirdparty_tax_rec.inc_tax_flag :'|| c_thirdparty_tax_rec.inc_tax_flag);
969: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :ln_lines_to_insert: ' || ln_lines_to_insert );

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

964: ln_lines_to_insert :=2 ;
965: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an inclusive tax. Two AP invoices will be created');
966: END IF;--(c_thirdparty_tax_rec.inc_tax_flag = 'N')
967:
968: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :c_thirdparty_tax_rec.inc_tax_flag :'|| c_thirdparty_tax_rec.inc_tax_flag);
969: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :ln_lines_to_insert: ' || ln_lines_to_insert );
970: Fnd_File.put_line(Fnd_File.LOG, ' ');
971:
972: FOR i in 1 .. ln_lines_to_insert

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

965: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :Tax is an inclusive tax. Two AP invoices will be created');
966: END IF;--(c_thirdparty_tax_rec.inc_tax_flag = 'N')
967:
968: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :c_thirdparty_tax_rec.inc_tax_flag :'|| c_thirdparty_tax_rec.inc_tax_flag);
969: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :ln_lines_to_insert: ' || ln_lines_to_insert );
970: Fnd_File.put_line(Fnd_File.LOG, ' ');
971:
972: FOR i in 1 .. ln_lines_to_insert
973: LOOP

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

966: END IF;--(c_thirdparty_tax_rec.inc_tax_flag = 'N')
967:
968: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :c_thirdparty_tax_rec.inc_tax_flag :'|| c_thirdparty_tax_rec.inc_tax_flag);
969: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :ln_lines_to_insert: ' || ln_lines_to_insert );
970: Fnd_File.put_line(Fnd_File.LOG, ' ');
971:
972: FOR i in 1 .. ln_lines_to_insert
973: LOOP
974: -----------------------------------------------------------------------

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

986:
987:
988: --added by eric for inclusive tax on 20-dec,2007, Begin
989: -----------------------------------------------------------------------
990: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num begin:');
991: IF (i =1 ) --normal third party invoice
992: THEN
993: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch :');
994:

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

989: -----------------------------------------------------------------------
990: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num begin:');
991: IF (i =1 ) --normal third party invoice
992: THEN
993: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch :');
994:
995:
996: lv_description := 'Invoice for vendor '
997: || r_get_vendor_details.vendor_name

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

998: ||' against receipt no. '|| lv_receipt_num;
999: lv_invoice_num := 'RECEIPT/'||lv_receipt_num || '/'
1000: || to_char(ln_inv_run_no);
1001:
1002: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_description :' || lv_description);
1003: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_invoice_num :' || lv_invoice_num);
1004: ELSE --(i =2 ),normal third party invoice--debit memo invoice
1005: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : i =2 Branch :');
1006:

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

999: lv_invoice_num := 'RECEIPT/'||lv_receipt_num || '/'
1000: || to_char(ln_inv_run_no);
1001:
1002: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_description :' || lv_description);
1003: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_invoice_num :' || lv_invoice_num);
1004: ELSE --(i =2 ),normal third party invoice--debit memo invoice
1005: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : i =2 Branch :');
1006:
1007: lv_description := 'Credit Memo for inclusive 3rd party taxes for'

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

1001:
1002: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_description :' || lv_description);
1003: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =1 Branch : lv_invoice_num :' || lv_invoice_num);
1004: ELSE --(i =2 ),normal third party invoice--debit memo invoice
1005: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : i =2 Branch :');
1006:
1007: lv_description := 'Credit Memo for inclusive 3rd party taxes for'
1008: ||' receipt No. ' || lv_receipt_num;
1009: lv_invoice_num := 'ITP-CM/'|| lv_receipt_num || '/'

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

1008: ||' receipt No. ' || lv_receipt_num;
1009: lv_invoice_num := 'ITP-CM/'|| lv_receipt_num || '/'
1010: ||to_char(ln_inv_run_no);
1011:
1012: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_description :' || lv_description);
1013: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_invoice_num :' || lv_invoice_num);
1014: END IF;--(i =1 )
1015:
1016: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num end:');

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

1009: lv_invoice_num := 'ITP-CM/'|| lv_receipt_num || '/'
1010: ||to_char(ln_inv_run_no);
1011:
1012: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_description :' || lv_description);
1013: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_invoice_num :' || lv_invoice_num);
1014: END IF;--(i =1 )
1015:
1016: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num end:');
1017: Fnd_File.put_line(Fnd_File.LOG, ' ');

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

1012: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_description :' || lv_description);
1013: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_invoice_num :' || lv_invoice_num);
1014: END IF;--(i =1 )
1015:
1016: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num end:');
1017: Fnd_File.put_line(Fnd_File.LOG, ' ');
1018: -----------------------------------------------------------------------
1019: --added by eric for inclusive tax on 20-dec,2007, end
1020:

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

1013: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2,i =2 Branch : lv_invoice_num :' || lv_invoice_num);
1014: END IF;--(i =1 )
1015:
1016: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : lv_description and lv_invoice_num end:');
1017: Fnd_File.put_line(Fnd_File.LOG, ' ');
1018: -----------------------------------------------------------------------
1019: --added by eric for inclusive tax on 20-dec,2007, end
1020:
1021:

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

1044: --added by eric for inclusive tax on 20-dec,2007, Begin
1045: -----------------------------------------------------------------------
1046: IF (i =1 )
1047: THEN
1048: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : jai_rcv_tp_invoice stable insert beign:');
1049: -----------------------------------------------------------------------
1050: --added by eric for inclusive tax on 20-dec,2007, end
1051: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,jai_rcv_tp_invoice table insert : i =1 Branch :');
1052: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1. Before insert into jai_rcv_tp_invoices ' );

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

1047: THEN
1048: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : jai_rcv_tp_invoice stable insert beign:');
1049: -----------------------------------------------------------------------
1050: --added by eric for inclusive tax on 20-dec,2007, end
1051: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,jai_rcv_tp_invoice table insert : i =1 Branch :');
1052: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1. Before insert into jai_rcv_tp_invoices ' );
1053:
1054:
1055: insert into jai_rcv_tp_invoices

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

1048: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : jai_rcv_tp_invoice stable insert beign:');
1049: -----------------------------------------------------------------------
1050: --added by eric for inclusive tax on 20-dec,2007, end
1051: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,jai_rcv_tp_invoice table insert : i =1 Branch :');
1052: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1. Before insert into jai_rcv_tp_invoices ' );
1053:
1054:
1055: insert into jai_rcv_tp_invoices
1056: (

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

1092: fnd_profile.value('CONC_LOGIN_ID'),
1093: fnd_profile.value('CONC_REQUEST_ID')
1094: );
1095:
1096: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );
1097: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :jai_rcv_tp_invoice table insert end:');
1098: Fnd_File.put_line(Fnd_File.LOG, ' ');
1099: --added by eric for inclusive tax on 20-dec,2007, Begin
1100: -----------------------------------------------------------------------

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

1093: fnd_profile.value('CONC_REQUEST_ID')
1094: );
1095:
1096: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );
1097: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :jai_rcv_tp_invoice table insert end:');
1098: Fnd_File.put_line(Fnd_File.LOG, ' ');
1099: --added by eric for inclusive tax on 20-dec,2007, Begin
1100: -----------------------------------------------------------------------
1101: END IF;--(i =1 )

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

1094: );
1095:
1096: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );
1097: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :jai_rcv_tp_invoice table insert end:');
1098: Fnd_File.put_line(Fnd_File.LOG, ' ');
1099: --added by eric for inclusive tax on 20-dec,2007, Begin
1100: -----------------------------------------------------------------------
1101: END IF;--(i =1 )
1102: -----------------------------------------------------------------------

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

1112: --Ap invoice interface table need to be inserted twice if necessary
1113: --the first time is for the normal third party inv
1114: --the second time is for the credit memo ,in case of inclusive tax
1115:
1116: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : insertface table insert begin:');
1117:
1118: --added by eric for inclusive tax on 20-dec,2007, Begin
1119: -----------------------------------------------------------------------
1120: IF (i =1 )

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

1120: IF (i =1 )
1121: THEN
1122: -----------------------------------------------------------------------
1123: --added by eric for inclusive tax on 20-dec,2007, end
1124: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,insertface table : i =1 Branch :');
1125: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 3. Before insert into insert_ap_inv_interface for Standard Invoice' );
1126:
1127: jai_ap_utils_pkg.insert_ap_inv_interface
1128: (

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

1121: THEN
1122: -----------------------------------------------------------------------
1123: --added by eric for inclusive tax on 20-dec,2007, end
1124: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,insertface table : i =1 Branch :');
1125: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 3. Before insert into insert_ap_inv_interface for Standard Invoice' );
1126:
1127: jai_ap_utils_pkg.insert_ap_inv_interface
1128: (
1129: p_jai_source => 'Third Party Invoices',

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

1152: p_last_update_login => null,
1153: p_org_id => ln_org_id -- added by csahoo for bug#6139899
1154: );
1155:
1156: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 4. After insert Standard third party Invoice :' || lv_invoice_num ||' into insert_ap_inv_interface');
1157: --added by eric for inclusive tax on 20-dec,2007, Begin
1158: -----------------------------------------------------------------------
1159: ELSIF (i =2 )
1160: THEN

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

1157: --added by eric for inclusive tax on 20-dec,2007, Begin
1158: -----------------------------------------------------------------------
1159: ELSIF (i =2 )
1160: THEN
1161: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,insertface table : i =2 Branch :');
1162: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 5. Before insert into insert_ap_inv_interface for CM ' );
1163:
1164: --added by eric for BUG#6988610 on Apr-24,2008, Begin
1165: -----------------------------------------------------------------------

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

1158: -----------------------------------------------------------------------
1159: ELSIF (i =2 )
1160: THEN
1161: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,insertface table : i =2 Branch :');
1162: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 5. Before insert into insert_ap_inv_interface for CM ' );
1163:
1164: --added by eric for BUG#6988610 on Apr-24,2008, Begin
1165: -----------------------------------------------------------------------
1166: OPEN get_totl_incl_tax_amount

Line 1240: 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');

1236: p_last_update_login => null,
1237: p_org_id => ln_org_id -- added by csahoo for bug#6139899
1238: );
1239:
1240: 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');
1241: --added by eric for inclusive tax on 20-dec,2007, Begin
1242: -----------------------------------------------------------------------
1243: END IF; --(i =1 )
1244: -----------------------------------------------------------------------

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

1241: --added by eric for inclusive tax on 20-dec,2007, Begin
1242: -----------------------------------------------------------------------
1243: END IF; --(i =1 )
1244: -----------------------------------------------------------------------
1245: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : insertface table insert end:');
1246: Fnd_File.put_line(Fnd_File.LOG, ' ');
1247: --added by eric for inclusive tax on 20-dec,2007, end
1248: end if; /* if p_simulation <> 'Y' then */
1249:

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

1242: -----------------------------------------------------------------------
1243: END IF; --(i =1 )
1244: -----------------------------------------------------------------------
1245: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : insertface table insert end:');
1246: Fnd_File.put_line(Fnd_File.LOG, ' ');
1247: --added by eric for inclusive tax on 20-dec,2007, end
1248: end if; /* if p_simulation <> 'Y' then */
1249:
1250:

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

1299: AND jrlt.tax_id = jcta.tax_id --added by eric for inclusive tax
1300: )
1301: LOOP
1302:
1303: Fnd_File.put_line(Fnd_File.LOG, ' ');
1304: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop Begin');
1305: --SELECT jai_rcv_tp_inv_details_s.nextval INTO ln_batch_line_id FROM DUAL;
1306:
1307: --tax table need to be populated once only

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

1300: )
1301: LOOP
1302:
1303: Fnd_File.put_line(Fnd_File.LOG, ' ');
1304: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop Begin');
1305: --SELECT jai_rcv_tp_inv_details_s.nextval INTO ln_batch_line_id FROM DUAL;
1306:
1307: --tax table need to be populated once only
1308: --added by eric for inclusive tax on 20-dec,2007, Begin

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

1310: IF (i =1 )
1311: THEN
1312: -----------------------------------------------------------------------
1313: --added by eric for inclusive tax on 20-dec,2007, end
1314: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 3 ,jai_rcv_tp_inv_details table : i =1 Branch :');
1315: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7. Before insert into jai_rcv_tp_inv_details' );
1316:
1317: INSERT INTO jai_rcv_tp_inv_details
1318: (

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

1311: THEN
1312: -----------------------------------------------------------------------
1313: --added by eric for inclusive tax on 20-dec,2007, end
1314: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 3 ,jai_rcv_tp_inv_details table : i =1 Branch :');
1315: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7. Before insert into jai_rcv_tp_inv_details' );
1316:
1317: INSERT INTO jai_rcv_tp_inv_details
1318: (
1319: BATCH_LINE_ID ,

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

1346: sysdate ,
1347: fnd_global.user_id ,
1348: fnd_global.login_id
1349: ) returning BATCH_LINE_ID into ln_BATCH_LINE_ID;
1350: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 8. After insert into jai_rcv_tp_inv_details' );
1351: --added by eric for inclusive tax on 20-dec,2007, Begin
1352: -----------------------------------------------------------------------
1353: END IF; --(i =1 )
1354: -----------------------------------------------------------------------

Line 1388: --Fnd_File.put_line(Fnd_File.LOG, ' ln_to_insert_line_number : '||ln_to_insert_line_number);

1384: ELSE
1385: ln_cm_line_number := ln_cm_line_number + 1;
1386: ln_to_insert_line_number :=ln_cm_line_number;
1387: END IF;
1388: --Fnd_File.put_line(Fnd_File.LOG, ' ln_to_insert_line_number : '||ln_to_insert_line_number);
1389: -----------------------------------------------------------------------
1390: --added by eric for inclusive tax on 20-dec,2007, end
1391: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : i ='||i ||' , '||'ln_to_insert_line_number = '|| ln_to_insert_line_number);
1392: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 9. Before insert into insert_ap_inv_lines_interface' );

Line 1391: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : i ='||i ||' , '||'ln_to_insert_line_number = '|| ln_to_insert_line_number);

1387: END IF;
1388: --Fnd_File.put_line(Fnd_File.LOG, ' ln_to_insert_line_number : '||ln_to_insert_line_number);
1389: -----------------------------------------------------------------------
1390: --added by eric for inclusive tax on 20-dec,2007, end
1391: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : i ='||i ||' , '||'ln_to_insert_line_number = '|| ln_to_insert_line_number);
1392: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 9. Before insert into insert_ap_inv_lines_interface' );
1393:
1394: jai_ap_utils_pkg.insert_ap_inv_lines_interface
1395: (

Line 1392: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 9. Before insert into insert_ap_inv_lines_interface' );

1388: --Fnd_File.put_line(Fnd_File.LOG, ' ln_to_insert_line_number : '||ln_to_insert_line_number);
1389: -----------------------------------------------------------------------
1390: --added by eric for inclusive tax on 20-dec,2007, end
1391: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : i ='||i ||' , '||'ln_to_insert_line_number = '|| ln_to_insert_line_number);
1392: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 9. Before insert into insert_ap_inv_lines_interface' );
1393:
1394: jai_ap_utils_pkg.insert_ap_inv_lines_interface
1395: (
1396: p_jai_source => 'Third Party Invoices',

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

1412: p_last_update_date => sysdate,
1413: p_last_update_login => null,
1414: p_org_id => ln_org_id -- added by csahoo for bug#139899
1415: );
1416: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 10. After insert into insert_ap_inv_lines_interface' );
1417: --added by eric for bug 6971486 on 20-Apr,2008, Begin
1418: -----------------------------------------------------------------------
1419: END IF;
1420: -----------------------------------------------------------------------

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

1423: ln_line_number := 0;
1424: --Added by eric for inclusive tax on Dec 14,2007 Begin
1425: ------------------------------------------------------------------------------
1426: ln_cm_line_number :=0;
1427: Fnd_File.put_line(Fnd_File.LOG, ' ');
1428: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop end');
1429: END LOOP;--( i in 1 .. ln_lines_to_insert)
1430: END IF; /* END IF FOR if lv_vendor_has_changed = 'TRUE' THEN */
1431: ------------------------------------------------------------------------------

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

1424: --Added by eric for inclusive tax on Dec 14,2007 Begin
1425: ------------------------------------------------------------------------------
1426: ln_cm_line_number :=0;
1427: Fnd_File.put_line(Fnd_File.LOG, ' ');
1428: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop end');
1429: END LOOP;--( i in 1 .. ln_lines_to_insert)
1430: END IF; /* END IF FOR if lv_vendor_has_changed = 'TRUE' THEN */
1431: ------------------------------------------------------------------------------
1432: --Added by eric for inclusive tax on Dec 14,2007 End

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

1429: END LOOP;--( i in 1 .. ln_lines_to_insert)
1430: END IF; /* END IF FOR if lv_vendor_has_changed = 'TRUE' THEN */
1431: ------------------------------------------------------------------------------
1432: --Added by eric for inclusive tax on Dec 14,2007 End
1433: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop end');
1434: Fnd_File.put_line(Fnd_File.LOG, ' ');
1435: end loop; --(For c_thirdparty_tax_rec IN)
1436:
1437:

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

1430: END IF; /* END IF FOR if lv_vendor_has_changed = 'TRUE' THEN */
1431: ------------------------------------------------------------------------------
1432: --Added by eric for inclusive tax on Dec 14,2007 End
1433: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 2 : Loop end');
1434: Fnd_File.put_line(Fnd_File.LOG, ' ');
1435: end loop; --(For c_thirdparty_tax_rec IN)
1436:
1437:
1438: << exit_from_procedure >>

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

1440: p_process_flag := 'Y';
1441: end if;
1442:
1443: if p_debug >= 1 then
1444: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||
1445: 'End of procedure jai_rcv_third_party_pkg.process_receipt for shipment header :' ||
1446: to_char(p_shipment_header_id)
1447: );
1448: end if;

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

1452: exception
1453: when others then
1454: p_process_flag := 'E';
1455: p_process_message := 'jai_rcv_third_party_pkg.process_receipt:' || sqlerrm;
1456: fnd_file.put_line( fnd_file.log, '******** Error in '||p_process_message);
1457: raise;
1458:
1459: end process_receipt;
1460: /****************************** End process_receipt ****************************/