7043: END IF;
7044: FOR k IN 1..l_scpod_wf_del_rows.count LOOP
7045: l_ctr := l_scpod_wf_del_rows(k);
7046: IF l_debug_on THEN
7047: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.START_SCPOD_C_PROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);
7048: END IF;
7049:
7050: WSH_WF_STD.Start_Scpod_C_Process( p_entity_id => u_del_rows(l_ctr),
7051: p_organization_id => u_organization_id(l_ctr),
7046: IF l_debug_on THEN
7047: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.START_SCPOD_C_PROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);
7048: END IF;
7049:
7050: WSH_WF_STD.Start_Scpod_C_Process( p_entity_id => u_del_rows(l_ctr),
7051: p_organization_id => u_organization_id(l_ctr),
7052: x_process_started => l_process_started,
7053: x_return_status => l_return_status);
7054: IF l_debug_on THEN
7107: -- Workflow Changes ==/
7108:
7109: FOR z IN 1..u_del_rows.count LOOP
7110: IF l_debug_on THEN
7111: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.Raise_Event',WSH_DEBUG_SV.C_PROC_LEVEL);
7112: END IF;
7113:
7114: WSH_WF_STD.Raise_Event(
7115: p_entity_type => 'DELIVERY',
7110: IF l_debug_on THEN
7111: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.Raise_Event',WSH_DEBUG_SV.C_PROC_LEVEL);
7112: END IF;
7113:
7114: WSH_WF_STD.Raise_Event(
7115: p_entity_type => 'DELIVERY',
7116: p_entity_id => u_del_rows(z),
7117: p_event => 'oracle.apps.wsh.delivery.gen.shipconfirmed',
7118: p_organization_id => u_organization_id(z),
7759: ELSE
7760: --/== Workflow Changes
7761: l_del_entity_ids(1) := p_in_rec.delivery_id;
7762: l_override_wf:= fnd_profile.value('WSH_OVERRIDE_SCPOD_WF');
7763: IF (l_override_wf = 'Y' AND WSH_WF_STD.Wf_Exists('DELIVERY_C',p_in_rec.delivery_id)) THEN
7764: IF l_debug_on THEN
7765: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.LOG_WF_EXCEPTION', WSH_DEBUG_SV.C_PROC_LEVEL);
7766: END IF;
7767: WSH_WF_STD.Log_Wf_Exception(p_entity_type => 'DELIVERY',
7761: l_del_entity_ids(1) := p_in_rec.delivery_id;
7762: l_override_wf:= fnd_profile.value('WSH_OVERRIDE_SCPOD_WF');
7763: IF (l_override_wf = 'Y' AND WSH_WF_STD.Wf_Exists('DELIVERY_C',p_in_rec.delivery_id)) THEN
7764: IF l_debug_on THEN
7765: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.LOG_WF_EXCEPTION', WSH_DEBUG_SV.C_PROC_LEVEL);
7766: END IF;
7767: WSH_WF_STD.Log_Wf_Exception(p_entity_type => 'DELIVERY',
7768: p_entity_id => p_in_rec.delivery_id,
7769: p_logging_entity => 'SHIPPER',
7763: IF (l_override_wf = 'Y' AND WSH_WF_STD.Wf_Exists('DELIVERY_C',p_in_rec.delivery_id)) THEN
7764: IF l_debug_on THEN
7765: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.LOG_WF_EXCEPTION', WSH_DEBUG_SV.C_PROC_LEVEL);
7766: END IF;
7767: WSH_WF_STD.Log_Wf_Exception(p_entity_type => 'DELIVERY',
7768: p_entity_id => p_in_rec.delivery_id,
7769: p_logging_entity => 'SHIPPER',
7770: p_exception_name => 'WSH_DEL_SCPOD_PURGED',
7771: x_return_status => l_wf_rs);
7773: WSH_DEBUG_SV.log(l_module_name,'L_WF_RS',l_wf_rs);
7774: END IF;
7775:
7776: IF l_debug_on THEN
7777: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.PURGE_ENTITY', WSH_DEBUG_SV.C_PROC_LEVEL);
7778: END IF;
7779:
7780: WSH_WF_STD.Purge_Entity(p_entity_type => 'DELIVERY',
7781: p_entity_ids => l_del_entity_ids,
7776: IF l_debug_on THEN
7777: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.PURGE_ENTITY', WSH_DEBUG_SV.C_PROC_LEVEL);
7778: END IF;
7779:
7780: WSH_WF_STD.Purge_Entity(p_entity_type => 'DELIVERY',
7781: p_entity_ids => l_del_entity_ids,
7782: p_docommit => FALSE,
7783: x_success_count => l_purged_count,
7784: x_return_status => l_wf_rs);
7789:
7790: END IF;
7791:
7792: IF l_debug_on THEN
7793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
7794: END IF;
7795:
7796: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
7797: p_entity_id => p_in_rec.delivery_id,
7792: IF l_debug_on THEN
7793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
7794: END IF;
7795:
7796: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
7797: p_entity_id => p_in_rec.delivery_id,
7798: p_event => 'oracle.apps.wsh.delivery.gen.setintransit',
7799: p_organization_id => l_org_id,
7800: x_return_status => l_wf_rs);
7799: p_organization_id => l_org_id,
7800: x_return_status => l_wf_rs);
7801:
7802: IF l_debug_on THEN
7803: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_rs);
7804: END IF;
7805: -- Workflow Changes ==/
7806: END IF;
7807:
8041:
8042: --/== Workflow Changes
8043: l_del_entity_ids(1) := p_in_rec.delivery_id;
8044: l_override_wf:= fnd_profile.value('WSH_OVERRIDE_SCPOD_WF');
8045: IF (l_override_wf = 'Y' AND WSH_WF_STD.Wf_Exists('DELIVERY_C',p_in_rec.delivery_id)) THEN
8046: WSH_WF_STD.Log_Wf_Exception('DELIVERY',
8047: p_in_rec.delivery_id,
8048: NULL,
8049: 'SHIPPER',
8042: --/== Workflow Changes
8043: l_del_entity_ids(1) := p_in_rec.delivery_id;
8044: l_override_wf:= fnd_profile.value('WSH_OVERRIDE_SCPOD_WF');
8045: IF (l_override_wf = 'Y' AND WSH_WF_STD.Wf_Exists('DELIVERY_C',p_in_rec.delivery_id)) THEN
8046: WSH_WF_STD.Log_Wf_Exception('DELIVERY',
8047: p_in_rec.delivery_id,
8048: NULL,
8049: 'SHIPPER',
8050: 'WSH_DEL_SCPOD_PURGED',
8048: NULL,
8049: 'SHIPPER',
8050: 'WSH_DEL_SCPOD_PURGED',
8051: l_wf_rs);
8052: WSH_WF_STD.Purge_Entity(
8053: p_entity_type => 'DELIVERY',
8054: p_entity_ids => l_del_entity_ids,
8055: p_docommit => FALSE,
8056: x_success_count => l_purged_count,
8058: END IF;
8059:
8060:
8061: IF l_debug_on THEN
8062: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
8063: END IF;
8064:
8065: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
8066: p_entity_id => p_in_rec.delivery_id,
8061: IF l_debug_on THEN
8062: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
8063: END IF;
8064:
8065: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
8066: p_entity_id => p_in_rec.delivery_id,
8067: p_event => 'oracle.apps.wsh.delivery.gen.closed',
8068: p_organization_id => l_org_id,
8069: x_return_status => l_wf_rs);
8068: p_organization_id => l_org_id,
8069: x_return_status => l_wf_rs);
8070:
8071: IF l_debug_on THEN
8072: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_rs);
8073: END IF;
8074: -- Workflow Changes ==/
8075:
8076: -- Close Exceptions for delivery and its contents
8634:
8635: --/== Workflow Changes
8636: IF (l_status_code = 'OP') THEN
8637: IF l_debug_on THEN
8638: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
8639: END IF;
8640:
8641: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
8642: p_entity_id => p_del_rows(i),
8637: IF l_debug_on THEN
8638: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
8639: END IF;
8640:
8641: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'DELIVERY',
8642: p_entity_id => p_del_rows(i),
8643: p_event => 'oracle.apps.wsh.delivery.gen.open',
8644: p_organization_id => l_organization_id,
8645: x_return_status => l_wf_rs);
8644: p_organization_id => l_organization_id,
8645: x_return_status => l_wf_rs);
8646:
8647: IF l_debug_on THEN
8648: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_rs);
8649: END IF;
8650: END IF;
8651: -- Workflow Changes ==/
8652: