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.RCV_AVAILABILITY dependencies on FND_API

Line 291: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067

287: AND ( p_subinventory_code IS NULL
288: OR p_subinventory_code = rti.subinventory)
289: AND ( p_locator_id IS NULL
290: OR p_locator_id = rti.locator_id)
291: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
292: OR l_lpn_id = rti.lpn_id --Bug 5329067
293: OR ( l_lpn_id IS NULL--Bug 5329067
294: AND rti.lpn_id IS NULL))
295: AND ( p_project_id IS NULL

Line 320: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067

316: AND ( p_subinventory_code IS NULL
317: OR p_subinventory_code = rsl.to_subinventory)
318: AND ( p_locator_id IS NULL
319: OR p_locator_id = rsl.locator_id)
320: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
321: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
322: FROM rcv_transactions rt
323: WHERE rt.shipment_line_id = rsl.shipment_line_id))
324: AND ( p_project_id IS NULL

Line 321: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067

317: OR p_subinventory_code = rsl.to_subinventory)
318: AND ( p_locator_id IS NULL
319: OR p_locator_id = rsl.locator_id)
320: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
321: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
322: FROM rcv_transactions rt
323: WHERE rt.shipment_line_id = rsl.shipment_line_id))
324: AND ( p_project_id IS NULL
325: OR p_project_id IN(SELECT rt.project_id

Line 378: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067

374: AND ( p_subinventory_code IS NULL
375: OR p_subinventory_code = rti.subinventory)
376: AND ( p_locator_id IS NULL
377: OR p_locator_id = rti.locator_id)
378: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
379: OR l_lpn_id = rti.lpn_id --Bug 5329067
380: OR ( l_lpn_id IS NULL --Bug 5329067
381: AND rti.lpn_id IS NULL))
382: AND ( p_project_id IS NULL

Line 407: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067

403: AND ( p_subinventory_code IS NULL
404: OR p_subinventory_code = rsl.to_subinventory)
405: AND ( p_locator_id IS NULL
406: OR p_locator_id = rsl.locator_id)
407: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
408: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num)--Bug 5329067
409: FROM rcv_transactions rt
410: WHERE rt.shipment_line_id = rsl.shipment_line_id))
411: AND ( p_project_id IS NULL

Line 408: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num)--Bug 5329067

404: OR p_subinventory_code = rsl.to_subinventory)
405: AND ( p_locator_id IS NULL
406: OR p_locator_id = rsl.locator_id)
407: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
408: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num)--Bug 5329067
409: FROM rcv_transactions rt
410: WHERE rt.shipment_line_id = rsl.shipment_line_id))
411: AND ( p_project_id IS NULL
412: OR p_project_id IN(SELECT rt.project_id

Line 476: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067

472: AND ( p_subinventory_code IS NULL
473: OR p_subinventory_code = rti.subinventory)
474: AND ( p_locator_id IS NULL
475: OR p_locator_id = rti.locator_id)
476: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
477: OR l_lpn_id = rti.lpn_id--Bug 5329067
478: OR ( l_lpn_id IS NULL --Bug 5329067
479: AND rti.lpn_id IS NULL))
480: AND ( p_project_id IS NULL

Line 505: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067

501: AND ( p_subinventory_code IS NULL
502: OR p_subinventory_code = rsl.to_subinventory)
503: AND ( p_locator_id IS NULL
504: OR p_locator_id = rsl.locator_id)
505: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
506: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
507: FROM rcv_transactions rt
508: WHERE rt.shipment_line_id = rsl.shipment_line_id))
509: AND ( p_project_id IS NULL

Line 506: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067

502: OR p_subinventory_code = rsl.to_subinventory)
503: AND ( p_locator_id IS NULL
504: OR p_locator_id = rsl.locator_id)
505: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
506: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
507: FROM rcv_transactions rt
508: WHERE rt.shipment_line_id = rsl.shipment_line_id))
509: AND ( p_project_id IS NULL
510: OR p_project_id IN(SELECT rt.project_id

Line 593: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067

589: AND ( p_subinventory_code IS NULL
590: OR p_subinventory_code = rti.subinventory)
591: AND ( p_locator_id IS NULL
592: OR p_locator_id = rti.locator_id)
593: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
594: OR l_lpn_id = rti.lpn_id --Bug 5329067
595: OR ( l_lpn_id IS NULL--Bug 5329067
596: AND rti.lpn_id IS NULL))
597: AND ( p_project_id IS NULL

Line 622: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067

618: AND ( p_subinventory_code IS NULL
619: OR p_subinventory_code = rsl.to_subinventory)
620: AND ( p_locator_id IS NULL
621: OR p_locator_id = rsl.locator_id)
622: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
623: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
624: FROM rcv_transactions rt
625: WHERE rt.shipment_line_id = rsl.shipment_line_id))
626: AND ( p_project_id IS NULL

Line 623: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067

619: OR p_subinventory_code = rsl.to_subinventory)
620: AND ( p_locator_id IS NULL
621: OR p_locator_id = rsl.locator_id)
622: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
623: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
624: FROM rcv_transactions rt
625: WHERE rt.shipment_line_id = rsl.shipment_line_id))
626: AND ( p_project_id IS NULL
627: OR p_project_id IN(SELECT rt.project_id

Line 706: x_return_status := fnd_api.g_ret_sts_error;

702: WHEN OTHERS THEN
703: NULL;
704: END update_rcv_quantity;
705: BEGIN
706: x_return_status := fnd_api.g_ret_sts_error;
707:
708: -- Standard call to check for call compatibility
709: IF NOT fnd_api.compatible_api_call(l_api_version_number,
710: p_api_version_number,

Line 709: IF NOT fnd_api.compatible_api_call(l_api_version_number,

705: BEGIN
706: x_return_status := fnd_api.g_ret_sts_error;
707:
708: -- Standard call to check for call compatibility
709: IF NOT fnd_api.compatible_api_call(l_api_version_number,
710: p_api_version_number,
711: l_api_name,
712: g_pkg_name
713: ) THEN

Line 714: RAISE fnd_api.g_exc_unexpected_error;

710: p_api_version_number,
711: l_api_name,
712: g_pkg_name
713: ) THEN
714: RAISE fnd_api.g_exc_unexpected_error;
715: END IF;
716:
717: -- Initialize message list.
718: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 718: IF fnd_api.to_boolean(p_init_msg_lst) THEN

714: RAISE fnd_api.g_exc_unexpected_error;
715: END IF;
716:
717: -- Initialize message list.
718: IF fnd_api.to_boolean(p_init_msg_lst) THEN
719: fnd_msg_pub.initialize;
720: END IF;
721:
722: IF ( p_supply_demand_code IS NULL

Line 728: RAISE fnd_api.g_exc_error;

724: OR p_supply_demand_header_id IS NULL
725: OR p_supply_demand_line_id IS NULL) THEN
726: fnd_message.set_name('RCV', 'RCV_INVALID_NULL');
727: fnd_msg_pub.ADD;
728: RAISE fnd_api.g_exc_error;
729: END IF;
730:
731: /** Bug 5329067:
732: * If the p_lpn_id is passed as 'null' to the procedure get_available_supply_demand(), then

Line 733: * we have to treat it same as the fnd_api.g_miss_num. As of now reservation in receiving is not

729: END IF;
730:
731: /** Bug 5329067:
732: * If the p_lpn_id is passed as 'null' to the procedure get_available_supply_demand(), then
733: * we have to treat it same as the fnd_api.g_miss_num. As of now reservation in receiving is not
734: * maintained at the LPN level, so we can treat the 'null' value as fnd_api.g_miss_num.
735: */
736: IF p_lpn_id is null then --Bug 5329067
737: l_lpn_id := fnd_api.g_miss_num;

Line 734: * maintained at the LPN level, so we can treat the 'null' value as fnd_api.g_miss_num.

730:
731: /** Bug 5329067:
732: * If the p_lpn_id is passed as 'null' to the procedure get_available_supply_demand(), then
733: * we have to treat it same as the fnd_api.g_miss_num. As of now reservation in receiving is not
734: * maintained at the LPN level, so we can treat the 'null' value as fnd_api.g_miss_num.
735: */
736: IF p_lpn_id is null then --Bug 5329067
737: l_lpn_id := fnd_api.g_miss_num;
738: ELSE

Line 737: l_lpn_id := fnd_api.g_miss_num;

733: * we have to treat it same as the fnd_api.g_miss_num. As of now reservation in receiving is not
734: * maintained at the LPN level, so we can treat the 'null' value as fnd_api.g_miss_num.
735: */
736: IF p_lpn_id is null then --Bug 5329067
737: l_lpn_id := fnd_api.g_miss_num;
738: ELSE
739: l_lpn_id := p_lpn_id;
740: END IF;
741:

Line 892: RAISE fnd_api.g_exc_error;

888:
889: IF (x_available_quantity IS NULL) THEN
890: fnd_message.set_name('RCV', 'RCV_UNEXPECTED_NULL');
891: fnd_msg_pub.ADD;
892: RAISE fnd_api.g_exc_error;
893: END IF;
894:
895: IF (x_available_quantity < 0) THEN
896: x_available_quantity := 0;

Line 902: x_return_status := fnd_api.g_ret_sts_success;

898: ELSE -- x_order_row.unit_of_measure is NULL
899: x_available_quantity := 0;
900: END IF; /* Bug:4901404 fix ends*/
901:
902: x_return_status := fnd_api.g_ret_sts_success;
903: EXCEPTION
904: WHEN fnd_api.g_exc_error THEN
905: x_return_status := fnd_api.g_ret_sts_error;
906: -- Get message count and data

Line 904: WHEN fnd_api.g_exc_error THEN

900: END IF; /* Bug:4901404 fix ends*/
901:
902: x_return_status := fnd_api.g_ret_sts_success;
903: EXCEPTION
904: WHEN fnd_api.g_exc_error THEN
905: x_return_status := fnd_api.g_ret_sts_error;
906: -- Get message count and data
907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
908: WHEN fnd_api.g_exc_unexpected_error THEN

Line 905: x_return_status := fnd_api.g_ret_sts_error;

901:
902: x_return_status := fnd_api.g_ret_sts_success;
903: EXCEPTION
904: WHEN fnd_api.g_exc_error THEN
905: x_return_status := fnd_api.g_ret_sts_error;
906: -- Get message count and data
907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
908: WHEN fnd_api.g_exc_unexpected_error THEN
909: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 908: WHEN fnd_api.g_exc_unexpected_error THEN

904: WHEN fnd_api.g_exc_error THEN
905: x_return_status := fnd_api.g_ret_sts_error;
906: -- Get message count and data
907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
908: WHEN fnd_api.g_exc_unexpected_error THEN
909: x_return_status := fnd_api.g_ret_sts_unexp_error;
910: -- Get message count and data
911: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
912: WHEN OTHERS THEN

Line 909: x_return_status := fnd_api.g_ret_sts_unexp_error;

905: x_return_status := fnd_api.g_ret_sts_error;
906: -- Get message count and data
907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
908: WHEN fnd_api.g_exc_unexpected_error THEN
909: x_return_status := fnd_api.g_ret_sts_unexp_error;
910: -- Get message count and data
911: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
912: WHEN OTHERS THEN
913: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 913: x_return_status := fnd_api.g_ret_sts_unexp_error;

909: x_return_status := fnd_api.g_ret_sts_unexp_error;
910: -- Get message count and data
911: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
912: WHEN OTHERS THEN
913: x_return_status := fnd_api.g_ret_sts_unexp_error;
914:
915: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
916: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
917: END IF;

Line 949: x_return_status := fnd_api.g_ret_sts_error;

945: l_api_version_number CONSTANT NUMBER := 1.0;
946: l_api_name CONSTANT VARCHAR2(30) := 'get_available_supply_demand';
947: l_lookup_code VARCHAR2(20);
948: BEGIN
949: x_return_status := fnd_api.g_ret_sts_error;
950: x_valid_status := 'N';
951:
952: -- Standard call to check for call compatibility
953: IF NOT fnd_api.compatible_api_call(l_api_version_number,

Line 953: IF NOT fnd_api.compatible_api_call(l_api_version_number,

949: x_return_status := fnd_api.g_ret_sts_error;
950: x_valid_status := 'N';
951:
952: -- Standard call to check for call compatibility
953: IF NOT fnd_api.compatible_api_call(l_api_version_number,
954: p_api_version_number,
955: l_api_name,
956: g_pkg_name
957: ) THEN

Line 958: RAISE fnd_api.g_exc_unexpected_error;

954: p_api_version_number,
955: l_api_name,
956: g_pkg_name
957: ) THEN
958: RAISE fnd_api.g_exc_unexpected_error;
959: END IF;
960:
961: -- Initialize message list.
962: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 962: IF fnd_api.to_boolean(p_init_msg_lst) THEN

958: RAISE fnd_api.g_exc_unexpected_error;
959: END IF;
960:
961: -- Initialize message list.
962: IF fnd_api.to_boolean(p_init_msg_lst) THEN
963: fnd_msg_pub.initialize;
964: END IF;
965:
966: IF ( p_supply_demand_code IS NULL

Line 972: RAISE fnd_api.g_exc_error;

968: OR p_supply_demand_header_id IS NULL
969: OR p_supply_demand_line_id IS NULL) THEN
970: fnd_message.set_name('RCV', 'RCV_INVALID_NULL');
971: fnd_msg_pub.ADD;
972: RAISE fnd_api.g_exc_error;
973: END IF;
974:
975: /*
976: The following section will attempt to use the backing docs to

Line 1058: x_return_status := fnd_api.g_ret_sts_success;

1054: AND rsl.shipment_line_id = p_supply_demand_line_detail
1055: AND rsl.po_line_location_id = p_supply_demand_line_id
1056: AND rsl.po_header_id = p_supply_demand_header_id;
1057:
1058: x_return_status := fnd_api.g_ret_sts_success;
1059: RETURN;
1060:
1061: END IF;
1062: /*End Bug#12320593 */

Line 1091: x_return_status := fnd_api.g_ret_sts_success;

1087: WHEN OTHERS THEN
1088: x_valid_status := 'N';
1089: END;
1090:
1091: x_return_status := fnd_api.g_ret_sts_success;
1092: EXCEPTION
1093: WHEN fnd_api.g_exc_error THEN
1094: x_return_status := fnd_api.g_ret_sts_error;
1095: -- Get message count and data

Line 1093: WHEN fnd_api.g_exc_error THEN

1089: END;
1090:
1091: x_return_status := fnd_api.g_ret_sts_success;
1092: EXCEPTION
1093: WHEN fnd_api.g_exc_error THEN
1094: x_return_status := fnd_api.g_ret_sts_error;
1095: -- Get message count and data
1096: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1097: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1094: x_return_status := fnd_api.g_ret_sts_error;

1090:
1091: x_return_status := fnd_api.g_ret_sts_success;
1092: EXCEPTION
1093: WHEN fnd_api.g_exc_error THEN
1094: x_return_status := fnd_api.g_ret_sts_error;
1095: -- Get message count and data
1096: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1097: WHEN fnd_api.g_exc_unexpected_error THEN
1098: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1097: WHEN fnd_api.g_exc_unexpected_error THEN

1093: WHEN fnd_api.g_exc_error THEN
1094: x_return_status := fnd_api.g_ret_sts_error;
1095: -- Get message count and data
1096: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1097: WHEN fnd_api.g_exc_unexpected_error THEN
1098: x_return_status := fnd_api.g_ret_sts_unexp_error;
1099: -- Get message count and data
1100: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1101: WHEN OTHERS THEN

Line 1098: x_return_status := fnd_api.g_ret_sts_unexp_error;

1094: x_return_status := fnd_api.g_ret_sts_error;
1095: -- Get message count and data
1096: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1097: WHEN fnd_api.g_exc_unexpected_error THEN
1098: x_return_status := fnd_api.g_ret_sts_unexp_error;
1099: -- Get message count and data
1100: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1101: WHEN OTHERS THEN
1102: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1102: x_return_status := fnd_api.g_ret_sts_unexp_error;

1098: x_return_status := fnd_api.g_ret_sts_unexp_error;
1099: -- Get message count and data
1100: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1101: WHEN OTHERS THEN
1102: x_return_status := fnd_api.g_ret_sts_unexp_error;
1103:
1104: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1105: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1106: END IF;