90: OR (p_quota_assign.quota_id = fnd_api.g_miss_num)
91: THEN
92: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
93: THEN
94: fnd_message.set_name ('CN', 'CN_REQ_PAR_MISSING');
95: fnd_msg_pub.ADD;
96: END IF;
97:
98: RAISE fnd_api.g_exc_error;
109: IF l_temp_count <> 0
110: THEN
111: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
112: THEN
113: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
114: fnd_message.set_token ('INPUT_NAME',
115: cn_api.get_lkup_meaning ('PE_NAME',
116: 'INPUT_TOKEN'
117: )
110: THEN
111: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
112: THEN
113: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
114: fnd_message.set_token ('INPUT_NAME',
115: cn_api.get_lkup_meaning ('PE_NAME',
116: 'INPUT_TOKEN'
117: )
118: );
136: IF l_temp_count = 0
137: THEN
138: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
139: THEN
140: fnd_message.set_name ('CN', 'CN_PLAN_ELT_DISJOINT');
141: fnd_msg_pub.ADD;
142: END IF;
143:
144: RAISE fnd_api.g_exc_error;
172: IF l_temp_count = 0
173: THEN
174: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
175: THEN
176: fnd_message.set_name ('CN', 'CN_IDQ_REFERENCE_NOT_VALID');
177: fnd_msg_pub.ADD;
178: END IF;
179:
180: RAISE fnd_api.g_exc_error;
229: INTO l_cp_name
230: FROM cn_comp_plans
231: WHERE comp_plan_id = l_comp_plan_id;
232:
233: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_AS');
234: fnd_message.set_token ('PE_NAME', l_pe_name);
235: fnd_message.set_token ('CP_NAME', l_cp_name);
236: l_note_msg := fnd_message.get;
237: jtf_notes_pub.create_note
230: FROM cn_comp_plans
231: WHERE comp_plan_id = l_comp_plan_id;
232:
233: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_AS');
234: fnd_message.set_token ('PE_NAME', l_pe_name);
235: fnd_message.set_token ('CP_NAME', l_cp_name);
236: l_note_msg := fnd_message.get;
237: jtf_notes_pub.create_note
238: (p_api_version => 1.0,
231: WHERE comp_plan_id = l_comp_plan_id;
232:
233: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_AS');
234: fnd_message.set_token ('PE_NAME', l_pe_name);
235: fnd_message.set_token ('CP_NAME', l_cp_name);
236: l_note_msg := fnd_message.get;
237: jtf_notes_pub.create_note
238: (p_api_version => 1.0,
239: x_return_status => x_return_status,
232:
233: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_AS');
234: fnd_message.set_token ('PE_NAME', l_pe_name);
235: fnd_message.set_token ('CP_NAME', l_cp_name);
236: l_note_msg := fnd_message.get;
237: jtf_notes_pub.create_note
238: (p_api_version => 1.0,
239: x_return_status => x_return_status,
240: x_msg_count => x_msg_count,
395: OR (p_quota_assign.quota_id IS NULL)
396: THEN
397: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
398: THEN
399: fnd_message.set_name ('CN', 'CN_REQ_PAR_MISSING');
400: fnd_msg_pub.ADD;
401: END IF;
402:
403: RAISE fnd_api.g_exc_error;
426: IF l_temp_count <> 0
427: THEN
428: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
429: THEN
430: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
431: fnd_message.set_token ('INPUT_NAME',
432: cn_api.get_lkup_meaning ('PE_NAME',
433: 'INPUT_TOKEN'
434: )
427: THEN
428: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
429: THEN
430: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
431: fnd_message.set_token ('INPUT_NAME',
432: cn_api.get_lkup_meaning ('PE_NAME',
433: 'INPUT_TOKEN'
434: )
435: );
479: IF l_temp_count = 0
480: THEN
481: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
482: THEN
483: fnd_message.set_name ('CN', 'CN_PLAN_ELT_DISJOINT');
484: fnd_msg_pub.ADD;
485: END IF;
486:
487: RAISE fnd_api.g_exc_error;
516: IF l_temp_count = 0
517: THEN
518: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
519: THEN
520: fnd_message.set_name ('CN', 'CN_IDQ_REFERENCE_NOT_VALID');
521: fnd_msg_pub.ADD;
522: END IF;
523:
524: RAISE fnd_api.g_exc_error;
530: -- 5. check object version number
531: IF l_old_quota_assign.object_version_number <>
532: p_quota_assign.object_version_number
533: THEN
534: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
535: fnd_msg_pub.ADD;
536: RAISE fnd_api.g_exc_error;
537: END IF;
538:
565: INTO l_cp_name
566: FROM cn_comp_plans
567: WHERE comp_plan_id = l_comp_plan_id;
568:
569: fnd_message.set_name ('CN', 'CN_PA_CP_QA_CALC_SEQ_NOTES');
570: fnd_message.set_token ('PE_NAME', l_pe_name);
571: fnd_message.set_token ('CP_NAME', l_cp_name);
572: fnd_message.set_token ('OLD_SEQ', old_seq);
573: fnd_message.set_token ('NEW_SEQ', p_quota_assign.quota_sequence);
566: FROM cn_comp_plans
567: WHERE comp_plan_id = l_comp_plan_id;
568:
569: fnd_message.set_name ('CN', 'CN_PA_CP_QA_CALC_SEQ_NOTES');
570: fnd_message.set_token ('PE_NAME', l_pe_name);
571: fnd_message.set_token ('CP_NAME', l_cp_name);
572: fnd_message.set_token ('OLD_SEQ', old_seq);
573: fnd_message.set_token ('NEW_SEQ', p_quota_assign.quota_sequence);
574: l_consolidated_note := fnd_message.get;
567: WHERE comp_plan_id = l_comp_plan_id;
568:
569: fnd_message.set_name ('CN', 'CN_PA_CP_QA_CALC_SEQ_NOTES');
570: fnd_message.set_token ('PE_NAME', l_pe_name);
571: fnd_message.set_token ('CP_NAME', l_cp_name);
572: fnd_message.set_token ('OLD_SEQ', old_seq);
573: fnd_message.set_token ('NEW_SEQ', p_quota_assign.quota_sequence);
574: l_consolidated_note := fnd_message.get;
575:
568:
569: fnd_message.set_name ('CN', 'CN_PA_CP_QA_CALC_SEQ_NOTES');
570: fnd_message.set_token ('PE_NAME', l_pe_name);
571: fnd_message.set_token ('CP_NAME', l_cp_name);
572: fnd_message.set_token ('OLD_SEQ', old_seq);
573: fnd_message.set_token ('NEW_SEQ', p_quota_assign.quota_sequence);
574: l_consolidated_note := fnd_message.get;
575:
576: ELSE IF (l_quota_id > 0 AND l_comp_plan_id > 0)
569: fnd_message.set_name ('CN', 'CN_PA_CP_QA_CALC_SEQ_NOTES');
570: fnd_message.set_token ('PE_NAME', l_pe_name);
571: fnd_message.set_token ('CP_NAME', l_cp_name);
572: fnd_message.set_token ('OLD_SEQ', old_seq);
573: fnd_message.set_token ('NEW_SEQ', p_quota_assign.quota_sequence);
574: l_consolidated_note := fnd_message.get;
575:
576: ELSE IF (l_quota_id > 0 AND l_comp_plan_id > 0)
577: THEN
570: fnd_message.set_token ('PE_NAME', l_pe_name);
571: fnd_message.set_token ('CP_NAME', l_cp_name);
572: fnd_message.set_token ('OLD_SEQ', old_seq);
573: fnd_message.set_token ('NEW_SEQ', p_quota_assign.quota_sequence);
574: l_consolidated_note := fnd_message.get;
575:
576: ELSE IF (l_quota_id > 0 AND l_comp_plan_id > 0)
577: THEN
578: SELECT NAME
584: INTO l_cp_name
585: FROM cn_comp_plans
586: WHERE comp_plan_id = l_comp_plan_id;
587:
588: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_AS');
589: fnd_message.set_token ('PE_NAME', l_pe_name);
590: fnd_message.set_token ('CP_NAME', l_cp_name);
591: l_note_msg := fnd_message.get;
592: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
585: FROM cn_comp_plans
586: WHERE comp_plan_id = l_comp_plan_id;
587:
588: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_AS');
589: fnd_message.set_token ('PE_NAME', l_pe_name);
590: fnd_message.set_token ('CP_NAME', l_cp_name);
591: l_note_msg := fnd_message.get;
592: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
593: /*jtf_notes_pub.create_note
586: WHERE comp_plan_id = l_comp_plan_id;
587:
588: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_AS');
589: fnd_message.set_token ('PE_NAME', l_pe_name);
590: fnd_message.set_token ('CP_NAME', l_cp_name);
591: l_note_msg := fnd_message.get;
592: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
593: /*jtf_notes_pub.create_note
594: (p_api_version => 1.0,
587:
588: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_AS');
589: fnd_message.set_token ('PE_NAME', l_pe_name);
590: fnd_message.set_token ('CP_NAME', l_cp_name);
591: l_note_msg := fnd_message.get;
592: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
593: /*jtf_notes_pub.create_note
594: (p_api_version => 1.0,
595: x_return_status => x_return_status,
610: INTO l_pe_name
611: FROM cn_quotas_all
612: WHERE quota_id = l_old_quota_assign.quota_id;
613:
614: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');
615: fnd_message.set_token ('PE_NAME', l_pe_name);
616: fnd_message.set_token ('CP_NAME', l_cp_name);
617: l_note_msg := fnd_message.get;
618: l_consolidated_note := l_consolidated_note || l_note_msg ||fnd_global.local_chr(10);
611: FROM cn_quotas_all
612: WHERE quota_id = l_old_quota_assign.quota_id;
613:
614: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');
615: fnd_message.set_token ('PE_NAME', l_pe_name);
616: fnd_message.set_token ('CP_NAME', l_cp_name);
617: l_note_msg := fnd_message.get;
618: l_consolidated_note := l_consolidated_note || l_note_msg ||fnd_global.local_chr(10);
619:
612: WHERE quota_id = l_old_quota_assign.quota_id;
613:
614: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');
615: fnd_message.set_token ('PE_NAME', l_pe_name);
616: fnd_message.set_token ('CP_NAME', l_cp_name);
617: l_note_msg := fnd_message.get;
618: l_consolidated_note := l_consolidated_note || l_note_msg ||fnd_global.local_chr(10);
619:
620: /*jtf_notes_pub.create_note
613:
614: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');
615: fnd_message.set_token ('PE_NAME', l_pe_name);
616: fnd_message.set_token ('CP_NAME', l_cp_name);
617: l_note_msg := fnd_message.get;
618: l_consolidated_note := l_consolidated_note || l_note_msg ||fnd_global.local_chr(10);
619:
620: /*jtf_notes_pub.create_note
621: (p_api_version => 1.0,
774: WHERE quota_assign_id = p_quota_assign.quota_assign_id;
775: EXCEPTION
776: WHEN NO_DATA_FOUND
777: THEN
778: fnd_message.set_name ('CN', 'CN_RECORD_DELETED');
779: fnd_msg_pub.ADD;
780: RAISE fnd_api.g_exc_unexpected_error;
781: END;
782:
808: INTO l_cp_name
809: FROM cn_comp_plans
810: WHERE comp_plan_id = l_comp_plan_id;
811:
812: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');
813: fnd_message.set_token ('PE_NAME', l_pe_name);
814: fnd_message.set_token ('CP_NAME', l_cp_name);
815: l_note_msg := fnd_message.get;
816: jtf_notes_pub.create_note
809: FROM cn_comp_plans
810: WHERE comp_plan_id = l_comp_plan_id;
811:
812: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');
813: fnd_message.set_token ('PE_NAME', l_pe_name);
814: fnd_message.set_token ('CP_NAME', l_cp_name);
815: l_note_msg := fnd_message.get;
816: jtf_notes_pub.create_note
817: (p_api_version => 1.0,
810: WHERE comp_plan_id = l_comp_plan_id;
811:
812: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');
813: fnd_message.set_token ('PE_NAME', l_pe_name);
814: fnd_message.set_token ('CP_NAME', l_cp_name);
815: l_note_msg := fnd_message.get;
816: jtf_notes_pub.create_note
817: (p_api_version => 1.0,
818: x_return_status => x_return_status,
811:
812: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');
813: fnd_message.set_token ('PE_NAME', l_pe_name);
814: fnd_message.set_token ('CP_NAME', l_cp_name);
815: l_note_msg := fnd_message.get;
816: jtf_notes_pub.create_note
817: (p_api_version => 1.0,
818: x_return_status => x_return_status,
819: x_msg_count => x_msg_count,