DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on FND_MSG_PUB

Line 1141: fnd_msg_pub.initialize;

1137: RAISE fnd_api.g_exc_unexpected_error;
1138: END IF;
1139:
1140: IF fnd_api.to_boolean(p_init_msg_list) THEN
1141: fnd_msg_pub.initialize;
1142: END IF;
1143:
1144: x_return_status := fnd_api.g_ret_sts_success;
1145:

Line 1182: fnd_msg_pub.ADD;

1178: l_skills_flag := 'N';
1179: -- If none of the other Flags are set we have an error situation
1180: IF l_contracts_flag = 'N' AND l_ib_flag = 'N' AND l_territory_flag = 'N' AND NOT l_has_suggested_res THEN
1181: fnd_message.set_name('CSF', 'CSF_NO_TASK_SKILL_RES');
1182: fnd_msg_pub.ADD;
1183: RAISE fnd_api.g_exc_error;
1184: END IF;
1185: END IF;
1186: END IF;

Line 1407: fnd_msg_pub.ADD;

1403: EXCEPTION
1404: WHEN e_no_res THEN
1405: x_return_status := fnd_api.g_ret_sts_error;
1406: fnd_message.set_name('CSF', get_assign_error_msg(l_stic));
1407: fnd_msg_pub.ADD;
1408: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1409: WHEN fnd_api.g_exc_error THEN
1410: x_return_status := fnd_api.g_ret_sts_error;
1411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1404: WHEN e_no_res THEN
1405: x_return_status := fnd_api.g_ret_sts_error;
1406: fnd_message.set_name('CSF', get_assign_error_msg(l_stic));
1407: fnd_msg_pub.ADD;
1408: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1409: WHEN fnd_api.g_exc_error THEN
1410: x_return_status := fnd_api.g_ret_sts_error;
1411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1412: WHEN fnd_api.g_exc_unexpected_error THEN

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

1407: fnd_msg_pub.ADD;
1408: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1409: WHEN fnd_api.g_exc_error THEN
1410: x_return_status := fnd_api.g_ret_sts_error;
1411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1412: WHEN fnd_api.g_exc_unexpected_error THEN
1413: x_return_status := fnd_api.g_ret_sts_unexp_error;
1414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1415: WHEN OTHERS THEN

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

1410: x_return_status := fnd_api.g_ret_sts_error;
1411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1412: WHEN fnd_api.g_exc_unexpected_error THEN
1413: x_return_status := fnd_api.g_ret_sts_unexp_error;
1414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1415: WHEN OTHERS THEN
1416: x_return_status := fnd_api.g_ret_sts_unexp_error;
1417: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1418: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

1413: x_return_status := fnd_api.g_ret_sts_unexp_error;
1414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1415: WHEN OTHERS THEN
1416: x_return_status := fnd_api.g_ret_sts_unexp_error;
1417: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1418: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1419: END IF;
1420: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1421: END get_resources_to_schedule;

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

1414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1415: WHEN OTHERS THEN
1416: x_return_status := fnd_api.g_ret_sts_unexp_error;
1417: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1418: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1419: END IF;
1420: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1421: END get_resources_to_schedule;
1422:

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

1416: x_return_status := fnd_api.g_ret_sts_unexp_error;
1417: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1418: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1419: END IF;
1420: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1421: END get_resources_to_schedule;
1422:
1423: /**
1424: * Gets the Qualified Resources for a Task in a format understood by Request Model.

Line 1465: fnd_msg_pub.initialize;

1461: RAISE fnd_api.g_exc_unexpected_error;
1462: END IF;
1463:
1464: IF fnd_api.to_boolean(p_init_msg_list) THEN
1465: fnd_msg_pub.initialize;
1466: END IF;
1467:
1468: x_return_status := fnd_api.g_ret_sts_success;
1469:

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

1527: END IF;
1528: EXCEPTION
1529: WHEN fnd_api.g_exc_error THEN
1530: x_return_status := fnd_api.g_ret_sts_error;
1531: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1532: WHEN fnd_api.g_exc_unexpected_error THEN
1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1535: WHEN OTHERS THEN

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

1530: x_return_status := fnd_api.g_ret_sts_error;
1531: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1532: WHEN fnd_api.g_exc_unexpected_error THEN
1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1535: WHEN OTHERS THEN
1536: x_return_status := fnd_api.g_ret_sts_unexp_error;
1537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1538: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1535: WHEN OTHERS THEN
1536: x_return_status := fnd_api.g_ret_sts_unexp_error;
1537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1538: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1539: END IF;
1540: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1541: END get_resources_to_schedule;

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

1534: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1535: WHEN OTHERS THEN
1536: x_return_status := fnd_api.g_ret_sts_unexp_error;
1537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1538: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1539: END IF;
1540: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1541: END get_resources_to_schedule;
1542:

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

1536: x_return_status := fnd_api.g_ret_sts_unexp_error;
1537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1538: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1539: END IF;
1540: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1541: END get_resources_to_schedule;
1542:
1543:
1544: /**

Line 1865: fnd_msg_pub.initialize;

1861: END IF;
1862:
1863: -- Initialize message list if p_init_msg_list is set to TRUE
1864: IF fnd_api.to_boolean(p_init_msg_list) THEN
1865: fnd_msg_pub.initialize;
1866: END IF;
1867:
1868: -- Initialize API return status to success
1869: x_return_status := fnd_api.g_ret_sts_success;

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

1899:
1900: EXCEPTION
1901: WHEN fnd_api.g_exc_error THEN
1902: x_return_status := fnd_api.g_ret_sts_error;
1903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1904: WHEN fnd_api.g_exc_unexpected_error THEN
1905: x_return_status := fnd_api.g_ret_sts_unexp_error;
1906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1907: WHEN OTHERS THEN

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

1902: x_return_status := fnd_api.g_ret_sts_error;
1903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1904: WHEN fnd_api.g_exc_unexpected_error THEN
1905: x_return_status := fnd_api.g_ret_sts_unexp_error;
1906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1907: WHEN OTHERS THEN
1908: x_return_status := fnd_api.g_ret_sts_unexp_error;
1909: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1910: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

1905: x_return_status := fnd_api.g_ret_sts_unexp_error;
1906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1907: WHEN OTHERS THEN
1908: x_return_status := fnd_api.g_ret_sts_unexp_error;
1909: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1910: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1911: END IF;
1912: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1913: END convert_timezone;

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

1906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1907: WHEN OTHERS THEN
1908: x_return_status := fnd_api.g_ret_sts_unexp_error;
1909: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1910: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1911: END IF;
1912: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1913: END convert_timezone;
1914:

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

1908: x_return_status := fnd_api.g_ret_sts_unexp_error;
1909: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1910: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1911: END IF;
1912: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1913: END convert_timezone;
1914:
1915: /**
1916: * Gets the Shift Definitions of the given Resource between the two given Dates.

Line 1984: fnd_msg_pub.initialize;

1980: RAISE fnd_api.g_exc_unexpected_error;
1981: END IF;
1982:
1983: IF fnd_api.to_boolean(p_init_msg_list) THEN
1984: fnd_msg_pub.initialize;
1985: END IF;
1986:
1987: x_return_status := fnd_api.g_ret_sts_success;
1988:

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

2035:
2036: EXCEPTION
2037: WHEN fnd_api.g_exc_error THEN
2038: x_return_status := fnd_api.g_ret_sts_error;
2039: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2040: WHEN fnd_api.g_exc_unexpected_error THEN
2041: x_return_status := fnd_api.g_ret_sts_unexp_error;
2042: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2043: WHEN OTHERS THEN

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

2038: x_return_status := fnd_api.g_ret_sts_error;
2039: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2040: WHEN fnd_api.g_exc_unexpected_error THEN
2041: x_return_status := fnd_api.g_ret_sts_unexp_error;
2042: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2043: WHEN OTHERS THEN
2044: x_return_status := fnd_api.g_ret_sts_unexp_error;
2045: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2046: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

2041: x_return_status := fnd_api.g_ret_sts_unexp_error;
2042: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2043: WHEN OTHERS THEN
2044: x_return_status := fnd_api.g_ret_sts_unexp_error;
2045: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2046: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2047: END IF;
2048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2049: END get_resource_shifts;

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

2042: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2043: WHEN OTHERS THEN
2044: x_return_status := fnd_api.g_ret_sts_unexp_error;
2045: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2046: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2047: END IF;
2048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2049: END get_resource_shifts;
2050:

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

2044: x_return_status := fnd_api.g_ret_sts_unexp_error;
2045: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2046: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2047: END IF;
2048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2049: END get_resource_shifts;
2050:
2051:
2052: BEGIN