DBA Data[Home] [Help]

APPS.HZ_BES_BO_TRACKING_PVT dependencies on FND_API

Line 74: RAISE FND_API.G_EXC_ERROR;

70: fnd_message.set_name('AR', 'HZ_API_INVALID_LOOKUP');
71: fnd_message.set_token('COLUMN' ,P_lkup_code);
72: fnd_message.set_token('LOOKUP_TYPE' ,P_lkup_type);
73: fnd_msg_pub.add;
74: RAISE FND_API.G_EXC_ERROR;
75: END IF;
76: WHEN 'INSERT_UPDATE_FLAG' THEN
77: IF P_lkup_code IN ('I','U') THEN
78: NULL;

Line 83: RAISE FND_API.G_EXC_ERROR;

79: ELSE
80: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
81: fnd_message.set_token('PARAMETER' ,P_lkup_code);
82: fnd_msg_pub.add;
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85: WHEN 'HZ_BUSINESS_ENTITIES' THEN
86: OPEN C_bo_code;
87: FETCH C_bo_code INTO l_tmp_no;

Line 95: RAISE FND_API.G_EXC_ERROR;

91: ELSE
92: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
93: fnd_message.set_token('PARAMETER' ,P_lkup_code);
94: fnd_msg_pub.add;
95: RAISE FND_API.G_EXC_ERROR;
96: END IF;
97: ELSE
98: RAISE FND_API.G_EXC_ERROR;
99: END CASE;

Line 98: RAISE FND_API.G_EXC_ERROR;

94: fnd_msg_pub.add;
95: RAISE FND_API.G_EXC_ERROR;
96: END IF;
97: ELSE
98: RAISE FND_API.G_EXC_ERROR;
99: END CASE;
100: */
101: -- Debug info.
102: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 221: RAISE FND_API.G_EXC_ERROR;

217: WHEN LTRIM(RTRIM(p_GPARENT_BO_CODE)) IS NULL THEN
218: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
219: fnd_message.set_token('PARAMETER' ,'p_GPARENT_BO_CODE');
220: fnd_msg_pub.add;
221: RAISE FND_API.G_EXC_ERROR;
222: WHEN (p_GPARENT_ID IS NULL OR p_GPARENT_ID = 0)THEN
223: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
224: fnd_message.set_token('PARAMETER' ,'p_GPARENT_ID');
225: fnd_msg_pub.add;

Line 226: RAISE FND_API.G_EXC_ERROR;

222: WHEN (p_GPARENT_ID IS NULL OR p_GPARENT_ID = 0)THEN
223: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
224: fnd_message.set_token('PARAMETER' ,'p_GPARENT_ID');
225: fnd_msg_pub.add;
226: RAISE FND_API.G_EXC_ERROR;
227: WHEN LTRIM(RTRIM(P_GPARENT_TBL_NAME)) IS NULL THEN
228: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
229: fnd_message.set_token('PARAMETER' ,'P_GPARENT_TBL_NAME');
230: fnd_msg_pub.add;

Line 231: RAISE FND_API.G_EXC_ERROR;

227: WHEN LTRIM(RTRIM(P_GPARENT_TBL_NAME)) IS NULL THEN
228: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
229: fnd_message.set_token('PARAMETER' ,'P_GPARENT_TBL_NAME');
230: fnd_msg_pub.add;
231: RAISE FND_API.G_EXC_ERROR;
232: ELSE NULL;
233: END CASE;
234: END IF ;
235:

Line 281: RAISE FND_API.G_EXC_ERROR;

277: WHEN LTRIM(RTRIM(P_CHILD_TBL_NAME)) IS NULL THEN
278: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
279: fnd_message.set_token('PARAMETER' ,'P_CHILD_TBL_NAME');
280: fnd_msg_pub.add;
281: RAISE FND_API.G_EXC_ERROR;
282: WHEN (P_CHILD_ID IS NULL OR P_CHILD_ID = 0)THEN
283: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
284: fnd_message.set_token('PARAMETER' ,'P_CHILD_ID');
285: fnd_msg_pub.add;

Line 286: RAISE FND_API.G_EXC_ERROR;

282: WHEN (P_CHILD_ID IS NULL OR P_CHILD_ID = 0)THEN
283: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
284: fnd_message.set_token('PARAMETER' ,'P_CHILD_ID');
285: fnd_msg_pub.add;
286: RAISE FND_API.G_EXC_ERROR;
287: WHEN LTRIM(RTRIM(P_CHILD_OPR_FLAG)) IS NULL THEN
288: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
289: fnd_message.set_token('PARAMETER' ,'P_CHILD_OPR_FLAG');
290: fnd_msg_pub.add;

Line 291: RAISE FND_API.G_EXC_ERROR;

287: WHEN LTRIM(RTRIM(P_CHILD_OPR_FLAG)) IS NULL THEN
288: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
289: fnd_message.set_token('PARAMETER' ,'P_CHILD_OPR_FLAG');
290: fnd_msg_pub.add;
291: RAISE FND_API.G_EXC_ERROR;
292: WHEN P_CHILD_UPDATE_DT IS NULL THEN
293: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
294: fnd_message.set_token('PARAMETER' ,'P_CHILD_UPDATE_DT');
295: fnd_msg_pub.add;

Line 296: RAISE FND_API.G_EXC_ERROR;

292: WHEN P_CHILD_UPDATE_DT IS NULL THEN
293: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
294: fnd_message.set_token('PARAMETER' ,'P_CHILD_UPDATE_DT');
295: fnd_msg_pub.add;
296: RAISE FND_API.G_EXC_ERROR;
297: WHEN P_PARENT_TBL_NAME IS NULL THEN
298: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
299: fnd_message.set_token('PARAMETER' ,'P_PARENT_TBL_NAME');
300: fnd_msg_pub.add;

Line 301: RAISE FND_API.G_EXC_ERROR;

297: WHEN P_PARENT_TBL_NAME IS NULL THEN
298: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
299: fnd_message.set_token('PARAMETER' ,'P_PARENT_TBL_NAME');
300: fnd_msg_pub.add;
301: RAISE FND_API.G_EXC_ERROR;
302: WHEN (P_PARENT_ID IS NULL OR P_PARENT_ID = 0)THEN
303: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
304: fnd_message.set_token('PARAMETER' ,'P_PARENT_ID');
305: fnd_msg_pub.add;

Line 306: RAISE FND_API.G_EXC_ERROR;

302: WHEN (P_PARENT_ID IS NULL OR P_PARENT_ID = 0)THEN
303: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');
304: fnd_message.set_token('PARAMETER' ,'P_PARENT_ID');
305: fnd_msg_pub.add;
306: RAISE FND_API.G_EXC_ERROR;
307: ELSE NULL;
308: END CASE;
309: -- Debug info.
310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 320: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

316: END do_val_mandatory;
317: ---------------------------------------------------------------------------
318: ---------------------------------------------------------------------------
319: PROCEDURE create_bot(
320: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
321: P_CHILD_BO_CODE IN VARCHAR2,
322: P_CHILD_TBL_NAME IN VARCHAR2,
323: P_CHILD_ID IN NUMBER,
324: P_CHILD_OPR_FLAG IN VARCHAR2,

Line 341: x_return_status := FND_API.G_RET_STS_SUCCESS;

337:
338: BEGIN
339:
340: -- initialize API return status to success.
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: -- Initialize message list if p_init_msg_list is set to TRUE
344: IF FND_API.to_Boolean(p_init_msg_list) THEN
345: FND_MSG_PUB.initialize;

Line 344: IF FND_API.to_Boolean(p_init_msg_list) THEN

340: -- initialize API return status to success.
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: -- Initialize message list if p_init_msg_list is set to TRUE
344: IF FND_API.to_Boolean(p_init_msg_list) THEN
345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: -- Debug info.

Line 430: WHEN fnd_api.g_exc_error THEN

426:
427:
428: EXCEPTION
429:
430: WHEN fnd_api.g_exc_error THEN
431: ROLLBACK TO cre_bot;
432: x_return_status := fnd_api.g_ret_sts_error;
433:
434: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 432: x_return_status := fnd_api.g_ret_sts_error;

428: EXCEPTION
429:
430: WHEN fnd_api.g_exc_error THEN
431: ROLLBACK TO cre_bot;
432: x_return_status := fnd_api.g_ret_sts_error;
433:
434: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
435: p_count => x_msg_count,
436: p_data => x_msg_data);

Line 434: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

430: WHEN fnd_api.g_exc_error THEN
431: ROLLBACK TO cre_bot;
432: x_return_status := fnd_api.g_ret_sts_error;
433:
434: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
435: p_count => x_msg_count,
436: p_data => x_msg_data);
437:
438: -- Debug info.

Line 450: WHEN fnd_api.g_exc_unexpected_error THEN

446: hz_utility_v2pub.debug(p_message=>'create_bot()-',
447: p_prefix=>G_DEBUG_PREFIX,
448: p_msg_level=>fnd_log.level_procedure);
449: END IF;
450: WHEN fnd_api.g_exc_unexpected_error THEN
451: ROLLBACK TO cre_bot;
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453:
454: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 452: x_return_status := fnd_api.g_ret_sts_unexp_error;

448: p_msg_level=>fnd_log.level_procedure);
449: END IF;
450: WHEN fnd_api.g_exc_unexpected_error THEN
451: ROLLBACK TO cre_bot;
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453:
454: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
455: p_count => x_msg_count,
456: p_data => x_msg_data);

Line 454: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

450: WHEN fnd_api.g_exc_unexpected_error THEN
451: ROLLBACK TO cre_bot;
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453:
454: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
455: p_count => x_msg_count,
456: p_data => x_msg_data);
457:
458: -- Debug info.

Line 472: x_return_status := fnd_api.g_ret_sts_unexp_error;

468: p_msg_level=>fnd_log.level_procedure);
469: END IF;
470: WHEN OTHERS THEN
471: ROLLBACK TO cre_bot;
472: x_return_status := fnd_api.g_ret_sts_unexp_error;
473:
474: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
475: fnd_message.set_token('ERROR' ,SQLERRM);
476: fnd_msg_pub.add;

Line 478: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

474: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
475: fnd_message.set_token('ERROR' ,SQLERRM);
476: fnd_msg_pub.add;
477:
478: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
479: p_count => x_msg_count,
480: p_data => x_msg_data);
481:
482: -- Debug info.