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_CONSTANTS

Line 60: p_process_flag := jai_constants.successful;

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
60: p_process_flag := jai_constants.successful;
61: p_process_msg := NULL;
62: return;
63: END IF;
64:

Line 66: p_process_flag := jai_constants.expected_error;

62: return;
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:

Line 72: p_process_flag := jai_constants.expected_error;

68: return;
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:

Line 78: p_process_flag := jai_constants.expected_error;

74: return;
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:

Line 117: p_process_flag := jai_constants.successful;

113: ln_user_id ,
114: sysdate ,
115: fnd_global.login_id
116: );
117: p_process_flag := jai_constants.successful;
118:
119: EXCEPTION
120: WHEN OTHERS THEN
121: p_process_flag := jai_constants.unexpected_error;

Line 121: p_process_flag := jai_constants.unexpected_error;

117: p_process_flag := jai_constants.successful;
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:

Line 146: and tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess); --rchandan for bug#4428980

142: SELECT NVL(SUM(balance),0)
143: FROM JAI_CMN_RG_OTH_BALANCES
144: WHERE org_unit_id = cp_org_unit_id
145: and register_type = p_register_type
146: and tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess); --rchandan for bug#4428980
147:
148: ln_org_unit_id NUMBER;
149: ln_balance_avlbl NUMBER;
150:

Line 154: p_process_flag := jai_constants.successful;

150:
151: BEGIN
152:
153: IF NVL(p_trx_amount,0) = 0 THEN
154: p_process_flag := jai_constants.successful;
155: p_process_message := NULL;
156: RETURN;
157: END IF;
158:

Line 164: p_process_flag := jai_constants.expected_error;

160: FETCH c_org_unit_id into ln_org_unit_id;
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:

Line 174: p_process_flag := jai_constants.expected_error;

170: FETCH c_balance_cur into ln_balance_avlbl;
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:

Line 180: p_process_flag := jai_constants.expected_error;

176: return;
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:

Line 186: p_process_flag := jai_constants.expected_error;

182: return;
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:

Line 191: p_process_flag := jai_constants.successful;

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;
192: p_process_message := NULL;
193:
194: EXCEPTION
195: WHEN others THEN

Line 196: p_process_flag := jai_constants.unexpected_error;

192: p_process_message := NULL;
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 */

Line 223: and tax_type in ( jai_constants.tax_type_sh_exc_edu_cess,

219: SELECT NVL(SUM(balance),0)
220: FROM JAI_CMN_RG_OTH_BALANCES
221: WHERE org_unit_id = cp_org_unit_id
222: and register_type = p_register_type
223: and tax_type in ( jai_constants.tax_type_sh_exc_edu_cess,
224: jai_constants.tax_type_sh_cvd_edu_cess
225: );
226:
227: ln_org_unit_id NUMBER;

Line 224: jai_constants.tax_type_sh_cvd_edu_cess

220: FROM JAI_CMN_RG_OTH_BALANCES
221: WHERE org_unit_id = cp_org_unit_id
222: and register_type = p_register_type
223: and tax_type in ( jai_constants.tax_type_sh_exc_edu_cess,
224: jai_constants.tax_type_sh_cvd_edu_cess
225: );
226:
227: ln_org_unit_id NUMBER;
228: ln_balance_avlbl NUMBER;

Line 233: p_process_flag := jai_constants.successful;

229:
230: BEGIN
231:
232: IF NVL(p_trx_amount,0) = 0 THEN
233: p_process_flag := jai_constants.successful;
234: p_process_message := NULL;
235: RETURN;
236: END IF;
237:

Line 243: p_process_flag := jai_constants.expected_error;

239: FETCH c_org_unit_id into ln_org_unit_id;
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:

Line 253: p_process_flag := jai_constants.expected_error;

249: FETCH c_balance_cur into ln_balance_avlbl;
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:

Line 259: p_process_flag := jai_constants.expected_error;

255: return;
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:

Line 265: p_process_flag := jai_constants.expected_error;

261: return;
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:

Line 270: p_process_flag := jai_constants.successful;

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;
271: p_process_message := NULL;
272:
273: EXCEPTION
274: WHEN others THEN

Line 275: p_process_flag := jai_constants.unexpected_error;

271: p_process_message := NULL;
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: