DBA Data[Home] [Help]

APPS.CN_COMP_PLAN_PVT dependencies on FND_MESSAGE

Line 73: fnd_message.set_name ('FND', 'MO_OU_REQUIRED');

69: IS
70: BEGIN
71: IF p_id IS NULL
72: THEN
73: fnd_message.set_name ('FND', 'MO_OU_REQUIRED');
74: fnd_msg_pub.ADD;
75: RAISE fnd_api.g_exc_error;
76: END IF;
77: END;

Line 153: fnd_message.set_name ('CN', 'CN_REQ_PAR_MISSING');

149: OR (p_comp_plan.start_date = fnd_api.g_miss_date)
150: THEN
151: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
152: THEN
153: fnd_message.set_name ('CN', 'CN_REQ_PAR_MISSING');
154: fnd_msg_pub.ADD;
155: END IF;
156:
157: RAISE fnd_api.g_exc_error;

Line 170: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');

166: IF l_temp_count <> 0
167: THEN
168: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
169: THEN
170: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
171: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('NAME', 'INPUT_TOKEN'));
172: fnd_msg_pub.ADD;
173: END IF;
174:

Line 171: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('NAME', 'INPUT_TOKEN'));

167: THEN
168: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
169: THEN
170: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
171: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('NAME', 'INPUT_TOKEN'));
172: fnd_msg_pub.ADD;
173: END IF;
174:
175: RAISE fnd_api.g_exc_error;

Line 183: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');

179: IF (p_comp_plan.end_date IS NOT NULL) AND (p_comp_plan.start_date > p_comp_plan.end_date)
180: THEN
181: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
182: THEN
183: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');
184: fnd_msg_pub.ADD;
185: END IF;
186:
187: RAISE fnd_api.g_exc_error;

Line 282: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_CREATE');

278:
279:
280: /* System Generated - Create Note Functionality */
281: /* This code is later needed when the Public --> Pvt instead of pvt --> public
282: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_CREATE');
283: fnd_message.set_token ('CP_NAME', l_comp_rec.NAME);
284: l_note_msg := fnd_message.get;
285: jtf_notes_pub.create_note
286: (p_api_version => 1.0,

Line 283: fnd_message.set_token ('CP_NAME', l_comp_rec.NAME);

279:
280: /* System Generated - Create Note Functionality */
281: /* This code is later needed when the Public --> Pvt instead of pvt --> public
282: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_CREATE');
283: fnd_message.set_token ('CP_NAME', l_comp_rec.NAME);
284: l_note_msg := fnd_message.get;
285: jtf_notes_pub.create_note
286: (p_api_version => 1.0,
287: x_return_status => x_return_status,

Line 284: l_note_msg := fnd_message.get;

280: /* System Generated - Create Note Functionality */
281: /* This code is later needed when the Public --> Pvt instead of pvt --> public
282: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_CREATE');
283: fnd_message.set_token ('CP_NAME', l_comp_rec.NAME);
284: l_note_msg := fnd_message.get;
285: jtf_notes_pub.create_note
286: (p_api_version => 1.0,
287: x_return_status => x_return_status,
288: x_msg_count => x_msg_count,

Line 438: fnd_message.set_name ('CN', 'CN_REQ_PAR_MISSING');

434: IF (p_comp_plan.NAME IS NULL) OR (p_comp_plan.start_date IS NULL)
435: THEN
436: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
437: THEN
438: fnd_message.set_name ('CN', 'CN_REQ_PAR_MISSING');
439: fnd_msg_pub.ADD;
440: END IF;
441:
442: RAISE fnd_api.g_exc_error;

Line 455: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');

451: IF l_temp_count <> 0
452: THEN
453: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
454: THEN
455: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
456: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('NAME', 'INPUT_TOKEN'));
457: fnd_msg_pub.ADD;
458: END IF;
459:

Line 456: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('NAME', 'INPUT_TOKEN'));

452: THEN
453: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
454: THEN
455: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
456: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('NAME', 'INPUT_TOKEN'));
457: fnd_msg_pub.ADD;
458: END IF;
459:
460: RAISE fnd_api.g_exc_error;

Line 497: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');

493: IF (l_end_date IS NOT NULL) AND (l_start_date > l_end_date)
494: THEN
495: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
496: THEN
497: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');
498: fnd_msg_pub.ADD;
499: END IF;
500:
501: RAISE fnd_api.g_exc_error;

Line 558: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');

554:
555: -- 3. check object version number
556: IF l_old_comp_plan.object_version_number <> p_comp_plan.object_version_number
557: THEN
558: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
559: fnd_msg_pub.ADD;
560: RAISE fnd_api.g_exc_error;
561: END IF;
562:

Line 577: fnd_message.set_name ('CN', 'CN_PLAN_ELT_DISJOINT');

573:
574: -- if end date null then cond doesn't pass, but that's okay
575: IF l_temp_count > 0
576: THEN
577: fnd_message.set_name ('CN', 'CN_PLAN_ELT_DISJOINT');
578: fnd_msg_pub.ADD;
579: RAISE fnd_api.g_exc_error;
580: END IF;
581:

Line 589: fnd_message.set_name ('CN', 'CN_ROLE_NOT_WITHIN_PLAN');

585: WHERE comp_plan_id = l_comp_plan_id AND (start_date < l_start_date OR (end_date IS NULL AND l_end_date IS NOT NULL) OR (end_date > l_end_date));
586:
587: IF l_temp_count > 0
588: THEN
589: fnd_message.set_name ('CN', 'CN_ROLE_NOT_WITHIN_PLAN');
590: fnd_msg_pub.ADD;
591: RAISE fnd_api.g_exc_error;
592: END IF;
593:

Line 662: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_UPDATE');

658: l_consolidated_note := '';
659: IF (p_comp_plan.NAME <> fnd_api.g_miss_char AND p_comp_plan.NAME IS NOT NULL AND p_comp_plan.NAME <> l_old_comp_plan.NAME)
660: THEN
661: -- Need to add note CNR12_NOTE_COMPPLAN_UPDATE
662: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_UPDATE');
663: fnd_message.set_token ('OLD_CP_NAME', l_old_comp_plan.NAME);
664: fnd_message.set_token ('NEW_CP_NAME', p_comp_plan.NAME);
665: l_note_msg := fnd_message.get;
666: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);

Line 663: fnd_message.set_token ('OLD_CP_NAME', l_old_comp_plan.NAME);

659: IF (p_comp_plan.NAME <> fnd_api.g_miss_char AND p_comp_plan.NAME IS NOT NULL AND p_comp_plan.NAME <> l_old_comp_plan.NAME)
660: THEN
661: -- Need to add note CNR12_NOTE_COMPPLAN_UPDATE
662: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_UPDATE');
663: fnd_message.set_token ('OLD_CP_NAME', l_old_comp_plan.NAME);
664: fnd_message.set_token ('NEW_CP_NAME', p_comp_plan.NAME);
665: l_note_msg := fnd_message.get;
666: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
667:

Line 664: fnd_message.set_token ('NEW_CP_NAME', p_comp_plan.NAME);

660: THEN
661: -- Need to add note CNR12_NOTE_COMPPLAN_UPDATE
662: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_UPDATE');
663: fnd_message.set_token ('OLD_CP_NAME', l_old_comp_plan.NAME);
664: fnd_message.set_token ('NEW_CP_NAME', p_comp_plan.NAME);
665: l_note_msg := fnd_message.get;
666: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
667:
668: /*

Line 665: l_note_msg := fnd_message.get;

661: -- Need to add note CNR12_NOTE_COMPPLAN_UPDATE
662: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_UPDATE');
663: fnd_message.set_token ('OLD_CP_NAME', l_old_comp_plan.NAME);
664: fnd_message.set_token ('NEW_CP_NAME', p_comp_plan.NAME);
665: l_note_msg := fnd_message.get;
666: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
667:
668: /*
669: jtf_notes_pub.create_note (p_api_version => 1.0,

Line 689: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_SDATE_CRE');

685: AND p_comp_plan.start_date <> l_old_comp_plan.start_date
686: )
687: THEN
688: -- Need to add note CNR12_NOTE_COMPPLAN_SDATE_CRE
689: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_SDATE_CRE');
690: fnd_message.set_token ('OLD_ST_DATE', TO_CHAR (l_old_comp_plan.start_date));
691: fnd_message.set_token ('NEW_ST_DATE', TO_CHAR (p_comp_plan.start_date));
692: l_note_msg := fnd_message.get;
693: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

Line 690: fnd_message.set_token ('OLD_ST_DATE', TO_CHAR (l_old_comp_plan.start_date));

686: )
687: THEN
688: -- Need to add note CNR12_NOTE_COMPPLAN_SDATE_CRE
689: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_SDATE_CRE');
690: fnd_message.set_token ('OLD_ST_DATE', TO_CHAR (l_old_comp_plan.start_date));
691: fnd_message.set_token ('NEW_ST_DATE', TO_CHAR (p_comp_plan.start_date));
692: l_note_msg := fnd_message.get;
693: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
694:

Line 691: fnd_message.set_token ('NEW_ST_DATE', TO_CHAR (p_comp_plan.start_date));

687: THEN
688: -- Need to add note CNR12_NOTE_COMPPLAN_SDATE_CRE
689: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_SDATE_CRE');
690: fnd_message.set_token ('OLD_ST_DATE', TO_CHAR (l_old_comp_plan.start_date));
691: fnd_message.set_token ('NEW_ST_DATE', TO_CHAR (p_comp_plan.start_date));
692: l_note_msg := fnd_message.get;
693: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
694:
695: /*

Line 692: l_note_msg := fnd_message.get;

688: -- Need to add note CNR12_NOTE_COMPPLAN_SDATE_CRE
689: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_SDATE_CRE');
690: fnd_message.set_token ('OLD_ST_DATE', TO_CHAR (l_old_comp_plan.start_date));
691: fnd_message.set_token ('NEW_ST_DATE', TO_CHAR (p_comp_plan.start_date));
692: l_note_msg := fnd_message.get;
693: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
694:
695: /*
696: jtf_notes_pub.create_note (p_api_version => 1.0,

Line 714: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_EDATE_UPD');

710: /* 3. Check if the end date has been changed */
711: IF (p_comp_plan.end_date <> fnd_api.g_miss_date AND p_comp_plan.end_date IS NOT NULL AND p_comp_plan.end_date <> l_old_comp_plan.end_date)
712: THEN
713: -- Need to add note CNR12_NOTE_COMPPLAN_EDATE_UPD
714: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_EDATE_UPD');
715: fnd_message.set_token ('OLD_END_DATE', TO_CHAR (l_old_comp_plan.end_date));
716: fnd_message.set_token ('NEW_END_DATE', TO_CHAR (p_comp_plan.end_date));
717: l_note_msg := fnd_message.get;
718: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

Line 715: fnd_message.set_token ('OLD_END_DATE', TO_CHAR (l_old_comp_plan.end_date));

711: IF (p_comp_plan.end_date <> fnd_api.g_miss_date AND p_comp_plan.end_date IS NOT NULL AND p_comp_plan.end_date <> l_old_comp_plan.end_date)
712: THEN
713: -- Need to add note CNR12_NOTE_COMPPLAN_EDATE_UPD
714: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_EDATE_UPD');
715: fnd_message.set_token ('OLD_END_DATE', TO_CHAR (l_old_comp_plan.end_date));
716: fnd_message.set_token ('NEW_END_DATE', TO_CHAR (p_comp_plan.end_date));
717: l_note_msg := fnd_message.get;
718: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
719: /*

Line 716: fnd_message.set_token ('NEW_END_DATE', TO_CHAR (p_comp_plan.end_date));

712: THEN
713: -- Need to add note CNR12_NOTE_COMPPLAN_EDATE_UPD
714: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_EDATE_UPD');
715: fnd_message.set_token ('OLD_END_DATE', TO_CHAR (l_old_comp_plan.end_date));
716: fnd_message.set_token ('NEW_END_DATE', TO_CHAR (p_comp_plan.end_date));
717: l_note_msg := fnd_message.get;
718: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
719: /*
720: jtf_notes_pub.create_note (p_api_version => 1.0,

Line 717: l_note_msg := fnd_message.get;

713: -- Need to add note CNR12_NOTE_COMPPLAN_EDATE_UPD
714: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_EDATE_UPD');
715: fnd_message.set_token ('OLD_END_DATE', TO_CHAR (l_old_comp_plan.end_date));
716: fnd_message.set_token ('NEW_END_DATE', TO_CHAR (p_comp_plan.end_date));
717: l_note_msg := fnd_message.get;
718: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
719: /*
720: jtf_notes_pub.create_note (p_api_version => 1.0,
721: x_return_status => x_return_status,

Line 742: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ELIG_UPD2');

738: AND p_comp_plan.allow_rev_class_overlap = 'N'
739: )
740: THEN
741: -- Need to add note CNR12_NOTE_COMPPLAN_ELIG_UPD2
742: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ELIG_UPD2');
743: l_note_msg := fnd_message.get;
744: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
745: /*
746: jtf_notes_pub.create_note (p_api_version => 1.0,

Line 743: l_note_msg := fnd_message.get;

739: )
740: THEN
741: -- Need to add note CNR12_NOTE_COMPPLAN_ELIG_UPD2
742: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ELIG_UPD2');
743: l_note_msg := fnd_message.get;
744: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
745: /*
746: jtf_notes_pub.create_note (p_api_version => 1.0,
747: x_return_status => x_return_status,

Line 768: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ELIG_UPD1');

764: AND p_comp_plan.allow_rev_class_overlap = 'Y'
765: )
766: THEN
767: -- Need to add note CNR12_NOTE_COMPPLAN_ELIG_UPD1
768: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ELIG_UPD1');
769: l_note_msg := fnd_message.get;
770: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
771: /*
772: jtf_notes_pub.create_note (p_api_version => 1.0,

Line 769: l_note_msg := fnd_message.get;

765: )
766: THEN
767: -- Need to add note CNR12_NOTE_COMPPLAN_ELIG_UPD1
768: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ELIG_UPD1');
769: l_note_msg := fnd_message.get;
770: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
771: /*
772: jtf_notes_pub.create_note (p_api_version => 1.0,
773: x_return_status => x_return_status,

Line 961: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_DELETE');

957:
958: /* Added the Notes for R12 */
959: IF (l_org_id <> -999)
960: THEN
961: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_DELETE');
962: fnd_message.set_token ('CP_NAME', l_cp_name);
963: l_note_msg := fnd_message.get;
964: jtf_notes_pub.create_note (p_api_version => 1.0,
965: x_return_status => x_return_status,

Line 962: fnd_message.set_token ('CP_NAME', l_cp_name);

958: /* Added the Notes for R12 */
959: IF (l_org_id <> -999)
960: THEN
961: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_DELETE');
962: fnd_message.set_token ('CP_NAME', l_cp_name);
963: l_note_msg := fnd_message.get;
964: jtf_notes_pub.create_note (p_api_version => 1.0,
965: x_return_status => x_return_status,
966: x_msg_count => x_msg_count,

Line 963: l_note_msg := fnd_message.get;

959: IF (l_org_id <> -999)
960: THEN
961: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_DELETE');
962: fnd_message.set_token ('CP_NAME', l_cp_name);
963: l_note_msg := fnd_message.get;
964: jtf_notes_pub.create_note (p_api_version => 1.0,
965: x_return_status => x_return_status,
966: x_msg_count => x_msg_count,
967: x_msg_data => x_msg_data,

Line 1497: fnd_message.set_name ('CN', 'CN_NO_PE_ASSIGNED');

1493: IF l_temp_count = 0
1494: THEN
1495: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1496: THEN
1497: fnd_message.set_name ('CN', 'CN_NO_PE_ASSIGNED');
1498: fnd_msg_pub.ADD;
1499: END IF;
1500:
1501: RAISE fnd_api.g_exc_error;

Line 1519: fnd_message.set_name ('CN', 'CN_INCOMP_FORMULA');

1515: IF l_incomp_forms IS NOT NULL
1516: THEN
1517: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1518: THEN
1519: fnd_message.set_name ('CN', 'CN_INCOMP_FORMULA');
1520: fnd_message.set_token ('FORMULA_NAME', l_incomp_forms);
1521: fnd_msg_pub.ADD;
1522: END IF;
1523:

Line 1520: fnd_message.set_token ('FORMULA_NAME', l_incomp_forms);

1516: THEN
1517: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1518: THEN
1519: fnd_message.set_name ('CN', 'CN_INCOMP_FORMULA');
1520: fnd_message.set_token ('FORMULA_NAME', l_incomp_forms);
1521: fnd_msg_pub.ADD;
1522: END IF;
1523:
1524: RAISE fnd_api.g_exc_error;

Line 1704: fnd_message.set_name ('CN', 'CN_CP_NOT_EXIST');

1700: WHEN NO_DATA_FOUND
1701: THEN
1702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1703: THEN
1704: fnd_message.set_name ('CN', 'CN_CP_NOT_EXIST');
1705: fnd_msg_pub.ADD;
1706: END IF;
1707:
1708: x_loading_status := 'CN_CP_NOT_EXIST';

Line 1731: fnd_message.set_name ('CN', 'PLN_PLAN_DUP_REV_CLASS');

1727: THEN
1728:
1729: /* IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1730: THEN
1731: fnd_message.set_name ('CN', 'PLN_PLAN_DUP_REV_CLASS');
1732: fnd_message.set_token ('PLAN_NAME', l_comp_plan_name);
1733: fnd_msg_pub.ADD;
1734: END IF; */
1735:

Line 1732: fnd_message.set_token ('PLAN_NAME', l_comp_plan_name);

1728:
1729: /* IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1730: THEN
1731: fnd_message.set_name ('CN', 'PLN_PLAN_DUP_REV_CLASS');
1732: fnd_message.set_token ('PLAN_NAME', l_comp_plan_name);
1733: fnd_msg_pub.ADD;
1734: END IF; */
1735:
1736: x_loading_status := 'PLN_PLAN_DUP_REV_CLASS';