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

Line 76: fnd_msg_pub.initialize;

72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF fnd_api.to_boolean (p_init_msg_list)
75: THEN
76: fnd_msg_pub.initialize;
77: END IF;
78:
79: -- Initialize API return status to success
80: x_return_status := fnd_api.g_ret_sts_success;

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

88: OR (p_quota_assign.comp_plan_id = fnd_api.g_miss_num)
89: OR (p_quota_assign.quota_id IS NULL)
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;

Line 95: fnd_msg_pub.ADD;

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

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

107: AND ROWNUM = 1;
108:
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',

Line 119: fnd_msg_pub.ADD;

115: cn_api.get_lkup_meaning ('PE_NAME',
116: 'INPUT_TOKEN'
117: )
118: );
119: fnd_msg_pub.ADD;
120: END IF;
121:
122: RAISE fnd_api.g_exc_error;
123: END IF;

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

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

Line 141: fnd_msg_pub.ADD;

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

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

170: AND quota_sequence < p_quota_assign.quota_sequence;
171:
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;

Line 177: fnd_msg_pub.ADD;

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

Line 267: fnd_msg_pub.count_and_get (p_count => x_msg_count,

263: COMMIT WORK;
264: END IF;
265:
266: -- Standard call to get message count and if count is 1, get message info.
267: fnd_msg_pub.count_and_get (p_count => x_msg_count,
268: p_data => x_msg_data,
269: p_encoded => fnd_api.g_false
270: );
271: EXCEPTION

Line 276: fnd_msg_pub.count_and_get (p_count => x_msg_count,

272: WHEN fnd_api.g_exc_error
273: THEN
274: ROLLBACK TO create_quota_assign;
275: x_return_status := fnd_api.g_ret_sts_error;
276: fnd_msg_pub.count_and_get (p_count => x_msg_count,
277: p_data => x_msg_data,
278: p_encoded => fnd_api.g_false
279: );
280: WHEN fnd_api.g_exc_unexpected_error

Line 284: fnd_msg_pub.count_and_get (p_count => x_msg_count,

280: WHEN fnd_api.g_exc_unexpected_error
281: THEN
282: ROLLBACK TO create_quota_assign;
283: x_return_status := fnd_api.g_ret_sts_unexp_error;
284: fnd_msg_pub.count_and_get (p_count => x_msg_count,
285: p_data => x_msg_data,
286: p_encoded => fnd_api.g_false
287: );
288: WHEN OTHERS

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

289: THEN
290: ROLLBACK TO create_quota_assign;
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292:
293: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
294: THEN
295: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
296: END IF;
297:

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

291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292:
293: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
294: THEN
295: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
296: END IF;
297:
298: fnd_msg_pub.count_and_get (p_count => x_msg_count,
299: p_data => x_msg_data,

Line 298: fnd_msg_pub.count_and_get (p_count => x_msg_count,

294: THEN
295: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
296: END IF;
297:
298: fnd_msg_pub.count_and_get (p_count => x_msg_count,
299: p_data => x_msg_data,
300: p_encoded => fnd_api.g_false
301: );
302: END create_quota_assign;

Line 385: fnd_msg_pub.initialize;

381:
382: -- Initialize message list if p_init_msg_list is set to TRUE.
383: IF fnd_api.to_boolean (p_init_msg_list)
384: THEN
385: fnd_msg_pub.initialize;
386: END IF;
387:
388: -- Initialize API return status to success
389: x_return_status := fnd_api.g_ret_sts_success;

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

393: -- 1. name can not be null
394: IF (p_quota_assign.comp_plan_id IS NULL)
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;

Line 400: fnd_msg_pub.ADD;

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

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

424: AND ROWNUM = 1;
425:
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',

Line 436: fnd_msg_pub.ADD;

432: cn_api.get_lkup_meaning ('PE_NAME',
433: 'INPUT_TOKEN'
434: )
435: );
436: fnd_msg_pub.ADD;
437: END IF;
438:
439: RAISE fnd_api.g_exc_error;
440: END IF;

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

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

Line 484: fnd_msg_pub.ADD;

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

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

514: AND quota_sequence < p_quota_assign.quota_sequence;
515:
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;

Line 521: fnd_msg_pub.ADD;

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

Line 535: fnd_msg_pub.ADD;

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:
539: cn_quota_assigns_pkg.begin_record

Line 663: fnd_msg_pub.count_and_get (p_count => x_msg_count,

659: COMMIT WORK;
660: END IF;
661:
662: -- Standard call to get message count and if count is 1, get message info.
663: fnd_msg_pub.count_and_get (p_count => x_msg_count,
664: p_data => x_msg_data,
665: p_encoded => fnd_api.g_false
666: );
667: EXCEPTION

Line 672: fnd_msg_pub.count_and_get (p_count => x_msg_count,

668: WHEN fnd_api.g_exc_error
669: THEN
670: ROLLBACK TO update_quota_assign;
671: x_return_status := fnd_api.g_ret_sts_error;
672: fnd_msg_pub.count_and_get (p_count => x_msg_count,
673: p_data => x_msg_data,
674: p_encoded => fnd_api.g_false
675: );
676: WHEN fnd_api.g_exc_unexpected_error

Line 680: fnd_msg_pub.count_and_get (p_count => x_msg_count,

676: WHEN fnd_api.g_exc_unexpected_error
677: THEN
678: ROLLBACK TO update_quota_assign;
679: x_return_status := fnd_api.g_ret_sts_unexp_error;
680: fnd_msg_pub.count_and_get (p_count => x_msg_count,
681: p_data => x_msg_data,
682: p_encoded => fnd_api.g_false
683: );
684: WHEN OTHERS

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

685: THEN
686: ROLLBACK TO update_quota_assign;
687: x_return_status := fnd_api.g_ret_sts_unexp_error;
688:
689: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
690: THEN
691: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
692: END IF;
693:

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

687: x_return_status := fnd_api.g_ret_sts_unexp_error;
688:
689: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
690: THEN
691: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
692: END IF;
693:
694: fnd_msg_pub.count_and_get (p_count => x_msg_count,
695: p_data => x_msg_data,

Line 694: fnd_msg_pub.count_and_get (p_count => x_msg_count,

690: THEN
691: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
692: END IF;
693:
694: fnd_msg_pub.count_and_get (p_count => x_msg_count,
695: p_data => x_msg_data,
696: p_encoded => fnd_api.g_false
697: );
698: END update_quota_assign;

Line 761: fnd_msg_pub.initialize;

757:
758: -- Initialize message list if p_init_msg_list is set to TRUE.
759: IF fnd_api.to_boolean (p_init_msg_list)
760: THEN
761: fnd_msg_pub.initialize;
762: END IF;
763:
764: -- Initialize API return status to success
765: x_return_status := fnd_api.g_ret_sts_success;

Line 779: fnd_msg_pub.ADD;

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:
783: cn_quota_assigns_pkg.begin_record

Line 839: fnd_msg_pub.count_and_get (p_count => x_msg_count,

835: COMMIT WORK;
836: END IF;
837:
838: -- Standard call to get message count and if count is 1, get message info.
839: fnd_msg_pub.count_and_get (p_count => x_msg_count,
840: p_data => x_msg_data,
841: p_encoded => fnd_api.g_false
842: );
843: EXCEPTION

Line 848: fnd_msg_pub.count_and_get (p_count => x_msg_count,

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

Line 856: fnd_msg_pub.count_and_get (p_count => x_msg_count,

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

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

861: THEN
862: ROLLBACK TO delete_quota_assign;
863: x_return_status := fnd_api.g_ret_sts_unexp_error;
864:
865: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
866: THEN
867: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
868: END IF;
869:

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

863: x_return_status := fnd_api.g_ret_sts_unexp_error;
864:
865: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
866: THEN
867: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
868: END IF;
869:
870: fnd_msg_pub.count_and_get (p_count => x_msg_count,
871: p_data => x_msg_data,

Line 870: fnd_msg_pub.count_and_get (p_count => x_msg_count,

866: THEN
867: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
868: END IF;
869:
870: fnd_msg_pub.count_and_get (p_count => x_msg_count,
871: p_data => x_msg_data,
872: p_encoded => fnd_api.g_false
873: );
874: END delete_quota_assign;

Line 942: fnd_msg_pub.initialize;

938:
939: -- Initialize message list if p_init_msg_list is set to TRUE.
940: IF fnd_api.to_boolean (p_init_msg_list)
941: THEN
942: fnd_msg_pub.initialize;
943: END IF;
944:
945: -- Initialize API return status to success
946: x_return_status := fnd_api.g_ret_sts_success;

Line 978: fnd_msg_pub.count_and_get (p_count => x_msg_count,

974: COMMIT WORK;
975: END IF;
976:
977: -- Standard call to get message count and if count is 1, get message info.
978: fnd_msg_pub.count_and_get (p_count => x_msg_count,
979: p_data => x_msg_data,
980: p_encoded => fnd_api.g_false
981: );
982: EXCEPTION

Line 987: fnd_msg_pub.count_and_get (p_count => x_msg_count,

983: WHEN fnd_api.g_exc_error
984: THEN
985: ROLLBACK TO get_quota_assign;
986: x_return_status := fnd_api.g_ret_sts_error;
987: fnd_msg_pub.count_and_get (p_count => x_msg_count,
988: p_data => x_msg_data,
989: p_encoded => fnd_api.g_false
990: );
991: WHEN fnd_api.g_exc_unexpected_error

Line 995: fnd_msg_pub.count_and_get (p_count => x_msg_count,

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

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

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

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

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

Line 1009: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1005: THEN
1006: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1007: END IF;
1008:
1009: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1010: p_data => x_msg_data,
1011: p_encoded => fnd_api.g_false
1012: );
1013: END get_quota_assign;