DBA Data[Home] [Help]

APPS.HZ_BES_BO_TRACKING_PVT dependencies on FND_MESSAGE

Line 70: fnd_message.set_name('AR', 'HZ_API_INVALID_LOOKUP');

66: CLOSE c_entity;
67: IF l_tmp_var IS NOT NULL THEN
68: NULL;
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;

Line 71: fnd_message.set_token('COLUMN' ,P_lkup_code);

67: IF l_tmp_var IS NOT NULL THEN
68: NULL;
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;

Line 72: fnd_message.set_token('LOOKUP_TYPE' ,P_lkup_type);

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

Line 80: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

76: WHEN 'INSERT_UPDATE_FLAG' THEN
77: IF P_lkup_code IN ('I','U') THEN
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;

Line 81: fnd_message.set_token('PARAMETER' ,P_lkup_code);

77: IF P_lkup_code IN ('I','U') THEN
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

Line 92: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

88: CLOSE C_bo_code;
89: IF l_tmp_no IS NOT NULL THEN
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;

Line 93: fnd_message.set_token('PARAMETER' ,P_lkup_code);

89: IF l_tmp_no IS NOT NULL THEN
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

Line 218: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');

214: 'IBY_FNDCPT_PAYER_ASSGN_INSTR_V')
215: THEN
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

Line 219: fnd_message.set_token('PARAMETER' ,'p_GPARENT_BO_CODE');

215: THEN
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');

Line 223: 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;
226: RAISE FND_API.G_EXC_ERROR;
227: WHEN LTRIM(RTRIM(P_GPARENT_TBL_NAME)) IS NULL THEN

Line 224: fnd_message.set_token('PARAMETER' ,'p_GPARENT_ID');

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

Line 228: 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;
231: RAISE FND_API.G_EXC_ERROR;
232: ELSE NULL;

Line 229: fnd_message.set_token('PARAMETER' ,'P_GPARENT_TBL_NAME');

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

Line 278: fnd_message.set_name('AR', 'HZ_API_NULL_PARAM');

274: P_PARENT_ID
275: */
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

Line 279: fnd_message.set_token('PARAMETER' ,'P_CHILD_TBL_NAME');

275: */
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');

Line 283: 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;
286: RAISE FND_API.G_EXC_ERROR;
287: WHEN LTRIM(RTRIM(P_CHILD_OPR_FLAG)) IS NULL THEN

Line 284: fnd_message.set_token('PARAMETER' ,'P_CHILD_ID');

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

Line 288: 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;
291: RAISE FND_API.G_EXC_ERROR;
292: WHEN P_CHILD_UPDATE_DT IS NULL THEN

Line 289: fnd_message.set_token('PARAMETER' ,'P_CHILD_OPR_FLAG');

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

Line 293: 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;
296: RAISE FND_API.G_EXC_ERROR;
297: WHEN P_PARENT_TBL_NAME IS NULL THEN

Line 294: fnd_message.set_token('PARAMETER' ,'P_CHILD_UPDATE_DT');

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

Line 298: 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;
301: RAISE FND_API.G_EXC_ERROR;
302: WHEN (P_PARENT_ID IS NULL OR P_PARENT_ID = 0)THEN

Line 299: fnd_message.set_token('PARAMETER' ,'P_PARENT_TBL_NAME');

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

Line 303: 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;
306: RAISE FND_API.G_EXC_ERROR;
307: ELSE NULL;

Line 304: fnd_message.set_token('PARAMETER' ,'P_PARENT_ID');

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

Line 474: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;
477:
478: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 475: fnd_message.set_token('ERROR' ,SQLERRM);

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;
477:
478: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
479: p_count => x_msg_count,