APPS.CSL_WF_NOTIFICATION_AT_ACC_PKG dependencies on FND_API

Line 412: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;

408: FROM WF_NOTIFICATION_ATTRIBUTES
409: WHERE NOTIFICATION_ID = p_notification_id;
410: r_get_attribute_name c_get_attribute_name%ROWTYPE;
411:
412: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;
413:
414: BEGIN
415:
416: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 471: l_return_value := FND_API.G_RET_STS_SUCCESS;

467: END IF;
468: FETCH c_notification_sender INTO r_notification_sender;
469: END LOOP;
470: CLOSE c_notification_sender;
471: l_return_value := FND_API.G_RET_STS_SUCCESS;
472: END IF;
473: /*** Second insert all received records ***/
474: OPEN c_notification_receive ( p_resource_id );
475: FETCH c_notification_receive INTO r_notification_receive;

Line 509: l_return_value := FND_API.G_RET_STS_SUCCESS;

505: FETCH c_notification_receive INTO r_notification_receive;
506: END LOOP;
507: CLOSE c_notification_receive;
508: END IF;
509: l_return_value := FND_API.G_RET_STS_SUCCESS;
510: END IF;
511:
512: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
513: jtm_message_log_pkg.Log_Msg

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

520: x_return_status := l_return_value;
521: EXCEPTION WHEN OTHERS THEN
522: /*** hook failed -> log error ***/
523: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
524: -- x_return_status := FND_API.G_RET_STS_ERROR;
525: x_return_status := FND_API.G_RET_STS_SUCCESS;
526:
527: END Insert_All_ACC_Records;
528:

Line 525: x_return_status := FND_API.G_RET_STS_SUCCESS;

521: EXCEPTION WHEN OTHERS THEN
522: /*** hook failed -> log error ***/
523: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
524: -- x_return_status := FND_API.G_RET_STS_ERROR;
525: x_return_status := FND_API.G_RET_STS_SUCCESS;
526:
527: END Insert_All_ACC_Records;
528:
529: PROCEDURE Delete_All_ACC_Records(

Line 572: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;

568: FROM WF_NOTIFICATION_ATTRIBUTES
569: WHERE NOTIFICATION_ID = p_notification_id;
570: r_get_attribute_name c_get_attribute_name%ROWTYPE;
571:
572: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;
573:
574: BEGIN
575: /*Get the debug level*/
576: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 648: l_return_value := FND_API.G_RET_STS_SUCCESS;

644: END IF;
645: FETCH c_notification_sender INTO r_notification_sender;
646: END LOOP;
647: CLOSE c_notification_sender;
648: l_return_value := FND_API.G_RET_STS_SUCCESS;
649: END IF;
650: /*** Second Delete all received records ***/
651: OPEN c_notification_receive ( p_resource_id );
652: FETCH c_notification_receive INTO r_notification_receive;

Line 702: l_return_value := FND_API.G_RET_STS_SUCCESS;

698: END IF;
699: FETCH c_notification_receive INTO r_notification_receive;
700: END LOOP;
701: CLOSE c_notification_receive;
702: l_return_value := FND_API.G_RET_STS_SUCCESS;
703: END IF;
704: END IF;
705:
706: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

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

719: , v_object_name => g_table_name
720: , v_message => 'Error occurred in Delete_All_ACC_Records'||sqlerrm
721: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
722: fnd_msg_pub.Add_Exc_Msg('CSL_WF_NOTIFICATION_AT_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
723: -- x_return_status := FND_API.G_RET_STS_ERROR;
724: x_return_status := FND_API.G_RET_STS_SUCCESS;
725:
726: END Delete_All_ACC_Records;
727:

Line 724: x_return_status := FND_API.G_RET_STS_SUCCESS;

720: , v_message => 'Error occurred in Delete_All_ACC_Records'||sqlerrm
721: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
722: fnd_msg_pub.Add_Exc_Msg('CSL_WF_NOTIFICATION_AT_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
723: -- x_return_status := FND_API.G_RET_STS_ERROR;
724: x_return_status := FND_API.G_RET_STS_SUCCESS;
725:
726: END Delete_All_ACC_Records;
727:
728: END CSL_WF_NOTIFICATION_AT_ACC_PKG;