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_PLANS_PUB dependencies on FND_MSG_PUB

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

291:
292: -- role_name must exist in cn_roles
293: IF NOT valid_role_name (p_role_plan_rec.role_name)
294: THEN
295: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
296: THEN
297: fnd_message.set_name ('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
298: fnd_message.set_token ('ROLE_NAME', p_role_plan_rec.role_name);
299: fnd_msg_pub.ADD;

Line 299: fnd_msg_pub.ADD;

295: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
296: THEN
297: fnd_message.set_name ('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
298: fnd_message.set_token ('ROLE_NAME', p_role_plan_rec.role_name);
299: fnd_msg_pub.ADD;
300: END IF;
301:
302: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
303: RAISE fnd_api.g_exc_error;

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

310: IF NOT valid_comp_plan_name (p_role_plan_rec.comp_plan_name,
311: p_role_plan_rec.org_id
312: )
313: THEN
314: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
315: THEN
316: fnd_message.set_name ('CN', 'CN_RL_ASGN_CP_NOT_EXIST');
317: fnd_message.set_token ('COMP_PLAN',
318: p_role_plan_rec.comp_plan_name

Line 320: fnd_msg_pub.ADD;

316: fnd_message.set_name ('CN', 'CN_RL_ASGN_CP_NOT_EXIST');
317: fnd_message.set_token ('COMP_PLAN',
318: p_role_plan_rec.comp_plan_name
319: );
320: fnd_msg_pub.ADD;
321: END IF;
322:
323: x_loading_status := 'CN_RL_ASGN_CP_NOT_EXIST';
324: RAISE fnd_api.g_exc_error;

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

337:
338: IF (l_cp_cur%NOTFOUND)
339: THEN
340: -- normally this won't happen as it has been valided previously
341: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
342: THEN
343: fnd_message.set_name ('CN', 'CN_RL_ASGN_CP_NOT_EXIST');
344: fnd_message.set_token ('COMP_PLAN',
345: p_role_plan_rec.comp_plan_name

Line 347: fnd_msg_pub.ADD;

343: fnd_message.set_name ('CN', 'CN_RL_ASGN_CP_NOT_EXIST');
344: fnd_message.set_token ('COMP_PLAN',
345: p_role_plan_rec.comp_plan_name
346: );
347: fnd_msg_pub.ADD;
348: END IF;
349:
350: x_loading_status := 'CN_RL_ASGN_CP_NOT_EXIST';
351:

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

358: l_cp_rec.start_date,
359: l_cp_rec.end_date
360: )
361: THEN
362: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
363: THEN
364: fnd_message.set_name ('CN', 'CN_RL_CP_DATE_RANGE_NOT_WITHIN');
365: fnd_message.set_token ('START_DATE',
366: p_role_plan_rec.start_date

Line 374: fnd_msg_pub.ADD;

370: fnd_message.set_token ('CP_END_DATE', l_cp_rec.end_date);
371: fnd_message.set_token ('COMP_PLAN_NAME',
372: p_role_plan_rec.comp_plan_name
373: );
374: fnd_msg_pub.ADD;
375: END IF;
376:
377: x_loading_status := 'CN_RL_CP_DATE_RANGE_NOT_WITHIN';
378:

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

394: p_role_plan_rec.start_date,
395: p_role_plan_rec.end_date
396: )
397: THEN
398: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
399: THEN
400: fnd_message.set_name ('CN', 'CN_RL_ROLE_PLAN_OVERLAP');
401: fnd_message.set_token ('COMP_PLAN_NAME',
402: cn_api.get_cp_name (l_rec.comp_plan_id)

Line 406: fnd_msg_pub.ADD;

402: cn_api.get_cp_name (l_rec.comp_plan_id)
403: );
404: fnd_message.set_token ('START_DATE', l_rec.start_date);
405: fnd_message.set_token ('END_DATE', l_rec.end_date);
406: fnd_msg_pub.ADD;
407: END IF;
408:
409: x_loading_status := 'CN_RL_ROLE_PLAN_OVERLAP';
410: RAISE fnd_api.g_exc_error;

Line 417: fnd_msg_pub.count_and_get (p_count => x_msg_count,

413:
414: -- End of API body.
415:
416: -- Standard call to get message count and if count is 1, get message info.
417: fnd_msg_pub.count_and_get (p_count => x_msg_count,
418: p_data => x_msg_data,
419: p_encoded => fnd_api.g_false
420: );
421: EXCEPTION

Line 425: fnd_msg_pub.count_and_get (p_count => x_msg_count,

421: EXCEPTION
422: WHEN fnd_api.g_exc_error
423: THEN
424: x_return_status := fnd_api.g_ret_sts_error;
425: fnd_msg_pub.count_and_get (p_count => x_msg_count,
426: p_data => x_msg_data,
427: p_encoded => fnd_api.g_false
428: );
429: WHEN fnd_api.g_exc_unexpected_error

Line 433: fnd_msg_pub.count_and_get (p_count => x_msg_count,

429: WHEN fnd_api.g_exc_unexpected_error
430: THEN
431: x_return_status := fnd_api.g_ret_sts_unexp_error;
432: x_loading_status := 'UNEXPECTED_ERR';
433: fnd_msg_pub.count_and_get (p_count => x_msg_count,
434: p_data => x_msg_data,
435: p_encoded => fnd_api.g_false
436: );
437: WHEN OTHERS

Line 442: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

438: THEN
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: x_loading_status := 'UNEXPECTED_ERR';
441:
442: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
443: THEN
444: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
445: END IF;
446:

Line 444: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

440: x_loading_status := 'UNEXPECTED_ERR';
441:
442: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
443: THEN
444: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
445: END IF;
446:
447: fnd_msg_pub.count_and_get (p_count => x_msg_count,
448: p_data => x_msg_data,

Line 447: fnd_msg_pub.count_and_get (p_count => x_msg_count,

443: THEN
444: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
445: END IF;
446:
447: fnd_msg_pub.count_and_get (p_count => x_msg_count,
448: p_data => x_msg_data,
449: p_encoded => fnd_api.g_false
450: );
451: END check_valid_insert;

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

523: );
524:
525: IF (x_role_plan_id_old IS NULL)
526: THEN
527: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
528: THEN
529: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST');
530: fnd_msg_pub.ADD;
531: END IF;

Line 530: fnd_msg_pub.ADD;

526: THEN
527: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
528: THEN
529: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST');
530: fnd_msg_pub.ADD;
531: END IF;
532:
533: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
534: RAISE fnd_api.g_exc_error;

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

594: IF (l_old_cur%NOTFOUND)
595: THEN
596: -- normally, this should not happen as the existance has
597: -- been validated previously
598: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
599: THEN
600: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST');
601: fnd_msg_pub.ADD;
602: END IF;

Line 601: fnd_msg_pub.ADD;

597: -- been validated previously
598: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
599: THEN
600: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST');
601: fnd_msg_pub.ADD;
602: END IF;
603:
604: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
605:

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

622: END IF;
623:
624: IF (tmp_end_date IS NOT NULL) AND (tmp_start_date > tmp_end_date)
625: THEN
626: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
627: THEN
628: fnd_message.set_name ('CN', 'CN_RL_INVALID_DATE_RANGE');
629: fnd_message.set_token ('START_DATE', tmp_start_date);
630: fnd_message.set_token ('END_DATE', tmp_end_date);

Line 631: fnd_msg_pub.ADD;

627: THEN
628: fnd_message.set_name ('CN', 'CN_RL_INVALID_DATE_RANGE');
629: fnd_message.set_token ('START_DATE', tmp_start_date);
630: fnd_message.set_token ('END_DATE', tmp_end_date);
631: fnd_msg_pub.ADD;
632: END IF;
633:
634: x_loading_status := 'CN_RL_INVALID_DATE_RANGE';
635:

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

647: -- operation to get it back in sync). the user needs to make the necessary
648: -- changes in SFP and reapply the push.
649: IF NVL (l_old_rec.create_module, 'OSC') = 'SFP'
650: THEN
651: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
652: THEN
653: fnd_message.set_name ('CN', 'CN_RP_CREATED_IN_SFP');
654: fnd_msg_pub.ADD;
655: END IF;

Line 654: fnd_msg_pub.ADD;

650: THEN
651: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
652: THEN
653: fnd_message.set_name ('CN', 'CN_RP_CREATED_IN_SFP');
654: fnd_msg_pub.ADD;
655: END IF;
656:
657: x_loading_status := 'CN_RP_CREATED_IN_SFP';
658: RAISE fnd_api.g_exc_error;

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

664: x_role_id := cn_api.get_role_id (p_role_plan_rec_new.role_name);
665:
666: IF (x_role_id IS NULL)
667: THEN
668: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
669: THEN
670: fnd_message.set_name ('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
671: fnd_message.set_token ('ROLE_NAME',
672: p_role_plan_rec_new.role_name

Line 674: fnd_msg_pub.ADD;

670: fnd_message.set_name ('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
671: fnd_message.set_token ('ROLE_NAME',
672: p_role_plan_rec_new.role_name
673: );
674: fnd_msg_pub.ADD;
675: END IF;
676:
677: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
678: RAISE fnd_api.g_exc_error;

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

686: IF (l_old_cur%NOTFOUND)
687: THEN
688: -- normally, this should not happen as the existance has
689: -- been validated previously
690: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
691: THEN
692: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST');
693: fnd_msg_pub.ADD;
694: END IF;

Line 693: fnd_msg_pub.ADD;

689: -- been validated previously
690: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
691: THEN
692: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST');
693: fnd_msg_pub.ADD;
694: END IF;
695:
696: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
697:

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

715: );
716:
717: IF (x_comp_plan_id IS NULL)
718: THEN
719: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
720: THEN
721: fnd_message.set_name ('CN', 'CN_RL_ASGN_CP_NOT_EXIST');
722: fnd_message.set_token ('COMP_PLAN',
723: p_role_plan_rec_new.comp_plan_name

Line 725: fnd_msg_pub.ADD;

721: fnd_message.set_name ('CN', 'CN_RL_ASGN_CP_NOT_EXIST');
722: fnd_message.set_token ('COMP_PLAN',
723: p_role_plan_rec_new.comp_plan_name
724: );
725: fnd_msg_pub.ADD;
726: END IF;
727:
728: x_loading_status := 'CN_RL_ASGN_CP_NOT_EXIST';
729: RAISE fnd_api.g_exc_error;

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

737: IF (l_old_cur%NOTFOUND)
738: THEN
739: -- normally, this should not happen as the existance has
740: -- been validated previously
741: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
742: THEN
743: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST');
744: fnd_msg_pub.ADD;
745: END IF;

Line 744: fnd_msg_pub.ADD;

740: -- been validated previously
741: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
742: THEN
743: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST');
744: fnd_msg_pub.ADD;
745: END IF;
746:
747: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
748:

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

776: l_cp_rec.start_date,
777: l_cp_rec.end_date
778: )
779: THEN
780: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
781: THEN
782: fnd_message.set_name ('CN', 'CN_RL_CP_DATE_RANGE_NOT_WITHIN');
783: fnd_message.set_token ('START_DATE', tmp_start_date);
784: fnd_message.set_token ('END_DATE', tmp_end_date);

Line 790: fnd_msg_pub.ADD;

786: fnd_message.set_token ('CP_END_DATE', l_cp_rec.end_date);
787: fnd_message.set_token ('COMP_PLAN_NAME',
788: cn_api.get_cp_name (x_comp_plan_id)
789: );
790: fnd_msg_pub.ADD;
791: END IF;
792:
793: x_loading_status := 'CN_RL_CP_DATE_RANGE_NOT_WITHIN';
794:

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

813: tmp_start_date,
814: tmp_end_date
815: )
816: THEN
817: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
818: THEN
819: fnd_message.set_name ('CN', 'CN_RL_ROLE_PLAN_OVERLAP');
820: fnd_message.set_token ('COMP_PLAN_NAME',
821: cn_api.get_cp_name (l_rec.comp_plan_id)

Line 825: fnd_msg_pub.ADD;

821: cn_api.get_cp_name (l_rec.comp_plan_id)
822: );
823: fnd_message.set_token ('START_DATE', l_rec.start_date);
824: fnd_message.set_token ('END_DATE', l_rec.end_date);
825: fnd_msg_pub.ADD;
826: END IF;
827:
828: x_loading_status := 'CN_RL_ROLE_PLAN_OVERLAP';
829: RAISE fnd_api.g_exc_error;

Line 864: fnd_msg_pub.count_and_get (p_count => x_msg_count,

860:
861: -- End of API body.
862:
863: -- Standard call to get message count and if count is 1, get message info.
864: fnd_msg_pub.count_and_get (p_count => x_msg_count,
865: p_data => x_msg_data,
866: p_encoded => fnd_api.g_false
867: );
868: EXCEPTION

Line 872: fnd_msg_pub.count_and_get (p_count => x_msg_count,

868: EXCEPTION
869: WHEN fnd_api.g_exc_error
870: THEN
871: x_return_status := fnd_api.g_ret_sts_error;
872: fnd_msg_pub.count_and_get (p_count => x_msg_count,
873: p_data => x_msg_data,
874: p_encoded => fnd_api.g_false
875: );
876: WHEN fnd_api.g_exc_unexpected_error

Line 880: fnd_msg_pub.count_and_get (p_count => x_msg_count,

876: WHEN fnd_api.g_exc_unexpected_error
877: THEN
878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: x_loading_status := 'UNEXPECTED_ERR';
880: fnd_msg_pub.count_and_get (p_count => x_msg_count,
881: p_data => x_msg_data,
882: p_encoded => fnd_api.g_false
883: );
884: WHEN OTHERS

Line 889: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

885: THEN
886: x_return_status := fnd_api.g_ret_sts_unexp_error;
887: x_loading_status := 'UNEXPECTED_ERR';
888:
889: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
890: THEN
891: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
892: END IF;
893:

Line 891: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

887: x_loading_status := 'UNEXPECTED_ERR';
888:
889: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
890: THEN
891: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
892: END IF;
893:
894: fnd_msg_pub.count_and_get (p_count => x_msg_count,
895: p_data => x_msg_data,

Line 894: fnd_msg_pub.count_and_get (p_count => x_msg_count,

890: THEN
891: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
892: END IF;
893:
894: fnd_msg_pub.count_and_get (p_count => x_msg_count,
895: p_data => x_msg_data,
896: p_encoded => fnd_api.g_false
897: );
898: END check_valid_update;

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

931: );
932:
933: IF (x_role_plan_id IS NULL)
934: THEN
935: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
936: THEN
937: fnd_message.set_name ('CN', 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST');
938: fnd_msg_pub.ADD;
939: END IF;

Line 938: fnd_msg_pub.ADD;

934: THEN
935: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
936: THEN
937: fnd_message.set_name ('CN', 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST');
938: fnd_msg_pub.ADD;
939: END IF;
940:
941: x_loading_status := 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST';
942: RAISE fnd_api.g_exc_error;

Line 948: fnd_msg_pub.count_and_get (p_count => x_msg_count,

944:
945: -- End of API body.
946:
947: -- Standard call to get message count and if count is 1, get message info.
948: fnd_msg_pub.count_and_get (p_count => x_msg_count,
949: p_data => x_msg_data,
950: p_encoded => fnd_api.g_false
951: );
952: EXCEPTION

Line 956: fnd_msg_pub.count_and_get (p_count => x_msg_count,

952: EXCEPTION
953: WHEN fnd_api.g_exc_error
954: THEN
955: x_return_status := fnd_api.g_ret_sts_error;
956: fnd_msg_pub.count_and_get (p_count => x_msg_count,
957: p_data => x_msg_data,
958: p_encoded => fnd_api.g_false
959: );
960: WHEN fnd_api.g_exc_unexpected_error

Line 964: fnd_msg_pub.count_and_get (p_count => x_msg_count,

960: WHEN fnd_api.g_exc_unexpected_error
961: THEN
962: x_return_status := fnd_api.g_ret_sts_unexp_error;
963: x_loading_status := 'UNEXPECTED_ERR';
964: fnd_msg_pub.count_and_get (p_count => x_msg_count,
965: p_data => x_msg_data,
966: p_encoded => fnd_api.g_false
967: );
968: WHEN OTHERS

Line 973: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

969: THEN
970: x_return_status := fnd_api.g_ret_sts_unexp_error;
971: x_loading_status := 'UNEXPECTED_ERR';
972:
973: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
974: THEN
975: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
976: END IF;
977:

Line 975: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

971: x_loading_status := 'UNEXPECTED_ERR';
972:
973: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
974: THEN
975: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
976: END IF;
977:
978: fnd_msg_pub.count_and_get (p_count => x_msg_count,
979: p_data => x_msg_data,

Line 978: fnd_msg_pub.count_and_get (p_count => x_msg_count,

974: THEN
975: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
976: END IF;
977:
978: fnd_msg_pub.count_and_get (p_count => x_msg_count,
979: p_data => x_msg_data,
980: p_encoded => fnd_api.g_false
981: );
982: END check_valid_delete;

Line 1288: fnd_msg_pub.initialize;

1284:
1285: -- Initialize message list if p_init_msg_list is set to TRUE.
1286: IF fnd_api.to_boolean (p_init_msg_list)
1287: THEN
1288: fnd_msg_pub.initialize;
1289: END IF;
1290:
1291: -- Initialize API return status to success
1292: x_return_status := fnd_api.g_ret_sts_success;

Line 1605: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1601: COMMIT WORK;
1602: END IF;
1603:
1604: -- Standard call to get message count and if count is 1, get message info.
1605: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1606: p_data => x_msg_data,
1607: p_encoded => fnd_api.g_false
1608: );
1609: EXCEPTION

Line 1614: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1610: WHEN fnd_api.g_exc_error
1611: THEN
1612: ROLLBACK TO create_role_plan;
1613: x_return_status := fnd_api.g_ret_sts_error;
1614: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1615: p_data => x_msg_data,
1616: p_encoded => fnd_api.g_false
1617: );
1618: WHEN fnd_api.g_exc_unexpected_error

Line 1623: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1619: THEN
1620: ROLLBACK TO create_role_plan;
1621: x_loading_status := 'UNEXPECTED_ERR';
1622: x_return_status := fnd_api.g_ret_sts_unexp_error;
1623: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1624: p_data => x_msg_data,
1625: p_encoded => fnd_api.g_false
1626: );
1627: WHEN OTHERS

Line 1633: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1629: ROLLBACK TO create_role_plan;
1630: x_loading_status := 'UNEXPECTED_ERR';
1631: x_return_status := fnd_api.g_ret_sts_unexp_error;
1632:
1633: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1634: THEN
1635: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1636: END IF;
1637:

Line 1635: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1631: x_return_status := fnd_api.g_ret_sts_unexp_error;
1632:
1633: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1634: THEN
1635: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1636: END IF;
1637:
1638: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1639: p_data => x_msg_data,

Line 1638: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1634: THEN
1635: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1636: END IF;
1637:
1638: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1639: p_data => x_msg_data,
1640: p_encoded => fnd_api.g_false
1641: );
1642: END create_role_plan;

Line 1701: fnd_msg_pub.initialize;

1697:
1698: -- Initialize message list if p_init_msg_list is set to TRUE.
1699: IF fnd_api.to_boolean (p_init_msg_list)
1700: THEN
1701: fnd_msg_pub.initialize;
1702: END IF;
1703:
1704: -- Initialize API return status to success
1705: x_return_status := fnd_api.g_ret_sts_success;

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

1765: 'cn.plsql.cn_role_plans_pub.update_role_plan.error',
1766: true);
1767: end if;
1768:
1769: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1770: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
1771: FND_MSG_PUB.Add;
1772: END IF;
1773:

Line 1771: FND_MSG_PUB.Add;

1767: end if;
1768:
1769: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1770: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
1771: FND_MSG_PUB.Add;
1772: END IF;
1773:
1774: RAISE FND_API.G_EXC_ERROR ;
1775: end if;

Line 2288: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2284: COMMIT WORK;
2285: END IF;
2286:
2287: -- Standard call to get message count and if count is 1, get message info.
2288: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2289: p_data => x_msg_data,
2290: p_encoded => fnd_api.g_false
2291: );
2292: EXCEPTION

Line 2297: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2293: WHEN fnd_api.g_exc_error
2294: THEN
2295: ROLLBACK TO update_role_plan;
2296: x_return_status := fnd_api.g_ret_sts_error;
2297: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2298: p_data => x_msg_data,
2299: p_encoded => fnd_api.g_false
2300: );
2301: WHEN fnd_api.g_exc_unexpected_error

Line 2306: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2302: THEN
2303: ROLLBACK TO update_role_plan;
2304: x_loading_status := 'UNEXPECTED_ERR';
2305: x_return_status := fnd_api.g_ret_sts_unexp_error;
2306: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2307: p_data => x_msg_data,
2308: p_encoded => fnd_api.g_false
2309: );
2310: WHEN OTHERS

Line 2316: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2312: ROLLBACK TO update_role_plan;
2313: x_loading_status := 'UNEXPECTED_ERR';
2314: x_return_status := fnd_api.g_ret_sts_unexp_error;
2315:
2316: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2317: THEN
2318: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2319: END IF;
2320:

Line 2318: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2314: x_return_status := fnd_api.g_ret_sts_unexp_error;
2315:
2316: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2317: THEN
2318: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2319: END IF;
2320:
2321: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2322: p_data => x_msg_data,

Line 2321: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2317: THEN
2318: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2319: END IF;
2320:
2321: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2322: p_data => x_msg_data,
2323: p_encoded => fnd_api.g_false
2324: );
2325: END update_role_plan;

Line 2373: fnd_msg_pub.initialize;

2369:
2370: -- Initialize message list if p_init_msg_list is set to TRUE.
2371: IF fnd_api.to_boolean (p_init_msg_list)
2372: THEN
2373: fnd_msg_pub.initialize;
2374: END IF;
2375:
2376: -- Initialize API return status to success
2377: x_return_status := fnd_api.g_ret_sts_success;

Line 2674: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2670: COMMIT WORK;
2671: END IF;
2672:
2673: -- Standard call to get message count and if count is 1, get message info.
2674: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2675: p_data => x_msg_data,
2676: p_encoded => fnd_api.g_false
2677: );
2678: EXCEPTION

Line 2683: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2679: WHEN fnd_api.g_exc_error
2680: THEN
2681: ROLLBACK TO delete_role_plan;
2682: x_return_status := fnd_api.g_ret_sts_error;
2683: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2684: p_data => x_msg_data,
2685: p_encoded => fnd_api.g_false
2686: );
2687: WHEN fnd_api.g_exc_unexpected_error

Line 2692: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2688: THEN
2689: ROLLBACK TO delete_role_plan;
2690: x_loading_status := 'UNEXPECTED_ERR';
2691: x_return_status := fnd_api.g_ret_sts_unexp_error;
2692: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2693: p_data => x_msg_data,
2694: p_encoded => fnd_api.g_false
2695: );
2696: WHEN OTHERS

Line 2702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2698: ROLLBACK TO delete_role_plan;
2699: x_loading_status := 'UNEXPECTED_ERR';
2700: x_return_status := fnd_api.g_ret_sts_unexp_error;
2701:
2702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2703: THEN
2704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2705: END IF;
2706:

Line 2704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2700: x_return_status := fnd_api.g_ret_sts_unexp_error;
2701:
2702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2703: THEN
2704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2705: END IF;
2706:
2707: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2708: p_data => x_msg_data,

Line 2707: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2703: THEN
2704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2705: END IF;
2706:
2707: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2708: p_data => x_msg_data,
2709: p_encoded => fnd_api.g_false
2710: );
2711: END delete_role_plan;