DBA Data[Home] [Help]

APPS.CSL_CSF_DEBRIEF_LINE_ACC_PKG dependencies on FND_API

Line 553: x_return_status := FND_API.G_RET_STS_SUCCESS;

549: ( x_return_status OUT NOCOPY varchar2
550: )
551: IS
552: BEGIN
553: x_return_status := FND_API.G_RET_STS_SUCCESS;
554: END PRE_INSERT_DEBRIEF_LINE;
555:
556: /* Called after debrief_line Insert */
557: PROCEDURE POST_INSERT_DEBRIEF_LINE

Line 568: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 614: x_return_status := FND_API.G_RET_STS_SUCCESS;

610: , 'Leaving POST_INSERT hook'
611: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
612: END IF;
613:
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615: RETURN;
616:
617: EXCEPTION WHEN OTHERS THEN
618: /*** hook failed -> log error ***/

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

623: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
624: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
625: END IF;
626: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','POST_INSERT_DEBRIEF_LINE',sqlerrm);
627: -- x_return_status := FND_API.G_RET_STS_ERROR;
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629: END POST_INSERT_DEBRIEF_LINE;
630:
631: /* Called before debrief_line Update */

Line 628: x_return_status := FND_API.G_RET_STS_SUCCESS;

624: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
625: END IF;
626: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','POST_INSERT_DEBRIEF_LINE',sqlerrm);
627: -- x_return_status := FND_API.G_RET_STS_ERROR;
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629: END POST_INSERT_DEBRIEF_LINE;
630:
631: /* Called before debrief_line Update */
632: PROCEDURE PRE_UPDATE_DEBRIEF_LINE

Line 642: x_return_status := FND_API.G_RET_STS_SUCCESS;

638: l_enabled_flag VARCHAR2(30);
639: BEGIN
640: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );
641: IF l_enabled_flag <> 'Y' THEN
642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643: RETURN;
644: END IF;
645: /*** get debug level ***/
646: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 690: x_return_status := FND_API.G_RET_STS_SUCCESS;

686: , 'Debrief line was not replicated before update'
687: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
688: END IF;
689:
690: x_return_status := FND_API.G_RET_STS_SUCCESS;
691:
692: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
693: jtm_message_log_pkg.Log_Msg
694: ( l_debrief_line_id

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

706: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
707: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
708: END IF;
709: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','PRE_UPDATE_DEBRIEF_LINE',sqlerrm);
710: -- x_return_status := FND_API.G_RET_STS_ERROR;
711: x_return_status := FND_API.G_RET_STS_SUCCESS;
712: g_pre_replicate := FALSE;
713: END PRE_UPDATE_DEBRIEF_LINE;
714:

Line 711: x_return_status := FND_API.G_RET_STS_SUCCESS;

707: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
708: END IF;
709: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','PRE_UPDATE_DEBRIEF_LINE',sqlerrm);
710: -- x_return_status := FND_API.G_RET_STS_ERROR;
711: x_return_status := FND_API.G_RET_STS_SUCCESS;
712: g_pre_replicate := FALSE;
713: END PRE_UPDATE_DEBRIEF_LINE;
714:
715: /* Called after debrief_line Update */

Line 733: x_return_status := FND_API.G_RET_STS_SUCCESS;

729: l_post_update_rec c_update_cache_rec%ROWTYPE;
730: BEGIN
731: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );
732: IF l_enabled_flag <> 'Y' THEN
733: x_return_status := FND_API.G_RET_STS_SUCCESS;
734: RETURN;
735: END IF;
736: /*** get debug level ***/
737: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 871: x_return_status := FND_API.G_RET_STS_SUCCESS;

867: , 'Leaving POST_UPDATE hook'
868: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
869: END IF;
870:
871: x_return_status := FND_API.G_RET_STS_SUCCESS;
872:
873: EXCEPTION WHEN OTHERS THEN
874: /*** hook failed -> log error ***/
875: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

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

879: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
880: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
881: END IF;
882: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','POST_UPDATE_DEBRIEF_LINE',sqlerrm);
883: -- x_return_status := FND_API.G_RET_STS_ERROR;
884: x_return_status := FND_API.G_RET_STS_SUCCESS;
885: END POST_UPDATE_DEBRIEF_LINE;
886:
887: /* Called before debrief_line Delete */

Line 884: x_return_status := FND_API.G_RET_STS_SUCCESS;

880: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
881: END IF;
882: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','POST_UPDATE_DEBRIEF_LINE',sqlerrm);
883: -- x_return_status := FND_API.G_RET_STS_ERROR;
884: x_return_status := FND_API.G_RET_STS_SUCCESS;
885: END POST_UPDATE_DEBRIEF_LINE;
886:
887: /* Called before debrief_line Delete */
888: PROCEDURE PRE_DELETE_DEBRIEF_LINE

Line 917: x_return_status := FND_API.G_RET_STS_SUCCESS;

913: /*** Delete debrief line from ACC table. This also deletes its Debrief Header ***/
914: Post_Delete_Child ( l_debrief_line_id
915: , l_resource_id );
916:
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918:
919: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
920: jtm_message_log_pkg.Log_Msg
921: ( v_object_id => l_debrief_line_id

Line 940: x_return_status := FND_API.G_RET_STS_SUCCESS;

936: END IF;
937:
938: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','PRE_DELETE_DEBRIEF_LINE',sqlerrm);
939:
940: x_return_status := FND_API.G_RET_STS_SUCCESS;
941: END PRE_DELETE_DEBRIEF_LINE;
942:
943: /* Called after debrief_line Delete */
944: PROCEDURE POST_DELETE_DEBRIEF_LINE

Line 949: x_return_status := FND_API.G_RET_STS_SUCCESS;

945: ( x_return_status OUT NOCOPY varchar2
946: )
947: IS
948: BEGIN
949: x_return_status := FND_API.G_RET_STS_SUCCESS;
950: END POST_DELETE_DEBRIEF_LINE;
951:
952: END CSL_CSF_DEBRIEF_LINE_ACC_PKG;