eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RESERVATION_FORM_PKG dependencies on FND_API

Line 10: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true

6: --R12- Project - SU : Added variables p_Serial_Number_Tbl and p_CrossDock_Flag
7: PROCEDURE create_reservation
8: (
9: p_api_version_number IN NUMBER
10: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
11: , x_return_status OUT NOCOPY VARCHAR2
12: , x_msg_count OUT NOCOPY NUMBER
13: , x_msg_data OUT NOCOPY VARCHAR2
14: , p_requirement_date IN DATE

Line 68: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

64: , p_attribute12 IN VARCHAR2 DEFAULT NULL
65: , p_attribute13 IN VARCHAR2 DEFAULT NULL
66: , p_attribute14 IN VARCHAR2 DEFAULT NULL
67: , p_attribute15 IN VARCHAR2 DEFAULT NULL
68: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
69: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
70: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
71: , x_quantity_reserved OUT NOCOPY NUMBER
72: , x_secondary_quantity_reserved OUT NOCOPY NUMBER

Line 69: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

65: , p_attribute13 IN VARCHAR2 DEFAULT NULL
66: , p_attribute14 IN VARCHAR2 DEFAULT NULL
67: , p_attribute15 IN VARCHAR2 DEFAULT NULL
68: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
69: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
70: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
71: , x_quantity_reserved OUT NOCOPY NUMBER
72: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
73: , x_reservation_id OUT NOCOPY NUMBER

Line 70: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

66: , p_attribute14 IN VARCHAR2 DEFAULT NULL
67: , p_attribute15 IN VARCHAR2 DEFAULT NULL
68: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
69: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
70: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
71: , x_quantity_reserved OUT NOCOPY NUMBER
72: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
73: , x_reservation_id OUT NOCOPY NUMBER
74: ) IS

Line 77: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

73: , x_reservation_id OUT NOCOPY NUMBER
74: ) IS
75: l_api_version_number CONSTANT NUMBER := 1.0;
76: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation';
77: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
78: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
79: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
80: BEGIN
81: -- Standard call to check for call compatibility

Line 82: IF NOT fnd_api.compatible_api_call(l_api_version_number

78: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
79: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
80: BEGIN
81: -- Standard call to check for call compatibility
82: IF NOT fnd_api.compatible_api_call(l_api_version_number
83: , p_api_version_number
84: , l_api_name
85: , G_PKG_NAME
86: ) THEN

Line 87: RAISE fnd_api.g_exc_unexpected_error;

83: , p_api_version_number
84: , l_api_name
85: , G_PKG_NAME
86: ) THEN
87: RAISE fnd_api.g_exc_unexpected_error;
88: END IF;
89: -- Initialize message list.
90: IF fnd_api.to_boolean(p_init_msg_lst) THEN
91: fnd_msg_pub.initialize;

Line 90: IF fnd_api.to_boolean(p_init_msg_lst) THEN

86: ) THEN
87: RAISE fnd_api.g_exc_unexpected_error;
88: END IF;
89: -- Initialize message list.
90: IF fnd_api.to_boolean(p_init_msg_lst) THEN
91: fnd_msg_pub.initialize;
92: END IF;
93: -- reservation id is not decided yet
94: l_rsv_rec.reservation_id := NULL;

Line 168: IF l_return_status = fnd_api.g_ret_sts_error THEN

164: , x_secondary_quantity_reserved => x_secondary_quantity_reserved -- INVCONV
165: , x_reservation_id => x_reservation_id
166: );
167:
168: IF l_return_status = fnd_api.g_ret_sts_error THEN
169: RAISE fnd_api.g_exc_error;
170: END IF ;
171:
172: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 169: RAISE fnd_api.g_exc_error;

165: , x_reservation_id => x_reservation_id
166: );
167:
168: IF l_return_status = fnd_api.g_ret_sts_error THEN
169: RAISE fnd_api.g_exc_error;
170: END IF ;
171:
172: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
173: RAISE fnd_api.g_exc_unexpected_error;

Line 172: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

168: IF l_return_status = fnd_api.g_ret_sts_error THEN
169: RAISE fnd_api.g_exc_error;
170: END IF ;
171:
172: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
173: RAISE fnd_api.g_exc_unexpected_error;
174: END IF;
175:
176: x_return_status := l_return_status;

Line 173: RAISE fnd_api.g_exc_unexpected_error;

169: RAISE fnd_api.g_exc_error;
170: END IF ;
171:
172: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
173: RAISE fnd_api.g_exc_unexpected_error;
174: END IF;
175:
176: x_return_status := l_return_status;
177:

Line 180: WHEN fnd_api.g_exc_error THEN

176: x_return_status := l_return_status;
177:
178: EXCEPTION
179:
180: WHEN fnd_api.g_exc_error THEN
181: x_return_status := fnd_api.g_ret_sts_error;
182:
183: -- Get message count and data
184: fnd_msg_pub.count_and_get

Line 181: x_return_status := fnd_api.g_ret_sts_error;

177:
178: EXCEPTION
179:
180: WHEN fnd_api.g_exc_error THEN
181: x_return_status := fnd_api.g_ret_sts_error;
182:
183: -- Get message count and data
184: fnd_msg_pub.count_and_get
185: ( p_count => x_msg_count

Line 190: WHEN fnd_api.g_exc_unexpected_error THEN

186: , p_data => x_msg_data
187: , p_encoded => 'F'
188: );
189:
190: WHEN fnd_api.g_exc_unexpected_error THEN
191: x_return_status := fnd_api.g_ret_sts_unexp_error ;
192:
193: -- Get message count and data
194: fnd_msg_pub.count_and_get

Line 191: x_return_status := fnd_api.g_ret_sts_unexp_error ;

187: , p_encoded => 'F'
188: );
189:
190: WHEN fnd_api.g_exc_unexpected_error THEN
191: x_return_status := fnd_api.g_ret_sts_unexp_error ;
192:
193: -- Get message count and data
194: fnd_msg_pub.count_and_get
195: ( p_count => x_msg_count

Line 201: x_return_status := fnd_api.g_ret_sts_unexp_error ;

197: , p_encoded => 'F'
198: );
199:
200: WHEN OTHERS THEN
201: x_return_status := fnd_api.g_ret_sts_unexp_error ;
202:
203: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
204: THEN
205: fnd_msg_pub.add_exc_msg

Line 223: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true

219:
220: PROCEDURE create_reservation
221: (
222: p_api_version_number IN NUMBER
223: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
224: , x_return_status OUT NOCOPY VARCHAR2
225: , x_msg_count OUT NOCOPY NUMBER
226: , x_msg_data OUT NOCOPY VARCHAR2
227: , p_requirement_date IN DATE

Line 274: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

270: , p_attribute12 IN VARCHAR2 DEFAULT NULL
271: , p_attribute13 IN VARCHAR2 DEFAULT NULL
272: , p_attribute14 IN VARCHAR2 DEFAULT NULL
273: , p_attribute15 IN VARCHAR2 DEFAULT NULL
274: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
275: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
276: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
277: , x_quantity_reserved OUT NOCOPY NUMBER
278: , x_reservation_id OUT NOCOPY NUMBER

Line 275: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

271: , p_attribute13 IN VARCHAR2 DEFAULT NULL
272: , p_attribute14 IN VARCHAR2 DEFAULT NULL
273: , p_attribute15 IN VARCHAR2 DEFAULT NULL
274: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
275: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
276: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
277: , x_quantity_reserved OUT NOCOPY NUMBER
278: , x_reservation_id OUT NOCOPY NUMBER
279: ) IS

Line 276: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

272: , p_attribute14 IN VARCHAR2 DEFAULT NULL
273: , p_attribute15 IN VARCHAR2 DEFAULT NULL
274: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
275: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
276: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
277: , x_quantity_reserved OUT NOCOPY NUMBER
278: , x_reservation_id OUT NOCOPY NUMBER
279: ) IS
280: l_api_version_number CONSTANT NUMBER := 1.0;

Line 282: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

278: , x_reservation_id OUT NOCOPY NUMBER
279: ) IS
280: l_api_version_number CONSTANT NUMBER := 1.0;
281: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation';
282: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
283: l_secondary_quantity_reserved NUMBER;
284: l_Dummy_Serial_Number_Tbl Inv_Reservation_Global.Serial_Number_Tbl_Type ;
285:
286: BEGIN

Line 288: IF NOT fnd_api.compatible_api_call(l_api_version_number

284: l_Dummy_Serial_Number_Tbl Inv_Reservation_Global.Serial_Number_Tbl_Type ;
285:
286: BEGIN
287: -- Standard call to check for call compatibility
288: IF NOT fnd_api.compatible_api_call(l_api_version_number
289: , p_api_version_number
290: , l_api_name
291: , G_PKG_NAME
292: ) THEN

Line 293: RAISE fnd_api.g_exc_unexpected_error;

289: , p_api_version_number
290: , l_api_name
291: , G_PKG_NAME
292: ) THEN
293: RAISE fnd_api.g_exc_unexpected_error;
294: END IF;
295: -- Initialize message list.
296: IF fnd_api.to_boolean(p_init_msg_lst) THEN
297: fnd_msg_pub.initialize;

Line 296: IF fnd_api.to_boolean(p_init_msg_lst) THEN

292: ) THEN
293: RAISE fnd_api.g_exc_unexpected_error;
294: END IF;
295: -- Initialize message list.
296: IF fnd_api.to_boolean(p_init_msg_lst) THEN
297: fnd_msg_pub.initialize;
298: END IF;
299:
300: -- Call the over loaded function

Line 367: IF l_return_status = fnd_api.g_ret_sts_error THEN

363: , x_reservation_id => x_reservation_id
364: );
365:
366:
367: IF l_return_status = fnd_api.g_ret_sts_error THEN
368: RAISE fnd_api.g_exc_error;
369: END IF ;
370:
371: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 368: RAISE fnd_api.g_exc_error;

364: );
365:
366:
367: IF l_return_status = fnd_api.g_ret_sts_error THEN
368: RAISE fnd_api.g_exc_error;
369: END IF ;
370:
371: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
372: RAISE fnd_api.g_exc_unexpected_error;

Line 371: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

367: IF l_return_status = fnd_api.g_ret_sts_error THEN
368: RAISE fnd_api.g_exc_error;
369: END IF ;
370:
371: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
372: RAISE fnd_api.g_exc_unexpected_error;
373: END IF;
374:
375: x_return_status := l_return_status;

Line 372: RAISE fnd_api.g_exc_unexpected_error;

368: RAISE fnd_api.g_exc_error;
369: END IF ;
370:
371: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
372: RAISE fnd_api.g_exc_unexpected_error;
373: END IF;
374:
375: x_return_status := l_return_status;
376:

Line 379: WHEN fnd_api.g_exc_error THEN

375: x_return_status := l_return_status;
376:
377: EXCEPTION
378:
379: WHEN fnd_api.g_exc_error THEN
380: x_return_status := fnd_api.g_ret_sts_error;
381:
382: -- Get message count and data
383: fnd_msg_pub.count_and_get

Line 380: x_return_status := fnd_api.g_ret_sts_error;

376:
377: EXCEPTION
378:
379: WHEN fnd_api.g_exc_error THEN
380: x_return_status := fnd_api.g_ret_sts_error;
381:
382: -- Get message count and data
383: fnd_msg_pub.count_and_get
384: ( p_count => x_msg_count

Line 389: WHEN fnd_api.g_exc_unexpected_error THEN

385: , p_data => x_msg_data
386: , p_encoded => 'F'
387: );
388:
389: WHEN fnd_api.g_exc_unexpected_error THEN
390: x_return_status := fnd_api.g_ret_sts_unexp_error ;
391:
392: -- Get message count and data
393: fnd_msg_pub.count_and_get

Line 390: x_return_status := fnd_api.g_ret_sts_unexp_error ;

386: , p_encoded => 'F'
387: );
388:
389: WHEN fnd_api.g_exc_unexpected_error THEN
390: x_return_status := fnd_api.g_ret_sts_unexp_error ;
391:
392: -- Get message count and data
393: fnd_msg_pub.count_and_get
394: ( p_count => x_msg_count

Line 400: x_return_status := fnd_api.g_ret_sts_unexp_error ;

396: , p_encoded => 'F'
397: );
398:
399: WHEN OTHERS THEN
400: x_return_status := fnd_api.g_ret_sts_unexp_error ;
401:
402: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
403: THEN
404: fnd_msg_pub.add_exc_msg

Line 431: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true

427: -- INVCONV - Incorporate secondaries
428: PROCEDURE update_reservation
429: (
430: p_api_version_number IN NUMBER
431: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
432: , x_return_status OUT NOCOPY VARCHAR2
433: , x_msg_count OUT NOCOPY NUMBER
434: , x_msg_data OUT NOCOPY VARCHAR2
435: , p_from_reservation_id IN NUMBER

Line 538: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

534: , p_to_attribute12 IN VARCHAR2 DEFAULT NULL
535: , p_to_attribute13 IN VARCHAR2 DEFAULT NULL
536: , p_to_attribute14 IN VARCHAR2 DEFAULT NULL
537: , p_to_attribute15 IN VARCHAR2 DEFAULT NULL
538: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
539: ) IS
540: l_api_version_number CONSTANT NUMBER := 1.0;
541: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
542: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 542: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

538: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
539: ) IS
540: l_api_version_number CONSTANT NUMBER := 1.0;
541: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
542: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
543: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
544: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
545: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
546: BEGIN

Line 549: IF NOT fnd_api.compatible_api_call(l_api_version_number

545: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
546: BEGIN
547:
548: -- Standard call to check for call compatibility
549: IF NOT fnd_api.compatible_api_call(l_api_version_number
550: , p_api_version_number
551: , l_api_name
552: , G_PKG_NAME
553: ) THEN

Line 554: RAISE fnd_api.g_exc_unexpected_error;

550: , p_api_version_number
551: , l_api_name
552: , G_PKG_NAME
553: ) THEN
554: RAISE fnd_api.g_exc_unexpected_error;
555: END IF;
556:
557: -- Initialize message list.
558: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 558: IF fnd_api.to_boolean(p_init_msg_lst) THEN

554: RAISE fnd_api.g_exc_unexpected_error;
555: END IF;
556:
557: -- Initialize message list.
558: IF fnd_api.to_boolean(p_init_msg_lst) THEN
559: fnd_msg_pub.initialize;
560: END IF;
561:
562: -- construct the record type for the original reservation

Line 579: l_orig_rsv_rec.primary_reservation_quantity := Nvl(p_from_primary_rsv_quantity,fnd_api.g_miss_num);

575: l_orig_rsv_rec.secondary_uom_id := p_from_secondary_uom_id; -- INVCONV
576: l_orig_rsv_rec.reservation_uom_code := p_from_reservation_uom_code;
577: l_orig_rsv_rec.reservation_uom_id := p_from_reservation_uom_id;
578: l_orig_rsv_rec.reservation_quantity := p_from_reservation_quantity;
579: l_orig_rsv_rec.primary_reservation_quantity := Nvl(p_from_primary_rsv_quantity,fnd_api.g_miss_num);
580: l_orig_rsv_rec.secondary_reservation_quantity := Nvl(p_from_secondary_rsv_quantity,fnd_api.g_miss_num);
581: l_orig_rsv_rec.autodetail_group_id := p_from_autodetail_group_id;
582: -- Bug 4756403:Setting external source code to g_miss_char
583: l_orig_rsv_rec.external_source_code :=

Line 580: l_orig_rsv_rec.secondary_reservation_quantity := Nvl(p_from_secondary_rsv_quantity,fnd_api.g_miss_num);

576: l_orig_rsv_rec.reservation_uom_code := p_from_reservation_uom_code;
577: l_orig_rsv_rec.reservation_uom_id := p_from_reservation_uom_id;
578: l_orig_rsv_rec.reservation_quantity := p_from_reservation_quantity;
579: l_orig_rsv_rec.primary_reservation_quantity := Nvl(p_from_primary_rsv_quantity,fnd_api.g_miss_num);
580: l_orig_rsv_rec.secondary_reservation_quantity := Nvl(p_from_secondary_rsv_quantity,fnd_api.g_miss_num);
581: l_orig_rsv_rec.autodetail_group_id := p_from_autodetail_group_id;
582: -- Bug 4756403:Setting external source code to g_miss_char
583: l_orig_rsv_rec.external_source_code :=
584: Nvl(p_from_external_source_code, fnd_api.g_miss_char);

Line 584: Nvl(p_from_external_source_code, fnd_api.g_miss_char);

580: l_orig_rsv_rec.secondary_reservation_quantity := Nvl(p_from_secondary_rsv_quantity,fnd_api.g_miss_num);
581: l_orig_rsv_rec.autodetail_group_id := p_from_autodetail_group_id;
582: -- Bug 4756403:Setting external source code to g_miss_char
583: l_orig_rsv_rec.external_source_code :=
584: Nvl(p_from_external_source_code, fnd_api.g_miss_char);
585: l_orig_rsv_rec.external_source_line_id := p_from_external_source_line;
586: l_orig_rsv_rec.supply_source_type_id := p_from_supply_type_id;
587: l_orig_rsv_rec.supply_source_header_id := p_from_supply_header_id;
588: l_orig_rsv_rec.supply_source_line_id := p_from_supply_line_id;

Line 623: l_to_rsv_rec.organization_id := Nvl(p_from_organization_id,fnd_api.g_miss_num);

619: l_Orig_Rsv_Rec.CrossDock_Flag := p_From_CrossDock_Flag ;
620:
621: -- construct the record type for the update to record
622: l_to_rsv_rec.requirement_date := p_to_requirement_date;
623: l_to_rsv_rec.organization_id := Nvl(p_from_organization_id,fnd_api.g_miss_num);
624: l_to_rsv_rec.inventory_item_id := Nvl(p_from_inventory_item_id,fnd_api.g_miss_num);
625: l_to_rsv_rec.demand_source_type_id := p_to_demand_type_id;
626: l_to_rsv_rec.demand_source_name := p_to_demand_name;
627: l_to_rsv_rec.demand_source_header_id := p_to_demand_header_id;

Line 624: l_to_rsv_rec.inventory_item_id := Nvl(p_from_inventory_item_id,fnd_api.g_miss_num);

620:
621: -- construct the record type for the update to record
622: l_to_rsv_rec.requirement_date := p_to_requirement_date;
623: l_to_rsv_rec.organization_id := Nvl(p_from_organization_id,fnd_api.g_miss_num);
624: l_to_rsv_rec.inventory_item_id := Nvl(p_from_inventory_item_id,fnd_api.g_miss_num);
625: l_to_rsv_rec.demand_source_type_id := p_to_demand_type_id;
626: l_to_rsv_rec.demand_source_name := p_to_demand_name;
627: l_to_rsv_rec.demand_source_header_id := p_to_demand_header_id;
628: l_to_rsv_rec.demand_source_line_id := p_to_demand_line_id;

Line 637: l_to_rsv_rec.primary_reservation_quantity := Nvl(p_to_primary_rsv_quantity,fnd_api.g_miss_num);

633: l_to_rsv_rec.secondary_uom_id := p_from_secondary_uom_id; -- INVCONV
634: l_to_rsv_rec.reservation_uom_code := p_to_reservation_uom_code;
635: l_to_rsv_rec.reservation_uom_id := p_to_reservation_uom_id;
636: l_to_rsv_rec.reservation_quantity := p_to_reservation_quantity;
637: l_to_rsv_rec.primary_reservation_quantity := Nvl(p_to_primary_rsv_quantity,fnd_api.g_miss_num);
638: l_to_rsv_rec.secondary_reservation_quantity := Nvl(p_to_secondary_rsv_quantity,fnd_api.g_miss_num); --INVCONV
639: l_to_rsv_rec.autodetail_group_id := p_to_autodetail_group_id;
640:
641: -- Bug 4756403:Setting external source code to g_miss_char

Line 638: l_to_rsv_rec.secondary_reservation_quantity := Nvl(p_to_secondary_rsv_quantity,fnd_api.g_miss_num); --INVCONV

634: l_to_rsv_rec.reservation_uom_code := p_to_reservation_uom_code;
635: l_to_rsv_rec.reservation_uom_id := p_to_reservation_uom_id;
636: l_to_rsv_rec.reservation_quantity := p_to_reservation_quantity;
637: l_to_rsv_rec.primary_reservation_quantity := Nvl(p_to_primary_rsv_quantity,fnd_api.g_miss_num);
638: l_to_rsv_rec.secondary_reservation_quantity := Nvl(p_to_secondary_rsv_quantity,fnd_api.g_miss_num); --INVCONV
639: l_to_rsv_rec.autodetail_group_id := p_to_autodetail_group_id;
640:
641: -- Bug 4756403:Setting external source code to g_miss_char
642: l_to_rsv_rec.external_source_code := Nvl(p_from_external_source_code, fnd_api.g_miss_char);

Line 642: l_to_rsv_rec.external_source_code := Nvl(p_from_external_source_code, fnd_api.g_miss_char);

638: l_to_rsv_rec.secondary_reservation_quantity := Nvl(p_to_secondary_rsv_quantity,fnd_api.g_miss_num); --INVCONV
639: l_to_rsv_rec.autodetail_group_id := p_to_autodetail_group_id;
640:
641: -- Bug 4756403:Setting external source code to g_miss_char
642: l_to_rsv_rec.external_source_code := Nvl(p_from_external_source_code, fnd_api.g_miss_char);
643: l_to_rsv_rec.external_source_line_id := p_to_external_source_line;
644: l_to_rsv_rec.supply_source_type_id := p_to_supply_type_id;
645: l_to_rsv_rec.supply_source_header_id := p_to_supply_header_id;
646: l_to_rsv_rec.supply_source_line_id := p_to_supply_line_id;

Line 694: IF l_return_status = fnd_api.g_ret_sts_error THEN

690: , p_to_serial_number => p_To_serial_number_tbl -- R12 Changes : SU
691: , p_validation_flag => p_validation_flag
692: );
693:
694: IF l_return_status = fnd_api.g_ret_sts_error THEN
695: RAISE fnd_api.g_exc_error;
696: END IF ;
697:
698: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 695: RAISE fnd_api.g_exc_error;

691: , p_validation_flag => p_validation_flag
692: );
693:
694: IF l_return_status = fnd_api.g_ret_sts_error THEN
695: RAISE fnd_api.g_exc_error;
696: END IF ;
697:
698: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
699: RAISE fnd_api.g_exc_unexpected_error;

Line 698: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

694: IF l_return_status = fnd_api.g_ret_sts_error THEN
695: RAISE fnd_api.g_exc_error;
696: END IF ;
697:
698: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
699: RAISE fnd_api.g_exc_unexpected_error;
700: END IF;
701:
702: x_return_status := l_return_status;

Line 699: RAISE fnd_api.g_exc_unexpected_error;

695: RAISE fnd_api.g_exc_error;
696: END IF ;
697:
698: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
699: RAISE fnd_api.g_exc_unexpected_error;
700: END IF;
701:
702: x_return_status := l_return_status;
703:

Line 706: WHEN fnd_api.g_exc_error THEN

702: x_return_status := l_return_status;
703:
704: EXCEPTION
705:
706: WHEN fnd_api.g_exc_error THEN
707: x_return_status := fnd_api.g_ret_sts_error;
708:
709: -- Get message count and data
710: fnd_msg_pub.count_and_get

Line 707: x_return_status := fnd_api.g_ret_sts_error;

703:
704: EXCEPTION
705:
706: WHEN fnd_api.g_exc_error THEN
707: x_return_status := fnd_api.g_ret_sts_error;
708:
709: -- Get message count and data
710: fnd_msg_pub.count_and_get
711: ( p_count => x_msg_count

Line 716: WHEN fnd_api.g_exc_unexpected_error THEN

712: , p_data => x_msg_data
713: , p_encoded => 'F'
714: );
715:
716: WHEN fnd_api.g_exc_unexpected_error THEN
717: x_return_status := fnd_api.g_ret_sts_unexp_error ;
718:
719: -- Get message count and data
720: fnd_msg_pub.count_and_get

Line 717: x_return_status := fnd_api.g_ret_sts_unexp_error ;

713: , p_encoded => 'F'
714: );
715:
716: WHEN fnd_api.g_exc_unexpected_error THEN
717: x_return_status := fnd_api.g_ret_sts_unexp_error ;
718:
719: -- Get message count and data
720: fnd_msg_pub.count_and_get
721: ( p_count => x_msg_count

Line 727: x_return_status := fnd_api.g_ret_sts_unexp_error ;

723: , p_encoded => 'F'
724: );
725:
726: WHEN OTHERS THEN
727: x_return_status := fnd_api.g_ret_sts_unexp_error ;
728:
729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
730: THEN
731: fnd_msg_pub.add_exc_msg

Line 750: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true

746: -- INVCONV - Incorporate secondaries
747: PROCEDURE delete_reservation
748: (
749: p_api_version_number IN NUMBER
750: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
751: , x_return_status OUT NOCOPY VARCHAR2
752: , x_msg_count OUT NOCOPY NUMBER
753: , x_msg_data OUT NOCOPY VARCHAR2
754: , p_reservation_id IN NUMBER

Line 811: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

807: , p_validation_flag IN VARCHAR2 DEFAULT 'T' --Bug 2354735
808: ) IS
809: l_api_version_number CONSTANT NUMBER := 1.0;
810: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Reservation';
811: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
812: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
813: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
814: BEGIN
815: -- Standard call to check for call compatibility

Line 816: IF NOT fnd_api.compatible_api_call(l_api_version_number

812: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
813: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
814: BEGIN
815: -- Standard call to check for call compatibility
816: IF NOT fnd_api.compatible_api_call(l_api_version_number
817: , p_api_version_number
818: , l_api_name
819: , G_PKG_NAME
820: ) THEN

Line 821: RAISE fnd_api.g_exc_unexpected_error;

817: , p_api_version_number
818: , l_api_name
819: , G_PKG_NAME
820: ) THEN
821: RAISE fnd_api.g_exc_unexpected_error;
822: END IF;
823:
824: -- Initialize message list.
825: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 825: IF fnd_api.to_boolean(p_init_msg_lst) THEN

821: RAISE fnd_api.g_exc_unexpected_error;
822: END IF;
823:
824: -- Initialize message list.
825: IF fnd_api.to_boolean(p_init_msg_lst) THEN
826: fnd_msg_pub.initialize;
827: END IF;
828:
829: l_rsv_rec.reservation_id := p_reservation_id;

Line 894: IF l_return_status = fnd_api.g_ret_sts_error THEN

890: , p_original_serial_number => p_serial_number_Tbl -- R12 Changes : SU
891: , p_validation_flag => p_validation_flag -- Bug 2354735
892: );
893:
894: IF l_return_status = fnd_api.g_ret_sts_error THEN
895: RAISE fnd_api.g_exc_error;
896: END IF ;
897:
898: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 895: RAISE fnd_api.g_exc_error;

891: , p_validation_flag => p_validation_flag -- Bug 2354735
892: );
893:
894: IF l_return_status = fnd_api.g_ret_sts_error THEN
895: RAISE fnd_api.g_exc_error;
896: END IF ;
897:
898: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
899: RAISE fnd_api.g_exc_unexpected_error;

Line 898: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

894: IF l_return_status = fnd_api.g_ret_sts_error THEN
895: RAISE fnd_api.g_exc_error;
896: END IF ;
897:
898: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
899: RAISE fnd_api.g_exc_unexpected_error;
900: END IF;
901:
902: x_return_status := l_return_status;

Line 899: RAISE fnd_api.g_exc_unexpected_error;

895: RAISE fnd_api.g_exc_error;
896: END IF ;
897:
898: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
899: RAISE fnd_api.g_exc_unexpected_error;
900: END IF;
901:
902: x_return_status := l_return_status;
903:

Line 906: WHEN fnd_api.g_exc_error THEN

902: x_return_status := l_return_status;
903:
904: EXCEPTION
905:
906: WHEN fnd_api.g_exc_error THEN
907: x_return_status := fnd_api.g_ret_sts_error;
908:
909: -- Get message count and data
910: fnd_msg_pub.count_and_get

Line 907: x_return_status := fnd_api.g_ret_sts_error;

903:
904: EXCEPTION
905:
906: WHEN fnd_api.g_exc_error THEN
907: x_return_status := fnd_api.g_ret_sts_error;
908:
909: -- Get message count and data
910: fnd_msg_pub.count_and_get
911: ( p_count => x_msg_count

Line 916: WHEN fnd_api.g_exc_unexpected_error THEN

912: , p_data => x_msg_data
913: , p_encoded => 'F'
914: );
915:
916: WHEN fnd_api.g_exc_unexpected_error THEN
917: x_return_status := fnd_api.g_ret_sts_unexp_error ;
918:
919: -- Get message count and data
920: fnd_msg_pub.count_and_get

Line 917: x_return_status := fnd_api.g_ret_sts_unexp_error ;

913: , p_encoded => 'F'
914: );
915:
916: WHEN fnd_api.g_exc_unexpected_error THEN
917: x_return_status := fnd_api.g_ret_sts_unexp_error ;
918:
919: -- Get message count and data
920: fnd_msg_pub.count_and_get
921: ( p_count => x_msg_count

Line 927: x_return_status := fnd_api.g_ret_sts_unexp_error ;

923: , p_encoded => 'F'
924: );
925:
926: WHEN OTHERS THEN
927: x_return_status := fnd_api.g_ret_sts_unexp_error ;
928:
929: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
930: THEN
931: fnd_msg_pub.add_exc_msg

Line 950: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true

946: -- INVCONV - Incorporate secondaries
947: PROCEDURE transfer_supply
948: (
949: p_api_version_number IN NUMBER
950: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
951: , x_return_status OUT NOCOPY VARCHAR2
952: , x_msg_count OUT NOCOPY NUMBER
953: , x_msg_data OUT NOCOPY VARCHAR2
954: , p_from_reservation_id IN NUMBER

Line 1022: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

1018: , p_to_lot_number IN VARCHAR2
1019: , p_to_lot_number_id IN NUMBER
1020: , p_to_pick_slip_number IN NUMBER
1021: , p_to_lpn_id IN NUMBER
1022: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
1023: , x_to_reservation_id OUT NOCOPY NUMBER
1024: ) IS
1025: l_api_version_number CONSTANT NUMBER := 1.0;
1026: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Supply';

Line 1027: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1023: , x_to_reservation_id OUT NOCOPY NUMBER
1024: ) IS
1025: l_api_version_number CONSTANT NUMBER := 1.0;
1026: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Supply';
1027: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1028: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1029: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1030: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
1031: BEGIN

Line 1034: IF NOT fnd_api.compatible_api_call(l_api_version_number

1030: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
1031: BEGIN
1032:
1033: -- Standard call to check for call compatibility
1034: IF NOT fnd_api.compatible_api_call(l_api_version_number
1035: , p_api_version_number
1036: , l_api_name
1037: , G_PKG_NAME
1038: ) THEN

Line 1039: RAISE fnd_api.g_exc_unexpected_error;

1035: , p_api_version_number
1036: , l_api_name
1037: , G_PKG_NAME
1038: ) THEN
1039: RAISE fnd_api.g_exc_unexpected_error;
1040: END IF;
1041:
1042: -- Initialize message list.
1043: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 1043: IF fnd_api.to_boolean(p_init_msg_lst) THEN

1039: RAISE fnd_api.g_exc_unexpected_error;
1040: END IF;
1041:
1042: -- Initialize message list.
1043: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1044: fnd_msg_pub.initialize;
1045: END IF;
1046:
1047: -- construct the record type for the original reservation

Line 1049: AND p_from_reservation_id <> fnd_api.g_miss_num

1045: END IF;
1046:
1047: -- construct the record type for the original reservation
1048: IF p_from_reservation_id IS NOT NULL
1049: AND p_from_reservation_id <> fnd_api.g_miss_num
1050: THEN
1051: l_orig_rsv_rec.reservation_id := p_from_reservation_id;
1052: ELSE
1053: l_orig_rsv_rec.requirement_date := p_from_requirement_date;

Line 1139: IF l_return_status = fnd_api.g_ret_sts_error THEN

1135: , p_validation_flag => p_validation_flag
1136: , x_reservation_id => x_to_reservation_id
1137: );
1138:
1139: IF l_return_status = fnd_api.g_ret_sts_error THEN
1140: RAISE fnd_api.g_exc_error;
1141: END IF ;
1142:
1143: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1140: RAISE fnd_api.g_exc_error;

1136: , x_reservation_id => x_to_reservation_id
1137: );
1138:
1139: IF l_return_status = fnd_api.g_ret_sts_error THEN
1140: RAISE fnd_api.g_exc_error;
1141: END IF ;
1142:
1143: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1144: RAISE fnd_api.g_exc_unexpected_error;

Line 1143: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1139: IF l_return_status = fnd_api.g_ret_sts_error THEN
1140: RAISE fnd_api.g_exc_error;
1141: END IF ;
1142:
1143: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1144: RAISE fnd_api.g_exc_unexpected_error;
1145: END IF;
1146:
1147: x_return_status := l_return_status;

Line 1144: RAISE fnd_api.g_exc_unexpected_error;

1140: RAISE fnd_api.g_exc_error;
1141: END IF ;
1142:
1143: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1144: RAISE fnd_api.g_exc_unexpected_error;
1145: END IF;
1146:
1147: x_return_status := l_return_status;
1148:

Line 1151: WHEN fnd_api.g_exc_error THEN

1147: x_return_status := l_return_status;
1148:
1149: EXCEPTION
1150:
1151: WHEN fnd_api.g_exc_error THEN
1152: x_return_status := fnd_api.g_ret_sts_error;
1153:
1154: -- Get message count and data
1155: fnd_msg_pub.count_and_get

Line 1152: x_return_status := fnd_api.g_ret_sts_error;

1148:
1149: EXCEPTION
1150:
1151: WHEN fnd_api.g_exc_error THEN
1152: x_return_status := fnd_api.g_ret_sts_error;
1153:
1154: -- Get message count and data
1155: fnd_msg_pub.count_and_get
1156: ( p_count => x_msg_count

Line 1161: WHEN fnd_api.g_exc_unexpected_error THEN

1157: , p_data => x_msg_data
1158: , p_encoded => 'F'
1159: );
1160:
1161: WHEN fnd_api.g_exc_unexpected_error THEN
1162: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1163:
1164: -- Get message count and data
1165: fnd_msg_pub.count_and_get

Line 1162: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1158: , p_encoded => 'F'
1159: );
1160:
1161: WHEN fnd_api.g_exc_unexpected_error THEN
1162: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1163:
1164: -- Get message count and data
1165: fnd_msg_pub.count_and_get
1166: ( p_count => x_msg_count

Line 1172: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1168: , p_encoded => 'F'
1169: );
1170:
1171: WHEN OTHERS THEN
1172: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1173:
1174: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1175: THEN
1176: fnd_msg_pub.add_exc_msg

Line 1195: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true

1191: -- INVCONV - Incorporate secondaries
1192: PROCEDURE transfer_demand
1193: (
1194: p_api_version_number IN NUMBER
1195: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
1196: , x_return_status OUT NOCOPY VARCHAR2
1197: , x_msg_count OUT NOCOPY NUMBER
1198: , x_msg_data OUT NOCOPY VARCHAR2
1199: , p_from_reservation_id IN NUMBER

Line 1263: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

1259: , p_to_secondary_uom_code IN VARCHAR2 -- INVCONV
1260: , p_to_secondary_rsv_quantity IN NUMBER -- INVCONV
1261: , p_to_project_id IN NUMBER Default Null
1262: , p_to_task_id IN NUMBER Default Null
1263: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
1264: , x_to_reservation_id OUT NOCOPY NUMBER
1265: ) IS
1266: l_api_version_number CONSTANT NUMBER := 1.0;
1267: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Demand';

Line 1268: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1264: , x_to_reservation_id OUT NOCOPY NUMBER
1265: ) IS
1266: l_api_version_number CONSTANT NUMBER := 1.0;
1267: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Demand';
1268: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1269: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1270: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1271: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
1272: l_fulfill_base VARCHAR2(1) := 'P';

Line 1276: IF NOT fnd_api.compatible_api_call(l_api_version_number

1272: l_fulfill_base VARCHAR2(1) := 'P';
1273: BEGIN
1274:
1275: -- Standard call to check for call compatibility
1276: IF NOT fnd_api.compatible_api_call(l_api_version_number
1277: , p_api_version_number
1278: , l_api_name
1279: , G_PKG_NAME
1280: ) THEN

Line 1281: RAISE fnd_api.g_exc_unexpected_error;

1277: , p_api_version_number
1278: , l_api_name
1279: , G_PKG_NAME
1280: ) THEN
1281: RAISE fnd_api.g_exc_unexpected_error;
1282: END IF;
1283:
1284: -- Initialize message list.
1285: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 1285: IF fnd_api.to_boolean(p_init_msg_lst) THEN

1281: RAISE fnd_api.g_exc_unexpected_error;
1282: END IF;
1283:
1284: -- Initialize message list.
1285: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1286: fnd_msg_pub.initialize;
1287: END IF;
1288:
1289: -- construct the record type for the original reservation

Line 1291: AND p_from_reservation_id <> fnd_api.g_miss_num THEN

1287: END IF;
1288:
1289: -- construct the record type for the original reservation
1290: IF p_from_reservation_id IS NOT NULL
1291: AND p_from_reservation_id <> fnd_api.g_miss_num THEN
1292: l_orig_rsv_rec.reservation_id := p_from_reservation_id;
1293: ELSE
1294: l_orig_rsv_rec.requirement_date := p_from_requirement_date;
1295: l_orig_rsv_rec.organization_id := p_from_organization_id;

Line 1389: IF l_return_status = fnd_api.g_ret_sts_error THEN

1385: , p_validation_flag => p_validation_flag
1386: , x_reservation_id => x_to_reservation_id
1387: );
1388:
1389: IF l_return_status = fnd_api.g_ret_sts_error THEN
1390: RAISE fnd_api.g_exc_error;
1391: END IF ;
1392:
1393: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1390: RAISE fnd_api.g_exc_error;

1386: , x_reservation_id => x_to_reservation_id
1387: );
1388:
1389: IF l_return_status = fnd_api.g_ret_sts_error THEN
1390: RAISE fnd_api.g_exc_error;
1391: END IF ;
1392:
1393: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1394: RAISE fnd_api.g_exc_unexpected_error;

Line 1393: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1389: IF l_return_status = fnd_api.g_ret_sts_error THEN
1390: RAISE fnd_api.g_exc_error;
1391: END IF ;
1392:
1393: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1394: RAISE fnd_api.g_exc_unexpected_error;
1395: END IF;
1396:
1397: x_return_status := l_return_status;

Line 1394: RAISE fnd_api.g_exc_unexpected_error;

1390: RAISE fnd_api.g_exc_error;
1391: END IF ;
1392:
1393: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1394: RAISE fnd_api.g_exc_unexpected_error;
1395: END IF;
1396:
1397: x_return_status := l_return_status;
1398:

Line 1401: WHEN fnd_api.g_exc_error THEN

1397: x_return_status := l_return_status;
1398:
1399: EXCEPTION
1400:
1401: WHEN fnd_api.g_exc_error THEN
1402: x_return_status := fnd_api.g_ret_sts_error;
1403:
1404: -- Get message count and data
1405: fnd_msg_pub.count_and_get

Line 1402: x_return_status := fnd_api.g_ret_sts_error;

1398:
1399: EXCEPTION
1400:
1401: WHEN fnd_api.g_exc_error THEN
1402: x_return_status := fnd_api.g_ret_sts_error;
1403:
1404: -- Get message count and data
1405: fnd_msg_pub.count_and_get
1406: ( p_count => x_msg_count

Line 1411: WHEN fnd_api.g_exc_unexpected_error THEN

1407: , p_data => x_msg_data
1408: , p_encoded => 'F'
1409: );
1410:
1411: WHEN fnd_api.g_exc_unexpected_error THEN
1412: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1413:
1414: -- Get message count and data
1415: fnd_msg_pub.count_and_get

Line 1412: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1408: , p_encoded => 'F'
1409: );
1410:
1411: WHEN fnd_api.g_exc_unexpected_error THEN
1412: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1413:
1414: -- Get message count and data
1415: fnd_msg_pub.count_and_get
1416: ( p_count => x_msg_count

Line 1422: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1418: , p_encoded => 'F'
1419: );
1420:
1421: WHEN OTHERS THEN
1422: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1423:
1424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1425: THEN
1426: fnd_msg_pub.add_exc_msg

Line 1444: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

1440: --
1441: PROCEDURE query_reservation
1442: (
1443: p_api_version_number IN NUMBER
1444: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1445: , x_return_status OUT NOCOPY VARCHAR2
1446: , x_msg_count OUT NOCOPY NUMBER
1447: , x_msg_data OUT NOCOPY VARCHAR2
1448: , p_reservation_id IN NUMBER

Line 1449: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false

1445: , x_return_status OUT NOCOPY VARCHAR2
1446: , x_msg_count OUT NOCOPY NUMBER
1447: , x_msg_data OUT NOCOPY VARCHAR2
1448: , p_reservation_id IN NUMBER
1449: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1450: , p_sort_by_req_date IN NUMBER
1451: , p_cancel_order_mode IN NUMBER
1452: , x_mtl_reservation_tbl
1453: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

Line 1459: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1455: , x_error_code OUT NOCOPY NUMBER
1456: ) IS
1457: l_api_version_number CONSTANT NUMBER := 1.0;
1458: l_api_name CONSTANT VARCHAR2(30) := 'Query_Reservation';
1459: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1460: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1461: BEGIN
1462: -- Standard call to check for call compatibility
1463: IF NOT fnd_api.compatible_api_call(l_api_version_number

Line 1463: IF NOT fnd_api.compatible_api_call(l_api_version_number

1459: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1460: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1461: BEGIN
1462: -- Standard call to check for call compatibility
1463: IF NOT fnd_api.compatible_api_call(l_api_version_number
1464: , p_api_version_number
1465: , l_api_name
1466: , G_PKG_NAME
1467: ) THEN

Line 1468: RAISE fnd_api.g_exc_unexpected_error;

1464: , p_api_version_number
1465: , l_api_name
1466: , G_PKG_NAME
1467: ) THEN
1468: RAISE fnd_api.g_exc_unexpected_error;
1469: END IF;
1470: --
1471: -- Initialize message list.
1472: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 1472: IF fnd_api.to_boolean(p_init_msg_lst) THEN

1468: RAISE fnd_api.g_exc_unexpected_error;
1469: END IF;
1470: --
1471: -- Initialize message list.
1472: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1473: fnd_msg_pub.initialize;
1474: END IF;
1475: --
1476: l_rsv_rec.reservation_id := p_reservation_id;

Line 1479: , p_init_msg_lst => fnd_api.g_false

1475: --
1476: l_rsv_rec.reservation_id := p_reservation_id;
1477: inv_reservation_pub.query_reservation
1478: ( p_api_version_number => 1.0
1479: , p_init_msg_lst => fnd_api.g_false
1480: , x_return_status => l_return_status
1481: , x_msg_count => x_msg_count
1482: , x_msg_data => x_msg_data
1483: , p_query_input => l_rsv_rec

Line 1491: IF l_return_status = fnd_api.g_ret_sts_error THEN

1487: , x_mtl_reservation_tbl => x_mtl_reservation_tbl
1488: , x_mtl_reservation_tbl_count => x_mtl_reservation_tbl_count
1489: , x_error_code => x_error_code
1490: );
1491: IF l_return_status = fnd_api.g_ret_sts_error THEN
1492: RAISE fnd_api.g_exc_error;
1493: END IF ;
1494:
1495: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1492: RAISE fnd_api.g_exc_error;

1488: , x_mtl_reservation_tbl_count => x_mtl_reservation_tbl_count
1489: , x_error_code => x_error_code
1490: );
1491: IF l_return_status = fnd_api.g_ret_sts_error THEN
1492: RAISE fnd_api.g_exc_error;
1493: END IF ;
1494:
1495: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1496: RAISE fnd_api.g_exc_unexpected_error;

Line 1495: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1491: IF l_return_status = fnd_api.g_ret_sts_error THEN
1492: RAISE fnd_api.g_exc_error;
1493: END IF ;
1494:
1495: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1496: RAISE fnd_api.g_exc_unexpected_error;
1497: END IF;
1498:
1499: x_return_status := l_return_status;

Line 1496: RAISE fnd_api.g_exc_unexpected_error;

1492: RAISE fnd_api.g_exc_error;
1493: END IF ;
1494:
1495: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1496: RAISE fnd_api.g_exc_unexpected_error;
1497: END IF;
1498:
1499: x_return_status := l_return_status;
1500:

Line 1503: WHEN fnd_api.g_exc_error THEN

1499: x_return_status := l_return_status;
1500:
1501: EXCEPTION
1502:
1503: WHEN fnd_api.g_exc_error THEN
1504: x_return_status := fnd_api.g_ret_sts_error;
1505:
1506: -- Get message count and data
1507: fnd_msg_pub.count_and_get

Line 1504: x_return_status := fnd_api.g_ret_sts_error;

1500:
1501: EXCEPTION
1502:
1503: WHEN fnd_api.g_exc_error THEN
1504: x_return_status := fnd_api.g_ret_sts_error;
1505:
1506: -- Get message count and data
1507: fnd_msg_pub.count_and_get
1508: ( p_count => x_msg_count

Line 1513: WHEN fnd_api.g_exc_unexpected_error THEN

1509: , p_data => x_msg_data
1510: , p_encoded => 'F'
1511: );
1512:
1513: WHEN fnd_api.g_exc_unexpected_error THEN
1514: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1515:
1516: -- Get message count and data
1517: fnd_msg_pub.count_and_get

Line 1514: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1510: , p_encoded => 'F'
1511: );
1512:
1513: WHEN fnd_api.g_exc_unexpected_error THEN
1514: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1515:
1516: -- Get message count and data
1517: fnd_msg_pub.count_and_get
1518: ( p_count => x_msg_count

Line 1524: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1520: , p_encoded => 'F'
1521: );
1522:
1523: WHEN OTHERS THEN
1524: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1525:
1526: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1527: THEN
1528: fnd_msg_pub.add_exc_msg

Line 1545: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

1541:
1542: PROCEDURE get_reservable_quantity
1543: (
1544: p_api_version_number IN NUMBER
1545: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1546: , x_return_status OUT NOCOPY VARCHAR2
1547: , x_msg_count OUT NOCOPY NUMBER
1548: , x_msg_data OUT NOCOPY VARCHAR2
1549: , p_reservation_id IN NUMBER

Line 1583: x_return_status := fnd_api.g_ret_sts_success;

1579: lx_Qty_Available2 Number;
1580: l_Reservable_Quantity2 number;
1581: BEGIN
1582: -- Initialize return status
1583: x_return_status := fnd_api.g_ret_sts_success;
1584:
1585: -- Standard call to check for call compatibility
1586: IF NOT fnd_api.compatible_api_call(l_api_version_number
1587: , p_api_version_number

Line 1586: IF NOT fnd_api.compatible_api_call(l_api_version_number

1582: -- Initialize return status
1583: x_return_status := fnd_api.g_ret_sts_success;
1584:
1585: -- Standard call to check for call compatibility
1586: IF NOT fnd_api.compatible_api_call(l_api_version_number
1587: , p_api_version_number
1588: , l_api_name
1589: , G_PKG_NAME
1590: ) THEN

Line 1591: RAISE fnd_api.g_exc_unexpected_error;

1587: , p_api_version_number
1588: , l_api_name
1589: , G_PKG_NAME
1590: ) THEN
1591: RAISE fnd_api.g_exc_unexpected_error;
1592: END IF;
1593: --
1594: -- Initialize message list.
1595: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 1595: IF fnd_api.to_boolean(p_init_msg_lst) THEN

1591: RAISE fnd_api.g_exc_unexpected_error;
1592: END IF;
1593: --
1594: -- Initialize message list.
1595: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1596: fnd_msg_pub.initialize;
1597: END IF;
1598:
1599: if p_demand_type_id in (inv_reservation_global.g_source_type_oe,

Line 1702: IF x_return_status = fnd_api.g_ret_sts_error THEN

1698: ,p_Task_Id => P_Task_Id
1699: ,p_API_Version_Number => 1.0
1700: ,p_Init_Msg_Lst => p_Init_Msg_lst );
1701:
1702: IF x_return_status = fnd_api.g_ret_sts_error THEN
1703: RAISE fnd_api.g_exc_error;
1704: END IF ;
1705:
1706: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1703: RAISE fnd_api.g_exc_error;

1699: ,p_API_Version_Number => 1.0
1700: ,p_Init_Msg_Lst => p_Init_Msg_lst );
1701:
1702: IF x_return_status = fnd_api.g_ret_sts_error THEN
1703: RAISE fnd_api.g_exc_error;
1704: END IF ;
1705:
1706: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1707: RAISE fnd_api.g_exc_unexpected_error;

Line 1706: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1702: IF x_return_status = fnd_api.g_ret_sts_error THEN
1703: RAISE fnd_api.g_exc_error;
1704: END IF ;
1705:
1706: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1707: RAISE fnd_api.g_exc_unexpected_error;
1708: END IF;
1709: end if;
1710:

Line 1707: RAISE fnd_api.g_exc_unexpected_error;

1703: RAISE fnd_api.g_exc_error;
1704: END IF ;
1705:
1706: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1707: RAISE fnd_api.g_exc_unexpected_error;
1708: END IF;
1709: end if;
1710:
1711: EXCEPTION

Line 1713: WHEN fnd_api.g_exc_error THEN

1709: end if;
1710:
1711: EXCEPTION
1712:
1713: WHEN fnd_api.g_exc_error THEN
1714: x_return_status := fnd_api.g_ret_sts_error;
1715: x_reservable_quantity := 0;
1716:
1717: -- Get message count and data

Line 1714: x_return_status := fnd_api.g_ret_sts_error;

1710:
1711: EXCEPTION
1712:
1713: WHEN fnd_api.g_exc_error THEN
1714: x_return_status := fnd_api.g_ret_sts_error;
1715: x_reservable_quantity := 0;
1716:
1717: -- Get message count and data
1718: fnd_msg_pub.count_and_get

Line 1724: WHEN fnd_api.g_exc_unexpected_error THEN

1720: , p_data => x_msg_data
1721: , p_encoded => 'F'
1722: );
1723:
1724: WHEN fnd_api.g_exc_unexpected_error THEN
1725: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1726: x_reservable_quantity := 0;
1727:
1728: -- Get message count and data

Line 1725: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1721: , p_encoded => 'F'
1722: );
1723:
1724: WHEN fnd_api.g_exc_unexpected_error THEN
1725: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1726: x_reservable_quantity := 0;
1727:
1728: -- Get message count and data
1729: fnd_msg_pub.count_and_get

Line 1736: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1732: , p_encoded => 'F'
1733: );
1734:
1735: WHEN OTHERS THEN
1736: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1737: x_reservable_quantity := 0;
1738:
1739: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1740: THEN

Line 1759: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

1755: -- GME CONVERGENCE BEGIN
1756: PROCEDURE create_move_order_header
1757: (
1758: p_api_version_number IN NUMBER
1759: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1760: , p_organization_id IN NUMBER
1761: , x_return_status OUT NOCOPY VARCHAR2
1762: , x_msg_count OUT NOCOPY NUMBER
1763: , x_msg_data OUT NOCOPY VARCHAR2

Line 1778: x_return_status := fnd_api.g_ret_sts_success;

1774: l_out_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1775:
1776: BEGIN
1777: -- Initialize return status
1778: x_return_status := fnd_api.g_ret_sts_success;
1779:
1780: -- Standard call to check for call compatibility
1781: IF NOT fnd_api.compatible_api_call(l_api_version_number
1782: , p_api_version_number

Line 1781: IF NOT fnd_api.compatible_api_call(l_api_version_number

1777: -- Initialize return status
1778: x_return_status := fnd_api.g_ret_sts_success;
1779:
1780: -- Standard call to check for call compatibility
1781: IF NOT fnd_api.compatible_api_call(l_api_version_number
1782: , p_api_version_number
1783: , l_api_name
1784: , G_PKG_NAME
1785: ) THEN

Line 1786: RAISE fnd_api.g_exc_unexpected_error;

1782: , p_api_version_number
1783: , l_api_name
1784: , G_PKG_NAME
1785: ) THEN
1786: RAISE fnd_api.g_exc_unexpected_error;
1787: END IF;
1788: --
1789: -- Initialize message list.
1790: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 1790: IF fnd_api.to_boolean(p_init_msg_lst) THEN

1786: RAISE fnd_api.g_exc_unexpected_error;
1787: END IF;
1788: --
1789: -- Initialize message list.
1790: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1791: fnd_msg_pub.initialize;
1792: END IF;
1793:
1794: l_in_trohdr_rec.organization_id := p_organization_id;

Line 1797: l_in_trohdr_rec.request_number := FND_API.G_MISS_CHAR;

1793:
1794: l_in_trohdr_rec.organization_id := p_organization_id;
1795: l_in_trohdr_rec.move_order_type := 8;
1796: l_in_trohdr_rec.operation := inv_globals.g_opr_create;
1797: l_in_trohdr_rec.request_number := FND_API.G_MISS_CHAR;
1798: l_in_trohdr_rec.header_id := FND_API.G_MISS_NUM;
1799: l_in_trohdr_rec.creation_date := SYSDATE;
1800: l_in_trohdr_rec.created_by := l_user_id;
1801: l_in_trohdr_rec.last_update_date := SYSDATE;

Line 1798: l_in_trohdr_rec.header_id := FND_API.G_MISS_NUM;

1794: l_in_trohdr_rec.organization_id := p_organization_id;
1795: l_in_trohdr_rec.move_order_type := 8;
1796: l_in_trohdr_rec.operation := inv_globals.g_opr_create;
1797: l_in_trohdr_rec.request_number := FND_API.G_MISS_CHAR;
1798: l_in_trohdr_rec.header_id := FND_API.G_MISS_NUM;
1799: l_in_trohdr_rec.creation_date := SYSDATE;
1800: l_in_trohdr_rec.created_by := l_user_id;
1801: l_in_trohdr_rec.last_update_date := SYSDATE;
1802: l_in_trohdr_rec.last_updated_by := l_user_id;

Line 1805: p_init_msg_list => FND_API.G_FALSE,

1801: l_in_trohdr_rec.last_update_date := SYSDATE;
1802: l_in_trohdr_rec.last_updated_by := l_user_id;
1803: inv_move_order_pub.create_move_order_header
1804: (p_api_version_number => 1.0,
1805: p_init_msg_list => FND_API.G_FALSE,
1806: p_return_values => FND_API.G_FALSE,
1807: p_commit => FND_API.G_FALSE,
1808: x_return_status => l_return_status,
1809: x_msg_count => x_msg_count,

Line 1806: p_return_values => FND_API.G_FALSE,

1802: l_in_trohdr_rec.last_updated_by := l_user_id;
1803: inv_move_order_pub.create_move_order_header
1804: (p_api_version_number => 1.0,
1805: p_init_msg_list => FND_API.G_FALSE,
1806: p_return_values => FND_API.G_FALSE,
1807: p_commit => FND_API.G_FALSE,
1808: x_return_status => l_return_status,
1809: x_msg_count => x_msg_count,
1810: x_msg_data => x_msg_data,

Line 1807: p_commit => FND_API.G_FALSE,

1803: inv_move_order_pub.create_move_order_header
1804: (p_api_version_number => 1.0,
1805: p_init_msg_list => FND_API.G_FALSE,
1806: p_return_values => FND_API.G_FALSE,
1807: p_commit => FND_API.G_FALSE,
1808: x_return_status => l_return_status,
1809: x_msg_count => x_msg_count,
1810: x_msg_data => x_msg_data,
1811: p_trohdr_rec => l_in_trohdr_rec,

Line 1817: IF l_return_status = fnd_api.g_ret_sts_error THEN

1813: x_trohdr_rec => l_out_trohdr_rec,
1814: x_trohdr_val_rec => l_out_trohdr_val_rec,
1815: p_validation_flag => inv_move_order_pub.g_validation_yes);
1816:
1817: IF l_return_status = fnd_api.g_ret_sts_error THEN
1818: RAISE fnd_api.g_exc_error;
1819: END IF ;
1820:
1821: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1818: RAISE fnd_api.g_exc_error;

1814: x_trohdr_val_rec => l_out_trohdr_val_rec,
1815: p_validation_flag => inv_move_order_pub.g_validation_yes);
1816:
1817: IF l_return_status = fnd_api.g_ret_sts_error THEN
1818: RAISE fnd_api.g_exc_error;
1819: END IF ;
1820:
1821: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1822: RAISE fnd_api.g_exc_unexpected_error;

Line 1821: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1817: IF l_return_status = fnd_api.g_ret_sts_error THEN
1818: RAISE fnd_api.g_exc_error;
1819: END IF ;
1820:
1821: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1822: RAISE fnd_api.g_exc_unexpected_error;
1823: END IF;
1824:
1825: x_header_id := l_out_trohdr_rec.header_id;

Line 1822: RAISE fnd_api.g_exc_unexpected_error;

1818: RAISE fnd_api.g_exc_error;
1819: END IF ;
1820:
1821: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1822: RAISE fnd_api.g_exc_unexpected_error;
1823: END IF;
1824:
1825: x_header_id := l_out_trohdr_rec.header_id;
1826:

Line 1829: WHEN fnd_api.g_exc_error THEN

1825: x_header_id := l_out_trohdr_rec.header_id;
1826:
1827: EXCEPTION
1828:
1829: WHEN fnd_api.g_exc_error THEN
1830: x_return_status := fnd_api.g_ret_sts_error;
1831:
1832: -- Get message count and data
1833: fnd_msg_pub.count_and_get

Line 1830: x_return_status := fnd_api.g_ret_sts_error;

1826:
1827: EXCEPTION
1828:
1829: WHEN fnd_api.g_exc_error THEN
1830: x_return_status := fnd_api.g_ret_sts_error;
1831:
1832: -- Get message count and data
1833: fnd_msg_pub.count_and_get
1834: ( p_count => x_msg_count

Line 1839: WHEN fnd_api.g_exc_unexpected_error THEN

1835: , p_data => x_msg_data
1836: , p_encoded => 'F'
1837: );
1838:
1839: WHEN fnd_api.g_exc_unexpected_error THEN
1840: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1841:
1842: -- Get message count and data
1843: fnd_msg_pub.count_and_get

Line 1840: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1836: , p_encoded => 'F'
1837: );
1838:
1839: WHEN fnd_api.g_exc_unexpected_error THEN
1840: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1841:
1842: -- Get message count and data
1843: fnd_msg_pub.count_and_get
1844: ( p_count => x_msg_count

Line 1850: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1846: , p_encoded => 'F'
1847: );
1848:
1849: WHEN OTHERS THEN
1850: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1851:
1852: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1853: THEN
1854: fnd_msg_pub.add_exc_msg

Line 1871: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

1867:
1868: PROCEDURE create_move_order_line
1869: (
1870: p_api_version_number IN NUMBER
1871: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1872: , p_organization_id IN NUMBER
1873: , p_move_order_header_id IN NUMBER
1874: , p_inventory_item_id IN NUMBER
1875: , p_quantity IN NUMBER

Line 1902: x_return_status := fnd_api.g_ret_sts_success;

1898: l_out_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1899:
1900: BEGIN
1901: -- Initialize return status
1902: x_return_status := fnd_api.g_ret_sts_success;
1903:
1904: -- Standard call to check for call compatibility
1905: IF NOT fnd_api.compatible_api_call(l_api_version_number
1906: , p_api_version_number

Line 1905: IF NOT fnd_api.compatible_api_call(l_api_version_number

1901: -- Initialize return status
1902: x_return_status := fnd_api.g_ret_sts_success;
1903:
1904: -- Standard call to check for call compatibility
1905: IF NOT fnd_api.compatible_api_call(l_api_version_number
1906: , p_api_version_number
1907: , l_api_name
1908: , G_PKG_NAME
1909: ) THEN

Line 1910: RAISE fnd_api.g_exc_unexpected_error;

1906: , p_api_version_number
1907: , l_api_name
1908: , G_PKG_NAME
1909: ) THEN
1910: RAISE fnd_api.g_exc_unexpected_error;
1911: END IF;
1912: --
1913: -- Initialize message list.
1914: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 1914: IF fnd_api.to_boolean(p_init_msg_lst) THEN

1910: RAISE fnd_api.g_exc_unexpected_error;
1911: END IF;
1912: --
1913: -- Initialize message list.
1914: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1915: fnd_msg_pub.initialize;
1916: END IF;
1917:
1918: l_in_trolin_tbl(1).operation := inv_globals.g_opr_create;

Line 1953: p_init_msg_list => FND_API.G_FALSE,

1949: -- bug 5671641 end
1950:
1951: inv_move_order_pub.create_move_order_lines
1952: (p_api_version_number => 1.0,
1953: p_init_msg_list => FND_API.G_FALSE,
1954: p_return_values => FND_API.G_FALSE,
1955: p_commit => FND_API.G_FALSE,
1956: x_return_status => l_return_status,
1957: x_msg_count => x_msg_count,

Line 1954: p_return_values => FND_API.G_FALSE,

1950:
1951: inv_move_order_pub.create_move_order_lines
1952: (p_api_version_number => 1.0,
1953: p_init_msg_list => FND_API.G_FALSE,
1954: p_return_values => FND_API.G_FALSE,
1955: p_commit => FND_API.G_FALSE,
1956: x_return_status => l_return_status,
1957: x_msg_count => x_msg_count,
1958: x_msg_data => x_msg_data,

Line 1955: p_commit => FND_API.G_FALSE,

1951: inv_move_order_pub.create_move_order_lines
1952: (p_api_version_number => 1.0,
1953: p_init_msg_list => FND_API.G_FALSE,
1954: p_return_values => FND_API.G_FALSE,
1955: p_commit => FND_API.G_FALSE,
1956: x_return_status => l_return_status,
1957: x_msg_count => x_msg_count,
1958: x_msg_data => x_msg_data,
1959: p_trolin_tbl => l_in_trolin_tbl,

Line 1965: IF l_return_status = fnd_api.g_ret_sts_error THEN

1961: x_trolin_tbl => l_out_trolin_tbl,
1962: x_trolin_val_tbl => l_out_trolin_val_tbl,
1963: p_validation_flag => inv_move_order_pub.g_validation_yes);
1964:
1965: IF l_return_status = fnd_api.g_ret_sts_error THEN
1966: RAISE fnd_api.g_exc_error;
1967: END IF ;
1968:
1969: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1966: RAISE fnd_api.g_exc_error;

1962: x_trolin_val_tbl => l_out_trolin_val_tbl,
1963: p_validation_flag => inv_move_order_pub.g_validation_yes);
1964:
1965: IF l_return_status = fnd_api.g_ret_sts_error THEN
1966: RAISE fnd_api.g_exc_error;
1967: END IF ;
1968:
1969: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1970: RAISE fnd_api.g_exc_unexpected_error;

Line 1969: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1965: IF l_return_status = fnd_api.g_ret_sts_error THEN
1966: RAISE fnd_api.g_exc_error;
1967: END IF ;
1968:
1969: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1970: RAISE fnd_api.g_exc_unexpected_error;
1971: END IF;
1972:
1973: x_line_id := l_out_trolin_tbl(1).line_id;

Line 1970: RAISE fnd_api.g_exc_unexpected_error;

1966: RAISE fnd_api.g_exc_error;
1967: END IF ;
1968:
1969: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1970: RAISE fnd_api.g_exc_unexpected_error;
1971: END IF;
1972:
1973: x_line_id := l_out_trolin_tbl(1).line_id;
1974:

Line 1977: WHEN fnd_api.g_exc_error THEN

1973: x_line_id := l_out_trolin_tbl(1).line_id;
1974:
1975: EXCEPTION
1976:
1977: WHEN fnd_api.g_exc_error THEN
1978: x_return_status := fnd_api.g_ret_sts_error;
1979:
1980: -- Get message count and data
1981: fnd_msg_pub.count_and_get

Line 1978: x_return_status := fnd_api.g_ret_sts_error;

1974:
1975: EXCEPTION
1976:
1977: WHEN fnd_api.g_exc_error THEN
1978: x_return_status := fnd_api.g_ret_sts_error;
1979:
1980: -- Get message count and data
1981: fnd_msg_pub.count_and_get
1982: ( p_count => x_msg_count

Line 1987: WHEN fnd_api.g_exc_unexpected_error THEN

1983: , p_data => x_msg_data
1984: , p_encoded => 'F'
1985: );
1986:
1987: WHEN fnd_api.g_exc_unexpected_error THEN
1988: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1989:
1990: -- Get message count and data
1991: fnd_msg_pub.count_and_get

Line 1988: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1984: , p_encoded => 'F'
1985: );
1986:
1987: WHEN fnd_api.g_exc_unexpected_error THEN
1988: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1989:
1990: -- Get message count and data
1991: fnd_msg_pub.count_and_get
1992: ( p_count => x_msg_count

Line 1998: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1994: , p_encoded => 'F'
1995: );
1996:
1997: WHEN OTHERS THEN
1998: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1999:
2000: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2001: THEN
2002: fnd_msg_pub.add_exc_msg

Line 2019: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

2015:
2016: PROCEDURE delete_move_order
2017: (
2018: p_api_version_number IN NUMBER
2019: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
2020: , p_move_order_header_id IN NUMBER
2021: , x_return_status OUT NOCOPY VARCHAR2
2022: , x_msg_count OUT NOCOPY NUMBER
2023: , x_msg_data OUT NOCOPY VARCHAR2

Line 2038: x_return_status := fnd_api.g_ret_sts_success;

2034: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
2035:
2036: BEGIN
2037: -- Initialize return status
2038: x_return_status := fnd_api.g_ret_sts_success;
2039:
2040: -- Standard call to check for call compatibility
2041: IF NOT fnd_api.compatible_api_call(l_api_version_number
2042: , p_api_version_number

Line 2041: IF NOT fnd_api.compatible_api_call(l_api_version_number

2037: -- Initialize return status
2038: x_return_status := fnd_api.g_ret_sts_success;
2039:
2040: -- Standard call to check for call compatibility
2041: IF NOT fnd_api.compatible_api_call(l_api_version_number
2042: , p_api_version_number
2043: , l_api_name
2044: , G_PKG_NAME
2045: ) THEN

Line 2046: RAISE fnd_api.g_exc_unexpected_error;

2042: , p_api_version_number
2043: , l_api_name
2044: , G_PKG_NAME
2045: ) THEN
2046: RAISE fnd_api.g_exc_unexpected_error;
2047: END IF;
2048: --
2049: -- Initialize message list.
2050: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 2050: IF fnd_api.to_boolean(p_init_msg_lst) THEN

2046: RAISE fnd_api.g_exc_unexpected_error;
2047: END IF;
2048: --
2049: -- Initialize message list.
2050: IF fnd_api.to_boolean(p_init_msg_lst) THEN
2051: fnd_msg_pub.initialize;
2052: END IF;
2053:
2054: l_in_trohdr_rec.operation := inv_globals.g_opr_delete;

Line 2058: p_init_msg_list => FND_API.G_TRUE,

2054: l_in_trohdr_rec.operation := inv_globals.g_opr_delete;
2055: l_in_trohdr_rec.header_id := p_move_order_header_id;
2056: inv_move_order_pub.process_move_order
2057: (p_api_version_number => 1.0,
2058: p_init_msg_list => FND_API.G_TRUE,
2059: p_return_values => FND_API.G_FALSE,
2060: p_commit => FND_API.G_FALSE,
2061: x_return_status => l_return_status,
2062: x_msg_count => x_msg_count,

Line 2059: p_return_values => FND_API.G_FALSE,

2055: l_in_trohdr_rec.header_id := p_move_order_header_id;
2056: inv_move_order_pub.process_move_order
2057: (p_api_version_number => 1.0,
2058: p_init_msg_list => FND_API.G_TRUE,
2059: p_return_values => FND_API.G_FALSE,
2060: p_commit => FND_API.G_FALSE,
2061: x_return_status => l_return_status,
2062: x_msg_count => x_msg_count,
2063: x_msg_data => x_msg_data,

Line 2060: p_commit => FND_API.G_FALSE,

2056: inv_move_order_pub.process_move_order
2057: (p_api_version_number => 1.0,
2058: p_init_msg_list => FND_API.G_TRUE,
2059: p_return_values => FND_API.G_FALSE,
2060: p_commit => FND_API.G_FALSE,
2061: x_return_status => l_return_status,
2062: x_msg_count => x_msg_count,
2063: x_msg_data => x_msg_data,
2064: p_trohdr_rec => l_in_trohdr_rec,

Line 2070: IF l_return_status = fnd_api.g_ret_sts_error THEN

2066: x_trohdr_val_rec => l_trohdr_val_rec,
2067: x_trolin_tbl => l_trolin_tbl,
2068: x_trolin_val_tbl => l_trolin_val_tbl);
2069:
2070: IF l_return_status = fnd_api.g_ret_sts_error THEN
2071: RAISE fnd_api.g_exc_error;
2072: END IF ;
2073:
2074: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2071: RAISE fnd_api.g_exc_error;

2067: x_trolin_tbl => l_trolin_tbl,
2068: x_trolin_val_tbl => l_trolin_val_tbl);
2069:
2070: IF l_return_status = fnd_api.g_ret_sts_error THEN
2071: RAISE fnd_api.g_exc_error;
2072: END IF ;
2073:
2074: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2075: RAISE fnd_api.g_exc_unexpected_error;

Line 2074: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2070: IF l_return_status = fnd_api.g_ret_sts_error THEN
2071: RAISE fnd_api.g_exc_error;
2072: END IF ;
2073:
2074: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2075: RAISE fnd_api.g_exc_unexpected_error;
2076: END IF;
2077:
2078:

Line 2075: RAISE fnd_api.g_exc_unexpected_error;

2071: RAISE fnd_api.g_exc_error;
2072: END IF ;
2073:
2074: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2075: RAISE fnd_api.g_exc_unexpected_error;
2076: END IF;
2077:
2078:
2079: EXCEPTION

Line 2081: WHEN fnd_api.g_exc_error THEN

2077:
2078:
2079: EXCEPTION
2080:
2081: WHEN fnd_api.g_exc_error THEN
2082: x_return_status := fnd_api.g_ret_sts_error;
2083:
2084: -- Get message count and data
2085: fnd_msg_pub.count_and_get

Line 2082: x_return_status := fnd_api.g_ret_sts_error;

2078:
2079: EXCEPTION
2080:
2081: WHEN fnd_api.g_exc_error THEN
2082: x_return_status := fnd_api.g_ret_sts_error;
2083:
2084: -- Get message count and data
2085: fnd_msg_pub.count_and_get
2086: ( p_count => x_msg_count

Line 2091: WHEN fnd_api.g_exc_unexpected_error THEN

2087: , p_data => x_msg_data
2088: , p_encoded => 'F'
2089: );
2090:
2091: WHEN fnd_api.g_exc_unexpected_error THEN
2092: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2093:
2094: -- Get message count and data
2095: fnd_msg_pub.count_and_get

Line 2092: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2088: , p_encoded => 'F'
2089: );
2090:
2091: WHEN fnd_api.g_exc_unexpected_error THEN
2092: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2093:
2094: -- Get message count and data
2095: fnd_msg_pub.count_and_get
2096: ( p_count => x_msg_count

Line 2102: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2098: , p_encoded => 'F'
2099: );
2100:
2101: WHEN OTHERS THEN
2102: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2103:
2104: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2105: THEN
2106: fnd_msg_pub.add_exc_msg