APPS.INV_RECEIVING_TRANSACTION dependencies on WMS_INSTALL

Line 988: l_wms_install_status VARCHAR2(1);

984:
985: l_transaction_type VARCHAR2(100);
986: l_organization_id NUMBER;
987: l_mmtt_transaction_temp_id NUMBER;
988: l_wms_install_status VARCHAR2(1);
989: l_return_status VARCHAR2(5);
990: l_msg_data VARCHAR2(500);
991: l_msg_count NUMBER;
992:

Line 1037: -- set wms_installed flag

1033: END IF;
1034: RETURN;
1035: END IF;
1036:
1037: -- set wms_installed flag
1038: IF wms_install.check_install(x_return_status,
1039: x_msg_count,
1040: x_msg_data,
1041: l_organization_id) THEN

Line 1038: IF wms_install.check_install(x_return_status,

1034: RETURN;
1035: END IF;
1036:
1037: -- set wms_installed flag
1038: IF wms_install.check_install(x_return_status,
1039: x_msg_count,
1040: x_msg_data,
1041: l_organization_id) THEN
1042: l_wms_install_status := 'I';

Line 1042: l_wms_install_status := 'I';

1038: IF wms_install.check_install(x_return_status,
1039: x_msg_count,
1040: x_msg_data,
1041: l_organization_id) THEN
1042: l_wms_install_status := 'I';
1043: ELSE
1044: l_wms_install_status := 'U';
1045: END IF;
1046: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 1044: l_wms_install_status := 'U';

1040: x_msg_data,
1041: l_organization_id) THEN
1042: l_wms_install_status := 'I';
1043: ELSE
1044: l_wms_install_status := 'U';
1045: END IF;
1046: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1047: IF (l_debug = 1) THEN
1048: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Could not get wms installed status, exitting - '||x_msg_data||' : 40',1);

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

1044: l_wms_install_status := 'U';
1045: END IF;
1046: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1047: IF (l_debug = 1) THEN
1048: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Could not get wms installed status, exitting - '||x_msg_data||' : 40',1);
1049: END IF;
1050: RAISE fnd_api.g_exc_error; --RETURN;
1051: END IF;
1052:

Line 1053: IF l_wms_install_status = 'I' THEN

1049: END IF;
1050: RAISE fnd_api.g_exc_error; --RETURN;
1051: END IF;
1052:
1053: IF l_wms_install_status = 'I' THEN
1054:
1055: IF (l_debug = 1) THEN
1056: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - WMS is installed : 50',4);
1057: END IF;

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

1179:
1180: IF (l_debug = 1) THEN
1181: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Committing after rollbacking and cleanup',4);
1182: END IF;
1183: END IF; -- l_wms_install_status = 'I'
1184: IF (l_debug = 1) THEN
1185: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Exiting TXN_MOBILE_TIMEOUT_CLEANUP : 230 '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
1186: END IF;
1187: END IF; --IF (l_patch_j_code = FALSE) THEN