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 246: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067

242: AND ( p_subinventory_code IS NULL
243: OR p_subinventory_code = rti.subinventory)
244: AND ( p_locator_id IS NULL
245: OR p_locator_id = rti.locator_id)
246: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
247: OR l_lpn_id = rti.lpn_id --Bug 5329067
248: OR ( l_lpn_id IS NULL--Bug 5329067
249: AND rti.lpn_id IS NULL))
250: AND ( p_project_id IS NULL

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

271: AND ( p_subinventory_code IS NULL
272: OR p_subinventory_code = rsl.to_subinventory)
273: AND ( p_locator_id IS NULL
274: OR p_locator_id = rsl.locator_id)
275: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
276: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
277: FROM rcv_transactions rt
278: WHERE rt.shipment_line_id = rsl.shipment_line_id))
279: AND ( p_project_id IS NULL

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

272: OR p_subinventory_code = rsl.to_subinventory)
273: AND ( p_locator_id IS NULL
274: OR p_locator_id = rsl.locator_id)
275: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
276: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
277: FROM rcv_transactions rt
278: WHERE rt.shipment_line_id = rsl.shipment_line_id))
279: AND ( p_project_id IS NULL
280: OR p_project_id IN(SELECT rt.project_id

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

329: AND ( p_subinventory_code IS NULL
330: OR p_subinventory_code = rti.subinventory)
331: AND ( p_locator_id IS NULL
332: OR p_locator_id = rti.locator_id)
333: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
334: OR l_lpn_id = rti.lpn_id --Bug 5329067
335: OR ( l_lpn_id IS NULL --Bug 5329067
336: AND rti.lpn_id IS NULL))
337: AND ( p_project_id IS NULL

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

358: AND ( p_subinventory_code IS NULL
359: OR p_subinventory_code = rsl.to_subinventory)
360: AND ( p_locator_id IS NULL
361: OR p_locator_id = rsl.locator_id)
362: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
363: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num)--Bug 5329067
364: FROM rcv_transactions rt
365: WHERE rt.shipment_line_id = rsl.shipment_line_id))
366: AND ( p_project_id IS NULL

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

359: OR p_subinventory_code = rsl.to_subinventory)
360: AND ( p_locator_id IS NULL
361: OR p_locator_id = rsl.locator_id)
362: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
363: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num)--Bug 5329067
364: FROM rcv_transactions rt
365: WHERE rt.shipment_line_id = rsl.shipment_line_id))
366: AND ( p_project_id IS NULL
367: OR p_project_id IN(SELECT rt.project_id

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

427: AND ( p_subinventory_code IS NULL
428: OR p_subinventory_code = rti.subinventory)
429: AND ( p_locator_id IS NULL
430: OR p_locator_id = rti.locator_id)
431: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
432: OR l_lpn_id = rti.lpn_id--Bug 5329067
433: OR ( l_lpn_id IS NULL --Bug 5329067
434: AND rti.lpn_id IS NULL))
435: AND ( p_project_id IS NULL

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

456: AND ( p_subinventory_code IS NULL
457: OR p_subinventory_code = rsl.to_subinventory)
458: AND ( p_locator_id IS NULL
459: OR p_locator_id = rsl.locator_id)
460: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
461: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
462: FROM rcv_transactions rt
463: WHERE rt.shipment_line_id = rsl.shipment_line_id))
464: AND ( p_project_id IS NULL

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

457: OR p_subinventory_code = rsl.to_subinventory)
458: AND ( p_locator_id IS NULL
459: OR p_locator_id = rsl.locator_id)
460: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
461: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
462: FROM rcv_transactions rt
463: WHERE rt.shipment_line_id = rsl.shipment_line_id))
464: AND ( p_project_id IS NULL
465: OR p_project_id IN(SELECT rt.project_id

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

544: AND ( p_subinventory_code IS NULL
545: OR p_subinventory_code = rti.subinventory)
546: AND ( p_locator_id IS NULL
547: OR p_locator_id = rti.locator_id)
548: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
549: OR l_lpn_id = rti.lpn_id --Bug 5329067
550: OR ( l_lpn_id IS NULL--Bug 5329067
551: AND rti.lpn_id IS NULL))
552: AND ( p_project_id IS NULL

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

573: AND ( p_subinventory_code IS NULL
574: OR p_subinventory_code = rsl.to_subinventory)
575: AND ( p_locator_id IS NULL
576: OR p_locator_id = rsl.locator_id)
577: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
578: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
579: FROM rcv_transactions rt
580: WHERE rt.shipment_line_id = rsl.shipment_line_id))
581: AND ( p_project_id IS NULL

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

574: OR p_subinventory_code = rsl.to_subinventory)
575: AND ( p_locator_id IS NULL
576: OR p_locator_id = rsl.locator_id)
577: AND ( l_lpn_id = fnd_api.g_miss_num --Bug 5329067
578: OR NVL(l_lpn_id, fnd_api.g_miss_num) IN(SELECT NVL(rt.lpn_id, fnd_api.g_miss_num) --Bug 5329067
579: FROM rcv_transactions rt
580: WHERE rt.shipment_line_id = rsl.shipment_line_id))
581: AND ( p_project_id IS NULL
582: OR p_project_id IN(SELECT rt.project_id

Line 661: x_return_status := fnd_api.g_ret_sts_error;

657: WHEN OTHERS THEN
658: NULL;
659: END update_rcv_quantity;
660: BEGIN
661: x_return_status := fnd_api.g_ret_sts_error;
662:
663: -- Standard call to check for call compatibility
664: IF NOT fnd_api.compatible_api_call(l_api_version_number,
665: p_api_version_number,

Line 664: IF NOT fnd_api.compatible_api_call(l_api_version_number,

660: BEGIN
661: x_return_status := fnd_api.g_ret_sts_error;
662:
663: -- Standard call to check for call compatibility
664: IF NOT fnd_api.compatible_api_call(l_api_version_number,
665: p_api_version_number,
666: l_api_name,
667: g_pkg_name
668: ) THEN

Line 669: RAISE fnd_api.g_exc_unexpected_error;

665: p_api_version_number,
666: l_api_name,
667: g_pkg_name
668: ) THEN
669: RAISE fnd_api.g_exc_unexpected_error;
670: END IF;
671:
672: -- Initialize message list.
673: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 673: IF fnd_api.to_boolean(p_init_msg_lst) THEN

669: RAISE fnd_api.g_exc_unexpected_error;
670: END IF;
671:
672: -- Initialize message list.
673: IF fnd_api.to_boolean(p_init_msg_lst) THEN
674: fnd_msg_pub.initialize;
675: END IF;
676:
677: IF ( p_supply_demand_code IS NULL

Line 683: RAISE fnd_api.g_exc_error;

679: OR p_supply_demand_header_id IS NULL
680: OR p_supply_demand_line_id IS NULL) THEN
681: fnd_message.set_name('RCV', 'RCV_INVALID_NULL');
682: fnd_msg_pub.ADD;
683: RAISE fnd_api.g_exc_error;
684: END IF;
685:
686: /** Bug 5329067:
687: * If the p_lpn_id is passed as 'null' to the procedure get_available_supply_demand(), then

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

684: END IF;
685:
686: /** Bug 5329067:
687: * If the p_lpn_id is passed as 'null' to the procedure get_available_supply_demand(), then
688: * we have to treat it same as the fnd_api.g_miss_num. As of now reservation in receiving is not
689: * maintained at the LPN level, so we can treat the 'null' value as fnd_api.g_miss_num.
690: */
691: IF p_lpn_id is null then --Bug 5329067
692: l_lpn_id := fnd_api.g_miss_num;

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

685:
686: /** Bug 5329067:
687: * If the p_lpn_id is passed as 'null' to the procedure get_available_supply_demand(), then
688: * we have to treat it same as the fnd_api.g_miss_num. As of now reservation in receiving is not
689: * maintained at the LPN level, so we can treat the 'null' value as fnd_api.g_miss_num.
690: */
691: IF p_lpn_id is null then --Bug 5329067
692: l_lpn_id := fnd_api.g_miss_num;
693: ELSE

Line 692: l_lpn_id := fnd_api.g_miss_num;

688: * we have to treat it same as the fnd_api.g_miss_num. As of now reservation in receiving is not
689: * maintained at the LPN level, so we can treat the 'null' value as fnd_api.g_miss_num.
690: */
691: IF p_lpn_id is null then --Bug 5329067
692: l_lpn_id := fnd_api.g_miss_num;
693: ELSE
694: l_lpn_id := p_lpn_id;
695: END IF;
696:

Line 798: RAISE fnd_api.g_exc_error;

794:
795: IF (x_available_quantity IS NULL) THEN
796: fnd_message.set_name('RCV', 'RCV_UNEXPECTED_NULL');
797: fnd_msg_pub.ADD;
798: RAISE fnd_api.g_exc_error;
799: END IF;
800:
801: IF (x_available_quantity < 0) THEN
802: x_available_quantity := 0;

Line 808: x_return_status := fnd_api.g_ret_sts_success;

804: ELSE -- x_order_row.unit_of_measure is NULL
805: x_available_quantity := 0;
806: END IF; /* Bug:4901404 fix ends*/
807:
808: x_return_status := fnd_api.g_ret_sts_success;
809: EXCEPTION
810: WHEN fnd_api.g_exc_error THEN
811: x_return_status := fnd_api.g_ret_sts_error;
812: -- Get message count and data

Line 810: WHEN fnd_api.g_exc_error THEN

806: END IF; /* Bug:4901404 fix ends*/
807:
808: x_return_status := fnd_api.g_ret_sts_success;
809: EXCEPTION
810: WHEN fnd_api.g_exc_error THEN
811: x_return_status := fnd_api.g_ret_sts_error;
812: -- Get message count and data
813: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
814: WHEN fnd_api.g_exc_unexpected_error THEN

Line 811: x_return_status := fnd_api.g_ret_sts_error;

807:
808: x_return_status := fnd_api.g_ret_sts_success;
809: EXCEPTION
810: WHEN fnd_api.g_exc_error THEN
811: x_return_status := fnd_api.g_ret_sts_error;
812: -- Get message count and data
813: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
814: WHEN fnd_api.g_exc_unexpected_error THEN
815: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 814: WHEN fnd_api.g_exc_unexpected_error THEN

810: WHEN fnd_api.g_exc_error THEN
811: x_return_status := fnd_api.g_ret_sts_error;
812: -- Get message count and data
813: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
814: WHEN fnd_api.g_exc_unexpected_error THEN
815: x_return_status := fnd_api.g_ret_sts_unexp_error;
816: -- Get message count and data
817: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
818: WHEN OTHERS THEN

Line 815: x_return_status := fnd_api.g_ret_sts_unexp_error;

811: x_return_status := fnd_api.g_ret_sts_error;
812: -- Get message count and data
813: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
814: WHEN fnd_api.g_exc_unexpected_error THEN
815: x_return_status := fnd_api.g_ret_sts_unexp_error;
816: -- Get message count and data
817: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
818: WHEN OTHERS THEN
819: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 819: x_return_status := fnd_api.g_ret_sts_unexp_error;

815: x_return_status := fnd_api.g_ret_sts_unexp_error;
816: -- Get message count and data
817: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
818: WHEN OTHERS THEN
819: x_return_status := fnd_api.g_ret_sts_unexp_error;
820:
821: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
822: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
823: END IF;

Line 855: x_return_status := fnd_api.g_ret_sts_error;

851: l_api_version_number CONSTANT NUMBER := 1.0;
852: l_api_name CONSTANT VARCHAR2(30) := 'get_available_supply_demand';
853: l_lookup_code VARCHAR2(20);
854: BEGIN
855: x_return_status := fnd_api.g_ret_sts_error;
856: x_valid_status := 'N';
857:
858: -- Standard call to check for call compatibility
859: IF NOT fnd_api.compatible_api_call(l_api_version_number,

Line 859: IF NOT fnd_api.compatible_api_call(l_api_version_number,

855: x_return_status := fnd_api.g_ret_sts_error;
856: x_valid_status := 'N';
857:
858: -- Standard call to check for call compatibility
859: IF NOT fnd_api.compatible_api_call(l_api_version_number,
860: p_api_version_number,
861: l_api_name,
862: g_pkg_name
863: ) THEN

Line 864: RAISE fnd_api.g_exc_unexpected_error;

860: p_api_version_number,
861: l_api_name,
862: g_pkg_name
863: ) THEN
864: RAISE fnd_api.g_exc_unexpected_error;
865: END IF;
866:
867: -- Initialize message list.
868: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 868: IF fnd_api.to_boolean(p_init_msg_lst) THEN

864: RAISE fnd_api.g_exc_unexpected_error;
865: END IF;
866:
867: -- Initialize message list.
868: IF fnd_api.to_boolean(p_init_msg_lst) THEN
869: fnd_msg_pub.initialize;
870: END IF;
871:
872: IF ( p_supply_demand_code IS NULL

Line 878: RAISE fnd_api.g_exc_error;

874: OR p_supply_demand_header_id IS NULL
875: OR p_supply_demand_line_id IS NULL) THEN
876: fnd_message.set_name('RCV', 'RCV_INVALID_NULL');
877: fnd_msg_pub.ADD;
878: RAISE fnd_api.g_exc_error;
879: END IF;
880:
881: /*
882: The following section will attempt to use the backing docs to

Line 990: x_return_status := fnd_api.g_ret_sts_success;

986: WHEN OTHERS THEN
987: x_valid_status := 'N';
988: END;
989:
990: x_return_status := fnd_api.g_ret_sts_success;
991: EXCEPTION
992: WHEN fnd_api.g_exc_error THEN
993: x_return_status := fnd_api.g_ret_sts_error;
994: -- Get message count and data

Line 992: WHEN fnd_api.g_exc_error THEN

988: END;
989:
990: x_return_status := fnd_api.g_ret_sts_success;
991: EXCEPTION
992: WHEN fnd_api.g_exc_error THEN
993: x_return_status := fnd_api.g_ret_sts_error;
994: -- Get message count and data
995: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
996: WHEN fnd_api.g_exc_unexpected_error THEN

Line 993: x_return_status := fnd_api.g_ret_sts_error;

989:
990: x_return_status := fnd_api.g_ret_sts_success;
991: EXCEPTION
992: WHEN fnd_api.g_exc_error THEN
993: x_return_status := fnd_api.g_ret_sts_error;
994: -- Get message count and data
995: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
996: WHEN fnd_api.g_exc_unexpected_error THEN
997: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 996: WHEN fnd_api.g_exc_unexpected_error THEN

992: WHEN fnd_api.g_exc_error THEN
993: x_return_status := fnd_api.g_ret_sts_error;
994: -- Get message count and data
995: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
996: WHEN fnd_api.g_exc_unexpected_error THEN
997: x_return_status := fnd_api.g_ret_sts_unexp_error;
998: -- Get message count and data
999: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1000: WHEN OTHERS THEN

Line 997: x_return_status := fnd_api.g_ret_sts_unexp_error;

993: x_return_status := fnd_api.g_ret_sts_error;
994: -- Get message count and data
995: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
996: WHEN fnd_api.g_exc_unexpected_error THEN
997: x_return_status := fnd_api.g_ret_sts_unexp_error;
998: -- Get message count and data
999: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1000: WHEN OTHERS THEN
1001: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1001: x_return_status := fnd_api.g_ret_sts_unexp_error;

997: x_return_status := fnd_api.g_ret_sts_unexp_error;
998: -- Get message count and data
999: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1000: WHEN OTHERS THEN
1001: x_return_status := fnd_api.g_ret_sts_unexp_error;
1002:
1003: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1004: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1005: END IF;