eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_JTF_TASK_ASS_ACC_PKG dependencies on FND_API

Line 472: x_return_status := FND_API.G_RET_STS_SUCCESS;

468: l_return_status := Pre_Insert_Child
469: ( r_task_assignment.task_assignment_id
470: ,p_resource_id);
471: END LOOP;
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473: EXCEPTION
474: WHEN OTHERS THEN
475: -- x_return_status := FND_API.G_RET_STS_ERROR;
476: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

471: END LOOP;
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473: EXCEPTION
474: WHEN OTHERS THEN
475: -- x_return_status := FND_API.G_RET_STS_ERROR;
476: x_return_status := FND_API.G_RET_STS_SUCCESS;
477: END INSERT_ALL_ACC_RECORDS;
478:
479: /* Called during deletion of a user */

Line 476: x_return_status := FND_API.G_RET_STS_SUCCESS;

472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473: EXCEPTION
474: WHEN OTHERS THEN
475: -- x_return_status := FND_API.G_RET_STS_ERROR;
476: x_return_status := FND_API.G_RET_STS_SUCCESS;
477: END INSERT_ALL_ACC_RECORDS;
478:
479: /* Called during deletion of a user */
480: PROCEDURE DELETE_ALL_ACC_RECORDS( p_resource_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2 ) IS

Line 492: x_return_status := FND_API.G_RET_STS_SUCCESS;

488: Post_Delete_Child
489: ( r_task_assignment.task_assignment_id
490: ,p_resource_id);
491: END LOOP;
492: x_return_status := FND_API.G_RET_STS_SUCCESS;
493: EXCEPTION
494: WHEN OTHERS THEN
495: -- x_return_status := FND_API.G_RET_STS_ERROR;
496: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

491: END LOOP;
492: x_return_status := FND_API.G_RET_STS_SUCCESS;
493: EXCEPTION
494: WHEN OTHERS THEN
495: -- x_return_status := FND_API.G_RET_STS_ERROR;
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497: END DELETE_ALL_ACC_RECORDS;
498:
499:

Line 496: x_return_status := FND_API.G_RET_STS_SUCCESS;

492: x_return_status := FND_API.G_RET_STS_SUCCESS;
493: EXCEPTION
494: WHEN OTHERS THEN
495: -- x_return_status := FND_API.G_RET_STS_ERROR;
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497: END DELETE_ALL_ACC_RECORDS;
498:
499:
500: /*** Called before assignment Insert ***/

Line 506: x_return_status := FND_API.G_RET_STS_SUCCESS;

502: ( x_return_status OUT NOCOPY varchar2
503: )
504: IS
505: BEGIN
506: x_return_status := FND_API.G_RET_STS_SUCCESS;
507: END PRE_INSERT_TASK_ASSIGNMENT;
508:
509: /*** Called after assignment Insert ***/
510: PROCEDURE POST_INSERT_TASK_ASSIGNMENT

Line 521: x_return_status := FND_API.G_RET_STS_SUCCESS;

517: l_enabled_flag VARCHAR2(30);
518: BEGIN
519: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP(P_APP_SHORT_NAME => 'CSL' );
520: IF l_enabled_flag <> 'Y' THEN
521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522: RETURN;
523: END IF;
524: /*** get assignment record details from public API ***/
525: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

Line 553: x_return_status := FND_API.G_RET_STS_SUCCESS;

549: , 'Leaving POST_INSERT hook'
550: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
551: END IF;
552:
553: x_return_status := FND_API.G_RET_STS_SUCCESS;
554: RETURN;
555:
556: EXCEPTION WHEN OTHERS THEN
557: /*** hook failed -> log error ***/

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

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:
570: /* Called before assignment Update */

Line 567: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
570: /* Called before assignment Update */
571: PROCEDURE PRE_UPDATE_TASK_ASSIGNMENT

Line 586: x_return_status := FND_API.G_RET_STS_SUCCESS;

582: l_enabled_flag VARCHAR2(30);
583: BEGIN
584: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP(P_APP_SHORT_NAME => 'CSL' );
585: IF l_enabled_flag <> 'Y' THEN
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587: RETURN;
588: END IF;
589: /*** get assignment record details from public API ***/
590: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

Line 617: x_return_status := FND_API.G_RET_STS_SUCCESS;

613: , 'Leaving PRE_UPDATE hook'
614: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
615: END IF;
616:
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618:
619: EXCEPTION WHEN OTHERS THEN
620: /*** hook failed -> log error ***/
621: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

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

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:
633: /* Called after assignment Update */

Line 630: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
633: /* Called after assignment Update */
634: PROCEDURE POST_UPDATE_TASK_ASSIGNMENT

Line 647: x_return_status := FND_API.G_RET_STS_SUCCESS;

643: l_enabled_flag VARCHAR2(30);
644: BEGIN
645: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP(P_APP_SHORT_NAME => 'CSL' );
646: IF l_enabled_flag <> 'Y' THEN
647: x_return_status := FND_API.G_RET_STS_SUCCESS;
648: RETURN;
649: END IF;
650: /*** get assignment record details from public API ***/
651: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

Line 734: x_return_status := FND_API.G_RET_STS_SUCCESS;

730: , 'Leaving POST_UPDATE hook'
731: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
732: END IF;
733:
734: x_return_status := FND_API.G_RET_STS_SUCCESS;
735: EXCEPTION WHEN OTHERS THEN
736: /*** hook failed -> log error ***/
737: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
738: jtm_message_log_pkg.Log_Msg

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

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:
749: /* Called before assignment Delete */

Line 746: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
749: /* Called before assignment Delete */
750: PROCEDURE PRE_DELETE_TASK_ASSIGNMENT

Line 760: x_return_status := FND_API.G_RET_STS_SUCCESS;

756: l_enabled_flag VARCHAR2(30);
757: BEGIN
758: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP(P_APP_SHORT_NAME => 'CSL' );
759: IF l_enabled_flag <> 'Y' THEN
760: x_return_status := FND_API.G_RET_STS_SUCCESS;
761: RETURN;
762: END IF;
763: /*** get assignment record details from public API ***/
764: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

Line 783: x_return_status := FND_API.G_RET_STS_SUCCESS;

779: Post_Delete_Child
780: ( l_task_assignment_id
781: ,l_resource_id);
782:
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784:
785: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
786: jtm_message_log_pkg.Log_Msg
787: ( l_task_assignment_id

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

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:
807: /* Called after assignment Delete */

Line 804: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
807: /* Called after assignment Delete */
808: PROCEDURE POST_DELETE_TASK_ASSIGNMENT

Line 813: x_return_status := FND_API.G_RET_STS_SUCCESS;

809: ( x_return_status OUT NOCOPY varchar2
810: )
811: IS
812: BEGIN
813: x_return_status := FND_API.G_RET_STS_SUCCESS;
814: END POST_DELETE_TASK_ASSIGNMENT;
815:
816:
817: /***Purge logic for Expired/Completed Task Assignments***/