579: Fnd_File.PUT_LINE(Fnd_File.LOG, ' End of JA_IN_CESS_ENTRIES');
580:
581: EXCEPTION
582: WHEN OTHERS THEN
583: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
584: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
585: app_exception.raise_exception;
586: end;
587:
580:
581: EXCEPTION
582: WHEN OTHERS THEN
583: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
584: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
585: app_exception.raise_exception;
586: end;
587:
588: -- end additions by ssumaith - bug#3817625
664: );
665:
666: EXCEPTION
667: WHEN OTHERS THEN
668: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
669: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
670: app_exception.raise_exception;
671: end;
672:
665:
666: EXCEPTION
667: WHEN OTHERS THEN
668: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
669: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
670: app_exception.raise_exception;
671: end;
672:
673:
903: p_cess_amount := ln_Cess_amount;
904: EXCEPTION
905: WHEN OTHERS THEN
906: p_cess_amount:=null;
907: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
908: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
909: app_exception.raise_exception;
910: end ja_in_ar_cess_register_entries;
911:
904: EXCEPTION
905: WHEN OTHERS THEN
906: p_cess_amount:=null;
907: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
908: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
909: app_exception.raise_exception;
910: end ja_in_ar_cess_register_entries;
911:
912: /**********************************************************************************************************************/
1070:
1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: p_cess_amount := null;
1074: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
1075: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
1076: app_exception.raise_exception;
1077: end;
1078:
1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: p_cess_amount := null;
1074: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
1075: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
1076: app_exception.raise_exception;
1077: end;
1078:
1079: /**********************************************************************************************************************/
1731: <
1732: null;
1733: EXCEPTION
1734: WHEN OTHERS THEN
1735: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
1736: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
1737: app_exception.raise_exception;
1738: END ja_in_accounting_entries;
1739:
1732: null;
1733: EXCEPTION
1734: WHEN OTHERS THEN
1735: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
1736: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
1737: app_exception.raise_exception;
1738: END ja_in_accounting_entries;
1739:
1740: /************************************** END JA_IN_ACCOUNTING_ENTRIES **************************************************/
2398: p_source
2399: );
2400: EXCEPTION
2401: WHEN OTHERS THEN
2402: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2403: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2404: app_exception.raise_exception;
2405: END ja_in_rg_I_entry;
2406: /***************************** JA_IN_RG_I_ENTRY *******************************************************************/
2399: );
2400: EXCEPTION
2401: WHEN OTHERS THEN
2402: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2403: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2404: app_exception.raise_exception;
2405: END ja_in_rg_I_entry;
2406: /***************************** JA_IN_RG_I_ENTRY *******************************************************************/
2407:
2533: p_creation_date, p_created_by, p_last_update_login,
2534: p_last_update_date, p_last_updated_by );
2535: EXCEPTION
2536: WHEN OTHERS THEN
2537: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2538: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2539: app_exception.raise_exception;
2540: END ja_in_rg23_part_I_entry;
2541: /***************************** JA_IN_RG23_PART_I_ENTRY ****************************************************************/
2534: p_last_update_date, p_last_updated_by );
2535: EXCEPTION
2536: WHEN OTHERS THEN
2537: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2538: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
2539: app_exception.raise_exception;
2540: END ja_in_rg23_part_I_entry;
2541: /***************************** JA_IN_RG23_PART_I_ENTRY ****************************************************************/
2542:
3001: location_id = p_location_id;
3002: END IF;
3003: EXCEPTION
3004: WHEN OTHERS THEN
3005: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
3006: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
3007: app_exception.raise_exception;
3008: END ja_in_rg23_part_II_entry;
3009:
3002: END IF;
3003: EXCEPTION
3004: WHEN OTHERS THEN
3005: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
3006: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
3007: app_exception.raise_exception;
3008: END ja_in_rg23_part_II_entry;
3009:
3010: /***************************** JA_IN_RG23_PART_II_ENTRY ****************************************************************/
3689: where register_id = ln_register_id;
3690:
3691: EXCEPTION
3692: WHEN OTHERS THEN
3693: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
3694: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
3695: app_exception.raise_exception;
3696: END ja_in_pla_entry;
3697:
3690:
3691: EXCEPTION
3692: WHEN OTHERS THEN
3693: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
3694: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
3695: app_exception.raise_exception;
3696: END ja_in_pla_entry;
3697:
3698: /***************************** JA_IN_PLA_ENTRY ****************************************************************/
4289: */
4290:
4291: EXCEPTION
4292: WHEN OTHERS THEN
4293: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
4294: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
4295: app_exception.raise_exception;
4296:
4297: END Ja_In_Rg23d_Entry;
4290:
4291: EXCEPTION
4292: WHEN OTHERS THEN
4293: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
4294: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
4295: app_exception.raise_exception;
4296:
4297: END Ja_In_Rg23d_Entry;
4298:
4763: || TO_CHAR(p_transaction_amount));
4764: END IF;
4765: EXCEPTION
4766: WHEN OTHERS THEN
4767: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
4768: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
4769: app_exception.raise_exception;
4770: END ja_in_register_txn_entry;
4771: /***************************** JA_IN_REGISTER_TXN_ENTRY *************************************************************/
4764: END IF;
4765: EXCEPTION
4766: WHEN OTHERS THEN
4767: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
4768: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
4769: app_exception.raise_exception;
4770: END ja_in_register_txn_entry;
4771: /***************************** JA_IN_REGISTER_TXN_ENTRY *************************************************************/
4772: