90: WHEN NO_DATA_FOUND
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_CP_NOT_EXIST');
95: fnd_message.set_token ('CP_NAME', p_cp_name);
96: fnd_msg_pub.ADD;
97: END IF;
98:
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_CP_NOT_EXIST');
95: fnd_message.set_token ('CP_NAME', p_cp_name);
96: fnd_msg_pub.ADD;
97: END IF;
98:
99: x_loading_status := 'CN_CP_NOT_EXIST';
112: WHEN NO_DATA_FOUND
113: THEN
114: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
115: THEN
116: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
117: fnd_message.set_token ('PE_NAME', p_pe_name);
118: fnd_msg_pub.ADD;
119: END IF;
120:
113: THEN
114: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
115: THEN
116: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
117: fnd_message.set_token ('PE_NAME', p_pe_name);
118: fnd_msg_pub.ADD;
119: END IF;
120:
121: x_loading_status := 'CN_PLN_NOT_EXIST';
136: WHEN NO_DATA_FOUND
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', 'PLN_QUOTA_ASSIGNED');
141: fnd_msg_pub.ADD;
142: END IF;
143:
144: x_loading_status := 'PLN_QUOTA_ASSIGNED';
160: IF l_rev_class_total <> l_rev_class_total_unique
161: THEN
162: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
163: THEN
164: fnd_message.set_name ('CN', 'PLN_PLAN_DUP_REV_CLASS');
165: fnd_message.set_token ('PLAN_NAME', p_cp_name);
166: fnd_msg_pub.ADD;
167: END IF;
168:
161: THEN
162: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
163: THEN
164: fnd_message.set_name ('CN', 'PLN_PLAN_DUP_REV_CLASS');
165: fnd_message.set_token ('PLAN_NAME', p_cp_name);
166: fnd_msg_pub.ADD;
167: END IF;
168:
169: x_loading_status := 'PLN_PLAN_DUP_REV_CLASS';
192: IF l_flag = true
193: THEN
194: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
195: THEN
196: fnd_message.set_name ('CN', 'CN_PLAN_ELT_DISJOINT');
197: fnd_msg_pub.ADD;
198: END IF;
199:
200: x_loading_status := 'CN_PLAN_ELT_DISJOINT';
438: -- Error, check the msg level and add an error message to the
439: -- API message list
440: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
441: THEN
442: fnd_message.set_name ('CN', 'CN_CP_NOT_CONSISTENT');
443: fnd_message.set_token ('CP_NAME', p_cp_rec.NAME);
444: l_lkup_meaning :=
445: cn_api.get_lkup_meaning ('DESC', 'CP_OBJECT_TYPE');
446: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
439: -- API message list
440: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
441: THEN
442: fnd_message.set_name ('CN', 'CN_CP_NOT_CONSISTENT');
443: fnd_message.set_token ('CP_NAME', p_cp_rec.NAME);
444: l_lkup_meaning :=
445: cn_api.get_lkup_meaning ('DESC', 'CP_OBJECT_TYPE');
446: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
447: fnd_msg_pub.ADD;
442: fnd_message.set_name ('CN', 'CN_CP_NOT_CONSISTENT');
443: fnd_message.set_token ('CP_NAME', p_cp_rec.NAME);
444: l_lkup_meaning :=
445: cn_api.get_lkup_meaning ('DESC', 'CP_OBJECT_TYPE');
446: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
447: fnd_msg_pub.ADD;
448: END IF;
449:
450: x_loading_status := 'CN_CP_NOT_CONSISTENT';
457: -- Error, check the msg level and add an error message to the
458: -- API message list
459: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
460: THEN
461: fnd_message.set_name ('CN', 'CN_CP_NOT_CONSISTENT');
462: fnd_message.set_token ('CP_NAME', p_cp_rec.NAME);
463: l_lkup_meaning :=
464: cn_api.get_lkup_meaning ('START_DATE', 'CP_OBJECT_TYPE');
465: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
458: -- API message list
459: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
460: THEN
461: fnd_message.set_name ('CN', 'CN_CP_NOT_CONSISTENT');
462: fnd_message.set_token ('CP_NAME', p_cp_rec.NAME);
463: l_lkup_meaning :=
464: cn_api.get_lkup_meaning ('START_DATE', 'CP_OBJECT_TYPE');
465: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
466: fnd_msg_pub.ADD;
461: fnd_message.set_name ('CN', 'CN_CP_NOT_CONSISTENT');
462: fnd_message.set_token ('CP_NAME', p_cp_rec.NAME);
463: l_lkup_meaning :=
464: cn_api.get_lkup_meaning ('START_DATE', 'CP_OBJECT_TYPE');
465: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
466: fnd_msg_pub.ADD;
467: END IF;
468:
469: x_loading_status := 'CN_CP_NOT_CONSISTENT';
478: -- Error, check the msg level and add an error message to the
479: -- API message list
480: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
481: THEN
482: fnd_message.set_name ('CN', 'CN_CP_NOT_CONSISTENT');
483: fnd_message.set_token ('CP_NAME', p_cp_rec.NAME);
484: l_lkup_meaning :=
485: cn_api.get_lkup_meaning ('END_DATE', 'CP_OBJECT_TYPE');
486: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
479: -- API message list
480: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
481: THEN
482: fnd_message.set_name ('CN', 'CN_CP_NOT_CONSISTENT');
483: fnd_message.set_token ('CP_NAME', p_cp_rec.NAME);
484: l_lkup_meaning :=
485: cn_api.get_lkup_meaning ('END_DATE', 'CP_OBJECT_TYPE');
486: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
487: fnd_msg_pub.ADD;
482: fnd_message.set_name ('CN', 'CN_CP_NOT_CONSISTENT');
483: fnd_message.set_token ('CP_NAME', p_cp_rec.NAME);
484: l_lkup_meaning :=
485: cn_api.get_lkup_meaning ('END_DATE', 'CP_OBJECT_TYPE');
486: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
487: fnd_msg_pub.ADD;
488: END IF;
489:
490: x_loading_status := 'CN_CP_NOT_CONSISTENT';
497: -- Error, check the msg level and add an error message to the
498: -- API message list
499: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
500: THEN
501: fnd_message.set_name ('CN', 'CN_CP_NOT_CONSISTENT');
502: fnd_message.set_token ('CP_NAME', p_cp_rec.NAME);
503: l_lkup_meaning :=
504: cn_api.get_lkup_meaning ('REV_CLS_OVERLAP', 'CP_OBJECT_TYPE');
505: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
498: -- API message list
499: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
500: THEN
501: fnd_message.set_name ('CN', 'CN_CP_NOT_CONSISTENT');
502: fnd_message.set_token ('CP_NAME', p_cp_rec.NAME);
503: l_lkup_meaning :=
504: cn_api.get_lkup_meaning ('REV_CLS_OVERLAP', 'CP_OBJECT_TYPE');
505: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
506: fnd_msg_pub.ADD;
501: fnd_message.set_name ('CN', 'CN_CP_NOT_CONSISTENT');
502: fnd_message.set_token ('CP_NAME', p_cp_rec.NAME);
503: l_lkup_meaning :=
504: cn_api.get_lkup_meaning ('REV_CLS_OVERLAP', 'CP_OBJECT_TYPE');
505: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
506: fnd_msg_pub.ADD;
507: END IF;
508:
509: x_loading_status := 'CN_CP_NOT_CONSISTENT';
603: IF (p_cp_rec.rc_overlap NOT IN ('Y', 'N'))
604: THEN
605: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
606: THEN
607: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
608: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
609: fnd_msg_pub.ADD;
610: END IF;
611:
604: THEN
605: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
606: THEN
607: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
608: fnd_message.set_token ('OBJ_NAME', l_lkup_meaning);
609: fnd_msg_pub.ADD;
610: END IF;
611:
612: x_loading_status := 'CN_INVALID_DATA';
666: )
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_INVALID_DATE_RANGE');
671: fnd_msg_pub.ADD;
672: END IF;
673:
674: x_loading_status := 'INVALID_END_DATE';
977:
978: /* Added the Notes for R12 */
979:
980: l_status_code := l_cp_rec.status;
981: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_CREATE');
982: fnd_message.set_token ('CP_NAME', l_cp_rec.NAME);
983: l_note_msg := fnd_message.get;
984: jtf_notes_pub.create_note
985: (p_api_version => 1.0,
978: /* Added the Notes for R12 */
979:
980: l_status_code := l_cp_rec.status;
981: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_CREATE');
982: fnd_message.set_token ('CP_NAME', l_cp_rec.NAME);
983: l_note_msg := fnd_message.get;
984: jtf_notes_pub.create_note
985: (p_api_version => 1.0,
986: x_return_status => x_return_status,
979:
980: l_status_code := l_cp_rec.status;
981: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_CREATE');
982: fnd_message.set_token ('CP_NAME', l_cp_rec.NAME);
983: l_note_msg := fnd_message.get;
984: jtf_notes_pub.create_note
985: (p_api_version => 1.0,
986: x_return_status => x_return_status,
987: x_msg_count => x_msg_count,