[Home] [Help]
77:
78: -- error out if supply source type id is null
79: IF (p_supply_source_type_id is null) THEN
80: fnd_message.set_name('INV', 'INV_NO_SUPPLY_TYPE');
81: fnd_msg_pub.add;
82: RAISE fnd_api.g_exc_error;
83: END IF;
84:
85: -- for WIP supply source
87:
88: -- error out if supply source header id is null
89: IF (p_supply_source_header_id is null) THEN
90: fnd_message.set_name('INV','INV_NO_SUPPLY_INFO');
91: fnd_msg_pub.add;
92: RAISE fnd_api.g_exc_error;
93: END IF;
94:
95: -- get wip entity type from wip_record_cache
363:
364: -- error out if supply source header or line id is null
365: IF (p_supply_source_header_id is null or p_supply_source_line_id is null) THEN
366: fnd_message.set_name('INV','INV_NO_SUPPLY_INFO');
367: fnd_msg_pub.add;
368: RAISE fnd_api.g_exc_error;
369: END IF;
370:
371: -- for ASN supply, error if if supply source line detail is null
371: -- for ASN supply, error if if supply source line detail is null
372: IF (p_supply_source_type_id = inv_reservation_global.g_source_type_asn
373: and p_supply_source_line_detail is null) THEN
374: fnd_message.set_name('INV','INV_NO_SUPPLY_INFO');
375: fnd_msg_pub.add;
376: RAISE fnd_api.g_exc_error;
377: END IF;
378:
379: -- call availability API for PO, ASN, Intransit shipment or Internal Req
515:
516: -- error out if organization_id or item id is null
517: IF (p_organization_id is null or p_item_id is null) THEN
518: fnd_message.set_name('INV', 'INV_NO_ORG_ITEM');
519: fnd_msg_pub.add;
520: RAISE fnd_api.g_exc_error;
521: END IF;
522:
523: -- call availability API for available quantity in receiving
689: debug_print('others error in available_supply_to_reserve');
690: debug_print('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM);
691: END IF;
692: --
693: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
694: THEN
695: fnd_msg_pub.add_exc_msg
696: ( g_pkg_name
697: , 'available_supply_to_reserve'
691: END IF;
692: --
693: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
694: THEN
695: fnd_msg_pub.add_exc_msg
696: ( g_pkg_name
697: , 'available_supply_to_reserve'
698: );
699: END IF;
858:
859: -- error out if demand source type id is null
860: IF (p_demand_source_type_id is null) THEN
861: fnd_message.set_name('INV', 'INV_NO_DEMAND_TYPE');
862: fnd_msg_pub.add;
863: RAISE fnd_api.g_exc_error;
864: END IF;
865:
866: -- for WIP demand source
868:
869: -- error out if demand source header id is null
870: IF (p_demand_source_header_id is null) THEN
871: fnd_message.set_name('INV','INV_NO_DEMAND_INFO');
872: fnd_msg_pub.add;
873: RAISE fnd_api.g_exc_error;
874: END IF;
875:
876: -- get wip entitty type from wip_record_cache
1081: debug_print('project_id = ' || p_project_id || ' and task_id = ' || p_task_id);
1082: END IF;
1083:
1084: FND_MESSAGE.SET_NAME('INV', 'INV_WDD_NOT_FOUND');
1085: FND_MSG_PUB.ADD;
1086: RAISE fnd_api.g_exc_error;
1087: END;
1088:
1089: IF (l_debug = 1) THEN
1561: IF (l_debug = 1) THEN
1562: debug_print('Cannot find the primary unit of measure');
1563: END IF;
1564: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1565: FND_MSG_PUB.ADD;
1566: RAISE fnd_api.g_exc_error;
1567: END;
1568: END IF;
1569:
1728: --
1729: WHEN OTHERS THEN
1730: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1731: --
1732: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1733: THEN
1734: fnd_msg_pub.add_exc_msg
1735: ( g_pkg_name
1736: , 'available_demand_to_reserve'
1730: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1731: --
1732: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1733: THEN
1734: fnd_msg_pub.add_exc_msg
1735: ( g_pkg_name
1736: , 'available_demand_to_reserve'
1737: );
1738: END IF;