740:
741: -- Workflow Project
742: -- Raise Stop Status change business event
743: IF l_debug_on THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
745: END IF;
746: WSH_WF_STD.RAISE_EVENT( p_entity_type => 'STOP',
747: p_entity_id => p_stop_rows(i),
748: p_event => 'oracle.apps.wsh.stop.gen.arrived',
742: -- Raise Stop Status change business event
743: IF l_debug_on THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
745: END IF;
746: WSH_WF_STD.RAISE_EVENT( p_entity_type => 'STOP',
747: p_entity_id => p_stop_rows(i),
748: p_event => 'oracle.apps.wsh.stop.gen.arrived',
749: x_return_status => l_wf_rs
750: );
748: p_event => 'oracle.apps.wsh.stop.gen.arrived',
749: x_return_status => l_wf_rs
750: );
751: IF l_debug_on THEN
752: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_rs);
753: END IF;
754:
755: IF l_linked_stop_id IS NOT NULL THEN
756: IF l_debug_on THEN
753: END IF;
754:
755: IF l_linked_stop_id IS NOT NULL THEN
756: IF l_debug_on THEN
757: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
758: END IF;
759: WSH_WF_STD.RAISE_EVENT( p_entity_type => 'STOP',
760: p_entity_id => l_linked_stop_id,
761: p_event => 'oracle.apps.wsh.stop.gen.arrived',
755: IF l_linked_stop_id IS NOT NULL THEN
756: IF l_debug_on THEN
757: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
758: END IF;
759: WSH_WF_STD.RAISE_EVENT( p_entity_type => 'STOP',
760: p_entity_id => l_linked_stop_id,
761: p_event => 'oracle.apps.wsh.stop.gen.arrived',
762: x_return_status => l_wf_rs
763: );
761: p_event => 'oracle.apps.wsh.stop.gen.arrived',
762: x_return_status => l_wf_rs
763: );
764: IF l_debug_on THEN
765: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_rs);
766: END IF;
767: END IF;
768: -- End of code for Workflow project
769:
1906:
1907: -- Workflow Project
1908: -- Raise Stop close business event
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
1911: END IF;
1912:
1913: WSH_WF_STD.RAISE_EVENT( p_entity_type => 'STOP',
1914: p_entity_id => p_in_rec.stop_id,
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
1911: END IF;
1912:
1913: WSH_WF_STD.RAISE_EVENT( p_entity_type => 'STOP',
1914: p_entity_id => p_in_rec.stop_id,
1915: p_event => 'oracle.apps.wsh.stop.gen.closed',
1916: x_return_status => l_wf_rs
1917: );
1915: p_event => 'oracle.apps.wsh.stop.gen.closed',
1916: x_return_status => l_wf_rs
1917: );
1918: IF l_debug_on THEN
1919: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_rs);
1920: END IF;
1921:
1922: IF p_in_rec1.linked_stop_id IS NOT NULL THEN
1923: IF l_debug_on THEN
1920: END IF;
1921:
1922: IF p_in_rec1.linked_stop_id IS NOT NULL THEN
1923: IF l_debug_on THEN
1924: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
1925: END IF;
1926: WSH_WF_STD.RAISE_EVENT( p_entity_type => 'STOP',
1927: p_entity_id => p_in_rec1.linked_stop_id,
1928: p_event => 'oracle.apps.wsh.stop.gen.closed',
1922: IF p_in_rec1.linked_stop_id IS NOT NULL THEN
1923: IF l_debug_on THEN
1924: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
1925: END IF;
1926: WSH_WF_STD.RAISE_EVENT( p_entity_type => 'STOP',
1927: p_entity_id => p_in_rec1.linked_stop_id,
1928: p_event => 'oracle.apps.wsh.stop.gen.closed',
1929: x_return_status => l_wf_rs
1930: );
1928: p_event => 'oracle.apps.wsh.stop.gen.closed',
1929: x_return_status => l_wf_rs
1930: );
1931: IF l_debug_on THEN
1932: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_rs);
1933: END IF;
1934: END IF;
1935: -- End of code for Workflow project
1936: --
2502:
2503: -- Workflow Project
2504: -- Raise Stop Open business event
2505: IF l_debug_on THEN
2506: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
2507: END IF;
2508:
2509: WSH_WF_STD.RAISE_EVENT( p_entity_type => 'STOP',
2510: p_entity_id => p_in_rec.stop_id,
2505: IF l_debug_on THEN
2506: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
2507: END IF;
2508:
2509: WSH_WF_STD.RAISE_EVENT( p_entity_type => 'STOP',
2510: p_entity_id => p_in_rec.stop_id,
2511: p_event => 'oracle.apps.wsh.stop.gen.open',
2512: x_return_status => l_wf_rs
2513: );
2511: p_event => 'oracle.apps.wsh.stop.gen.open',
2512: x_return_status => l_wf_rs
2513: );
2514: IF l_debug_on THEN
2515: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_rs);
2516: END IF;
2517: -- End of code for Workflow project
2518: --
2519: -- DBI Project