201: RETURN r_tax;
202:
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_apportioned_tax;
209:
202:
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_apportioned_tax;
209:
210:
237: EXCEPTION
238: WHEN OTHERS THEN
239: p_vendor_id := null;
240: p_vendor_site_id := null;
241: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
242: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
243: app_exception.raise_exception;
244: END get_changed_vendor_dtls;
245:
238: WHEN OTHERS THEN
239: p_vendor_id := null;
240: p_vendor_site_id := null;
241: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
242: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
243: app_exception.raise_exception;
244: END get_changed_vendor_dtls;
245:
246: /* Procedure Created by Vijay Shankar for Bug#3940588. RECEIPTS DEPLUG
416: --end additions for bug#4750798
417:
418: EXCEPTION
419: WHEN OTHERS THEN
420: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
421: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
422: app_exception.raise_exception;
423: END post_cenvat_processor;
424:
417:
418: EXCEPTION
419: WHEN OTHERS THEN
420: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
421: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
422: app_exception.raise_exception;
423: END post_cenvat_processor;
424:
425: /* Start of bug 5365346. Created by Lakshmi Gopalsami */
977: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath, null, 'END');
978: EXCEPTION
979: WHEN OTHERS THEN
980: pr_tax := null;
981: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
982: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
983: app_exception.raise_exception;
984: END do_cenvat_rounding;
985:
978: EXCEPTION
979: WHEN OTHERS THEN
980: pr_tax := null;
981: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
982: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
983: app_exception.raise_exception;
984: END do_cenvat_rounding;
985:
986: PROCEDURE process_transaction(
5189:
5190: RETURN ln_cenvat_claimed_ptg;
5191: EXCEPTION
5192: WHEN OTHERS THEN
5193: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5194: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5195: app_exception.raise_exception;
5196: END get_receive_claimed_ptg;
5197:
5190: RETURN ln_cenvat_claimed_ptg;
5191: EXCEPTION
5192: WHEN OTHERS THEN
5193: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5194: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5195: app_exception.raise_exception;
5196: END get_receive_claimed_ptg;
5197:
5198: /*~~~~~~~~~~~~~~~~~~~~~~~~~ TAX BREAUP ~~~~~~~~~~~~~~~~~~~~~~~~~~*/
5548:
5549: EXCEPTION
5550: WHEN OTHERS THEN
5551: pr_tax := null;
5552: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5553: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5554: app_exception.raise_exception;
5555: END get_tax_amount_breakup;
5556:
5549: EXCEPTION
5550: WHEN OTHERS THEN
5551: pr_tax := null;
5552: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5553: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5554: app_exception.raise_exception;
5555: END get_tax_amount_breakup;
5556:
5557: PROCEDURE other_cenvat_rg_recording(
5587: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate
5588: );
5589: EXCEPTION
5590: WHEN OTHERS THEN
5591: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5592: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5593: app_exception.raise_exception;
5594: END other_cenvat_rg_recording;
5595:
5588: );
5589: EXCEPTION
5590: WHEN OTHERS THEN
5591: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5592: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5593: app_exception.raise_exception;
5594: END other_cenvat_rg_recording;
5595:
5596: /*~~~~~~~~~~~~~~~~~~~~~~ DERIVING CGIN Scenario ~~~~~~~~~~~~~~~~~~~~~~~~~*/
5777: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath, NULL, 'END'); /* 26 */
5778: EXCEPTION
5779: WHEN OTHERS THEN
5780: p_cgin_code := null;
5781: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5782: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5783: app_exception.raise_exception;
5784: END derive_cgin_scenario;
5785:
5778: EXCEPTION
5779: WHEN OTHERS THEN
5780: p_cgin_code := null;
5781: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5782: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5783: app_exception.raise_exception;
5784: END derive_cgin_scenario;
5785:
5786: PROCEDURE derive_duty_registers(