DBA Data[Home] [Help]

APPS.WMS_CAROUSEL_INTEGRATION_PVT dependencies on FND_API

Line 427: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

423: IF (l_debug > 0) THEN
424: LOG(v_directive.device_id, 'After calling parse_device_response. l_return_status is '||l_return_status);
425: END IF;
426:
427: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
428: IF (l_debug > 0) THEN
429: LOG(v_directive.device_id, 'Error calling parse_device_response. '||SQLERRM);
430: END IF;
431: RAISE fnd_api.g_exc_unexpected_error;

Line 431: RAISE fnd_api.g_exc_unexpected_error;

427: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
428: IF (l_debug > 0) THEN
429: LOG(v_directive.device_id, 'Error calling parse_device_response. '||SQLERRM);
430: END IF;
431: RAISE fnd_api.g_exc_unexpected_error;
432: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
433: IF (l_debug > 0) THEN
434: LOG(v_directive.device_id, 'Error calling parse_device_response. '||SQLERRM);
435: END IF;

Line 432: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

428: IF (l_debug > 0) THEN
429: LOG(v_directive.device_id, 'Error calling parse_device_response. '||SQLERRM);
430: END IF;
431: RAISE fnd_api.g_exc_unexpected_error;
432: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
433: IF (l_debug > 0) THEN
434: LOG(v_directive.device_id, 'Error calling parse_device_response. '||SQLERRM);
435: END IF;
436: RAISE fnd_api.g_exc_error;

Line 436: RAISE fnd_api.g_exc_error;

432: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
433: IF (l_debug > 0) THEN
434: LOG(v_directive.device_id, 'Error calling parse_device_response. '||SQLERRM);
435: END IF;
436: RAISE fnd_api.g_exc_error;
437: END IF;
438:
439: IF (l_debug > 0) THEN
440: LOG (v_directive.device_id, 'Marking directive as success, id='

Line 1549: x_return_status := fnd_api.g_ret_sts_success;

1545: --4311016
1546: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1547: PRAGMA AUTONOMOUS_TRANSACTION;
1548: BEGIN
1549: x_return_status := fnd_api.g_ret_sts_success;
1550: -- Get pipe NAME
1551: l_reading_pipe :=
1552: NVL (get_config_parameter (p_name => 'PIPE_NAME',
1553: p_sequence_id => p_device_id),

Line 1598: x_return_status := fnd_api.G_RET_STS_ERROR;

1594: RETURN;
1595: EXCEPTION
1596: WHEN OTHERS
1597: THEN
1598: x_return_status := fnd_api.G_RET_STS_ERROR;
1599: x_msg_data := SQLERRM;
1600: END read_pipe_content;
1601: --
1602: --

Line 1692: x_return_status := fnd_api.g_ret_sts_success;

1688: l_msg_component msg_components%ROWTYPE;
1689: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1690: PRAGMA AUTONOMOUS_TRANSACTION;
1691: BEGIN
1692: x_return_status := fnd_api.g_ret_sts_success;
1693: OPEN msg_components (p_template_id, p_component_no);
1694: FETCH msg_components
1695: INTO l_msg_component;
1696:

Line 1717: x_return_status := fnd_api.g_ret_sts_error;

1713: CLOSE msg_components;
1714: EXCEPTION
1715: WHEN OTHERS
1716: THEN
1717: x_return_status := fnd_api.g_ret_sts_error;
1718: x_msg_data := SQLERRM;
1719: END get_component_details;
1720:
1721: /*

Line 1820: x_return_status := fnd_api.g_ret_sts_success;

1816: l_response_record WMS_WCS_DEVICE_GRP.MSG_COMPONENT_LOOKUP_TYPE;
1817: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1818: PRAGMA AUTONOMOUS_TRANSACTION;
1819: BEGIN
1820: x_return_status := fnd_api.g_ret_sts_success;
1821: l_template_id := p_template_id;
1822: l_device_id := p_device_id;
1823: OPEN msg_template_record (l_template_id);
1824: FETCH msg_template_record

Line 1932: IF l_return_status <> fnd_api.g_ret_sts_success

1928: x_return_status => l_return_status,
1929: x_msg_count => l_msg_count,
1930: x_msg_data => l_msg_data
1931: );
1932: IF l_return_status <> fnd_api.g_ret_sts_success
1933: THEN
1934: RAISE msg_component_exception;
1935: END IF;
1936: --output_table (l_no_of_msg_comps).component_value := l_attribute_value;

Line 1940: x_return_status := fnd_api.g_ret_sts_error;

1936: --output_table (l_no_of_msg_comps).component_value := l_attribute_value;
1937: EXCEPTION
1938: WHEN msg_component_exception
1939: THEN
1940: x_return_status := fnd_api.g_ret_sts_error;
1941: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1942: p_data => x_msg_data
1943: );
1944: WHEN OTHERS

Line 1946: x_return_status := fnd_api.g_ret_sts_unexp_error;

1942: p_data => x_msg_data
1943: );
1944: WHEN OTHERS
1945: THEN
1946: x_return_status := fnd_api.g_ret_sts_unexp_error;
1947: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1948: p_data => x_msg_data
1949: );
1950: END;

Line 2011: IF l_return_status <> fnd_api.g_ret_sts_success

2007: x_return_status => l_return_status,
2008: x_msg_count => l_msg_count,
2009: x_msg_data => l_msg_data
2010: );
2011: IF l_return_status <> fnd_api.g_ret_sts_success
2012: THEN
2013: RAISE msg_component_exception;
2014: END IF;
2015: output_table (l_no_of_msg_comps).component_value :=

Line 2027: x_return_status := fnd_api.g_ret_sts_error;

2023: );
2024: EXCEPTION
2025: WHEN msg_component_exception
2026: THEN
2027: x_return_status := fnd_api.g_ret_sts_error;
2028: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2029: p_data => x_msg_data
2030: );
2031: WHEN OTHERS

Line 2033: x_return_status := fnd_api.g_ret_sts_unexp_error;

2029: p_data => x_msg_data
2030: );
2031: WHEN OTHERS
2032: THEN
2033: x_return_status := fnd_api.g_ret_sts_unexp_error;
2034: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2035: p_data => x_msg_data
2036: );
2037: END;

Line 2092: IF l_return_status <> fnd_api.g_ret_sts_success

2088: x_return_status => l_return_status,
2089: x_msg_count => l_msg_count,
2090: x_msg_data => l_msg_data
2091: );
2092: IF l_return_status <> fnd_api.g_ret_sts_success
2093: THEN
2094: RAISE msg_component_exception;
2095: END IF;
2096: output_table (l_no_of_msg_comps).component_value :=

Line 2108: x_return_status := fnd_api.g_ret_sts_error;

2104: );
2105: EXCEPTION
2106: WHEN msg_component_exception
2107: THEN
2108: x_return_status := fnd_api.g_ret_sts_error;
2109: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2110: p_data => x_msg_data
2111: );
2112: WHEN OTHERS

Line 2114: x_return_status := fnd_api.g_ret_sts_unexp_error;

2110: p_data => x_msg_data
2111: );
2112: WHEN OTHERS
2113: THEN
2114: x_return_status := fnd_api.g_ret_sts_unexp_error;
2115: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2116: p_data => x_msg_data
2117: );
2118: END;

Line 2167: IF l_return_status <> fnd_api.g_ret_sts_success

2163: x_return_status => l_return_status,
2164: x_msg_count => l_msg_count,
2165: x_msg_data => l_msg_data
2166: );
2167: IF l_return_status <> fnd_api.g_ret_sts_success
2168: THEN
2169: RAISE msg_component_exception;
2170: END IF;
2171: --LOG(p_device_id, 'output_table (l_no_of_msg_comps).start_comp_delimiter: '||output_table (l_no_of_msg_comps).start_comp_delimiter);

Line 2199: x_return_status := fnd_api.g_ret_sts_error;

2195: );
2196: EXCEPTION
2197: WHEN msg_component_exception
2198: THEN
2199: x_return_status := fnd_api.g_ret_sts_error;
2200: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2201: p_data => x_msg_data
2202: );
2203: WHEN OTHERS

Line 2205: x_return_status := fnd_api.g_ret_sts_unexp_error;

2201: p_data => x_msg_data
2202: );
2203: WHEN OTHERS
2204: THEN
2205: x_return_status := fnd_api.g_ret_sts_unexp_error;
2206: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2207: p_data => x_msg_data
2208: );
2209: END;

Line 2292: x_return_status := fnd_api.g_ret_sts_unexp_error;

2288: LOG (p_device_id, 'Unexpected error in parse_device_response for p_request_id='
2289: || p_request_id
2290: );
2291: END IF;
2292: x_return_status := fnd_api.g_ret_sts_unexp_error;
2293: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2294: p_data => x_msg_data);
2295: END parse_device_response;
2296: --