DBA Data[Home] [Help]

APPS.CSL_JTF_RS_GRP_MEM_ACC_PKG dependencies on FND_API

Line 384: x_return_status := fnd_api.g_ret_sts_success;

380: , g_table_name
381: , 'Leaving POST_INSERT_RS_GROUP_MEMBER hook'
382: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
383: END IF;
384: x_return_status := fnd_api.g_ret_sts_success;
385:
386: EXCEPTION WHEN OTHERS THEN
387: /*** hook failed -> log error ***/
388: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 395: x_return_status := FND_API.G_RET_STS_SUCCESS;

391: , g_table_name
392: , 'Caught exception in POST_INSERT Procedure:' || fnd_global.local_chr(10) || sqlerrm
393: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
394: END IF;
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: END POST_INSERT_RS_GROUP_MEMBER;
398:
399: /* Called after Group member delete */

Line 449: x_return_status := FND_API.G_RET_STS_SUCCESS;

445: , 'Could not find group member for group_id = ' || p_group_id || ', resource_id = ' || p_resource_id
446: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
447: END IF;
448: CLOSE c_group_member;
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450: RETURN;
451: END IF;
452: CLOSE c_group_member;
453:

Line 548: x_return_status := FND_API.G_RET_STS_SUCCESS;

544: , 'Leaving PRE_DELETE_RS_GROUP_MEMBER hook'
545: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
546: END IF;
547:
548: x_return_status := FND_API.G_RET_STS_SUCCESS;
549:
550: EXCEPTION WHEN OTHERS THEN
551: /*** hook failed -> log error ***/
552: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 559: x_return_status := FND_API.G_RET_STS_SUCCESS;

555: , g_table_name
556: , 'Caught exception in PRE_DELETE Procedure:' || fnd_global.local_chr(10) || sqlerrm
557: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
558: END IF;
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: END PRE_DELETE_RS_GROUP_MEMBER;
562:
563: /* Remove all ACC records of a mobile user */

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

594: , g_table_name
595: , 'Resource is not a mobile field service/laptop resource'
596: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
597: END IF;
598: -- x_return_status := FND_API.G_RET_STS_ERROR;
599: x_return_status := FND_API.G_RET_STS_SUCCESS;
600: ELSE
601: FOR r_grp_mem_acc IN c_grp_mem_acc( p_resource_id )
602: LOOP

Line 599: x_return_status := FND_API.G_RET_STS_SUCCESS;

595: , 'Resource is not a mobile field service/laptop resource'
596: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
597: END IF;
598: -- x_return_status := FND_API.G_RET_STS_ERROR;
599: x_return_status := FND_API.G_RET_STS_SUCCESS;
600: ELSE
601: FOR r_grp_mem_acc IN c_grp_mem_acc( p_resource_id )
602: LOOP
603: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 617: x_return_status := FND_API.G_RET_STS_SUCCESS;

613: ,p_resource_id
614: );
615: END LOOP;
616:
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618: END IF;
619:
620: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
621: jtm_message_log_pkg.Log_Msg

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

635: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
636: END IF;
637:
638: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_RS_GRP_MEM_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
639: -- x_return_status := FND_API.G_RET_STS_ERROR;
640: x_return_status := FND_API.G_RET_STS_SUCCESS;
641: END Delete_All_ACC_Records;
642:
643: /* Full synch for a mobile user */

Line 640: x_return_status := FND_API.G_RET_STS_SUCCESS;

636: END IF;
637:
638: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_RS_GRP_MEM_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
639: -- x_return_status := FND_API.G_RET_STS_ERROR;
640: x_return_status := FND_API.G_RET_STS_SUCCESS;
641: END Delete_All_ACC_Records;
642:
643: /* Full synch for a mobile user */
644: PROCEDURE Insert_All_ACC_Records

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

676: , g_table_name
677: , 'Resource is not a mobile field service/laptop resource'
678: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
679: END IF;
680: -- x_return_status := FND_API.G_RET_STS_ERROR;
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: ELSE
683: /*** Yes -> insert all replicateable records ***/
684: FOR r_jtf_rs_group_members IN c_jtf_rs_group_members( p_resource_id )

Line 681: x_return_status := FND_API.G_RET_STS_SUCCESS;

677: , 'Resource is not a mobile field service/laptop resource'
678: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
679: END IF;
680: -- x_return_status := FND_API.G_RET_STS_ERROR;
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: ELSE
683: /*** Yes -> insert all replicateable records ***/
684: FOR r_jtf_rs_group_members IN c_jtf_rs_group_members( p_resource_id )
685: LOOP

Line 699: x_return_status := FND_API.G_RET_STS_SUCCESS;

695: ( r_jtf_rs_group_members.group_member_id
696: , p_resource_id
697: );
698: END LOOP;
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700: END IF;
701:
702: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
703: jtm_message_log_pkg.Log_Msg

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

717: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
718: END IF;
719:
720: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_RS_GRP_MEM_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
721: -- x_return_status := FND_API.G_RET_STS_ERROR;
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723: END Insert_All_ACC_Records;
724:
725: END CSL_JTF_RS_GRP_MEM_ACC_PKG;

Line 722: x_return_status := FND_API.G_RET_STS_SUCCESS;

718: END IF;
719:
720: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_RS_GRP_MEM_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
721: -- x_return_status := FND_API.G_RET_STS_ERROR;
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723: END Insert_All_ACC_Records;
724:
725: END CSL_JTF_RS_GRP_MEM_ACC_PKG;