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_WSH_PKG dependencies on JAI_OM_WSH_PKG

Line 1: PACKAGE BODY jai_om_wsh_pkg AS

1: PACKAGE BODY jai_om_wsh_pkg AS
2: /* $Header: jai_om_wsh.plb 120.11.12010000.3 2008/11/24 09:58:43 vkaranam ship $ */
3:
4:
5: PROCEDURE process_delivery

Line 647: jai_om_wsh_pkg.get_excise_register_with_bal - for preference checks in case of EOU and Non-EOU

643: 19 2002/07/03 Nagaraj.s - For Enh#2415656.
644: Cursors pref_cur - Incorporated v_export_oriented_unit also in the select clause
645: RG Bal Cur- Incorporated basic,additional,other pla balance also in the select clause.
646: Functions jai_om_wsh_processing_pkg.excise_balance_check - for preference checks in case of EOU and Non-EOU for total excise amount
647: jai_om_wsh_pkg.get_excise_register_with_bal - for preference checks in case of EOU and Non-EOU
648: for exempted amount.
649: Before sending this patch it has to be taken care that, the alter scripts,functions should also
650: accompany the patch otherwise the patch would certainly fail.
651:

Line 915: This code object calls the functions jai_om_wsh_processing_pkg.excise_balance_check_f and jai_om_wsh_pkg.get_excise_register_with_bal_f

911: The basic business logic validation is that both cess and excise should be available as
912: part of the same register type and the register preference setup at the organization additional information
913: needs to be considered for picking up the correct register .
914:
915: This code object calls the functions jai_om_wsh_processing_pkg.excise_balance_check_f and jai_om_wsh_pkg.get_excise_register_with_bal_f
916: which have had changes in their signature and hence the caller also needs to pass the correct
917: parameters.
918:
919: The change done in this object is to pass the additional parameters correctly to the functions.

Line 923: jai_om_wsh_pkg.get_excise_register_with_bal (version 115.1) also packaged as part of this bug.

919: The change done in this object is to pass the additional parameters correctly to the functions.
920:
921: Dependency Due to this Bug:-
922: The current procedure becomes dependent on the functions jai_om_wsh_processing_pkg.excise_balance_check (version 115.1) and
923: jai_om_wsh_pkg.get_excise_register_with_bal (version 115.1) also packaged as part of this bug.
924:
925: 42. 2005/02/16 ssumaith - bug# 4185392 - File version 115.4
926:
927: Excise Duty rate was going in as zero in JAI_CMN_RG_I_TRXS table. This was because the variable

Line 991: This has been populated from this and jai_om_wsh_pkg.process_delivery procedure.

987: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
988: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
989:
990: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.
991: This has been populated from this and jai_om_wsh_pkg.process_delivery procedure.
992:
993: A migration script has been provided to migrate the value for cess and source.
994:
995: Dependency due to this bug:-

Line 999: 4. Procedure jai_om_wsh_pkg.process_delivery

995: Dependency due to this bug:-
996: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
997: 2. Added two new parameters in jai_om_rg_pkg.ja_in_rg_i_entry procedure to insert data into JAI_CMN_RG_I_TRXS table
998: 3. Modified the trigger jai_jar_t_aru_t1
999: 4. Procedure jai_om_wsh_pkg.process_delivery
1000: 5. Report JAICMNRG1.rdf
1001: 6. Created a migration script to populate cess_amt and source for Shipment and Receivable transactions.
1002: Both functional and technical dependencies exists
1003:

Line 1085: 4147608 jai_om_wsh_pkg.get_excise_register_with_bal_f.sql 115.1 ssumaith 11/02/2005 New parameters added to function.

1081: 619.1 3446362 IN60105D2 None -- Aiyer 19/03/2004 Row introduces to start dependency tracking
1082:
1083:
1084: 115.3 4171272 IN60106 +
1085: 4147608 jai_om_wsh_pkg.get_excise_register_with_bal_f.sql 115.1 ssumaith 11/02/2005 New parameters added to function.
1086: jai_om_wsh_processing_pkg.excise_balance_check_f.sql 115.1 ssumaith 11/02/2005 New parameters added to function.
1087:
1088: 12.0 4566054 jai_om_rg.pls 120.3 Aiyer 24-Aug-2005
1089: jai_om_rg.plb 120.4

Line 1090: jai_om_wsh.plb (jai_om_wsh_pkg.process_delivery) 120.4

1086: jai_om_wsh_processing_pkg.excise_balance_check_f.sql 115.1 ssumaith 11/02/2005 New parameters added to function.
1087:
1088: 12.0 4566054 jai_om_rg.pls 120.3 Aiyer 24-Aug-2005
1089: jai_om_rg.plb 120.4
1090: jai_om_wsh.plb (jai_om_wsh_pkg.process_delivery) 120.4
1091: JAINIRGI.fmb 120.2
1092: jain14.odf 120.3
1093: jain14reg.ldt 120.3
1094: New migration script to port data into new tables 120.0

Line 1536: v_reg_type := jai_om_wsh_pkg.get_excise_register_with_bal(

1532: fetch c_sh_cess_amount into ln_sh_cess_amount;
1533: close c_sh_cess_amount;
1534:
1535:
1536: v_reg_type := jai_om_wsh_pkg.get_excise_register_with_bal(
1537: v_pref_rg23a ,
1538: v_pref_rg23c ,
1539: v_pref_pla ,
1540: NVL(v_ssi_unit_flag,'N') ,

Line 2453: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_wsh_pkg.get_excise_register_with_bal';

2449: lv_rg23a_sh_cess_avlbl VARCHAR2(10); /* added by ssawant for bug 5989740 */
2450: lv_rg23c_sh_cess_avlbl VARCHAR2(10); /* added by ssawant for bug 5989740 */
2451: lv_pla_sh_cess_avlbl VARCHAR2(10); /* added by ssawant for bug 5989740 */
2452:
2453: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_wsh_pkg.get_excise_register_with_bal';
2454:
2455:
2456: --Variable Declaration Ends here......................
2457:

Line 2468: type. This Function is called from ja_in_wsh_dlry_dtls_au_trg.sql and jai_om_wsh_pkg.process_delivery.sql.

2464: Function created for checking the register preferences in case of an Non-
2465: Export Oriented Unit and in case of an Export Oriented Unit, the component
2466: balances are checked and if balances does not exist, the function will raise an
2467: application error and if balances exists, then the function will return the register
2468: type. This Function is called from ja_in_wsh_dlry_dtls_au_trg.sql and jai_om_wsh_pkg.process_delivery.sql.
2469: This Function is a prerequisite patch with the above mentioned trigger and procedure.
2470: Also Alter table scripts with this patch should be available before sending this patch.
2471: Otherwise the patch would certainly fail.
2472:

Line 2891: jai_om_wsh_pkg.process_delivery ( errbuf ,

2887: A delivery id was passed , So just call the procedure once , ascertain the return status and signal completion
2888: **/
2889:
2890: IF pn_delivery_id IS NOT NULL THEN
2891: jai_om_wsh_pkg.process_delivery ( errbuf ,
2892: retcode ,
2893: pn_delivery_id
2894: ) ;
2895: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || pn_delivery_id || ' return code => ' || retcode);

Line 2895: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || pn_delivery_id || ' return code => ' || retcode);

2891: jai_om_wsh_pkg.process_delivery ( errbuf ,
2892: retcode ,
2893: pn_delivery_id
2894: ) ;
2895: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || pn_delivery_id || ' return code => ' || retcode);
2896: IF nvl(retcode,'0') <> '0' THEN
2897: ln_error_occured := 1;
2898: ln_success := 0;
2899: Rollback;

Line 2914: fnd_file.put_line ( fnd_file.log , ' Calling jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id );

2910: From JAI_OM_OE_GEN_TAXINV_T
2911: )
2912: LOOP
2913: BEGIN
2914: fnd_file.put_line ( fnd_file.log , ' Calling jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id );
2915: jai_om_wsh_pkg.process_delivery(errbuf ,
2916: retcode ,
2917: temp_rec.delivery_id
2918: ) ;

Line 2915: jai_om_wsh_pkg.process_delivery(errbuf ,

2911: )
2912: LOOP
2913: BEGIN
2914: fnd_file.put_line ( fnd_file.log , ' Calling jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id );
2915: jai_om_wsh_pkg.process_delivery(errbuf ,
2916: retcode ,
2917: temp_rec.delivery_id
2918: ) ;
2919: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' return code => ' || retcode);

Line 2919: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' return code => ' || retcode);

2915: jai_om_wsh_pkg.process_delivery(errbuf ,
2916: retcode ,
2917: temp_rec.delivery_id
2918: ) ;
2919: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' return code => ' || retcode);
2920: IF nvl(retcode,'0') <> '0' THEN
2921: /* An Error has occured - rollback the changes done by the changes and proceed with the next one*/
2922: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' Error is => ' || errbuf);
2923: ln_error_occured := 1;

Line 2922: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' Error is => ' || errbuf);

2918: ) ;
2919: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' return code => ' || retcode);
2920: IF nvl(retcode,'0') <> '0' THEN
2921: /* An Error has occured - rollback the changes done by the changes and proceed with the next one*/
2922: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' Error is => ' || errbuf);
2923: ln_error_occured := 1;
2924: Rollback;
2925: else
2926: ln_success := 1; /* It will hold the status whether atleast one delivery was successfully processed*/

Line 2958: END jai_om_wsh_pkg;

2954: end if;
2955: errbuf := substr(sqlerrm,1,1999);
2956: END process_deliveries;
2957:
2958: END jai_om_wsh_pkg;