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_CMN_ST_FORMS_PKG dependencies on FND_FILE

Line 296: Fnd_File.put_line(Fnd_File.LOG, ' Start of getSTformsTaxBaseAmount');

292: and line_location_id = c_line_location_id
293: and po_distribution_id = c_po_distribution_id;
294:
295: begin
296: Fnd_File.put_line(Fnd_File.LOG, ' Start of getSTformsTaxBaseAmount');
297:
298: open c_get_inv_dist_details;
299: fetch c_get_inv_dist_details into v_line_number, v_po_distribution_id, v_rcv_transaction_id, v_precedence_0;
300: --fetch c_get_inv_dist_details into v_invoice_distribution_id, v_po_distribution_id, v_rcv_transaction_id, v_precedence_0;

Line 303: Fnd_File.put_line(Fnd_File.LOG, ' 0 precedence amount : ' || v_precedence_0 );

299: fetch c_get_inv_dist_details into v_line_number, v_po_distribution_id, v_rcv_transaction_id, v_precedence_0;
300: --fetch c_get_inv_dist_details into v_invoice_distribution_id, v_po_distribution_id, v_rcv_transaction_id, v_precedence_0;
301: close c_get_inv_dist_details;
302:
303: Fnd_File.put_line(Fnd_File.LOG, ' 0 precedence amount : ' || v_precedence_0 );
304:
305:
306: open c_get_po_details(v_po_distribution_id);
307: fetch c_get_po_details into v_po_header_id, v_po_line_id, v_po_line_location_id;

Line 353: /*Commenting Starts Fnd_File.put_line(Fnd_File.LOG, ' Calculated tax base backward from tax amount and rate as PO tax details not found ');

349: --start addded by Aparajita for bug#3094025
350: if nvl(v_tax_base_amt, 0) = 0 then
351: -- the tax may no be there at po, have to calculate back if it is from receipt.
352: -- as precedence is not available
353: /*Commenting Starts Fnd_File.put_line(Fnd_File.LOG, ' Calculated tax base backward from tax amount and rate as PO tax details not found ');
354: v_tax_base_amt := ((p_tax_amount * 100) / p_tax_rate); Commenting Ends*/
355: /*Code added by nprashar for bug #6043559, FP changes of bug # 5999535*/
356: OPEN c_receipt_base_amt (c_invoice_id => p_invoice_id,
357: c_invoice_distribution_id => p_line_number,

Line 364: Fnd_File.put_line(Fnd_File.LOG, ' Calculated tax base from receipt taxes '); /Ends here/

360: c_line_location_id => v_po_line_location_id,
361: c_po_distribution_id => v_po_distribution_id);
362: FETCH c_receipt_base_amt INTO v_tax_base_amt;
363: CLOSE c_receipt_base_amt;
364: Fnd_File.put_line(Fnd_File.LOG, ' Calculated tax base from receipt taxes '); /*Ends here*/
365: end if;
366: --End addded by Aparajita for bug#3094025
367:
368:

Line 369: Fnd_File.put_line(Fnd_File.LOG, ' End of getSTformsTaxBaseAmount : ' || v_tax_base_amt);

365: end if;
366: --End addded by Aparajita for bug#3094025
367:
368:
369: Fnd_File.put_line(Fnd_File.LOG, ' End of getSTformsTaxBaseAmount : ' || v_tax_base_amt);
370: return v_tax_base_amt;
371:
372: exception
373: when others then

Line 374: Fnd_File.put_line(Fnd_File.LOG, ' Error in getting tax base amount for ST forrms :' || sqlerrm);

370: return v_tax_base_amt;
371:
372: exception
373: when others then
374: Fnd_File.put_line(Fnd_File.LOG, ' Error in getting tax base amount for ST forrms :' || sqlerrm);
375: Fnd_File.put_line(Fnd_File.LOG, ' Populated st forms tax target amount as 0');
376: return 0;
377: end getSTformsTaxBaseAmount;
378: -- end added by Aparajita for bug#3038566;

Line 375: Fnd_File.put_line(Fnd_File.LOG, ' Populated st forms tax target amount as 0');

371:
372: exception
373: when others then
374: Fnd_File.put_line(Fnd_File.LOG, ' Error in getting tax base amount for ST forrms :' || sqlerrm);
375: Fnd_File.put_line(Fnd_File.LOG, ' Populated st forms tax target amount as 0');
376: return 0;
377: end getSTformsTaxBaseAmount;
378: -- end added by Aparajita for bug#3038566;
379:

Line 447: Fnd_File.put_line(Fnd_File.LOG, ' ========================================== ');

443: ------------------------------------------------------------------------------------------------------- */
444: v_debug := jai_constants.yes ; --Ramananda for File.Sql.35
445:
446: if v_debug = 'Y' then
447: Fnd_File.put_line(Fnd_File.LOG, '**** ========================================== ****');
448: Fnd_File.put_line(Fnd_File.LOG, '**** Start procedure - jai_cmn_st_forms_pkg.generate_ap_forms ****');
449: end if;
450:
451: v_uid := fnd_global.USER_ID;

Line 448: Fnd_File.put_line(Fnd_File.LOG, ' Start procedure - jai_cmn_st_forms_pkg.generate_ap_forms ');

444: v_debug := jai_constants.yes ; --Ramananda for File.Sql.35
445:
446: if v_debug = 'Y' then
447: Fnd_File.put_line(Fnd_File.LOG, '**** ========================================== ****');
448: Fnd_File.put_line(Fnd_File.LOG, '**** Start procedure - jai_cmn_st_forms_pkg.generate_ap_forms ****');
449: end if;
450:
451: v_uid := fnd_global.USER_ID;
452:

Line 483: Fnd_File.put_line(Fnd_File.LOG, ' ** Processing invoice (id) : '

479:
480: begin
481:
482: if v_debug = 'Y' then
483: Fnd_File.put_line(Fnd_File.LOG, ' ** Processing invoice (id) : '
484: || c_invoices.invoice_num || '('
485: || c_invoices.invoice_id || '}' );
486: end if;
487:

Line 498: Fnd_File.put_line(Fnd_File.LOG, ' Invoice is Cancelled - not processing' );

494: v_invoice_process_flag := 'N'; -- this invoice should not be processed.
495: v_not_processed_inv_cnt := v_not_processed_inv_cnt + 1;
496:
497: if v_debug = 'Y' then
498: Fnd_File.put_line(Fnd_File.LOG, ' Invoice is Cancelled - not processing' );
499: end if;
500:
501:
502: delete JAI_CMN_ST_FORM_DTLS a

Line 512: Fnd_File.put_line(Fnd_File.LOG,

508: and st_dtl_id = a.st_dtl_id
509: );
510:
511: if v_debug = 'Y' then
512: Fnd_File.put_line(Fnd_File.LOG,
513: ' No of unmatched records deleetd from st forms for this invoice :'
514: || to_char(sql%rowcount) );
515: end if;
516:

Line 542: Fnd_File.put_line(Fnd_File.LOG, ' Invoice is not validated - not processing' );

538: v_invoice_process_flag := 'N'; -- this invoice should not be processed.
539: v_not_processed_inv_cnt := v_not_processed_inv_cnt + 1;
540:
541: if v_debug = 'Y' then
542: Fnd_File.put_line(Fnd_File.LOG, ' Invoice is not validated - not processing' );
543: end if;
544:
545:
546: delete JAI_CMN_ST_FORM_DTLS a

Line 556: Fnd_File.put_line(Fnd_File.LOG,

552: and st_dtl_id = a.st_dtl_id
553: );
554:
555: if v_debug = 'Y' then
556: Fnd_File.put_line(Fnd_File.LOG,
557: ' No of unmatched records deleted from st forms for this invoice :'
558: || to_char(sql%rowcount) );
559: end if;
560:

Line 585: Fnd_File.put_line(Fnd_File.LOG,

581: and st_dtl_id = a.st_dtl_id
582: );
583:
584: if v_debug = 'Y' then
585: Fnd_File.put_line(Fnd_File.LOG,
586: ' Re-Process : No of unmatched records purged from st forms for this invoice :'
587: || to_char(sql%rowcount) );
588: end if;
589:

Line 787: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_target_amount='||v_tax_target_amount||',v_mod_cr_pctg='||v_mod_cr_pctg||',lv_recoverable_flag='||lv_recoverable_flag);

783: -- For partially recoverable taxes tax_target_amount needs to be apportioned
784: -- because there will be two lines one for recoverable and one for non recoverable
785: -- and for both the tax lines getSTFormsTaxBaseAmount will return same base amount
786: --
787: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_target_amount='||v_tax_target_amount||',v_mod_cr_pctg='||v_mod_cr_pctg||',lv_recoverable_flag='||lv_recoverable_flag);
788: if v_mod_cr_pctg > 0 and v_mod_cr_pctg < 100 then
789: Fnd_File.put_line(Fnd_File.LOG, 'INSIDE IF1');
790: if lv_recoverable_flag = jai_constants.YES then
791: v_tax_target_amount := (v_tax_target_amount) * (v_mod_cr_pctg/100);

Line 789: Fnd_File.put_line(Fnd_File.LOG, 'INSIDE IF1');

785: -- and for both the tax lines getSTFormsTaxBaseAmount will return same base amount
786: --
787: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_target_amount='||v_tax_target_amount||',v_mod_cr_pctg='||v_mod_cr_pctg||',lv_recoverable_flag='||lv_recoverable_flag);
788: if v_mod_cr_pctg > 0 and v_mod_cr_pctg < 100 then
789: Fnd_File.put_line(Fnd_File.LOG, 'INSIDE IF1');
790: if lv_recoverable_flag = jai_constants.YES then
791: v_tax_target_amount := (v_tax_target_amount) * (v_mod_cr_pctg/100);
792: elsif lv_recoverable_flag = jai_constants.NO then
793: v_tax_target_amount := v_tax_target_amount * (1 - (v_mod_cr_pctg/100));

Line 894: Fnd_File.put_line(Fnd_File.LOG,' Error :' || v_error_message);

890: elsif v_invoice_error_flag = 'Y' then
891:
892: rollback;
893: if v_debug = 'Y' then
894: Fnd_File.put_line(Fnd_File.LOG,' Error :' || v_error_message);
895: end if;
896: v_error_inv_cnt := v_error_inv_cnt + 1;
897: v_error_flag := 'Y';
898:

Line 903: Fnd_File.put_line(Fnd_File.LOG,' Successful : No of ST forms lines created for the invoice - '

899: else
900:
901: commit;
902: if v_debug = 'Y' then
903: Fnd_File.put_line(Fnd_File.LOG,' Successful : No of ST forms lines created for the invoice - '
904: || to_char(v_st_lines_for_inv) );
905: end if;
906: v_processed_inv_cnt := v_processed_inv_cnt + 1;
907:

Line 915: Fnd_File.put_line(Fnd_File.LOG, ' ======================= S U M M A R Y ======================= ');

911:
912: end loop; -- c_invoices
913:
914:
915: Fnd_File.put_line(Fnd_File.LOG, '**** ======================= S U M M A R Y ======================= ****');
916: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices processed successfully :'
917: || to_char(v_processed_inv_cnt) );
918:
919: if v_not_processed_inv_cnt > 0 then

Line 916: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices processed successfully :'

912: end loop; -- c_invoices
913:
914:
915: Fnd_File.put_line(Fnd_File.LOG, '**** ======================= S U M M A R Y ======================= ****');
916: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices processed successfully :'
917: || to_char(v_processed_inv_cnt) );
918:
919: if v_not_processed_inv_cnt > 0 then
920: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices not processed for status - cancelled /not validated status :'

Line 920: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices not processed for status - cancelled /not validated status :'

916: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices processed successfully :'
917: || to_char(v_processed_inv_cnt) );
918:
919: if v_not_processed_inv_cnt > 0 then
920: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices not processed for status - cancelled /not validated status :'
921: || to_char(v_not_processed_inv_cnt) );
922: end if;
923:
924:

Line 927: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices for which error is encountered :'

923:
924:
925: if v_error_inv_cnt > 0 then
926:
927: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices for which error is encountered :'
928: || to_char(v_error_inv_cnt) );
929:
930: p_ret_code := 1;
931: p_err_buf := 'Please check the detailed log. '

Line 941: Fnd_File.put_line(Fnd_File.LOG, '**** Exception from procedure ja_in_ap_populate_st_forms:' || sqlerrm);

937:
938: when others then
939: p_ret_code := 2;
940: p_err_buf := sqlerrm;
941: Fnd_File.put_line(Fnd_File.LOG, '**** Exception from procedure ja_in_ap_populate_st_forms:' || sqlerrm);
942:
943: end generate_ap_forms;
944:
945: PROCEDURE generate_forms( errbuf OUT NOCOPY varchar2 ,

Line 1048: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure - jai_cmn_st_forms_pkg.generate_forms');

1044: ld_to_date := fnd_date.canonical_to_date(p_to_date) ;
1045:
1046: audsid := userenv('SESSIONID'); --Ramananda for File.Sql.35
1047:
1048: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure - jai_cmn_st_forms_pkg.generate_forms');
1049: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id : '|| p_org_id ||' Process All orgs ' || p_all_orgs || ' p_party_type :' || p_party_type );
1050: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id : ' || p_party_id || ' p_party_site_id : ' || p_party_site_id);
1051: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date :' || p_from_date ||' p_to_date ' || p_to_date || ' Trace ' || P_Enable_Trace);
1052:

Line 1049: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id : '|| p_org_id ||' Process All orgs ' || p_all_orgs || ' p_party_type :' || p_party_type );

1045:
1046: audsid := userenv('SESSIONID'); --Ramananda for File.Sql.35
1047:
1048: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure - jai_cmn_st_forms_pkg.generate_forms');
1049: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id : '|| p_org_id ||' Process All orgs ' || p_all_orgs || ' p_party_type :' || p_party_type );
1050: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id : ' || p_party_id || ' p_party_site_id : ' || p_party_site_id);
1051: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date :' || p_from_date ||' p_to_date ' || p_to_date || ' Trace ' || P_Enable_Trace);
1052:
1053: if P_Enable_Trace = 'Y' or P_Enable_Trace = 'y' then

Line 1050: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id : ' || p_party_id || ' p_party_site_id : ' || p_party_site_id);

1046: audsid := userenv('SESSIONID'); --Ramananda for File.Sql.35
1047:
1048: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure - jai_cmn_st_forms_pkg.generate_forms');
1049: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id : '|| p_org_id ||' Process All orgs ' || p_all_orgs || ' p_party_type :' || p_party_type );
1050: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id : ' || p_party_id || ' p_party_site_id : ' || p_party_site_id);
1051: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date :' || p_from_date ||' p_to_date ' || p_to_date || ' Trace ' || P_Enable_Trace);
1052:
1053: if P_Enable_Trace = 'Y' or P_Enable_Trace = 'y' then
1054: execute immediate 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''' ;

Line 1051: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date :' || p_from_date ||' p_to_date ' || p_to_date || ' Trace ' || P_Enable_Trace);

1047:
1048: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure - jai_cmn_st_forms_pkg.generate_forms');
1049: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id : '|| p_org_id ||' Process All orgs ' || p_all_orgs || ' p_party_type :' || p_party_type );
1050: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id : ' || p_party_id || ' p_party_site_id : ' || p_party_site_id);
1051: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date :' || p_from_date ||' p_to_date ' || p_to_date || ' Trace ' || P_Enable_Trace);
1052:
1053: if P_Enable_Trace = 'Y' or P_Enable_Trace = 'y' then
1054: execute immediate 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''' ;
1055:

Line 1060: fnd_file.put_line(FND_FILE.LOG, 'v_program_id -> '||v_program_id

1056: OPEN c_program_id(FND_GLOBAL.CONC_REQUEST_ID);
1057: FETCH c_program_id INTO v_program_id, v_enable_trace;
1058: CLOSE c_program_id;
1059:
1060: fnd_file.put_line(FND_FILE.LOG, 'v_program_id -> '||v_program_id
1061: ||', v_enable_trace -> '||v_enable_trace
1062: ||', request_id -> '||FND_GLOBAL.CONC_REQUEST_ID);
1063:
1064: if v_enable_trace = 'Y' THEN

Line 1073: fnd_file.put_line(FND_FILE.LOG,'TraceFile Name = '||lower(name1)||'_ora_'||spid||'.trc');

1069: OPEN get_dbname;
1070: FETCH get_dbname INTO name1;
1071: CLOSE get_dbname;
1072:
1073: fnd_file.put_line(FND_FILE.LOG,'TraceFile Name = '||lower(name1)||'_ora_'||spid||'.trc');
1074: end if;
1075:
1076: -- trx gen ends here
1077: end if;

Line 1128: fnd_file.put_line(FND_FILE.LOG,'Encountered the Error ' || errbuf);

1124: );
1125: end if;
1126:
1127: if errbuf is not null then
1128: fnd_file.put_line(FND_FILE.LOG,'Encountered the Error ' || errbuf);
1129: end if;
1130:
1131: /* Added by Ramananda for bug#4407165 */
1132: EXCEPTION

Line 1380: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_iso_forms' );

1376:
1377: v_some_errors := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1378: v_order_flag := 'O'; --Ramananda for File.Sql.35
1379:
1380: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_iso_forms' );
1381: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1382: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1383: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1384:

Line 1381: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );

1377: v_some_errors := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1378: v_order_flag := 'O'; --Ramananda for File.Sql.35
1379:
1380: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_iso_forms' );
1381: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1382: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1383: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1384:
1385: FOR st_forms_rec IN c_fetch_records

Line 1382: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);

1378: v_order_flag := 'O'; --Ramananda for File.Sql.35
1379:
1380: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_iso_forms' );
1381: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1382: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1383: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1384:
1385: FOR st_forms_rec IN c_fetch_records
1386: LOOP

Line 1383: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);

1379:
1380: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_iso_forms' );
1381: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1382: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1383: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1384:
1385: FOR st_forms_rec IN c_fetch_records
1386: LOOP
1387:

Line 1389: fnd_file.put_line(FND_FILE.LOG,'1.0 Processing delivery : ' || st_forms_rec.delivery_id);

1385: FOR st_forms_rec IN c_fetch_records
1386: LOOP
1387:
1388: /* duplicate check */
1389: fnd_file.put_line(FND_FILE.LOG,'1.0 Processing delivery : ' || st_forms_rec.delivery_id);
1390:
1391: v_record_exists := null;
1392:
1393: open c_check_duplicate(st_forms_rec.delivery_id);

Line 1408: fnd_file.put_line(FND_FILE.LOG,'1.1 Delivery : ' || st_forms_rec.delivery_id || ' not present in St form tables, hence processing.' );

1404: need to insert records into the st forms hdr and st forms detail tables.
1405: JAI_CMN_STFORM_HDRS_ALL
1406: JAI_CMN_ST_FORM_DTLS
1407: */
1408: fnd_file.put_line(FND_FILE.LOG,'1.1 Delivery : ' || st_forms_rec.delivery_id || ' not present in St form tables, hence processing.' );
1409:
1410: FOR tax_rec IN c_get_taxes(st_forms_rec.delivery_id)
1411: LOOP
1412: BEGIN

Line 1462: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_STFORM_HDRS_ALL table with header id '|| v_st_hdr_id);

1458: fnd_global.login_id ,
1459: st_forms_rec.org_id ,
1460: 'C'
1461: ) RETURNING st_hdr_id INTO v_st_hdr_id;
1462: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_STFORM_HDRS_ALL table with header id '|| v_st_hdr_id);
1463: ELSE
1464:
1465: v_st_hdr_id := v_hdr_record_exists;
1466: fnd_file.put_line(FND_FILE.LOG,'header record found . Header id is : ' ||v_st_hdr_id);

Line 1466: fnd_file.put_line(FND_FILE.LOG,'header record found . Header id is : ' ||v_st_hdr_id);

1462: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_STFORM_HDRS_ALL table with header id '|| v_st_hdr_id);
1463: ELSE
1464:
1465: v_st_hdr_id := v_hdr_record_exists;
1466: fnd_file.put_line(FND_FILE.LOG,'header record found . Header id is : ' ||v_st_hdr_id);
1467:
1468:
1469: END IF;
1470:

Line 1546: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_ST_FORM_DTLS table with detail id :' ||v_st_line_id );

1542: fnd_global.user_id ,
1543: fnd_global.login_id
1544:
1545: ) RETURNING st_dtl_id INTO v_st_line_id;
1546: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_ST_FORM_DTLS table with detail id :' ||v_st_line_id );
1547: v_base_tax_amt :=NULL;
1548:
1549: EXCEPTION
1550: WHEN OTHERS THEN

Line 1551: fnd_file.put_line(FND_FILE.LOG,'Encountered Error when processing Delivery : ' || st_forms_Rec.delivery_id );

1547: v_base_tax_amt :=NULL;
1548:
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: fnd_file.put_line(FND_FILE.LOG,'Encountered Error when processing Delivery : ' || st_forms_Rec.delivery_id );
1552: fnd_file.put_line(FND_FILE.LOG,'Error reported is : ' || sqlerrm );
1553: v_some_errors := '1';
1554: rollback;
1555: EXIT; -- So that this delivery_id is not processed further

Line 1552: fnd_file.put_line(FND_FILE.LOG,'Error reported is : ' || sqlerrm );

1548:
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: fnd_file.put_line(FND_FILE.LOG,'Encountered Error when processing Delivery : ' || st_forms_Rec.delivery_id );
1552: fnd_file.put_line(FND_FILE.LOG,'Error reported is : ' || sqlerrm );
1553: v_some_errors := '1';
1554: rollback;
1555: EXIT; -- So that this delivery_id is not processed further
1556: END;

Line 1867: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_ar_forms' );

1863:
1864: v_some_errors := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1865: v_order_flag := 'O'; --Ramananda for File.Sql.35
1866:
1867: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_ar_forms' );
1868: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1869: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1870: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1871:

Line 1868: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );

1864: v_some_errors := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1865: v_order_flag := 'O'; --Ramananda for File.Sql.35
1866:
1867: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_ar_forms' );
1868: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1869: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1870: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1871:
1872: FOR st_forms_rec IN c_fetch_records

Line 1869: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);

1865: v_order_flag := 'O'; --Ramananda for File.Sql.35
1866:
1867: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_ar_forms' );
1868: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1869: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1870: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1871:
1872: FOR st_forms_rec IN c_fetch_records
1873: LOOP

Line 1870: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);

1866:
1867: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_ar_forms' );
1868: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1869: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1870: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1871:
1872: FOR st_forms_rec IN c_fetch_records
1873: LOOP
1874:

Line 1876: fnd_file.put_line(FND_FILE.LOG,'1.0 Processing invoice : '||st_forms_rec.document_type||':' || st_forms_rec.customer_trx_id);

1872: FOR st_forms_rec IN c_fetch_records
1873: LOOP
1874:
1875: /* duplicate check */
1876: fnd_file.put_line(FND_FILE.LOG,'1.0 Processing invoice : '||st_forms_rec.document_type||':' || st_forms_rec.customer_trx_id);
1877:
1878: v_record_exists := null;
1879:
1880: open c_check_duplicate(st_forms_rec.customer_trx_id);

Line 1895: fnd_file.put_line(FND_FILE.LOG,'1.1 Invoice : '||st_forms_rec.document_type||':' || st_forms_rec.customer_trx_id || ' not present in St form tables, hence processing.' );

1891: need to insert records into the st forms hdr and st forms detail tables.
1892: JAI_CMN_STFORM_HDRS_ALL
1893: JAI_CMN_ST_FORM_DTLS
1894: */
1895: fnd_file.put_line(FND_FILE.LOG,'1.1 Invoice : '||st_forms_rec.document_type||':' || st_forms_rec.customer_trx_id || ' not present in St form tables, hence processing.' );
1896:
1897: FOR tax_rec IN c_get_taxes(st_forms_rec.customer_trx_id)
1898: LOOP
1899: BEGIN

Line 1925: fnd_file.put_line(FND_FILE.LOG,'before inserting into JAI_CMN_STFORM_HDRS_ALL table');

1921: /* no record exists in the st forms hdr table (JAI_CMN_STFORM_HDRS_ALL) for the combination of
1922: party , party site , form_type , org_id and party type.
1923: */
1924:
1925: fnd_file.put_line(FND_FILE.LOG,'before inserting into JAI_CMN_STFORM_HDRS_ALL table');
1926: INSERT INTO JAI_CMN_STFORM_HDRS_ALL(
1927: st_hdr_id ,
1928: party_id ,
1929: party_site_id ,

Line 2008: fnd_file.put_line(FND_FILE.LOG,'before inserting into JAI_CMN_ST_FORM_DTLS table');

2004: fetch c_orgn_locn into v_orgn_id , v_locn_id;
2005: close c_orgn_locn;
2006: end if;
2007:
2008: fnd_file.put_line(FND_FILE.LOG,'before inserting into JAI_CMN_ST_FORM_DTLS table');
2009:
2010: INSERT INTO JAI_CMN_ST_FORM_DTLS(
2011: ST_HDR_ID ,
2012: ST_DTL_ID ,

Line 2062: fnd_file.put_line(FND_FILE.LOG,'Encountered Error when processing Invoice : ' ||st_forms_rec.document_type||':'|| st_forms_Rec.customer_Trx_id );

2058: v_base_tax_amt :=NULL;
2059:
2060: EXCEPTION
2061: WHEN OTHERS THEN
2062: fnd_file.put_line(FND_FILE.LOG,'Encountered Error when processing Invoice : ' ||st_forms_rec.document_type||':'|| st_forms_Rec.customer_Trx_id );
2063: fnd_file.put_line(FND_FILE.LOG,'Error reported is : ' || sqlerrm );
2064: v_some_errors := '1';
2065: rollback;
2066: EXIT; -- So that this CUSTOMER_TRX_ID is not processed further

Line 2063: fnd_file.put_line(FND_FILE.LOG,'Error reported is : ' || sqlerrm );

2059:
2060: EXCEPTION
2061: WHEN OTHERS THEN
2062: fnd_file.put_line(FND_FILE.LOG,'Encountered Error when processing Invoice : ' ||st_forms_rec.document_type||':'|| st_forms_Rec.customer_Trx_id );
2063: fnd_file.put_line(FND_FILE.LOG,'Error reported is : ' || sqlerrm );
2064: v_some_errors := '1';
2065: rollback;
2066: EXIT; -- So that this CUSTOMER_TRX_ID is not processed further
2067: END;