DBA Data[Home] [Help]

APPS.WIP_EAM_GENEALOGY_PVT dependencies on FND_MSG_PUB

Line 94: FND_MSG_PUB.initialize;

90:
91: IF FND_API.TO_BOOLEAN(p_init_msg_list)
92: THEN
93:
94: FND_MSG_PUB.initialize;
95:
96: END IF;
97:
98: -- Initialize API return status to success

Line 147: FND_MSG_PUB.ADD;

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;
151: l_inventory_item_id := p_inventory_item_id;

Line 169: FND_MSG_PUB.ADD;

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
173: l_serial_number := p_serial_number;

Line 188: FND_MSG_PUB.ADD;

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
192: begin

Line 205: FND_MSG_PUB.ADD;

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;
209:

Line 239: FND_MSG_PUB.ADD;

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:
243: exception

Line 250: FND_MSG_PUB.initialize;

246: end;
247:
248: -- perform genealogy creation
249:
250: FND_MSG_PUB.initialize;
251:
252: inv_genealogy_pub.insert_genealogy(
253: p_api_version => l_api_version,
254: p_object_type => 2,

Line 347: FND_MSG_PUB.Count_And_Get

343: ROLLBACK TO eam_rebuild_genealogy;
344:
345: x_return_status := FND_API.G_RET_STS_ERROR;
346:
347: FND_MSG_PUB.Count_And_Get
348: ( p_encoded => FND_API.G_FALSE,
349: p_count => x_msg_count,
350: p_data => x_msg_data
351: );

Line 358: FND_MSG_PUB.Count_And_Get

354: ROLLBACK TO eam_rebuild_genealogy;
355:
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357:
358: FND_MSG_PUB.Count_And_Get
359: ( p_encoded => FND_API.G_FALSE,
360: p_count => x_msg_count,
361: p_data => x_msg_data
362: );

Line 458: FND_MSG_PUB.initialize;

454:
455: IF FND_API.TO_BOOLEAN(p_init_msg_list)
456: THEN
457:
458: FND_MSG_PUB.initialize;
459:
460: END IF;
461:
462: -- Initialize API return status to success

Line 499: FND_MSG_PUB.ADD;

495: or p_organization_id is null then
496:
497: -- if serial_number is null, then quit processing
498: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ITEM_DOES_NOT_EXIST');
499: FND_MSG_PUB.ADD;
500: RAISE FND_API.G_EXC_ERROR;
501: else
502: l_serial_number := p_serial_number;
503: l_inventory_item_id := p_inventory_item_id;

Line 516: FND_MSG_PUB.ADD;

512:
513: exception
514: when others then
515: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ITEM_DOES_NOT_EXIST');
516: FND_MSG_PUB.ADD;
517: RAISE FND_API.G_EXC_ERROR;
518: end;
519: end if;
520:

Line 536: FND_MSG_PUB.ADD;

532:
533: exception
534: when others then
535: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ITEM_DOES_NOT_EXIST');
536: FND_MSG_PUB.ADD;
537: RAISE FND_API.G_EXC_ERROR;
538: end;
539:
540: else

Line 581: FND_MSG_PUB.ADD;

577: NULL,
578: NULL,
579: 'Z') <> 'Y' then
580: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_INVALID_SUBINVENTORY');
581: FND_MSG_PUB.ADD;
582: RAISE FND_API.G_EXC_ERROR;
583: end if;
584:
585: select restrict_subinventories_code

Line 606: FND_MSG_PUB.ADD;

602: and secondary_inventory = l_subinventory);
603: exception
604: when others then
605: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_INVALID_SUBINVENTORY');
606: FND_MSG_PUB.ADD;
607: RAISE FND_API.G_EXC_ERROR;
608: end;
609:
610: if l_dummy <> 10 then

Line 612: FND_MSG_PUB.ADD;

608: end;
609:
610: if l_dummy <> 10 then
611: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_INVALID_SUBINVENTORY');
612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_ERROR;
614: end if;
615:
616: end if;

Line 649: FND_MSG_PUB.ADD;

645: -- if the locator control is Predefined or Dynamic Entry
646: if(x_locator_ctrl = 2 or x_locator_ctrl = 3) then
647: if(p_locator_id IS NULL) then
648: FND_MESSAGE.SET_NAME('EAM', 'EAM_RET_MAT_LOCATOR_NEEDED');
649: FND_MSG_PUB.ADD;
650: RAISE FND_API.G_EXC_ERROR;
651: end if;
652: elsif(x_locator_ctrl = 1) then -- If the locator control is NOControl
653: if(p_locator_id IS NOT NULL) then

Line 655: FND_MSG_PUB.ADD;

651: end if;
652: elsif(x_locator_ctrl = 1) then -- If the locator control is NOControl
653: if(p_locator_id IS NOT NULL) then
654: FND_MESSAGE.SET_NAME('EAM', 'EAM_RET_MAT_LOCATOR_RESTRICTED');
655: FND_MSG_PUB.ADD;
656: RAISE FND_API.G_EXC_ERROR;
657: end if;
658: end if; -- end of locator_control checkif
659:

Line 668: FND_MSG_PUB.ADD;

664: -- of transaction is future, the status of the item is changed immediately
665:
666: if p_end_date_active is not null and p_end_date_active > sysdate then
667: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_REBUILD_FUTURE_TXN');
668: FND_MSG_PUB.ADD;
669: RAISE FND_API.G_EXC_ERROR;
670: else
671:
672: -- obtain the offset account id from user-defined EAM parameters

Line 679: FND_MSG_PUB.ADD;

675: where organization_id = l_organization_id;
676:
677: if l_dist_acct_id is null then
678: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_NO_OFFSET_ACCOUNT');
679: FND_MSG_PUB.ADD;
680: RAISE FND_API.G_EXC_ERROR;
681: end if;
682:
683: --obtain the revision of the object from MSN

Line 738: FND_MSG_PUB.initialize;

734: AND object_id = l_object_id
735: AND end_date_active IS NULL;
736: /* R12 Hook for Asset Log #4141712 To get Parent Object Id End*/
737:
738: FND_MSG_PUB.initialize;
739:
740: inv_genealogy_pub.update_genealogy(
741: p_api_version => l_api_version,
742: p_object_type => 2,

Line 800: fnd_msg_pub.add;

796: ( application => 'EAM'
797: , name => 'EAM_INSTANCE_ID_INVALID'
798: );
799:
800: fnd_msg_pub.add;
801: x_return_status:= fnd_api.g_ret_sts_error;
802: fnd_msg_pub.Count_And_Get
803: ( p_count => x_msg_count,
804: p_data => x_msg_data

Line 802: fnd_msg_pub.Count_And_Get

798: );
799:
800: fnd_msg_pub.add;
801: x_return_status:= fnd_api.g_ret_sts_error;
802: fnd_msg_pub.Count_And_Get
803: ( p_count => x_msg_count,
804: p_data => x_msg_data
805: );
806: RETURN;

Line 845: fnd_msg_pub.add;

841: ( application => 'EAM'
842: , name => 'EAM_INSTANCE_ID_INVALID'
843: );
844:
845: fnd_msg_pub.add;
846: x_return_status:= fnd_api.g_ret_sts_error;
847: fnd_msg_pub.Count_And_Get
848: ( p_count => x_msg_count,
849: p_data => x_msg_data

Line 847: fnd_msg_pub.Count_And_Get

843: );
844:
845: fnd_msg_pub.add;
846: x_return_status:= fnd_api.g_ret_sts_error;
847: fnd_msg_pub.Count_And_Get
848: ( p_count => x_msg_count,
849: p_data => x_msg_data
850: );
851: RETURN;

Line 871: FND_MSG_PUB.Count_And_Get

867: ROLLBACK TO eam_rebuild_genealogy;
868:
869: x_return_status := FND_API.G_RET_STS_ERROR;
870:
871: FND_MSG_PUB.Count_And_Get
872: ( p_encoded => FND_API.G_FALSE,
873: p_count => x_msg_count,
874: p_data => x_msg_data
875: );

Line 883: FND_MSG_PUB.Count_And_Get

879: ROLLBACK TO eam_rebuild_genealogy;
880:
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882:
883: FND_MSG_PUB.Count_And_Get
884: ( p_encoded => FND_API.G_FALSE,
885: p_count => x_msg_count,
886: p_data => x_msg_data
887: );