APPS.WMS_XDOCK_EXCEPTION dependencies on FND_API

Line 90: l_new_reservation.demand_ship_date := fnd_api.g_miss_date;

86: AND organization_id = p_org_id) LOOP
87:
88: l_update_flag := 'N';
89: l_exception_code := NULL;
90: l_new_reservation.demand_ship_date := fnd_api.g_miss_date;
91: l_new_reservation.supply_receipt_date := fnd_api.g_miss_date;
92:
93: l_progress := '003';
94: BEGIN

Line 91: l_new_reservation.supply_receipt_date := fnd_api.g_miss_date;

87:
88: l_update_flag := 'N';
89: l_exception_code := NULL;
90: l_new_reservation.demand_ship_date := fnd_api.g_miss_date;
91: l_new_reservation.supply_receipt_date := fnd_api.g_miss_date;
92:
93: l_progress := '003';
94: BEGIN
95: IF (l_debug = 1) THEN

Line 152: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

148: ,x_expected_time => l_expected_supply_time);
149: END IF;
150: l_progress := '008';
151:
152: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
153: IF (l_debug = 1) THEN
154: print_debug('Error getting expected supply time!');
155: END IF;
156: l_progress := '009';

Line 157: RAISE fnd_api.g_exc_unexpected_error;

153: IF (l_debug = 1) THEN
154: print_debug('Error getting expected supply time!');
155: END IF;
156: l_progress := '009';
157: RAISE fnd_api.g_exc_unexpected_error;
158: END IF;
159:
160: -- Call get_expected_time to get the actual expected_demand_date
161: l_progress := '010';

Line 178: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

174: ,x_dock_end_time => l_dock_end_time
175: ,x_expected_time => l_expected_demand_time);
176: l_progress := '011';
177:
178: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
179: IF (l_debug = 1) THEN
180: print_debug('Error getting expected demand time!');
181: END IF;
182: l_progress := '012';

Line 183: RAISE fnd_api.g_exc_unexpected_error;

179: IF (l_debug = 1) THEN
180: print_debug('Error getting expected demand time!');
181: END IF;
182: l_progress := '012';
183: RAISE fnd_api.g_exc_unexpected_error;
184: END IF;
185:
186: IF (l_debug = 1) THEN
187: print_debug('l_xdock_pegging_rec.supply_receipt_date:'||

Line 300: fnd_api.g_miss_date,

296: BEGIN
297: UPDATE mtl_reservations
298: SET exception_code = l_exception_code
299: , supply_receipt_date = Decode(l_new_reservation.supply_receipt_date,
300: fnd_api.g_miss_date,
301: supply_receipt_date,
302: l_new_reservation.supply_receipt_date)
303: , demand_ship_date = Decode(l_new_reservation.demand_ship_date,
304: fnd_api.g_miss_date,

Line 304: fnd_api.g_miss_date,

300: fnd_api.g_miss_date,
301: supply_receipt_date,
302: l_new_reservation.supply_receipt_date)
303: , demand_ship_date = Decode(l_new_reservation.demand_ship_date,
304: fnd_api.g_miss_date,
305: demand_ship_date,
306: l_new_reservation.demand_ship_date)
307: WHERE reservation_id = l_xdock_pegging_rec.reservation_id;
308: EXCEPTION

Line 314: RAISE fnd_api.g_exc_unexpected_error;

310: IF (l_debug = 1) THEN
311: print_debug('Exception occurred at progress: '||l_progress);
312: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM);
313: END IF;
314: RAISE fnd_api.g_exc_unexpected_error;
315: END ;
316:
317: l_progress := '015';
318: