APPS.CSM_EMAIL_QUERY_PKG dependencies on CSM_QUERY_PKG

Line 512: CSM_QUERY_PKG.INSERT_INSTANCE

508: END IF;
509: END LOOP;
510: END IF;
511:
512: CSM_QUERY_PKG.INSERT_INSTANCE
513: ( p_USER_ID => g_user_id,
514: p_QUERY_ID => l_query_id,
515: p_INSTANCE_ID => NULL,
516: p_INSTANCE_NAME => NULL,

Line 529: || ' ROOT ERROR: CSM_QUERY_PKG.INSERT_INSTANCE '

525:
526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: x_error_message := 'Error in EXECUTE_COMMAND :'
529: || ' ROOT ERROR: CSM_QUERY_PKG.INSERT_INSTANCE '
530: || ' for QUERY_ID ' || l_query_id || ' Detail: ' || x_error_message;
531: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
532: RETURN ;
533: END IF;

Line 535: CSM_QUERY_PKG.EXECUTE_QUERY(

531: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
532: RETURN ;
533: END IF;
534:
535: CSM_QUERY_PKG.EXECUTE_QUERY(
536: p_USER_ID => g_user_id,
537: p_QUERY_ID => l_query_id,
538: p_INSTANCE_ID => p_instance_id,
539: x_return_status => x_return_status,

Line 547: || ' ROOT ERROR: CSM_QUERY_PKG.EXECUTE_QUERY '

543:
544: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: x_error_message := 'Error in EXECUTE_COMMAND :'
547: || ' ROOT ERROR: CSM_QUERY_PKG.EXECUTE_QUERY '
548: || ' for INSTANCE_ID ' || p_instance_id || ' Detail: ' || x_error_message;
549: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
550: RETURN ;
551: END IF;