DBA Data[Home] [Help]

APPS.CN_QUOTA_ASSIGN_PVT dependencies on FND_MESSAGE

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

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;

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

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

Line 114: fnd_message.set_token ('INPUT_NAME',

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

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

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;

Line 176: fnd_message.set_name ('CN', 'CN_IDQ_REFERENCE_NOT_VALID');

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;

Line 233: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_AS');

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

Line 234: fnd_message.set_token ('PE_NAME', l_pe_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
238: (p_api_version => 1.0,

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

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,

Line 236: l_note_msg := fnd_message.get;

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,

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

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;

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

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

Line 431: fnd_message.set_token ('INPUT_NAME',

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

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

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;

Line 520: fnd_message.set_name ('CN', 'CN_IDQ_REFERENCE_NOT_VALID');

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;

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

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:

Line 569: fnd_message.set_name ('CN', 'CN_PA_CP_QA_CALC_SEQ_NOTES');

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

Line 570: fnd_message.set_token ('PE_NAME', l_pe_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);
574: l_consolidated_note := fnd_message.get;

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

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:

Line 572: fnd_message.set_token ('OLD_SEQ', old_seq);

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)

Line 573: fnd_message.set_token ('NEW_SEQ', p_quota_assign.quota_sequence);

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

Line 574: l_consolidated_note := fnd_message.get;

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

Line 588: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_AS');

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

Line 589: fnd_message.set_token ('PE_NAME', l_pe_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);
593: /*jtf_notes_pub.create_note

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

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,

Line 591: l_note_msg := fnd_message.get;

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,

Line 614: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');

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

Line 615: fnd_message.set_token ('PE_NAME', 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);
619:

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

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

Line 617: l_note_msg := fnd_message.get;

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,

Line 778: fnd_message.set_name ('CN', 'CN_RECORD_DELETED');

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:

Line 812: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ASPE_UNAS');

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

Line 813: fnd_message.set_token ('PE_NAME', l_pe_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
817: (p_api_version => 1.0,

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

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,

Line 815: l_note_msg := fnd_message.get;

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,