DBA Data[Home] [Help]

APPS.JAI_OM_RG_PKG dependencies on GL_INTERFACE

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 557: p_debit_account gl_interface.code_combination_id%type ,

553: procedure ja_in_cess_acctg_entries(
554: p_trx_hdr_id number ,
555: p_inv_orgn_id number ,
556: p_cess_amount number ,
557: p_debit_account gl_interface.code_combination_id%type ,
558: p_credit_account gl_interface.code_combination_id%type ,
559: p_je_source_name gl_interface.user_je_source_name%type ,
560: p_je_Category_name gl_interface.user_je_category_name%type,
561: p_currency_code gl_interface.currency_Code%type ,

Line 558: p_credit_account gl_interface.code_combination_id%type ,

554: p_trx_hdr_id number ,
555: p_inv_orgn_id number ,
556: p_cess_amount number ,
557: p_debit_account gl_interface.code_combination_id%type ,
558: p_credit_account gl_interface.code_combination_id%type ,
559: p_je_source_name gl_interface.user_je_source_name%type ,
560: p_je_Category_name gl_interface.user_je_category_name%type,
561: p_currency_code gl_interface.currency_Code%type ,
562: P_REFERENCE_10 varchar2 ,

Line 559: p_je_source_name gl_interface.user_je_source_name%type ,

555: p_inv_orgn_id number ,
556: p_cess_amount number ,
557: p_debit_account gl_interface.code_combination_id%type ,
558: p_credit_account gl_interface.code_combination_id%type ,
559: p_je_source_name gl_interface.user_je_source_name%type ,
560: p_je_Category_name gl_interface.user_je_category_name%type,
561: p_currency_code gl_interface.currency_Code%type ,
562: P_REFERENCE_10 varchar2 ,
563: P_REFERENCE_23 varchar2 ,

Line 560: p_je_Category_name gl_interface.user_je_category_name%type,

556: p_cess_amount number ,
557: p_debit_account gl_interface.code_combination_id%type ,
558: p_credit_account gl_interface.code_combination_id%type ,
559: p_je_source_name gl_interface.user_je_source_name%type ,
560: p_je_Category_name gl_interface.user_je_category_name%type,
561: p_currency_code gl_interface.currency_Code%type ,
562: P_REFERENCE_10 varchar2 ,
563: P_REFERENCE_23 varchar2 ,
564: P_REFERENCE_24 varchar2 ,

Line 561: p_currency_code gl_interface.currency_Code%type ,

557: p_debit_account gl_interface.code_combination_id%type ,
558: p_credit_account gl_interface.code_combination_id%type ,
559: p_je_source_name gl_interface.user_je_source_name%type ,
560: p_je_Category_name gl_interface.user_je_category_name%type,
561: p_currency_code gl_interface.currency_Code%type ,
562: P_REFERENCE_10 varchar2 ,
563: P_REFERENCE_23 varchar2 ,
564: P_REFERENCE_24 varchar2 ,
565: P_REFERENCE_25 varchar2 ,

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 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 871: p_je_source_name gl_interface.USER_JE_SOURCE_NAME%type ,

867: procedure ja_in_cess_register_entries(
868: p_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%type ,
869: p_register_type varchar2 ,
870: p_inv_orgn_id JAI_CMN_INVENTORY_ORGS.organization_id%type ,
871: p_je_source_name gl_interface.USER_JE_SOURCE_NAME%type ,
872: p_je_category_name gl_interface.USER_JE_CATEGORY_NAME%type ,
873: p_source_type JAI_CMN_RG_OTHERS.source_type%type ,
874: p_currency_code gl_interface.currency_code%type ,
875: p_transaction_hdr_id Number ,

Line 872: p_je_category_name gl_interface.USER_JE_CATEGORY_NAME%type ,

868: p_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%type ,
869: p_register_type varchar2 ,
870: p_inv_orgn_id JAI_CMN_INVENTORY_ORGS.organization_id%type ,
871: p_je_source_name gl_interface.USER_JE_SOURCE_NAME%type ,
872: p_je_category_name gl_interface.USER_JE_CATEGORY_NAME%type ,
873: p_source_type JAI_CMN_RG_OTHERS.source_type%type ,
874: p_currency_code gl_interface.currency_code%type ,
875: p_transaction_hdr_id Number ,
876: p_debit_account Number ,

Line 874: p_currency_code gl_interface.currency_code%type ,

870: p_inv_orgn_id JAI_CMN_INVENTORY_ORGS.organization_id%type ,
871: p_je_source_name gl_interface.USER_JE_SOURCE_NAME%type ,
872: p_je_category_name gl_interface.USER_JE_CATEGORY_NAME%type ,
873: p_source_type JAI_CMN_RG_OTHERS.source_type%type ,
874: p_currency_code gl_interface.currency_code%type ,
875: p_transaction_hdr_id Number ,
876: p_debit_account Number ,
877: p_Credit_account Number ,
878: p_cess_amount OUT NOCOPY number ,

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 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 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 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 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: