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:
162: -- Start, following procedures added by Vijay Shankar for Bug#3940588. RECEIPTS DEPLUG
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
198: POST PROCESSOR of CENVAT */
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 */
295: PROCEDURE update_RTV_Diff_value
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(
856: p_transaction_id IN NUMBER,
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 ~~~~~~~~~~~~~~~~~~~~~~~~~~*/
4806:
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(
5025: p_source_register IN VARCHAR2,
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 ~~~~~~~~~~~~~~~~~~~~~~~~~*/
5064:
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(
5254: p_organization_id IN NUMBER,