DBA Data[Home] [Help]

APPS.WMS_CAROUSEL_INTEGRATION_PVT dependencies on FND_API

Line 429: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

Line 433: RAISE fnd_api.g_exc_unexpected_error;

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

Line 434: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

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

Line 438: RAISE fnd_api.g_exc_error;

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

Line 1559: x_return_status := fnd_api.g_ret_sts_success;

1555: --4311016
1556: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1557: PRAGMA AUTONOMOUS_TRANSACTION;
1558: BEGIN
1559: x_return_status := fnd_api.g_ret_sts_success;
1560: -- Get pipe NAME
1561: l_reading_pipe :=
1562: NVL (get_config_parameter (p_name => 'PIPE_NAME',
1563: p_sequence_id => p_device_id),

Line 1608: x_return_status := fnd_api.G_RET_STS_ERROR;

1604: RETURN;
1605: EXCEPTION
1606: WHEN OTHERS
1607: THEN
1608: x_return_status := fnd_api.G_RET_STS_ERROR;
1609: x_msg_data := SQLERRM;
1610: END read_pipe_content;
1611: --
1612: --

Line 1702: x_return_status := fnd_api.g_ret_sts_success;

1698: l_msg_component msg_components%ROWTYPE;
1699: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1700: PRAGMA AUTONOMOUS_TRANSACTION;
1701: BEGIN
1702: x_return_status := fnd_api.g_ret_sts_success;
1703: OPEN msg_components (p_template_id, p_component_no);
1704: FETCH msg_components
1705: INTO l_msg_component;
1706:

Line 1727: x_return_status := fnd_api.g_ret_sts_error;

1723: CLOSE msg_components;
1724: EXCEPTION
1725: WHEN OTHERS
1726: THEN
1727: x_return_status := fnd_api.g_ret_sts_error;
1728: x_msg_data := SQLERRM;
1729: END get_component_details;
1730:
1731: /*

Line 1830: x_return_status := fnd_api.g_ret_sts_success;

1826: l_response_record WMS_WCS_DEVICE_GRP.MSG_COMPONENT_LOOKUP_TYPE;
1827: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1828: PRAGMA AUTONOMOUS_TRANSACTION;
1829: BEGIN
1830: x_return_status := fnd_api.g_ret_sts_success;
1831: l_template_id := p_template_id;
1832: l_device_id := p_device_id;
1833: OPEN msg_template_record (l_template_id);
1834: FETCH msg_template_record

Line 1942: IF l_return_status <> fnd_api.g_ret_sts_success

1938: x_return_status => l_return_status,
1939: x_msg_count => l_msg_count,
1940: x_msg_data => l_msg_data
1941: );
1942: IF l_return_status <> fnd_api.g_ret_sts_success
1943: THEN
1944: RAISE msg_component_exception;
1945: END IF;
1946: --output_table (l_no_of_msg_comps).component_value := l_attribute_value;

Line 1950: x_return_status := fnd_api.g_ret_sts_error;

1946: --output_table (l_no_of_msg_comps).component_value := l_attribute_value;
1947: EXCEPTION
1948: WHEN msg_component_exception
1949: THEN
1950: x_return_status := fnd_api.g_ret_sts_error;
1951: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1952: p_data => x_msg_data
1953: );
1954: WHEN OTHERS

Line 1956: x_return_status := fnd_api.g_ret_sts_unexp_error;

1952: p_data => x_msg_data
1953: );
1954: WHEN OTHERS
1955: THEN
1956: x_return_status := fnd_api.g_ret_sts_unexp_error;
1957: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1958: p_data => x_msg_data
1959: );
1960: END;

Line 2021: IF l_return_status <> fnd_api.g_ret_sts_success

2017: x_return_status => l_return_status,
2018: x_msg_count => l_msg_count,
2019: x_msg_data => l_msg_data
2020: );
2021: IF l_return_status <> fnd_api.g_ret_sts_success
2022: THEN
2023: RAISE msg_component_exception;
2024: END IF;
2025: output_table (l_no_of_msg_comps).component_value :=

Line 2037: x_return_status := fnd_api.g_ret_sts_error;

2033: );
2034: EXCEPTION
2035: WHEN msg_component_exception
2036: THEN
2037: x_return_status := fnd_api.g_ret_sts_error;
2038: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2039: p_data => x_msg_data
2040: );
2041: WHEN OTHERS

Line 2043: x_return_status := fnd_api.g_ret_sts_unexp_error;

2039: p_data => x_msg_data
2040: );
2041: WHEN OTHERS
2042: THEN
2043: x_return_status := fnd_api.g_ret_sts_unexp_error;
2044: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2045: p_data => x_msg_data
2046: );
2047: END;

Line 2102: IF l_return_status <> fnd_api.g_ret_sts_success

2098: x_return_status => l_return_status,
2099: x_msg_count => l_msg_count,
2100: x_msg_data => l_msg_data
2101: );
2102: IF l_return_status <> fnd_api.g_ret_sts_success
2103: THEN
2104: RAISE msg_component_exception;
2105: END IF;
2106: output_table (l_no_of_msg_comps).component_value :=

Line 2118: x_return_status := fnd_api.g_ret_sts_error;

2114: );
2115: EXCEPTION
2116: WHEN msg_component_exception
2117: THEN
2118: x_return_status := fnd_api.g_ret_sts_error;
2119: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2120: p_data => x_msg_data
2121: );
2122: WHEN OTHERS

Line 2124: x_return_status := fnd_api.g_ret_sts_unexp_error;

2120: p_data => x_msg_data
2121: );
2122: WHEN OTHERS
2123: THEN
2124: x_return_status := fnd_api.g_ret_sts_unexp_error;
2125: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2126: p_data => x_msg_data
2127: );
2128: END;

Line 2177: IF l_return_status <> fnd_api.g_ret_sts_success

2173: x_return_status => l_return_status,
2174: x_msg_count => l_msg_count,
2175: x_msg_data => l_msg_data
2176: );
2177: IF l_return_status <> fnd_api.g_ret_sts_success
2178: THEN
2179: RAISE msg_component_exception;
2180: END IF;
2181: --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 2209: x_return_status := fnd_api.g_ret_sts_error;

2205: );
2206: EXCEPTION
2207: WHEN msg_component_exception
2208: THEN
2209: x_return_status := fnd_api.g_ret_sts_error;
2210: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2211: p_data => x_msg_data
2212: );
2213: WHEN OTHERS

Line 2215: x_return_status := fnd_api.g_ret_sts_unexp_error;

2211: p_data => x_msg_data
2212: );
2213: WHEN OTHERS
2214: THEN
2215: x_return_status := fnd_api.g_ret_sts_unexp_error;
2216: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2217: p_data => x_msg_data
2218: );
2219: END;

Line 2314: x_return_status := fnd_api.g_ret_sts_unexp_error;

2310: LOG (p_device_id, 'Unexpected error in parse_device_response for p_request_id='
2311: || p_request_id
2312: );
2313: END IF;
2314: x_return_status := fnd_api.g_ret_sts_unexp_error;
2315: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2316: p_data => x_msg_data);
2317: END parse_device_response;
2318: --