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_CMN_RG_OTHERS_PKG dependencies on JAI_CMN_RG_OTHERS

Line 1: PACKAGE BODY jai_cmn_rg_others_pkg AS

1: PACKAGE BODY jai_cmn_rg_others_pkg AS
2: /* $Header: jai_cmn_rg_oth.plb 120.2 2007/05/04 13:43:25 csahoo ship $ */
3: /***************************************************************************************************
4: CREATED BY : ssumaith
5: CREATED DATE : 11-JAN-2005

Line 19: and not process the insert into JAI_CMN_RG_OTHERS table with zero debit and credit.

15: S.No dd/mm/yyyy Author and Details
16: 1 17/02/2005 ssumaith - File version 115.1
17: IF cess amount is passed as zero, an error is thrown to the user that cess amount cannot be zero
18: This may not be correct at all times. Hence code has been added to return control with success
19: and not process the insert into JAI_CMN_RG_OTHERS table with zero debit and credit.
20:
21: 2. 08-Jun-2005 Version 116.1 jai_cmn_rg_oth -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
22: as required for CASE COMPLAINCE.
23:

Line 36: procedure insert_row (p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,

32: ------------------------------------------------------------------------------------------------------------------------------
33:
34: ***************************************************************************************************/
35:
36: procedure insert_row (p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
37: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
38: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
39: p_tax_type JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE ,
40: debit_amt JAI_CMN_RG_OTHERS.DEBIT%TYPE ,

Line 37: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,

33:
34: ***************************************************************************************************/
35:
36: procedure insert_row (p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
37: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
38: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
39: p_tax_type JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE ,
40: debit_amt JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
41: credit_amt JAI_CMN_RG_OTHERS.CREDIT%TYPE ,

Line 38: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,

34: ***************************************************************************************************/
35:
36: procedure insert_row (p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
37: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
38: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
39: p_tax_type JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE ,
40: debit_amt JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
41: credit_amt JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
42: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 39: p_tax_type JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE ,

35:
36: procedure insert_row (p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
37: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
38: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
39: p_tax_type JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE ,
40: debit_amt JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
41: credit_amt JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
42: p_process_flag OUT NOCOPY VARCHAR2 ,
43: p_process_msg OUT NOCOPY VARCHAR2 ,

Line 40: debit_amt JAI_CMN_RG_OTHERS.DEBIT%TYPE ,

36: procedure insert_row (p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
37: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
38: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
39: p_tax_type JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE ,
40: debit_amt JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
41: credit_amt JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
42: p_process_flag OUT NOCOPY VARCHAR2 ,
43: p_process_msg OUT NOCOPY VARCHAR2 ,
44: p_attribute1 VARCHAR2 DEFAULT NULL ,

Line 41: credit_amt JAI_CMN_RG_OTHERS.CREDIT%TYPE ,

37: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
38: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
39: p_tax_type JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE ,
40: debit_amt JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
41: credit_amt JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
42: p_process_flag OUT NOCOPY VARCHAR2 ,
43: p_process_msg OUT NOCOPY VARCHAR2 ,
44: p_attribute1 VARCHAR2 DEFAULT NULL ,
45: p_attribute2 VARCHAR2 DEFAULT NULL ,

Line 52: SELECT JAI_CMN_RG_OTHERS_S.nextval

48: p_attribute5 VARCHAR2 DEFAULT NULL
49: ) IS
50:
51: CURSOR c_rg_other_id IS
52: SELECT JAI_CMN_RG_OTHERS_S.nextval
53: FROM dual;
54:
55: ln_rg_other_id JAI_CMN_RG_OTHERS.RG_OTHER_ID%TYPE;
56: ln_user_id NUMBER ; --:= fnd_global.user_id File.Sql.35 by Brathod

Line 55: ln_rg_other_id JAI_CMN_RG_OTHERS.RG_OTHER_ID%TYPE;

51: CURSOR c_rg_other_id IS
52: SELECT JAI_CMN_RG_OTHERS_S.nextval
53: FROM dual;
54:
55: ln_rg_other_id JAI_CMN_RG_OTHERS.RG_OTHER_ID%TYPE;
56: ln_user_id NUMBER ; --:= fnd_global.user_id File.Sql.35 by Brathod
57: BEGIN
58: ln_user_id := fnd_global.user_id ; -- File.Sql.35 by Brathod
59: IF nvl(debit_amt,0) = 0 AND NVL(credit_amt,0) =0 THEN

Line 67: p_process_msg := 'jai_cmn_rg_others_pkg - Source type cannot be Null';

63: END IF;
64:
65: IF p_source_type IS NULL THEN
66: p_process_flag := jai_constants.expected_error;
67: p_process_msg := 'jai_cmn_rg_others_pkg - Source type cannot be Null';
68: return;
69: END IF;
70:
71: IF p_source_name IS NULL THEN

Line 73: p_process_msg := 'jai_cmn_rg_others_pkg -Source Name cannot be Null';

69: END IF;
70:
71: IF p_source_name IS NULL THEN
72: p_process_flag := jai_constants.expected_error;
73: p_process_msg := 'jai_cmn_rg_others_pkg -Source Name cannot be Null';
74: return;
75: end if;
76:
77: IF p_tax_type IS NULL THEN

Line 79: p_process_msg := 'jai_cmn_rg_others_pkg - Tax type cannot be Null';

75: end if;
76:
77: IF p_tax_type IS NULL THEN
78: p_process_flag := jai_constants.expected_error;
79: p_process_msg := 'jai_cmn_rg_others_pkg - Tax type cannot be Null';
80: return;
81: END IF;
82:
83: OPEN c_rg_other_id;

Line 87: Insert into JAI_CMN_RG_OTHERS

83: OPEN c_rg_other_id;
84: FETCH c_rg_other_id into ln_rg_other_id;
85: CLOSE c_rg_other_id;
86:
87: Insert into JAI_CMN_RG_OTHERS
88: (
89: rg_other_id ,
90: source_type ,
91: source_register ,

Line 122: p_process_msg := 'Error Occured in jai_cmn_rg_others_pkg.insert_row - ' || substr(sqlerrm,1,900);

118:
119: EXCEPTION
120: WHEN OTHERS THEN
121: p_process_flag := jai_constants.unexpected_error;
122: p_process_msg := 'Error Occured in jai_cmn_rg_others_pkg.insert_row - ' || substr(sqlerrm,1,900);
123: END insert_row;
124:
125:
126: procedure check_balances(p_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE ,

Line 165: p_process_message := 'JAI_CMN_RG_OTHERS.check_balances => Invalid Organization and Location Combination passed ';

161: CLOSE c_org_unit_id;
162:
163: IF ln_org_unit_id IS NULL then
164: p_process_flag := jai_constants.expected_error;
165: p_process_message := 'JAI_CMN_RG_OTHERS.check_balances => Invalid Organization and Location Combination passed ';
166: return;
167: END IF;
168:
169: OPEN c_balance_cur(ln_org_unit_id);

Line 175: p_process_message := 'JAI_CMN_RG_OTHERS.check_balances => No Balance Available for the organization , location and register type combination ';

171: close c_balance_cur;
172:
173: IF ln_balance_avlbl = 0 THEN
174: p_process_flag := jai_constants.expected_error;
175: p_process_message := 'JAI_CMN_RG_OTHERS.check_balances => No Balance Available for the organization , location and register type combination ';
176: return;
177: END IF;
178:
179: IF p_trx_amount IS NULL THEN

Line 181: p_process_message := 'JAI_CMN_RG_OTHERS.check_balances => Input Transaction Amount is NULL ';

177: END IF;
178:
179: IF p_trx_amount IS NULL THEN
180: p_process_flag := jai_constants.expected_error;
181: p_process_message := 'JAI_CMN_RG_OTHERS.check_balances => Input Transaction Amount is NULL ';
182: return;
183: END IF;
184:
185: IF ln_balance_avlbl < p_trx_amount THEN

Line 187: p_process_message := 'JAI_CMN_RG_OTHERS.check_balances => Sufficient Balance Not Available for the organization , location and register type combination ';

183: END IF;
184:
185: IF ln_balance_avlbl < p_trx_amount THEN
186: p_process_flag := jai_constants.expected_error;
187: p_process_message := 'JAI_CMN_RG_OTHERS.check_balances => Sufficient Balance Not Available for the organization , location and register type combination ';
188: return;
189: END IF;
190:
191: p_process_flag := jai_constants.successful;

Line 197: p_process_message := 'JAI_CMN_RG_OTHERS.check_balances => Error Occured : ' || substr(sqlerrm,1,1000);

193:
194: EXCEPTION
195: WHEN others THEN
196: p_process_flag := jai_constants.unexpected_error;
197: p_process_message := 'JAI_CMN_RG_OTHERS.check_balances => Error Occured : ' || substr(sqlerrm,1,1000);
198: END;
199:
200: /*Procedure check_sh_balances is added to check balances for secondary and higher education cess */
201: -- start 5989740

Line 244: p_process_message := 'JAI_CMN_RG_OTHERS.check_sh_balances => Invalid Organization and Location Combination passed ';

240: CLOSE c_org_unit_id;
241:
242: IF ln_org_unit_id IS NULL then
243: p_process_flag := jai_constants.expected_error;
244: p_process_message := 'JAI_CMN_RG_OTHERS.check_sh_balances => Invalid Organization and Location Combination passed ';
245: return;
246: END IF;
247:
248: OPEN c_balance_cur(ln_org_unit_id);

Line 254: p_process_message := 'JAI_CMN_RG_OTHERS.check_sh_balances => No Balance Available for the organization , location and register type combination ';

250: close c_balance_cur;
251:
252: IF ln_balance_avlbl = 0 THEN
253: p_process_flag := jai_constants.expected_error;
254: p_process_message := 'JAI_CMN_RG_OTHERS.check_sh_balances => No Balance Available for the organization , location and register type combination ';
255: return;
256: END IF;
257:
258: IF p_trx_amount IS NULL THEN

Line 260: p_process_message := 'JAI_CMN_RG_OTHERS.check_sh_balances => Input Transaction Amount is NULL ';

256: END IF;
257:
258: IF p_trx_amount IS NULL THEN
259: p_process_flag := jai_constants.expected_error;
260: p_process_message := 'JAI_CMN_RG_OTHERS.check_sh_balances => Input Transaction Amount is NULL ';
261: return;
262: END IF;
263:
264: IF ln_balance_avlbl < p_trx_amount THEN

Line 266: p_process_message := 'JAI_CMN_RG_OTHERS.check_sh_balances => Sufficient Balance Not Available for the organization , location and register type combination ';

262: END IF;
263:
264: IF ln_balance_avlbl < p_trx_amount THEN
265: p_process_flag := jai_constants.expected_error;
266: p_process_message := 'JAI_CMN_RG_OTHERS.check_sh_balances => Sufficient Balance Not Available for the organization , location and register type combination ';
267: return;
268: END IF;
269:
270: p_process_flag := jai_constants.successful;

Line 276: p_process_message := 'JAI_CMN_RG_OTHERS.check_sh_balances => Error Occured : ' || substr(sqlerrm,1,1000);

272:
273: EXCEPTION
274: WHEN others THEN
275: p_process_flag := jai_constants.unexpected_error;
276: p_process_message := 'JAI_CMN_RG_OTHERS.check_sh_balances => Error Occured : ' || substr(sqlerrm,1,1000);
277: END check_sh_balances;
278: --end 5989740
279:
280:

Line 281: END jai_cmn_rg_others_pkg;

277: END check_sh_balances;
278: --end 5989740
279:
280:
281: END jai_cmn_rg_others_pkg;