eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_ROLE_PMT_PLANS_PVT dependencies on FND_MSG_PUB

Line 182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

178: END IF;
179:
180: -- role_name must exist in cn_roles
181: IF NOT valid_role_name(p_role_pmt_plan_rec.role_name) THEN
182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
183: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
184: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pmt_plan_rec.role_name);
185: fnd_msg_pub.ADD;
186: END IF;

Line 185: fnd_msg_pub.ADD;

181: IF NOT valid_role_name(p_role_pmt_plan_rec.role_name) THEN
182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
183: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
184: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pmt_plan_rec.role_name);
185: fnd_msg_pub.ADD;
186: END IF;
187: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
188: RAISE fnd_api.g_exc_error;
189: ELSE

Line 195: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

191: END IF;
192:
193: -- pmt_plan_id must exist in cn_pmt_plans
194: IF NOT valid_pmt_plan_id(p_role_pmt_plan_rec.pmt_plan_id, p_role_pmt_plan_rec.org_id) THEN
195: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
196: fnd_message.set_name('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
197: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec.pmt_plan_name);
198: fnd_msg_pub.ADD;
199: END IF;

Line 198: fnd_msg_pub.ADD;

194: IF NOT valid_pmt_plan_id(p_role_pmt_plan_rec.pmt_plan_id, p_role_pmt_plan_rec.org_id) THEN
195: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
196: fnd_message.set_name('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
197: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec.pmt_plan_name);
198: fnd_msg_pub.ADD;
199: END IF;
200: x_loading_status := 'CN_RL_ASGN_PP_NOT_EXIST';
201: RAISE fnd_api.g_exc_error;
202: ELSE

Line 213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

209: FETCH l_pp_cur INTO l_pp_rec;
210:
211: IF (l_pp_cur%notfound) THEN
212: -- normally this won't happen as it has been valided previously
213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
214: fnd_message.set_name ('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
215: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec.pmt_plan_name);
216: fnd_msg_pub.ADD;
217: END IF;

Line 216: fnd_msg_pub.ADD;

212: -- normally this won't happen as it has been valided previously
213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
214: fnd_message.set_name ('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
215: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec.pmt_plan_name);
216: fnd_msg_pub.ADD;
217: END IF;
218: x_loading_status := 'CN_RL_ASGN_PP_NOT_EXIST';
219: CLOSE l_pp_cur;
220: RAISE fnd_api.g_exc_error;

Line 228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

224: IF NOT date_range_within(p_role_pmt_plan_rec.start_date,
225: p_role_pmt_plan_rec.end_date,
226: l_pp_rec.start_date,
227: l_pp_rec.end_date) THEN
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
229: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');
230: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
231: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
232: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);

Line 235: fnd_msg_pub.ADD;

231: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
232: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
233: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
234: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);
235: fnd_msg_pub.ADD;
236: END IF;
237: x_loading_status := 'CN_RL_PP_DATE_RANGE_NOT_WITHIN';
238: CLOSE l_pp_cur;
239: RAISE fnd_api.g_exc_error;

Line 245: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

241:
242: --bug 3560026 by Julia Huang on 4/7/04 -begin
243: IF ( p_role_pmt_plan_rec.start_date < l_pp_rec.start_date )
244: THEN
245: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
246: THEN
247: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');
248: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
249: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);

Line 253: fnd_msg_pub.ADD;

249: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
250: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
251: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
252: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);
253: fnd_msg_pub.ADD;
254: END IF;
255:
256: x_loading_status := 'CN_RL_PP_SD_LESS_THAN_PP_SD';
257: CLOSE l_pp_cur;

Line 291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

287: (l_pp_payment_group_code = l_payment_group_code))
288:
289: THEN
290:
291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
292: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
293: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
294: fnd_message.set_token('START_DATE',l_rec.start_date);
295: fnd_message.set_token('END_DATE',l_rec.end_date);

Line 296: fnd_msg_pub.ADD;

292: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
293: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
294: fnd_message.set_token('START_DATE',l_rec.start_date);
295: fnd_message.set_token('END_DATE',l_rec.end_date);
296: fnd_msg_pub.ADD;
297: END IF;
298: x_loading_status := 'CN_RL_ROLE_PMT_PLAN_OVERLAP';
299: RAISE fnd_api.g_exc_error;
300: END IF;

Line 306: FND_MSG_PUB.Count_And_Get

302:
303: -- End of API body.
304:
305: -- Standard call to get message count and if count is 1, get message info.
306: FND_MSG_PUB.Count_And_Get
307: (
308: p_count => x_msg_count ,
309: p_data => x_msg_data ,
310: p_encoded => FND_API.G_FALSE

Line 316: FND_MSG_PUB.Count_And_Get

312:
313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN
315: x_return_status := FND_API.G_RET_STS_ERROR ;
316: FND_MSG_PUB.Count_And_Get
317: (
318: p_count => x_msg_count ,
319: p_data => x_msg_data ,
320: p_encoded => FND_API.G_FALSE

Line 325: FND_MSG_PUB.Count_And_Get

321: );
322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
324: x_loading_status := 'UNEXPECTED_ERR';
325: FND_MSG_PUB.Count_And_Get
326: (
327: p_count => x_msg_count ,
328: p_data => x_msg_data ,
329: p_encoded => FND_API.G_FALSE

Line 334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

330: );
331: WHEN OTHERS THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: x_loading_status := 'UNEXPECTED_ERR';
334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
337: END IF;
338: FND_MSG_PUB.Count_And_Get

Line 336: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: x_loading_status := 'UNEXPECTED_ERR';
334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
337: END IF;
338: FND_MSG_PUB.Count_And_Get
339: (
340: p_count => x_msg_count ,

Line 338: FND_MSG_PUB.Count_And_Get

334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
337: END IF;
338: FND_MSG_PUB.Count_And_Get
339: (
340: p_count => x_msg_count ,
341: p_data => x_msg_data ,
342: p_encoded => FND_API.G_FALSE

Line 411: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

407: p_role_pmt_plan_rec_old.end_date,
408: p_role_pmt_plan_rec_old.org_id);
409:
410: IF (x_role_pmt_plan_id_old IS NULL) THEN
411: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
412: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');
413: fnd_msg_pub.ADD;
414: END IF;
415: x_loading_status := 'CN_RL_UPD_ROLE_PP_NOT_EXIST';

Line 413: fnd_msg_pub.ADD;

409:
410: IF (x_role_pmt_plan_id_old IS NULL) THEN
411: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
412: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');
413: fnd_msg_pub.ADD;
414: END IF;
415: x_loading_status := 'CN_RL_UPD_ROLE_PP_NOT_EXIST';
416: RAISE fnd_api.g_exc_error;
417: END IF;

Line 469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

465: FETCH l_old_cur INTO l_old_rec;
466: IF (l_old_cur%notfound) THEN
467: -- normally, this should not happen as the existance has
468: -- been validated previously
469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
470: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');
471: fnd_msg_pub.ADD;
472: END IF;
473: x_loading_status := 'CN_RL_UPD_ROLE_PP_NOT_EXIST';

Line 471: fnd_msg_pub.ADD;

467: -- normally, this should not happen as the existance has
468: -- been validated previously
469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
470: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');
471: fnd_msg_pub.ADD;
472: END IF;
473: x_loading_status := 'CN_RL_UPD_ROLE_PP_NOT_EXIST';
474: CLOSE l_old_cur;
475: RAISE fnd_api.g_exc_error;

Line 488: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

484: ELSE
485: tmp_end_date := p_role_pmt_plan_rec_new.end_date;
486: END IF;
487: IF (tmp_end_date IS NOT NULL) AND (tmp_start_date > tmp_end_date) THEN
488: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
489: fnd_message.set_name('CN', 'CN_RL_INVALID_DATE_RANGE');
490: fnd_message.set_token('START_DATE',tmp_start_date);
491: fnd_message.set_token('END_DATE',tmp_end_date);
492: fnd_msg_pub.ADD;

Line 492: fnd_msg_pub.ADD;

488: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
489: fnd_message.set_name('CN', 'CN_RL_INVALID_DATE_RANGE');
490: fnd_message.set_token('START_DATE',tmp_start_date);
491: fnd_message.set_token('END_DATE',tmp_end_date);
492: fnd_msg_pub.ADD;
493: END IF;
494: x_loading_status := 'CN_RL_INVALID_DATE_RANGE';
495: CLOSE l_old_cur;
496: RAISE fnd_api.g_exc_error;

Line 505: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

501: -- if new role_name is not missing then new role_name must exist in cn_roles
502: IF (p_role_pmt_plan_rec_new.role_name <> fnd_api.g_miss_char) THEN
503: x_role_id := cn_api.get_role_id(p_role_pmt_plan_rec_new.role_name);
504: IF (x_role_id IS NULL) THEN
505: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
506: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
507: fnd_message.set_token('ROLE_NAME',p_role_pmt_plan_rec_new.role_name);
508: fnd_msg_pub.ADD;
509: END IF;

Line 508: fnd_msg_pub.ADD;

504: IF (x_role_id IS NULL) THEN
505: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
506: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
507: fnd_message.set_token('ROLE_NAME',p_role_pmt_plan_rec_new.role_name);
508: fnd_msg_pub.ADD;
509: END IF;
510: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
511: RAISE fnd_api.g_exc_error;
512: END IF;

Line 519: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

515: FETCH l_old_cur INTO l_old_rec;
516: IF (l_old_cur%notfound) THEN
517: -- normally, this should not happen as the existance has
518: -- been validated previously
519: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
520: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');
521: fnd_msg_pub.ADD;
522: END IF;
523: x_loading_status := 'CN_RL_UPD_ROLE_PP_NOT_EXIST';

Line 521: fnd_msg_pub.ADD;

517: -- normally, this should not happen as the existance has
518: -- been validated previously
519: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
520: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');
521: fnd_msg_pub.ADD;
522: END IF;
523: x_loading_status := 'CN_RL_UPD_ROLE_PP_NOT_EXIST';
524: CLOSE l_old_cur;
525: RAISE fnd_api.g_exc_error;

Line 537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

533: -- new pmt_plan_name must exist in cn_pmt_plans
534: IF (p_role_pmt_plan_rec_new.pmt_plan_name <> fnd_api.g_miss_char) THEN
535: x_pmt_plan_id := cn_api.get_pp_id(p_role_pmt_plan_rec_new.pmt_plan_name,p_role_pmt_plan_rec_new.org_id);
536: IF (x_pmt_plan_id IS NULL) THEN
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
538: fnd_message.set_name ('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
539: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec_new.pmt_plan_name);
540: fnd_msg_pub.ADD;
541: END IF;

Line 540: fnd_msg_pub.ADD;

536: IF (x_pmt_plan_id IS NULL) THEN
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
538: fnd_message.set_name ('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
539: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec_new.pmt_plan_name);
540: fnd_msg_pub.ADD;
541: END IF;
542: x_loading_status := 'CN_RL_ASGN_PP_NOT_EXIST';
543: RAISE fnd_api.g_exc_error;
544: END IF;

Line 551: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

547: FETCH l_old_cur INTO l_old_rec;
548: IF (l_old_cur%notfound) THEN
549: -- normally, this should not happen as the existance has
550: -- been validated previously
551: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
552: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');
553: fnd_msg_pub.ADD;
554: END IF;
555: x_loading_status := 'CN_RL_UPD_ROLE_PP_NOT_EXIST';

Line 553: fnd_msg_pub.ADD;

549: -- normally, this should not happen as the existance has
550: -- been validated previously
551: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
552: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');
553: fnd_msg_pub.ADD;
554: END IF;
555: x_loading_status := 'CN_RL_UPD_ROLE_PP_NOT_EXIST';
556: CLOSE l_old_cur;
557: RAISE fnd_api.g_exc_error;

Line 579: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

575: IF NOT date_range_within(tmp_start_date,
576: tmp_end_date,
577: l_pp_rec.start_date,
578: l_pp_rec.end_date) THEN
579: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
580: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');
581: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
582: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
583: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);

Line 586: fnd_msg_pub.ADD;

582: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
583: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
584: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
585: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));
586: fnd_msg_pub.ADD;
587: END IF;
588: x_loading_status := 'CN_RL_PP_DATE_RANGE_NOT_WITHIN';
589: CLOSE l_pp_cur;
590: RAISE fnd_api.g_exc_error;

Line 596: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

592:
593: --bug 3560026 by Julia Huang on 4/7/04 -begin
594: IF ( tmp_start_date < l_pp_rec.start_date )
595: THEN
596: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
597: THEN
598: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');
599: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
600: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);

Line 604: fnd_msg_pub.ADD;

600: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
601: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
602: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
603: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));
604: fnd_msg_pub.ADD;
605: END IF;
606:
607: x_loading_status := 'CN_RL_PP_SD_LESS_THAN_PP_SD';
608: CLOSE l_pp_cur;

Line 625: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

621: IF cn_api.date_range_overlap(l_rec.start_date,
622: l_rec.end_date,
623: tmp_start_date,
624: tmp_end_date) THEN
625: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
626: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
627: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
628: fnd_message.set_token('START_DATE',l_rec.start_date);
629: fnd_message.set_token('END_DATE',l_rec.end_date);

Line 630: fnd_msg_pub.ADD;

626: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
627: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
628: fnd_message.set_token('START_DATE',l_rec.start_date);
629: fnd_message.set_token('END_DATE',l_rec.end_date);
630: fnd_msg_pub.ADD;
631: END IF;
632: x_loading_status := 'CN_RL_ROLE_PMT_PLAN_OVERLAP';
633: RAISE fnd_api.g_exc_error;
634: END IF;

Line 659: FND_MSG_PUB.Count_And_Get

655:
656: -- End of API body.
657:
658: -- Standard call to get message count and if count is 1, get message info.
659: FND_MSG_PUB.Count_And_Get
660: (
661: p_count => x_msg_count ,
662: p_data => x_msg_data ,
663: p_encoded => FND_API.G_FALSE

Line 669: FND_MSG_PUB.Count_And_Get

665:
666: EXCEPTION
667: WHEN FND_API.G_EXC_ERROR THEN
668: x_return_status := FND_API.G_RET_STS_ERROR ;
669: FND_MSG_PUB.Count_And_Get
670: (
671: p_count => x_msg_count ,
672: p_data => x_msg_data ,
673: p_encoded => FND_API.G_FALSE

Line 678: FND_MSG_PUB.Count_And_Get

674: );
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
677: x_loading_status := 'UNEXPECTED_ERR';
678: FND_MSG_PUB.Count_And_Get
679: (
680: p_count => x_msg_count ,
681: p_data => x_msg_data ,
682: p_encoded => FND_API.G_FALSE

Line 687: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

683: );
684: WHEN OTHERS THEN
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
686: x_loading_status := 'UNEXPECTED_ERR';
687: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
688: THEN
689: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
690: END IF;
691: FND_MSG_PUB.Count_And_Get

Line 689: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
686: x_loading_status := 'UNEXPECTED_ERR';
687: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
688: THEN
689: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
690: END IF;
691: FND_MSG_PUB.Count_And_Get
692: (
693: p_count => x_msg_count ,

Line 691: FND_MSG_PUB.Count_And_Get

687: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
688: THEN
689: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
690: END IF;
691: FND_MSG_PUB.Count_And_Get
692: (
693: p_count => x_msg_count ,
694: p_data => x_msg_data ,
695: p_encoded => FND_API.G_FALSE

Line 738: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

734: p_role_pmt_plan_rec.start_date,
735: p_role_pmt_plan_rec.end_date,
736: p_role_pmt_plan_rec.org_id);*/
737: IF (x_role_pmt_plan_id IS NULL) THEN
738: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
739: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PP_NOT_EXIST');
740: FND_MSG_PUB.Add;
741: END IF;
742: x_loading_status := 'CN_RL_DEL_ROLE_PP_NOT_EXIST';

Line 740: FND_MSG_PUB.Add;

736: p_role_pmt_plan_rec.org_id);*/
737: IF (x_role_pmt_plan_id IS NULL) THEN
738: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
739: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PP_NOT_EXIST');
740: FND_MSG_PUB.Add;
741: END IF;
742: x_loading_status := 'CN_RL_DEL_ROLE_PP_NOT_EXIST';
743: RAISE FND_API.G_EXC_ERROR ;
744: END IF;

Line 750: FND_MSG_PUB.Count_And_Get

746: -- End of API body.
747:
748: -- Standard call to get message count and if count is 1, get message info.
749:
750: FND_MSG_PUB.Count_And_Get
751: (
752: p_count => x_msg_count ,
753: p_data => x_msg_data ,
754: p_encoded => FND_API.G_FALSE

Line 760: FND_MSG_PUB.Count_And_Get

756:
757: EXCEPTION
758: WHEN FND_API.G_EXC_ERROR THEN
759: x_return_status := FND_API.G_RET_STS_ERROR ;
760: FND_MSG_PUB.Count_And_Get
761: (
762: p_count => x_msg_count ,
763: p_data => x_msg_data ,
764: p_encoded => FND_API.G_FALSE

Line 769: FND_MSG_PUB.Count_And_Get

765: );
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
768: x_loading_status := 'UNEXPECTED_ERR';
769: FND_MSG_PUB.Count_And_Get
770: (
771: p_count => x_msg_count ,
772: p_data => x_msg_data ,
773: p_encoded => FND_API.G_FALSE

Line 778: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

774: );
775: WHEN OTHERS THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
777: x_loading_status := 'UNEXPECTED_ERR';
778: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
779: THEN
780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
781: END IF;
782: FND_MSG_PUB.Count_And_Get

Line 780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
777: x_loading_status := 'UNEXPECTED_ERR';
778: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
779: THEN
780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
781: END IF;
782: FND_MSG_PUB.Count_And_Get
783: (
784: p_count => x_msg_count ,

Line 782: FND_MSG_PUB.Count_And_Get

778: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
779: THEN
780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
781: END IF;
782: FND_MSG_PUB.Count_And_Get
783: (
784: p_count => x_msg_count ,
785: p_data => x_msg_data ,
786: p_encoded => FND_API.G_FALSE

Line 880: fnd_msg_pub.initialize;

876:
877: IF (p_suppress_flag = 'Y') THEN
878: l_msg_count := 0;
879: l_msg_data := '';
880: fnd_msg_pub.initialize;
881: x_return_status := FND_API.G_RET_STS_SUCCESS;
882: ELSE
883: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
884: x_return_status := l_return_status;

Line 1101: FND_MSG_PUB.initialize;

1097: END IF;
1098:
1099: -- Initialize message list if p_init_msg_list is set to TRUE.
1100: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1101: FND_MSG_PUB.initialize;
1102: END IF;
1103:
1104: -- Initialize API return status to success
1105: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1190: FND_MSG_PUB.Count_And_Get

1186:
1187:
1188: -- Standard call to get message count and if count is 1, get message info.
1189:
1190: FND_MSG_PUB.Count_And_Get
1191: (
1192: p_count => x_msg_count ,
1193: p_data => x_msg_data ,
1194: p_encoded => FND_API.G_FALSE

Line 1201: FND_MSG_PUB.Count_And_Get

1197: EXCEPTION
1198: WHEN FND_API.G_EXC_ERROR THEN
1199: ROLLBACK TO create_role_pmt_plan;
1200: x_return_status := FND_API.G_RET_STS_ERROR ;
1201: FND_MSG_PUB.Count_And_Get
1202: (
1203: p_count => x_msg_count ,
1204: p_data => x_msg_data ,
1205: p_encoded => FND_API.G_FALSE

Line 1211: FND_MSG_PUB.Count_And_Get

1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: ROLLBACK TO create_role_pmt_plan;
1209: x_loading_status := 'UNEXPECTED_ERR';
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1211: FND_MSG_PUB.Count_And_Get
1212: (
1213: p_count => x_msg_count ,
1214: p_data => x_msg_data ,
1215: p_encoded => FND_API.G_FALSE

Line 1221: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1217: WHEN OTHERS THEN
1218: ROLLBACK TO create_role_pmt_plan;
1219: x_loading_status := 'UNEXPECTED_ERR';
1220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1221: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1222: THEN
1223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1224: END IF;
1225: FND_MSG_PUB.Count_And_Get

Line 1223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1219: x_loading_status := 'UNEXPECTED_ERR';
1220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1221: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1222: THEN
1223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1224: END IF;
1225: FND_MSG_PUB.Count_And_Get
1226: (
1227: p_count => x_msg_count ,

Line 1225: FND_MSG_PUB.Count_And_Get

1221: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1222: THEN
1223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1224: END IF;
1225: FND_MSG_PUB.Count_And_Get
1226: (
1227: p_count => x_msg_count ,
1228: p_data => x_msg_data ,
1229: p_encoded => FND_API.G_FALSE

Line 1282: FND_MSG_PUB.initialize;

1278: END IF;
1279:
1280: -- Initialize message list if p_init_msg_list is set to TRUE.
1281: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1282: FND_MSG_PUB.initialize;
1283: END IF;
1284:
1285: -- Initialize API return status to success
1286: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1379: FND_MSG_PUB.Count_And_Get

1375: END IF;
1376:
1377: -- Standard call to get message count and if count is 1, get message info.
1378:
1379: FND_MSG_PUB.Count_And_Get
1380: (
1381: p_count => x_msg_count ,
1382: p_data => x_msg_data ,
1383: p_encoded => FND_API.G_FALSE

Line 1390: FND_MSG_PUB.Count_And_Get

1386: EXCEPTION
1387: WHEN FND_API.G_EXC_ERROR THEN
1388: ROLLBACK TO update_role_pmt_plan;
1389: x_return_status := FND_API.G_RET_STS_ERROR ;
1390: FND_MSG_PUB.Count_And_Get
1391: (
1392: p_count => x_msg_count ,
1393: p_data => x_msg_data ,
1394: p_encoded => FND_API.G_FALSE

Line 1400: FND_MSG_PUB.Count_And_Get

1396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1397: ROLLBACK TO update_role_pmt_plan;
1398: x_loading_status := 'UNEXPECTED_ERR';
1399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1400: FND_MSG_PUB.Count_And_Get
1401: (
1402: p_count => x_msg_count ,
1403: p_data => x_msg_data ,
1404: p_encoded => FND_API.G_FALSE

Line 1410: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1406: WHEN OTHERS THEN
1407: ROLLBACK TO update_role_pmt_plan;
1408: x_loading_status := 'UNEXPECTED_ERR';
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1410: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1411: THEN
1412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1413: END IF;
1414: FND_MSG_PUB.Count_And_Get

Line 1412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1408: x_loading_status := 'UNEXPECTED_ERR';
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1410: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1411: THEN
1412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1413: END IF;
1414: FND_MSG_PUB.Count_And_Get
1415: (
1416: p_count => x_msg_count ,

Line 1414: FND_MSG_PUB.Count_And_Get

1410: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1411: THEN
1412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1413: END IF;
1414: FND_MSG_PUB.Count_And_Get
1415: (
1416: p_count => x_msg_count ,
1417: p_data => x_msg_data ,
1418: p_encoded => FND_API.G_FALSE

Line 1467: FND_MSG_PUB.initialize;

1463: END IF;
1464:
1465: -- Initialize message list if p_init_msg_list is set to TRUE.
1466: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1467: FND_MSG_PUB.initialize;
1468: END IF;
1469:
1470: -- Initialize API return status to success
1471: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1525: FND_MSG_PUB.Count_And_Get

1521:
1522:
1523: -- Standard call to get message count and if count is 1, get message info.
1524:
1525: FND_MSG_PUB.Count_And_Get
1526: (
1527: p_count => x_msg_count ,
1528: p_data => x_msg_data ,
1529: p_encoded => FND_API.G_FALSE

Line 1536: FND_MSG_PUB.Count_And_Get

1532: EXCEPTION
1533: WHEN FND_API.G_EXC_ERROR THEN
1534: ROLLBACK TO delete_role_pmt_plan;
1535: x_return_status := FND_API.G_RET_STS_ERROR ;
1536: FND_MSG_PUB.Count_And_Get
1537: (
1538: p_count => x_msg_count ,
1539: p_data => x_msg_data ,
1540: p_encoded => FND_API.G_FALSE

Line 1546: FND_MSG_PUB.Count_And_Get

1542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1543: ROLLBACK TO delete_role_pmt_plan;
1544: x_loading_status := 'UNEXPECTED_ERR';
1545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1546: FND_MSG_PUB.Count_And_Get
1547: (
1548: p_count => x_msg_count ,
1549: p_data => x_msg_data ,
1550: p_encoded => FND_API.G_FALSE

Line 1556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1552: WHEN OTHERS THEN
1553: ROLLBACK TO delete_role_pmt_plan;
1554: x_loading_status := 'UNEXPECTED_ERR';
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1557: THEN
1558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1559: END IF;
1560: FND_MSG_PUB.Count_And_Get

Line 1558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1554: x_loading_status := 'UNEXPECTED_ERR';
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1557: THEN
1558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1559: END IF;
1560: FND_MSG_PUB.Count_And_Get
1561: (
1562: p_count => x_msg_count ,

Line 1560: FND_MSG_PUB.Count_And_Get

1556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1557: THEN
1558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1559: END IF;
1560: FND_MSG_PUB.Count_And_Get
1561: (
1562: p_count => x_msg_count ,
1563: p_data => x_msg_data ,
1564: p_encoded => FND_API.G_FALSE