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 342: Fnd_File.put_line(Fnd_File.LOG, ' Start of getSTformsTaxBaseAmount');

338: and line_location_id = c_line_location_id
339: and nvl(po_distribution_id,1) = nvl(c_po_distribution_id,nvl(po_distribution_id,1)); /*Added NVL condition for bug # 12561167 */
340:
341: begin
342: Fnd_File.put_line(Fnd_File.LOG, ' Start of getSTformsTaxBaseAmount');
343:
344: open c_get_inv_dist_details;
345: fetch c_get_inv_dist_details into v_line_number, v_po_distribution_id, v_rcv_transaction_id, v_precedence_0, v_match_type;
346: --fetch c_get_inv_dist_details into v_invoice_distribution_id, v_po_distribution_id, v_rcv_transaction_id, v_precedence_0;

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

345: fetch c_get_inv_dist_details into v_line_number, v_po_distribution_id, v_rcv_transaction_id, v_precedence_0, v_match_type;
346: --fetch c_get_inv_dist_details into v_invoice_distribution_id, v_po_distribution_id, v_rcv_transaction_id, v_precedence_0;
347: close c_get_inv_dist_details;
348:
349: Fnd_File.put_line(Fnd_File.LOG, ' 0 precedence amount : ' || v_precedence_0 );
350:
351: If v_po_distribution_id is not null then /*Added by nprashar for bug # 12561167 */
352: open c_get_po_details(v_po_distribution_id);
353: fetch c_get_po_details into v_po_header_id, v_po_line_id, v_po_line_location_id;

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

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

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

465: c_line_location_id => v_po_line_location_id,
466: c_po_distribution_id => v_po_distribution_id);
467: FETCH c_receipt_base_amt INTO v_tax_base_amt;
468: CLOSE c_receipt_base_amt;
469: Fnd_File.put_line(Fnd_File.LOG, ' Calculated tax base from receipt taxes '); /*Ends here*/
470: end if;
471: --End addded by Aparajita for bug#3094025
472:
473:

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

470: end if;
471: --End addded by Aparajita for bug#3094025
472:
473:
474: Fnd_File.put_line(Fnd_File.LOG, ' End of getSTformsTaxBaseAmount : ' || v_tax_base_amt);
475: return v_tax_base_amt;
476:
477: exception
478: when others then

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

475: return v_tax_base_amt;
476:
477: exception
478: when others then
479: Fnd_File.put_line(Fnd_File.LOG, ' Error in getting tax base amount for ST forrms :' || sqlerrm);
480: Fnd_File.put_line(Fnd_File.LOG, ' Populated st forms tax target amount as 0');
481: return 0;
482: end getSTformsTaxBaseAmount;
483: -- end added by Aparajita for bug#3038566;

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

476:
477: exception
478: when others then
479: Fnd_File.put_line(Fnd_File.LOG, ' Error in getting tax base amount for ST forrms :' || sqlerrm);
480: Fnd_File.put_line(Fnd_File.LOG, ' Populated st forms tax target amount as 0');
481: return 0;
482: end getSTformsTaxBaseAmount;
483: -- end added by Aparajita for bug#3038566;
484:

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

553: ------------------------------------------------------------------------------------------------------- */
554: v_debug := jai_constants.yes ; --Ramananda for File.Sql.35
555:
556: if v_debug = 'Y' then
557: Fnd_File.put_line(Fnd_File.LOG, '**** ========================================== ****');
558: Fnd_File.put_line(Fnd_File.LOG, '**** Start procedure - jai_cmn_st_forms_pkg.generate_ap_forms ****');
559: end if;
560:
561: v_uid := fnd_global.USER_ID;

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

554: v_debug := jai_constants.yes ; --Ramananda for File.Sql.35
555:
556: if v_debug = 'Y' then
557: Fnd_File.put_line(Fnd_File.LOG, '**** ========================================== ****');
558: Fnd_File.put_line(Fnd_File.LOG, '**** Start procedure - jai_cmn_st_forms_pkg.generate_ap_forms ****');
559: end if;
560:
561: v_uid := fnd_global.USER_ID;
562:

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

589:
590: begin
591:
592: if v_debug = 'Y' then
593: Fnd_File.put_line(Fnd_File.LOG, ' ** Processing invoice (id) : '
594: || c_invoices.invoice_num || '('
595: || c_invoices.invoice_id || '}' );
596: end if;
597:

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

604: v_invoice_process_flag := 'N'; -- this invoice should not be processed.
605: v_not_processed_inv_cnt := v_not_processed_inv_cnt + 1;
606:
607: if v_debug = 'Y' then
608: Fnd_File.put_line(Fnd_File.LOG, ' Invoice is Cancelled - not processing' );
609: end if;
610:
611:
612: delete JAI_CMN_ST_FORM_DTLS a

Line 622: Fnd_File.put_line(Fnd_File.LOG,

618: and st_dtl_id = a.st_dtl_id
619: );
620:
621: if v_debug = 'Y' then
622: Fnd_File.put_line(Fnd_File.LOG,
623: ' No of unmatched records deleetd from st forms for this invoice :'
624: || to_char(sql%rowcount) );
625: end if;
626:

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

648: v_invoice_process_flag := 'N'; -- this invoice should not be processed.
649: v_not_processed_inv_cnt := v_not_processed_inv_cnt + 1;
650:
651: if v_debug = 'Y' then
652: Fnd_File.put_line(Fnd_File.LOG, ' Invoice is not validated - not processing' );
653: end if;
654:
655:
656: delete JAI_CMN_ST_FORM_DTLS a

Line 666: Fnd_File.put_line(Fnd_File.LOG,

662: and st_dtl_id = a.st_dtl_id
663: );
664:
665: if v_debug = 'Y' then
666: Fnd_File.put_line(Fnd_File.LOG,
667: ' No of unmatched records deleted from st forms for this invoice :'
668: || to_char(sql%rowcount) );
669: end if;
670:

Line 695: Fnd_File.put_line(Fnd_File.LOG,

691: and st_dtl_id = a.st_dtl_id
692: );
693:
694: if v_debug = 'Y' then
695: Fnd_File.put_line(Fnd_File.LOG,
696: ' Re-Process : No of unmatched records purged from st forms for this invoice :'
697: || to_char(sql%rowcount) );
698: end if;
699:

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

923: -- For partially recoverable taxes tax_target_amount needs to be apportioned
924: -- because there will be two lines one for recoverable and one for non recoverable
925: -- and for both the tax lines getSTFormsTaxBaseAmount will return same base amount
926: --
927: 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);
928: if v_mod_cr_pctg > 0 and v_mod_cr_pctg < 100 then
929: Fnd_File.put_line(Fnd_File.LOG, 'INSIDE IF1');
930: if lv_recoverable_flag = jai_constants.YES then
931: v_tax_target_amount := (v_tax_target_amount) * (v_mod_cr_pctg/100);

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

925: -- and for both the tax lines getSTFormsTaxBaseAmount will return same base amount
926: --
927: 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);
928: if v_mod_cr_pctg > 0 and v_mod_cr_pctg < 100 then
929: Fnd_File.put_line(Fnd_File.LOG, 'INSIDE IF1');
930: if lv_recoverable_flag = jai_constants.YES then
931: v_tax_target_amount := (v_tax_target_amount) * (v_mod_cr_pctg/100);
932: elsif lv_recoverable_flag = jai_constants.NO then
933: v_tax_target_amount := v_tax_target_amount * (1 - (v_mod_cr_pctg/100));

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

1030: elsif v_invoice_error_flag = 'Y' then
1031:
1032: rollback;
1033: if v_debug = 'Y' then
1034: Fnd_File.put_line(Fnd_File.LOG,' Error :' || v_error_message);
1035: end if;
1036: v_error_inv_cnt := v_error_inv_cnt + 1;
1037: v_error_flag := 'Y';
1038:

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

1039: else
1040:
1041: commit;
1042: if v_debug = 'Y' then
1043: Fnd_File.put_line(Fnd_File.LOG,' Successful : No of ST forms lines created for the invoice - '
1044: || to_char(v_st_lines_for_inv) );
1045: end if;
1046: v_processed_inv_cnt := v_processed_inv_cnt + 1;
1047:

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

1051:
1052: end loop; -- c_invoices
1053:
1054:
1055: Fnd_File.put_line(Fnd_File.LOG, '**** ======================= S U M M A R Y ======================= ****');
1056: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices processed successfully :'
1057: || to_char(v_processed_inv_cnt) );
1058:
1059: if v_not_processed_inv_cnt > 0 then

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

1052: end loop; -- c_invoices
1053:
1054:
1055: Fnd_File.put_line(Fnd_File.LOG, '**** ======================= S U M M A R Y ======================= ****');
1056: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices processed successfully :'
1057: || to_char(v_processed_inv_cnt) );
1058:
1059: if v_not_processed_inv_cnt > 0 then
1060: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices not processed for status - cancelled /not validated status :'

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

1056: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices processed successfully :'
1057: || to_char(v_processed_inv_cnt) );
1058:
1059: if v_not_processed_inv_cnt > 0 then
1060: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices not processed for status - cancelled /not validated status :'
1061: || to_char(v_not_processed_inv_cnt) );
1062: end if;
1063:
1064:

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

1063:
1064:
1065: if v_error_inv_cnt > 0 then
1066:
1067: Fnd_File.put_line(Fnd_File.LOG, '**** No of invoices for which error is encountered :'
1068: || to_char(v_error_inv_cnt) );
1069:
1070: p_ret_code := 1;
1071: p_err_buf := 'Please check the detailed log. '

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

1077:
1078: when others then
1079: p_ret_code := 2;
1080: p_err_buf := sqlerrm;
1081: Fnd_File.put_line(Fnd_File.LOG, '**** Exception from procedure ja_in_ap_populate_st_forms:' || sqlerrm);
1082:
1083: end generate_ap_forms;
1084:
1085: PROCEDURE generate_forms( errbuf OUT NOCOPY varchar2 ,

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

1184: ld_to_date := fnd_date.canonical_to_date(p_to_date) ;
1185:
1186: audsid := userenv('SESSIONID'); --Ramananda for File.Sql.35
1187:
1188: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure - jai_cmn_st_forms_pkg.generate_forms');
1189: 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 );
1190: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id : ' || p_party_id || ' p_party_site_id : ' || p_party_site_id);
1191: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date :' || p_from_date ||' p_to_date ' || p_to_date || ' Trace ' || P_Enable_Trace);
1192:

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

1185:
1186: audsid := userenv('SESSIONID'); --Ramananda for File.Sql.35
1187:
1188: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure - jai_cmn_st_forms_pkg.generate_forms');
1189: 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 );
1190: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id : ' || p_party_id || ' p_party_site_id : ' || p_party_site_id);
1191: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date :' || p_from_date ||' p_to_date ' || p_to_date || ' Trace ' || P_Enable_Trace);
1192:
1193: if P_Enable_Trace = 'Y' or P_Enable_Trace = 'y' then

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

1186: audsid := userenv('SESSIONID'); --Ramananda for File.Sql.35
1187:
1188: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure - jai_cmn_st_forms_pkg.generate_forms');
1189: 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 );
1190: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id : ' || p_party_id || ' p_party_site_id : ' || p_party_site_id);
1191: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date :' || p_from_date ||' p_to_date ' || p_to_date || ' Trace ' || P_Enable_Trace);
1192:
1193: if P_Enable_Trace = 'Y' or P_Enable_Trace = 'y' then
1194: execute immediate 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''' ;

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

1187:
1188: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure - jai_cmn_st_forms_pkg.generate_forms');
1189: 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 );
1190: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id : ' || p_party_id || ' p_party_site_id : ' || p_party_site_id);
1191: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date :' || p_from_date ||' p_to_date ' || p_to_date || ' Trace ' || P_Enable_Trace);
1192:
1193: if P_Enable_Trace = 'Y' or P_Enable_Trace = 'y' then
1194: execute immediate 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''' ;
1195:

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

1196: OPEN c_program_id(FND_GLOBAL.CONC_REQUEST_ID);
1197: FETCH c_program_id INTO v_program_id, v_enable_trace;
1198: CLOSE c_program_id;
1199:
1200: fnd_file.put_line(FND_FILE.LOG, 'v_program_id -> '||v_program_id
1201: ||', v_enable_trace -> '||v_enable_trace
1202: ||', request_id -> '||FND_GLOBAL.CONC_REQUEST_ID);
1203:
1204: if v_enable_trace = 'Y' THEN

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

1209: OPEN get_dbname;
1210: FETCH get_dbname INTO name1;
1211: CLOSE get_dbname;
1212:
1213: fnd_file.put_line(FND_FILE.LOG,'TraceFile Name = '||lower(name1)||'_ora_'||spid||'.trc');
1214: end if;
1215:
1216: -- trx gen ends here
1217: end if;

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

1264: );
1265: end if;
1266:
1267: if errbuf is not null then
1268: fnd_file.put_line(FND_FILE.LOG,'Encountered the Error ' || errbuf);
1269: end if;
1270:
1271: /* Added by Ramananda for bug#4407165 */
1272: EXCEPTION

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

1521:
1522: v_some_errors := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1523: v_order_flag := 'O'; --Ramananda for File.Sql.35
1524:
1525: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_iso_forms' );
1526: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1527: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1528: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1529:

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

1522: v_some_errors := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1523: v_order_flag := 'O'; --Ramananda for File.Sql.35
1524:
1525: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_iso_forms' );
1526: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1527: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1528: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1529:
1530: FOR st_forms_rec IN c_fetch_records

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

1523: v_order_flag := 'O'; --Ramananda for File.Sql.35
1524:
1525: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_iso_forms' );
1526: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1527: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1528: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1529:
1530: FOR st_forms_rec IN c_fetch_records
1531: LOOP

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

1524:
1525: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_iso_forms' );
1526: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
1527: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
1528: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
1529:
1530: FOR st_forms_rec IN c_fetch_records
1531: LOOP
1532:

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

1530: FOR st_forms_rec IN c_fetch_records
1531: LOOP
1532:
1533: /* duplicate check */
1534: fnd_file.put_line(FND_FILE.LOG,'1.0 Processing delivery : ' || st_forms_rec.delivery_id);
1535:
1536: v_record_exists := null;
1537:
1538: open c_check_duplicate(st_forms_rec.delivery_id);

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

1549: need to insert records into the st forms hdr and st forms detail tables.
1550: JAI_CMN_STFORM_HDRS_ALL
1551: JAI_CMN_ST_FORM_DTLS
1552: */
1553: fnd_file.put_line(FND_FILE.LOG,'1.1 Delivery : ' || st_forms_rec.delivery_id || ' not present in St form tables, hence processing.' );
1554:
1555: FOR tax_rec IN c_get_taxes(st_forms_rec.delivery_id)
1556: LOOP
1557: BEGIN

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

1603: fnd_global.login_id ,
1604: st_forms_rec.org_id ,
1605: 'C'
1606: ) RETURNING st_hdr_id INTO v_st_hdr_id;
1607: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_STFORM_HDRS_ALL table with header id '|| v_st_hdr_id);
1608: ELSE
1609:
1610: v_st_hdr_id := v_hdr_record_exists;
1611: fnd_file.put_line(FND_FILE.LOG,'header record found . Header id is : ' ||v_st_hdr_id);

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

1607: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_STFORM_HDRS_ALL table with header id '|| v_st_hdr_id);
1608: ELSE
1609:
1610: v_st_hdr_id := v_hdr_record_exists;
1611: fnd_file.put_line(FND_FILE.LOG,'header record found . Header id is : ' ||v_st_hdr_id);
1612:
1613:
1614: END IF;
1615:

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

1687: fnd_global.user_id ,
1688: fnd_global.login_id
1689:
1690: ) RETURNING st_dtl_id INTO v_st_line_id;
1691: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_ST_FORM_DTLS table with detail id :' ||v_st_line_id );
1692: v_base_tax_amt :=NULL;
1693:
1694: EXCEPTION
1695: WHEN OTHERS THEN

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

1692: v_base_tax_amt :=NULL;
1693:
1694: EXCEPTION
1695: WHEN OTHERS THEN
1696: fnd_file.put_line(FND_FILE.LOG,'Encountered Error when processing Delivery : ' || st_forms_Rec.delivery_id );
1697: fnd_file.put_line(FND_FILE.LOG,'Error reported is : ' || sqlerrm );
1698: v_some_errors := '1';
1699: rollback;
1700: EXIT; -- So that this delivery_id is not processed further

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

1693:
1694: EXCEPTION
1695: WHEN OTHERS THEN
1696: fnd_file.put_line(FND_FILE.LOG,'Encountered Error when processing Delivery : ' || st_forms_Rec.delivery_id );
1697: fnd_file.put_line(FND_FILE.LOG,'Error reported is : ' || sqlerrm );
1698: v_some_errors := '1';
1699: rollback;
1700: EXIT; -- So that this delivery_id is not processed further
1701: END;

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

2010:
2011: v_some_errors := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
2012: v_order_flag := 'O'; --Ramananda for File.Sql.35
2013:
2014: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_ar_forms' );
2015: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
2016: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
2017: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
2018:

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

2011: v_some_errors := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
2012: v_order_flag := 'O'; --Ramananda for File.Sql.35
2013:
2014: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_ar_forms' );
2015: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
2016: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
2017: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
2018:
2019: FOR st_forms_rec IN c_fetch_records

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

2012: v_order_flag := 'O'; --Ramananda for File.Sql.35
2013:
2014: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_ar_forms' );
2015: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
2016: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
2017: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
2018:
2019: FOR st_forms_rec IN c_fetch_records
2020: LOOP

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

2013:
2014: fnd_file.put_line(FND_FILE.LOG,'1 Entering procedure : jai_cmn_st_forms_pkg.generate_ar_forms' );
2015: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_org_id -> : '|| p_org_id || ' p_party_type -> :' || p_party_type );
2016: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_party_id -> : ' || p_party_id || ' p_party_site_id -> : ' || p_party_site_id);
2017: fnd_file.put_line(FND_FILE.LOG,'Parameters - p_from_date -> :' || p_from_date ||' p_to_date -> :' || p_to_date);
2018:
2019: FOR st_forms_rec IN c_fetch_records
2020: LOOP
2021:

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

2019: FOR st_forms_rec IN c_fetch_records
2020: LOOP
2021:
2022: /* duplicate check */
2023: fnd_file.put_line(FND_FILE.LOG,'1.0 Processing invoice : '||st_forms_rec.document_type||':' || st_forms_rec.customer_trx_id);
2024:
2025: v_record_exists := null;
2026: -- Added Parameter st_forms_rec.trx_number for bug#9113108 by nprashar
2027: open c_check_duplicate(st_forms_rec.customer_trx_id, st_forms_rec.trx_number);

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

2038: need to insert records into the st forms hdr and st forms detail tables.
2039: JAI_CMN_STFORM_HDRS_ALL
2040: JAI_CMN_ST_FORM_DTLS
2041: */
2042: 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.' );
2043:
2044: FOR tax_rec IN c_get_taxes(st_forms_rec.customer_trx_id)
2045: LOOP
2046: BEGIN

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

2068: /* no record exists in the st forms hdr table (JAI_CMN_STFORM_HDRS_ALL) for the combination of
2069: party , party site , form_type , org_id and party type.
2070: */
2071:
2072: fnd_file.put_line(FND_FILE.LOG,'before inserting into JAI_CMN_STFORM_HDRS_ALL table');
2073: INSERT INTO JAI_CMN_STFORM_HDRS_ALL(
2074: st_hdr_id ,
2075: party_id ,
2076: party_site_id ,

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

2151: fetch c_orgn_locn into v_orgn_id , v_locn_id;
2152: close c_orgn_locn;
2153: end if;
2154:
2155: fnd_file.put_line(FND_FILE.LOG,'before inserting into JAI_CMN_ST_FORM_DTLS table');
2156:
2157: INSERT INTO JAI_CMN_ST_FORM_DTLS(
2158: ST_HDR_ID ,
2159: ST_DTL_ID ,

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

2205: v_base_tax_amt :=NULL;
2206:
2207: EXCEPTION
2208: WHEN OTHERS THEN
2209: fnd_file.put_line(FND_FILE.LOG,'Encountered Error when processing Invoice : ' ||st_forms_rec.document_type||':'|| st_forms_Rec.customer_Trx_id );
2210: fnd_file.put_line(FND_FILE.LOG,'Error reported is : ' || sqlerrm );
2211: v_some_errors := '1';
2212: rollback;
2213: EXIT; -- So that this CUSTOMER_TRX_ID is not processed further

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

2206:
2207: EXCEPTION
2208: WHEN OTHERS THEN
2209: fnd_file.put_line(FND_FILE.LOG,'Encountered Error when processing Invoice : ' ||st_forms_rec.document_type||':'|| st_forms_Rec.customer_Trx_id );
2210: fnd_file.put_line(FND_FILE.LOG,'Error reported is : ' || sqlerrm );
2211: v_some_errors := '1';
2212: rollback;
2213: EXIT; -- So that this CUSTOMER_TRX_ID is not processed further
2214: END;