2807: );
2808:
2809: IF lv_process_flag IN ('EE', 'UE')
2810: THEN
2811: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2812: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_TAX_PKG.CALCULATE_TAX.Err:'||lv_process_message);
2813: app_exception.raise_exception;
2814: END IF;
2815: END IF;
2808:
2809: IF lv_process_flag IN ('EE', 'UE')
2810: THEN
2811: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2812: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_TAX_PKG.CALCULATE_TAX.Err:'||lv_process_message);
2813: app_exception.raise_exception;
2814: END IF;
2815: END IF;
2816: --=====================================================
2833: );
2834:
2835: IF lv_process_flag IN ('EE', 'UE')
2836: THEN
2837: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2838: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_TAX_PKG.CALCULATE_TAX.Err:'||lv_process_message);
2839: app_exception.raise_exception;
2840: END IF;
2841: END IF;
2834:
2835: IF lv_process_flag IN ('EE', 'UE')
2836: THEN
2837: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2838: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_TAX_PKG.CALCULATE_TAX.Err:'||lv_process_message);
2839: app_exception.raise_exception;
2840: END IF;
2841: END IF;
2842: --=====================================================
2867:
2868: EXCEPTION
2869: WHEN OTHERS THEN
2870: p_tax_amount := null;
2871: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2872: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2873: app_exception.raise_exception;
2874:
2875: END calculate_tax;
2868: EXCEPTION
2869: WHEN OTHERS THEN
2870: p_tax_amount := null;
2871: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2872: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2873: app_exception.raise_exception;
2874:
2875: END calculate_tax;
2876:
3084: 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.');
3085:
3086: EXCEPTION
3087: WHEN OTHERS THEN
3088: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
3089: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
3090: app_exception.raise_exception;
3091: END batch_quot_taxes_copy;
3092:
3085:
3086: EXCEPTION
3087: WHEN OTHERS THEN
3088: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
3089: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
3090: app_exception.raise_exception;
3091: END batch_quot_taxes_copy;
3092:
3093: /*------------------------------------------------------------------------------------------*/
3443: END LOOP;**/ --commented by Sriram on 22-Nov-2001
3444:
3445: EXCEPTION
3446: WHEN OTHERS THEN
3447: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
3448: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
3449: app_exception.raise_exception;
3450: END copy_reqn_taxes;
3451:
3444:
3445: EXCEPTION
3446: WHEN OTHERS THEN
3447: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
3448: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
3449: app_exception.raise_exception;
3450: END copy_reqn_taxes;
3451:
3452: /* ------------------------------------------------------------------------------------------------------*/
6427: );
6428:
6429: IF lv_process_flag IN ('EE', 'UE')
6430: THEN
6431: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
6432: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_TAX_PKG.CALC_TAX.Err:'||lv_process_message);
6433: app_exception.raise_exception;
6434: END IF;
6435: END IF;
6428:
6429: IF lv_process_flag IN ('EE', 'UE')
6430: THEN
6431: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
6432: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_TAX_PKG.CALC_TAX.Err:'||lv_process_message);
6433: app_exception.raise_exception;
6434: END IF;
6435: END IF;
6436: --=====================================================
6494:
6495: EXCEPTION
6496: WHEN OTHERS THEN
6497: p_tax_amount := null;
6498: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
6499: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
6500: app_exception.raise_exception;
6501: END calc_tax;
6502:
6495: EXCEPTION
6496: WHEN OTHERS THEN
6497: p_tax_amount := null;
6498: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
6499: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
6500: app_exception.raise_exception;
6501: END calc_tax;
6502:
6503:
6842: Where line_location_id = p_po_line_loc_id;
6843: END IF;
6844: EXCEPTION
6845: WHEN OTHERS THEN
6846: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
6847: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
6848: app_exception.raise_exception;
6849: END copy_source_taxes;
6850:
6843: END IF;
6844: EXCEPTION
6845: WHEN OTHERS THEN
6846: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
6847: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
6848: app_exception.raise_exception;
6849: END copy_source_taxes;
6850:
6851: /*----------------------------------------------------------------------------------------*/
7152: );
7153:
7154: EXCEPTION
7155: WHEN OTHERS THEN
7156: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
7157: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
7158: app_exception.raise_exception;
7159: END copy_quot_taxes;
7160:
7153:
7154: EXCEPTION
7155: WHEN OTHERS THEN
7156: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
7157: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
7158: app_exception.raise_exception;
7159: END copy_quot_taxes;
7160:
7161: /*------------------------------------------------------------------------------------------------------------*/
8034: DELETE FROM JAI_PO_REQUEST_T WHERE line_focus_id = p_seq_val;
8035: END IF ;
8036: EXCEPTION
8037: WHEN OTHERS THEN
8038: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
8039: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
8040: app_exception.raise_exception;
8041: END copy_agreement_taxes;
8042:
8035: END IF ;
8036: EXCEPTION
8037: WHEN OTHERS THEN
8038: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
8039: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
8040: app_exception.raise_exception;
8041: END copy_agreement_taxes;
8042:
8043: /*--------------------------------------------------------------------------------------------------------------------------
8585: END IF;
8586: EXCEPTION
8587: WHEN OTHERS THEN
8588: success:= null;
8589: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
8590: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
8591: app_exception.raise_exception;
8592: END Ja_In_Po_Case1;
8593:
8586: EXCEPTION
8587: WHEN OTHERS THEN
8588: success:= null;
8589: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
8590: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
8591: app_exception.raise_exception;
8592: END Ja_In_Po_Case1;
8593:
8594: -------------------------------------------------------------------------------------------------
8986: END IF;
8987:
8988: EXCEPTION
8989: WHEN OTHERS THEN
8990: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
8991: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
8992: app_exception.raise_exception;
8993: END Ja_In_Po_Case2;
8994:
8987:
8988: EXCEPTION
8989: WHEN OTHERS THEN
8990: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
8991: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
8992: app_exception.raise_exception;
8993: END Ja_In_Po_Case2;
8994:
8995: -------------------------------------------------------------------------------------------------
9088: );
9089:
9090: EXCEPTION
9091: WHEN OTHERS THEN
9092: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
9093: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
9094: app_exception.raise_exception;
9095:
9096: END Ja_In_Po_Insert;
9089:
9090: EXCEPTION
9091: WHEN OTHERS THEN
9092: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
9093: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
9094: app_exception.raise_exception;
9095:
9096: END Ja_In_Po_Insert;
9097: END jai_po_tax_pkg;