[Home] [Help]
76:
77: -- error out if supply source type id is null
78: IF (p_supply_source_type_id is null) THEN
79: fnd_message.set_name('INV', 'INV_NO_SUPPLY_TYPE');
80: fnd_msg_pub.add;
81: RAISE fnd_api.g_exc_error;
82: END IF;
83:
84: -- for WIP supply source
86:
87: -- error out if supply source header id is null
88: IF (p_supply_source_header_id is null) THEN
89: fnd_message.set_name('INV','INV_NO_SUPPLY_INFO');
90: fnd_msg_pub.add;
91: RAISE fnd_api.g_exc_error;
92: END IF;
93:
94: -- get wip entity type from wip_record_cache
328:
329: -- error out if supply source header or line id is null
330: IF (p_supply_source_header_id is null or p_supply_source_line_id is null) THEN
331: fnd_message.set_name('INV','INV_NO_SUPPLY_INFO');
332: fnd_msg_pub.add;
333: RAISE fnd_api.g_exc_error;
334: END IF;
335:
336: -- for ASN supply, error if if supply source line detail is null
336: -- for ASN supply, error if if supply source line detail is null
337: IF (p_supply_source_type_id = inv_reservation_global.g_source_type_asn
338: and p_supply_source_line_detail is null) THEN
339: fnd_message.set_name('INV','INV_NO_SUPPLY_INFO');
340: fnd_msg_pub.add;
341: RAISE fnd_api.g_exc_error;
342: END IF;
343:
344: -- call availability API for PO, ASN, Intransit shipment or Internal Req
479:
480: -- error out if organization_id or item id is null
481: IF (p_organization_id is null or p_item_id is null) THEN
482: fnd_message.set_name('INV', 'INV_NO_ORG_ITEM');
483: fnd_msg_pub.add;
484: RAISE fnd_api.g_exc_error;
485: END IF;
486:
487: -- call availability API for available quantity in receiving
609: debug_print('others error in available_supply_to_reserve');
610: debug_print('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM);
611: END IF;
612: --
613: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
614: THEN
615: fnd_msg_pub.add_exc_msg
616: ( g_pkg_name
617: , 'available_supply_to_reserve'
611: END IF;
612: --
613: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
614: THEN
615: fnd_msg_pub.add_exc_msg
616: ( g_pkg_name
617: , 'available_supply_to_reserve'
618: );
619: END IF;
678:
679: -- error out if demand source type id is null
680: IF (p_demand_source_type_id is null) THEN
681: fnd_message.set_name('INV', 'INV_NO_DEMAND_TYPE');
682: fnd_msg_pub.add;
683: RAISE fnd_api.g_exc_error;
684: END IF;
685:
686: -- for WIP demand source
688:
689: -- error out if demand source header id is null
690: IF (p_demand_source_header_id is null) THEN
691: fnd_message.set_name('INV','INV_NO_DEMAND_INFO');
692: fnd_msg_pub.add;
693: RAISE fnd_api.g_exc_error;
694: END IF;
695:
696: -- get wip entitty type from wip_record_cache
901: debug_print('project_id = ' || p_project_id || ' and task_id = ' || p_task_id);
902: END IF;
903:
904: FND_MESSAGE.SET_NAME('INV', 'INV_WDD_NOT_FOUND');
905: FND_MSG_PUB.ADD;
906: RAISE fnd_api.g_exc_error;
907: END;
908:
909: IF (l_debug = 1) THEN
1054: IF (l_debug = 1) THEN
1055: debug_print('Cannot find the primary unit of measure');
1056: END IF;
1057: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1058: FND_MSG_PUB.ADD;
1059: RAISE fnd_api.g_exc_error;
1060: END;
1061: END IF;
1062:
1132: --
1133: WHEN OTHERS THEN
1134: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1135: --
1136: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1137: THEN
1138: fnd_msg_pub.add_exc_msg
1139: ( g_pkg_name
1140: , 'available_demand_to_reserve'
1134: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1135: --
1136: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1137: THEN
1138: fnd_msg_pub.add_exc_msg
1139: ( g_pkg_name
1140: , 'available_demand_to_reserve'
1141: );
1142: END IF;