DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on FND_MSG_PUB

Line 1325: fnd_msg_pub.initialize;

1321: RAISE fnd_api.g_exc_unexpected_error;
1322: END IF;
1323:
1324: IF fnd_api.to_boolean(p_init_msg_list) THEN
1325: fnd_msg_pub.initialize;
1326: END IF;
1327:
1328: x_return_status := fnd_api.g_ret_sts_success;
1329:

Line 1384: fnd_msg_pub.ADD;

1380: l_skills_flag := 'N';
1381: -- If none of the other Flags are set we have an error situation
1382: IF l_contracts_flag = 'N' AND l_ib_flag = 'N' AND l_territory_flag = 'N' AND NOT l_has_suggested_res THEN
1383: fnd_message.set_name('CSF', 'CSF_NO_TASK_SKILL_RES');
1384: fnd_msg_pub.ADD;
1385: RAISE fnd_api.g_exc_error;
1386: END IF;
1387: END IF;
1388: END IF;

Line 1719: fnd_msg_pub.ADD;

1715: EXCEPTION
1716: WHEN e_no_res THEN
1717: x_return_status := fnd_api.g_ret_sts_error;
1718: fnd_message.set_name('CSF', get_assign_error_msg(l_stic));
1719: fnd_msg_pub.ADD;
1720: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1721: WHEN fnd_api.g_exc_error THEN
1722: x_return_status := fnd_api.g_ret_sts_error;
1723: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1716: WHEN e_no_res THEN
1717: x_return_status := fnd_api.g_ret_sts_error;
1718: fnd_message.set_name('CSF', get_assign_error_msg(l_stic));
1719: fnd_msg_pub.ADD;
1720: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1721: WHEN fnd_api.g_exc_error THEN
1722: x_return_status := fnd_api.g_ret_sts_error;
1723: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1724: WHEN fnd_api.g_exc_unexpected_error THEN

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

1719: fnd_msg_pub.ADD;
1720: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1721: WHEN fnd_api.g_exc_error THEN
1722: x_return_status := fnd_api.g_ret_sts_error;
1723: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1724: WHEN fnd_api.g_exc_unexpected_error THEN
1725: x_return_status := fnd_api.g_ret_sts_unexp_error;
1726: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1727: WHEN OTHERS THEN

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

1722: x_return_status := fnd_api.g_ret_sts_error;
1723: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1724: WHEN fnd_api.g_exc_unexpected_error THEN
1725: x_return_status := fnd_api.g_ret_sts_unexp_error;
1726: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1727: WHEN OTHERS THEN
1728: x_return_status := fnd_api.g_ret_sts_unexp_error;
1729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1730: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

1725: x_return_status := fnd_api.g_ret_sts_unexp_error;
1726: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1727: WHEN OTHERS THEN
1728: x_return_status := fnd_api.g_ret_sts_unexp_error;
1729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1730: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1731: END IF;
1732: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1733: END get_resources_to_schedule;

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

1726: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1727: WHEN OTHERS THEN
1728: x_return_status := fnd_api.g_ret_sts_unexp_error;
1729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1730: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1731: END IF;
1732: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1733: END get_resources_to_schedule;
1734:

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

1728: x_return_status := fnd_api.g_ret_sts_unexp_error;
1729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1730: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1731: END IF;
1732: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1733: END get_resources_to_schedule;
1734:
1735: /**
1736: * Gets the Qualified Resources for a Task in a format understood by Request Model.

Line 1777: fnd_msg_pub.initialize;

1773: RAISE fnd_api.g_exc_unexpected_error;
1774: END IF;
1775:
1776: IF fnd_api.to_boolean(p_init_msg_list) THEN
1777: fnd_msg_pub.initialize;
1778: END IF;
1779:
1780: x_return_status := fnd_api.g_ret_sts_success;
1781:

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

1860:
1861: EXCEPTION
1862: WHEN fnd_api.g_exc_error THEN
1863: x_return_status := fnd_api.g_ret_sts_error;
1864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1865: WHEN fnd_api.g_exc_unexpected_error THEN
1866: x_return_status := fnd_api.g_ret_sts_unexp_error;
1867: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1868: WHEN OTHERS THEN

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

1863: x_return_status := fnd_api.g_ret_sts_error;
1864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1865: WHEN fnd_api.g_exc_unexpected_error THEN
1866: x_return_status := fnd_api.g_ret_sts_unexp_error;
1867: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1868: WHEN OTHERS THEN
1869: x_return_status := fnd_api.g_ret_sts_unexp_error;
1870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

1866: x_return_status := fnd_api.g_ret_sts_unexp_error;
1867: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1868: WHEN OTHERS THEN
1869: x_return_status := fnd_api.g_ret_sts_unexp_error;
1870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1872: END IF;
1873: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1874: END get_resources_to_schedule;

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

1867: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1868: WHEN OTHERS THEN
1869: x_return_status := fnd_api.g_ret_sts_unexp_error;
1870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1872: END IF;
1873: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1874: END get_resources_to_schedule;
1875:

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

1869: x_return_status := fnd_api.g_ret_sts_unexp_error;
1870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1872: END IF;
1873: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1874: END get_resources_to_schedule;
1875:
1876: PROCEDURE get_resources_to_schedule(
1877: p_api_version IN NUMBER

Line 1924: fnd_msg_pub.initialize;

1920: RAISE fnd_api.g_exc_unexpected_error;
1921: END IF;
1922:
1923: IF fnd_api.to_boolean(p_init_msg_list) THEN
1924: fnd_msg_pub.initialize;
1925: END IF;
1926:
1927: x_return_status := fnd_api.g_ret_sts_success;
1928:

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

2012: END IF;
2013: EXCEPTION
2014: WHEN fnd_api.g_exc_error THEN
2015: x_return_status := fnd_api.g_ret_sts_error;
2016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2017: WHEN fnd_api.g_exc_unexpected_error THEN
2018: x_return_status := fnd_api.g_ret_sts_unexp_error;
2019: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2020: WHEN OTHERS THEN

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

2015: x_return_status := fnd_api.g_ret_sts_error;
2016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2017: WHEN fnd_api.g_exc_unexpected_error THEN
2018: x_return_status := fnd_api.g_ret_sts_unexp_error;
2019: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2020: WHEN OTHERS THEN
2021: x_return_status := fnd_api.g_ret_sts_unexp_error;
2022: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2023: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

2018: x_return_status := fnd_api.g_ret_sts_unexp_error;
2019: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2020: WHEN OTHERS THEN
2021: x_return_status := fnd_api.g_ret_sts_unexp_error;
2022: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2023: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2024: END IF;
2025: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2026: END get_resources_to_schedule;

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

2019: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2020: WHEN OTHERS THEN
2021: x_return_status := fnd_api.g_ret_sts_unexp_error;
2022: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2023: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2024: END IF;
2025: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2026: END get_resources_to_schedule;
2027:

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

2021: x_return_status := fnd_api.g_ret_sts_unexp_error;
2022: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2023: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2024: END IF;
2025: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2026: END get_resources_to_schedule;
2027:
2028: FUNCTION get_resources_to_schedule_pvt(
2029: p_task_id IN NUMBER

Line 2409: fnd_msg_pub.initialize;

2405: END IF;
2406:
2407: -- Initialize message list if p_init_msg_list is set to TRUE
2408: IF fnd_api.to_boolean(p_init_msg_list) THEN
2409: fnd_msg_pub.initialize;
2410: END IF;
2411:
2412: -- Initialize API return status to success
2413: x_return_status := fnd_api.g_ret_sts_success;

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

2443:
2444: EXCEPTION
2445: WHEN fnd_api.g_exc_error THEN
2446: x_return_status := fnd_api.g_ret_sts_error;
2447: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2448: WHEN fnd_api.g_exc_unexpected_error THEN
2449: x_return_status := fnd_api.g_ret_sts_unexp_error;
2450: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2451: WHEN OTHERS THEN

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

2446: x_return_status := fnd_api.g_ret_sts_error;
2447: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2448: WHEN fnd_api.g_exc_unexpected_error THEN
2449: x_return_status := fnd_api.g_ret_sts_unexp_error;
2450: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2451: WHEN OTHERS THEN
2452: x_return_status := fnd_api.g_ret_sts_unexp_error;
2453: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2454: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

2449: x_return_status := fnd_api.g_ret_sts_unexp_error;
2450: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2451: WHEN OTHERS THEN
2452: x_return_status := fnd_api.g_ret_sts_unexp_error;
2453: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2454: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2455: END IF;
2456: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2457: END convert_timezone;

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

2450: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2451: WHEN OTHERS THEN
2452: x_return_status := fnd_api.g_ret_sts_unexp_error;
2453: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2454: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2455: END IF;
2456: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2457: END convert_timezone;
2458:

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

2452: x_return_status := fnd_api.g_ret_sts_unexp_error;
2453: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2454: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2455: END IF;
2456: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2457: END convert_timezone;
2458:
2459: /**
2460: * Gets the Shift Definitions of the given Resource between the two given Dates.

Line 2530: fnd_msg_pub.initialize;

2526: RAISE fnd_api.g_exc_unexpected_error;
2527: END IF;
2528:
2529: IF fnd_api.to_boolean(p_init_msg_list) THEN
2530: fnd_msg_pub.initialize;
2531: END IF;
2532:
2533: x_return_status := fnd_api.g_ret_sts_success;
2534:

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

2585:
2586: EXCEPTION
2587: WHEN fnd_api.g_exc_error THEN
2588: x_return_status := fnd_api.g_ret_sts_error;
2589: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2590: WHEN fnd_api.g_exc_unexpected_error THEN
2591: x_return_status := fnd_api.g_ret_sts_unexp_error;
2592: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2593: WHEN OTHERS THEN

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

2588: x_return_status := fnd_api.g_ret_sts_error;
2589: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2590: WHEN fnd_api.g_exc_unexpected_error THEN
2591: x_return_status := fnd_api.g_ret_sts_unexp_error;
2592: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2593: WHEN OTHERS THEN
2594: x_return_status := fnd_api.g_ret_sts_unexp_error;
2595: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2596: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

2591: x_return_status := fnd_api.g_ret_sts_unexp_error;
2592: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2593: WHEN OTHERS THEN
2594: x_return_status := fnd_api.g_ret_sts_unexp_error;
2595: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2596: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2597: END IF;
2598: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2599: END get_resource_shifts;

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

2592: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2593: WHEN OTHERS THEN
2594: x_return_status := fnd_api.g_ret_sts_unexp_error;
2595: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2596: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2597: END IF;
2598: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2599: END get_resource_shifts;
2600:

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

2594: x_return_status := fnd_api.g_ret_sts_unexp_error;
2595: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2596: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2597: END IF;
2598: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2599: END get_resource_shifts;
2600:
2601: PROCEDURE get_location(
2602: x_return_status OUT NOCOPY VARCHAR2

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

2717: END IF;
2718: EXCEPTION
2719: WHEN OTHERS THEN
2720: x_return_status := fnd_api.g_ret_sts_unexp_error;
2721: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2722: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_LOCATION');
2723: END IF;
2724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2725: END get_location;

Line 2722: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_LOCATION');

2718: EXCEPTION
2719: WHEN OTHERS THEN
2720: x_return_status := fnd_api.g_ret_sts_unexp_error;
2721: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2722: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_LOCATION');
2723: END IF;
2724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2725: END get_location;
2726:

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

2720: x_return_status := fnd_api.g_ret_sts_unexp_error;
2721: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2722: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_LOCATION');
2723: END IF;
2724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2725: END get_location;
2726:
2727: PROCEDURE get_location(
2728: x_return_status OUT NOCOPY VARCHAR2