DBA Data[Home] [Help]

APPS.OE_BULK_ORDER_PVT dependencies on FND_PROFILE

Line 60: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then

56: oe_debug_pub.add( 'ERROR IN DELETE_MTL_SALES_ORDERS_BULK :' ||L_RETURN_STATUS ) ;
57: END IF;
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then
61: -- Delete line records
62: FORALL i IN 1..G_ERROR_REC.order_source_id.COUNT
63: DELETE from OE_ORDER_LINES
64: WHERE orig_sys_line_ref in

Line 176: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then

172: oe_debug_pub.add('G_ORDER_SOURCE :'||G_ERROR_REC.ORDER_SOURCE_ID(1));
173: END IF;
174:
175: --ER 9060917
176: If NVL (Fnd_Profile.Value('ONT_HVOP_DROP_INVALID_LINES'), 'N')='Y' then
177:
178: FORALL i IN (G_error_count+1)..G_ERROR_REC.order_source_id.COUNT
179: UPDATE OE_HEADERS_IFACE_ALL
180: SET ERROR_FLAG = 'Y'