2086: );
2087:
2088: IF lv_process_flag IN ('EE', 'UE')
2089: THEN
2090: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2091: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_TAX_PKG.CALCULATE_TAX.Err:'||lv_process_message);
2092: app_exception.raise_exception;
2093: END IF;
2094: END IF;
2087:
2088: IF lv_process_flag IN ('EE', 'UE')
2089: THEN
2090: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2091: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_TAX_PKG.CALCULATE_TAX.Err:'||lv_process_message);
2092: app_exception.raise_exception;
2093: END IF;
2094: END IF;
2095: --=====================================================
2112: );
2113:
2114: IF lv_process_flag IN ('EE', 'UE')
2115: THEN
2116: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2117: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_TAX_PKG.CALCULATE_TAX.Err:'||lv_process_message);
2118: app_exception.raise_exception;
2119: END IF;
2120: END IF;
2113:
2114: IF lv_process_flag IN ('EE', 'UE')
2115: THEN
2116: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2117: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_TAX_PKG.CALCULATE_TAX.Err:'||lv_process_message);
2118: app_exception.raise_exception;
2119: END IF;
2120: END IF;
2121: --=====================================================
2146:
2147: EXCEPTION
2148: WHEN OTHERS THEN
2149: p_tax_amount := null;
2150: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2151: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2152: app_exception.raise_exception;
2153:
2154: END calculate_tax;
2147: EXCEPTION
2148: WHEN OTHERS THEN
2149: p_tax_amount := null;
2150: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2151: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2152: app_exception.raise_exception;
2153:
2154: END calculate_tax;
2155:
2363: FND_FILE.put_line(FND_FILE.LOG, 'Tax Defaultation is SUCCESSFUL. END PROCEDURE - JA_IN_BULK_PO_QUOT_TAXES - '||v_processed||'/'||v_total||' records processed.');
2364:
2365: EXCEPTION
2366: WHEN OTHERS THEN
2367: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2368: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2369: app_exception.raise_exception;
2370: END batch_quot_taxes_copy;
2371:
2364:
2365: EXCEPTION
2366: WHEN OTHERS THEN
2367: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2368: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2369: app_exception.raise_exception;
2370: END batch_quot_taxes_copy;
2371:
2372: /*------------------------------------------------------------------------------------------*/
2686: END LOOP;**/ --commented by Sriram on 22-Nov-2001
2687:
2688: EXCEPTION
2689: WHEN OTHERS THEN
2690: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2691: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2692: app_exception.raise_exception;
2693: END copy_reqn_taxes;
2694:
2687:
2688: EXCEPTION
2689: WHEN OTHERS THEN
2690: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2691: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2692: app_exception.raise_exception;
2693: END copy_reqn_taxes;
2694:
2695: /* ------------------------------------------------------------------------------------------------------*/
5038: );
5039:
5040: IF lv_process_flag IN ('EE', 'UE')
5041: THEN
5042: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5043: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_TAX_PKG.CALC_TAX.Err:'||lv_process_message);
5044: app_exception.raise_exception;
5045: END IF;
5046: END IF;
5039:
5040: IF lv_process_flag IN ('EE', 'UE')
5041: THEN
5042: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5043: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_TAX_PKG.CALC_TAX.Err:'||lv_process_message);
5044: app_exception.raise_exception;
5045: END IF;
5046: END IF;
5047: --=====================================================
5105:
5106: EXCEPTION
5107: WHEN OTHERS THEN
5108: p_tax_amount := null;
5109: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5110: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5111: app_exception.raise_exception;
5112: END calc_tax;
5113:
5106: EXCEPTION
5107: WHEN OTHERS THEN
5108: p_tax_amount := null;
5109: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5110: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5111: app_exception.raise_exception;
5112: END calc_tax;
5113:
5114:
5453: Where line_location_id = p_po_line_loc_id;
5454: END IF;
5455: EXCEPTION
5456: WHEN OTHERS THEN
5457: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5458: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5459: app_exception.raise_exception;
5460: END copy_source_taxes;
5461:
5454: END IF;
5455: EXCEPTION
5456: WHEN OTHERS THEN
5457: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5458: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5459: app_exception.raise_exception;
5460: END copy_source_taxes;
5461:
5462: /*----------------------------------------------------------------------------------------*/
5740: -- Ravi for VAT
5741:
5742: EXCEPTION
5743: WHEN OTHERS THEN
5744: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5745: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5746: app_exception.raise_exception;
5747: END copy_quot_taxes;
5748:
5741:
5742: EXCEPTION
5743: WHEN OTHERS THEN
5744: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
5745: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
5746: app_exception.raise_exception;
5747: END copy_quot_taxes;
5748:
5749: /*------------------------------------------------------------------------------------------------------------*/
6554: DELETE FROM JAI_PO_REQUEST_T WHERE line_focus_id = p_seq_val;
6555: END IF ;
6556: EXCEPTION
6557: WHEN OTHERS THEN
6558: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
6559: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
6560: app_exception.raise_exception;
6561: END copy_agreement_taxes;
6562:
6555: END IF ;
6556: EXCEPTION
6557: WHEN OTHERS THEN
6558: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
6559: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
6560: app_exception.raise_exception;
6561: END copy_agreement_taxes;
6562:
6563: /*--------------------------------------------------------------------------------------------------------------------------
7071: END IF;
7072: EXCEPTION
7073: WHEN OTHERS THEN
7074: success:= null;
7075: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
7076: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
7077: app_exception.raise_exception;
7078: END Ja_In_Po_Case1;
7079:
7072: EXCEPTION
7073: WHEN OTHERS THEN
7074: success:= null;
7075: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
7076: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
7077: app_exception.raise_exception;
7078: END Ja_In_Po_Case1;
7079:
7080: -------------------------------------------------------------------------------------------------
7405: END IF;
7406:
7407: EXCEPTION
7408: WHEN OTHERS THEN
7409: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
7410: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
7411: app_exception.raise_exception;
7412: END Ja_In_Po_Case2;
7413:
7406:
7407: EXCEPTION
7408: WHEN OTHERS THEN
7409: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
7410: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
7411: app_exception.raise_exception;
7412: END Ja_In_Po_Case2;
7413:
7414: -------------------------------------------------------------------------------------------------
7507: );
7508:
7509: EXCEPTION
7510: WHEN OTHERS THEN
7511: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
7512: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
7513: app_exception.raise_exception;
7514:
7515: END Ja_In_Po_Insert;
7508:
7509: EXCEPTION
7510: WHEN OTHERS THEN
7511: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
7512: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
7513: app_exception.raise_exception;
7514:
7515: END Ja_In_Po_Insert;
7516: END jai_po_tax_pkg;