DBA Data[Home] [Help]

APPS.CSL_CSP_REQ_LINES_ACC_PKG dependencies on FND_API

Line 501: x_return_status := FND_API.G_RET_STS_SUCCESS;

497: ( x_return_status OUT NOCOPY varchar2
498: )
499: IS
500: BEGIN
501: x_return_status := FND_API.G_RET_STS_SUCCESS;
502: END PRE_INSERT_REQ_LINE;
503:
504: /*** Called after requirement Insert ***/
505: PROCEDURE POST_INSERT_REQ_LINE

Line 514: x_return_status := FND_API.G_RET_STS_SUCCESS;

510: l_enabled_flag VARCHAR2(30);
511: BEGIN
512: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL');
513: IF l_enabled_flag <> 'Y' THEN
514: x_return_status := FND_API.G_RET_STS_SUCCESS;
515: RETURN;
516: END IF;
517: /*** get debug level ***/
518: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 543: x_return_status := FND_API.G_RET_STS_SUCCESS;

539: , 'Leaving POST_INSERT hook'
540: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
541: END IF;
542:
543: x_return_status := FND_API.G_RET_STS_SUCCESS;
544: RETURN;
545:
546: EXCEPTION WHEN OTHERS THEN
547: /*** hook failed -> log error ***/

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

552: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
553: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
554: END IF;
555: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','POST_INSERT_REQ_LINE',sqlerrm);
556: -- x_return_status := FND_API.G_RET_STS_ERROR;
557: x_return_status := FND_API.G_RET_STS_SUCCESS;
558: END POST_INSERT_REQ_LINE;
559:
560: /* Called before requirement Update */

Line 557: x_return_status := FND_API.G_RET_STS_SUCCESS;

553: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
554: END IF;
555: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','POST_INSERT_REQ_LINE',sqlerrm);
556: -- x_return_status := FND_API.G_RET_STS_ERROR;
557: x_return_status := FND_API.G_RET_STS_SUCCESS;
558: END POST_INSERT_REQ_LINE;
559:
560: /* Called before requirement Update */
561: PROCEDURE PRE_UPDATE_REQ_LINE

Line 566: x_return_status := FND_API.G_RET_STS_SUCCESS;

562: ( x_return_status OUT NOCOPY varchar2
563: )
564: IS
565: BEGIN
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567:
568: EXCEPTION WHEN OTHERS THEN
569: /*** hook failed -> log error ***/
570: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','PRE_UPDATE_REQ_LINE',sqlerrm);

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

567:
568: EXCEPTION WHEN OTHERS THEN
569: /*** hook failed -> log error ***/
570: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','PRE_UPDATE_REQ_LINE',sqlerrm);
571: -- x_return_status := FND_API.G_RET_STS_ERROR;
572: x_return_status := FND_API.G_RET_STS_SUCCESS;
573: END PRE_UPDATE_REQ_LINE;
574:
575: /* Called after requirement Update */

Line 572: x_return_status := FND_API.G_RET_STS_SUCCESS;

568: EXCEPTION WHEN OTHERS THEN
569: /*** hook failed -> log error ***/
570: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','PRE_UPDATE_REQ_LINE',sqlerrm);
571: -- x_return_status := FND_API.G_RET_STS_ERROR;
572: x_return_status := FND_API.G_RET_STS_SUCCESS;
573: END PRE_UPDATE_REQ_LINE;
574:
575: /* Called after requirement Update */
576: PROCEDURE POST_UPDATE_REQ_LINE

Line 585: x_return_status := FND_API.G_RET_STS_SUCCESS;

581: l_enabled_flag VARCHAR2(30);
582: BEGIN
583: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL');
584: IF l_enabled_flag <> 'Y' THEN
585: x_return_status := FND_API.G_RET_STS_SUCCESS;
586: RETURN;
587: END IF;
588: /*** get debug level ***/
589: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 614: x_return_status := FND_API.G_RET_STS_SUCCESS;

610: , 'Leaving POST_UPDATE 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: EXCEPTION WHEN OTHERS THEN
616: /*** hook failed -> log error ***/
617: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
618: jtm_message_log_pkg.Log_Msg

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

621: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
622: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
623: END IF;
624: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','POST_UPDATE_REQ_LINE',sqlerrm);
625: -- x_return_status := FND_API.G_RET_STS_ERROR;
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627: END POST_UPDATE_REQ_LINE;
628:
629: /* Called before req header Delete */

Line 626: x_return_status := FND_API.G_RET_STS_SUCCESS;

622: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
623: END IF;
624: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','POST_UPDATE_REQ_LINE',sqlerrm);
625: -- x_return_status := FND_API.G_RET_STS_ERROR;
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627: END POST_UPDATE_REQ_LINE;
628:
629: /* Called before req header Delete */
630: PROCEDURE PRE_DELETE_REQ_LINE

Line 635: x_return_status := FND_API.G_RET_STS_SUCCESS;

631: ( x_return_status OUT NOCOPY varchar2
632: )
633: IS
634: BEGIN
635: x_return_status := FND_API.G_RET_STS_SUCCESS;
636: END PRE_DELETE_REQ_LINE;
637:
638: /* Called after req header Delete */
639: PROCEDURE POST_DELETE_REQ_LINE

Line 645: x_return_status := FND_API.G_RET_STS_SUCCESS;

641: )
642: IS
643: BEGIN
644:
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646:
647: EXCEPTION WHEN OTHERS THEN
648: /*** hook failed -> log error ***/
649: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','POST_DELETE_REQ_LINE',sqlerrm);

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

646:
647: EXCEPTION WHEN OTHERS THEN
648: /*** hook failed -> log error ***/
649: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','POST_DELETE_REQ_LINE',sqlerrm);
650: -- x_return_status := FND_API.G_RET_STS_ERROR;
651: x_return_status := FND_API.G_RET_STS_SUCCESS;
652: END POST_DELETE_REQ_LINE;
653:
654:

Line 651: x_return_status := FND_API.G_RET_STS_SUCCESS;

647: EXCEPTION WHEN OTHERS THEN
648: /*** hook failed -> log error ***/
649: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','POST_DELETE_REQ_LINE',sqlerrm);
650: -- x_return_status := FND_API.G_RET_STS_ERROR;
651: x_return_status := FND_API.G_RET_STS_SUCCESS;
652: END POST_DELETE_REQ_LINE;
653:
654:
655:

Line 708: x_return_status := FND_API.G_RET_STS_SUCCESS;

704: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
705: END IF;
706:
707:
708: x_return_status := FND_API.G_RET_STS_SUCCESS;
709: EXCEPTION WHEN OTHERS THEN
710: /*** hook failed -> log error ***/
711: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
712: -- x_return_status := FND_API.G_RET_STS_ERROR;

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

708: x_return_status := FND_API.G_RET_STS_SUCCESS;
709: EXCEPTION WHEN OTHERS THEN
710: /*** hook failed -> log error ***/
711: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
712: -- x_return_status := FND_API.G_RET_STS_ERROR;
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714: END Delete_All_ACC_Records;
715:
716: /* Full synch for a mobile user */

Line 713: x_return_status := FND_API.G_RET_STS_SUCCESS;

709: EXCEPTION WHEN OTHERS THEN
710: /*** hook failed -> log error ***/
711: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
712: -- x_return_status := FND_API.G_RET_STS_ERROR;
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714: END Delete_All_ACC_Records;
715:
716: /* Full synch for a mobile user */
717: PROCEDURE Insert_All_ACC_Records

Line 771: x_return_status := FND_API.G_RET_STS_SUCCESS;

767: , 'Leaving Insert_All_ACC_Records procedure for user: ' || p_resource_id
768: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
769: END IF;
770:
771: x_return_status := FND_API.G_RET_STS_SUCCESS;
772: EXCEPTION WHEN OTHERS THEN
773: /*** hook failed -> log error ***/
774: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
775: -- x_return_status := FND_API.G_RET_STS_ERROR;

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

771: x_return_status := FND_API.G_RET_STS_SUCCESS;
772: EXCEPTION WHEN OTHERS THEN
773: /*** hook failed -> log error ***/
774: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
775: -- x_return_status := FND_API.G_RET_STS_ERROR;
776: x_return_status := FND_API.G_RET_STS_SUCCESS;
777: END Insert_All_ACC_Records;
778:
779: END CSL_CSP_REQ_LINES_ACC_PKG;

Line 776: x_return_status := FND_API.G_RET_STS_SUCCESS;

772: EXCEPTION WHEN OTHERS THEN
773: /*** hook failed -> log error ***/
774: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
775: -- x_return_status := FND_API.G_RET_STS_ERROR;
776: x_return_status := FND_API.G_RET_STS_SUCCESS;
777: END Insert_All_ACC_Records;
778:
779: END CSL_CSP_REQ_LINES_ACC_PKG;