74: RETURN lv_expense_flag;
75:
76: EXCEPTION
77: WHEN OTHERS THEN
78: FND_MESSAGE.SET_NAME('JA','JAI_EXCEPTION_OCCURED');
79: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG', lv_object_name ||'. Err:'||sqlerrm );
80: app_exception.raise_exception;
81: END is_item_an_expense;
82:
75:
76: EXCEPTION
77: WHEN OTHERS THEN
78: FND_MESSAGE.SET_NAME('JA','JAI_EXCEPTION_OCCURED');
79: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG', lv_object_name ||'. Err:'||sqlerrm );
80: app_exception.raise_exception;
81: END is_item_an_expense;
82:
83: FUNCTION get_fin_year( p_organization_id IN NUMBER) RETURN NUMBER IS
97: CLOSE c_active_fin_year;
98: RETURN ln_fin_year;
99: EXCEPTION
100: WHEN OTHERS THEN
101: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
102: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
103: app_exception.raise_exception;
104: END get_fin_year;
105:
98: RETURN ln_fin_year;
99: EXCEPTION
100: WHEN OTHERS THEN
101: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
102: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
103: app_exception.raise_exception;
104: END get_fin_year;
105:
106: PROCEDURE get_range_division (
124: EXCEPTION
125: WHEN OTHERS THEN
126: p_range_no:=null;
127: p_division_no:=null;
128: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
129: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
130: app_exception.raise_exception;
131: END get_range_division;
132:
125: WHEN OTHERS THEN
126: p_range_no:=null;
127: p_division_no:=null;
128: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
129: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
130: app_exception.raise_exception;
131: END get_range_division;
132:
133: FUNCTION get_currency_precision (
174:
175: RETURN lv_concatenated_segments;
176: EXCEPTION
177: WHEN OTHERS THEN
178: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
179: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
180: app_exception.raise_exception;
181: END get_gl_concatenated_segments;
182:
175: RETURN lv_concatenated_segments;
176: EXCEPTION
177: WHEN OTHERS THEN
178: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
179: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
180: app_exception.raise_exception;
181: END get_gl_concatenated_segments;
182:
183: FUNCTION get_organization_code (
201:
202: RETURN lv_organization_code;
203: EXCEPTION
204: WHEN OTHERS THEN
205: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
206: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
207: app_exception.raise_exception;
208: END get_organization_code;
209:
202: RETURN lv_organization_code;
203: EXCEPTION
204: WHEN OTHERS THEN
205: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
206: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
207: app_exception.raise_exception;
208: END get_organization_code;
209:
210: FUNCTION get_rg_register_type(p_item_class IN VARCHAR2) RETURN VARCHAR2 IS
226:
227: RETURN lv_register_type;
228: EXCEPTION
229: WHEN OTHERS THEN
230: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
231: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
232: app_exception.raise_exception;
233: END get_rg_register_type;
234:
227: RETURN lv_register_type;
228: EXCEPTION
229: WHEN OTHERS THEN
230: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
231: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
232: app_exception.raise_exception;
233: END get_rg_register_type;
234:
235: FUNCTION get_primary_uom_code(p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2 IS
251:
252: RETURN lv_uom_code;
253: EXCEPTION
254: WHEN OTHERS THEN
255: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
256: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
257: app_exception.raise_exception;
258: END get_primary_uom_code;
259:
252: RETURN lv_uom_code;
253: EXCEPTION
254: WHEN OTHERS THEN
255: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
256: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
257: app_exception.raise_exception;
258: END get_primary_uom_code;
259:
260: FUNCTION get_uom_code(p_uom IN VARCHAR2) RETURN VARCHAR2 IS
274: RETURN lv_uom_code;
275:
276: EXCEPTION
277: WHEN OTHERS THEN
278: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
279: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
280: app_exception.raise_exception;
281: END get_uom_code;
282:
275:
276: EXCEPTION
277: WHEN OTHERS THEN
278: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
279: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
280: app_exception.raise_exception;
281: END get_uom_code;
282:
283: FUNCTION get_orgn_master_flag(p_organization_id IN NUMBER, p_location_id IN NUMBER) RETURN VARCHAR2 IS
297:
298: RETURN lv_master_flag;
299: EXCEPTION
300: WHEN OTHERS THEN
301: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
302: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
303: app_exception.raise_exception;
304: END get_orgn_master_flag;
305:
298: RETURN lv_master_flag;
299: EXCEPTION
300: WHEN OTHERS THEN
301: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
302: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
303: app_exception.raise_exception;
304: END get_orgn_master_flag;
305:
306: FUNCTION get_matched_boe_no(
324:
325: RETURN lv_boe_no;
326: EXCEPTION
327: WHEN OTHERS THEN
328: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
329: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
330: app_exception.raise_exception;
331: END get_matched_boe_no;
332:
325: RETURN lv_boe_no;
326: EXCEPTION
327: WHEN OTHERS THEN
328: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
329: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
330: app_exception.raise_exception;
331: END get_matched_boe_no;
332:
333: FUNCTION trxn_to_primary_conv_rate(
361:
362: RETURN vTransToPrimaryUOMConv;
363: EXCEPTION
364: WHEN OTHERS THEN
365: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
366: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
367: app_exception.raise_exception;
368: END trxn_to_primary_conv_rate;
369:
362: RETURN vTransToPrimaryUOMConv;
363: EXCEPTION
364: WHEN OTHERS THEN
365: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
366: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
367: app_exception.raise_exception;
368: END trxn_to_primary_conv_rate;
369:
370: FUNCTION get_last_record_of_rg(
514:
515: RETURN ln_register_id;
516: EXCEPTION
517: WHEN OTHERS THEN
518: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
519: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
520: app_exception.raise_exception;
521: END get_last_record_of_rg;
522:
515: RETURN ln_register_id;
516: EXCEPTION
517: WHEN OTHERS THEN
518: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
519: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
520: app_exception.raise_exception;
521: END get_last_record_of_rg;
522:
523: PROCEDURE update_rg_balances(
561: WHERE organization_id = p_location_id
562: AND location_id = p_location_id;
563: EXCEPTION
564: WHEN OTHERS THEN
565: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
566: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
567: app_exception.raise_exception;
568: END update_rg_balances;
569:
562: AND location_id = p_location_id;
563: EXCEPTION
564: WHEN OTHERS THEN
565: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
566: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
567: app_exception.raise_exception;
568: END update_rg_balances;
569:
570: function plot_codepath
1148: END IF ;
1149:
1150: EXCEPTION
1151: WHEN OTHERS THEN
1152: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
1153: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
1154: app_exception.raise_exception;
1155:
1156: END ja_in_vat_assessable_value;
1149:
1150: EXCEPTION
1151: WHEN OTHERS THEN
1152: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
1153: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
1154: app_exception.raise_exception;
1155:
1156: END ja_in_vat_assessable_value;
1157: