DBA Data[Home] [Help]

APPS.WSH_WF_INTERFACE dependencies on WSH_UTIL_CORE

Line 240: IF (l_return_status <> wsh_util_core.g_ret_sts_error

236: IF l_debug_on THEN
237: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
238: END IF;
239:
240: IF (l_return_status <> wsh_util_core.g_ret_sts_error
241: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN
242: UPDATE WSH_NEW_DELIVERIES
243: SET del_wf_intransit_attr = 'C'
244: WHERE delivery_id = l_delivery_id;

Line 241: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN

237: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
238: END IF;
239:
240: IF (l_return_status <> wsh_util_core.g_ret_sts_error
241: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN
242: UPDATE WSH_NEW_DELIVERIES
243: SET del_wf_intransit_attr = 'C'
244: WHERE delivery_id = l_delivery_id;
245: resultout := 'COMPLETE:SUCCESS';

Line 466: IF (l_return_status <> wsh_util_core.g_ret_sts_error

462: END IF;
463:
464:
465:
466: IF (l_return_status <> wsh_util_core.g_ret_sts_error
467: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN
468: UPDATE WSH_NEW_DELIVERIES
469: SET del_wf_close_attr = 'C'
470: WHERE delivery_id = l_delivery_id;

Line 467: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN

463:
464:
465:
466: IF (l_return_status <> wsh_util_core.g_ret_sts_error
467: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN
468: UPDATE WSH_NEW_DELIVERIES
469: SET del_wf_close_attr = 'C'
470: WHERE delivery_id = l_delivery_id;
471: resultout := 'COMPLETE:SUCCESS';

Line 598: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error,l_module_name);

594: SET del_wf_interface_attr = 'E'
595: WHERE delivery_id = l_delivery_id;
596: resultout := 'COMPLETE:FAILURE';
597: fnd_message.set_name('WSH', 'WSH_DET_INV_INT_REQ_SUBMISSION');
598: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error,l_module_name);
599: ELSE
600: UPDATE WSH_NEW_DELIVERIES
601: SET del_wf_interface_attr = 'C'
602: WHERE delivery_id = l_delivery_id;

Line 606: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_SUCCESS,l_module_name);

602: WHERE delivery_id = l_delivery_id;
603: resultout := 'COMPLETE:SUCCESS';
604: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INV_INT_SUBMITTED');
605: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_request_id));
606: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_SUCCESS,l_module_name);
607: END IF;
608:
609:
610: l_msg_buffer := FND_MESSAGE.Get;

Line 668: l_delivery_ids WSH_UTIL_CORE.id_tab_type;

664:
665: l_organization_id NUMBER;
666: l_report_set_id NUMBER;
667: l_dummy_doc_set WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE;
668: l_delivery_ids WSH_UTIL_CORE.id_tab_type;
669: l_dummy_rows1 WSH_UTIL_CORE.id_tab_type;
670: l_return_status VARCHAR2(1);
671:
672: e_print_doc_failed EXCEPTION;

Line 669: l_dummy_rows1 WSH_UTIL_CORE.id_tab_type;

665: l_organization_id NUMBER;
666: l_report_set_id NUMBER;
667: l_dummy_doc_set WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE;
668: l_delivery_ids WSH_UTIL_CORE.id_tab_type;
669: l_dummy_rows1 WSH_UTIL_CORE.id_tab_type;
670: l_return_status VARCHAR2(1);
671:
672: e_print_doc_failed EXCEPTION;
673:

Line 720: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

716: IF l_debug_on THEN
717: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
718: END IF;
719:
720: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
721: raise e_print_doc_failed;
722: ELSE
723: resultout := 'COMPLETE';
724: END IF;

Line 1061: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1057: IF l_debug_on THEN
1058: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1059: END IF;
1060:
1061: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1062: raise e_param_not_defined;
1063: ELSE
1064: l_screening_flag := NVL(l_param_info.EXPORT_SCREENING_FLAG,'N');
1065: END IF;

Line 1176: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1172: IF l_debug_on THEN
1173: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1174: END IF;
1175:
1176: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1177: raise e_param_not_defined;
1178: ELSE
1179: l_screening_flag := NVL(l_param_info.EXPORT_SCREENING_FLAG,'N');
1180: END IF;

Line 1298: IF (l_return_status <> wsh_util_core.g_ret_sts_error

1294: IF l_debug_on THEN
1295: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1296: END IF;
1297:
1298: IF (l_return_status <> wsh_util_core.g_ret_sts_error
1299: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN
1300: resultout := 'COMPLETE:';
1301: ELSE
1302: resultout := '';

Line 1299: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN

1295: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1296: END IF;
1297:
1298: IF (l_return_status <> wsh_util_core.g_ret_sts_error
1299: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN
1300: resultout := 'COMPLETE:';
1301: ELSE
1302: resultout := '';
1303: END IF;

Line 1416: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_custom_process_name is null) THEN

1412: WSH_DEBUG_SV.log(l_module_name,'L_SCPOD_WF_PROCESS_EXISTS',l_scpod_wf_process_exists);
1413: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
1414: END IF;
1415:
1416: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_custom_process_name is null) THEN
1417: l_custom_process_name := 'R_SCPOD_C';
1418: END IF;
1419:
1420: UPDATE WSH_NEW_DELIVERIES