DBA Data[Home] [Help]

APPS.CSL_JTF_TASKS_ACC_PKG dependencies on FND_API

Line 549: x_return_status := FND_API.G_RET_STS_SUCCESS;

545: ( x_return_status OUT NOCOPY varchar2
546: )
547: IS
548: BEGIN
549: x_return_status := FND_API.G_RET_STS_SUCCESS;
550: END PRE_INSERT_TASK;
551:
552: /* Called after task Insert */
553: PROCEDURE POST_INSERT_TASK

Line 570: x_return_status := FND_API.G_RET_STS_SUCCESS;

566: l_enabled_flag VARCHAR2(30);
567: BEGIN
568: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );
569: IF l_enabled_flag <> 'Y' THEN
570: x_return_status := FND_API.G_RET_STS_SUCCESS;
571: RETURN;
572: END IF;
573: /*** get debug level ***/
574: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 607: x_return_status := FND_API.G_RET_STS_SUCCESS;

603: , 'Leaving POST_INSERT_TASK hook'
604: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
605: END IF;
606:
607: x_return_status := FND_API.G_RET_STS_SUCCESS;
608: EXCEPTION WHEN OTHERS THEN
609: /*** hook failed -> log error ***/
610: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
611: jtm_message_log_pkg.Log_Msg

Line 618: -- x_return_status := FND_API.G_RET_STS_ERROR;

614: , 'Caught exception in POST_INSERT_TASK hook:' || fnd_global.local_chr(10) || sqlerrm
615: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
616: END IF;
617: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_INSERT_TASK',sqlerrm);
618: -- x_return_status := FND_API.G_RET_STS_ERROR;
619: x_return_status := FND_API.G_RET_STS_SUCCESS;
620: END POST_INSERT_TASK;
621:
622: /* Called before task Update */

Line 619: x_return_status := FND_API.G_RET_STS_SUCCESS;

615: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
616: END IF;
617: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_INSERT_TASK',sqlerrm);
618: -- x_return_status := FND_API.G_RET_STS_ERROR;
619: x_return_status := FND_API.G_RET_STS_SUCCESS;
620: END POST_INSERT_TASK;
621:
622: /* Called before task Update */
623: PROCEDURE PRE_UPDATE_TASK

Line 636: x_return_status := FND_API.G_RET_STS_SUCCESS;

632: WHERE TASK_ID = b_task_id;
633: BEGIN
634: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL');
635: IF l_enabled_flag <> 'Y' THEN
636: x_return_status := FND_API.G_RET_STS_SUCCESS;
637: RETURN;
638: END IF;
639: /*** get task record details from public API ***/
640: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;

Line 660: x_return_status := FND_API.G_RET_STS_SUCCESS;

656: OPEN c_task_address( l_task_id );
657: FETCH c_task_address INTO g_cached_task_address_id;
658: CLOSE c_task_address;
659:
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
663: jtm_message_log_pkg.Log_Msg
664: ( l_task_id

Line 680: -- x_return_status := FND_API.G_RET_STS_ERROR;

676: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
677: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
678: END IF;
679: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_TASK',sqlerrm);
680: -- x_return_status := FND_API.G_RET_STS_ERROR;
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: END PRE_UPDATE_TASK;
683:
684: /* Called after task Update */

Line 681: x_return_status := FND_API.G_RET_STS_SUCCESS;

677: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
678: END IF;
679: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_TASK',sqlerrm);
680: -- x_return_status := FND_API.G_RET_STS_ERROR;
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: END PRE_UPDATE_TASK;
683:
684: /* Called after task Update */
685: PROCEDURE POST_UPDATE_TASK

Line 713: x_return_status := FND_API.G_RET_STS_SUCCESS;

709: l_enabled_flag VARCHAR2(30);
710: BEGIN
711: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL');
712: IF l_enabled_flag <> 'Y' THEN
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714: RETURN;
715: END IF;
716: /*** get task record details from public API ***/
717: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;

Line 848: x_return_status := FND_API.G_RET_STS_SUCCESS;

844: END LOOP;
845: END IF;
846: END IF;
847:
848: x_return_status := FND_API.G_RET_STS_SUCCESS;
849:
850: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
851: jtm_message_log_pkg.Log_Msg
852: ( l_task_id

Line 868: -- x_return_status := FND_API.G_RET_STS_ERROR;

864: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
865: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
866: END IF;
867: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_TASK',sqlerrm);
868: -- x_return_status := FND_API.G_RET_STS_ERROR;
869: x_return_status := FND_API.G_RET_STS_SUCCESS;
870: END POST_UPDATE_TASK;
871:
872: /* Called before task Delete */

Line 869: x_return_status := FND_API.G_RET_STS_SUCCESS;

865: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
866: END IF;
867: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_TASK',sqlerrm);
868: -- x_return_status := FND_API.G_RET_STS_ERROR;
869: x_return_status := FND_API.G_RET_STS_SUCCESS;
870: END POST_UPDATE_TASK;
871:
872: /* Called before task Delete */
873: PROCEDURE PRE_DELETE_TASK

Line 878: x_return_status := FND_API.G_RET_STS_SUCCESS;

874: ( x_return_status OUT NOCOPY varchar2
875: )
876: IS
877: BEGIN
878: x_return_status := FND_API.G_RET_STS_SUCCESS;
879: END PRE_DELETE_TASK;
880:
881: /* Called after task Delete */
882: PROCEDURE POST_DELETE_TASK

Line 887: x_return_status := FND_API.G_RET_STS_SUCCESS;

883: ( x_return_status OUT NOCOPY varchar2
884: )
885: IS
886: BEGIN
887: x_return_status := FND_API.G_RET_STS_SUCCESS;
888: END POST_DELETE_TASK;
889:
890: PROCEDURE INSERT_ALL_ACC_RECORDS
891: ( p_resource_id IN NUMBER

Line 928: x_return_status := FND_API.G_RET_STS_SUCCESS;

924: , 'Leaving POST_INSERT hook'
925: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
926: END IF;
927:
928: x_return_status := FND_API.G_RET_STS_SUCCESS;
929:
930: EXCEPTION
931: WHEN OTHERS THEN
932: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 939: x_return_status := FND_API.G_RET_STS_ERROR;

935: , g_table_name
936: , 'Caught exception in INSERT_ALL_ACC_RECORDS:' || fnd_global.local_chr(10) || sqlerrm
937: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
938: END IF;
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: END INSERT_ALL_ACC_RECORDS;
941:
942: /***Purge logic for Expired/Closed Personal Task***/
943: --Bug 3475657