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 333: Fnd_File.PUT_LINE(Fnd_File.LOG, ' start of JA_IN_CESS_ENTRIES with p_delivery_detail_id = ' || p_delivery_detail_id);

329: So no further check is done here for the same.
330: */
331: begin
332:
333: Fnd_File.PUT_LINE(Fnd_File.LOG, ' start of JA_IN_CESS_ENTRIES with p_delivery_detail_id = ' || p_delivery_detail_id);
334:
335: v_Delivery_id :=0;
336: open c_delivery_cur(p_delivery_detail_id);
337: fetch c_delivery_cur into v_Delivery_id, v_org_id;

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

336: open c_delivery_cur(p_delivery_detail_id);
337: fetch c_delivery_cur into v_Delivery_id, v_org_id;
338: close c_delivery_cur;
339:
340: Fnd_File.PUT_LINE(Fnd_File.LOG, 'v_Delivery_id =, Org id = ' || v_Delivery_id || ' : ' || v_org_id);
341:
342: if v_delivery_id > 0 then
343:
344: open c_cess_amount(v_Delivery_id);

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

366: v_currency_code := l_func_curr_det.currency_code;
367: --v_precision := l_func_curr_det.precision;
368: v_precision := 0; /*bug 8537295 - for excise invoice, amount should be rounded to nearest rupee*/
369:
370: 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 );
371:
372: if v_precision is null then
373: v_precision :=0;
374: end if;

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

375:
376: v_cess_amount := round(v_cess_amount,v_precision);
377: v_sh_cess_amount := round(v_sh_cess_amount,v_precision);/*Bug 5989740 bduvarag*/
378:
379: Fnd_File.PUT_LINE(Fnd_File.LOG, 'v_cess_amount = ' || v_cess_amount);
380:
381: if v_cess_amount > 0 then
382:
383: -- Dr Intransit Material Value

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

380:
381: if v_cess_amount > 0 then
382:
383: -- Dr Intransit Material Value
384: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling gl_interface for CESS ');
385:
386: jai_cmn_gl_pkg.create_gl_entry
387: (p_organization_id,
388: p_currency_code,

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

430: if p_fob_point =1 then -- fobpoint =(shipment)
431:
432:
433: -- Dr Intercompany Receivable
434: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling gl_interface for CESS ');
435:
436: jai_cmn_gl_pkg.create_gl_entry
437: (p_organization_id,
438: p_currency_code,

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

526: if p_fob_point =1 then -- fobpoint =(shipment)
527:
528:
529: -- Dr Intercompany Receivable
530: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling gl_interface for CESS ');
531:
532: jai_cmn_gl_pkg.create_gl_entry
533: (p_organization_id,
534: p_currency_code,

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

575: end if;
576: /*Bug 5989740 bduvarag*/
577: end if;
578:
579: Fnd_File.PUT_LINE(Fnd_File.LOG, ' End of JA_IN_CESS_ENTRIES');
580:
581: EXCEPTION
582: WHEN OTHERS THEN
583: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');

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

615: **********************************************************************/
616: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_acctg_entries';
617: begin
618:
619: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling gl_interface for credit entry for CESS' );
620:
621:
622: if p_debit_account is null or p_credit_account is null then
623: 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 623: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cess Accounts have not been setup in Organization Additional Information Screen - Cannot Process' ); --Added for bug#7172215

619: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling gl_interface for credit entry for CESS' );
620:
621:
622: if p_debit_account is null or p_credit_account is null then
623: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Cess Accounts have not been setup in Organization Additional Information Screen - Cannot Process' ); --Added for bug#7172215
624: raise_application_error(-20107,'Cess Accounts have not been setup in Organization Additional Information Screen - Cannot Process');
625: end if;
626:
627: jai_cmn_gl_pkg.create_gl_entry(

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

642: P_REFERENCE_25 => p_reference_25 ,
643: P_REFERENCE_26 => p_reference_26
644: );
645:
646: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling gl_interface for debit entry for CESS' );
647: jai_cmn_gl_pkg.create_gl_entry(
648: P_ORGANIZATION_ID => p_inv_orgn_id ,
649: P_CURRENCY_CODE => p_currency_code ,
650: P_CREDIT_AMOUNT => NULL ,

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

755: FOR tax_type_rec IN c_tax_type_rec
756: LOOP
757: ln_Cess_amount := ln_Cess_amount + nvl(tax_type_rec.tax_amount,0);
758:
759: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling jai_Rg_others_pkg.insert_row');
760:
761: jai_cmn_rg_others_pkg.insert_row(
762: P_SOURCE_TYPE => p_source_type ,
763: P_SOURCE_NAME => p_source_name ,

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

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

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

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

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

771:
772: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
773: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
774: IF lv_process_flag <> jai_constants.successful THEN
775: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
776: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);
777: END IF;
778:
779: END LOOP;

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

789: FOR tax_type_rec IN c_tax_type_for_delivery_rec
790: LOOP
791: ln_Cess_amount := ln_Cess_amount + nvl(tax_type_rec.tax_amount,0);
792:
793: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling jai_Rg_others_pkg.insert_row');
794:
795: jai_cmn_rg_others_pkg.insert_row(
796: P_SOURCE_TYPE => p_source_type ,
797: P_SOURCE_NAME => p_source_name ,

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

802: P_PROCESS_FLAG => lv_process_flag ,
803: P_PROCESS_MSG => lv_process_msg
804: );
805:
806: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
807: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
808: IF lv_process_flag <> jai_constants.successful THEN
809: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
810: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);

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

803: P_PROCESS_MSG => lv_process_msg
804: );
805:
806: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
807: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
808: IF lv_process_flag <> jai_constants.successful THEN
809: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
810: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);
811: END IF;

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

805:
806: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
807: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
808: IF lv_process_flag <> jai_constants.successful THEN
809: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
810: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);
811: END IF;
812:
813: END LOOP;

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

1040: p_cess_type => p_cess_type/*Bug 5989740 bduvarag*/
1041: );
1042: end if;
1043:
1044: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling ja_in_cess_acctg_entries' );
1045: /*
1046: -- MXYZ No Cess A/c in trading scenario
1047: */
1048: if p_source_type <> 3 then

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

1062: P_REFERENCE_25 ,
1063: P_REFERENCE_26
1064: );
1065: End If;
1066: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after calling ja_in_cess_acctg_entries' );
1067: end if;
1068:
1069: p_cess_amount := ln_Cess_amount;
1070:

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

1297: FETCH c_get_order_details INTO
1298: v_from_organization_id, v_order_source_id, v_requisition_header_id, v_requisition_line_id;
1299: CLOSE c_get_order_details;
1300:
1301: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
1302: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id='||v_order_header_id||', v_order_line_id='|| v_order_line_id );
1303: 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);
1304:
1305: 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 1302: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id='||v_order_header_id||', v_order_line_id='|| v_order_line_id );

1298: v_from_organization_id, v_order_source_id, v_requisition_header_id, v_requisition_line_id;
1299: CLOSE c_get_order_details;
1300:
1301: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
1302: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id='||v_order_header_id||', v_order_line_id='|| v_order_line_id );
1303: 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);
1304:
1305: 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);
1306:

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

1299: CLOSE c_get_order_details;
1300:
1301: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
1302: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id='||v_order_header_id||', v_order_line_id='|| v_order_line_id );
1303: 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);
1304:
1305: 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);
1306:
1307:

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

1301: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
1302: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id='||v_order_header_id||', v_order_line_id='|| v_order_line_id );
1303: 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);
1304:
1305: 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);
1306:
1307:
1308: -- IF NVL(v_order_source_id, 0) <> 10 THEN, commented by Aparajita for bug # 2848921
1309:

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

1312: OPEN debit_account_cur(v_from_organization_id , p_location_id);
1313: 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;
1314: CLOSE debit_account_cur;
1315:
1316: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_to_organization_id = ' || v_to_organization_id );
1317: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_intransit_type, v_fob_point ' || v_intransit_type || ' , ' || v_fob_point);
1318: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_excise_rcvble_account , v_intransit_inv_account ' || v_excise_rcvble_account || ', ' || v_intransit_inv_account );
1319:
1320: OPEN debit_account_cur(v_to_organization_id , ln_to_location_id );

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

1313: 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;
1314: CLOSE debit_account_cur;
1315:
1316: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_to_organization_id = ' || v_to_organization_id );
1317: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_intransit_type, v_fob_point ' || v_intransit_type || ' , ' || v_fob_point);
1318: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_excise_rcvble_account , v_intransit_inv_account ' || v_excise_rcvble_account || ', ' || v_intransit_inv_account );
1319:
1320: OPEN debit_account_cur(v_to_organization_id , ln_to_location_id );
1321: 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 1318: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_excise_rcvble_account , v_intransit_inv_account ' || v_excise_rcvble_account || ', ' || v_intransit_inv_account );

1314: CLOSE debit_account_cur;
1315:
1316: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_to_organization_id = ' || v_to_organization_id );
1317: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_intransit_type, v_fob_point ' || v_intransit_type || ' , ' || v_fob_point);
1318: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_excise_rcvble_account , v_intransit_inv_account ' || v_excise_rcvble_account || ', ' || v_intransit_inv_account );
1319:
1320: OPEN debit_account_cur(v_to_organization_id , ln_to_location_id );
1321: 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;
1322: CLOSE debit_account_cur;

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

1321: 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;
1322: CLOSE debit_account_cur;
1323: --Added for bug#7277543
1324: IF p_non_iso_credit_account_id IS NULL OR p_non_iso_debit_account_id IS NULL THEN
1325: 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');
1326: END IF;
1327: --End bug#7277543
1328: IF NVL(p_non_iso_credit_account_id,0) >0 AND NVL(p_non_iso_debit_account_id,0) >0 AND
1329: NOT /* The NOT part of the if condition added by ssumaith - bug# 4171469 */

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

1345: )
1346: THEN
1347:
1348: -- v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
1349: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling gl interface -1 ');
1350: jai_cmn_gl_pkg.create_gl_entry
1351: (
1352: p_org_id,
1353: p_currency_code,

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

1531: ends here additions by ssumaith - bug# 4171469
1532: */
1533: --Added for bug#7277543
1534: IF v_excise_rcvble_account IS NULL OR v_intransit_inv_account IS NULL THEN
1535: 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');
1536: END IF;
1537: --End bug#7277543
1538: IF NVL(v_excise_rcvble_account,0) >0 AND NVL(v_intransit_inv_account,0) >0 THEN
1539:

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

1537: --End bug#7277543
1538: IF NVL(v_excise_rcvble_account,0) >0 AND NVL(v_intransit_inv_account,0) >0 THEN
1539:
1540: --CREDIT Excise Paid Payable Account
1541: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling gl interface - 2 ');
1542: jai_cmn_gl_pkg.create_gl_entry
1543: (
1544: p_org_id,
1545: p_currency_code,

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

1590:
1591: IF v_fob_point=1 THEN
1592: --Added for bug#7277543
1593: IF v_interorg_payables_account IS NULL OR v_interorg_receivables_account IS NULL THEN
1594: 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');
1595: END IF;
1596: --End bug#7277543
1597:
1598: IF NVL(v_interorg_payables_account, 0) >0 AND NVL(v_interorg_receivables_account,0) >0 THEN

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

1597:
1598: IF NVL(v_interorg_payables_account, 0) >0 AND NVL(v_interorg_receivables_account,0) >0 THEN
1599:
1600: -- DEBIT Inter Org Receivables Account
1601: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling gl interface - 3 ');
1602:
1603: jai_cmn_gl_pkg.create_gl_entry
1604: ( p_org_id,
1605: p_currency_code,

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

1654:
1655: IF NVL(v_excise_rcvble_account, 0) >0 AND NVL(v_interorg_receivables_account,0) >0 THEN
1656:
1657: --CREDIT Excise Paid Payable Account
1658: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling gl interface - 4 ');
1659:
1660: jai_cmn_gl_pkg.create_gl_entry
1661: (
1662: p_org_id,

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

1701: END IF; --End if for Account Checks. */
1702: -- type is transit, extra accounting entries
1703:
1704: -- start additions by ssumaith - bug#3817625
1705: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before calling JA_IN_CESS_ENTRIES');
1706:
1707: JA_IN_CESS_ENTRIES
1708: (
1709: p_organization_id => p_org_id ,

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

1723: P_REF_25 => P_REF_25 ,
1724: P_REF_26 => P_REF_26
1725: );
1726: END IF;/*Bug 5989740 bduvarag*/
1727: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after calling JA_IN_CESS_ENTRIES');
1728: -- start additions by ssumaith - bug#3817625
1729: END IF; -- internal order.
1730:
1731: <>

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

2696: OPEN RANGE_DIVISION_CUR;
2697: FETCH RANGE_DIVISION_CUR INTO v_range_no,v_division_no;
2698: CLOSE RANGE_DIVISION_CUR;
2699:
2700: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in rg pkg p_excise_exempt_type is ' || p_excise_exempt_type);
2701:
2702: IF p_excise_exempt_type IN ('CT2', 'EXCISE_EXEMPT_CERT','CT2_OTH', 'EXCISE_EXEMPT_CERT_OTH' ,'CT3') THEN
2703:
2704: -- CT3 added by sriram into the list. Bug # 2796717. 16/mar/2003

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

2725: FETCH debit_account_cur INTO v_debit_account_id, v_cess_debit_account_id,v_sh_cess_debit_account_id /*Bug 5989740 bduvarag*/;
2726: CLOSE debit_account_cur;
2727: END IF;
2728:
2729: Fnd_File.PUT_LINE(Fnd_File.LOG, ' debit account id is ' || v_debit_account_id);
2730: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Cess debit account id is ' || v_cess_debit_account_id);
2731: Fnd_File.PUT_LINE(Fnd_File.LOG, ' SH Cess debit account id is ' || v_sh_cess_debit_account_id);
2732: --Added for bug#7277543
2733: 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 2730: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Cess debit account id is ' || v_cess_debit_account_id);

2726: CLOSE debit_account_cur;
2727: END IF;
2728:
2729: Fnd_File.PUT_LINE(Fnd_File.LOG, ' debit account id is ' || v_debit_account_id);
2730: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Cess debit account id is ' || v_cess_debit_account_id);
2731: Fnd_File.PUT_LINE(Fnd_File.LOG, ' SH Cess debit account id is ' || v_sh_cess_debit_account_id);
2732: --Added for bug#7277543
2733: 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
2734: 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 2731: Fnd_File.PUT_LINE(Fnd_File.LOG, ' SH Cess debit account id is ' || v_sh_cess_debit_account_id);

2727: END IF;
2728:
2729: Fnd_File.PUT_LINE(Fnd_File.LOG, ' debit account id is ' || v_debit_account_id);
2730: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Cess debit account id is ' || v_cess_debit_account_id);
2731: Fnd_File.PUT_LINE(Fnd_File.LOG, ' SH Cess debit account id is ' || v_sh_cess_debit_account_id);
2732: --Added for bug#7277543
2733: 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
2734: 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 ' );
2735: END IF;

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

2730: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Cess debit account id is ' || v_cess_debit_account_id);
2731: Fnd_File.PUT_LINE(Fnd_File.LOG, ' SH Cess debit account id is ' || v_sh_cess_debit_account_id);
2732: --Added for bug#7277543
2733: 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
2734: 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 ' );
2735: END IF;
2736: --End bug#7277543
2737: /* Bug 4931887. Added by Lakshmi Gopalsami
2738: Re-used the cursor get_curr_code for fixing perf. issue reported.

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

2744: OPEN ssi_unit_flag_cur;
2745: FETCH ssi_unit_flag_cur INTO v_ssi_unit_flag;
2746: CLOSE ssi_unit_flag_cur;
2747:
2748: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_register_type is ' || p_register_type);
2749: IF p_register_type = 'A' THEN
2750: OPEN rm_account_cur;
2751: FETCH rm_account_cur INTO v_account_id , v_cess_account_id,v_sh_cess_account_id; /*Bug 5989740 bduvarag*/
2752: CLOSE rm_account_cur;

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

2759: OPEN serial_no_cur;
2760: FETCH serial_no_cur INTO v_previous_serial_no, v_serial_no;
2761: CLOSE serial_no_cur;
2762:
2763: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_previous_serial_no is ' || v_previous_serial_no);
2764: IF NVL(v_previous_serial_no,0) = 0 THEN
2765: v_previous_serial_no := 0;
2766: v_serial_no := 1;
2767: END IF;

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

2765: v_previous_serial_no := 0;
2766: v_serial_no := 1;
2767: END IF;
2768:
2769: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_previous_serial_no is ' || v_previous_serial_no);
2770: IF NVL(v_previous_serial_no,0) > 0 THEN
2771:
2772: OPEN balance_cur(v_previous_serial_no);
2773: FETCH balance_cur INTO v_opening_balance, v_closing_balance;

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

2775:
2776: v_opening_balance := v_closing_balance;
2777: v_closing_balance := v_closing_balance - (NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0));
2778:
2779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' opening and closing balances : ' || v_opening_balance || ' and ' || v_closing_balance);
2780: IF NVL(v_closing_balance,0) < 0 THEN
2781: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN
2782: 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
2783: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the RG23 PART II Opening Balance ---'|| TO_CHAR(v_opening_balance));

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

2778:
2779: Fnd_File.PUT_LINE(Fnd_File.LOG, ' opening and closing balances : ' || v_opening_balance || ' and ' || v_closing_balance);
2780: IF NVL(v_closing_balance,0) < 0 THEN
2781: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN
2782: 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
2783: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the RG23 PART II Opening Balance ---'|| TO_CHAR(v_opening_balance));
2784: END IF;
2785: END IF;
2786:

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

2802: 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));
2803:
2804: IF v_closing_balance < 0 THEN
2805: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN
2806: 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
2807: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the RG23 PART II Opening Balance '|| TO_CHAR(v_rg_balance));
2808: END IF;
2809: END IF;
2810:

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

2808: END IF;
2809: END IF;
2810:
2811: END IF;
2812: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before insert into JAI_CMN_RG_23AC_II_TRXS');
2813: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, begin
2814: --------------------------------------------------------------------------------------
2815: /*
2816: OPEN get_external_flag_cur;

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

2910: p_last_updated_by,
2911: p_remarks
2912: );
2913:
2914: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after insert into JAI_CMN_RG_23AC_II_TRXS');
2915: -- Code has been modified here by Aparajita on 08/03/2002 for bug # 2496388
2916:
2917:
2918: IF p_register_code <>'BOND_REG' THEN

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

2917:
2918: IF p_register_code <>'BOND_REG' THEN
2919:
2920: v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
2921: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling ja_in_accounting entries procedure');
2922: ja_in_accounting_entries
2923: (
2924: p_org_id,
2925: p_location_id,

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

2936: P_REF_24,
2937: P_REF_25,
2938: P_REF_26
2939: );
2940: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling ja_in_accounting entries procedure');
2941:
2942:
2943: ja_in_cess_register_entries(p_register_id => ln_register_id ,
2944: p_register_type => p_register_type ,

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

3194: ln_external_flag NUMBER;*/--Comments by zhiwei for Bug#12537533
3195: --------------------------------------------------------------------------------------
3196: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, end
3197: BEGIN
3198: fnd_file.put_line(fnd_file.log, '1 Start of procedure jai_om_rg_pkg.ja_in_pla_entry');
3199: OPEN RANGE_DIVISION_CUR;
3200: FETCH RANGE_DIVISION_CUR INTO v_range_no,v_division_no;
3201: CLOSE RANGE_DIVISION_CUR;
3202:

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

3228: FETCH c_order_type_id INTO v_order_type_id;
3229: CLOSE c_order_type_id;
3230:
3231: --sriram - bug # 3021588 and using the following procedure call instead.
3232: Fnd_File.PUT_LINE(Fnd_File.LOG, '2 before call to jai_cmn_bond_register_pkg.get_register_id ');
3233:
3234: jai_cmn_bond_register_pkg.get_register_id (p_org_id ,
3235: p_location_id,
3236: v_order_type_id, -- order type id

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

3237: 'Y', -- order invoice type
3238: v_asst_register_id, -- out parameter to get the register id
3239: v_register_code);
3240:
3241: Fnd_File.PUT_LINE(Fnd_File.LOG, '3 after call from jai_cmn_bond_register_pkg.get_register_id ');
3242: IF NVL(v_previous_serial_no,0) = 0 THEN
3243: v_previous_serial_no := 0;
3244: v_serial_no := 1;
3245: END IF;

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

3243: v_previous_serial_no := 0;
3244: v_serial_no := 1;
3245: END IF;
3246:
3247: Fnd_File.PUT_LINE(Fnd_File.LOG, '4 p_org_id -> ' ||p_org_id
3248: ||' ,p_location_id -> ' ||p_location_id
3249: ||' ,v_order_type_id -> ' ||v_order_type_id
3250: ||' ,v_asst_register_id -> ' ||v_asst_register_id
3251: ||' ,v_register_code -> ' ||v_register_code

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

3268: v_additional_closing_balance := v_additional_closing_balance - NVL(p_dr_additional_ed,0);
3269: v_other_opening_balance := v_other_closing_balance;
3270: v_other_closing_balance := v_other_closing_balance - NVL(p_dr_other_ed,0);
3271: --Ends here....
3272: Fnd_File.PUT_LINE(Fnd_File.LOG, '5 ');
3273: -- Check for Export Excise and EOU.............
3274: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3275: Fnd_File.PUT_LINE(Fnd_File.LOG, '6 ');
3276: IF NVL(v_basic_closing_balance,0) < 0 THEN

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

3271: --Ends here....
3272: Fnd_File.PUT_LINE(Fnd_File.LOG, '5 ');
3273: -- Check for Export Excise and EOU.............
3274: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3275: Fnd_File.PUT_LINE(Fnd_File.LOG, '6 ');
3276: IF NVL(v_basic_closing_balance,0) < 0 THEN
3277: 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
3278: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance)));
3279: END IF;

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

3273: -- Check for Export Excise and EOU.............
3274: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3275: Fnd_File.PUT_LINE(Fnd_File.LOG, '6 ');
3276: IF NVL(v_basic_closing_balance,0) < 0 THEN
3277: 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
3278: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance)));
3279: END IF;
3280: IF NVL(v_additional_closing_balance,0) < 0 THEN
3281: 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 3281: 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

3277: 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
3278: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance)));
3279: END IF;
3280: IF NVL(v_additional_closing_balance,0) < 0 THEN
3281: 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
3282: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance)));
3283: END IF;
3284:
3285: IF NVL(v_other_closing_balance,0) < 0 THEN

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

3282: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance)));
3283: END IF;
3284:
3285: IF NVL(v_other_closing_balance,0) < 0 THEN
3286: 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
3287: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance)));
3288: END IF;
3289:
3290: ELSE

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

3289:
3290: ELSE
3291: IF NVL(v_closing_balance,0) < 0 THEN
3292: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN
3293: 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
3294: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_opening_balance)));
3295: END IF;
3296: END IF;
3297: END IF;

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

3294: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_opening_balance)));
3295: END IF;
3296: END IF;
3297: END IF;
3298: Fnd_File.PUT_LINE(Fnd_File.LOG, '7 ');
3299: ELSE
3300: Fnd_File.PUT_LINE(Fnd_File.LOG, '8 ');
3301: --Changed by Nagaraj.s for Enh2415656....
3302: OPEN pla_balance_cur;

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

3296: END IF;
3297: END IF;
3298: Fnd_File.PUT_LINE(Fnd_File.LOG, '7 ');
3299: ELSE
3300: Fnd_File.PUT_LINE(Fnd_File.LOG, '8 ');
3301: --Changed by Nagaraj.s for Enh2415656....
3302: OPEN pla_balance_cur;
3303: FETCH pla_balance_cur INTO v_rg_balance,v_rg_basic_balance,v_rg_additional_balance,v_rg_other_balance;
3304: CLOSE pla_balance_cur;

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

3302: OPEN pla_balance_cur;
3303: FETCH pla_balance_cur INTO v_rg_balance,v_rg_basic_balance,v_rg_additional_balance,v_rg_other_balance;
3304: CLOSE pla_balance_cur;
3305:
3306: fnd_file.put_line(fnd_file.log, '9 v_rg_balance '
3307: ||' ,v_rg_basic_balance -> '||v_rg_basic_balance
3308: ||' ,v_rg_additional_balance -> '||v_rg_additional_balance
3309: ||' ,v_rg_other_balance -> ' ||v_rg_other_balance);
3310:

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

3316: v_additional_closing_balance := NVL(v_rg_additional_balance,0) - NVL(p_dr_additional_ed,0);
3317: v_other_opening_balance := NVL(v_rg_other_balance,0);
3318: v_other_closing_balance := NVL(v_rg_other_balance,0) - NVL(p_dr_other_ed,0);
3319: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3320: fnd_file.put_line(fnd_file.log, '10 ');
3321: IF NVL(v_basic_closing_balance,0) < 0 THEN
3322: 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
3323: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance)));
3324: END IF;

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

3318: v_other_closing_balance := NVL(v_rg_other_balance,0) - NVL(p_dr_other_ed,0);
3319: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3320: fnd_file.put_line(fnd_file.log, '10 ');
3321: IF NVL(v_basic_closing_balance,0) < 0 THEN
3322: 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
3323: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance)));
3324: END IF;
3325:
3326: IF NVL(v_additional_closing_balance,0) < 0 THEN

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

3323: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Basic PLA Opening Balance '|| TO_CHAR(ROUND(v_basic_opening_balance)));
3324: END IF;
3325:
3326: IF NVL(v_additional_closing_balance,0) < 0 THEN
3327: 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
3328: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance)));
3329: END IF;
3330:
3331: IF NVL(v_other_closing_balance,0) < 0 THEN

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

3328: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Additional PLA Opening Balance '|| TO_CHAR(ROUND(v_additional_opening_balance)));
3329: END IF;
3330:
3331: IF NVL(v_other_closing_balance,0) < 0 THEN
3332: 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
3333: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance)));
3334: END IF;
3335: fnd_file.put_line(fnd_file.log, '11 ');
3336: ELSE

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

3331: IF NVL(v_other_closing_balance,0) < 0 THEN
3332: 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
3333: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance)));
3334: END IF;
3335: fnd_file.put_line(fnd_file.log, '11 ');
3336: ELSE
3337: fnd_file.put_line(fnd_file.log, '12 ');
3338: IF v_closing_balance < 0 THEN
3339: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN

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

3333: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the Other PLA Opening Balance '|| TO_CHAR(ROUND(v_other_opening_balance)));
3334: END IF;
3335: fnd_file.put_line(fnd_file.log, '11 ');
3336: ELSE
3337: fnd_file.put_line(fnd_file.log, '12 ');
3338: IF v_closing_balance < 0 THEN
3339: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN
3340: 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
3341: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_rg_balance)));

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

3336: ELSE
3337: fnd_file.put_line(fnd_file.log, '12 ');
3338: IF v_closing_balance < 0 THEN
3339: IF NVL(v_ssi_unit_flag,'N') = 'N' THEN
3340: 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
3341: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_rg_balance)));
3342: END IF;
3343: END IF;
3344: END IF;

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

3341: RAISE_APPLICATION_ERROR(-20120, 'Cannot Debit more than the PLA Opening Balance '|| TO_CHAR(ROUND(v_rg_balance)));
3342: END IF;
3343: END IF;
3344: END IF;
3345: fnd_file.put_line(fnd_file.log, '13 ');
3346: END IF;
3347:
3348: fnd_file.put_line(fnd_file.log, '14 ');
3349: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, begin

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

3344: END IF;
3345: fnd_file.put_line(fnd_file.log, '13 ');
3346: END IF;
3347:
3348: fnd_file.put_line(fnd_file.log, '14 ');
3349: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, begin
3350: --For 'External' event, pick accounting/tax_amount from JAI Interface,
3351: --update accounting, and returns.
3352: --------------------------------------------------------------------------------------

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

3387: CLOSE cur_get_pla_reg_id ;
3388:
3389: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3390:
3391: fnd_file.put_line(fnd_file.log, '15 before insert into update into JAI_CMN_RG_PLA_TRXS , slno ' || v_serial_no
3392: ||' ,register_id ->' || ln_register_id
3393: ||' ,organization_id ->' || p_org_id
3394: ||' ,location_id ->' || p_location_id
3395: ||' ,inventory_item_id ->' || p_inventory_item_id

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

3498: v_other_opening_balance,
3499: v_other_closing_balance
3500: ) returning register_id into ln_register_id;
3501:
3502: fnd_file.put_line(fnd_file.log, '16 after insert into JAI_CMN_RG_PLA_TRXS');
3503:
3504: v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
3505:
3506: UPDATE JAI_CMN_RG_BALANCES

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

3509: additional_pla_balance = NVL(additional_pla_balance,0) - NVL(p_dr_additional_ed,0),
3510: other_pla_balance = NVL(other_pla_balance,0) - NVL(p_dr_other_ed,0)
3511: WHERE organization_id = p_org_id
3512: AND location_id = p_location_id;
3513: fnd_file.put_line(fnd_file.log, '17 after update into JAI_CMN_RG_BALANCES');
3514: ELSE
3515: fnd_file.put_line(fnd_file.log, '18 before insert into update into JAI_CMN_RG_PLA_TRXS , slno ' || v_serial_no
3516: ||' , register_id ->' || ln_register_id
3517: ||' , organization_id ->' || p_org_id

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

3511: WHERE organization_id = p_org_id
3512: AND location_id = p_location_id;
3513: fnd_file.put_line(fnd_file.log, '17 after update into JAI_CMN_RG_BALANCES');
3514: ELSE
3515: fnd_file.put_line(fnd_file.log, '18 before insert into update into JAI_CMN_RG_PLA_TRXS , slno ' || v_serial_no
3516: ||' , register_id ->' || ln_register_id
3517: ||' , organization_id ->' || p_org_id
3518: ||' , location_id ->' || p_location_id
3519: ||' , inventory_item_id ->' || p_inventory_item_id

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

3603: p_last_update_date,
3604: p_last_updated_by
3605: ) returning register_id into ln_register_id;
3606:
3607: fnd_file.put_line(fnd_file.log, '19 after insert into JAI_CMN_RG_PLA_TRXS');
3608:
3609: v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
3610:
3611: UPDATE JAI_CMN_RG_BALANCES

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

3612: SET pla_balance = pla_balance - v_excise_amount
3613: WHERE organization_id = p_org_id
3614: AND location_id = p_location_id;
3615:
3616: fnd_file.put_line(fnd_file.log, '20 after update of JAI_CMN_RG_BALANCES');
3617:
3618: END IF;
3619:
3620:

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

3617:
3618: END IF;
3619:
3620:
3621: fnd_file.put_line(fnd_file.log, '21 before call to ja_in_accounting_entries procedure ');
3622:
3623: ja_in_accounting_entries
3624: (
3625: p_org_id,

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

3638: P_REF_25,
3639: P_REF_26
3640: );
3641:
3642: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling ja_in_cess_register_entries procedure');
3643: ja_in_cess_register_entries(
3644: p_register_id => ln_register_id ,
3645: p_register_type => 'PLA' ,
3646: p_inv_orgn_id => p_org_id ,

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

3680: P_REFERENCE_24 => P_REF_24 ,
3681: P_REFERENCE_25 => P_REF_25 ,
3682: P_REFERENCE_26 => P_REF_26
3683: );
3684: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling ja_in_cess_register_entries procedure');
3685:
3686:
3687: update JAI_CMN_RG_PLA_TRXS
3688: set other_tax_debit = ln_cess_amount + ln_sh_cess_amount -- Date 04/06/2007 by Sacsethi for bug 6109941

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

4081: OPEN c_sh_cess_amount;
4082: FETCH c_sh_cess_amount INTO ln_sh_cess_amount;
4083: CLOSE c_sh_cess_amount;
4084:
4085: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
4086: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id, v_order_line_id' || v_order_header_id || v_order_line_id );
4087: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_from_organization_id, v_order_source_id, v_requisition_header_id, v_requisition_line_id '
4088: || v_from_organization_id ||' , ' || v_order_source_id ||' , ' || v_requisition_header_id ||' , ' || v_requisition_line_id );
4089:

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

4082: FETCH c_sh_cess_amount INTO ln_sh_cess_amount;
4083: CLOSE c_sh_cess_amount;
4084:
4085: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
4086: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id, v_order_line_id' || v_order_header_id || v_order_line_id );
4087: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_from_organization_id, v_order_source_id, v_requisition_header_id, v_requisition_line_id '
4088: || v_from_organization_id ||' , ' || v_order_source_id ||' , ' || v_requisition_header_id ||' , ' || v_requisition_line_id );
4089:
4090: OPEN debit_account_cur(v_from_organization_id , p_location_id);

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

4083: CLOSE c_sh_cess_amount;
4084:
4085: Fnd_File.PUT_LINE(Fnd_File.LOG, ' in the gl_interface procedure with values as follows' );
4086: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_order_header_id, v_order_line_id' || v_order_header_id || v_order_line_id );
4087: Fnd_File.PUT_LINE(Fnd_File.LOG, ' v_from_organization_id, v_order_source_id, v_requisition_header_id, v_requisition_line_id '
4088: || v_from_organization_id ||' , ' || v_order_source_id ||' , ' || v_requisition_header_id ||' , ' || v_requisition_line_id );
4089:
4090: OPEN debit_account_cur(v_from_organization_id , p_location_id);
4091: 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 4756: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Validity Period of the Bond Register has expired' ); --Added for bug#7172215

4752: p_last_update_login,
4753: p_last_update_date,
4754: p_last_updated_by );
4755: else
4756: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Validity Period of the Bond Register has expired' ); --Added for bug#7172215
4757: RAISE_APPLICATION_ERROR(-20121,' Validity Period of the Bond Register has expired' );
4758: end if;
4759: ELSE
4760: 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 4760: 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

4756: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Validity Period of the Bond Register has expired' ); --Added for bug#7172215
4757: RAISE_APPLICATION_ERROR(-20121,' Validity Period of the Bond Register has expired' );
4758: end if;
4759: ELSE
4760: 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
4761: RAISE_APPLICATION_ERROR(-20120, 'Bonded Amount -> ' || TO_CHAR(v_charge_amount)
4762: || 'cannot be less than the transaction_amount -> '
4763: || TO_CHAR(p_transaction_amount));
4764: END IF;