DBA Data[Home] [Help]

APPS.WMS_CAROUSEL_INTEGRATION_PVT dependencies on WMS_CAROUSEL_INTEGRATION_PVT

Line 1: PACKAGE BODY WMS_CAROUSEL_INTEGRATION_PVT AS

1: PACKAGE BODY WMS_CAROUSEL_INTEGRATION_PVT AS
2: /* $Header: WMSCSPVB.pls 120.25 2011/01/26 21:21:10 adyeh ship $ */
3:
4: --
5: -- Private Procedure to slow down the application if the hardware is not able to keep pace

Line 1349: || p_data, 'WMS_CAROUSEL_INTEGRATION_PVT', 9);

1345: BEGIN
1346: inv_log_util.trace('MHP:Device='
1347: || p_device_id
1348: || ':'
1349: || p_data, 'WMS_CAROUSEL_INTEGRATION_PVT', 9);
1350: /*
1351: Commented out for Bug# 4624894
1352:
1353: INSERT INTO wms_carousel_log

Line 1840: wms_carousel_integration_pvt.ascii_csv_to_string

1836: l_param_delimiter :=
1837: fnd_global.local_chr (l_template_record.parameter_delimiter);
1838: --Convert the ascii csv to a string representation
1839: l_start_delimiter :=
1840: wms_carousel_integration_pvt.ascii_csv_to_string
1841: (l_template_record.start_message_delimiter);
1842: l_end_delimiter :=
1843: wms_carousel_integration_pvt.ascii_csv_to_string
1844: (l_template_record.end_message_delimiter);

Line 1843: wms_carousel_integration_pvt.ascii_csv_to_string

1839: l_start_delimiter :=
1840: wms_carousel_integration_pvt.ascii_csv_to_string
1841: (l_template_record.start_message_delimiter);
1842: l_end_delimiter :=
1843: wms_carousel_integration_pvt.ascii_csv_to_string
1844: (l_template_record.end_message_delimiter);
1845:
1846: --l_start_delimiter := l_template_record.start_message_delimiter;
1847: --l_end_delimiter := l_template_record.end_message_delimiter;

Line 1873: IF l_msg_type = wms_carousel_integration_pvt.v_xml_msg

1869: (p_device_id, 'Message after stripping start and end delimiters is '
1870: || l_msg
1871: );
1872: END IF;
1873: IF l_msg_type = wms_carousel_integration_pvt.v_xml_msg
1874: THEN
1875: FOR l_comp_record IN msg_component_records (l_template_id)
1876: LOOP
1877: --l_no_of_msg_comps := l_no_of_msg_comps + 1;

Line 1926: wms_carousel_integration_pvt.get_component_details

1922: --
1923: --
1924: DECLARE
1925: BEGIN
1926: wms_carousel_integration_pvt.get_component_details
1927: (p_device_id => l_device_id,
1928: p_template_id => l_template_id,
1929: p_component_no => l_no_of_msg_comps,
1930: x_component_code => output_table

Line 1965: wms_carousel_integration_pvt.populate_response_record

1961: --
1962: --
1963: output_table (l_no_of_msg_comps).component_value :=
1964: l_attribute_value;
1965: wms_carousel_integration_pvt.populate_response_record
1966: (
1967: p_device_id => p_device_id,
1968: p_component_code => output_table (l_no_of_msg_comps).component_no,
1969: p_msg_component => l_attribute_value,

Line 1986: ELSIF l_msg_type = wms_carousel_integration_pvt.v_msg_with_delimiter

1982: END IF;
1983: END LOOP;
1984: xmlparser.freeparser (l_parser);
1985: xmldom.freedocument (l_doc);
1986: ELSIF l_msg_type = wms_carousel_integration_pvt.v_msg_with_delimiter
1987: THEN
1988: --This is the start of parsing logic for message of type 2
1989: --Message with delimiter
1990: WHILE l_instr_output <> 0

Line 2009: wms_carousel_integration_pvt.get_component_details

2005: INTO l_msg_component
2006: FROM DUAL;
2007: DECLARE
2008: BEGIN
2009: wms_carousel_integration_pvt.get_component_details
2010: (p_device_id => l_device_id,
2011: p_template_id => l_template_id,
2012: p_component_no => l_no_of_msg_comps,
2013: x_component_code => output_table (l_no_of_msg_comps).component_no,

Line 2027: wms_carousel_integration_pvt.populate_response_record

2023: RAISE msg_component_exception;
2024: END IF;
2025: output_table (l_no_of_msg_comps).component_value :=
2026: l_msg_component;
2027: wms_carousel_integration_pvt.populate_response_record
2028: (
2029: p_device_id => p_device_id,
2030: p_component_code => output_table (l_no_of_msg_comps).component_no,
2031: p_msg_component => l_msg_component,

Line 2057: ELSIF l_msg_type = wms_carousel_integration_pvt.v_msg_without_delimiter

2053: || l_msg_component
2054: );
2055: END IF;
2056: END LOOP;
2057: ELSIF l_msg_type = wms_carousel_integration_pvt.v_msg_without_delimiter
2058: THEN
2059: FOR l_comp_record IN msg_component_records (l_template_id)
2060: LOOP
2061: l_no_of_msg_comps := l_no_of_msg_comps + 1;

Line 2090: wms_carousel_integration_pvt.get_component_details

2086: fnd_global.local_chr (l_comp_record.padding_character)
2087: );
2088: END IF;
2089: BEGIN
2090: wms_carousel_integration_pvt.get_component_details
2091: (p_device_id => l_device_id,
2092: p_template_id => l_template_id,
2093: p_component_no => l_no_of_msg_comps,
2094: x_component_code => output_table (l_no_of_msg_comps).component_no,

Line 2108: wms_carousel_integration_pvt.populate_response_record

2104: RAISE msg_component_exception;
2105: END IF;
2106: output_table (l_no_of_msg_comps).component_value :=
2107: l_msg_component;
2108: wms_carousel_integration_pvt.populate_response_record
2109: (
2110: p_device_id => p_device_id,
2111: p_component_code => output_table (l_no_of_msg_comps).component_no,
2112: p_msg_component => l_msg_component,

Line 2133: ELSIF l_msg_type = wms_carousel_integration_pvt.v_vocollect_msg

2129: --
2130: --
2131: l_start_position := l_start_position + l_comp_record.component_length;
2132: END LOOP;
2133: ELSIF l_msg_type = wms_carousel_integration_pvt.v_vocollect_msg
2134: THEN
2135: WHILE l_instr_output <> 0
2136: LOOP
2137: l_no_of_msg_comps := l_no_of_msg_comps + 1;

Line 2165: wms_carousel_integration_pvt.get_component_details

2161: INTO l_msg_component
2162: FROM DUAL;
2163: --LOG('p_device_id, l_msg_component: '||l_msg_component);
2164: BEGIN
2165: wms_carousel_integration_pvt.get_component_details
2166: (p_device_id => l_device_id,
2167: p_template_id => l_template_id,
2168: p_component_no => l_no_of_msg_comps,
2169: x_component_code => output_table (l_no_of_msg_comps).component_no,

Line 2199: wms_carousel_integration_pvt.populate_response_record

2195: );
2196: END IF;
2197: output_table (l_no_of_msg_comps).component_value :=
2198: l_msg_component;
2199: wms_carousel_integration_pvt.populate_response_record
2200: (
2201: p_device_id => p_device_id,
2202: p_component_code => output_table (l_no_of_msg_comps).component_no,
2203: p_msg_component => l_msg_component,

Line 2283: wms_carousel_integration_pvt.log_response_record

2279: || l_debug
2280: );
2281: END IF;
2282:
2283: wms_carousel_integration_pvt.log_response_record
2284: (
2285: p_device_id => p_device_id,
2286: p_response_record => l_response_record
2287: );

Line 2636: END wms_carousel_integration_pvt;

2632: LOG(p_device_id, 'Exception in pause_directive:'||SQLERRM);
2633: END IF;
2634: END pause_directive;
2635:
2636: END wms_carousel_integration_pvt;