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

Line 496: x_return_status := FND_API.G_RET_STS_SUCCESS;

492: ( x_return_status OUT NOCOPY varchar2
493: )
494: IS
495: BEGIN
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497: END PRE_INSERT_SHIP_LOCATION;
498:
499: /*** Called after location Insert ***/
500: PROCEDURE POST_INSERT_SHIP_LOCATION

Line 509: x_return_status := FND_API.G_RET_STS_SUCCESS;

505: l_enabled_flag VARCHAR2(30);
506: BEGIN
507: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL');
508: IF l_enabled_flag <>'Y' THEN
509: x_return_status := FND_API.G_RET_STS_SUCCESS;
510: RETURN;
511: END IF;
512: /*** get location record details from public API ***/
513: l_location_id := csp_ship_to_address_pvt.g_inv_loc_id;

Line 538: x_return_status := FND_API.G_RET_STS_SUCCESS;

534: , 'Leaving POST_INSERT hook'
535: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
536: END IF;
537:
538: x_return_status := FND_API.G_RET_STS_SUCCESS;
539: RETURN;
540:
541: EXCEPTION WHEN OTHERS THEN
542: /*** hook failed -> log error ***/

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

547: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
548: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
549: END IF;
550: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','POST_INSERT_SHIP_LOCATION',sqlerrm);
551: -- x_return_status := FND_API.G_RET_STS_ERROR;
552: x_return_status := FND_API.G_RET_STS_SUCCESS;
553: END POST_INSERT_SHIP_LOCATION;
554:
555: /* Called before location Update */

Line 552: x_return_status := FND_API.G_RET_STS_SUCCESS;

548: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
549: END IF;
550: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','POST_INSERT_SHIP_LOCATION',sqlerrm);
551: -- x_return_status := FND_API.G_RET_STS_ERROR;
552: x_return_status := FND_API.G_RET_STS_SUCCESS;
553: END POST_INSERT_SHIP_LOCATION;
554:
555: /* Called before location Update */
556: PROCEDURE PRE_UPDATE_SHIP_LOCATION

Line 561: x_return_status := FND_API.G_RET_STS_SUCCESS;

557: ( x_return_status OUT NOCOPY varchar2
558: )
559: IS
560: BEGIN
561: x_return_status := FND_API.G_RET_STS_SUCCESS;
562:
563: EXCEPTION WHEN OTHERS THEN
564: /*** hook failed -> log error ***/
565: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','PRE_UPDATE_SHIP_LOCATION',sqlerrm);

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

562:
563: EXCEPTION WHEN OTHERS THEN
564: /*** hook failed -> log error ***/
565: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','PRE_UPDATE_SHIP_LOCATION',sqlerrm);
566: -- x_return_status := FND_API.G_RET_STS_ERROR;
567: x_return_status := FND_API.G_RET_STS_SUCCESS;
568: END PRE_UPDATE_SHIP_LOCATION;
569:
570: /* Called after assignment Update */

Line 567: x_return_status := FND_API.G_RET_STS_SUCCESS;

563: EXCEPTION WHEN OTHERS THEN
564: /*** hook failed -> log error ***/
565: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','PRE_UPDATE_SHIP_LOCATION',sqlerrm);
566: -- x_return_status := FND_API.G_RET_STS_ERROR;
567: x_return_status := FND_API.G_RET_STS_SUCCESS;
568: END PRE_UPDATE_SHIP_LOCATION;
569:
570: /* Called after assignment Update */
571: PROCEDURE POST_UPDATE_SHIP_LOCATION

Line 580: x_return_status := FND_API.G_RET_STS_SUCCESS;

576: l_enabled_flag VARCHAR2(30);
577: BEGIN
578: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL');
579: IF l_enabled_flag <>'Y' THEN
580: x_return_status := FND_API.G_RET_STS_SUCCESS;
581: RETURN;
582: END IF;
583: /*** get assignment record details from public API ***/
584: l_location_id := csp_ship_to_address_pvt.g_inv_loc_id;

Line 609: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

616: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
617: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
618: END IF;
619: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_SHIP_LOCATION',sqlerrm);
620: -- x_return_status := FND_API.G_RET_STS_ERROR;
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622: END POST_UPDATE_SHIP_LOCATION;
623:
624: /* Called before assignment Delete */

Line 621: x_return_status := FND_API.G_RET_STS_SUCCESS;

617: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
618: END IF;
619: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_SHIP_LOCATION',sqlerrm);
620: -- x_return_status := FND_API.G_RET_STS_ERROR;
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622: END POST_UPDATE_SHIP_LOCATION;
623:
624: /* Called before assignment Delete */
625: PROCEDURE PRE_DELETE_SHIP_LOCATION

Line 630: x_return_status := FND_API.G_RET_STS_SUCCESS;

626: ( x_return_status OUT NOCOPY varchar2
627: )
628: IS
629: BEGIN
630: x_return_status := FND_API.G_RET_STS_SUCCESS;
631: END PRE_DELETE_SHIP_LOCATION;
632:
633: /* Called after assignment Delete */
634: PROCEDURE POST_DELETE_SHIP_LOCATION

Line 640: x_return_status := FND_API.G_RET_STS_SUCCESS;

636: )
637: IS
638: BEGIN
639:
640: x_return_status := FND_API.G_RET_STS_SUCCESS;
641:
642: EXCEPTION WHEN OTHERS THEN
643: /*** hook failed -> log error ***/
644: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','POST_DELETE_SHIP_LOCATION',sqlerrm);

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

641:
642: EXCEPTION WHEN OTHERS THEN
643: /*** hook failed -> log error ***/
644: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','POST_DELETE_SHIP_LOCATION',sqlerrm);
645: -- x_return_status := FND_API.G_RET_STS_ERROR;
646: x_return_status := FND_API.G_RET_STS_SUCCESS;
647: END POST_DELETE_SHIP_LOCATION;
648:
649: /* Remove all ACC resords of a mobile user */

Line 646: x_return_status := FND_API.G_RET_STS_SUCCESS;

642: EXCEPTION WHEN OTHERS THEN
643: /*** hook failed -> log error ***/
644: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','POST_DELETE_SHIP_LOCATION',sqlerrm);
645: -- x_return_status := FND_API.G_RET_STS_ERROR;
646: x_return_status := FND_API.G_RET_STS_SUCCESS;
647: END POST_DELETE_SHIP_LOCATION;
648:
649: /* Remove all ACC resords of a mobile user */
650: PROCEDURE Delete_All_ACC_Records

Line 691: x_return_status := FND_API.G_RET_STS_SUCCESS;

687: , 'Leaving Delete_All_ACC_Records procedure for user: ' || p_resource_id
688: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
689: END IF;
690:
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692: EXCEPTION WHEN OTHERS THEN
693: /*** hook failed -> log error ***/
694: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
695: -- x_return_status := FND_API.G_RET_STS_ERROR;

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

691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692: EXCEPTION WHEN OTHERS THEN
693: /*** hook failed -> log error ***/
694: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
695: -- x_return_status := FND_API.G_RET_STS_ERROR;
696: x_return_status := FND_API.G_RET_STS_SUCCESS;
697: END Delete_All_ACC_Records;
698:
699: /* Full synch for a mobile user */

Line 696: x_return_status := FND_API.G_RET_STS_SUCCESS;

692: EXCEPTION WHEN OTHERS THEN
693: /*** hook failed -> log error ***/
694: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
695: -- x_return_status := FND_API.G_RET_STS_ERROR;
696: x_return_status := FND_API.G_RET_STS_SUCCESS;
697: END Delete_All_ACC_Records;
698:
699: /* Full synch for a mobile user */
700: PROCEDURE Insert_All_ACC_Records

Line 744: x_return_status := FND_API.G_RET_STS_SUCCESS;

740: , 'Leaving Insert_All_ACC_Records procedure for user: ' || p_resource_id
741: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
742: END IF;
743:
744: x_return_status := FND_API.G_RET_STS_SUCCESS;
745: EXCEPTION WHEN OTHERS THEN
746: /*** hook failed -> log error ***/
747: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
748: -- x_return_status := FND_API.G_RET_STS_ERROR;

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

744: x_return_status := FND_API.G_RET_STS_SUCCESS;
745: EXCEPTION WHEN OTHERS THEN
746: /*** hook failed -> log error ***/
747: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
748: -- x_return_status := FND_API.G_RET_STS_ERROR;
749: x_return_status := FND_API.G_RET_STS_SUCCESS;
750: END Insert_All_ACC_Records;
751:
752: END CSL_CSP_LOCATIONS_ACC_PKG;

Line 749: x_return_status := FND_API.G_RET_STS_SUCCESS;

745: EXCEPTION WHEN OTHERS THEN
746: /*** hook failed -> log error ***/
747: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_LOCATIONS_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
748: -- x_return_status := FND_API.G_RET_STS_ERROR;
749: x_return_status := FND_API.G_RET_STS_SUCCESS;
750: END Insert_All_ACC_Records;
751:
752: END CSL_CSP_LOCATIONS_ACC_PKG;