441: , v_object_name => g_table_name
442: , v_message => 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
443: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
444: END IF;
445: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_INV_LOC_ASS_ACC_PKG','POST_INSERT_INV_LOC_ASSIGNMENT',sqlerrm);
446: -- x_return_status := FND_API.G_RET_STS_ERROR;
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448: END POST_INSERT_INV_LOC_ASSIGNMENT;
449:
504: , v_object_name => g_table_name
505: , v_message => 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
506: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
507: END IF;
508: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_INV_LOC_ASS_ACC_PKG','PRE_UPDATE_INV_LOC_ASSIGNMENT',sqlerrm);
509: -- x_return_status := FND_API.G_RET_STS_ERROR;
510: x_return_status := FND_API.G_RET_STS_SUCCESS;
511: END PRE_UPDATE_INV_LOC_ASSIGNMENT;
512:
653: , v_object_name => g_table_name
654: , v_message => 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
655: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
656: END IF;
657: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_INV_LOC_ASS_ACC_PKG','POST_UPDATE_INV_LOC_ASSIGNMENT',sqlerrm);
658: -- x_return_status := FND_API.G_RET_STS_ERROR;
659: x_return_status := FND_API.G_RET_STS_SUCCESS;
660: END POST_UPDATE_INV_LOC_ASSIGNMENT;
661:
711: , v_object_name => g_table_name
712: , v_message => 'Caught exception in PRE_DELETE hook:' || fnd_global.local_chr(10) || sqlerrm
713: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
714: END IF;
715: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_INV_LOC_ASS_ACC_PKG','PRE_DELETE_INV_LOC_ASSIGNMENT',sqlerrm);
716: -- x_return_status := FND_API.G_RET_STS_ERROR;
717: x_return_status := FND_API.G_RET_STS_SUCCESS;
718: END PRE_DELETE_INV_LOC_ASSIGNMENT;
719:
790:
791: x_return_status := FND_API.G_RET_STS_SUCCESS;
792: EXCEPTION WHEN OTHERS THEN
793: /*** hook failed -> log error ***/
794: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
795: -- x_return_status := FND_API.G_RET_STS_ERROR;
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797: END Delete_All_ACC_Records;
798:
868:
869: x_return_status := l_return_value;
870: EXCEPTION WHEN OTHERS THEN
871: /*** hook failed -> log error ***/
872: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
873: -- x_return_status := FND_API.G_RET_STS_ERROR;
874: x_return_status := FND_API.G_RET_STS_SUCCESS;
875: END Insert_All_ACC_Records;
876: