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;
300: END IF;
301:
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;
300: END IF;
301:
302: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
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
319: );
320: fnd_msg_pub.ADD;
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
319: );
320: fnd_msg_pub.ADD;
321: END IF;
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
346: );
347: fnd_msg_pub.ADD;
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
346: );
347: fnd_msg_pub.ADD;
348: END IF;
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
367: );
368: fnd_message.set_token ('END_DATE', p_role_plan_rec.end_date);
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
367: );
368: fnd_message.set_token ('END_DATE', p_role_plan_rec.end_date);
369: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);
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
367: );
368: fnd_message.set_token ('END_DATE', p_role_plan_rec.end_date);
369: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);
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
365: fnd_message.set_token ('START_DATE',
366: p_role_plan_rec.start_date
367: );
368: fnd_message.set_token ('END_DATE', p_role_plan_rec.end_date);
369: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);
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: );
366: p_role_plan_rec.start_date
367: );
368: fnd_message.set_token ('END_DATE', p_role_plan_rec.end_date);
369: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);
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;
367: );
368: fnd_message.set_token ('END_DATE', p_role_plan_rec.end_date);
369: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);
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;
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)
403: );
404: fnd_message.set_token ('START_DATE', l_rec.start_date);
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)
403: );
404: fnd_message.set_token ('START_DATE', l_rec.start_date);
405: fnd_message.set_token ('END_DATE', l_rec.end_date);
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)
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:
401: fnd_message.set_token ('COMP_PLAN_NAME',
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';
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;
532:
533: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
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;
603:
604: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
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);
631: fnd_msg_pub.ADD;
632: END IF;
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);
631: fnd_msg_pub.ADD;
632: END IF;
633:
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);
631: fnd_msg_pub.ADD;
632: END IF;
633:
634: x_loading_status := 'CN_RL_INVALID_DATE_RANGE';
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;
656:
657: x_loading_status := 'CN_RP_CREATED_IN_SFP';
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
673: );
674: fnd_msg_pub.ADD;
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
673: );
674: fnd_msg_pub.ADD;
675: END IF;
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;
695:
696: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
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
724: );
725: fnd_msg_pub.ADD;
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
724: );
725: fnd_msg_pub.ADD;
726: END IF;
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;
746:
747: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
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);
785: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);
786: fnd_message.set_token ('CP_END_DATE', l_cp_rec.end_date);
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);
785: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);
786: fnd_message.set_token ('CP_END_DATE', l_cp_rec.end_date);
787: fnd_message.set_token ('COMP_PLAN_NAME',
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);
785: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);
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)
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);
785: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);
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: );
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);
785: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);
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;
783: fnd_message.set_token ('START_DATE', tmp_start_date);
784: fnd_message.set_token ('END_DATE', tmp_end_date);
785: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);
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;
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)
822: );
823: fnd_message.set_token ('START_DATE', l_rec.start_date);
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)
822: );
823: fnd_message.set_token ('START_DATE', l_rec.start_date);
824: fnd_message.set_token ('END_DATE', l_rec.end_date);
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)
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:
820: fnd_message.set_token ('COMP_PLAN_NAME',
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';
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;
940:
941: x_loading_status := 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST';
1441: x_object_version_number => l_object_version_number
1442: );
1443:
1444: /* System Generated - Create Note Functionality */
1445: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1446: fnd_message.set_token ('NEWVALUE', l_rec.role_name);
1447: fnd_message.set_token ('NAME', l_rec.comp_plan_name);
1448: l_note_msg := fnd_message.get;
1449: jtf_notes_pub.create_note
1442: );
1443:
1444: /* System Generated - Create Note Functionality */
1445: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1446: fnd_message.set_token ('NEWVALUE', l_rec.role_name);
1447: fnd_message.set_token ('NAME', l_rec.comp_plan_name);
1448: l_note_msg := fnd_message.get;
1449: jtf_notes_pub.create_note
1450: (p_api_version => 1.0,
1443:
1444: /* System Generated - Create Note Functionality */
1445: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1446: fnd_message.set_token ('NEWVALUE', l_rec.role_name);
1447: fnd_message.set_token ('NAME', l_rec.comp_plan_name);
1448: l_note_msg := fnd_message.get;
1449: jtf_notes_pub.create_note
1450: (p_api_version => 1.0,
1451: x_return_status => x_return_status,
1444: /* System Generated - Create Note Functionality */
1445: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1446: fnd_message.set_token ('NEWVALUE', l_rec.role_name);
1447: fnd_message.set_token ('NAME', l_rec.comp_plan_name);
1448: l_note_msg := fnd_message.get;
1449: jtf_notes_pub.create_note
1450: (p_api_version => 1.0,
1451: x_return_status => x_return_status,
1452: x_msg_count => x_msg_count,
1758: end if;
1759:
1760: if (nvl(p_role_plan_rec_new.org_id, l_org_id)
1761: <> nvl(l_rec_old.org_id, l_org_id)) then
1762: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
1763: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1764: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
1765: 'cn.plsql.cn_role_plans_pub.update_role_plan.error',
1766: true);
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:
1774: RAISE FND_API.G_EXC_ERROR ;
1917: AND l_rec_old.role_name <> fnd_api.g_miss_char AND l_rec_old.role_name IS NOT NULL
1918: AND l_rec_new.role_name <> l_rec_old.role_name)
1919: THEN
1920: --Notes for Old Role being unassigned
1921: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
1922: fnd_message.set_token ('NEWVALUE', l_rec_old.role_name);
1923: fnd_message.set_token ('NAME', l_rec_old.comp_plan_name);
1924: l_note_msg := fnd_message.get;
1925: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1918: AND l_rec_new.role_name <> l_rec_old.role_name)
1919: THEN
1920: --Notes for Old Role being unassigned
1921: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
1922: fnd_message.set_token ('NEWVALUE', l_rec_old.role_name);
1923: fnd_message.set_token ('NAME', l_rec_old.comp_plan_name);
1924: l_note_msg := fnd_message.get;
1925: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1926: /*
1919: THEN
1920: --Notes for Old Role being unassigned
1921: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
1922: fnd_message.set_token ('NEWVALUE', l_rec_old.role_name);
1923: fnd_message.set_token ('NAME', l_rec_old.comp_plan_name);
1924: l_note_msg := fnd_message.get;
1925: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1926: /*
1927: jtf_notes_pub.create_note
1920: --Notes for Old Role being unassigned
1921: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
1922: fnd_message.set_token ('NEWVALUE', l_rec_old.role_name);
1923: fnd_message.set_token ('NAME', l_rec_old.comp_plan_name);
1924: l_note_msg := fnd_message.get;
1925: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1926: /*
1927: jtf_notes_pub.create_note
1928: (p_api_version => 1.0,
1937: x_jtf_note_id => l_note_id -- returned
1938: );
1939: */
1940: --Notes for New Role being assigned
1941: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1942: fnd_message.set_token ('NEWVALUE', l_rec_new.role_name);
1943: fnd_message.set_token ('NAME', l_rec_new.comp_plan_name);
1944: l_note_msg := fnd_message.get;
1945: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1938: );
1939: */
1940: --Notes for New Role being assigned
1941: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1942: fnd_message.set_token ('NEWVALUE', l_rec_new.role_name);
1943: fnd_message.set_token ('NAME', l_rec_new.comp_plan_name);
1944: l_note_msg := fnd_message.get;
1945: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1946: /*
1939: */
1940: --Notes for New Role being assigned
1941: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1942: fnd_message.set_token ('NEWVALUE', l_rec_new.role_name);
1943: fnd_message.set_token ('NAME', l_rec_new.comp_plan_name);
1944: l_note_msg := fnd_message.get;
1945: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1946: /*
1947: jtf_notes_pub.create_note
1940: --Notes for New Role being assigned
1941: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1942: fnd_message.set_token ('NEWVALUE', l_rec_new.role_name);
1943: fnd_message.set_token ('NAME', l_rec_new.comp_plan_name);
1944: l_note_msg := fnd_message.get;
1945: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1946: /*
1947: jtf_notes_pub.create_note
1948: (p_api_version => 1.0,
1961: AND l_rec_old.comp_plan_name <> fnd_api.g_miss_char AND l_rec_old.comp_plan_name IS NOT NULL
1962: AND l_rec_new.comp_plan_name <> l_rec_old.comp_plan_name)
1963: THEN
1964: --Notes for Role being unassigned from Old Compplan
1965: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
1966: fnd_message.set_token ('NEWVALUE', l_rec_old.role_name);
1967: fnd_message.set_token ('NAME', l_rec_old.comp_plan_name);
1968: l_note_msg := fnd_message.get;
1969: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1962: AND l_rec_new.comp_plan_name <> l_rec_old.comp_plan_name)
1963: THEN
1964: --Notes for Role being unassigned from Old Compplan
1965: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
1966: fnd_message.set_token ('NEWVALUE', l_rec_old.role_name);
1967: fnd_message.set_token ('NAME', l_rec_old.comp_plan_name);
1968: l_note_msg := fnd_message.get;
1969: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1970: /*
1963: THEN
1964: --Notes for Role being unassigned from Old Compplan
1965: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
1966: fnd_message.set_token ('NEWVALUE', l_rec_old.role_name);
1967: fnd_message.set_token ('NAME', l_rec_old.comp_plan_name);
1968: l_note_msg := fnd_message.get;
1969: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1970: /*
1971: jtf_notes_pub.create_note
1964: --Notes for Role being unassigned from Old Compplan
1965: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
1966: fnd_message.set_token ('NEWVALUE', l_rec_old.role_name);
1967: fnd_message.set_token ('NAME', l_rec_old.comp_plan_name);
1968: l_note_msg := fnd_message.get;
1969: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1970: /*
1971: jtf_notes_pub.create_note
1972: (p_api_version => 1.0,
1981: x_jtf_note_id => l_note_id -- returned
1982: );
1983: */
1984: --Notes for Role being assigned to New Compplan
1985: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1986: fnd_message.set_token ('NEWVALUE', l_rec_new.role_name);
1987: fnd_message.set_token ('NAME', l_rec_new.comp_plan_name);
1988: l_note_msg := fnd_message.get;
1989: l_consolidated_note_new := l_consolidated_note_new || l_note_msg || fnd_global.local_chr(10);
1982: );
1983: */
1984: --Notes for Role being assigned to New Compplan
1985: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1986: fnd_message.set_token ('NEWVALUE', l_rec_new.role_name);
1987: fnd_message.set_token ('NAME', l_rec_new.comp_plan_name);
1988: l_note_msg := fnd_message.get;
1989: l_consolidated_note_new := l_consolidated_note_new || l_note_msg || fnd_global.local_chr(10);
1990: /*
1983: */
1984: --Notes for Role being assigned to New Compplan
1985: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1986: fnd_message.set_token ('NEWVALUE', l_rec_new.role_name);
1987: fnd_message.set_token ('NAME', l_rec_new.comp_plan_name);
1988: l_note_msg := fnd_message.get;
1989: l_consolidated_note_new := l_consolidated_note_new || l_note_msg || fnd_global.local_chr(10);
1990: /*
1991: jtf_notes_pub.create_note
1984: --Notes for Role being assigned to New Compplan
1985: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1986: fnd_message.set_token ('NEWVALUE', l_rec_new.role_name);
1987: fnd_message.set_token ('NAME', l_rec_new.comp_plan_name);
1988: l_note_msg := fnd_message.get;
1989: l_consolidated_note_new := l_consolidated_note_new || l_note_msg || fnd_global.local_chr(10);
1990: /*
1991: jtf_notes_pub.create_note
1992: (p_api_version => 1.0,
2003: */
2004: ELSE IF (l_rec_new.start_date <> l_rec_old.start_date)
2005: THEN
2006: --Notes for changing start date for RolePlan assignment
2007: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_START_DATE_UPD');
2008: fnd_message.set_token ('OLDVALUE', l_rec_old.start_date);
2009: fnd_message.set_token ('NEWVALUE', l_rec_new.start_date);
2010: fnd_message.set_token ('NAME', l_rec_new.role_name);
2011: l_note_msg := fnd_message.get;
2004: ELSE IF (l_rec_new.start_date <> l_rec_old.start_date)
2005: THEN
2006: --Notes for changing start date for RolePlan assignment
2007: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_START_DATE_UPD');
2008: fnd_message.set_token ('OLDVALUE', l_rec_old.start_date);
2009: fnd_message.set_token ('NEWVALUE', l_rec_new.start_date);
2010: fnd_message.set_token ('NAME', l_rec_new.role_name);
2011: l_note_msg := fnd_message.get;
2012: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2005: THEN
2006: --Notes for changing start date for RolePlan assignment
2007: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_START_DATE_UPD');
2008: fnd_message.set_token ('OLDVALUE', l_rec_old.start_date);
2009: fnd_message.set_token ('NEWVALUE', l_rec_new.start_date);
2010: fnd_message.set_token ('NAME', l_rec_new.role_name);
2011: l_note_msg := fnd_message.get;
2012: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2013: /*
2006: --Notes for changing start date for RolePlan assignment
2007: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_START_DATE_UPD');
2008: fnd_message.set_token ('OLDVALUE', l_rec_old.start_date);
2009: fnd_message.set_token ('NEWVALUE', l_rec_new.start_date);
2010: fnd_message.set_token ('NAME', l_rec_new.role_name);
2011: l_note_msg := fnd_message.get;
2012: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2013: /*
2014: jtf_notes_pub.create_note
2007: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_START_DATE_UPD');
2008: fnd_message.set_token ('OLDVALUE', l_rec_old.start_date);
2009: fnd_message.set_token ('NEWVALUE', l_rec_new.start_date);
2010: fnd_message.set_token ('NAME', l_rec_new.role_name);
2011: l_note_msg := fnd_message.get;
2012: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2013: /*
2014: jtf_notes_pub.create_note
2015: (p_api_version => 1.0,
2028: IF ((l_rec_old.end_date is null OR l_rec_old.end_date = fnd_api.G_MISS_DATE)
2029: AND (l_rec_new.end_date is not null AND l_rec_new.end_date <> fnd_api.G_MISS_DATE))
2030: THEN
2031: --Notes for setting end date for RolePlan assignment
2032: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_NULL_UPD');
2033: fnd_message.set_token ('NEWVALUE', l_rec_new.end_date);
2034: fnd_message.set_token ('NAME', l_rec_new.role_name);
2035: l_note_msg := fnd_message.get;
2036: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2029: AND (l_rec_new.end_date is not null AND l_rec_new.end_date <> fnd_api.G_MISS_DATE))
2030: THEN
2031: --Notes for setting end date for RolePlan assignment
2032: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_NULL_UPD');
2033: fnd_message.set_token ('NEWVALUE', l_rec_new.end_date);
2034: fnd_message.set_token ('NAME', l_rec_new.role_name);
2035: l_note_msg := fnd_message.get;
2036: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2037: /*
2030: THEN
2031: --Notes for setting end date for RolePlan assignment
2032: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_NULL_UPD');
2033: fnd_message.set_token ('NEWVALUE', l_rec_new.end_date);
2034: fnd_message.set_token ('NAME', l_rec_new.role_name);
2035: l_note_msg := fnd_message.get;
2036: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2037: /*
2038: jtf_notes_pub.create_note
2031: --Notes for setting end date for RolePlan assignment
2032: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_NULL_UPD');
2033: fnd_message.set_token ('NEWVALUE', l_rec_new.end_date);
2034: fnd_message.set_token ('NAME', l_rec_new.role_name);
2035: l_note_msg := fnd_message.get;
2036: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2037: /*
2038: jtf_notes_pub.create_note
2039: (p_api_version => 1.0,
2051: ELSE IF ((l_rec_new.end_date is null OR l_rec_new.end_date = fnd_api.G_MISS_DATE)
2052: AND (l_rec_old.end_date is not null AND l_rec_old.end_date <> fnd_api.G_MISS_DATE))
2053: THEN
2054: --Notes for removing end date for RolePlan assignment
2055: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD_NULL');
2056: fnd_message.set_token ('NAME', l_rec_new.role_name);
2057: l_note_msg := fnd_message.get;
2058: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2059: /*
2052: AND (l_rec_old.end_date is not null AND l_rec_old.end_date <> fnd_api.G_MISS_DATE))
2053: THEN
2054: --Notes for removing end date for RolePlan assignment
2055: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD_NULL');
2056: fnd_message.set_token ('NAME', l_rec_new.role_name);
2057: l_note_msg := fnd_message.get;
2058: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2059: /*
2060: jtf_notes_pub.create_note
2053: THEN
2054: --Notes for removing end date for RolePlan assignment
2055: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD_NULL');
2056: fnd_message.set_token ('NAME', l_rec_new.role_name);
2057: l_note_msg := fnd_message.get;
2058: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2059: /*
2060: jtf_notes_pub.create_note
2061: (p_api_version => 1.0,
2073:
2074: ELSE IF (l_rec_new.end_date <> l_rec_old.end_date)
2075: THEN
2076: --Notes for changing end date for RolePlan assignment
2077: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD');
2078: fnd_message.set_token ('OLDVALUE', l_rec_old.end_date);
2079: fnd_message.set_token ('NEWVALUE', l_rec_new.end_date);
2080: fnd_message.set_token ('NAME', l_rec_new.role_name);
2081: l_note_msg := fnd_message.get;
2074: ELSE IF (l_rec_new.end_date <> l_rec_old.end_date)
2075: THEN
2076: --Notes for changing end date for RolePlan assignment
2077: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD');
2078: fnd_message.set_token ('OLDVALUE', l_rec_old.end_date);
2079: fnd_message.set_token ('NEWVALUE', l_rec_new.end_date);
2080: fnd_message.set_token ('NAME', l_rec_new.role_name);
2081: l_note_msg := fnd_message.get;
2082: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2075: THEN
2076: --Notes for changing end date for RolePlan assignment
2077: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD');
2078: fnd_message.set_token ('OLDVALUE', l_rec_old.end_date);
2079: fnd_message.set_token ('NEWVALUE', l_rec_new.end_date);
2080: fnd_message.set_token ('NAME', l_rec_new.role_name);
2081: l_note_msg := fnd_message.get;
2082: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2083: /*
2076: --Notes for changing end date for RolePlan assignment
2077: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD');
2078: fnd_message.set_token ('OLDVALUE', l_rec_old.end_date);
2079: fnd_message.set_token ('NEWVALUE', l_rec_new.end_date);
2080: fnd_message.set_token ('NAME', l_rec_new.role_name);
2081: l_note_msg := fnd_message.get;
2082: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2083: /*
2084: jtf_notes_pub.create_note
2077: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD');
2078: fnd_message.set_token ('OLDVALUE', l_rec_old.end_date);
2079: fnd_message.set_token ('NEWVALUE', l_rec_new.end_date);
2080: fnd_message.set_token ('NAME', l_rec_new.role_name);
2081: l_note_msg := fnd_message.get;
2082: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2083: /*
2084: jtf_notes_pub.create_note
2085: (p_api_version => 1.0,
2528: -- delete_row
2529: cn_role_plans_pkg.delete_row (x_role_plan_id => l_role_plan_id);
2530:
2531: /* System Generated - Create Note Functionality */
2532: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
2533: fnd_message.set_token ('NEWVALUE', l_rec.role_name);
2534: fnd_message.set_token ('NAME', l_rec.comp_plan_name);
2535: l_note_msg := fnd_message.get;
2536: jtf_notes_pub.create_note
2529: cn_role_plans_pkg.delete_row (x_role_plan_id => l_role_plan_id);
2530:
2531: /* System Generated - Create Note Functionality */
2532: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
2533: fnd_message.set_token ('NEWVALUE', l_rec.role_name);
2534: fnd_message.set_token ('NAME', l_rec.comp_plan_name);
2535: l_note_msg := fnd_message.get;
2536: jtf_notes_pub.create_note
2537: (p_api_version => 1.0,
2530:
2531: /* System Generated - Create Note Functionality */
2532: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
2533: fnd_message.set_token ('NEWVALUE', l_rec.role_name);
2534: fnd_message.set_token ('NAME', l_rec.comp_plan_name);
2535: l_note_msg := fnd_message.get;
2536: jtf_notes_pub.create_note
2537: (p_api_version => 1.0,
2538: x_return_status => x_return_status,
2531: /* System Generated - Create Note Functionality */
2532: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
2533: fnd_message.set_token ('NEWVALUE', l_rec.role_name);
2534: fnd_message.set_token ('NAME', l_rec.comp_plan_name);
2535: l_note_msg := fnd_message.get;
2536: jtf_notes_pub.create_note
2537: (p_api_version => 1.0,
2538: x_return_status => x_return_status,
2539: x_msg_count => x_msg_count,