DBA Data[Home] [Help]

APPS.HZ_BES_BO_TRACKING_PVT dependencies on FND_MSG_PUB

Line 73: fnd_msg_pub.add;

69: ELSE
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

Line 82: fnd_msg_pub.add;

78: NULL;
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;

Line 94: fnd_msg_pub.add;

90: NULL;
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;

Line 220: fnd_msg_pub.add;

216: CASE
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');

Line 225: 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;
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');

Line 230: 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;
231: RAISE FND_API.G_EXC_ERROR;
232: ELSE NULL;
233: END CASE;
234: END IF ;

Line 280: fnd_msg_pub.add;

276: CASE
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');

Line 285: 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;
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');

Line 290: 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;
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');

Line 295: 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;
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');

Line 300: 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;
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');

Line 305: 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;
306: RAISE FND_API.G_EXC_ERROR;
307: ELSE NULL;
308: END CASE;
309: -- Debug info.

Line 345: FND_MSG_PUB.initialize;

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.
349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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 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 476: fnd_msg_pub.add;

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;
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);

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.