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_RESERVATIONS_INTERFACE dependencies on FND_API

Line 61: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

57: PROCEDURE rsv_interface_manager(
58: x_errbuf OUT NOCOPY VARCHAR2
59: , x_retcode OUT NOCOPY NUMBER
60: , p_api_version_number IN NUMBER DEFAULT 1.0
61: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
62: , p_form_mode IN VARCHAR2 DEFAULT 'N') as
63:
64: -- Constants
65: c_max_numof_lines constant number := 3;

Line 112: if not fnd_api.compatible_api_call(

108:
109: /*
110: ** Standard call to check for call compatibility
111: */
112: if not fnd_api.compatible_api_call(
113: c_api_version_number
114: , p_api_version_number
115: , c_api_name
116: , g_pkg_name) then

Line 117: raise fnd_api.g_exc_unexpected_error;

113: c_api_version_number
114: , p_api_version_number
115: , c_api_name
116: , g_pkg_name) then
117: raise fnd_api.g_exc_unexpected_error;
118: end if;
119:
120: /*
121: ** Initialize message list

Line 123: if fnd_api.to_boolean(p_init_msg_lst) then

119:
120: /*
121: ** Initialize message list
122: */
123: if fnd_api.to_boolean(p_init_msg_lst) then
124: fnd_msg_pub.initialize;
125: end if;
126:
127: /*

Line 130: l_return_status := fnd_api.g_ret_sts_success;

126:
127: /*
128: ** Initialize return status to success
129: */
130: l_return_status := fnd_api.g_ret_sts_success;
131:
132: if (p_form_mode in ('N','n')) then
133: fnd_message.set_name('INV', 'INV_RSV_MANAGER');
134: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 190: , p_init_msg_lst => fnd_api.g_false

186: -- , 'Y' /* Commit */
187: -- )
188: rsv_interface_batch_processor(
189: p_api_version_number => 1.0
190: , p_init_msg_lst => fnd_api.g_false
191: , p_reservation_batches => l_batch_arg
192: , p_process_mode => 3 /* Background */
193: , p_partial_batch_process_flag => 2 /* No Partial Processing */
194: , p_commit_flag => 'Y'/* Commit */

Line 236: , p_init_msg_lst => fnd_api.g_false

232: -- )
233:
234: rsv_interface_batch_processor(
235: p_api_version_number => 1.0
236: , p_init_msg_lst => fnd_api.g_false
237: , p_reservation_batches => l_batch_array_arg
238: , p_process_mode => 3 /* Background */
239: , p_partial_batch_process_flag => 2 /* No Partial Processing */
240: , p_commit_flag => 'Y'/* Commit */

Line 301: , p_init_msg_lst => fnd_api.g_false

297: -- )
298:
299: rsv_interface_batch_processor(
300: p_api_version_number => 1.0
301: , p_init_msg_lst => fnd_api.g_false
302: , p_reservation_batches => l_batch_array_arg
303: , p_process_mode => 3 /* Background */
304: , p_partial_batch_process_flag => 2 /* No Partial Processing */
305: , p_commit_flag => 'Y'/* Commit */

Line 315: when fnd_api.g_exc_error then

311:
312: l_conc_status := fnd_concurrent.set_completion_status('NORMAL','NORMAL');
313:
314: exception
315: when fnd_api.g_exc_error then
316: l_return_status := fnd_api.g_ret_sts_error;
317:
318: fnd_msg_pub.count_and_get(
319: p_count => l_msg_count

Line 316: l_return_status := fnd_api.g_ret_sts_error;

312: l_conc_status := fnd_concurrent.set_completion_status('NORMAL','NORMAL');
313:
314: exception
315: when fnd_api.g_exc_error then
316: l_return_status := fnd_api.g_ret_sts_error;
317:
318: fnd_msg_pub.count_and_get(
319: p_count => l_msg_count
320: , p_data => l_msg_data

Line 329: when fnd_api.g_exc_unexpected_error then

325: end if;
326:
327: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
328:
329: when fnd_api.g_exc_unexpected_error then
330: l_return_status := fnd_api.g_ret_sts_unexp_error;
331:
332: fnd_msg_pub.count_and_get(
333: p_count => l_msg_count

Line 330: l_return_status := fnd_api.g_ret_sts_unexp_error;

326:
327: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
328:
329: when fnd_api.g_exc_unexpected_error then
330: l_return_status := fnd_api.g_ret_sts_unexp_error;
331:
332: fnd_msg_pub.count_and_get(
333: p_count => l_msg_count
334: , p_data => l_msg_data

Line 344: l_return_status := fnd_api.g_ret_sts_unexp_error;

340:
341: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
342:
343: when others then
344: l_return_status := fnd_api.g_ret_sts_unexp_error;
345:
346: if (fnd_msg_pub.check_msg_level
347: (fnd_msg_pub.g_msg_lvl_unexp_error))then
348: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);

Line 428: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

424: */
425:
426: PROCEDURE rsv_interface_batch_processor (
427: p_api_version_number IN NUMBER
428: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
429: , p_reservation_batches IN VARCHAR2
430: , p_process_mode IN NUMBER DEFAULT 1
431: , p_partial_batch_process_flag IN NUMBER DEFAULT 1
432: , p_commit_flag IN VARCHAR2 DEFAULT 'Y'

Line 472: if not fnd_api.compatible_api_call(

468: begin
469: /*
470: ** Standard call to check for call compatibility
471: */
472: if not fnd_api.compatible_api_call(
473: c_api_version_number
474: , p_api_version_number
475: , c_api_name
476: , g_pkg_name) then

Line 477: raise fnd_api.g_exc_unexpected_error;

473: c_api_version_number
474: , p_api_version_number
475: , c_api_name
476: , g_pkg_name) then
477: raise fnd_api.g_exc_unexpected_error;
478: end if;
479:
480: /*
481: ** Initialize message list

Line 483: if fnd_api.to_boolean(p_init_msg_lst) then

479:
480: /*
481: ** Initialize message list
482: */
483: if fnd_api.to_boolean(p_init_msg_lst) then
484: fnd_msg_pub.initialize;
485: end if;
486:
487: /*

Line 490: x_return_status := fnd_api.g_ret_sts_success;

486:
487: /*
488: ** Initialize return status to success
489: */
490: x_return_status := fnd_api.g_ret_sts_success;
491:
492: l_reservation_batches := rtrim(ltrim(p_reservation_batches));
493:
494: while (0=0) loop

Line 534: l_return_status := fnd_api.g_ret_sts_success;

530: for mric_row in mric(l_batch_id, p_process_mode) loop
531:
532: -- Initialize
533: l_interface_id := mric_row.reservation_interface_id;
534: l_return_status := fnd_api.g_ret_sts_success;
535: l_error_code := null;
536: l_error_text := null;
537:
538: if (p_form_mode in ('N','n')) then

Line 559: , p_init_msg_lst => fnd_api.g_false

555:
556: -- Call rsv_interface_line_processor
557: rsv_interface_line_processor (
558: p_api_version_number => 1.0
559: , p_init_msg_lst => fnd_api.g_false
560: , p_reservation_interface_id => l_interface_id
561: , p_form_mode => p_form_mode
562: , x_error_code => l_error_code
563: , x_error_text => l_error_text

Line 576: if ((l_return_status <> fnd_api.g_ret_sts_success or

572: ** for a value of 1, processing should continue for others when one
573: ** fails.
574: */
575:
576: if ((l_return_status <> fnd_api.g_ret_sts_success or
577: l_error_text is not null or
578: l_error_code is not null) and
579: (p_partial_batch_process_flag = 2))then
580:

Line 597: if ((l_return_status <> fnd_api.g_ret_sts_success or

593:
594: exit;
595: end if;
596:
597: if ((l_return_status <> fnd_api.g_ret_sts_success or
598: l_error_text is not null or
599: l_error_code is not null) and
600: (p_partial_batch_process_flag = 1))then
601:

Line 635: when fnd_api.g_exc_error then

631:
632: -- l_conc_status := fnd_concurrent.set_completion_status('NORMAL','NORMAL');
633:
634: exception
635: when fnd_api.g_exc_error then
636: x_return_status := fnd_api.g_ret_sts_error;
637:
638: fnd_msg_pub.count_and_get(
639: p_count => x_msg_count

Line 636: x_return_status := fnd_api.g_ret_sts_error;

632: -- l_conc_status := fnd_concurrent.set_completion_status('NORMAL','NORMAL');
633:
634: exception
635: when fnd_api.g_exc_error then
636: x_return_status := fnd_api.g_ret_sts_error;
637:
638: fnd_msg_pub.count_and_get(
639: p_count => x_msg_count
640: , p_data => x_msg_data

Line 649: when fnd_api.g_exc_unexpected_error then

645: end if;
646:
647: --l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
648:
649: when fnd_api.g_exc_unexpected_error then
650: x_return_status := fnd_api.g_ret_sts_unexp_error;
651:
652: fnd_msg_pub.count_and_get(
653: p_count => x_msg_count

Line 650: x_return_status := fnd_api.g_ret_sts_unexp_error;

646:
647: --l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
648:
649: when fnd_api.g_exc_unexpected_error then
650: x_return_status := fnd_api.g_ret_sts_unexp_error;
651:
652: fnd_msg_pub.count_and_get(
653: p_count => x_msg_count
654: , p_data => x_msg_data

Line 664: x_return_status := fnd_api.g_ret_sts_unexp_error;

660:
661: --l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
662:
663: when others then
664: x_return_status := fnd_api.g_ret_sts_unexp_error;
665:
666: if (fnd_msg_pub.check_msg_level
667: (fnd_msg_pub.g_msg_lvl_unexp_error))then
668: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);

Line 735: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

731: */
732:
733: PROCEDURE rsv_interface_line_processor (
734: p_api_version_number IN NUMBER
735: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
736: , p_reservation_interface_id IN NUMBER
737: , p_form_mode IN VARCHAR2 DEFAULT 'N'
738: , x_error_code OUT NOCOPY NUMBER
739: , x_error_text OUT NOCOPY VARCHAR2

Line 853: if not fnd_api.compatible_api_call(

849: begin
850: /*
851: ** Standard call to check for call compatibility
852: */
853: if not fnd_api.compatible_api_call(
854: c_api_version_number
855: , p_api_version_number
856: , c_api_name
857: , g_pkg_name) then

Line 858: raise fnd_api.g_exc_unexpected_error;

854: c_api_version_number
855: , p_api_version_number
856: , c_api_name
857: , g_pkg_name) then
858: raise fnd_api.g_exc_unexpected_error;
859: end if;
860:
861: /*
862: ** Initialize message list

Line 864: if fnd_api.to_boolean(p_init_msg_lst) then

860:
861: /*
862: ** Initialize message list
863: */
864: if fnd_api.to_boolean(p_init_msg_lst) then
865: fnd_msg_pub.initialize;
866: end if;
867:
868: /*

Line 871: x_return_status := fnd_api.g_ret_sts_success;

867:
868: /*
869: ** Initialize return status to success
870: */
871: x_return_status := fnd_api.g_ret_sts_success;
872: x_error_code := NULL;
873: x_error_text := NULL;
874:
875: /*

Line 1136: raise fnd_api.g_exc_error;

1132:
1133: If (l_oe_line_subinventory is not null) and (l_oe_line_subinventory <> l_rsv_rec.subinventory_code) then
1134: fnd_message.set_name('INV','INV_INVALID_SUBINVENTORY');
1135: fnd_msg_pub.add;
1136: raise fnd_api.g_exc_error;
1137: End if;
1138: End if;
1139: End if;
1140:

Line 1151: RAISE fnd_api.g_exc_error;

1147: IF l_rsv_rec.primary_reservation_quantity <= 0 OR l_rsv_rec.reservation_quantity <= 0 THEN
1148: debug('Primary Reservation Quantity or Reservation Quantity should not be equal to lessa than zero',c_api_name,1);
1149: fnd_message.set_name('INV', 'INV_GREATER_THAN_ZERO');
1150: fnd_msg_pub.ADD;
1151: RAISE fnd_api.g_exc_error;
1152: END IF;
1153:
1154: IF ( inv_cache.set_item_rec(l_rsv_rec.organization_id, l_rsv_rec.inventory_item_id) ) THEN
1155: l_rsv_rec.primary_uom_code := inv_cache.item_rec.primary_uom_code;

Line 1178: RAISE fnd_api.g_exc_error;

1174: -- conversion failed
1175: debug('Cannot Convert to Primary UOM',c_api_name,1);
1176: fnd_message.set_name('INV', 'CAN-NOT-CONVERT-TO-PRIMARY-UOM');
1177: fnd_msg_pub.ADD;
1178: RAISE fnd_api.g_exc_error;
1179: END IF;
1180: END IF;
1181: END IF;
1182:

Line 1199: l_partial_reservation_flag := fnd_api.g_true;

1195: ** we have to do this.
1196: ** l_partial_quantities 1=Yes; Not(1)=No;
1197: */
1198: if (l_partial_quantities_allowed = 1) then
1199: l_partial_reservation_flag := fnd_api.g_true;
1200: else
1201: l_partial_reservation_flag := fnd_api.g_false;
1202: end if;
1203:

Line 1201: l_partial_reservation_flag := fnd_api.g_false;

1197: */
1198: if (l_partial_quantities_allowed = 1) then
1199: l_partial_reservation_flag := fnd_api.g_true;
1200: else
1201: l_partial_reservation_flag := fnd_api.g_false;
1202: end if;
1203:
1204: /*
1205: ** Initialize parameter return status

Line 1207: l_return_status := fnd_api.g_ret_sts_success;

1203:
1204: /*
1205: ** Initialize parameter return status
1206: */
1207: l_return_status := fnd_api.g_ret_sts_success;
1208:
1209: /*
1210: ** For not(insert) requests quantity should be a value of don't care
1211: ** for a successful retrieval of source record.

Line 1214: l_rsv_rec.reservation_quantity := fnd_api.g_miss_num;

1210: ** For not(insert) requests quantity should be a value of don't care
1211: ** for a successful retrieval of source record.
1212: */
1213: if (l_reservation_action_code in (2,3,4)) then
1214: l_rsv_rec.reservation_quantity := fnd_api.g_miss_num;
1215: l_rsv_rec.primary_reservation_quantity := fnd_api.g_miss_num;
1216: l_rsv_rec.secondary_reservation_quantity:= fnd_api.g_miss_num; -- INVCONV
1217: end if;
1218:

Line 1215: l_rsv_rec.primary_reservation_quantity := fnd_api.g_miss_num;

1211: ** for a successful retrieval of source record.
1212: */
1213: if (l_reservation_action_code in (2,3,4)) then
1214: l_rsv_rec.reservation_quantity := fnd_api.g_miss_num;
1215: l_rsv_rec.primary_reservation_quantity := fnd_api.g_miss_num;
1216: l_rsv_rec.secondary_reservation_quantity:= fnd_api.g_miss_num; -- INVCONV
1217: end if;
1218:
1219: /*

Line 1216: l_rsv_rec.secondary_reservation_quantity:= fnd_api.g_miss_num; -- INVCONV

1212: */
1213: if (l_reservation_action_code in (2,3,4)) then
1214: l_rsv_rec.reservation_quantity := fnd_api.g_miss_num;
1215: l_rsv_rec.primary_reservation_quantity := fnd_api.g_miss_num;
1216: l_rsv_rec.secondary_reservation_quantity:= fnd_api.g_miss_num; -- INVCONV
1217: end if;
1218:
1219: /*
1220: ** Call appropriate API based on action code

Line 1232: , p_init_msg_lst => fnd_api.g_false

1228: -- Create reservation
1229:
1230: inv_reservation_pub.create_reservation(
1231: p_api_version_number => 1.0
1232: , p_init_msg_lst => fnd_api.g_false
1233: , x_return_status => l_return_status
1234: , x_msg_count => x_msg_count
1235: , x_msg_data => x_msg_data
1236: , p_rsv_rec => l_rsv_rec

Line 1240: , p_force_reservation_flag => fnd_api.g_false

1236: , p_rsv_rec => l_rsv_rec
1237: , p_serial_number => l_serial_number
1238: , x_serial_number => l_serial_number
1239: , p_partial_reservation_flag => l_partial_reservation_flag
1240: , p_force_reservation_flag => fnd_api.g_false
1241: , p_validation_flag => fnd_api.g_true
1242: , x_quantity_reserved => l_quantity_reserved
1243: , x_secondary_quantity_reserved => l_secondary_quantity_reserved --INVCONV
1244: , x_reservation_id => l_reservation_id);

Line 1241: , p_validation_flag => fnd_api.g_true

1237: , p_serial_number => l_serial_number
1238: , x_serial_number => l_serial_number
1239: , p_partial_reservation_flag => l_partial_reservation_flag
1240: , p_force_reservation_flag => fnd_api.g_false
1241: , p_validation_flag => fnd_api.g_true
1242: , x_quantity_reserved => l_quantity_reserved
1243: , x_secondary_quantity_reserved => l_secondary_quantity_reserved --INVCONV
1244: , x_reservation_id => l_reservation_id);
1245:

Line 1246: if (l_return_status = fnd_api.g_ret_sts_success) then

1242: , x_quantity_reserved => l_quantity_reserved
1243: , x_secondary_quantity_reserved => l_secondary_quantity_reserved --INVCONV
1244: , x_reservation_id => l_reservation_id);
1245:
1246: if (l_return_status = fnd_api.g_ret_sts_success) then
1247: x_return_status := l_return_status;
1248:
1249: if (p_form_mode in ('N','n')) then
1250: -- kgm_msg

Line 1279: elsif (l_return_status = fnd_api.g_ret_sts_error) then

1275: fnd_file.put_line(fnd_file.log,' ');
1276: */
1277: end if;
1278:
1279: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1280: raise fnd_api.g_exc_error;
1281: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1282: raise fnd_api.g_exc_unexpected_error;
1283: end if;

Line 1280: raise fnd_api.g_exc_error;

1276: */
1277: end if;
1278:
1279: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1280: raise fnd_api.g_exc_error;
1281: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1282: raise fnd_api.g_exc_unexpected_error;
1283: end if;
1284:

Line 1281: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then

1277: end if;
1278:
1279: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1280: raise fnd_api.g_exc_error;
1281: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1282: raise fnd_api.g_exc_unexpected_error;
1283: end if;
1284:
1285: elsif (l_reservation_action_code = 2) then

Line 1282: raise fnd_api.g_exc_unexpected_error;

1278:
1279: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1280: raise fnd_api.g_exc_error;
1281: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1282: raise fnd_api.g_exc_unexpected_error;
1283: end if;
1284:
1285: elsif (l_reservation_action_code = 2) then
1286: -- Update reservation

Line 1291: , p_init_msg_lst => fnd_api.g_false

1287: -- Adeed the extra parameter for call to update_reservations
1288: -- Bug Number 3392957
1289: inv_reservation_pub.update_reservation(
1290: p_api_version_number => 1.0
1291: , p_init_msg_lst => fnd_api.g_false
1292: , x_return_status => l_return_status
1293: , x_msg_count => x_msg_count
1294: , x_msg_data => x_msg_data
1295: , p_original_rsv_rec => l_rsv_rec

Line 1299: , p_validation_flag => fnd_api.g_true

1295: , p_original_rsv_rec => l_rsv_rec
1296: , p_to_rsv_rec => l_to_rsv_rec
1297: , p_original_serial_number => l_serial_number
1298: , p_to_serial_number => l_serial_number
1299: , p_validation_flag => fnd_api.g_true
1300: , p_check_availability => fnd_api.g_true
1301: );
1302:
1303: if (l_return_status = fnd_api.g_ret_sts_success) then

Line 1300: , p_check_availability => fnd_api.g_true

1296: , p_to_rsv_rec => l_to_rsv_rec
1297: , p_original_serial_number => l_serial_number
1298: , p_to_serial_number => l_serial_number
1299: , p_validation_flag => fnd_api.g_true
1300: , p_check_availability => fnd_api.g_true
1301: );
1302:
1303: if (l_return_status = fnd_api.g_ret_sts_success) then
1304: x_return_status := l_return_status;

Line 1303: if (l_return_status = fnd_api.g_ret_sts_success) then

1299: , p_validation_flag => fnd_api.g_true
1300: , p_check_availability => fnd_api.g_true
1301: );
1302:
1303: if (l_return_status = fnd_api.g_ret_sts_success) then
1304: x_return_status := l_return_status;
1305:
1306: if (p_form_mode in ('N','n')) then
1307: -- kgm_msg

Line 1324: elsif (l_return_status = fnd_api.g_ret_sts_error) then

1320: fnd_file.put_line(fnd_file.log,' ');
1321: */
1322: end if;
1323:
1324: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1325: raise fnd_api.g_exc_error;
1326: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1327: raise fnd_api.g_exc_unexpected_error;
1328: end if;

Line 1325: raise fnd_api.g_exc_error;

1321: */
1322: end if;
1323:
1324: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1325: raise fnd_api.g_exc_error;
1326: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1327: raise fnd_api.g_exc_unexpected_error;
1328: end if;
1329:

Line 1326: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then

1322: end if;
1323:
1324: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1325: raise fnd_api.g_exc_error;
1326: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1327: raise fnd_api.g_exc_unexpected_error;
1328: end if;
1329:
1330: elsif (l_reservation_action_code = 3) then

Line 1327: raise fnd_api.g_exc_unexpected_error;

1323:
1324: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1325: raise fnd_api.g_exc_error;
1326: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1327: raise fnd_api.g_exc_unexpected_error;
1328: end if;
1329:
1330: elsif (l_reservation_action_code = 3) then
1331: -- Delete reservation

Line 1332: l_rsv_rec.reservation_id := fnd_api.g_miss_num;

1328: end if;
1329:
1330: elsif (l_reservation_action_code = 3) then
1331: -- Delete reservation
1332: l_rsv_rec.reservation_id := fnd_api.g_miss_num;
1333:
1334: inv_reservation_pub.delete_reservation(
1335: p_api_version_number => 1.0
1336: , p_init_msg_lst => fnd_api.g_false

Line 1336: , p_init_msg_lst => fnd_api.g_false

1332: l_rsv_rec.reservation_id := fnd_api.g_miss_num;
1333:
1334: inv_reservation_pub.delete_reservation(
1335: p_api_version_number => 1.0
1336: , p_init_msg_lst => fnd_api.g_false
1337: , x_return_status => l_return_status
1338: , x_msg_count => x_msg_count
1339: , x_msg_data => x_msg_data
1340: , p_rsv_rec => l_rsv_rec

Line 1343: if (l_return_status = fnd_api.g_ret_sts_success) then

1339: , x_msg_data => x_msg_data
1340: , p_rsv_rec => l_rsv_rec
1341: , p_serial_number => l_serial_number);
1342:
1343: if (l_return_status = fnd_api.g_ret_sts_success) then
1344: x_return_status := l_return_status;
1345:
1346: if (p_form_mode in ('N','n')) then
1347: -- kgm_msg

Line 1364: elsif (l_return_status = fnd_api.g_ret_sts_error) then

1360: fnd_file.put_line(fnd_file.log,' ');
1361: */
1362: end if;
1363:
1364: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1365: raise fnd_api.g_exc_error;
1366: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1367: raise fnd_api.g_exc_unexpected_error;
1368: end if;

Line 1365: raise fnd_api.g_exc_error;

1361: */
1362: end if;
1363:
1364: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1365: raise fnd_api.g_exc_error;
1366: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1367: raise fnd_api.g_exc_unexpected_error;
1368: end if;
1369:

Line 1366: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then

1362: end if;
1363:
1364: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1365: raise fnd_api.g_exc_error;
1366: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1367: raise fnd_api.g_exc_unexpected_error;
1368: end if;
1369:
1370: elsif (l_reservation_action_code = 4) then

Line 1367: raise fnd_api.g_exc_unexpected_error;

1363:
1364: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1365: raise fnd_api.g_exc_error;
1366: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1367: raise fnd_api.g_exc_unexpected_error;
1368: end if;
1369:
1370: elsif (l_reservation_action_code = 4) then
1371: -- Transfer reservation

Line 1373: l_rsv_rec.reservation_id := fnd_api.g_miss_num;

1369:
1370: elsif (l_reservation_action_code = 4) then
1371: -- Transfer reservation
1372:
1373: l_rsv_rec.reservation_id := fnd_api.g_miss_num;
1374:
1375: inv_reservation_pub.transfer_reservation(
1376: p_api_version_number => 1.0
1377: , p_init_msg_lst => fnd_api.g_false

Line 1377: , p_init_msg_lst => fnd_api.g_false

1373: l_rsv_rec.reservation_id := fnd_api.g_miss_num;
1374:
1375: inv_reservation_pub.transfer_reservation(
1376: p_api_version_number => 1.0
1377: , p_init_msg_lst => fnd_api.g_false
1378: , x_return_status => l_return_status
1379: , x_msg_count => x_msg_count
1380: , x_msg_data => x_msg_data
1381: , p_is_transfer_supply => fnd_api.g_true

Line 1381: , p_is_transfer_supply => fnd_api.g_true

1377: , p_init_msg_lst => fnd_api.g_false
1378: , x_return_status => l_return_status
1379: , x_msg_count => x_msg_count
1380: , x_msg_data => x_msg_data
1381: , p_is_transfer_supply => fnd_api.g_true
1382: , p_original_rsv_rec => l_rsv_rec
1383: , p_to_rsv_rec => l_to_rsv_rec
1384: , p_original_serial_number => l_serial_number
1385: , p_to_serial_number => l_serial_number

Line 1386: , p_validation_flag => fnd_api.g_true

1382: , p_original_rsv_rec => l_rsv_rec
1383: , p_to_rsv_rec => l_to_rsv_rec
1384: , p_original_serial_number => l_serial_number
1385: , p_to_serial_number => l_serial_number
1386: , p_validation_flag => fnd_api.g_true
1387: , x_to_reservation_id => l_reservation_id);
1388:
1389: if (l_return_status = fnd_api.g_ret_sts_success) then
1390: x_return_status := l_return_status;

Line 1389: if (l_return_status = fnd_api.g_ret_sts_success) then

1385: , p_to_serial_number => l_serial_number
1386: , p_validation_flag => fnd_api.g_true
1387: , x_to_reservation_id => l_reservation_id);
1388:
1389: if (l_return_status = fnd_api.g_ret_sts_success) then
1390: x_return_status := l_return_status;
1391:
1392: if (p_form_mode in ('N','n')) then
1393: -- kgm_msg

Line 1410: elsif (l_return_status = fnd_api.g_ret_sts_error) then

1406: fnd_file.put_line(fnd_file.log,' ');
1407: */
1408: end if;
1409:
1410: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1411: raise fnd_api.g_exc_error;
1412: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1413: raise fnd_api.g_exc_unexpected_error;
1414: end if;

Line 1411: raise fnd_api.g_exc_error;

1407: */
1408: end if;
1409:
1410: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1411: raise fnd_api.g_exc_error;
1412: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1413: raise fnd_api.g_exc_unexpected_error;
1414: end if;
1415:

Line 1412: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then

1408: end if;
1409:
1410: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1411: raise fnd_api.g_exc_error;
1412: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1413: raise fnd_api.g_exc_unexpected_error;
1414: end if;
1415:
1416: else

Line 1413: raise fnd_api.g_exc_unexpected_error;

1409:
1410: elsif (l_return_status = fnd_api.g_ret_sts_error) then
1411: raise fnd_api.g_exc_error;
1412: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1413: raise fnd_api.g_exc_unexpected_error;
1414: end if;
1415:
1416: else
1417: -- Invalid or unsuitable action code here

Line 1423: if (l_return_status = fnd_api.g_ret_sts_success) then

1419: raise INVALID_ACTION_CODE;
1420:
1421: end if;
1422:
1423: if (l_return_status = fnd_api.g_ret_sts_success) then
1424: update mtl_reservations_interface
1425: set row_status_code = 2 /* Completed */
1426: where reservation_interface_id = p_reservation_interface_id;
1427: end if;

Line 1431: x_return_status := fnd_api.g_ret_sts_error;

1427: end if;
1428:
1429: exception
1430: when NO_DATA_FOUND then
1431: x_return_status := fnd_api.g_ret_sts_error;
1432:
1433: -- kgm_msg
1434: if (p_form_mode in ('N','n')) then
1435: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');

Line 1459: x_return_status := fnd_api.g_ret_sts_error;

1455: print_error(x_msg_count);
1456: end if;
1457:
1458: when INVALID_ACTION_CODE then
1459: x_return_status := fnd_api.g_ret_sts_error;
1460:
1461: if (p_form_mode in ('N','n')) then
1462: -- kgm_msg
1463: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');

Line 1486: when fnd_api.g_exc_error then

1482: if (p_form_mode in ('N','n')) then
1483: print_error(x_msg_count);
1484: end if;
1485:
1486: when fnd_api.g_exc_error then
1487: x_return_status := fnd_api.g_ret_sts_error;
1488:
1489: if (p_form_mode in ('N','n')) then
1490: -- kgm_msg

Line 1487: x_return_status := fnd_api.g_ret_sts_error;

1483: print_error(x_msg_count);
1484: end if;
1485:
1486: when fnd_api.g_exc_error then
1487: x_return_status := fnd_api.g_ret_sts_error;
1488:
1489: if (p_form_mode in ('N','n')) then
1490: -- kgm_msg
1491: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');

Line 1510: when fnd_api.g_exc_unexpected_error then

1506: if (p_form_mode in ('N','n')) then
1507: print_error(x_msg_count);
1508: end if;
1509:
1510: when fnd_api.g_exc_unexpected_error then
1511: x_return_status := fnd_api.g_ret_sts_unexp_error;
1512:
1513: if (p_form_mode in ('N','n')) then
1514: -- kgm_msg

Line 1511: x_return_status := fnd_api.g_ret_sts_unexp_error;

1507: print_error(x_msg_count);
1508: end if;
1509:
1510: when fnd_api.g_exc_unexpected_error then
1511: x_return_status := fnd_api.g_ret_sts_unexp_error;
1512:
1513: if (p_form_mode in ('N','n')) then
1514: -- kgm_msg
1515: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');

Line 1535: x_return_status := fnd_api.g_ret_sts_unexp_error;

1531: print_error(x_msg_count);
1532: end if;
1533:
1534: when others then
1535: x_return_status := fnd_api.g_ret_sts_unexp_error;
1536:
1537: if (p_form_mode in ('N','n')) then
1538: -- kgm_msg
1539: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');