152: RETURN r_tax;
153:
154: EXCEPTION
155: WHEN OTHERS THEN
156: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
157: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
158: app_exception.raise_exception;
159: END get_apportioned_tax;
160:
153:
154: EXCEPTION
155: WHEN OTHERS THEN
156: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
157: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
158: app_exception.raise_exception;
159: END get_apportioned_tax;
160:
161:
188: EXCEPTION
189: WHEN OTHERS THEN
190: p_vendor_id := null;
191: p_vendor_site_id := null;
192: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
193: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
194: app_exception.raise_exception;
195: END get_changed_vendor_dtls;
196:
189: WHEN OTHERS THEN
190: p_vendor_id := null;
191: p_vendor_site_id := null;
192: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
193: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
194: app_exception.raise_exception;
195: END get_changed_vendor_dtls;
196:
197: /* Procedure Created by Vijay Shankar for Bug#3940588. RECEIPTS DEPLUG
285: END IF;
286: /* End, Vijay Shankar for Bug#3940588 */
287: EXCEPTION
288: WHEN OTHERS THEN
289: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
290: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
291: app_exception.raise_exception;
292: END post_cenvat_processor;
293:
286: /* End, Vijay Shankar for Bug#3940588 */
287: EXCEPTION
288: WHEN OTHERS THEN
289: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
290: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
291: app_exception.raise_exception;
292: END post_cenvat_processor;
293:
294: /* Start of bug 5365346. Created by Lakshmi Gopalsami */
846: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath, null, 'END');
847: EXCEPTION
848: WHEN OTHERS THEN
849: pr_tax := null;
850: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
851: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
852: app_exception.raise_exception;
853: END do_cenvat_rounding;
854:
847: EXCEPTION
848: WHEN OTHERS THEN
849: pr_tax := null;
850: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
851: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
852: app_exception.raise_exception;
853: END do_cenvat_rounding;
854:
855: PROCEDURE process_transaction(
4796:
4797: RETURN ln_cenvat_claimed_ptg;
4798: EXCEPTION
4799: WHEN OTHERS THEN
4800: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
4801: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
4802: app_exception.raise_exception;
4803: END get_receive_claimed_ptg;
4804:
4797: RETURN ln_cenvat_claimed_ptg;
4798: EXCEPTION
4799: WHEN OTHERS THEN
4800: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
4801: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
4802: app_exception.raise_exception;
4803: END get_receive_claimed_ptg;
4804:
4805: /*~~~~~~~~~~~~~~~~~~~~~~~~~ TAX BREAUP ~~~~~~~~~~~~~~~~~~~~~~~~~~*/
5015:
5016: EXCEPTION
5017: WHEN OTHERS THEN
5018: pr_tax := null;
5019: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5020: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5021: app_exception.raise_exception;
5022: END get_tax_amount_breakup;
5023:
5016: EXCEPTION
5017: WHEN OTHERS THEN
5018: pr_tax := null;
5019: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5020: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5021: app_exception.raise_exception;
5022: END get_tax_amount_breakup;
5023:
5024: PROCEDURE other_cenvat_rg_recording(
5054: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate
5055: );
5056: EXCEPTION
5057: WHEN OTHERS THEN
5058: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5059: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5060: app_exception.raise_exception;
5061: END other_cenvat_rg_recording;
5062:
5055: );
5056: EXCEPTION
5057: WHEN OTHERS THEN
5058: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5059: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5060: app_exception.raise_exception;
5061: END other_cenvat_rg_recording;
5062:
5063: /*~~~~~~~~~~~~~~~~~~~~~~ DERIVING CGIN Scenario ~~~~~~~~~~~~~~~~~~~~~~~~~*/
5244: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath, NULL, 'END'); /* 26 */
5245: EXCEPTION
5246: WHEN OTHERS THEN
5247: p_cgin_code := null;
5248: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5249: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5250: app_exception.raise_exception;
5251: END derive_cgin_scenario;
5252:
5245: EXCEPTION
5246: WHEN OTHERS THEN
5247: p_cgin_code := null;
5248: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5249: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5250: app_exception.raise_exception;
5251: END derive_cgin_scenario;
5252:
5253: PROCEDURE derive_duty_registers(