[Home] [Help]
142: if p_object_id is null then
143:
144: if p_serial_number is null or p_inventory_item_id is null or p_organization_id is null then
145: -- if serial_number is null, then quit processing
146: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ITEM_DOES_NOT_EXIST');
147: FND_MSG_PUB.ADD;
148: RAISE FND_API.G_EXC_ERROR;
149: else
150: l_serial_number := p_serial_number;
164: from mtl_serial_numbers
165: where gen_object_id = p_object_id;
166: exception
167: when others then
168: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ITEM_DOES_NOT_EXIST');
169: FND_MSG_PUB.ADD;
170: RAISE FND_API.G_EXC_ERROR;
171: end;
172: else
183: -- obtain parent object id information
184: if p_parent_object_id is null then
185: if p_parent_serial_number is null or p_parent_inventory_item_id is null or p_parent_organization_id is null then
186: -- if there is no parent information, then quit processing
187: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_INVALID_PARENT_ITEM');
188: FND_MSG_PUB.ADD;
189: RAISE FND_API.G_EXC_ERROR;
190:
191: else
200: where serial_number = l_parent_serial_number
201: and inventory_item_id = p_parent_inventory_item_id;
202: exception
203: when others then
204: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_INVALID_PARENT_ITEM');
205: FND_MSG_PUB.ADD;
206: RAISE FND_API.G_EXC_ERROR;
207: end;
208: end if;
234: and wdj.manual_rebuild_flag = 'N'
235: and wdj.status_type in (1,3,6);
236:
237: if l_charge_object_id <> l_parent_object_id then
238: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_WO_WITH_CHARGE_ASSET');
239: FND_MSG_PUB.ADD;
240: RAISE FND_API.G_EXC_ERROR;
241: end if;
242:
491: or p_inventory_item_id is null
492: or p_organization_id is null then
493:
494: -- if serial_number is null, then quit processing
495: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ITEM_DOES_NOT_EXIST');
496: FND_MSG_PUB.ADD;
497: RAISE FND_API.G_EXC_ERROR;
498: else
499: l_serial_number := p_serial_number;
508: and inventory_item_id = p_inventory_item_id;
509:
510: exception
511: when others then
512: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ITEM_DOES_NOT_EXIST');
513: FND_MSG_PUB.ADD;
514: RAISE FND_API.G_EXC_ERROR;
515: end;
516: end if;
528: gen_object_id = p_object_id;
529:
530: exception
531: when others then
532: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ITEM_DOES_NOT_EXIST');
533: FND_MSG_PUB.ADD;
534: RAISE FND_API.G_EXC_ERROR;
535: end;
536:
573: NULL,
574: NULL,
575: NULL,
576: 'Z') <> 'Y' then
577: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_INVALID_SUBINVENTORY');
578: FND_MSG_PUB.ADD;
579: RAISE FND_API.G_EXC_ERROR;
580: end if;
581:
598: and organization_id = l_organization_id
599: and secondary_inventory = l_subinventory);
600: exception
601: when others then
602: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_INVALID_SUBINVENTORY');
603: FND_MSG_PUB.ADD;
604: RAISE FND_API.G_EXC_ERROR;
605: end;
606:
604: RAISE FND_API.G_EXC_ERROR;
605: end;
606:
607: if l_dummy <> 10 then
608: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_INVALID_SUBINVENTORY');
609: FND_MSG_PUB.ADD;
610: RAISE FND_API.G_EXC_ERROR;
611: end if;
612:
634: -- This restriction has been put in place because eventhough the date
635: -- of transaction is future, the status of the item is changed immediately
636:
637: if p_end_date_active is not null and p_end_date_active > sysdate then
638: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_REBUILD_FUTURE_TXN');
639: FND_MSG_PUB.ADD;
640: RAISE FND_API.G_EXC_ERROR;
641: else
642:
645: from wip_eam_parameters
646: where organization_id = l_organization_id;
647:
648: if l_dist_acct_id is null then
649: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_NO_OFFSET_ACCOUNT');
650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;
652: end if;
653:
762: );
763:
764: exception
765: WHEN NO_DATA_FOUND THEN
766: fnd_message.set_name
767: ( application => 'EAM'
768: , name => 'EAM_INSTANCE_ID_INVALID'
769: );
770:
807: );
808:
809: exception
810: WHEN NO_DATA_FOUND THEN
811: fnd_message.set_name
812: ( application => 'EAM'
813: , name => 'EAM_INSTANCE_ID_INVALID'
814: );
815: