DBA Data[Home] [Help]

APPS.INV_LABEL dependencies on WMS_INSTALL

Line 1814: * It only apply for WMS installed

1810: END update_history_record;
1811:
1812: /*******************************************
1813: * Call the rules engine to get label format
1814: * It only apply for WMS installed
1815: * It will first insert a row into wms_label_requests
1816: * then call the rules engine to get the label format
1817: ******************************************/
1818:

Line 1878: l_wms_installed BOOLEAN := FALSE;

1874: x_label_format OUT NOCOPY VARCHAR2,
1875: x_label_request_id OUT NOCOPY NUMBER
1876: )IS
1877:
1878: l_wms_installed BOOLEAN := FALSE;
1879: l_return_status VARCHAR2(240);
1880: l_msg_count NUMBER;
1881: l_msg_data VARCHAR2(2000);
1882: l_label_request_id NUMBER;

Line 2034: l_wms_installed := wms_install.check_install(

2030: trace('Inserted into WMS_LABEL_REQUESTS table, label_request_id=' ||l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
2031: END IF;
2032: x_label_request_id := l_label_request_id;
2033:
2034: l_wms_installed := wms_install.check_install(
2035: x_return_status => l_return_status,
2036: x_msg_count => l_msg_count,
2037: x_msg_data => l_msg_data,
2038: p_organization_id => P_ORGANIZATION_ID);

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

2056: END;
2057:
2058: ELSIF nvl(p_use_rule_engine, 'Y') <> 'N' THEN
2059: -- If indicate not to use rules engine
2060: -- Manual format is not specified. Check WMS installed
2061: -- For WMS user, call rules engine
2062: -- otherwise, return null
2063: IF (l_wms_installed = FALSE) OR (l_return_status <> 'S') THEN
2064: IF (l_debug = 1) THEN

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

2059: -- If indicate not to use rules engine
2060: -- Manual format is not specified. Check WMS installed
2061: -- For WMS user, call rules engine
2062: -- otherwise, return null
2063: IF (l_wms_installed = FALSE) OR (l_return_status <> 'S') THEN
2064: IF (l_debug = 1) THEN
2065: trace('WMS is not installed or enabled for org ' || P_ORGANIZATION_ID || ', will not apply rules engine.', TRACE_PROMPT, TRACE_LEVEL);
2066: END IF;
2067: