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

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

215: EXCEPTION
216: WHEN fnd_api.g_exc_error
217: THEN
218: x_return_status := fnd_api.g_ret_sts_error;
219: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
220: WHEN fnd_api.g_exc_unexpected_error
221: THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

219: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
220: WHEN fnd_api.g_exc_unexpected_error
221: THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
224: WHEN OTHERS
225: THEN
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

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

223: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
224: WHEN OTHERS
225: THEN
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
228: THEN
229: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
230: END IF;
231: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 229: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');

225: THEN
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
228: THEN
229: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
230: END IF;
231: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
232:
233: END add_system_note;

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

227: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
228: THEN
229: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
230: END IF;
231: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
232:
233: END add_system_note;
234:
235: -- Start of comments

Line 317: fnd_msg_pub.initialize;

313:
314: -- Initialize message list if p_init_msg_list is set to TRUE.
315: IF fnd_api.to_boolean (p_init_msg_list)
316: THEN
317: fnd_msg_pub.initialize;
318: END IF;
319:
320: -- Initialize API return status to success
321: x_return_status := fnd_api.g_ret_sts_success;

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

408: COMMIT WORK;
409: END IF;
410:
411: -- Standard call to get message count and if count is 1, get message info.
412: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
413: EXCEPTION
414: WHEN fnd_api.g_exc_error
415: THEN
416: ROLLBACK TO create_rt_quota_asgn;

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

414: WHEN fnd_api.g_exc_error
415: THEN
416: ROLLBACK TO create_rt_quota_asgn;
417: x_return_status := fnd_api.g_ret_sts_error;
418: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
419: WHEN fnd_api.g_exc_unexpected_error
420: THEN
421: ROLLBACK TO create_rt_quota_asgn;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

419: WHEN fnd_api.g_exc_unexpected_error
420: THEN
421: ROLLBACK TO create_rt_quota_asgn;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
424: WHEN OTHERS
425: THEN
426: ROLLBACK TO create_rt_quota_asgn;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

425: THEN
426: ROLLBACK TO create_rt_quota_asgn;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428:
429: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
430: THEN
431: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
432: END IF;
433:

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

427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428:
429: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
430: THEN
431: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
432: END IF;
433:
434: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
435: END create_rate_table_assignment;

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

430: THEN
431: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
432: END IF;
433:
434: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
435: END create_rate_table_assignment;
436:
437: -- Start of comments
438: -- API name : Update_Rt_Quota_Asgn

Line 529: fnd_msg_pub.initialize;

525:
526: -- Initialize message list if p_init_msg_list is set to TRUE.
527: IF fnd_api.to_boolean (p_init_msg_list)
528: THEN
529: fnd_msg_pub.initialize;
530: END IF;
531:
532: -- Initialize API return status to success
533: x_return_status := fnd_api.g_ret_sts_success;

Line 624: fnd_msg_pub.ADD;

620: -- 3. check object version number
621: IF l_old_rt_quota_asgn.object_version_number <> p_rt_quota_asgn.object_version_number
622: THEN
623: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
624: fnd_msg_pub.ADD;
625: RAISE fnd_api.g_exc_error;
626: END IF;
627:
628: cn_rt_quota_asgns_pkg.begin_record (x_org_id => p_rt_quota_asgn.org_id,

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

681: COMMIT WORK;
682: END IF;
683:
684: -- Standard call to get message count and if count is 1, get message info.
685: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
686: EXCEPTION
687: WHEN fnd_api.g_exc_error
688: THEN
689: ROLLBACK TO update_rt_quota_asgn;

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

687: WHEN fnd_api.g_exc_error
688: THEN
689: ROLLBACK TO update_rt_quota_asgn;
690: x_return_status := fnd_api.g_ret_sts_error;
691: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
692: WHEN fnd_api.g_exc_unexpected_error
693: THEN
694: ROLLBACK TO update_rt_quota_asgn;
695: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

692: WHEN fnd_api.g_exc_unexpected_error
693: THEN
694: ROLLBACK TO update_rt_quota_asgn;
695: x_return_status := fnd_api.g_ret_sts_unexp_error;
696: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
697: WHEN OTHERS
698: THEN
699: ROLLBACK TO update_rt_quota_asgn;
700: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

698: THEN
699: ROLLBACK TO update_rt_quota_asgn;
700: x_return_status := fnd_api.g_ret_sts_unexp_error;
701:
702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
703: THEN
704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
705: END IF;
706:

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

700: x_return_status := fnd_api.g_ret_sts_unexp_error;
701:
702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
703: THEN
704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
705: END IF;
706:
707: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
708: END update_rate_table_assignment;

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

703: THEN
704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
705: END IF;
706:
707: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
708: END update_rate_table_assignment;
709:
710: -- Start of comments
711: -- API name : Delete_Rt_Quota_Asgn

Line 796: fnd_msg_pub.initialize;

792:
793: -- Initialize message list if p_init_msg_list is set to TRUE.
794: IF fnd_api.to_boolean (p_init_msg_list)
795: THEN
796: fnd_msg_pub.initialize;
797: END IF;
798:
799: -- Initialize API return status to success
800: x_return_status := fnd_api.g_ret_sts_success;

Line 812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

808: and rownum = 1;
809:
810: IF l_temp_count > 0 THEN
811:
812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
813: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_RULE_ASGNED');
814: FND_MSG_PUB.Add;
815: END IF;
816: RAISE FND_API.G_EXC_ERROR ;

Line 814: FND_MSG_PUB.Add;

810: IF l_temp_count > 0 THEN
811:
812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
813: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_RULE_ASGNED');
814: FND_MSG_PUB.Add;
815: END IF;
816: RAISE FND_API.G_EXC_ERROR ;
817: END IF;*/
818: SELECT p_rt_quota_asgn.org_id,

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

937: COMMIT WORK;
938: END IF;
939:
940: -- Standard call to get message count and if count is 1, get message info.
941: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
942: EXCEPTION
943: WHEN fnd_api.g_exc_error
944: THEN
945: ROLLBACK TO delete_rt_quota_asgn;

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

943: WHEN fnd_api.g_exc_error
944: THEN
945: ROLLBACK TO delete_rt_quota_asgn;
946: x_return_status := fnd_api.g_ret_sts_error;
947: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
948: WHEN fnd_api.g_exc_unexpected_error
949: THEN
950: ROLLBACK TO delete_rt_quota_asgn;
951: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

948: WHEN fnd_api.g_exc_unexpected_error
949: THEN
950: ROLLBACK TO delete_rt_quota_asgn;
951: x_return_status := fnd_api.g_ret_sts_unexp_error;
952: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
953: WHEN OTHERS
954: THEN
955: ROLLBACK TO delete_rt_quota_asgn;
956: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

954: THEN
955: ROLLBACK TO delete_rt_quota_asgn;
956: x_return_status := fnd_api.g_ret_sts_unexp_error;
957:
958: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
959: THEN
960: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
961: END IF;
962:

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

956: x_return_status := fnd_api.g_ret_sts_unexp_error;
957:
958: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
959: THEN
960: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
961: END IF;
962:
963: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
964: END delete_rate_table_assignment;

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

959: THEN
960: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
961: END IF;
962:
963: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
964: END delete_rate_table_assignment;
965:
966: -- Start of comments
967: -- API name : get_formula_rate_tables

Line 1052: fnd_msg_pub.initialize;

1048:
1049: -- Initialize message list if p_init_msg_list is set to TRUE.
1050: IF fnd_api.to_boolean (p_init_msg_list)
1051: THEN
1052: fnd_msg_pub.initialize;
1053: END IF;
1054:
1055: -- Initialize API return status to success
1056: x_return_status := fnd_api.g_ret_sts_success;

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

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

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

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

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

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

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

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

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

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

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

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

Line 1200: fnd_msg_pub.initialize;

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

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

1213: END IF;
1214:
1215: IF p_rt_quota_asgn.rate_schedule_id IS NULL
1216: THEN
1217: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1218: THEN
1219: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1220: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('CALC_FORMULA_ID', 'PE_OBJECT_TYPE'));
1221: fnd_msg_pub.ADD;

Line 1221: fnd_msg_pub.ADD;

1217: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1218: THEN
1219: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1220: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('CALC_FORMULA_ID', 'PE_OBJECT_TYPE'));
1221: fnd_msg_pub.ADD;
1222: RAISE fnd_api.g_exc_error;
1223: END IF;
1224: ELSE
1225: BEGIN

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

1229: WHERE rate_schedule_id = p_rt_quota_asgn.rate_schedule_id;
1230: EXCEPTION
1231: WHEN NO_DATA_FOUND
1232: THEN
1233: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1234: THEN
1235: fnd_message.set_name ('CN', 'CN_RATE_SCH_NOT_EXIST');
1236: fnd_msg_pub.ADD;
1237: END IF;

Line 1236: fnd_msg_pub.ADD;

1232: THEN
1233: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1234: THEN
1235: fnd_message.set_name ('CN', 'CN_RATE_SCH_NOT_EXIST');
1236: fnd_msg_pub.ADD;
1237: END IF;
1238:
1239: RAISE fnd_api.g_exc_error;
1240: END;

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

1241: END IF;
1242:
1243: IF p_rt_quota_asgn.quota_id IS NULL
1244: THEN
1245: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1246: THEN
1247: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1248: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
1249: fnd_msg_pub.ADD;

Line 1249: fnd_msg_pub.ADD;

1245: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1246: THEN
1247: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1248: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
1249: fnd_msg_pub.ADD;
1250: RAISE fnd_api.g_exc_error;
1251: END IF;
1252: ELSE
1253: BEGIN

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

1257: WHERE quota_id = p_rt_quota_asgn.quota_id;
1258: EXCEPTION
1259: WHEN OTHERS
1260: THEN
1261: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1262: THEN
1263: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1264: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
1265: fnd_msg_pub.ADD;

Line 1265: fnd_msg_pub.ADD;

1261: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1262: THEN
1263: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1264: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
1265: fnd_msg_pub.ADD;
1266: END IF;
1267:
1268: RAISE fnd_api.g_exc_error;
1269: END;

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

1271:
1272: IF p_rt_quota_asgn.calc_formula_id IS NULL
1273: THEN
1274: IF l_formula_type = 'FORMULA' THEN
1275: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1276: THEN
1277: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1278: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('CALC_FORMULA_ID', 'PE_OBJECT_TYPE'));
1279: fnd_msg_pub.ADD;

Line 1279: fnd_msg_pub.ADD;

1275: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1276: THEN
1277: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1278: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('CALC_FORMULA_ID', 'PE_OBJECT_TYPE'));
1279: fnd_msg_pub.ADD;
1280: RAISE fnd_api.g_exc_error;
1281: END IF;
1282: END IF ;
1283: ELSE

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

1288: WHERE fml.calc_formula_id = p_rt_quota_asgn.calc_formula_id;
1289: EXCEPTION
1290: WHEN NO_DATA_FOUND
1291: THEN
1292: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1293: THEN
1294: fnd_message.set_name ('CN', 'CN_FORMULA_NOT_EXIST');
1295: fnd_message.set_token ('FORMULA_NAME', p_rt_quota_asgn.calc_formula_id);
1296: fnd_msg_pub.ADD;

Line 1296: fnd_msg_pub.ADD;

1292: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1293: THEN
1294: fnd_message.set_name ('CN', 'CN_FORMULA_NOT_EXIST');
1295: fnd_message.set_token ('FORMULA_NAME', p_rt_quota_asgn.calc_formula_id);
1296: fnd_msg_pub.ADD;
1297: END IF;
1298:
1299: RAISE fnd_api.g_exc_error;
1300: END;

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

1301: END IF;
1302:
1303: IF (p_rt_quota_asgn.start_date IS NULL)
1304: THEN
1305: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1306: THEN
1307: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1308: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('START_DATE', 'PE_OBJECT_TYPE'));
1309: fnd_msg_pub.ADD;

Line 1309: fnd_msg_pub.ADD;

1305: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1306: THEN
1307: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1308: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('START_DATE', 'PE_OBJECT_TYPE'));
1309: fnd_msg_pub.ADD;
1310: END IF;
1311:
1312: RAISE fnd_api.g_exc_error;
1313: END IF;

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

1314:
1315: -- 3.Start Date > End Date
1316: IF (p_rt_quota_asgn.end_date IS NOT NULL) AND (p_rt_quota_asgn.start_date > p_rt_quota_asgn.end_date)
1317: THEN
1318: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1319: THEN
1320: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');
1321: fnd_msg_pub.ADD;
1322: END IF;

Line 1321: fnd_msg_pub.ADD;

1317: THEN
1318: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1319: THEN
1320: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');
1321: fnd_msg_pub.ADD;
1322: END IF;
1323:
1324: RAISE fnd_api.g_exc_error;
1325: END IF;

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

1351: AND p_rt_quota_asgn.start_date <= NVL(rta.end_date,p_rt_quota_asgn.start_date) ;
1352:
1353: IF l_counter > 0
1354: THEN
1355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1356: THEN
1357: fnd_message.set_name ('CN', 'CN_DATE_OVERLAP');
1358: fnd_msg_pub.ADD;
1359: RAISE fnd_api.g_exc_error;

Line 1358: fnd_msg_pub.ADD;

1354: THEN
1355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1356: THEN
1357: fnd_message.set_name ('CN', 'CN_DATE_OVERLAP');
1358: fnd_msg_pub.ADD;
1359: RAISE fnd_api.g_exc_error;
1360: END IF;
1361: END IF;
1362:

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

1366: WHERE calc_formula_id = p_rt_quota_asgn.calc_formula_id;
1367: SELECT NUMBER_DIM INTO l_rate_dim FROM CN_RATE_SCHEDULES
1368: WHERE rate_schedule_id = p_rt_quota_asgn.rate_schedule_id;
1369: IF l_formula_dim <> l_rate_dim THEN
1370: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1371: THEN
1372: fnd_message.set_name ('CN', 'CN_PE_DIMS_NOT_EQUAL');
1373: fnd_msg_pub.ADD;
1374: RAISE fnd_api.g_exc_error;

Line 1373: fnd_msg_pub.ADD;

1369: IF l_formula_dim <> l_rate_dim THEN
1370: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1371: THEN
1372: fnd_message.set_name ('CN', 'CN_PE_DIMS_NOT_EQUAL');
1373: fnd_msg_pub.ADD;
1374: RAISE fnd_api.g_exc_error;
1375: END IF;
1376: END IF;
1377:

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

1385: COMMIT WORK;
1386: END IF;
1387:
1388: -- Standard call to get message count and if count is 1, get message info.
1389: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1390: EXCEPTION
1391: WHEN fnd_api.g_exc_error
1392: THEN
1393: ROLLBACK TO check_rt_quota_asgn;

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

1391: WHEN fnd_api.g_exc_error
1392: THEN
1393: ROLLBACK TO check_rt_quota_asgn;
1394: x_return_status := fnd_api.g_ret_sts_error;
1395: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1396: WHEN fnd_api.g_exc_unexpected_error
1397: THEN
1398: ROLLBACK TO check_rt_quota_asgn;
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1396: WHEN fnd_api.g_exc_unexpected_error
1397: THEN
1398: ROLLBACK TO check_rt_quota_asgn;
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1400: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1401: WHEN OTHERS
1402: THEN
1403: ROLLBACK TO check_rt_quota_asgn;
1404: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1402: THEN
1403: ROLLBACK TO check_rt_quota_asgn;
1404: x_return_status := fnd_api.g_ret_sts_unexp_error;
1405:
1406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1407: THEN
1408: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1409: END IF;
1410:

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

1404: x_return_status := fnd_api.g_ret_sts_unexp_error;
1405:
1406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1407: THEN
1408: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1409: END IF;
1410:
1411: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1412: END validate_rate_table_assignment;

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

1407: THEN
1408: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1409: END IF;
1410:
1411: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1412: END validate_rate_table_assignment;
1413: END cn_rt_quota_asgn_pvt;