APPS.CSL_JTF_TASK_ASS_ACC_PKG dependencies on CSL_JTF_TASK_ASS_ACC_PKG

Line 1: PACKAGE BODY CSL_JTF_TASK_ASS_ACC_PKG AS

1: PACKAGE BODY CSL_JTF_TASK_ASS_ACC_PKG AS
2: /* $Header: csltaacb.pls 120.0 2005/05/24 18:02:19 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_JTF_TASK_ASS_ACC';

Line 565: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASK_ASS_ACC_PKG','POST_INSERT_TASK_ASSIGNMENT',sqlerrm);

561: , g_table_name
562: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
563: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
564: END IF;
565: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASK_ASS_ACC_PKG','POST_INSERT_TASK_ASSIGNMENT',sqlerrm);
566: -- x_return_status := FND_API.G_RET_STS_ERROR;
567: x_return_status := FND_API.G_RET_STS_SUCCESS;
568: END POST_INSERT_TASK_ASSIGNMENT;
569:

Line 628: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASK_ASS_ACC_PKG','PRE_UPDATE_TASK_ASSIGNMENT',sqlerrm);

624: , g_table_name
625: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
626: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
627: END IF;
628: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASK_ASS_ACC_PKG','PRE_UPDATE_TASK_ASSIGNMENT',sqlerrm);
629: -- x_return_status := FND_API.G_RET_STS_ERROR;
630: x_return_status := FND_API.G_RET_STS_SUCCESS;
631: END PRE_UPDATE_TASK_ASSIGNMENT;
632:

Line 744: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASK_ASS_ACC_PKG','POST_UPDATE_TASK_ASSIGNMENT',sqlerrm);

740: , g_table_name
741: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
742: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
743: END IF;
744: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASK_ASS_ACC_PKG','POST_UPDATE_TASK_ASSIGNMENT',sqlerrm);
745: -- x_return_status := FND_API.G_RET_STS_ERROR;
746: x_return_status := FND_API.G_RET_STS_SUCCESS;
747: END POST_UPDATE_TASK_ASSIGNMENT;
748:

Line 802: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASK_ASS_ACC_PKG','PRE_DELETE_TASK_ASSIGNMENT',sqlerrm);

798: , g_table_name
799: , 'Caught exception in PRE_DELETE hook:' || fnd_global.local_chr(10) || sqlerrm
800: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
801: END IF;
802: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASK_ASS_ACC_PKG','PRE_DELETE_TASK_ASSIGNMENT',sqlerrm);
803: -- x_return_status := FND_API.G_RET_STS_ERROR;
804: x_return_status := FND_API.G_RET_STS_SUCCESS;
805: END PRE_DELETE_TASK_ASSIGNMENT;
806:

Line 861: p_message := 'CSL_JTF_TASK_ASS_ACC_PKG.PURGE_TASK_ASSIGNMENTS Completed successfully';

857:
858: CSL_JTF_TASKS_ACC_PKG.Purge_Tasks;
859:
860: p_status := 'FINE';
861: p_message := 'CSL_JTF_TASK_ASS_ACC_PKG.PURGE_TASK_ASSIGNMENTS Completed successfully';
862:
863: EXCEPTION
864:
865: WHEN OTHERS THEN

Line 869: p_message := 'Error in CSL_JTF_TASK_ASS_ACC_PKG.PURGE_TASK_ASSIGNMENTS: ' || substr(SQLERRM, 1, 2000);

865: WHEN OTHERS THEN
866:
867: ROLLBACK;
868: p_status := 'ERROR';
869: p_message := 'Error in CSL_JTF_TASK_ASS_ACC_PKG.PURGE_TASK_ASSIGNMENTS: ' || substr(SQLERRM, 1, 2000);
870:
871: jtm_message_log_pkg.Log_Msg
872: (rcur_purge_task_assignments.task_assignment_id,
873: 'CSL_JTF_TASK_ASS_ACC',

Line 879: END CSL_JTF_TASK_ASS_ACC_PKG;

875: JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
876:
877: END PURGE_TASK_ASSIGNMENTS;
878:
879: END CSL_JTF_TASK_ASS_ACC_PKG;