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.19.12020000.10 2013/04/07 08:20:39 mmurtuza ship $ */
3:
4:
5: PROCEDURE process_delivery

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

671: 19 2002/07/03 Nagaraj.s - For Enh#2415656.
672: Cursors pref_cur - Incorporated v_export_oriented_unit also in the select clause
673: RG Bal Cur- Incorporated basic,additional,other pla balance also in the select clause.
674: Functions jai_om_wsh_processing_pkg.excise_balance_check - for preference checks in case of EOU and Non-EOU for total excise amount
675: jai_om_wsh_pkg.get_excise_register_with_bal - for preference checks in case of EOU and Non-EOU
676: for exempted amount.
677: Before sending this patch it has to be taken care that, the alter scripts,functions should also
678: accompany the patch otherwise the patch would certainly fail.
679:

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

939: The basic business logic validation is that both cess and excise should be available as
940: part of the same register type and the register preference setup at the organization additional information
941: needs to be considered for picking up the correct register .
942:
943: 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
944: which have had changes in their signature and hence the caller also needs to pass the correct
945: parameters.
946:
947: The change done in this object is to pass the additional parameters correctly to the functions.

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

947: The change done in this object is to pass the additional parameters correctly to the functions.
948:
949: Dependency Due to this Bug:-
950: The current procedure becomes dependent on the functions jai_om_wsh_processing_pkg.excise_balance_check (version 115.1) and
951: jai_om_wsh_pkg.get_excise_register_with_bal (version 115.1) also packaged as part of this bug.
952:
953: 42. 2005/02/16 ssumaith - bug# 4185392 - File version 115.4
954:
955: Excise Duty rate was going in as zero in JAI_CMN_RG_I_TRXS table. This was because the variable

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

1015: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
1016: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
1017:
1018: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.
1019: This has been populated from this and jai_om_wsh_pkg.process_delivery procedure.
1020:
1021: A migration script has been provided to migrate the value for cess and source.
1022:
1023: Dependency due to this bug:-

Line 1027: 4. Procedure jai_om_wsh_pkg.process_delivery

1023: Dependency due to this bug:-
1024: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
1025: 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
1026: 3. Modified the trigger jai_jar_t_aru_t1
1027: 4. Procedure jai_om_wsh_pkg.process_delivery
1028: 5. Report JAICMNRG1.rdf
1029: 6. Created a migration script to populate cess_amt and source for Shipment and Receivable transactions.
1030: Both functional and technical dependencies exists
1031:

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

1161: 619.1 3446362 IN60105D2 None -- Aiyer 19/03/2004 Row introduces to start dependency tracking
1162:
1163:
1164: 115.3 4171272 IN60106 +
1165: 4147608 jai_om_wsh_pkg.get_excise_register_with_bal_f.sql 115.1 ssumaith 11/02/2005 New parameters added to function.
1166: jai_om_wsh_processing_pkg.excise_balance_check_f.sql 115.1 ssumaith 11/02/2005 New parameters added to function.
1167:
1168: 12.0 4566054 jai_om_rg.pls 120.3 Aiyer 24-Aug-2005
1169: jai_om_rg.plb 120.4

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

1166: jai_om_wsh_processing_pkg.excise_balance_check_f.sql 115.1 ssumaith 11/02/2005 New parameters added to function.
1167:
1168: 12.0 4566054 jai_om_rg.pls 120.3 Aiyer 24-Aug-2005
1169: jai_om_rg.plb 120.4
1170: jai_om_wsh.plb (jai_om_wsh_pkg.process_delivery) 120.4
1171: JAINIRGI.fmb 120.2
1172: jain14.odf 120.3
1173: jain14reg.ldt 120.3
1174: New migration script to port data into new tables 120.0

Line 1625: v_reg_type := jai_om_wsh_pkg.get_excise_register_with_bal(

1621: fetch c_sh_cess_amount into ln_sh_cess_amount;
1622: close c_sh_cess_amount;
1623:
1624:
1625: v_reg_type := jai_om_wsh_pkg.get_excise_register_with_bal(
1626: v_pref_rg23a ,
1627: v_pref_rg23c ,
1628: v_pref_pla ,
1629: NVL(v_ssi_unit_flag,'N') ,

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

2578: lv_rg23a_sh_cess_avlbl VARCHAR2(10); /* added by ssawant for bug 5989740 */
2579: lv_rg23c_sh_cess_avlbl VARCHAR2(10); /* added by ssawant for bug 5989740 */
2580: lv_pla_sh_cess_avlbl VARCHAR2(10); /* added by ssawant for bug 5989740 */
2581:
2582: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_wsh_pkg.get_excise_register_with_bal';
2583:
2584:
2585: --Variable Declaration Ends here......................
2586:

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

2593: Function created for checking the register preferences in case of an Non-
2594: Export Oriented Unit and in case of an Export Oriented Unit, the component
2595: balances are checked and if balances does not exist, the function will raise an
2596: application error and if balances exists, then the function will return the register
2597: type. This Function is called from ja_in_wsh_dlry_dtls_au_trg.sql and jai_om_wsh_pkg.process_delivery.sql.
2598: This Function is a prerequisite patch with the above mentioned trigger and procedure.
2599: Also Alter table scripts with this patch should be available before sending this patch.
2600: Otherwise the patch would certainly fail.
2601:

Line 3020: jai_om_wsh_pkg.process_delivery ( errbuf ,

3016: A delivery id was passed , So just call the procedure once , ascertain the return status and signal completion
3017: **/
3018:
3019: IF pn_delivery_id IS NOT NULL THEN
3020: jai_om_wsh_pkg.process_delivery ( errbuf ,
3021: retcode ,
3022: pn_delivery_id
3023: ) ;
3024: 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 3024: 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);

3020: jai_om_wsh_pkg.process_delivery ( errbuf ,
3021: retcode ,
3022: pn_delivery_id
3023: ) ;
3024: 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);
3025: IF nvl(retcode,'0') <> '0' THEN
3026: ln_error_occured := 1;
3027: ln_success := 0;
3028: Rollback;

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

3042: and mo_global.check_access(jowla.org_id) = 'Y'
3043: ) /*Added join of table jai_om_wsh_lines_all and check_access by mmurtuza for bug 16308603*/
3044: LOOP
3045: BEGIN
3046: fnd_file.put_line ( fnd_file.log , ' Calling jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id );
3047: jai_om_wsh_pkg.process_delivery(errbuf ,
3048: retcode ,
3049: temp_rec.delivery_id
3050: ) ;

Line 3047: jai_om_wsh_pkg.process_delivery(errbuf ,

3043: ) /*Added join of table jai_om_wsh_lines_all and check_access by mmurtuza for bug 16308603*/
3044: LOOP
3045: BEGIN
3046: fnd_file.put_line ( fnd_file.log , ' Calling jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id );
3047: jai_om_wsh_pkg.process_delivery(errbuf ,
3048: retcode ,
3049: temp_rec.delivery_id
3050: ) ;
3051: 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 3051: 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);

3047: jai_om_wsh_pkg.process_delivery(errbuf ,
3048: retcode ,
3049: temp_rec.delivery_id
3050: ) ;
3051: 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);
3052: IF nvl(retcode,'0') <> '0' THEN
3053: /* An Error has occured - rollback the changes done by the changes and proceed with the next one*/
3054: 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);
3055: ln_error_occured := 1;

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

3050: ) ;
3051: 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);
3052: IF nvl(retcode,'0') <> '0' THEN
3053: /* An Error has occured - rollback the changes done by the changes and proceed with the next one*/
3054: 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);
3055: ln_error_occured := 1;
3056: Rollback;
3057: else
3058: ln_success := 1; /* It will hold the status whether atleast one delivery was successfully processed*/

Line 3090: END jai_om_wsh_pkg;

3086: end if;
3087: errbuf := substr(sqlerrm,1,1999);
3088: END process_deliveries;
3089:
3090: END jai_om_wsh_pkg;