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

Line 104: Added few more fnd_file statements.

100: jai_om_rg.pls 120.2
101: jai_om_wsh.plb 120.3
102:
103: 02-DEC-2005 Bug 4765347, Added by aiyer for Version 120.4
104: Added few more fnd_file statements.
105:
106: Dependencies Due to this issue :-
107: Yes, please refer the future dependencies section.
108:

Line 294: Fnd_File.PUT_LINE(Fnd_File.LOG, ' start of JA_IN_CESS_ENTRIES with p_delivery_detail_id = ' || p_delivery_detail_id);

290: So no further check is done here for the same.
291: */
292: begin
293:
294: Fnd_File.PUT_LINE(Fnd_File.LOG, ' start of JA_IN_CESS_ENTRIES with p_delivery_detail_id = ' || p_delivery_detail_id);
295:
296: v_Delivery_id :=0;
297: open c_delivery_cur(p_delivery_detail_id);
298: fetch c_delivery_cur into v_Delivery_id, v_org_id;

Line 301: Fnd_File.PUT_LINE(Fnd_File.LOG, 'v_Delivery_id =, Org id = ' || v_Delivery_id || ' : ' || v_org_id);

297: open c_delivery_cur(p_delivery_detail_id);
298: fetch c_delivery_cur into v_Delivery_id, v_org_id;
299: close c_delivery_cur;
300:
301: Fnd_File.PUT_LINE(Fnd_File.LOG, 'v_Delivery_id =, Org id = ' || v_Delivery_id || ' : ' || v_org_id);
302:
303: if v_delivery_id > 0 then
304:
305: open c_cess_amount(v_Delivery_id);

Line 330: Fnd_File.PUT_LINE(Fnd_File.LOG, 'v_currency_code =, v_precision = , v_cess_paid_payable =' || v_currency_code || ' : ' || v_precision || ' : ' || v_cess_paid_payable );

326: (p_org_id => v_org_id );
327: v_currency_code := l_func_curr_det.currency_code;
328: v_precision := l_func_curr_det.precision;
329:
330: Fnd_File.PUT_LINE(Fnd_File.LOG, 'v_currency_code =, v_precision = , v_cess_paid_payable =' || v_currency_code || ' : ' || v_precision || ' : ' || v_cess_paid_payable );
331:
332: if v_precision is null then
333: v_precision :=0;
334: end if;

Line 339: Fnd_File.PUT_LINE(Fnd_File.LOG, 'v_cess_amount = ' || v_cess_amount);

335:
336: v_cess_amount := round(v_cess_amount,v_precision);
337: v_sh_cess_amount := round(v_sh_cess_amount,v_precision);/*Bug 5989740 bduvarag*/
338:
339: Fnd_File.PUT_LINE(Fnd_File.LOG, 'v_cess_amount = ' || v_cess_amount);
340:
341: if v_cess_amount > 0 then
342:
343: -- Dr Intransit Material Value

Line 344: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling gl_interface for CESS ');

340:
341: if v_cess_amount > 0 then
342:
343: -- Dr Intransit Material Value
344: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling gl_interface for CESS ');
345:
346: jai_cmn_gl_pkg.create_gl_entry
347: (p_organization_id,
348: p_currency_code,

Line 394: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling gl_interface for CESS ');

390: if p_fob_point =1 then -- fobpoint =(shipment)
391:
392:
393: -- Dr Intercompany Receivable
394: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling gl_interface for CESS ');
395:
396: jai_cmn_gl_pkg.create_gl_entry
397: (p_organization_id,
398: p_currency_code,

Line 490: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling gl_interface for CESS ');

486: if p_fob_point =1 then -- fobpoint =(shipment)
487:
488:
489: -- Dr Intercompany Receivable
490: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling gl_interface for CESS ');
491:
492: jai_cmn_gl_pkg.create_gl_entry
493: (p_organization_id,
494: p_currency_code,

Line 539: Fnd_File.PUT_LINE(Fnd_File.LOG, ' End of JA_IN_CESS_ENTRIES');

535: end if;
536: /*Bug 5989740 bduvarag*/
537: end if;
538:
539: Fnd_File.PUT_LINE(Fnd_File.LOG, ' End of JA_IN_CESS_ENTRIES');
540:
541: EXCEPTION
542: WHEN OTHERS THEN
543: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');

Line 579: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling gl_interface for credit entry for CESS' );

575: **********************************************************************/
576: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_acctg_entries';
577: begin
578:
579: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling gl_interface for credit entry for CESS' );
580:
581:
582: if p_debit_account is null or p_credit_account is null then
583: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cess Accounts have not been setup in Organization Additional Information Screen - Cannot Process' ); --Added for bug#7172215

Line 583: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cess Accounts have not been setup in Organization Additional Information Screen - Cannot Process' ); --Added for bug#7172215

579: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling gl_interface for credit entry for CESS' );
580:
581:
582: if p_debit_account is null or p_credit_account is null then
583: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cess Accounts have not been setup in Organization Additional Information Screen - Cannot Process' ); --Added for bug#7172215
584: raise_application_error(-20107,'Cess Accounts have not been setup in Organization Additional Information Screen - Cannot Process');
585: end if;
586:
587: jai_cmn_gl_pkg.create_gl_entry(

Line 606: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling gl_interface for debit entry for CESS' );

602: P_REFERENCE_25 => p_reference_25 ,
603: P_REFERENCE_26 => p_reference_26
604: );
605:
606: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling gl_interface for debit entry for CESS' );
607: jai_cmn_gl_pkg.create_gl_entry(
608: P_ORGANIZATION_ID => p_inv_orgn_id ,
609: P_CURRENCY_CODE => p_currency_code ,
610: P_CREDIT_AMOUNT => NULL ,

Line 719: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling jai_Rg_others_pkg.insert_row');

715: FOR tax_type_rec IN c_tax_type_rec
716: LOOP
717: ln_Cess_amount := ln_Cess_amount + nvl(tax_type_rec.tax_amount,0);
718:
719: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling jai_Rg_others_pkg.insert_row');
720:
721: jai_cmn_rg_others_pkg.insert_row(
722: P_SOURCE_TYPE => p_source_type ,
723: P_SOURCE_NAME => p_source_name ,

Line 732: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);

728: P_PROCESS_FLAG => lv_process_flag ,
729: P_PROCESS_MSG => lv_process_msg
730: );
731:
732: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
733: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
734: IF lv_process_flag <> jai_constants.successful THEN
735: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
736: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);

Line 733: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);

729: P_PROCESS_MSG => lv_process_msg
730: );
731:
732: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
733: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
734: IF lv_process_flag <> jai_constants.successful THEN
735: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
736: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);
737: END IF;

Line 735: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215

731:
732: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
733: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
734: IF lv_process_flag <> jai_constants.successful THEN
735: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
736: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);
737: END IF;
738:
739: END LOOP;

Line 753: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling jai_Rg_others_pkg.insert_row');

749: FOR tax_type_rec IN c_tax_type_for_delivery_rec
750: LOOP
751: ln_Cess_amount := ln_Cess_amount + nvl(tax_type_rec.tax_amount,0);
752:
753: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling jai_Rg_others_pkg.insert_row');
754:
755: jai_cmn_rg_others_pkg.insert_row(
756: P_SOURCE_TYPE => p_source_type ,
757: P_SOURCE_NAME => p_source_name ,

Line 766: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);

762: P_PROCESS_FLAG => lv_process_flag ,
763: P_PROCESS_MSG => lv_process_msg
764: );
765:
766: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
767: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
768: IF lv_process_flag <> jai_constants.successful THEN
769: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
770: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);

Line 767: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);

763: P_PROCESS_MSG => lv_process_msg
764: );
765:
766: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
767: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
768: IF lv_process_flag <> jai_constants.successful THEN
769: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
770: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);
771: END IF;

Line 769: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215

765:
766: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
767: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
768: IF lv_process_flag <> jai_constants.successful THEN
769: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
770: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);
771: END IF;
772:
773: END LOOP;

Line 998: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling ja_in_cess_acctg_entries' );

994: p_cess_type => p_cess_type/*Bug 5989740 bduvarag*/
995: );
996: end if;
997:
998: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling ja_in_cess_acctg_entries' );
999: /*
1000: -- MXYZ No Cess A/c in trading scenario
1001: */
1002: if p_source_type <> 3 then

Line 1020: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after calling ja_in_cess_acctg_entries' );

1016: P_REFERENCE_25 ,
1017: P_REFERENCE_26
1018: );
1019: End If;
1020: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after calling ja_in_cess_acctg_entries' );
1021: end if;
1022:
1023: p_cess_amount := ln_Cess_amount;
1024:

Line 1255: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );

1251: FETCH c_get_order_details INTO
1252: v_from_organization_id, v_order_source_id, v_requisition_header_id, v_requisition_line_id;
1253: CLOSE c_get_order_details;
1254:
1255: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
1256: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id='||v_order_header_id||', v_order_line_id='|| v_order_line_id );
1257: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_from_organization_id='||v_from_organization_id||', v_order_source_id='||v_order_source_id||', v_requisition_header_id='||v_requisition_header_id||', v_requisition_line_id='||v_requisition_line_id);
1258:
1259: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_non_iso_credit_account_id ='||p_non_iso_credit_account_id|| 'and p_non_iso_debit_account_id ='||p_non_iso_debit_account_id);

Line 1256: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id='||v_order_header_id||', v_order_line_id='|| v_order_line_id );

1252: v_from_organization_id, v_order_source_id, v_requisition_header_id, v_requisition_line_id;
1253: CLOSE c_get_order_details;
1254:
1255: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
1256: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id='||v_order_header_id||', v_order_line_id='|| v_order_line_id );
1257: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_from_organization_id='||v_from_organization_id||', v_order_source_id='||v_order_source_id||', v_requisition_header_id='||v_requisition_header_id||', v_requisition_line_id='||v_requisition_line_id);
1258:
1259: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_non_iso_credit_account_id ='||p_non_iso_credit_account_id|| 'and p_non_iso_debit_account_id ='||p_non_iso_debit_account_id);
1260:

Line 1257: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_from_organization_id='||v_from_organization_id||', v_order_source_id='||v_order_source_id||', v_requisition_header_id='||v_requisition_header_id||', v_requisition_line_id='||v_requisition_line_id);

1253: CLOSE c_get_order_details;
1254:
1255: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
1256: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id='||v_order_header_id||', v_order_line_id='|| v_order_line_id );
1257: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_from_organization_id='||v_from_organization_id||', v_order_source_id='||v_order_source_id||', v_requisition_header_id='||v_requisition_header_id||', v_requisition_line_id='||v_requisition_line_id);
1258:
1259: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_non_iso_credit_account_id ='||p_non_iso_credit_account_id|| 'and p_non_iso_debit_account_id ='||p_non_iso_debit_account_id);
1260:
1261:

Line 1259: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_non_iso_credit_account_id ='||p_non_iso_credit_account_id|| 'and p_non_iso_debit_account_id ='||p_non_iso_debit_account_id);

1255: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
1256: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id='||v_order_header_id||', v_order_line_id='|| v_order_line_id );
1257: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_from_organization_id='||v_from_organization_id||', v_order_source_id='||v_order_source_id||', v_requisition_header_id='||v_requisition_header_id||', v_requisition_line_id='||v_requisition_line_id);
1258:
1259: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_non_iso_credit_account_id ='||p_non_iso_credit_account_id|| 'and p_non_iso_debit_account_id ='||p_non_iso_debit_account_id);
1260:
1261:
1262: -- IF NVL(v_order_source_id, 0) <> 10 THEN, commented by Aparajita for bug # 2848921
1263:

Line 1270: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_to_organization_id = ' || v_to_organization_id );

1266: OPEN debit_account_cur(v_from_organization_id , p_location_id);
1267: FETCH debit_account_cur INTO v_excise_rcvble_account , ln_src_excise_23d_account, ln_src_excise_in_rg23d, lv_source_trading, lv_source_manufacturing;
1268: CLOSE debit_account_cur;
1269:
1270: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_to_organization_id = ' || v_to_organization_id );
1271: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_intransit_type, v_fob_point ' || v_intransit_type || ' , ' || v_fob_point);
1272: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_excise_rcvble_account , v_intransit_inv_account ' || v_excise_rcvble_account || ', ' || v_intransit_inv_account );
1273:
1274: OPEN debit_account_cur(v_to_organization_id , ln_to_location_id );

Line 1271: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_intransit_type, v_fob_point ' || v_intransit_type || ' , ' || v_fob_point);

1267: FETCH debit_account_cur INTO v_excise_rcvble_account , ln_src_excise_23d_account, ln_src_excise_in_rg23d, lv_source_trading, lv_source_manufacturing;
1268: CLOSE debit_account_cur;
1269:
1270: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_to_organization_id = ' || v_to_organization_id );
1271: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_intransit_type, v_fob_point ' || v_intransit_type || ' , ' || v_fob_point);
1272: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_excise_rcvble_account , v_intransit_inv_account ' || v_excise_rcvble_account || ', ' || v_intransit_inv_account );
1273:
1274: OPEN debit_account_cur(v_to_organization_id , ln_to_location_id );
1275: FETCH debit_account_cur INTO ln_dest_excise_rcvble_account , ln_dest_excise_23d_account , ln_dest_excise_in_rg23d ,lv_dest_trading, lv_dest_manufacturing;

Line 1272: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_excise_rcvble_account , v_intransit_inv_account ' || v_excise_rcvble_account || ', ' || v_intransit_inv_account );

1268: CLOSE debit_account_cur;
1269:
1270: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_to_organization_id = ' || v_to_organization_id );
1271: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_intransit_type, v_fob_point ' || v_intransit_type || ' , ' || v_fob_point);
1272: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_excise_rcvble_account , v_intransit_inv_account ' || v_excise_rcvble_account || ', ' || v_intransit_inv_account );
1273:
1274: OPEN debit_account_cur(v_to_organization_id , ln_to_location_id );
1275: FETCH debit_account_cur INTO ln_dest_excise_rcvble_account , ln_dest_excise_23d_account , ln_dest_excise_in_rg23d ,lv_dest_trading, lv_dest_manufacturing;
1276: CLOSE debit_account_cur;

Line 1279: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Excise Payable Accounts (RG23A/C/PLA) have not been setup in Organization Additional Information Screen - Cannot Process for Accounting');

1275: FETCH debit_account_cur INTO ln_dest_excise_rcvble_account , ln_dest_excise_23d_account , ln_dest_excise_in_rg23d ,lv_dest_trading, lv_dest_manufacturing;
1276: CLOSE debit_account_cur;
1277: --Added for bug#7277543
1278: IF p_non_iso_credit_account_id IS NULL OR p_non_iso_debit_account_id IS NULL THEN
1279: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Excise Payable Accounts (RG23A/C/PLA) have not been setup in Organization Additional Information Screen - Cannot Process for Accounting');
1280: END IF;
1281: --End bug#7277543
1282: IF NVL(p_non_iso_credit_account_id,0) >0 AND NVL(p_non_iso_debit_account_id,0) >0 AND
1283: NOT /* The NOT part of the if condition added by ssumaith - bug# 4171469 */

Line 1303: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling gl interface -1 ');

1299: )
1300: THEN
1301:
1302: -- v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
1303: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling gl interface -1 ');
1304: jai_cmn_gl_pkg.create_gl_entry
1305: (
1306: p_org_id,
1307: p_currency_code,

Line 1489: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Excise Receivable account or Intransit Invoice Account have not been setup in Organization Additional Information Screen - Cannot Process for Accounting');

1485: ends here additions by ssumaith - bug# 4171469
1486: */
1487: --Added for bug#7277543
1488: IF v_excise_rcvble_account IS NULL OR v_intransit_inv_account IS NULL THEN
1489: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Excise Receivable account or Intransit Invoice Account have not been setup in Organization Additional Information Screen - Cannot Process for Accounting');
1490: END IF;
1491: --End bug#7277543
1492: IF NVL(v_excise_rcvble_account,0) >0 AND NVL(v_intransit_inv_account,0) >0 THEN
1493:

Line 1495: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling gl interface - 2 ');

1491: --End bug#7277543
1492: IF NVL(v_excise_rcvble_account,0) >0 AND NVL(v_intransit_inv_account,0) >0 THEN
1493:
1494: --CREDIT Excise Paid Payable Account
1495: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling gl interface - 2 ');
1496: jai_cmn_gl_pkg.create_gl_entry
1497: (
1498: p_org_id,
1499: p_currency_code,

Line 1548: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Interorg Payables Account or Interorg Receivables Account have not been setup in Organization Additional Information Screen - Cannot Process for Accounting');

1544:
1545: IF v_fob_point=1 THEN
1546: --Added for bug#7277543
1547: IF v_interorg_payables_account IS NULL OR v_interorg_receivables_account IS NULL THEN
1548: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Interorg Payables Account or Interorg Receivables Account have not been setup in Organization Additional Information Screen - Cannot Process for Accounting');
1549: END IF;
1550: --End bug#7277543
1551:
1552: IF NVL(v_interorg_payables_account, 0) >0 AND NVL(v_interorg_receivables_account,0) >0 THEN

Line 1555: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling gl interface - 3 ');

1551:
1552: IF NVL(v_interorg_payables_account, 0) >0 AND NVL(v_interorg_receivables_account,0) >0 THEN
1553:
1554: -- DEBIT Inter Org Receivables Account
1555: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling gl interface - 3 ');
1556:
1557: jai_cmn_gl_pkg.create_gl_entry
1558: ( p_org_id,
1559: p_currency_code,

Line 1612: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling gl interface - 4 ');

1608:
1609: IF NVL(v_excise_rcvble_account, 0) >0 AND NVL(v_interorg_receivables_account,0) >0 THEN
1610:
1611: --CREDIT Excise Paid Payable Account
1612: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling gl interface - 4 ');
1613:
1614: jai_cmn_gl_pkg.create_gl_entry
1615: (
1616: p_org_id,

Line 1659: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling JA_IN_CESS_ENTRIES');

1655: END IF; --End if for Account Checks. */
1656: -- type is transit, extra accounting entries
1657:
1658: -- start additions by ssumaith - bug#3817625
1659: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling JA_IN_CESS_ENTRIES');
1660:
1661: JA_IN_CESS_ENTRIES
1662: (
1663: p_organization_id => p_org_id ,

Line 1681: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after calling JA_IN_CESS_ENTRIES');

1677: P_REF_25 => P_REF_25 ,
1678: P_REF_26 => P_REF_26
1679: );
1680: END IF;/*Bug 5989740 bduvarag*/
1681: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after calling JA_IN_CESS_ENTRIES');
1682: -- start additions by ssumaith - bug#3817625
1683: END IF; -- internal order.
1684:
1685: <>

Line 2505: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in rg pkg p_excise_exempt_type is ' || p_excise_exempt_type);

2501: OPEN RANGE_DIVISION_CUR;
2502: FETCH RANGE_DIVISION_CUR INTO v_range_no,v_division_no;
2503: CLOSE RANGE_DIVISION_CUR;
2504:
2505: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in rg pkg p_excise_exempt_type is ' || p_excise_exempt_type);
2506:
2507: IF p_excise_exempt_type IN ('CT2', 'EXCISE_EXEMPT_CERT','CT2_OTH', 'EXCISE_EXEMPT_CERT_OTH' ,'CT3') THEN
2508:
2509: -- CT3 added by sriram into the list. Bug # 2796717. 16/mar/2003

Line 2534: Fnd_File.PUT_LINE(Fnd_File.LOG, ' debit account id is ' || v_debit_account_id);

2530: FETCH debit_account_cur INTO v_debit_account_id, v_cess_debit_account_id,v_sh_cess_debit_account_id /*Bug 5989740 bduvarag*/;
2531: CLOSE debit_account_cur;
2532: END IF;
2533:
2534: Fnd_File.PUT_LINE(Fnd_File.LOG, ' debit account id is ' || v_debit_account_id);
2535: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Cess debit account id is ' || v_cess_debit_account_id);
2536: Fnd_File.PUT_LINE(Fnd_File.LOG, ' SH Cess debit account id is ' || v_sh_cess_debit_account_id);
2537: --Added for bug#7277543
2538: IF v_debit_account_id IS NULL OR v_cess_debit_account_id IS NULL OR v_sh_cess_debit_account_id IS NULL THEN

Line 2535: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Cess debit account id is ' || v_cess_debit_account_id);

2531: CLOSE debit_account_cur;
2532: END IF;
2533:
2534: Fnd_File.PUT_LINE(Fnd_File.LOG, ' debit account id is ' || v_debit_account_id);
2535: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Cess debit account id is ' || v_cess_debit_account_id);
2536: Fnd_File.PUT_LINE(Fnd_File.LOG, ' SH Cess debit account id is ' || v_sh_cess_debit_account_id);
2537: --Added for bug#7277543
2538: IF v_debit_account_id IS NULL OR v_cess_debit_account_id IS NULL OR v_sh_cess_debit_account_id IS NULL THEN
2539: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Debit or Cess Debit or SH Cess Debit Accounts have not been setup in Organization Additional Information Screen ' );

Line 2536: Fnd_File.PUT_LINE(Fnd_File.LOG, ' SH Cess debit account id is ' || v_sh_cess_debit_account_id);

2532: END IF;
2533:
2534: Fnd_File.PUT_LINE(Fnd_File.LOG, ' debit account id is ' || v_debit_account_id);
2535: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Cess debit account id is ' || v_cess_debit_account_id);
2536: Fnd_File.PUT_LINE(Fnd_File.LOG, ' SH Cess debit account id is ' || v_sh_cess_debit_account_id);
2537: --Added for bug#7277543
2538: IF v_debit_account_id IS NULL OR v_cess_debit_account_id IS NULL OR v_sh_cess_debit_account_id IS NULL THEN
2539: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Debit or Cess Debit or SH Cess Debit Accounts have not been setup in Organization Additional Information Screen ' );
2540: END IF;

Line 2539: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Debit or Cess Debit or SH Cess Debit Accounts have not been setup in Organization Additional Information Screen ' );

2535: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Cess debit account id is ' || v_cess_debit_account_id);
2536: Fnd_File.PUT_LINE(Fnd_File.LOG, ' SH Cess debit account id is ' || v_sh_cess_debit_account_id);
2537: --Added for bug#7277543
2538: IF v_debit_account_id IS NULL OR v_cess_debit_account_id IS NULL OR v_sh_cess_debit_account_id IS NULL THEN
2539: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Debit or Cess Debit or SH Cess Debit Accounts have not been setup in Organization Additional Information Screen ' );
2540: END IF;
2541: --End bug#7277543
2542: /* Bug 4931887. Added by Lakshmi Gopalsami
2543: Re-used the cursor get_curr_code for fixing perf. issue reported.

Line 2553: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_register_type is ' || p_register_type);

2549: OPEN ssi_unit_flag_cur;
2550: FETCH ssi_unit_flag_cur INTO v_ssi_unit_flag;
2551: CLOSE ssi_unit_flag_cur;
2552:
2553: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_register_type is ' || p_register_type);
2554: IF p_register_type = 'A' THEN
2555: OPEN rm_account_cur;
2556: FETCH rm_account_cur INTO v_account_id , v_cess_account_id,v_sh_cess_account_id; /*Bug 5989740 bduvarag*/
2557: CLOSE rm_account_cur;

Line 2568: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_previous_serial_no is ' || v_previous_serial_no);

2564: OPEN serial_no_cur;
2565: FETCH serial_no_cur INTO v_previous_serial_no, v_serial_no;
2566: CLOSE serial_no_cur;
2567:
2568: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_previous_serial_no is ' || v_previous_serial_no);
2569: IF NVL(v_previous_serial_no,0) = 0 THEN
2570: v_previous_serial_no := 0;
2571: v_serial_no := 1;
2572: END IF;

Line 2574: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_previous_serial_no is ' || v_previous_serial_no);

2570: v_previous_serial_no := 0;
2571: v_serial_no := 1;
2572: END IF;
2573:
2574: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_previous_serial_no is ' || v_previous_serial_no);
2575: IF NVL(v_previous_serial_no,0) > 0 THEN
2576:
2577: OPEN balance_cur(v_previous_serial_no);
2578: FETCH balance_cur INTO v_opening_balance, v_closing_balance;

Line 2584: Fnd_File.PUT_LINE(Fnd_File.LOG, ' opening and closing balances : ' || v_opening_balance || ' and ' || v_closing_balance);

2580:
2581: v_opening_balance := v_closing_balance;
2582: v_closing_balance := v_closing_balance - (NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0));
2583:
2584: Fnd_File.PUT_LINE(Fnd_File.LOG, ' opening and closing balances : ' || v_opening_balance || ' and ' || v_closing_balance);
2585: IF NVL(v_closing_balance,0) < 0 THEN
2586: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN
2587: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the RG23 PART II Opening Balance ---'|| TO_CHAR(v_opening_balance)); --Added for bug#7172215
2588: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the RG23 PART II Opening Balance ---'|| TO_CHAR(v_opening_balance));

Line 2587: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the RG23 PART II Opening Balance ---'|| TO_CHAR(v_opening_balance)); --Added for bug#7172215

2583:
2584: Fnd_File.PUT_LINE(Fnd_File.LOG, ' opening and closing balances : ' || v_opening_balance || ' and ' || v_closing_balance);
2585: IF NVL(v_closing_balance,0) < 0 THEN
2586: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN
2587: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the RG23 PART II Opening Balance ---'|| TO_CHAR(v_opening_balance)); --Added for bug#7172215
2588: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the RG23 PART II Opening Balance ---'|| TO_CHAR(v_opening_balance));
2589: END IF;
2590: END IF;
2591:

Line 2611: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the RG23 PART II Opening Balance ---'|| TO_CHAR(v_rg_balance)); --Added for bug#7172215

2607: v_closing_balance := NVL(v_rg_balance,0) - (NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0));
2608:
2609: IF v_closing_balance < 0 THEN
2610: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN
2611: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the RG23 PART II Opening Balance ---'|| TO_CHAR(v_rg_balance)); --Added for bug#7172215
2612: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the RG23 PART II Opening Balance '|| TO_CHAR(v_rg_balance));
2613: END IF;
2614: END IF;
2615:

Line 2617: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before insert into JAI_CMN_RG_23AC_II_TRXS');

2613: END IF;
2614: END IF;
2615:
2616: END IF;
2617: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before insert into JAI_CMN_RG_23AC_II_TRXS');
2618:
2619: select JAI_CMN_RG_23AC_II_TRXS_S.NEXTVAL
2620: into ln_register_id
2621: from dual;

Line 2683: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after insert into JAI_CMN_RG_23AC_II_TRXS');

2679: p_last_updated_by,
2680: p_remarks
2681: );
2682:
2683: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after insert into JAI_CMN_RG_23AC_II_TRXS');
2684: -- Code has been modified here by Aparajita on 08/03/2002 for bug # 2496388
2685:
2686: IF p_register_code <>'BOND_REG' THEN
2687:

Line 2689: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling ja_in_accounting entries procedure');

2685:
2686: IF p_register_code <>'BOND_REG' THEN
2687:
2688: v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
2689: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling ja_in_accounting entries procedure');
2690: ja_in_accounting_entries
2691: (
2692: p_org_id,
2693: p_location_id,

Line 2708: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling ja_in_accounting entries procedure');

2704: P_REF_24,
2705: P_REF_25,
2706: P_REF_26
2707: );
2708: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling ja_in_accounting entries procedure');
2709:
2710:
2711: ja_in_cess_register_entries(p_register_id => ln_register_id ,
2712: p_register_type => p_register_type ,

Line 2937: fnd_file.put_line(fnd_file.log, '1 Start of procedure jai_om_rg_pkg.ja_in_pla_entry');

2933:
2934: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_pla_entry';
2935:
2936: BEGIN
2937: fnd_file.put_line(fnd_file.log, '1 Start of procedure jai_om_rg_pkg.ja_in_pla_entry');
2938: OPEN RANGE_DIVISION_CUR;
2939: FETCH RANGE_DIVISION_CUR INTO v_range_no,v_division_no;
2940: CLOSE RANGE_DIVISION_CUR;
2941:

Line 2971: Fnd_File.PUT_LINE(Fnd_File.LOG, '2 before call to jai_cmn_bond_register_pkg.get_register_id ');

2967: FETCH c_order_type_id INTO v_order_type_id;
2968: CLOSE c_order_type_id;
2969:
2970: --sriram - bug # 3021588 and using the following procedure call instead.
2971: Fnd_File.PUT_LINE(Fnd_File.LOG, '2 before call to jai_cmn_bond_register_pkg.get_register_id ');
2972:
2973: jai_cmn_bond_register_pkg.get_register_id (p_org_id ,
2974: p_location_id,
2975: v_order_type_id, -- order type id

Line 2980: Fnd_File.PUT_LINE(Fnd_File.LOG, '3 after call from jai_cmn_bond_register_pkg.get_register_id ');

2976: 'Y', -- order invoice type
2977: v_asst_register_id, -- out parameter to get the register id
2978: v_register_code);
2979:
2980: Fnd_File.PUT_LINE(Fnd_File.LOG, '3 after call from jai_cmn_bond_register_pkg.get_register_id ');
2981: IF NVL(v_previous_serial_no,0) = 0 THEN
2982: v_previous_serial_no := 0;
2983: v_serial_no := 1;
2984: END IF;

Line 2986: Fnd_File.PUT_LINE(Fnd_File.LOG, '4 p_org_id -> ' ||p_org_id

2982: v_previous_serial_no := 0;
2983: v_serial_no := 1;
2984: END IF;
2985:
2986: Fnd_File.PUT_LINE(Fnd_File.LOG, '4 p_org_id -> ' ||p_org_id
2987: ||' ,p_location_id -> ' ||p_location_id
2988: ||' ,v_order_type_id -> ' ||v_order_type_id
2989: ||' ,v_asst_register_id -> ' ||v_asst_register_id
2990: ||' ,v_register_code -> ' ||v_register_code

Line 3011: Fnd_File.PUT_LINE(Fnd_File.LOG, '5 ');

3007: v_additional_closing_balance := v_additional_closing_balance - NVL(p_dr_additional_ed,0);
3008: v_other_opening_balance := v_other_closing_balance;
3009: v_other_closing_balance := v_other_closing_balance - NVL(p_dr_other_ed,0);
3010: --Ends here....
3011: Fnd_File.PUT_LINE(Fnd_File.LOG, '5 ');
3012: -- Check for Export Excise and EOU.............
3013: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3014: Fnd_File.PUT_LINE(Fnd_File.LOG, '6 ');
3015: IF NVL(v_basic_closing_balance,0) < 0 THEN

Line 3014: Fnd_File.PUT_LINE(Fnd_File.LOG, '6 ');

3010: --Ends here....
3011: Fnd_File.PUT_LINE(Fnd_File.LOG, '5 ');
3012: -- Check for Export Excise and EOU.............
3013: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3014: Fnd_File.PUT_LINE(Fnd_File.LOG, '6 ');
3015: IF NVL(v_basic_closing_balance,0) < 0 THEN
3016: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance))); --Added for bug#7172215
3017: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance)));
3018: END IF;

Line 3016: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance))); --Added for bug#7172215

3012: -- Check for Export Excise and EOU.............
3013: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3014: Fnd_File.PUT_LINE(Fnd_File.LOG, '6 ');
3015: IF NVL(v_basic_closing_balance,0) < 0 THEN
3016: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance))); --Added for bug#7172215
3017: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance)));
3018: END IF;
3019: IF NVL(v_additional_closing_balance,0) < 0 THEN
3020: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance))); --Added for bug#7172215

Line 3020: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance))); --Added for bug#7172215

3016: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance))); --Added for bug#7172215
3017: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance)));
3018: END IF;
3019: IF NVL(v_additional_closing_balance,0) < 0 THEN
3020: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance))); --Added for bug#7172215
3021: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance)));
3022: END IF;
3023:
3024: IF NVL(v_other_closing_balance,0) < 0 THEN

Line 3025: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance))); --Added for bug#7172215

3021: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance)));
3022: END IF;
3023:
3024: IF NVL(v_other_closing_balance,0) < 0 THEN
3025: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance))); --Added for bug#7172215
3026: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance)));
3027: END IF;
3028:
3029: ELSE

Line 3032: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_opening_balance))); --Added for bug#7172215

3028:
3029: ELSE
3030: IF NVL(v_closing_balance,0) < 0 THEN
3031: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN
3032: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_opening_balance))); --Added for bug#7172215
3033: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_opening_balance)));
3034: END IF;
3035: END IF;
3036: END IF;

Line 3037: Fnd_File.PUT_LINE(Fnd_File.LOG, '7 ');

3033: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_opening_balance)));
3034: END IF;
3035: END IF;
3036: END IF;
3037: Fnd_File.PUT_LINE(Fnd_File.LOG, '7 ');
3038: ELSE
3039: Fnd_File.PUT_LINE(Fnd_File.LOG, '8 ');
3040: --Changed by Nagaraj.s for Enh2415656....
3041: OPEN pla_balance_cur;

Line 3039: Fnd_File.PUT_LINE(Fnd_File.LOG, '8 ');

3035: END IF;
3036: END IF;
3037: Fnd_File.PUT_LINE(Fnd_File.LOG, '7 ');
3038: ELSE
3039: Fnd_File.PUT_LINE(Fnd_File.LOG, '8 ');
3040: --Changed by Nagaraj.s for Enh2415656....
3041: OPEN pla_balance_cur;
3042: FETCH pla_balance_cur INTO v_rg_balance,v_rg_basic_balance,v_rg_additional_balance,v_rg_other_balance;
3043: CLOSE pla_balance_cur;

Line 3045: fnd_file.put_line(fnd_file.log, '9 v_rg_balance '

3041: OPEN pla_balance_cur;
3042: FETCH pla_balance_cur INTO v_rg_balance,v_rg_basic_balance,v_rg_additional_balance,v_rg_other_balance;
3043: CLOSE pla_balance_cur;
3044:
3045: fnd_file.put_line(fnd_file.log, '9 v_rg_balance '
3046: ||' ,v_rg_basic_balance -> '||v_rg_basic_balance
3047: ||' ,v_rg_additional_balance -> '||v_rg_additional_balance
3048: ||' ,v_rg_other_balance -> ' ||v_rg_other_balance);
3049:

Line 3059: fnd_file.put_line(fnd_file.log, '10 ');

3055: v_additional_closing_balance := NVL(v_rg_additional_balance,0) - NVL(p_dr_additional_ed,0);
3056: v_other_opening_balance := NVL(v_rg_other_balance,0);
3057: v_other_closing_balance := NVL(v_rg_other_balance,0) - NVL(p_dr_other_ed,0);
3058: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3059: fnd_file.put_line(fnd_file.log, '10 ');
3060: IF NVL(v_basic_closing_balance,0) < 0 THEN
3061: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance))); --Added for bug#7172215
3062: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance)));
3063: END IF;

Line 3061: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance))); --Added for bug#7172215

3057: v_other_closing_balance := NVL(v_rg_other_balance,0) - NVL(p_dr_other_ed,0);
3058: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3059: fnd_file.put_line(fnd_file.log, '10 ');
3060: IF NVL(v_basic_closing_balance,0) < 0 THEN
3061: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance))); --Added for bug#7172215
3062: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance)));
3063: END IF;
3064:
3065: IF NVL(v_additional_closing_balance,0) < 0 THEN

Line 3066: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance))); --Added for bug#7172215

3062: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance)));
3063: END IF;
3064:
3065: IF NVL(v_additional_closing_balance,0) < 0 THEN
3066: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance))); --Added for bug#7172215
3067: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance)));
3068: END IF;
3069:
3070: IF NVL(v_other_closing_balance,0) < 0 THEN

Line 3071: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance))); --Added for bug#7172215

3067: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance)));
3068: END IF;
3069:
3070: IF NVL(v_other_closing_balance,0) < 0 THEN
3071: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance))); --Added for bug#7172215
3072: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance)));
3073: END IF;
3074: fnd_file.put_line(fnd_file.log, '11 ');
3075: ELSE

Line 3074: fnd_file.put_line(fnd_file.log, '11 ');

3070: IF NVL(v_other_closing_balance,0) < 0 THEN
3071: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance))); --Added for bug#7172215
3072: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance)));
3073: END IF;
3074: fnd_file.put_line(fnd_file.log, '11 ');
3075: ELSE
3076: fnd_file.put_line(fnd_file.log, '12 ');
3077: IF v_closing_balance < 0 THEN
3078: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN

Line 3076: fnd_file.put_line(fnd_file.log, '12 ');

3072: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance)));
3073: END IF;
3074: fnd_file.put_line(fnd_file.log, '11 ');
3075: ELSE
3076: fnd_file.put_line(fnd_file.log, '12 ');
3077: IF v_closing_balance < 0 THEN
3078: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN
3079: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_rg_balance))); --Added for bug#7172215
3080: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_rg_balance)));

Line 3079: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_rg_balance))); --Added for bug#7172215

3075: ELSE
3076: fnd_file.put_line(fnd_file.log, '12 ');
3077: IF v_closing_balance < 0 THEN
3078: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN
3079: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_rg_balance))); --Added for bug#7172215
3080: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_rg_balance)));
3081: END IF;
3082: END IF;
3083: END IF;

Line 3084: fnd_file.put_line(fnd_file.log, '13 ');

3080: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_rg_balance)));
3081: END IF;
3082: END IF;
3083: END IF;
3084: fnd_file.put_line(fnd_file.log, '13 ');
3085: END IF;
3086:
3087: fnd_file.put_line(fnd_file.log, '14 ');
3088:

Line 3087: fnd_file.put_line(fnd_file.log, '14 ');

3083: END IF;
3084: fnd_file.put_line(fnd_file.log, '13 ');
3085: END IF;
3086:
3087: fnd_file.put_line(fnd_file.log, '14 ');
3088:
3089: OPEN cur_get_pla_reg_id ;
3090: FETCH cur_get_pla_reg_id INTO ln_register_id ;
3091: CLOSE cur_get_pla_reg_id ;

Line 3095: fnd_file.put_line(fnd_file.log, '15 before insert into update into JAI_CMN_RG_PLA_TRXS , slno ' || v_serial_no

3091: CLOSE cur_get_pla_reg_id ;
3092:
3093: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3094:
3095: fnd_file.put_line(fnd_file.log, '15 before insert into update into JAI_CMN_RG_PLA_TRXS , slno ' || v_serial_no
3096: ||' ,register_id ->' || ln_register_id
3097: ||' ,organization_id ->' || p_org_id
3098: ||' ,location_id ->' || p_location_id
3099: ||' ,inventory_item_id ->' || p_inventory_item_id

Line 3206: fnd_file.put_line(fnd_file.log, '16 after insert into JAI_CMN_RG_PLA_TRXS');

3202: v_other_opening_balance,
3203: v_other_closing_balance
3204: ) returning register_id into ln_register_id;
3205:
3206: fnd_file.put_line(fnd_file.log, '16 after insert into JAI_CMN_RG_PLA_TRXS');
3207:
3208: v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
3209:
3210: UPDATE JAI_CMN_RG_BALANCES

Line 3217: fnd_file.put_line(fnd_file.log, '17 after update into JAI_CMN_RG_BALANCES');

3213: additional_pla_balance = NVL(additional_pla_balance,0) - NVL(p_dr_additional_ed,0),
3214: other_pla_balance = NVL(other_pla_balance,0) - NVL(p_dr_other_ed,0)
3215: WHERE organization_id = p_org_id
3216: AND location_id = p_location_id;
3217: fnd_file.put_line(fnd_file.log, '17 after update into JAI_CMN_RG_BALANCES');
3218: ELSE
3219: fnd_file.put_line(fnd_file.log, '18 before insert into update into JAI_CMN_RG_PLA_TRXS , slno ' || v_serial_no
3220: ||' , register_id ->' || ln_register_id
3221: ||' , organization_id ->' || p_org_id

Line 3219: fnd_file.put_line(fnd_file.log, '18 before insert into update into JAI_CMN_RG_PLA_TRXS , slno ' || v_serial_no

3215: WHERE organization_id = p_org_id
3216: AND location_id = p_location_id;
3217: fnd_file.put_line(fnd_file.log, '17 after update into JAI_CMN_RG_BALANCES');
3218: ELSE
3219: fnd_file.put_line(fnd_file.log, '18 before insert into update into JAI_CMN_RG_PLA_TRXS , slno ' || v_serial_no
3220: ||' , register_id ->' || ln_register_id
3221: ||' , organization_id ->' || p_org_id
3222: ||' , location_id ->' || p_location_id
3223: ||' , inventory_item_id ->' || p_inventory_item_id

Line 3311: fnd_file.put_line(fnd_file.log, '19 after insert into JAI_CMN_RG_PLA_TRXS');

3307: p_last_update_date,
3308: p_last_updated_by
3309: ) returning register_id into ln_register_id;
3310:
3311: fnd_file.put_line(fnd_file.log, '19 after insert into JAI_CMN_RG_PLA_TRXS');
3312:
3313: v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
3314:
3315: UPDATE JAI_CMN_RG_BALANCES

Line 3320: fnd_file.put_line(fnd_file.log, '20 after update of JAI_CMN_RG_BALANCES');

3316: SET pla_balance = pla_balance - v_excise_amount
3317: WHERE organization_id = p_org_id
3318: AND location_id = p_location_id;
3319:
3320: fnd_file.put_line(fnd_file.log, '20 after update of JAI_CMN_RG_BALANCES');
3321:
3322: END IF;
3323:
3324:

Line 3325: fnd_file.put_line(fnd_file.log, '21 before call to ja_in_accounting_entries procedure ');

3321:
3322: END IF;
3323:
3324:
3325: fnd_file.put_line(fnd_file.log, '21 before call to ja_in_accounting_entries procedure ');
3326:
3327: ja_in_accounting_entries
3328: (
3329: p_org_id,

Line 3346: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling ja_in_cess_register_entries procedure');

3342: P_REF_25,
3343: P_REF_26
3344: );
3345:
3346: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling ja_in_cess_register_entries procedure');
3347: ja_in_cess_register_entries(
3348: p_register_id => ln_register_id ,
3349: p_register_type => 'PLA' ,
3350: p_inv_orgn_id => p_org_id ,

Line 3388: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling ja_in_cess_register_entries procedure');

3384: P_REFERENCE_24 => P_REF_24 ,
3385: P_REFERENCE_25 => P_REF_25 ,
3386: P_REFERENCE_26 => P_REF_26
3387: );
3388: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling ja_in_cess_register_entries procedure');
3389:
3390:
3391: update JAI_CMN_RG_PLA_TRXS
3392: set other_tax_debit = ln_cess_amount + ln_sh_cess_amount -- Date 04/06/2007 by Sacsethi for bug 6109941

Line 3778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );

3774: OPEN c_sh_cess_amount;
3775: FETCH c_sh_cess_amount INTO ln_sh_cess_amount;
3776: CLOSE c_sh_cess_amount;
3777:
3778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
3779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id, v_order_line_id' || v_order_header_id || v_order_line_id );
3780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_from_organization_id, v_order_source_id, v_requisition_header_id, v_requisition_line_id '
3781: || v_from_organization_id ||' , ' || v_order_source_id ||' , ' || v_requisition_header_id ||' , ' || v_requisition_line_id );
3782:

Line 3779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id, v_order_line_id' || v_order_header_id || v_order_line_id );

3775: FETCH c_sh_cess_amount INTO ln_sh_cess_amount;
3776: CLOSE c_sh_cess_amount;
3777:
3778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
3779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id, v_order_line_id' || v_order_header_id || v_order_line_id );
3780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_from_organization_id, v_order_source_id, v_requisition_header_id, v_requisition_line_id '
3781: || v_from_organization_id ||' , ' || v_order_source_id ||' , ' || v_requisition_header_id ||' , ' || v_requisition_line_id );
3782:
3783: OPEN debit_account_cur(v_from_organization_id , p_location_id);

Line 3780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_from_organization_id, v_order_source_id, v_requisition_header_id, v_requisition_line_id '

3776: CLOSE c_sh_cess_amount;
3777:
3778: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
3779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id, v_order_line_id' || v_order_header_id || v_order_line_id );
3780: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_from_organization_id, v_order_source_id, v_requisition_header_id, v_requisition_line_id '
3781: || v_from_organization_id ||' , ' || v_order_source_id ||' , ' || v_requisition_header_id ||' , ' || v_requisition_line_id );
3782:
3783: OPEN debit_account_cur(v_from_organization_id , p_location_id);
3784: FETCH debit_account_cur INTO v_excise_rcvble_account , ln_src_excise_23d_account, ln_src_excise_in_rg23d, lv_source_trading, lv_source_manufacturing ;

Line 4320: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Validity Period of the Bond Register has expired' ); --Added for bug#7172215

4316: p_last_update_login,
4317: p_last_update_date,
4318: p_last_updated_by );
4319: else
4320: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Validity Period of the Bond Register has expired' ); --Added for bug#7172215
4321: RAISE_APPLICATION_ERROR(-20121,' Validity Period of the Bond Register has expired' );
4322: end if;
4323: ELSE
4324: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Bonded Amount -> ' || TO_CHAR(v_charge_amount) || 'cannot be less than the transaction_amount -> ' || TO_CHAR(p_transaction_amount)); --Added for bug#7172215

Line 4324: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Bonded Amount -> ' || TO_CHAR(v_charge_amount) || 'cannot be less than the transaction_amount -> ' || TO_CHAR(p_transaction_amount)); --Added for bug#7172215

4320: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Validity Period of the Bond Register has expired' ); --Added for bug#7172215
4321: RAISE_APPLICATION_ERROR(-20121,' Validity Period of the Bond Register has expired' );
4322: end if;
4323: ELSE
4324: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Bonded Amount -> ' || TO_CHAR(v_charge_amount) || 'cannot be less than the transaction_amount -> ' || TO_CHAR(p_transaction_amount)); --Added for bug#7172215
4325: RAISE_APPLICATION_ERROR(-20120, 'Bonded Amount -> ' || TO_CHAR(v_charge_amount)
4326: || 'cannot be less than the transaction_amount -> '
4327: || TO_CHAR(p_transaction_amount));
4328: END IF;