DBA Data[Home] [Help]

APPS.CN_ROLE_PLANS_PUB dependencies on FND_MESSAGE

Line 297: fnd_message.set_name ('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');

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:

Line 298: fnd_message.set_token ('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:
302: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';

Line 316: fnd_message.set_name ('CN', 'CN_RL_ASGN_CP_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;

Line 317: fnd_message.set_token ('COMP_PLAN',

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;

Line 343: fnd_message.set_name ('CN', 'CN_RL_ASGN_CP_NOT_EXIST');

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;

Line 344: fnd_message.set_token ('COMP_PLAN',

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;

Line 364: fnd_message.set_name ('CN', 'CN_RL_CP_DATE_RANGE_NOT_WITHIN');

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

Line 365: fnd_message.set_token ('START_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);

Line 368: fnd_message.set_token ('END_DATE', p_role_plan_rec.end_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

Line 369: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);

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

Line 370: fnd_message.set_token ('CP_END_DATE', l_cp_rec.end_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: );
374: fnd_msg_pub.ADD;

Line 371: fnd_message.set_token ('COMP_PLAN_NAME',

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;

Line 400: fnd_message.set_name ('CN', 'CN_RL_ROLE_PLAN_OVERLAP');

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

Line 401: fnd_message.set_token ('COMP_PLAN_NAME',

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

Line 404: fnd_message.set_token ('START_DATE', l_rec.start_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:

Line 405: fnd_message.set_token ('END_DATE', l_rec.end_date);

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

Line 529: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST');

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

Line 600: fnd_message.set_name ('CN', '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';

Line 628: fnd_message.set_name ('CN', 'CN_RL_INVALID_DATE_RANGE');

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;

Line 629: fnd_message.set_token ('START_DATE', tmp_start_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;
633:

Line 630: fnd_message.set_token ('END_DATE', tmp_end_date);

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

Line 653: fnd_message.set_name ('CN', 'CN_RP_CREATED_IN_SFP');

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

Line 670: fnd_message.set_name ('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');

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;

Line 671: fnd_message.set_token ('ROLE_NAME',

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;

Line 692: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST');

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

Line 721: fnd_message.set_name ('CN', 'CN_RL_ASGN_CP_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;

Line 722: fnd_message.set_token ('COMP_PLAN',

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;

Line 743: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST');

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

Line 782: fnd_message.set_name ('CN', 'CN_RL_CP_DATE_RANGE_NOT_WITHIN');

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

Line 783: fnd_message.set_token ('START_DATE', tmp_start_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',

Line 784: fnd_message.set_token ('END_DATE', tmp_end_date);

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)

Line 785: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);

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

Line 786: fnd_message.set_token ('CP_END_DATE', l_cp_rec.end_date);

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;

Line 787: fnd_message.set_token ('COMP_PLAN_NAME',

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;

Line 819: fnd_message.set_name ('CN', 'CN_RL_ROLE_PLAN_OVERLAP');

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

Line 820: fnd_message.set_token ('COMP_PLAN_NAME',

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

Line 823: fnd_message.set_token ('START_DATE', l_rec.start_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:

Line 824: fnd_message.set_token ('END_DATE', l_rec.end_date);

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

Line 937: fnd_message.set_name ('CN', 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST');

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

Line 1445: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');

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

Line 1446: fnd_message.set_token ('NEWVALUE', l_rec.role_name);

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,

Line 1447: fnd_message.set_token ('NAME', l_rec.comp_plan_name);

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,

Line 1448: l_note_msg := fnd_message.get;

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,

Line 1762: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');

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

Line 1770: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');

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 ;

Line 1921: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');

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

Line 1922: fnd_message.set_token ('NEWVALUE', l_rec_old.role_name);

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: /*

Line 1923: fnd_message.set_token ('NAME', l_rec_old.comp_plan_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: /*
1927: jtf_notes_pub.create_note

Line 1924: l_note_msg := fnd_message.get;

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,

Line 1941: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');

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

Line 1942: fnd_message.set_token ('NEWVALUE', l_rec_new.role_name);

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: /*

Line 1943: fnd_message.set_token ('NAME', l_rec_new.comp_plan_name);

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

Line 1944: l_note_msg := fnd_message.get;

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,

Line 1965: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');

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

Line 1966: fnd_message.set_token ('NEWVALUE', l_rec_old.role_name);

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: /*

Line 1967: fnd_message.set_token ('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: /*
1971: jtf_notes_pub.create_note

Line 1968: l_note_msg := fnd_message.get;

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,

Line 1985: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');

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

Line 1986: fnd_message.set_token ('NEWVALUE', l_rec_new.role_name);

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: /*

Line 1987: fnd_message.set_token ('NAME', l_rec_new.comp_plan_name);

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

Line 1988: l_note_msg := fnd_message.get;

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,

Line 2007: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_START_DATE_UPD');

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;

Line 2008: fnd_message.set_token ('OLDVALUE', l_rec_old.start_date);

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

Line 2009: fnd_message.set_token ('NEWVALUE', l_rec_new.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);
2013: /*

Line 2010: fnd_message.set_token ('NAME', l_rec_new.role_name);

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

Line 2011: l_note_msg := fnd_message.get;

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,

Line 2032: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_NULL_UPD');

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

Line 2033: fnd_message.set_token ('NEWVALUE', l_rec_new.end_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);
2037: /*

Line 2034: fnd_message.set_token ('NAME', l_rec_new.role_name);

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

Line 2035: l_note_msg := fnd_message.get;

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,

Line 2055: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD_NULL');

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: /*

Line 2056: fnd_message.set_token ('NAME', l_rec_new.role_name);

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

Line 2057: l_note_msg := fnd_message.get;

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,

Line 2077: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD');

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;

Line 2078: fnd_message.set_token ('OLDVALUE', l_rec_old.end_date);

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

Line 2079: fnd_message.set_token ('NEWVALUE', l_rec_new.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);
2083: /*

Line 2080: fnd_message.set_token ('NAME', l_rec_new.role_name);

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

Line 2081: l_note_msg := fnd_message.get;

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,

Line 2532: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');

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

Line 2533: fnd_message.set_token ('NEWVALUE', l_rec.role_name);

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,

Line 2534: fnd_message.set_token ('NAME', l_rec.comp_plan_name);

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,

Line 2535: l_note_msg := fnd_message.get;

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,