APPS.WSH_TRANSACTIONS_UTIL dependencies on WSH_DELIVERY_UTIL

Line 305: IF ( WSH_DELIVERY_UTIL.Is_SendDoc_Allowed( p_entity_id,

301: wsh_debug_sv.log (l_module_name, 'Document Type ' , p_document_type);
302: END IF;
303: IF ( p_action_type = 'A' ) THEN
304:
305: IF ( WSH_DELIVERY_UTIL.Is_SendDoc_Allowed( p_entity_id,
306: p_action_type,
307: x_return_status)
308: ) THEN
309:

Line 406: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,

402:
403: END IF;
404:
405:
406: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,
407: p_action_type,
408: p_document_type,
409: x_return_status);
410: --commit;

Line 444: IF ( WSH_DELIVERY_UTIL.Is_SendDoc_Allowed(p_entity_id,

440:
441: ELSIF ( p_action_type = 'D' ) THEN --{
442:
443:
444: IF ( WSH_DELIVERY_UTIL.Is_SendDoc_Allowed(p_entity_id,
445: p_action_type,
446: x_return_status)
447: ) THEN --{
448:

Line 469: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,

465: from wsh_new_deliveries
466: where delivery_id = p_entity_id
467: for update nowait;
468:
469: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,
470: p_action_type,
471: p_document_type,
472: x_return_status);
473:

Line 552: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,

548: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_cms_del_det_rel_stat');
549: END IF;
550: WHEN wsh_insert_history_error THEN
551: IF ( p_action_type = 'A' ) THEN
552: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,
553: NULL,
554: p_document_type,
555: x_return_status);
556: --commit;

Line 559: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,

555: x_return_status);
556: --commit;
557: x_return_status := wsh_util_core.g_ret_sts_error;
558: ELSIF ( p_action_type = 'D' ) THEN
559: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,
560: 'A',
561: p_document_type,
562: x_return_status);
563: --commit;

Line 572: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,

568: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_insert_history_error');
569: END IF;
570: WHEN wsh_raise_event_error THEN
571: IF ( p_action_type = 'A' ) THEN
572: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,
573: NULL,
574: p_document_type,
575: x_return_status);
576: --commit;

Line 579: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,

575: x_return_status);
576: --commit;
577: x_return_status := wsh_util_core.g_ret_sts_error;
578: ELSIF ( p_action_type = 'D' ) THEN
579: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,
580: 'A',
581: p_document_type,
582: x_return_status);
583: --commit;

Line 823: WSH_DELIVERY_UTIL.Update_Dlvy_Status(l_delivery_id,

819: resultout := 'COMPLETE:FAILURE';
820: raise wsh_del_not_found;
821: END IF;
822:
823: WSH_DELIVERY_UTIL.Update_Dlvy_Status(l_delivery_id,
824: NULL,
825: NULL,
826: l_return_status);
827: IF l_debug_on THEN