DBA Data[Home] [Help]

APPS.INV_LABEL dependencies on WMS_INSTALL

Line 1753: * It only apply for WMS installed

1749: END update_history_record;
1750:
1751: /*******************************************
1752: * Call the rules engine to get label format
1753: * It only apply for WMS installed
1754: * It will first insert a row into wms_label_requests
1755: * then call the rules engine to get the label format
1756: ******************************************/
1757:

Line 1817: l_wms_installed BOOLEAN := FALSE;

1813: x_label_format OUT NOCOPY VARCHAR2,
1814: x_label_request_id OUT NOCOPY NUMBER
1815: )IS
1816:
1817: l_wms_installed BOOLEAN := FALSE;
1818: l_return_status VARCHAR2(240);
1819: l_msg_count NUMBER;
1820: l_msg_data VARCHAR2(2000);
1821: l_label_request_id NUMBER;

Line 1973: l_wms_installed := wms_install.check_install(

1969: trace('Inserted into WMS_LABEL_REQUESTS table, label_request_id=' ||l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1970: END IF;
1971: x_label_request_id := l_label_request_id;
1972:
1973: l_wms_installed := wms_install.check_install(
1974: x_return_status => l_return_status,
1975: x_msg_count => l_msg_count,
1976: x_msg_data => l_msg_data,
1977: p_organization_id => P_ORGANIZATION_ID);

Line 1999: -- Manual format is not specified. Check WMS installed

1995: END;
1996:
1997: ELSIF nvl(p_use_rule_engine, 'Y') <> 'N' THEN
1998: -- If indicate not to use rules engine
1999: -- Manual format is not specified. Check WMS installed
2000: -- For WMS user, call rules engine
2001: -- otherwise, return null
2002: IF (l_wms_installed = FALSE) OR (l_return_status <> 'S') THEN
2003: IF (l_debug = 1) THEN

Line 2002: IF (l_wms_installed = FALSE) OR (l_return_status <> 'S') THEN

1998: -- If indicate not to use rules engine
1999: -- Manual format is not specified. Check WMS installed
2000: -- For WMS user, call rules engine
2001: -- otherwise, return null
2002: IF (l_wms_installed = FALSE) OR (l_return_status <> 'S') THEN
2003: IF (l_debug = 1) THEN
2004: trace('WMS is not installed or enabled for org ' || P_ORGANIZATION_ID || ', will not apply rules engine.', TRACE_PROMPT, TRACE_LEVEL);
2005: END IF;
2006: