735: --
736: -- Debug Statements
737: --
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
740: END IF;
741: --
742: WSH_USA_ACTIONS_PVT.Import_Delivery_Details(
743: p_source_line_id => l_source_line_id,
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
740: END IF;
741: --
742: WSH_USA_ACTIONS_PVT.Import_Delivery_Details(
743: p_source_line_id => l_source_line_id,
744: p_source_code => p_source_code,
745: x_return_status => l_rs);
746:
2578: --
2579: -- Debug Statements
2580: --
2581: IF l_debug_on THEN
2582: WSH_DEBUG_SV.logmsg(l_module_name, 'CALLING WSH_USA_ACTIONS_PVT.IMPORT_RECORDS' );
2583: END IF;
2584: --
2585: --
2586: -- Debug Statements
2585: --
2586: -- Debug Statements
2587: --
2588: IF l_debug_on THEN
2589: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_ACTIONS_PVT.IMPORT_RECORDS',WSH_DEBUG_SV.C_PROC_LEVEL);
2590: END IF;
2591: --
2592: WSH_USA_ACTIONS_PVT.Import_Records(
2593: p_source_code => p_source_code,
2588: IF l_debug_on THEN
2589: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_ACTIONS_PVT.IMPORT_RECORDS',WSH_DEBUG_SV.C_PROC_LEVEL);
2590: END IF;
2591: --
2592: WSH_USA_ACTIONS_PVT.Import_Records(
2593: p_source_code => p_source_code,
2594: p_changed_attributes => p_changed_attributes,
2595: x_return_status => l_rs);
2596: END IF;
2597: --
2598: -- Debug Statements
2599: --
2600: IF l_debug_on THEN
2601: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER CALLING WSH_USA_ACTIONS_PVT.IMPORT_RECORDS '|| L_RS );
2602: END IF;
2603: --
2604: END IF;
2605:
2607: --
2608: -- Debug Statements
2609: --
2610: IF l_debug_on THEN
2611: WSH_DEBUG_SV.logmsg(l_module_name, 'CALLING WSH_USA_ACTIONS_PVT.SPLIT_RECORDS' );
2612: END IF;
2613: --
2614: --
2615: -- Debug Statements
2614: --
2615: -- Debug Statements
2616: --
2617: IF l_debug_on THEN
2618: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_ACTIONS_PVT.SPLIT_RECORDS',WSH_DEBUG_SV.C_PROC_LEVEL);
2619: END IF;
2620: --
2621: WSH_USA_ACTIONS_PVT.Split_Records(
2622: p_source_code => p_source_code,
2617: IF l_debug_on THEN
2618: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_ACTIONS_PVT.SPLIT_RECORDS',WSH_DEBUG_SV.C_PROC_LEVEL);
2619: END IF;
2620: --
2621: WSH_USA_ACTIONS_PVT.Split_Records(
2622: p_source_code => p_source_code,
2623: p_changed_attributes => p_changed_attributes,
2624: p_interface_flag => p_interface_flag,
2625: x_return_status => l_rs);
2629: --
2630: -- Debug Statements
2631: --
2632: IF l_debug_on THEN
2633: WSH_DEBUG_SV.logmsg(l_module_name, 'CALLING WSH_USA_ACTIONS_PVT.UPDATE_RECORDS' );
2634: END IF;
2635: --
2636: --
2637: -- Debug Statements
2636: --
2637: -- Debug Statements
2638: --
2639: IF l_debug_on THEN
2640: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_ACTIONS_PVT.UPDATE_RECORDS',WSH_DEBUG_SV.C_PROC_LEVEL);
2641: END IF;
2642: --
2643: WSH_USA_ACTIONS_PVT.Update_Records(
2644: p_source_code => p_source_code,
2639: IF l_debug_on THEN
2640: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_ACTIONS_PVT.UPDATE_RECORDS',WSH_DEBUG_SV.C_PROC_LEVEL);
2641: END IF;
2642: --
2643: WSH_USA_ACTIONS_PVT.Update_Records(
2644: p_source_code => p_source_code,
2645: p_changed_attributes => p_changed_attributes,
2646: p_interface_flag => p_interface_flag,
2647: x_return_status => l_rs);