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_CSP_INV_LOC_ASS_ACC_PKG dependencies on FND_API

Line 370: x_return_status := FND_API.G_RET_STS_SUCCESS;

366: ( x_return_status OUT NOCOPY varchar2
367: )
368: IS
369: BEGIN
370: x_return_status := FND_API.G_RET_STS_SUCCESS;
371: END PRE_INSERT_INV_LOC_ASSIGNMENT;
372:
373: /*** Called after assignment Insert ***/
374: PROCEDURE POST_INSERT_INV_LOC_ASSIGNMENT

Line 389: x_return_status := FND_API.G_RET_STS_SUCCESS;

385: l_enabled_flag VARCHAR2(30);
386: BEGIN
387: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );
388: IF l_enabled_flag <> 'Y' THEN
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390: RETURN;
391: END IF;
392: /*** get debug level ***/
393: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 433: x_return_status := FND_API.G_RET_STS_SUCCESS;

429: , v_message => 'Leaving POST_INSERT hook'
430: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
431: END IF;
432:
433: x_return_status := FND_API.G_RET_STS_SUCCESS;
434: RETURN;
435:
436: EXCEPTION WHEN OTHERS THEN
437: /*** hook failed -> log error ***/

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

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

Line 447: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
450: /* Called before assignment Update */
451: PROCEDURE PRE_UPDATE_INV_LOC_ASSIGNMENT

Line 466: x_return_status := FND_API.G_RET_STS_SUCCESS;

462: l_enabled_flag VARCHAR2(30);
463: BEGIN
464: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );
465: IF l_enabled_flag <> 'Y' THEN
466: x_return_status := FND_API.G_RET_STS_SUCCESS;
467: RETURN;
468: END IF;
469: /*** get assignment record details from public API ***/
470: l_csp_inv_loc_assignment := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;

Line 497: x_return_status := FND_API.G_RET_STS_SUCCESS;

493: , v_message => 'Leaving PRE_UPDATE hook'
494: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
495: END IF;
496:
497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498:
499: EXCEPTION WHEN OTHERS THEN
500: /*** hook failed -> log error ***/
501: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

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

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

Line 510: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
513: /* Called after assignment Update */
514: PROCEDURE POST_UPDATE_INV_LOC_ASSIGNMENT

Line 542: x_return_status := FND_API.G_RET_STS_SUCCESS;

538: l_enabled_flag VARCHAR2(30);
539: BEGIN
540: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );
541: IF l_enabled_flag <> 'Y' THEN
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
543: RETURN;
544: END IF;
545: /*** get debug level ***/
546: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 647: x_return_status := FND_API.G_RET_STS_SUCCESS;

643: , v_message => 'Leaving POST_UPDATE hook'
644: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
645: END IF;
646:
647: x_return_status := FND_API.G_RET_STS_SUCCESS;
648: EXCEPTION WHEN OTHERS THEN
649: /*** hook failed -> log error ***/
650: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
651: jtm_message_log_pkg.Log_Msg

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

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

Line 659: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
662: /* Called before assignment Delete */
663: PROCEDURE PRE_DELETE_INV_LOC_ASSIGNMENT

Line 673: x_return_status := FND_API.G_RET_STS_SUCCESS;

669: l_enabled_flag VARCHAR2(30);
670: BEGIN
671: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );
672: IF l_enabled_flag <> 'Y' THEN
673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674: RETURN;
675: END IF;
676: /*** get assignment record details from public API ***/
677: l_csp_inv_loc_assignment := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;

Line 696: x_return_status := FND_API.G_RET_STS_SUCCESS;

692: Post_Delete_Child
693: ( l_csp_inv_loc_assignment
694: ,l_resource_id);
695:
696: x_return_status := FND_API.G_RET_STS_SUCCESS;
697:
698: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
699: jtm_message_log_pkg.Log_Msg
700: ( v_object_id => l_csp_inv_loc_assignment

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

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

Line 717: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
720: /* Called after assignment Delete */
721: PROCEDURE POST_DELETE_INV_LOC_ASSIGNMENT

Line 726: x_return_status := FND_API.G_RET_STS_SUCCESS;

722: ( x_return_status OUT NOCOPY varchar2
723: )
724: IS
725: BEGIN
726: x_return_status := FND_API.G_RET_STS_SUCCESS;
727: END POST_DELETE_INV_LOC_ASSIGNMENT;
728:
729: /* Remove all ACC records of a mobile user */
730: PROCEDURE Delete_All_ACC_Records

Line 742: -- l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_ERROR;

738: FROM jtm_csp_inv_loc_ass_acc
739: WHERE RESOURCE_ID = b_resource_id;
740: r_csp_inv_loc_assignment c_csp_inv_loc_assignment%ROWTYPE;
741:
742: -- l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_ERROR;
743: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;
744: l_dummy BOOLEAN;
745: BEGIN
746: g_debug_level := JTM_HOOK_UTIL_PKG.GET_DEBUG_LEVEL;

Line 743: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;

739: WHERE RESOURCE_ID = b_resource_id;
740: r_csp_inv_loc_assignment c_csp_inv_loc_assignment%ROWTYPE;
741:
742: -- l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_ERROR;
743: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;
744: l_dummy BOOLEAN;
745: BEGIN
746: g_debug_level := JTM_HOOK_UTIL_PKG.GET_DEBUG_LEVEL;
747: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 791: x_return_status := FND_API.G_RET_STS_SUCCESS;

787: , 'Leaving Delete_All_ACC_Records procedure for user: ' || p_resource_id
788: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
789: END IF;
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;

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

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:
799: /* Full synch for a mobile user */

Line 796: 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:
799: /* Full synch for a mobile user */
800: PROCEDURE Insert_All_ACC_Records

Line 814: -- l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_ERROR;

810: AND RESOURCE_TYPE = 'RS_EMPLOYEE' ;
811:
812: r_csp_inv_loc_assignment c_csp_inv_loc_assignment%ROWTYPE;
813:
814: -- l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_ERROR;
815: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;
816: l_dummy BOOLEAN;
817: BEGIN
818: g_debug_level := JTM_HOOK_UTIL_PKG.GET_DEBUG_LEVEL;

Line 815: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;

811:
812: r_csp_inv_loc_assignment c_csp_inv_loc_assignment%ROWTYPE;
813:
814: -- l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_ERROR;
815: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;
816: l_dummy BOOLEAN;
817: BEGIN
818: g_debug_level := JTM_HOOK_UTIL_PKG.GET_DEBUG_LEVEL;
819: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 858: l_return_value := FND_API.G_RET_STS_SUCCESS;

854: FETCH c_csp_inv_loc_assignment INTO r_csp_inv_loc_assignment;
855: END LOOP;
856: END IF;
857: CLOSE c_csp_inv_loc_assignment;
858: l_return_value := FND_API.G_RET_STS_SUCCESS;
859: ELSE
860: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
861: jtm_message_log_pkg.Log_Msg
862: ( v_object_id => p_resource_id

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

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:
877: END CSL_CSP_INV_LOC_ASS_ACC_PKG;

Line 874: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
877: END CSL_CSP_INV_LOC_ASS_ACC_PKG;