41:
42: BEGIN
43:
44: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
49: l_api_name, g_pkg_name)
77: return l_status_code;
78:
79: EXCEPTION
80: WHEN OTHERS THEN
81: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
82: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
83: IF (g_fnd_debug = 'Y') THEN
84: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
85: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
78:
79: EXCEPTION
80: WHEN OTHERS THEN
81: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
82: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
83: IF (g_fnd_debug = 'Y') THEN
84: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
85: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
86: l_api_name || '.others_exception', sqlcode);
123:
124: BEGIN
125:
126: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
127: FND_MSG_PUB.initialize;
128: END IF;
129:
130: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
131: l_api_name, g_pkg_name) THEN
160: return l_shipment_status;
161:
162: EXCEPTION
163: WHEN OTHERS THEN
164: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
165: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
166: IF (g_fnd_debug = 'Y') THEN
167: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
168: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
161:
162: EXCEPTION
163: WHEN OTHERS THEN
164: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
165: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
166: IF (g_fnd_debug = 'Y') THEN
167: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
168: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
169: l_api_name || '.others_exception', sqlcode);
210:
211: BEGIN
212:
213: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
214: FND_MSG_PUB.initialize;
215: END IF;
216:
217: IF NOT FND_API.Compatible_API_Call ( l_api_version,
218: p_api_version,
253: WHEN FND_API.g_exc_unexpected_error THEN
254: x_return_status := FND_API.g_ret_sts_unexp_error;
255: WHEN OTHERS THEN
256: x_return_status := FND_API.g_ret_sts_unexp_error;
257: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
258: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
259: IF (g_fnd_debug = 'Y') THEN
260: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
261: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
254: x_return_status := FND_API.g_ret_sts_unexp_error;
255: WHEN OTHERS THEN
256: x_return_status := FND_API.g_ret_sts_unexp_error;
257: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
258: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
259: IF (g_fnd_debug = 'Y') THEN
260: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
261: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
262: l_api_name || '.others_exception', sqlcode);
295:
296: BEGIN
297:
298: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301:
302: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
303: l_api_name, g_pkg_name)
331: WHEN FND_API.g_exc_unexpected_error THEN
332: x_return_status := FND_API.g_ret_sts_unexp_error;
333: WHEN OTHERS THEN
334: x_return_status := FND_API.g_ret_sts_unexp_error;
335: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
336: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
337: IF (g_fnd_debug = 'Y') THEN
338: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
339: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
332: x_return_status := FND_API.g_ret_sts_unexp_error;
333: WHEN OTHERS THEN
334: x_return_status := FND_API.g_ret_sts_unexp_error;
335: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
336: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
337: IF (g_fnd_debug = 'Y') THEN
338: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
339: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
340: l_api_name || '.others_exception', sqlcode);
369:
370: BEGIN
371:
372: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
373: FND_MSG_PUB.initialize;
374: END IF;
375:
376: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
377: l_api_name, g_pkg_name)
407: return l_result;
408:
409: EXCEPTION
410: WHEN OTHERS THEN
411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
412: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
413: IF (g_fnd_debug = 'Y') THEN
414: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
415: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
408:
409: EXCEPTION
410: WHEN OTHERS THEN
411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
412: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
413: IF (g_fnd_debug = 'Y') THEN
414: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
415: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
416: l_api_name || '.others_exception', sqlcode);
451:
452: BEGIN
453:
454: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
455: FND_MSG_PUB.initialize;
456: END IF;
457:
458: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
459: l_api_name, g_pkg_name)
486: WHEN FND_API.g_exc_unexpected_error THEN
487: x_return_status := FND_API.g_ret_sts_unexp_error;
488: WHEN OTHERS THEN
489: x_return_status := FND_API.g_ret_sts_unexp_error;
490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
491: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
492: IF (g_fnd_debug = 'Y') THEN
493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
494: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
487: x_return_status := FND_API.g_ret_sts_unexp_error;
488: WHEN OTHERS THEN
489: x_return_status := FND_API.g_ret_sts_unexp_error;
490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
491: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
492: IF (g_fnd_debug = 'Y') THEN
493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
494: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
495: l_api_name || '.others_exception', sqlcode);