DBA Data[Home] [Help]

APPS.CSR_RULES_PVT dependencies on FND_MSG_PUB

Line 433: fnd_msg_pub.ADD;

429: END IF;
430:
431: IF p_rule_name IS NULL THEN
432: fnd_message.set_name('CSR', 'CSR_RULE_NAME_NOT_GIVEN');
433: fnd_msg_pub.ADD;
434: RAISE fnd_api.g_exc_error;
435: END IF;
436:
437: IF p_rule_doc IS NULL THEN

Line 439: fnd_msg_pub.ADD;

435: END IF;
436:
437: IF p_rule_doc IS NULL THEN
438: fnd_message.set_name('CSR', 'CSR_RULE_DOC_NOT_GIVEN');
439: fnd_msg_pub.ADD;
440: RAISE fnd_api.g_exc_error;
441: END IF;
442:
443: IF NVL(p_resource_id, -9999) <> -9999 AND NVL(p_resource_type, '-') = '-'

Line 451: fnd_msg_pub.ADD;

447: fnd_message.set_name ('JTF', 'JTF_RS_RESOURCE_PARAM_ID_NULL');
448: ELSE
449: fnd_message.set_name ('JTF', 'JTF_RS_RESOURCE_CATEGORY_NULL');
450: END IF;
451: fnd_msg_pub.ADD;
452: RAISE fnd_api.g_exc_error;
453: END IF;
454:
455: IF l_debug = 'Y' THEN

Line 467: fnd_msg_pub.ADD;

463: AND (p_terr_id IS NULL OR p_terr_id = g_not_specified)
464: AND (p_resource_id IS NULL OR p_resource_id = g_not_specified)
465: THEN
466: fnd_message.set_name('CSR', 'CSR_RULE_ELIGIBILITY_NOT_GIVEN');
467: fnd_msg_pub.ADD;
468: RAISE fnd_api.g_exc_error;
469: END IF;
470:
471: IF l_debug = 'Y' THEN

Line 483: fnd_msg_pub.ADD;

479:
480: IF l_duplicate_rule.rule_id IS NOT NULL THEN
481: fnd_message.set_name('CSR', 'CSR_RULE_DUPLICATION');
482: fnd_message.set_token ('RULE_NAME', l_duplicate_rule.rule_name);
483: fnd_msg_pub.ADD;
484: RAISE fnd_api.g_exc_error;
485: END IF;
486:
487: IF p_rule_rank NOT IN (0, 2, 4, 8, 16, 32) THEN

Line 879: fnd_msg_pub.initialize;

875: END IF;
876:
877: -- Initialize Message Stack if required
878: IF fnd_api.to_boolean(p_init_msg_list) THEN
879: fnd_msg_pub.initialize;
880: END IF;
881:
882: -- Initialize Return Status
883: x_return_status := fnd_api.g_ret_sts_success;

Line 957: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

953: EXCEPTION
954: WHEN fnd_api.g_exc_error THEN
955: ROLLBACK TO csr_rule_create;
956: x_return_status := fnd_api.g_ret_sts_error;
957: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
958: IF l_debug = 'Y' THEN
959: debug('Create Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
960: END IF;
961: WHEN fnd_api.g_exc_unexpected_error THEN

Line 964: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

960: END IF;
961: WHEN fnd_api.g_exc_unexpected_error THEN
962: ROLLBACK TO csr_rule_create;
963: x_return_status := fnd_api.g_ret_sts_unexp_error;
964: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
965: IF l_debug = 'Y' THEN
966: debug('Create Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
967: END IF;
968: WHEN OTHERS THEN

Line 970: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

966: debug('Create Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
967: END IF;
968: WHEN OTHERS THEN
969: x_return_status := fnd_api.g_ret_sts_unexp_error;
970: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
971: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
972: END IF;
973: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
974: ROLLBACK TO csr_rule_create;

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

967: END IF;
968: WHEN OTHERS THEN
969: x_return_status := fnd_api.g_ret_sts_unexp_error;
970: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
971: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
972: END IF;
973: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
974: ROLLBACK TO csr_rule_create;
975: IF l_debug = 'Y' THEN

Line 973: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

969: x_return_status := fnd_api.g_ret_sts_unexp_error;
970: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
971: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
972: END IF;
973: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
974: ROLLBACK TO csr_rule_create;
975: IF l_debug = 'Y' THEN
976: debug('Create Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
977: END IF;

Line 1049: fnd_msg_pub.initialize;

1045: END IF;
1046:
1047: -- Initialize Message Stack if required
1048: IF fnd_api.to_boolean(p_init_msg_list) THEN
1049: fnd_msg_pub.initialize;
1050: END IF;
1051:
1052: -- Initialize Return Status
1053: x_return_status := fnd_api.g_ret_sts_success;

Line 1082: fnd_msg_pub.ADD;

1078:
1079: IF l_rule.rule_id IS NULL THEN
1080: fnd_message.set_name('CSR', 'CSR_RULE_NOT_FOUND');
1081: fnd_message.set_token('RULE_ID', p_rule_id);
1082: fnd_msg_pub.ADD;
1083: RAISE fnd_api.g_exc_error;
1084: END IF;
1085:
1086: IF l_rule.object_version_number <> p_object_version_number THEN

Line 1088: fnd_msg_pub.ADD;

1084: END IF;
1085:
1086: IF l_rule.object_version_number <> p_object_version_number THEN
1087: fnd_message.set_name ('JTF', 'JTF_API_RECORD_NOT_FOUND');
1088: fnd_msg_pub.ADD;
1089: RAISE fnd_api.g_exc_error;
1090: END IF;
1091:
1092: l_old_rule_doc := l_rule.rule_doc;

Line 1201: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1197: EXCEPTION
1198: WHEN fnd_api.g_exc_error THEN
1199: ROLLBACK TO csr_rule_update;
1200: x_return_status := fnd_api.g_ret_sts_error;
1201: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1202: IF l_debug = 'Y' THEN
1203: debug('Update Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
1204: END IF;
1205: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1208: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1204: END IF;
1205: WHEN fnd_api.g_exc_unexpected_error THEN
1206: ROLLBACK TO csr_rule_update;
1207: x_return_status := fnd_api.g_ret_sts_unexp_error;
1208: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1209: IF l_debug = 'Y' THEN
1210: debug('Update Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
1211: END IF;
1212: WHEN OTHERS THEN

Line 1214: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1210: debug('Update Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
1211: END IF;
1212: WHEN OTHERS THEN
1213: x_return_status := fnd_api.g_ret_sts_unexp_error;
1214: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1215: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1216: END IF;
1217: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1218: ROLLBACK TO csr_rule_update;

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

1211: END IF;
1212: WHEN OTHERS THEN
1213: x_return_status := fnd_api.g_ret_sts_unexp_error;
1214: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1215: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1216: END IF;
1217: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1218: ROLLBACK TO csr_rule_update;
1219: IF l_debug = 'Y' THEN

Line 1217: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1213: x_return_status := fnd_api.g_ret_sts_unexp_error;
1214: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1215: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1216: END IF;
1217: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1218: ROLLBACK TO csr_rule_update;
1219: IF l_debug = 'Y' THEN
1220: debug('Update Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
1221: END IF;

Line 1260: fnd_msg_pub.initialize;

1256: END IF;
1257:
1258: -- Initialize Message Stack if required
1259: IF fnd_api.to_boolean(p_init_msg_list) THEN
1260: fnd_msg_pub.initialize;
1261: END IF;
1262:
1263: -- Initialize Return Status
1264: x_return_status := fnd_api.g_ret_sts_success;

Line 1307: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1303: EXCEPTION
1304: WHEN fnd_api.g_exc_error THEN
1305: ROLLBACK TO csr_rule_delete;
1306: x_return_status := fnd_api.g_ret_sts_error;
1307: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1308: WHEN fnd_api.g_exc_unexpected_error THEN
1309: ROLLBACK TO csr_rule_delete;
1310: x_return_status := fnd_api.g_ret_sts_unexp_error;
1311: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1311: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1307: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1308: WHEN fnd_api.g_exc_unexpected_error THEN
1309: ROLLBACK TO csr_rule_delete;
1310: x_return_status := fnd_api.g_ret_sts_unexp_error;
1311: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1312: WHEN OTHERS THEN
1313: x_return_status := fnd_api.g_ret_sts_unexp_error;
1314: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1315: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1314: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1310: x_return_status := fnd_api.g_ret_sts_unexp_error;
1311: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1312: WHEN OTHERS THEN
1313: x_return_status := fnd_api.g_ret_sts_unexp_error;
1314: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1315: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1316: END IF;
1317: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1318: ROLLBACK TO csr_rule_delete;

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

1311: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1312: WHEN OTHERS THEN
1313: x_return_status := fnd_api.g_ret_sts_unexp_error;
1314: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1315: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1316: END IF;
1317: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1318: ROLLBACK TO csr_rule_delete;
1319: END delete_rule;

Line 1317: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1313: x_return_status := fnd_api.g_ret_sts_unexp_error;
1314: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1315: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1316: END IF;
1317: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1318: ROLLBACK TO csr_rule_delete;
1319: END delete_rule;
1320:
1321: FUNCTION get_sch_parameter_value(

Line 1482: fnd_msg_pub.initialize;

1478: END IF;
1479:
1480: -- Initialize Message Stack if required
1481: IF fnd_api.to_boolean(p_init_msg_list) THEN
1482: fnd_msg_pub.initialize;
1483: END IF;
1484:
1485: -- Initialize Return Status
1486: x_return_status := fnd_api.g_ret_sts_success;

Line 1588: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1584: END IF;
1585: EXCEPTION
1586: WHEN fnd_api.g_exc_error THEN
1587: x_return_status := fnd_api.g_ret_sts_error;
1588: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1589: WHEN fnd_api.g_exc_unexpected_error THEN
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1592: WHEN OTHERS THEN

Line 1591: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1587: x_return_status := fnd_api.g_ret_sts_error;
1588: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1589: WHEN fnd_api.g_exc_unexpected_error THEN
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1592: WHEN OTHERS THEN
1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1595: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1594: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1592: WHEN OTHERS THEN
1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1595: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1596: END IF;
1597: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1598: END get_scheduler_rules;

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

1591: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1592: WHEN OTHERS THEN
1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1595: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1596: END IF;
1597: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1598: END get_scheduler_rules;
1599:

Line 1597: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1595: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1596: END IF;
1597: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1598: END get_scheduler_rules;
1599:
1600: PROCEDURE process_webadi_action(
1601: p_action IN VARCHAR2

Line 1881: fnd_message.set_encoded(fnd_msg_pub.get(fnd_msg_pub.g_last));

1877: debug('Process WebADI Action Errored out. Message Count = ' || l_msg_count || ' : Message Data = ' || l_msg_data, l_api_name, fnd_log.level_error);
1878: END IF;
1879:
1880: IF l_msg_count > 0 THEN
1881: fnd_message.set_encoded(fnd_msg_pub.get(fnd_msg_pub.g_last));
1882: fnd_message.raise_error;
1883: END IF;
1884: END IF;
1885: END IF;