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
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;
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 ***/
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 */
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
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;
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
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:
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 */
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;
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
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 */
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
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
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
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;