2577: WHEN NO_DATA_FOUND THEN
2578: NULL;
2579: END;
2580:
2581: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2582: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2583:
2584: IF g_error_count >= 1 THEN
2585:
2578: NULL;
2579: END;
2580:
2581: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2582: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2583:
2584: IF g_error_count >= 1 THEN
2585:
2586: UPDATE OE_HEADERS_IFACE_ALL a
2595: AND b.order_source_id = a.order_source_id
2596: AND b.request_id = OE_BULK_ORDER_PVT.G_REQUEST_ID); -- Added for Bug 6671781
2597:
2598:
2599: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2600: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2601:
2602:
2603: BEGIN
2596: AND b.request_id = OE_BULK_ORDER_PVT.G_REQUEST_ID); -- Added for Bug 6671781
2597:
2598:
2599: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2600: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2601:
2602:
2603: BEGIN
2604:
2619: ----------------------------------------
2620: --ADDED BY UMA ON 7/18/02
2621: ----------------------------------------
2622:
2623: --OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2624: -- OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2625:
2626: END IF;
2627:
2620: --ADDED BY UMA ON 7/18/02
2621: ----------------------------------------
2622:
2623: --OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2624: -- OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2625:
2626: END IF;
2627:
2628: EXCEPTION