51: l_progress VARCHAR2(3) := '001';
52:
53: BEGIN
54: IF (g_fnd_debug = 'Y') THEN
55: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
56: FND_LOG.string (
57: log_level => FND_LOG.LEVEL_STATEMENT,
58: module => c_log_head || '.'||l_api_name||'.' || l_progress,
59: message => 'Check API Call Compatibility');
52:
53: BEGIN
54: IF (g_fnd_debug = 'Y') THEN
55: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
56: FND_LOG.string (
57: log_level => FND_LOG.LEVEL_STATEMENT,
58: module => c_log_head || '.'||l_api_name||'.' || l_progress,
59: message => 'Check API Call Compatibility');
60: END IF;
53: BEGIN
54: IF (g_fnd_debug = 'Y') THEN
55: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
56: FND_LOG.string (
57: log_level => FND_LOG.LEVEL_STATEMENT,
58: module => c_log_head || '.'||l_api_name||'.' || l_progress,
59: message => 'Check API Call Compatibility');
60: END IF;
61: END IF;
72: -- Initialize API return status to success
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: IF (g_fnd_debug = 'Y') THEN
76: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
77: FND_LOG.string (
78: log_level => FND_LOG.LEVEL_STATEMENT,
79: module => c_log_head || '.'||l_api_name||'.' || l_progress,
80: message => 'Query to get x_po_releases_attributes');
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: IF (g_fnd_debug = 'Y') THEN
76: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
77: FND_LOG.string (
78: log_level => FND_LOG.LEVEL_STATEMENT,
79: module => c_log_head || '.'||l_api_name||'.' || l_progress,
80: message => 'Query to get x_po_releases_attributes');
81: END IF;
74:
75: IF (g_fnd_debug = 'Y') THEN
76: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
77: FND_LOG.string (
78: log_level => FND_LOG.LEVEL_STATEMENT,
79: module => c_log_head || '.'||l_api_name||'.' || l_progress,
80: message => 'Query to get x_po_releases_attributes');
81: END IF;
82: END IF;
223:
224: EXCEPTION
225: WHEN OTHERS THEN
226: IF (g_fnd_debug = 'Y') THEN
227: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
228: FND_LOG.string( log_level => FND_LOG.LEVEL_EXCEPTION,
229: module => c_log_head || '.'||l_api_name,
230: message => 'unexpected error');
231: END IF;
224: EXCEPTION
225: WHEN OTHERS THEN
226: IF (g_fnd_debug = 'Y') THEN
227: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
228: FND_LOG.string( log_level => FND_LOG.LEVEL_EXCEPTION,
229: module => c_log_head || '.'||l_api_name,
230: message => 'unexpected error');
231: END IF;
232: END IF;