APPS.INV_RECEIVING_TRANSACTION dependencies on WMS_INSTALL

Line 1230: l_wms_install_status VARCHAR2(1);

1226:
1227: l_transaction_type VARCHAR2(100);
1228: l_organization_id NUMBER;
1229: l_mmtt_transaction_temp_id NUMBER;
1230: l_wms_install_status VARCHAR2(1);
1231: l_return_status VARCHAR2(5);
1232: l_msg_data VARCHAR2(500);
1233: l_msg_count NUMBER;
1234:

Line 1279: -- set wms_installed flag

1275: END IF;
1276: RETURN;
1277: END IF;
1278:
1279: -- set wms_installed flag
1280: IF wms_install.check_install(x_return_status,
1281: x_msg_count,
1282: x_msg_data,
1283: l_organization_id) THEN

Line 1280: IF wms_install.check_install(x_return_status,

1276: RETURN;
1277: END IF;
1278:
1279: -- set wms_installed flag
1280: IF wms_install.check_install(x_return_status,
1281: x_msg_count,
1282: x_msg_data,
1283: l_organization_id) THEN
1284: l_wms_install_status := 'I';

Line 1284: l_wms_install_status := 'I';

1280: IF wms_install.check_install(x_return_status,
1281: x_msg_count,
1282: x_msg_data,
1283: l_organization_id) THEN
1284: l_wms_install_status := 'I';
1285: ELSE
1286: l_wms_install_status := 'U';
1287: END IF;
1288: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 1286: l_wms_install_status := 'U';

1282: x_msg_data,
1283: l_organization_id) THEN
1284: l_wms_install_status := 'I';
1285: ELSE
1286: l_wms_install_status := 'U';
1287: END IF;
1288: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1289: IF (l_debug = 1) THEN
1290: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Could not get wms installed status, exitting - '||x_msg_data||' : 40',1);

Line 1290: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Could not get wms installed status, exitting - '||x_msg_data||' : 40',1);

1286: l_wms_install_status := 'U';
1287: END IF;
1288: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1289: IF (l_debug = 1) THEN
1290: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Could not get wms installed status, exitting - '||x_msg_data||' : 40',1);
1291: END IF;
1292: RAISE fnd_api.g_exc_error; --RETURN;
1293: END IF;
1294:

Line 1295: IF l_wms_install_status = 'I' THEN

1291: END IF;
1292: RAISE fnd_api.g_exc_error; --RETURN;
1293: END IF;
1294:
1295: IF l_wms_install_status = 'I' THEN
1296:
1297: IF (l_debug = 1) THEN
1298: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - WMS is installed : 50',4);
1299: END IF;

Line 1425: END IF; -- l_wms_install_status = 'I'

1421:
1422: IF (l_debug = 1) THEN
1423: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Committing after rollbacking and cleanup',4);
1424: END IF;
1425: END IF; -- l_wms_install_status = 'I'
1426: IF (l_debug = 1) THEN
1427: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Exiting TXN_MOBILE_TIMEOUT_CLEANUP : 230 '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
1428: END IF;
1429: END IF; --IF (l_patch_j_code = FALSE) THEN