11154:
11155:
11156: IF (NVL(FND_PROFILE.VALUE('WSH_ENABLE_DCP'), -1) = 1 OR
11157: NVL(FND_PROFILE.VALUE('WSH_ENABLE_DCP'), -1) = 2) AND
11158: WSH_DCP_PVT.G_CALL_DCP_CHECK = 'Y' THEN
11159:
11160: WSH_DCP_PVT.G_INIT_MSG_COUNT := fnd_msg_pub.count_msg;
11161:
11162: BEGIN
11156: IF (NVL(FND_PROFILE.VALUE('WSH_ENABLE_DCP'), -1) = 1 OR
11157: NVL(FND_PROFILE.VALUE('WSH_ENABLE_DCP'), -1) = 2) AND
11158: WSH_DCP_PVT.G_CALL_DCP_CHECK = 'Y' THEN
11159:
11160: WSH_DCP_PVT.G_INIT_MSG_COUNT := fnd_msg_pub.count_msg;
11161:
11162: BEGIN
11163: IF l_debug_level > 0 THEN
11164: oe_debug_pub.add(p_header_id ||'-----' || l_line_rec.header_id, 1);
11163: IF l_debug_level > 0 THEN
11164: oe_debug_pub.add(p_header_id ||'-----' || l_line_rec.header_id, 1);
11165: END IF;
11166:
11167: WSH_DCP_PVT.g_dc_table.DELETE;
11168:
11169: IF p_header_id is NULL OR
11170: p_header_id = FND_API.G_MISS_NUM THEN
11171: l_header_id := l_line_rec.header_id;
11173: l_header_id := p_header_id;
11174: END IF;
11175:
11176: IF l_debug_level > 0 THEN
11177: oe_debug_pub.add('CALLING WSH_DCP_PVT.Check_Scripts '
11178: ||'from delete row-'|| l_header_id, 1);
11179: END IF;
11180:
11181: WSH_DCP_PVT.Check_Scripts
11177: oe_debug_pub.add('CALLING WSH_DCP_PVT.Check_Scripts '
11178: ||'from delete row-'|| l_header_id, 1);
11179: END IF;
11180:
11181: WSH_DCP_PVT.Check_Scripts
11182: ( p_source_header_id => l_header_id
11183: ,x_data_inconsistent => l_data);
11184:
11185: IF l_debug_level > 0 THEN
11183: ,x_data_inconsistent => l_data);
11184:
11185: IF l_debug_level > 0 THEN
11186: oe_debug_pub.add
11187: ('CALLING WSH_DCP_PVT.Post_Process '|| l_data, 1);
11188: END IF;
11189:
11190: WSH_DCP_PVT.Post_Process
11191: ( p_action_code => 'OM'
11186: oe_debug_pub.add
11187: ('CALLING WSH_DCP_PVT.Post_Process '|| l_data, 1);
11188: END IF;
11189:
11190: WSH_DCP_PVT.Post_Process
11191: ( p_action_code => 'OM'
11192: ,p_raise_exception => 'Y');
11193:
11194: EXCEPTION
11191: ( p_action_code => 'OM'
11192: ,p_raise_exception => 'Y');
11193:
11194: EXCEPTION
11195: WHEN WSH_DCP_PVT.dcp_caught THEN
11196: IF l_debug_level > 0 THEN
11197: oe_debug_pub.add('OM call to WSH DCP Caught in delete', 1);
11198: END IF;
11199: