APPS.CSM_QUERY_INSTANCE_PKG dependencies on FND_MSG_PUB

Line 300: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);

296: p_error_msg := 'Upload Successful for the Instance Id : ' || l_instance_id ;
297: RETURN;
298:
299: EXCEPTION WHEN OTHERS THEN
300: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
301: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
302: (
303: p_api_error => TRUE
304: );

Line 389: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_DELETE', sqlerrm);

385: p_error_msg := 'Delete Successful for the Instance Id : ' || l_instance_id ;
386: RETURN;
387:
388: EXCEPTION WHEN OTHERS THEN
389: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_DELETE', sqlerrm);
390: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT (p_api_error => TRUE);
391: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_DELETE: ' || sqlerrm
392: || ' for Instance ID ' || p_record.INSTANCE_ID ,'CSM_QUERY_INSTANCE_PKG.APPLY_DELETE',FND_LOG.LEVEL_EXCEPTION);
393: p_error_msg := 'Exception in APPLY_DELETE for Instance Id : ' || l_instance_id || substr(SQLERRM, 1,2000);

Line 410: FND_MSG_PUB.INITIALIZE;

406: l_access_id NUMBER;
407: BEGIN
408: /*** initialize return status and message list ***/
409: x_return_status := FND_API.G_RET_STS_SUCCESS;
410: FND_MSG_PUB.INITIALIZE;
411:
412: CSM_UTIL_PKG.LOG('Entering CSM_QUERY_INSTANCE_PKG.APPLY_RECORD for Query Instance ID ' || p_record.INSTANCE_ID ,
413: 'CSM_QUERY_INSTANCE_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
414:

Line 450: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);

446:
447: CSM_UTIL_PKG.LOG('Leaving CSM_QUERY_INSTANCE_PKG.APPLY_RECORD for Query Instance ID ' || p_record.INSTANCE_ID ,
448: 'CSM_QUERY_INSTANCE_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
449: EXCEPTION WHEN OTHERS THEN
450: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
451: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
452: (
453: p_api_error => TRUE
454: );