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_QUOTA_RULES_GRP dependencies on FND_MSG_PUB

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

41: WHERE NAME = l_pe_rec.NAME and org_id = p_revenue_class_rec.org_id;
42: EXCEPTION
43: WHEN NO_DATA_FOUND
44: THEN
45: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
46: THEN
47: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
48: fnd_message.set_token ('PE_NAME', l_pe_rec.NAME);
49: fnd_msg_pub.ADD;

Line 49: fnd_msg_pub.ADD;

45: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
46: THEN
47: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
48: fnd_message.set_token ('PE_NAME', l_pe_rec.NAME);
49: fnd_msg_pub.ADD;
50: END IF;
51:
52: x_loading_status := 'CN_PLN_NOT_EXIST';
53: RAISE fnd_api.g_exc_error;

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

142: -- Check wheather revenue class allowed for this Quota Type.
143: --+
144: IF (p_pe_rec.incentive_type_code NOT IN ('COMMISSION', 'BONUS'))
145: THEN
146: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
147: THEN
148: fnd_message.set_name ('CN', 'CN_CANNOT_HAVE_REV_CLASS');
149: fnd_message.set_token ('OBJ_VALUE', 'MANUAL');
150: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (p_pe_rec.quota_type_code, 'QUOTA_TYPE'));

Line 154: fnd_msg_pub.ADD;

150: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (p_pe_rec.quota_type_code, 'QUOTA_TYPE'));
151: fnd_message.set_token ('TOKEN1', NULL);
152: fnd_message.set_token ('TOKEN2', NULL);
153: fnd_message.set_token ('TOKEN3', NULL);
154: fnd_msg_pub.ADD;
155: END IF;
156:
157: x_loading_status := 'CN_CANNOT_HAVE_REV_CLASS';
158: RAISE fnd_api.g_exc_error;

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

162: -- Check the revenue class name is exists in the Database.
163: --+
164: IF p_pe_rec.rev_class_id IS NULL AND p_pe_rec.rev_class_name IS NOT NULL
165: THEN
166: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
167: THEN
168: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
169: fnd_msg_pub.ADD;
170: END IF;

Line 169: fnd_msg_pub.ADD;

165: THEN
166: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
167: THEN
168: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
169: fnd_msg_pub.ADD;
170: END IF;
171:
172: x_loading_status := 'CN_REV_CLASS_NOT_EXIST';
173: RAISE fnd_api.g_exc_error;

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

190: IF l_same_pe <> 0
191: THEN
192: -- Error, check the msg level and add an error message to the
193: -- API message list
194: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
195: THEN
196: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXISTS');
197: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
198: fnd_message.set_token ('REVENUE_CLASS_NAME', p_pe_rec.rev_class_name);

Line 199: fnd_msg_pub.ADD;

195: THEN
196: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXISTS');
197: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
198: fnd_message.set_token ('REVENUE_CLASS_NAME', p_pe_rec.rev_class_name);
199: fnd_msg_pub.ADD;
200: END IF;
201:
202: x_loading_status := 'PLN_QUOTA_REV_EXISTS';
203: END IF;

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

206: EXCEPTION
207: WHEN fnd_api.g_exc_error
208: THEN
209: x_return_status := fnd_api.g_ret_sts_error;
210: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
211: WHEN fnd_api.g_exc_unexpected_error
212: THEN
213: x_return_status := fnd_api.g_ret_sts_unexp_error;
214: x_loading_status := 'UNEXPECTED_ERR';

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

211: WHEN fnd_api.g_exc_unexpected_error
212: THEN
213: x_return_status := fnd_api.g_ret_sts_unexp_error;
214: x_loading_status := 'UNEXPECTED_ERR';
215: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
216: WHEN OTHERS
217: THEN
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219: x_loading_status := 'UNEXPECTED_ERR';

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

217: THEN
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219: x_loading_status := 'UNEXPECTED_ERR';
220:
221: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
222: THEN
223: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
224: END IF;
225:

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

219: x_loading_status := 'UNEXPECTED_ERR';
220:
221: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
222: THEN
223: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
224: END IF;
225:
226: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
227: END valid_quota_rules;

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

222: THEN
223: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
224: END IF;
225:
226: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
227: END valid_quota_rules;
228:
229: -- ----------------------------------------------------------------------------+
230: -- Procedure: Check Valid Update

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

254:
255: -- Old revenue class exists and valid in the database
256: IF p_rev_class_name_old IS NULL
257: THEN
258: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
259: THEN
260: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
261: fnd_msg_pub.ADD;
262: END IF;

Line 261: fnd_msg_pub.ADD;

257: THEN
258: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
259: THEN
260: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
261: fnd_msg_pub.ADD;
262: END IF;
263:
264: x_loading_status := 'REV_CLASS_NOT_ASSIGNED';
265: RAISE fnd_api.g_exc_error;

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

266: END IF;
267:
268: IF x_rev_class_id_old IS NULL AND p_rev_class_name_old IS NOT NULL
269: THEN
270: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
271: THEN
272: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
273: fnd_msg_pub.ADD;
274: END IF;

Line 273: fnd_msg_pub.ADD;

269: THEN
270: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
271: THEN
272: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
273: fnd_msg_pub.ADD;
274: END IF;
275:
276: x_loading_status := 'CN_REV_CLASS_NOT_EXIST';
277: RAISE fnd_api.g_exc_error;

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

285: WHERE revenue_class_id = x_rev_class_id_old) AND qr.quota_id = p_new_pe_rec.quota_id;
286:
287: IF l_same_pe = 0
288: THEN
289: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
290: THEN
291: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
292: fnd_msg_pub.ADD;
293: END IF;

Line 292: fnd_msg_pub.ADD;

288: THEN
289: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
290: THEN
291: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
292: fnd_msg_pub.ADD;
293: END IF;
294:
295: x_loading_status := 'REV_CLASS_NOT_ASSIGNED';
296: RAISE fnd_api.g_exc_error;

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

306: WHERE revenue_class_id = p_new_pe_rec.rev_class_id) AND qr.quota_id = p_new_pe_rec.quota_id;
307:
308: IF l_same_pe > 0
309: THEN
310: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
311: THEN
312: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXIST');
313: fnd_message.set_token ('PLAN_NAME', p_new_pe_rec.NAME);
314: fnd_message.set_token ('REVENUE_CLASS_NAME', p_new_pe_rec.rev_class_name);

Line 315: fnd_msg_pub.ADD;

311: THEN
312: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXIST');
313: fnd_message.set_token ('PLAN_NAME', p_new_pe_rec.NAME);
314: fnd_message.set_token ('REVENUE_CLASS_NAME', p_new_pe_rec.rev_class_name);
315: fnd_msg_pub.ADD;
316: END IF;
317:
318: x_loading_status := 'PLN_QUOTA_REV_EXISTS';
319: RAISE fnd_api.g_exc_error;

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

326: x_quota_rule_id_old := cn_chk_plan_element_pkg.get_quota_rule_id (p_quota_id => p_new_pe_rec.quota_id, p_rev_class_id => x_rev_class_id_old);
327:
328: IF x_quota_rule_id_old IS NULL
329: THEN
330: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
331: THEN
332: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
333: fnd_message.set_token ('PLAN_NAME', p_new_pe_rec.NAME);
334: fnd_message.set_token ('REVENUE_CLASS_NAME', p_new_pe_rec.rev_class_name);

Line 335: fnd_msg_pub.ADD;

331: THEN
332: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
333: fnd_message.set_token ('PLAN_NAME', p_new_pe_rec.NAME);
334: fnd_message.set_token ('REVENUE_CLASS_NAME', p_new_pe_rec.rev_class_name);
335: fnd_msg_pub.ADD;
336: END IF;
337:
338: x_loading_status := 'QUOTA_RULE_NOT_EXIST';
339: RAISE fnd_api.g_exc_error;

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

356: END IF;
357:
358: -- End of API body.
359: -- Standard call to get message count and if count is 1, get message info.
360: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
361: EXCEPTION
362: WHEN fnd_api.g_exc_error
363: THEN
364: x_return_status := fnd_api.g_ret_sts_error;

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

361: EXCEPTION
362: WHEN fnd_api.g_exc_error
363: THEN
364: x_return_status := fnd_api.g_ret_sts_error;
365: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
366: WHEN fnd_api.g_exc_unexpected_error
367: THEN
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369: l_loading_status := 'UNEXPECTED_ERR';

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

366: WHEN fnd_api.g_exc_unexpected_error
367: THEN
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369: l_loading_status := 'UNEXPECTED_ERR';
370: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
371: WHEN OTHERS
372: THEN
373: x_return_status := fnd_api.g_ret_sts_unexp_error;
374: x_loading_status := 'UNEXPECTED_ERR';

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

372: THEN
373: x_return_status := fnd_api.g_ret_sts_unexp_error;
374: x_loading_status := 'UNEXPECTED_ERR';
375:
376: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
377: THEN
378: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
379: END IF;
380:

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

374: x_loading_status := 'UNEXPECTED_ERR';
375:
376: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
377: THEN
378: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
379: END IF;
380:
381: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
382: END check_valid_update;

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

377: THEN
378: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
379: END IF;
380:
381: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
382: END check_valid_update;
383:
384: --|/*-----------------------------------------------------------------------+
385: --| Procedure Name: Create_Quota_Rules

Line 430: fnd_msg_pub.initialize;

426: -- Initialize message list if p_init_msg_list is set to TRUE.
427: -- +
428: IF fnd_api.to_boolean (p_init_msg_list)
429: THEN
430: fnd_msg_pub.initialize;
431: END IF;
432:
433: -- +
434: -- Initialize API return status to success

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

539: l_meaning := cn_api.get_lkup_meaning (p_trx_factor_rec_tbl (i).trx_type, 'TRX TYPES');
540:
541: IF l_meaning IS NULL
542: THEN
543: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
544: THEN
545: fnd_message.set_name ('CN', 'CN_TRX_TYPE_NOT_EXISTS');
546: fnd_msg_pub.ADD;
547: END IF;

Line 546: fnd_msg_pub.ADD;

542: THEN
543: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
544: THEN
545: fnd_message.set_name ('CN', 'CN_TRX_TYPE_NOT_EXISTS');
546: fnd_msg_pub.ADD;
547: END IF;
548:
549: x_loading_status := 'CN_TRX_TYPE_NOT_EXISTS';
550: RAISE fnd_api.g_exc_error;

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

606:
607: --+
608: -- Standard call to get message count and if count is 1, get message info.
609: --+
610: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
611: EXCEPTION
612: WHEN fnd_api.g_exc_error
613: THEN
614: ROLLBACK TO create_plan_element;

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

612: WHEN fnd_api.g_exc_error
613: THEN
614: ROLLBACK TO create_plan_element;
615: x_return_status := fnd_api.g_ret_sts_error;
616: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
617: WHEN fnd_api.g_exc_unexpected_error
618: THEN
619: ROLLBACK TO create_plan_element;
620: x_loading_status := 'UNEXPECTED_ERR';

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

618: THEN
619: ROLLBACK TO create_plan_element;
620: x_loading_status := 'UNEXPECTED_ERR';
621: x_return_status := fnd_api.g_ret_sts_unexp_error;
622: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
623: WHEN OTHERS
624: THEN
625: ROLLBACK TO create_plan_element;
626: x_loading_status := 'UNEXPECTED_ERR';

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

625: ROLLBACK TO create_plan_element;
626: x_loading_status := 'UNEXPECTED_ERR';
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628:
629: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
630: THEN
631: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
632: END IF;
633:

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

627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628:
629: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
630: THEN
631: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
632: END IF;
633:
634: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
635: END create_quota_rules;

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

630: THEN
631: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
632: END IF;
633:
634: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
635: END create_quota_rules;
636:
637: --|-------------------------------------------------------------------------+
638: --| Procedure Name: Update_Quota_Rules

Line 682: fnd_msg_pub.initialize;

678: -- Initialize message list if p_init_msg_list is set to TRUE.
679: -- +
680: IF fnd_api.to_boolean (p_init_msg_list)
681: THEN
682: fnd_msg_pub.initialize;
683: END IF;
684:
685: -- +
686: -- Initialize API return status to success

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

839:
840: --+
841: -- Standard call to get message count and if count is 1, get message info.
842: --+
843: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
844: EXCEPTION
845: WHEN fnd_api.g_exc_error
846: THEN
847: ROLLBACK TO update_plan_element;

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

845: WHEN fnd_api.g_exc_error
846: THEN
847: ROLLBACK TO update_plan_element;
848: x_return_status := fnd_api.g_ret_sts_error;
849: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
850: WHEN fnd_api.g_exc_unexpected_error
851: THEN
852: ROLLBACK TO update_plan_element;
853: x_loading_status := 'UNEXPECTED_ERR';

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

851: THEN
852: ROLLBACK TO update_plan_element;
853: x_loading_status := 'UNEXPECTED_ERR';
854: x_return_status := fnd_api.g_ret_sts_unexp_error;
855: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
856: WHEN OTHERS
857: THEN
858: ROLLBACK TO update_plan_element;
859: x_loading_status := 'UNEXPECTED_ERR';

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

858: ROLLBACK TO update_plan_element;
859: x_loading_status := 'UNEXPECTED_ERR';
860: x_return_status := fnd_api.g_ret_sts_unexp_error;
861:
862: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
863: THEN
864: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
865: END IF;
866:

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

860: x_return_status := fnd_api.g_ret_sts_unexp_error;
861:
862: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
863: THEN
864: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
865: END IF;
866:
867: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
868: END update_quota_rules;

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

863: THEN
864: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
865: END IF;
866:
867: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
868: END update_quota_rules;
869:
870: --|-------------------------------------------------------------------------+
871: --| Procedure Name: Delete_Quota_Rules

Line 905: fnd_msg_pub.initialize;

901:
902: -- Initialize message list if p_init_msg_list is set to TRUE.
903: IF fnd_api.to_boolean (p_init_msg_list)
904: THEN
905: fnd_msg_pub.initialize;
906: END IF;
907:
908: -- Initialize API return status to success
909: x_return_status := fnd_api.g_ret_sts_success;

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

939:
940: -- Raise an Error If quota id is null but name is not null
941: IF l_rev_rec.quota_id IS NULL AND p_quota_name IS NOT NULL
942: THEN
943: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
944: THEN
945: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
946: fnd_message.set_token ('PE_NAME', p_quota_name);
947: fnd_msg_pub.ADD;

Line 947: fnd_msg_pub.ADD;

943: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
944: THEN
945: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
946: fnd_message.set_token ('PE_NAME', p_quota_name);
947: fnd_msg_pub.ADD;
948: END IF;
949:
950: x_loading_status := 'CN_PLN_NOT_EXIST';
951: RAISE fnd_api.g_exc_error;

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

961:
962: -- Raise an Error if the Revenue Class iD is Null and Name IS not NUll
963: IF l_rev_rec.revenue_class_id IS NULL AND p_revenue_class_rec_tbl (i).rev_class_name IS NOT NULL
964: THEN
965: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
966: THEN
967: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
968: fnd_msg_pub.ADD;
969: END IF;

Line 968: fnd_msg_pub.ADD;

964: THEN
965: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
966: THEN
967: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
968: fnd_msg_pub.ADD;
969: END IF;
970:
971: x_loading_status := 'CN_REV_CLASS_NOT_EXIST';
972: RAISE fnd_api.g_exc_error;

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

976: l_rev_rec.quota_rule_id := cn_chk_plan_element_pkg.get_quota_rule_id (l_rev_rec.quota_id, l_rev_rec.revenue_class_id);
977:
978: IF l_rev_rec.quota_rule_id IS NULL
979: THEN
980: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
981: THEN
982: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
983: fnd_message.set_token ('PLAN_NAME', p_quota_name);
984: fnd_message.set_token ('REVENUE_CLASS_NAME', p_revenue_class_rec_tbl (i).rev_class_name);

Line 985: fnd_msg_pub.ADD;

981: THEN
982: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
983: fnd_message.set_token ('PLAN_NAME', p_quota_name);
984: fnd_message.set_token ('REVENUE_CLASS_NAME', p_revenue_class_rec_tbl (i).rev_class_name);
985: fnd_msg_pub.ADD;
986: END IF;
987:
988: x_loading_status := 'QUOTA_RULE_NOT_EXIST';
989: RAISE fnd_api.g_exc_error;

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

1011:
1012: --+
1013: -- Standard call to get message count and if count is 1, get message info.
1014: --+
1015: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1016: EXCEPTION
1017: WHEN fnd_api.g_exc_error
1018: THEN
1019: ROLLBACK TO delete_plan_element;

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

1017: WHEN fnd_api.g_exc_error
1018: THEN
1019: ROLLBACK TO delete_plan_element;
1020: x_return_status := fnd_api.g_ret_sts_error;
1021: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1022: WHEN fnd_api.g_exc_unexpected_error
1023: THEN
1024: ROLLBACK TO delete_plan_element;
1025: x_loading_status := 'UNEXPECTED_ERR';

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

1023: THEN
1024: ROLLBACK TO delete_plan_element;
1025: x_loading_status := 'UNEXPECTED_ERR';
1026: x_return_status := fnd_api.g_ret_sts_unexp_error;
1027: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1028: WHEN OTHERS
1029: THEN
1030: ROLLBACK TO delete_plan_element;
1031: x_loading_status := 'UNEXPECTED_ERR';

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

1030: ROLLBACK TO delete_plan_element;
1031: x_loading_status := 'UNEXPECTED_ERR';
1032: x_return_status := fnd_api.g_ret_sts_unexp_error;
1033:
1034: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1035: THEN
1036: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1037: END IF;
1038:

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

1032: x_return_status := fnd_api.g_ret_sts_unexp_error;
1033:
1034: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1035: THEN
1036: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1037: END IF;
1038:
1039: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1040: END delete_quota_rules;

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

1035: THEN
1036: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1037: END IF;
1038:
1039: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1040: END delete_quota_rules;
1041: END cn_quota_rules_grp;