eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_COMP_PLAN_PVT dependencies on FND_MSG_PUB

Line 74: fnd_msg_pub.ADD;

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

Line 133: fnd_msg_pub.initialize;

129:
130: -- Initialize message list if p_init_msg_list is set to TRUE.
131: IF fnd_api.to_boolean (p_init_msg_list)
132: THEN
133: fnd_msg_pub.initialize;
134: END IF;
135:
136: -- Initialize API return status to success
137: x_return_status := fnd_api.g_ret_sts_success;

Line 151: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

147: OR (p_comp_plan.NAME = fnd_api.g_miss_char)
148: OR (p_comp_plan.start_date IS NULL)
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;

Line 154: fnd_msg_pub.ADD;

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;
158: END IF;

Line 168: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

164: WHERE NAME = p_comp_plan.NAME AND org_id = p_comp_plan.org_id AND ROWNUM = 1;
165:
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;

Line 172: fnd_msg_pub.ADD;

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;
176: END IF;

Line 181: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

177:
178: -- start date > end date
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;

Line 184: fnd_msg_pub.ADD;

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;
188: END IF;

Line 307: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

303: COMMIT WORK;
304: END IF;
305:
306: -- Standard call to get message count and if count is 1, get message info.
307: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
308: EXCEPTION
309: WHEN fnd_api.g_exc_error
310: THEN
311: ROLLBACK TO create_comp_plan;

Line 313: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

309: WHEN fnd_api.g_exc_error
310: THEN
311: ROLLBACK TO create_comp_plan;
312: x_return_status := fnd_api.g_ret_sts_error;
313: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
314: WHEN fnd_api.g_exc_unexpected_error
315: THEN
316: ROLLBACK TO create_comp_plan;
317: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 318: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

314: WHEN fnd_api.g_exc_unexpected_error
315: THEN
316: ROLLBACK TO create_comp_plan;
317: x_return_status := fnd_api.g_ret_sts_unexp_error;
318: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
319: WHEN OTHERS
320: THEN
321: ROLLBACK TO create_comp_plan;
322: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 324: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

320: THEN
321: ROLLBACK TO create_comp_plan;
322: x_return_status := fnd_api.g_ret_sts_unexp_error;
323:
324: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
325: THEN
326: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
327: END IF;
328:

Line 326: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

322: x_return_status := fnd_api.g_ret_sts_unexp_error;
323:
324: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
325: THEN
326: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
327: END IF;
328:
329: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
330: END create_comp_plan;

Line 329: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

325: THEN
326: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
327: END IF;
328:
329: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
330: END create_comp_plan;
331:
332: -- Start of comments
333: -- API name : Update_Comp_Plan

Line 424: fnd_msg_pub.initialize;

420:
421: -- Initialize message list if p_init_msg_list is set to TRUE.
422: IF fnd_api.to_boolean (p_init_msg_list)
423: THEN
424: fnd_msg_pub.initialize;
425: END IF;
426:
427: -- Initialize API return status to success
428: x_return_status := fnd_api.g_ret_sts_success;

Line 436: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

432:
433: -- 1. name can not be null
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;

Line 439: fnd_msg_pub.ADD;

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;
443: END IF;

Line 453: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

449: WHERE NAME = p_comp_plan.NAME AND comp_plan_id <> p_comp_plan.comp_plan_id AND org_id = p_comp_plan.org_id AND ROWNUM = 1;
450:
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;

Line 457: fnd_msg_pub.ADD;

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;
461: END IF;

Line 495: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

491:
492: -- start date > end date
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;

Line 498: fnd_msg_pub.ADD;

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;
502: END IF;

Line 559: fnd_msg_pub.ADD;

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:
563: -- 4. check for consistency in date range assignment

Line 578: fnd_msg_pub.ADD;

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:
582: SELECT COUNT (1)

Line 590: fnd_msg_pub.ADD;

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:
594: -- since srp assignments always within role assignments, then we

Line 810: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

806: COMMIT WORK;
807: END IF;
808:
809: -- Standard call to get message count and if count is 1, get message info.
810: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
811: EXCEPTION
812: WHEN fnd_api.g_exc_error
813: THEN
814: ROLLBACK TO update_comp_plan;

Line 816: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

812: WHEN fnd_api.g_exc_error
813: THEN
814: ROLLBACK TO update_comp_plan;
815: x_return_status := fnd_api.g_ret_sts_error;
816: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
817: WHEN fnd_api.g_exc_unexpected_error
818: THEN
819: ROLLBACK TO update_comp_plan;
820: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 821: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

817: WHEN fnd_api.g_exc_unexpected_error
818: THEN
819: ROLLBACK TO update_comp_plan;
820: x_return_status := fnd_api.g_ret_sts_unexp_error;
821: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
822: WHEN OTHERS
823: THEN
824: ROLLBACK TO update_comp_plan;
825: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 827: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

823: THEN
824: ROLLBACK TO update_comp_plan;
825: x_return_status := fnd_api.g_ret_sts_unexp_error;
826:
827: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
828: THEN
829: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
830: END IF;
831:

Line 829: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

825: x_return_status := fnd_api.g_ret_sts_unexp_error;
826:
827: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
828: THEN
829: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
830: END IF;
831:
832: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
833: END update_comp_plan;

Line 832: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

828: THEN
829: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
830: END IF;
831:
832: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
833: END update_comp_plan;
834:
835: -- Start of comments
836: -- API name : Delete_Comp_Plan

Line 889: fnd_msg_pub.initialize;

885:
886: -- Initialize message list if p_init_msg_list is set to TRUE.
887: IF fnd_api.to_boolean (p_init_msg_list)
888: THEN
889: fnd_msg_pub.initialize;
890: END IF;
891:
892: -- Initialize API return status to success
893: x_return_status := fnd_api.g_ret_sts_success;

Line 985: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

981: COMMIT WORK;
982: END IF;
983:
984: -- Standard call to get message count and if count is 1, get message info.
985: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
986: EXCEPTION
987: WHEN fnd_api.g_exc_error
988: THEN
989: ROLLBACK TO delete_comp_plan;

Line 991: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

987: WHEN fnd_api.g_exc_error
988: THEN
989: ROLLBACK TO delete_comp_plan;
990: x_return_status := fnd_api.g_ret_sts_error;
991: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
992: WHEN fnd_api.g_exc_unexpected_error
993: THEN
994: ROLLBACK TO delete_comp_plan;
995: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 996: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

992: WHEN fnd_api.g_exc_unexpected_error
993: THEN
994: ROLLBACK TO delete_comp_plan;
995: x_return_status := fnd_api.g_ret_sts_unexp_error;
996: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
997: WHEN OTHERS
998: THEN
999: ROLLBACK TO delete_comp_plan;
1000: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1002: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

998: THEN
999: ROLLBACK TO delete_comp_plan;
1000: x_return_status := fnd_api.g_ret_sts_unexp_error;
1001:
1002: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1003: THEN
1004: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1005: END IF;
1006:

Line 1004: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1000: x_return_status := fnd_api.g_ret_sts_unexp_error;
1001:
1002: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1003: THEN
1004: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1005: END IF;
1006:
1007: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1008: END delete_comp_plan;

Line 1007: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1003: THEN
1004: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1005: END IF;
1006:
1007: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1008: END delete_comp_plan;
1009:
1010: -- Start of comments
1011: -- API name : Get_Comp_Plan_Sum

Line 1084: fnd_msg_pub.initialize;

1080:
1081: -- Initialize message list if p_init_msg_list is set to TRUE.
1082: IF fnd_api.to_boolean (p_init_msg_list)
1083: THEN
1084: fnd_msg_pub.initialize;
1085: END IF;
1086:
1087: -- Initialize API return status to success
1088: x_return_status := fnd_api.g_ret_sts_success;

Line 1122: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1118: COMMIT WORK;
1119: END IF;
1120:
1121: -- Standard call to get message count and if count is 1, get message info.
1122: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1123: EXCEPTION
1124: WHEN fnd_api.g_exc_error
1125: THEN
1126: ROLLBACK TO get_comp_plan_sum;

Line 1128: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1124: WHEN fnd_api.g_exc_error
1125: THEN
1126: ROLLBACK TO get_comp_plan_sum;
1127: x_return_status := fnd_api.g_ret_sts_error;
1128: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1129: WHEN fnd_api.g_exc_unexpected_error
1130: THEN
1131: ROLLBACK TO get_comp_plan_sum;
1132: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1133: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1129: WHEN fnd_api.g_exc_unexpected_error
1130: THEN
1131: ROLLBACK TO get_comp_plan_sum;
1132: x_return_status := fnd_api.g_ret_sts_unexp_error;
1133: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1134: WHEN OTHERS
1135: THEN
1136: ROLLBACK TO get_comp_plan_sum;
1137: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1139: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1135: THEN
1136: ROLLBACK TO get_comp_plan_sum;
1137: x_return_status := fnd_api.g_ret_sts_unexp_error;
1138:
1139: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1140: THEN
1141: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1142: END IF;
1143:

Line 1141: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1137: x_return_status := fnd_api.g_ret_sts_unexp_error;
1138:
1139: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1140: THEN
1141: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1142: END IF;
1143:
1144: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1145: END get_comp_plan_sum;

Line 1144: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1140: THEN
1141: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1142: END IF;
1143:
1144: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1145: END get_comp_plan_sum;
1146:
1147: -- Start of comments
1148: -- API name : Get_Comp_Plan_Dtl

Line 1204: fnd_msg_pub.initialize;

1200:
1201: -- Initialize message list if p_init_msg_list is set to TRUE.
1202: IF fnd_api.to_boolean (p_init_msg_list)
1203: THEN
1204: fnd_msg_pub.initialize;
1205: END IF;
1206:
1207: -- Initialize API return status to success
1208: x_return_status := fnd_api.g_ret_sts_success;

Line 1262: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1258: COMMIT WORK;
1259: END IF;
1260:
1261: -- Standard call to get message count and if count is 1, get message info.
1262: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1263: EXCEPTION
1264: WHEN fnd_api.g_exc_error
1265: THEN
1266: ROLLBACK TO get_comp_plan_dtl;

Line 1268: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1264: WHEN fnd_api.g_exc_error
1265: THEN
1266: ROLLBACK TO get_comp_plan_dtl;
1267: x_return_status := fnd_api.g_ret_sts_error;
1268: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1269: WHEN fnd_api.g_exc_unexpected_error
1270: THEN
1271: ROLLBACK TO get_comp_plan_dtl;
1272: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1273: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1269: WHEN fnd_api.g_exc_unexpected_error
1270: THEN
1271: ROLLBACK TO get_comp_plan_dtl;
1272: x_return_status := fnd_api.g_ret_sts_unexp_error;
1273: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1274: WHEN OTHERS
1275: THEN
1276: ROLLBACK TO get_comp_plan_dtl;
1277: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1279: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1275: THEN
1276: ROLLBACK TO get_comp_plan_dtl;
1277: x_return_status := fnd_api.g_ret_sts_unexp_error;
1278:
1279: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1280: THEN
1281: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1282: END IF;
1283:

Line 1281: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1277: x_return_status := fnd_api.g_ret_sts_unexp_error;
1278:
1279: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1280: THEN
1281: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1282: END IF;
1283:
1284: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1285: END get_comp_plan_dtl;

Line 1284: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1280: THEN
1281: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1282: END IF;
1283:
1284: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1285: END get_comp_plan_dtl;
1286:
1287: -- Start of comments
1288: -- API name : Get_Sales_Role

Line 1351: fnd_msg_pub.initialize;

1347:
1348: -- Initialize message list if p_init_msg_list is set to TRUE.
1349: IF fnd_api.to_boolean (p_init_msg_list)
1350: THEN
1351: fnd_msg_pub.initialize;
1352: END IF;
1353:
1354: -- Initialize API return status to success
1355: x_return_status := fnd_api.g_ret_sts_success;

Line 1379: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1375: COMMIT WORK;
1376: END IF;
1377:
1378: -- Standard call to get message count and if count is 1, get message info.
1379: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1380: EXCEPTION
1381: WHEN fnd_api.g_exc_error
1382: THEN
1383: ROLLBACK TO get_sales_role;

Line 1385: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1381: WHEN fnd_api.g_exc_error
1382: THEN
1383: ROLLBACK TO get_sales_role;
1384: x_return_status := fnd_api.g_ret_sts_error;
1385: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1386: WHEN fnd_api.g_exc_unexpected_error
1387: THEN
1388: ROLLBACK TO get_sales_role;
1389: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1390: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1386: WHEN fnd_api.g_exc_unexpected_error
1387: THEN
1388: ROLLBACK TO get_sales_role;
1389: x_return_status := fnd_api.g_ret_sts_unexp_error;
1390: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1391: WHEN OTHERS
1392: THEN
1393: ROLLBACK TO get_sales_role;
1394: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1396: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1392: THEN
1393: ROLLBACK TO get_sales_role;
1394: x_return_status := fnd_api.g_ret_sts_unexp_error;
1395:
1396: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1397: THEN
1398: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1399: END IF;
1400:

Line 1398: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1394: x_return_status := fnd_api.g_ret_sts_unexp_error;
1395:
1396: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1397: THEN
1398: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1399: END IF;
1400:
1401: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1402: END get_sales_role;

Line 1401: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1397: THEN
1398: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1399: END IF;
1400:
1401: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1402: END get_sales_role;
1403:
1404: -- Start of comments
1405: -- API name : Validate_Comp_Plan

Line 1477: fnd_msg_pub.initialize;

1473:
1474: -- Initialize message list if p_init_msg_list is set to TRUE.
1475: IF fnd_api.to_boolean (p_init_msg_list)
1476: THEN
1477: fnd_msg_pub.initialize;
1478: END IF;
1479:
1480: -- Initialize API return status to success
1481: x_return_status := fnd_api.g_ret_sts_success;

Line 1495: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1491: WHERE comp_plan_id = p_comp_plan.comp_plan_id AND ROWNUM = 1;
1492:
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;

Line 1498: fnd_msg_pub.ADD;

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;
1502: END IF;

Line 1517: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1513: END LOOP;
1514:
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;

Line 1521: fnd_msg_pub.ADD;

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;
1525: END IF;

Line 1578: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1574: COMMIT WORK;
1575: END IF;
1576:
1577: -- Standard call to get message count and if count is 1, get message info.
1578: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1579: EXCEPTION
1580: WHEN fnd_api.g_exc_error
1581: THEN
1582: ROLLBACK TO validate_comp_plan;

Line 1584: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1580: WHEN fnd_api.g_exc_error
1581: THEN
1582: ROLLBACK TO validate_comp_plan;
1583: x_return_status := fnd_api.g_ret_sts_error;
1584: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1585: WHEN fnd_api.g_exc_unexpected_error
1586: THEN
1587: ROLLBACK TO validate_comp_plan;
1588: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1589: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1585: WHEN fnd_api.g_exc_unexpected_error
1586: THEN
1587: ROLLBACK TO validate_comp_plan;
1588: x_return_status := fnd_api.g_ret_sts_unexp_error;
1589: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1590: WHEN OTHERS
1591: THEN
1592: ROLLBACK TO validate_comp_plan;
1593: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1595: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1591: THEN
1592: ROLLBACK TO validate_comp_plan;
1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594:
1595: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1596: THEN
1597: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1598: END IF;
1599:

Line 1597: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594:
1595: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1596: THEN
1597: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1598: END IF;
1599:
1600: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1601: END validate_comp_plan;

Line 1600: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1596: THEN
1597: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1598: END IF;
1599:
1600: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1601: END validate_comp_plan;
1602:
1603: --| -----------------------------------------------------------------------=
1604: --| Procedure Name : check_revenue_class_overlap

Line 1702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1698: WHERE comp_plan_id = p_comp_plan_id;
1699: EXCEPTION
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;

Line 1705: fnd_msg_pub.ADD;

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';
1709: x_return_status := fnd_api.g_ret_sts_error;

Line 1729: /* IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1725:
1726: IF (result = false)
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;

Line 1733: fnd_msg_pub.ADD;

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';
1737: x_return_status := fnd_api.g_ret_sts_error;

Line 1854: FND_MSG_PUB.initialize;

1850: -- Initialize message list if p_init_msg_list is set to TRUE.
1851:
1852: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1853:
1854: FND_MSG_PUB.initialize;
1855:
1856: END IF;
1857:
1858: -- Initialize API return status to success

Line 1977: FND_MSG_PUB.Count_And_Get

1973: END IF;
1974:
1975: -- Standard call to get message count and if count is 1, get message info.
1976:
1977: FND_MSG_PUB.Count_And_Get
1978: (p_count => x_msg_count ,
1979: p_data => x_msg_data ,
1980: p_encoded => FND_API.G_FALSE );
1981:

Line 1987: FND_MSG_PUB.count_and_get

1983:
1984: WHEN FND_API.G_EXC_ERROR THEN
1985: ROLLBACK TO duplicate_comp_plan;
1986: x_return_status := FND_API.G_RET_STS_ERROR ;
1987: FND_MSG_PUB.count_and_get
1988: (p_count => x_msg_count ,
1989: p_data => x_msg_data ,
1990: p_encoded => FND_API.G_FALSE );
1991:

Line 1995: FND_MSG_PUB.count_and_get

1991:
1992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1993: ROLLBACK TO duplicate_comp_plan;
1994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1995: FND_MSG_PUB.count_and_get
1996: (p_count => x_msg_count ,
1997: p_data => x_msg_data ,
1998: p_encoded => FND_API.G_FALSE );
1999:

Line 2003: IF FND_MSG_PUB.check_msg_level

1999:
2000: WHEN OTHERS THEN
2001: ROLLBACK TO duplicate_comp_plan;
2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2003: IF FND_MSG_PUB.check_msg_level
2004: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2005: THEN
2006: FND_MSG_PUB.add_exc_msg
2007: (G_PKG_NAME ,

Line 2004: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2000: WHEN OTHERS THEN
2001: ROLLBACK TO duplicate_comp_plan;
2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2003: IF FND_MSG_PUB.check_msg_level
2004: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2005: THEN
2006: FND_MSG_PUB.add_exc_msg
2007: (G_PKG_NAME ,
2008: l_api_name );

Line 2006: FND_MSG_PUB.add_exc_msg

2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2003: IF FND_MSG_PUB.check_msg_level
2004: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2005: THEN
2006: FND_MSG_PUB.add_exc_msg
2007: (G_PKG_NAME ,
2008: l_api_name );
2009: END IF;
2010:

Line 2011: FND_MSG_PUB.count_and_get

2007: (G_PKG_NAME ,
2008: l_api_name );
2009: END IF;
2010:
2011: FND_MSG_PUB.count_and_get
2012: (p_count => x_msg_count ,
2013: p_data => x_msg_data ,
2014: p_encoded => FND_API.G_FALSE );
2015: