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.CSF_RESOURCE_PUB dependencies on FND_API

Line 888: , p_init_msg_list => fnd_api.g_true

884: END LOOP;
885:
886: jtf_calendar_pub.get_resource_shifts(
887: p_api_version => 1
888: , p_init_msg_list => fnd_api.g_true
889: , x_return_status => l_return_status
890: , x_msg_count => l_msg_count
891: , x_msg_data => l_msg_data
892: , p_resource_id => p_res_tbl(i).resource_id

Line 898: IF l_return_status = fnd_api.g_ret_sts_success OR l_shift_tbl.COUNT > 0 THEN

894: , p_start_date => p_start
895: , p_end_date => p_end
896: , x_shift => l_shift_tbl
897: );
898: IF l_return_status = fnd_api.g_ret_sts_success OR l_shift_tbl.COUNT > 0 THEN
899: j := j + 1;
900: l_out_tbl(j) := p_res_tbl(i);
901: EXIT WHEN j = l_max_resources;
902: END IF;

Line 1136: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1132: and i.incident_type_id = iv.incident_type_id;
1133:
1134:
1135: BEGIN
1136: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1137: RAISE fnd_api.g_exc_unexpected_error;
1138: END IF;
1139:
1140: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1137: RAISE fnd_api.g_exc_unexpected_error;

1133:
1134:
1135: BEGIN
1136: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
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;

Line 1140: IF fnd_api.to_boolean(p_init_msg_list) THEN

1136: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
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;

Line 1144: x_return_status := fnd_api.g_ret_sts_success;

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:
1146: IF csf_util_pvt.g_timing_activated THEN
1147: csf_util_pvt.add_timer(105, 'Get resources to schedule (init)', 0, NULL);
1148: END IF;

Line 1183: RAISE fnd_api.g_exc_error;

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;
1187:

Line 1240: , p_init_msg_list => fnd_api.g_false

1236: END IF;
1237:
1238: jtf_assign_pub.get_assign_resources(
1239: p_api_version => 1.0
1240: , p_init_msg_list => fnd_api.g_false
1241: , p_commit => fnd_api.g_false
1242: , x_return_status => x_return_status
1243: , x_msg_count => x_msg_count
1244: , x_msg_data => x_msg_data

Line 1241: , p_commit => fnd_api.g_false

1237:
1238: jtf_assign_pub.get_assign_resources(
1239: p_api_version => 1.0
1240: , p_init_msg_list => fnd_api.g_false
1241: , p_commit => fnd_api.g_false
1242: , x_return_status => x_return_status
1243: , x_msg_count => x_msg_count
1244: , x_msg_data => x_msg_data
1245: , p_sr_task_rec => l_sr_task_rec

Line 1262: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1258: , p_business_process_id => l_business_process_id
1259: , x_assign_resources_tbl => l_contracts_ib_res_tbl
1260: );
1261:
1262: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1263: RAISE fnd_api.g_exc_unexpected_error;
1264: END IF;
1265:
1266: IF l_contracts_ib_res_tbl.COUNT = 0 THEN

Line 1263: RAISE fnd_api.g_exc_unexpected_error;

1259: , x_assign_resources_tbl => l_contracts_ib_res_tbl
1260: );
1261:
1262: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1263: RAISE fnd_api.g_exc_unexpected_error;
1264: END IF;
1265:
1266: IF l_contracts_ib_res_tbl.COUNT = 0 THEN
1267: l_continue_search := FALSE;

Line 1289: , p_init_msg_list => fnd_api.g_false

1285: l_stic := l_stic + 4;
1286:
1287: jtf_assign_pub.get_assign_resources(
1288: p_api_version => 1.0
1289: , p_init_msg_list => fnd_api.g_false
1290: , p_commit => fnd_api.g_false
1291: , x_return_status => x_return_status
1292: , x_msg_count => x_msg_count
1293: , x_msg_data => x_msg_data

Line 1290: , p_commit => fnd_api.g_false

1286:
1287: jtf_assign_pub.get_assign_resources(
1288: p_api_version => 1.0
1289: , p_init_msg_list => fnd_api.g_false
1290: , p_commit => fnd_api.g_false
1291: , x_return_status => x_return_status
1292: , x_msg_count => x_msg_count
1293: , x_msg_data => x_msg_data
1294: , p_sr_task_rec => l_sr_task_rec

Line 1309: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1305: , p_calling_doc_id => l_sr_task_rec.service_request_id
1306: , p_calling_doc_type => g_assign_doc_type
1307: , x_assign_resources_tbl => l_territory_res_tbl
1308: );
1309: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1310: RAISE fnd_api.g_exc_unexpected_error;
1311: END IF;
1312:
1313: IF l_territory_res_tbl.COUNT = 0 THEN

Line 1310: RAISE fnd_api.g_exc_unexpected_error;

1306: , p_calling_doc_type => g_assign_doc_type
1307: , x_assign_resources_tbl => l_territory_res_tbl
1308: );
1309: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1310: RAISE fnd_api.g_exc_unexpected_error;
1311: END IF;
1312:
1313: IF l_territory_res_tbl.COUNT = 0 THEN
1314: l_continue_search := FALSE;

Line 1405: x_return_status := fnd_api.g_ret_sts_error;

1401: csf_util_pvt.add_timer(114, 'reduce sorted resources list', 1, NULL);
1402: END IF;
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

Line 1409: WHEN fnd_api.g_exc_error 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
1413: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1410: 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
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);

Line 1412: WHEN fnd_api.g_exc_unexpected_error THEN

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
1416: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1413: x_return_status := fnd_api.g_ret_sts_unexp_error;

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
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

Line 1416: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
1419: END IF;
1420: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1460: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1456: l_assign_resource_tbl jtf_assign_pub.assignresources_tbl_type;
1457: j PLS_INTEGER;
1458: k PLS_INTEGER;
1459: BEGIN
1460: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1461: RAISE fnd_api.g_exc_unexpected_error;
1462: END IF;
1463:
1464: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1461: RAISE fnd_api.g_exc_unexpected_error;

1457: j PLS_INTEGER;
1458: k PLS_INTEGER;
1459: BEGIN
1460: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
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;

Line 1464: IF fnd_api.to_boolean(p_init_msg_list) THEN

1460: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
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;

Line 1468: x_return_status := fnd_api.g_ret_sts_success;

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:
1470: get_resources_to_schedule(
1471: p_api_version => 1
1472: , p_init_msg_list => fnd_api.g_false

Line 1472: , p_init_msg_list => fnd_api.g_false

1468: x_return_status := fnd_api.g_ret_sts_success;
1469:
1470: get_resources_to_schedule(
1471: p_api_version => 1
1472: , p_init_msg_list => fnd_api.g_false
1473: , x_return_status => x_return_status
1474: , x_msg_count => x_msg_count
1475: , x_msg_data => x_msg_data
1476: , p_task_id => p_task_id

Line 1503: IF x_return_status = fnd_api.g_ret_sts_success AND l_assign_resource_tbl.COUNT > 0 THEN

1499: --start with an empty table so that previous value are deleted
1500: x_res_tbl.delete;
1501:
1502: -- if qualified resoucres are found, add them to the output list
1503: IF x_return_status = fnd_api.g_ret_sts_success AND l_assign_resource_tbl.COUNT > 0 THEN
1504:
1505: j := l_assign_resource_tbl.FIRST;
1506: WHILE j IS NOT NULL LOOP
1507: x_res_tbl.EXTEND;

Line 1529: WHEN fnd_api.g_exc_error THEN

1525: j := l_assign_resource_tbl.NEXT(j);
1526: END LOOP;
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;

Line 1530: x_return_status := fnd_api.g_ret_sts_error;

1526: END LOOP;
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);

Line 1532: WHEN fnd_api.g_exc_unexpected_error THEN

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
1536: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1533: x_return_status := fnd_api.g_ret_sts_unexp_error;

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
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

Line 1536: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
1539: END IF;
1540: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1708: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1704: , p_date => p_date
1705: , x_address_rec => l_res_cache_info.address
1706: );
1707:
1708: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1709: RETURN NULL;
1710: END IF;
1711:
1712: l_found := FALSE;

Line 1822: * 'T' (FND_API.G_TRUE) to make it return the other way round.

1818: * or vice versa.
1819: *
1820: * By default, the given date is assumed to be in Resource Timezone and the
1821: * date returned is Server Timezone. Set p_server_to_resource parameter as
1822: * 'T' (FND_API.G_TRUE) to make it return the other way round.
1823: *
1824: * Note that the API doesnt support RS_TEAM or RS_GROUP resources.
1825: *
1826: * @param p_api_version API Version (1.0)

Line 1859: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, 'CSF_TASKS_PUB') THEN

1855: WHERE resource_id = p_resource_id
1856: AND p_resource_type NOT IN('RS_GROUP', 'RS_TEAM');
1857: BEGIN
1858: -- Standard call to check for call compatibility
1859: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, 'CSF_TASKS_PUB') THEN
1860: RAISE fnd_api.g_exc_unexpected_error;
1861: END IF;
1862:
1863: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1860: RAISE fnd_api.g_exc_unexpected_error;

1856: AND p_resource_type NOT IN('RS_GROUP', 'RS_TEAM');
1857: BEGIN
1858: -- Standard call to check for call compatibility
1859: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, 'CSF_TASKS_PUB') THEN
1860: RAISE fnd_api.g_exc_unexpected_error;
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

Line 1864: IF fnd_api.to_boolean(p_init_msg_list) THEN

1860: RAISE fnd_api.g_exc_unexpected_error;
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

Line 1869: x_return_status := fnd_api.g_ret_sts_success;

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;
1870:
1871: -- Start actual processing
1872: fnd_profile.get('SERVER_TIMEZONE_ID', l_dest_tz_id);
1873:

Line 1879: IF fnd_api.to_boolean(p_server_to_resource) THEN

1875: FETCH c_resource INTO l_source_tz_id;
1876: CLOSE c_resource;
1877:
1878: -- Reverse conversion when requested
1879: IF fnd_api.to_boolean(p_server_to_resource) THEN
1880: l_temp_tz_id := l_source_tz_id;
1881: l_source_tz_id := l_dest_tz_id;
1882: l_dest_tz_id := l_source_tz_id;
1883: END IF;

Line 1889: , p_init_msg_list => fnd_api.g_false

1885: -- Only try conversion when source and destination timezones are found
1886: IF l_source_tz_id IS NOT NULL AND l_dest_tz_id IS NOT NULL THEN
1887: hz_timezone_pub.get_time(
1888: p_api_version => 1.0
1889: , p_init_msg_list => fnd_api.g_false
1890: , p_source_tz_id => l_source_tz_id
1891: , p_dest_tz_id => l_dest_tz_id
1892: , p_source_day_time => x_datetime
1893: , x_dest_day_time => x_datetime

Line 1901: WHEN fnd_api.g_exc_error THEN

1897: );
1898: END IF;
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;

Line 1902: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1904: WHEN fnd_api.g_exc_unexpected_error THEN

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
1908: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1905: x_return_status := fnd_api.g_ret_sts_unexp_error;

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
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

Line 1908: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
1911: END IF;
1912: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1979: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1975: l_shift_endtime DATE;
1976: i PLS_INTEGER; -- Iterator for JTF's Shift Table
1977: j PLS_INTEGER; -- Iterator for CSF's Shift Table
1978: BEGIN
1979: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1980: RAISE fnd_api.g_exc_unexpected_error;
1981: END IF;
1982:
1983: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1980: RAISE fnd_api.g_exc_unexpected_error;

1976: i PLS_INTEGER; -- Iterator for JTF's Shift Table
1977: j PLS_INTEGER; -- Iterator for CSF's Shift Table
1978: BEGIN
1979: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
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;

Line 1983: IF fnd_api.to_boolean(p_init_msg_list) THEN

1979: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
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;

Line 1987: x_return_status := fnd_api.g_ret_sts_success;

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:
1989: jtf_calendar_pub.get_resource_shifts(
1990: p_api_version => 1.0
1991: , p_resource_id => p_resource_id

Line 2001: IF x_return_status <> fnd_api.g_ret_sts_success OR l_multiday_shifts.COUNT = 0 THEN

1997: , x_msg_data => x_msg_data
1998: , x_shift => l_multiday_shifts
1999: );
2000:
2001: IF x_return_status <> fnd_api.g_ret_sts_success OR l_multiday_shifts.COUNT = 0 THEN
2002: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2003: RAISE fnd_api.g_exc_unexpected_error;
2004: END IF;
2005: RAISE fnd_api.g_exc_error;

Line 2002: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1998: , x_shift => l_multiday_shifts
1999: );
2000:
2001: IF x_return_status <> fnd_api.g_ret_sts_success OR l_multiday_shifts.COUNT = 0 THEN
2002: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2003: RAISE fnd_api.g_exc_unexpected_error;
2004: END IF;
2005: RAISE fnd_api.g_exc_error;
2006: END IF;

Line 2003: RAISE fnd_api.g_exc_unexpected_error;

1999: );
2000:
2001: IF x_return_status <> fnd_api.g_ret_sts_success OR l_multiday_shifts.COUNT = 0 THEN
2002: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2003: RAISE fnd_api.g_exc_unexpected_error;
2004: END IF;
2005: RAISE fnd_api.g_exc_error;
2006: END IF;
2007:

Line 2005: RAISE fnd_api.g_exc_error;

2001: IF x_return_status <> fnd_api.g_ret_sts_success OR l_multiday_shifts.COUNT = 0 THEN
2002: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2003: RAISE fnd_api.g_exc_unexpected_error;
2004: END IF;
2005: RAISE fnd_api.g_exc_error;
2006: END IF;
2007:
2008: i := l_multiday_shifts.FIRST;
2009: j := 0;

Line 2037: WHEN fnd_api.g_exc_error THEN

2033: i := l_multiday_shifts.NEXT(i);
2034: END LOOP;
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;

Line 2038: x_return_status := fnd_api.g_ret_sts_error;

2034: END LOOP;
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);

Line 2040: WHEN fnd_api.g_exc_unexpected_error THEN

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
2044: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2041: x_return_status := fnd_api.g_ret_sts_unexp_error;

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
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

Line 2044: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
2047: END IF;
2048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);