DBA Data[Home] [Help]

APPS.CZ_IB_LOCKING dependencies on FND_API

Line 77: IF (NOT FND_API.compatible_api_call(l_api_version

73: l_api_name CONSTANT VARCHAR2(30) := 'lock_Config';
74: l_ndebug NUMBER := 0;
75: BEGIN
76:
77: IF (NOT FND_API.compatible_api_call(l_api_version
78: ,p_api_version
79: ,l_api_name
80: ,G_PKG_NAME
81: )) THEN

Line 82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

78: ,p_api_version
79: ,l_api_name
80: ,G_PKG_NAME
81: )) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
85: IF (p_init_msg_list = FND_API.G_TRUE) THEN
86: fnd_msg_pub.initialize;

Line 85: IF (p_init_msg_list = FND_API.G_TRUE) THEN

81: )) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
85: IF (p_init_msg_list = FND_API.G_TRUE) THEN
86: fnd_msg_pub.initialize;
87: END IF;
88:
89: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 89: x_return_status := FND_API.G_RET_STS_SUCCESS;

85: IF (p_init_msg_list = FND_API.G_TRUE) THEN
86: fnd_msg_pub.initialize;
87: END IF;
88:
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90: x_msg_count := 0;
91: x_msg_data := NULL;
92:
93: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

145: -- validate p_config_session_hdr_id,p_config_session_rev_nbr,p_config_session_item_id
146: -- and if they are not valid then log error message and exit
147: --
148: IF NOT(is_Valid_Data (p_config_session_hdr_id,p_config_session_rev_nbr,p_config_session_item_id)) THEN
149: x_return_status := FND_API.G_RET_STS_ERROR;
150:
151: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Error : Invalid Data : '||
152: 'p_config_session_hdr_id/p_config_session_rev_nbr/p_config_session_item_id='||
153: TO_CHAR(p_config_session_hdr_id)||'/'||TO_CHAR(p_config_session_rev_nbr)||'/'||TO_CHAR(p_config_session_item_id));

Line 156: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

152: 'p_config_session_hdr_id/p_config_session_rev_nbr/p_config_session_item_id='||
153: TO_CHAR(p_config_session_hdr_id)||'/'||TO_CHAR(p_config_session_rev_nbr)||'/'||TO_CHAR(p_config_session_item_id));
154: fnd_msg_pub.count_and_get(p_count => x_msg_count,
155: p_data => x_msg_data);
156: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
157:
158: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
159: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
160: 'Error : Invalid Data : p_config_session_hdr_id/p_config_session_rev_nbr/p_config_session_item_id='||

Line 226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

222: x_msg_data := CZ_IB_LOCKING.m_msg_data;
223: END IF;
224:
225: EXCEPTION
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: fnd_msg_pub.count_and_get(p_count => x_msg_count,
229: p_data => x_msg_data);
230:

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

223: END IF;
224:
225: EXCEPTION
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: fnd_msg_pub.count_and_get(p_count => x_msg_count,
229: p_data => x_msg_data);
230:
231: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 233: 'Unexpected error : '||fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE),

229: p_data => x_msg_data);
230:
231: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
233: 'Unexpected error : '||fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE),
234: fnd_log.LEVEL_ERROR);
235: END IF;
236: WHEN OTHERS THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

233: 'Unexpected error : '||fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE),
234: fnd_log.LEVEL_ERROR);
235: END IF;
236: WHEN OTHERS THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Fatal error : '||SQLERRM);
239: fnd_msg_pub.count_and_get(p_count => x_msg_count,
240: p_data => x_msg_data);
241: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 279: IF (NOT FND_API.compatible_api_call(l_api_version

275: l_api_name CONSTANT VARCHAR2(30) := 'unlock_Config';
276: l_ndebug NUMBER := 1;
277: BEGIN
278:
279: IF (NOT FND_API.compatible_api_call(l_api_version
280: ,p_api_version
281: ,l_api_name
282: ,G_PKG_NAME
283: )) THEN

Line 284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

280: ,p_api_version
281: ,l_api_name
282: ,G_PKG_NAME
283: )) THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: IF (p_init_msg_list = FND_API.G_TRUE) THEN
288: fnd_msg_pub.initialize;

Line 287: IF (p_init_msg_list = FND_API.G_TRUE) THEN

283: )) THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: IF (p_init_msg_list = FND_API.G_TRUE) THEN
288: fnd_msg_pub.initialize;
289: END IF;
290:
291: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 291: x_return_status := FND_API.G_RET_STS_SUCCESS;

287: IF (p_init_msg_list = FND_API.G_TRUE) THEN
288: fnd_msg_pub.initialize;
289: END IF;
290:
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292: x_msg_count := 0;
293: x_msg_data := NULL;
294:
295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 355: x_return_status := FND_API.G_RET_STS_ERROR;

351: -- validate p_config_session_hdr_id,p_config_session_rev_nbr,p_config_session_item_id
352: -- and if they are not valid then log error message and exit
353: --
354: IF NOT(is_Valid_Data (p_config_session_hdr_id,p_config_session_rev_nbr,p_config_session_item_id)) THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356:
357: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Error : Invalid Data : '||
358: 'p_config_session_hdr_id/p_config_session_rev_nbr/p_config_session_item_id='||
359: TO_CHAR(p_config_session_hdr_id)||'/'||TO_CHAR(p_config_session_rev_nbr)||'/'||TO_CHAR(p_config_session_item_id));

Line 362: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

358: 'p_config_session_hdr_id/p_config_session_rev_nbr/p_config_session_item_id='||
359: TO_CHAR(p_config_session_hdr_id)||'/'||TO_CHAR(p_config_session_rev_nbr)||'/'||TO_CHAR(p_config_session_item_id));
360: fnd_msg_pub.count_and_get(p_count => x_msg_count,
361: p_data => x_msg_data);
362: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
363:
364: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
365: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
366: 'Error : Invalid Data : p_config_session_hdr_id/p_config_session_rev_nbr/p_config_session_item_id='||

Line 433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

429: x_msg_data := CZ_IB_LOCKING.m_msg_data;
430: END IF;
431:
432: EXCEPTION
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: fnd_msg_pub.count_and_get(p_count => x_msg_count,
436: p_data => x_msg_data);
437: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

430: END IF;
431:
432: EXCEPTION
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: fnd_msg_pub.count_and_get(p_count => x_msg_count,
436: p_data => x_msg_data);
437: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
438: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,

Line 439: 'Unexpected error : '||fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE),

435: fnd_msg_pub.count_and_get(p_count => x_msg_count,
436: p_data => x_msg_data);
437: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
438: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
439: 'Unexpected error : '||fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE),
440: fnd_log.LEVEL_ERROR);
441: END IF;
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

439: 'Unexpected error : '||fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE),
440: fnd_log.LEVEL_ERROR);
441: END IF;
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Fatal error : '||SQLERRM);
445: fnd_msg_pub.count_and_get(p_count => x_msg_count,
446: p_data => x_msg_data);
447: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN