DBA Data[Home] [Help]

APPS.BOM_OPRESOURCE_PVT dependencies on FND_MESSAGE

Line 125: Fnd_Message.Set_Name('BOM', 'BOM_ORG_ID_MISSING');

121: P_Code => l_resource_rec.organization_code) loop
122: l_resource_rec.organization_id := l_parameter_rec.organization_id;
123: End loop;
124: If l_resource_rec.organization_id is null then
125: Fnd_Message.Set_Name('BOM', 'BOM_ORG_ID_MISSING');
126: FND_MSG_PUB.Add;
127: raise FND_API.G_EXC_ERROR;
128: End if; -- invalid org
129: End if; -- organization code

Line 140: Fnd_Message.Set_Name('BOM', 'BOM_ASSY_ITEM_MISSING');

136: item_number_in => l_resource_rec.assembly_item_number,
137: item_id_out => l_resource_rec.assembly_item_id,
138: err_text => l_err_text);
139: if l_ret_code <> 0 then
140: Fnd_Message.Set_Name('BOM', 'BOM_ASSY_ITEM_MISSING');
141: FND_MSG_PUB.Add;
142: raise FND_API.G_EXC_ERROR;
143: end if; -- parse failed
144: end if; -- assembly item number

Line 170: Fnd_Message.Set_Name('BOM', 'BOM_EVENT_RESOURCE');

166: P_OpSeqId => l_resource_rec.operation_sequence_id) loop
167: l_EventFound := TRUE;
168: If l_event_rec.reference_flag = g_yes or
169: l_event_rec.operation_type <> g_event then
170: Fnd_Message.Set_Name('BOM', 'BOM_EVENT_RESOURCE');
171: FND_MSG_PUB.Add;
172: Raise FND_API.G_EXC_ERROR;
173: End if;
174: End loop;

Line 176: Fnd_Message.Set_Name('BOM', 'BOM_OP_SEQ_INVALID');

172: Raise FND_API.G_EXC_ERROR;
173: End if;
174: End loop;
175: If not l_EventFound then
176: Fnd_Message.Set_Name('BOM', 'BOM_OP_SEQ_INVALID');
177: FND_MSG_PUB.Add;
178: Raise FND_API.G_EXC_ERROR;
179: End if; -- invalid op seq id
180: End if; -- non-referenced event?

Line 196: Fnd_Message.Set_Name('BOM', 'BOM_OP_SEQ_INVALID');

192: End if; -- get operation
193: If nvl(l_resource_rec.operation_sequence_id, Fnd_Api.G_Miss_Num) =
194: Fnd_Api.G_Miss_Num then
195: -- operation not found (must also be non-referenced event)
196: Fnd_Message.Set_Name('BOM', 'BOM_OP_SEQ_INVALID');
197: FND_MSG_PUB.Add;
198: Raise FND_API.G_EXC_ERROR;
199: End if;
200:

Line 211: Fnd_Message.Set_Name('BOM', 'BOM_RESOURCE_ID_MISSING');

207: P_OrgId =>l_resource_rec.organization_id) loop
208: l_resource_rec.resource_id := l_SetUpResource_rec.resource_id;
209: End loop;
210: If l_resource_rec.resource_id is null then
211: Fnd_Message.Set_Name('BOM', 'BOM_RESOURCE_ID_MISSING');
212: FND_MSG_PUB.Add;
213: Raise FND_API.G_EXC_ERROR;
214: End if; -- invalid resource
215: End if; -- get resource id

Line 227: Fnd_Message.Set_Name('BOM', 'BOM_ACTIVITY_INVALID');

223: P_OrgId => l_resource_rec.organization_id) loop
224: l_resource_rec.activity_id := l_activity_rec.activity_id;
225: End loop;
226: If l_resource_rec.activity_id is null then
227: Fnd_Message.Set_Name('BOM', 'BOM_ACTIVITY_INVALID');
228: FND_MSG_PUB.Add;
229: Raise FND_API.G_EXC_ERROR;
230: End if; -- invalid activity
231: End if; -- get activity id

Line 489: Fnd_Message.Set_Name('BOM', 'BOM_OP_SEQ_INVALID');

485:
486: -- verify for existence of operation seq id
487: For l_operation_rec in l_operation_csr(
488: P_OpSeqId => l_resource_rec.operation_sequence_id) loop
489: Fnd_Message.Set_Name('BOM', 'BOM_OP_SEQ_INVALID');
490: FND_MSG_PUB.Add;
491: Raise FND_API.G_EXC_ERROR;
492: End loop;
493:

Line 496: Fnd_Message.Set_Name('BOM', 'BOM_NULL_RESOURCE_SEQ_NUM');

492: End loop;
493:
494: -- check for null resource seq num
495: If l_resource_rec.new_resource_seq_num is null then
496: Fnd_Message.Set_Name('BOM', 'BOM_NULL_RESOURCE_SEQ_NUM');
497: FND_MSG_PUB.Add;
498: Raise FND_API.G_EXC_ERROR;
499: End if;
500:

Line 506: Fnd_Message.Set_Name('BOM', 'BOM_DUPLICATE_RES_NUM');

502: For l_DupResource_rec in l_DupResource_csr(
503: P_OpSeqId => l_resource_rec.operation_sequence_id,
504: P_OldSeqNum => l_resource_rec.resource_seq_num,
505: P_NewSeqNum => l_resource_rec.new_resource_seq_num) loop
506: Fnd_Message.Set_Name('BOM', 'BOM_DUPLICATE_RES_NUM');
507: FND_MSG_PUB.Add;
508: Raise FND_API.G_EXC_ERROR;
509: End loop;
510:

Line 515: Fnd_Message.Set_Name('BOM', 'BOM_DEPT_RES_INVALID');

511: -- validate resource exists and is enabled and belongs to dept
512: For l_InvalidResource_rec in l_resource_csr(
513: P_OpSeqId => l_resource_rec.operation_sequence_id,
514: P_ResourceId => l_resource_rec.resource_id) loop
515: Fnd_Message.Set_Name('BOM', 'BOM_DEPT_RES_INVALID');
516: FND_MSG_PUB.Add;
517: Raise FND_API.G_EXC_ERROR;
518: End loop;
519:

Line 538: Fnd_Message.Set_Name('BOM', 'BOM_ACTIVITY_ID_INVALID');

534: if l_resource_rec.activity_id is not null then
535: For l_activity_rec in l_activity_csr(
536: P_ActivityId => l_resource_rec.activity_id,
537: P_OpSeqId => l_resource_rec.operation_sequence_id) loop
538: Fnd_Message.Set_Name('BOM', 'BOM_ACTIVITY_ID_INVALID');
539: FND_MSG_PUB.Add;
540: Raise FND_API.G_EXC_ERROR;
541: End loop;
542: End if;

Line 564: Fnd_Message.Set_Name('BOM', 'BOM_OP_RES_SCHED_NO');

560: -- 2) res uom class <> hour uom class and
561: -- 3) no conversion between resource uom and hour uom
562: If l_resource_rec.schedule_flag <> g_no then
563: If l_HourUomClass <> l_ResUomClass then
564: Fnd_Message.Set_Name('BOM', 'BOM_OP_RES_SCHED_NO');
565: FND_MSG_PUB.Add;
566: Raise FND_API.G_EXC_ERROR;
567: End if; -- not time based class
568: For l_conversion_rec in l_conversion_csr loop

Line 569: Fnd_Message.Set_Name('BOM', 'BOM_OP_RES_SCHED_NO');

565: FND_MSG_PUB.Add;
566: Raise FND_API.G_EXC_ERROR;
567: End if; -- not time based class
568: For l_conversion_rec in l_conversion_csr loop
569: Fnd_Message.Set_Name('BOM', 'BOM_OP_RES_SCHED_NO');
570: FND_MSG_PUB.Add;
571: Raise FND_API.G_EXC_ERROR;
572: End loop;
573: end if; -- schedule flag

Line 583: Fnd_Message.Set_Name('BOM', 'BOM_OP_RES_PRIOR_ERROR');

579: For l_Schedule_rec in l_schedule_csr(
580: P_OpSeqId => l_resource_rec.operation_sequence_id,
581: P_SeqNum => l_resource_rec.resource_seq_num,
582: P_SchedType => l_resource_rec.schedule_flag) loop
583: Fnd_Message.Set_Name('BOM', 'BOM_OP_RES_PRIOR_ERROR');
584: FND_MSG_PUB.Add;
585: Raise FND_API.G_EXC_ERROR;
586: End loop;
587: End if; -- prior

Line 594: Fnd_Message.Set_Name('BOM', 'BOM_OP_RES_NEXT_ERROR');

590: For l_Schedule_rec in l_schedule_csr(
591: P_OpSeqId => l_resource_rec.operation_sequence_id,
592: P_SeqNum => l_resource_rec.resource_seq_num,
593: P_SchedType => l_resource_rec.schedule_flag) loop
594: Fnd_Message.Set_Name('BOM', 'BOM_OP_RES_NEXT_ERROR');
595: FND_MSG_PUB.Add;
596: Raise FND_API.G_EXC_ERROR;
597: End loop;
598: End if; -- next

Line 606: Fnd_Message.Set_Name('BOM', 'BOM_NEGATIVE_USAGE_RATE');

602: -- 2) res uom class = hour_uom_class
603:
604: If l_resource_rec.usage_rate_or_amount < 0 then
605: If l_resource_rec.autocharge_type in (3, 4) then
606: Fnd_Message.Set_Name('BOM', 'BOM_NEGATIVE_USAGE_RATE');
607: FND_MSG_PUB.Add;
608: Raise FND_API.G_EXC_ERROR;
609: End if;
610: If l_HourUomClass = l_ResUomClass then

Line 611: Fnd_Message.Set_Name('BOM', 'BOM_NEGATIVE_USAGE_RATE');

607: FND_MSG_PUB.Add;
608: Raise FND_API.G_EXC_ERROR;
609: End if;
610: If l_HourUomClass = l_ResUomClass then
611: Fnd_Message.Set_Name('BOM', 'BOM_NEGATIVE_USAGE_RATE');
612: FND_MSG_PUB.Add;
613: Raise FND_API.G_EXC_ERROR;
614: End if;
615: End if; -- negative usage

Line 619: Fnd_Message.Set_Name('BOM', 'BOM_ASSIGNED_UNIT_ERROR');

615: End if; -- negative usage
616:
617: -- assigned units cannot be less than or equal to .00001
618: If l_resource_rec.assigned_units <= .00001 then
619: Fnd_Message.Set_Name('BOM', 'BOM_ASSIGNED_UNIT_ERROR');
620: FND_MSG_PUB.Add;
621: Raise FND_API.G_EXC_ERROR;
622: End if;
623:

Line 630: Fnd_Message.Set_Name('BOM', 'BOM_OP_RES_LOOKUP_ERROR');

626: If (l_resource_rec.basis_type not in (1,2)) or
627: (l_resource_rec.standard_rate_flag not in (1, 2)) or
628: (l_resource_rec.schedule_flag not in (1,2,3,4)) or
629: (l_resource_rec.autocharge_type not in (1,2,3,4)) then
630: Fnd_Message.Set_Name('BOM', 'BOM_OP_RES_LOOKUP_ERROR');
631: FND_MSG_PUB.Add;
632: Raise FND_API.G_EXC_ERROR;
633: End if;
634:

Line 640: Fnd_Message.Set_Name('BOM', 'BOM_AUTOCHARGE_INVALID');

636: If l_resource_rec.autocharge_type = l_POMove then
637: For l_autocharge_rec in l_pomove_csr(
638: P_OpSeqId => l_resource_rec.operation_sequence_id,
639: P_SeqNum => l_resource_rec.resource_seq_num) loop
640: Fnd_Message.Set_Name('BOM', 'BOM_AUTOCHARGE_INVALID');
641: FND_MSG_PUB.Add;
642: Raise FND_API.G_EXC_ERROR;
643: End loop;
644: End if; -- PO Move

Line 651: Fnd_Message.Set_Name('BOM','BOM_AUTOCHARGE_INVALID');

647: -- the department has no location
648: If l_resource_rec.autocharge_type in (l_POReceipt, l_POMove) then
649: For l_location_rec in l_CheckLocation_csr(
650: P_OpSeqId => l_resource_rec.operation_sequence_id) loop
651: Fnd_Message.Set_Name('BOM','BOM_AUTOCHARGE_INVALID');
652: FND_MSG_PUB.Add;
653: Raise FND_API.G_EXC_ERROR;
654: End loop;
655: End if;

Line 659: Fnd_Message.Set_Name('BOM', 'BOM_OFFSET_PERCENT_INVALID');

655: End if;
656:
657: -- Check offset percent
658: If l_resource_rec.resource_offset_percent not between 0 and 100 then
659: Fnd_Message.Set_Name('BOM', 'BOM_OFFSET_PERCENT_INVALID');
660: FND_MSG_PUB.Add;
661: Raise FND_API.G_EXC_ERROR;
662: End if;
663:

Line 668: Fnd_Message.Set_Name('BOM', 'BOM_RES_PCLFLAG_INVALID');

664: -- Bug 2514018 Check Principle Flag
665: If l_resource_rec.principle_flag IS NOT NULL and
666: l_resource_rec.principle_flag NOT IN (1,2)
667: and l_resource_rec.principle_flag <> FND_API.G_MISS_NUM then
668: Fnd_Message.Set_Name('BOM', 'BOM_RES_PCLFLAG_INVALID');
669: FND_MSG_PUB.Add;
670: Raise FND_API.G_EXC_ERROR;
671: END IF;
672: --Bug 2514018

Line 680: Fnd_Message.Set_Name('BOM', 'BOM_USAGE_RATE_INVALID');

676: /*
677: If l_resource_rec.usage_rate_or_amount <> 0 then
678: If round(l_resource_rec.usage_rate_or_amount, 6) <>
679: round((1 / l_resource_rec.usage_rate_or_amount_inverse), 6) then
680: Fnd_Message.Set_Name('BOM', 'BOM_USAGE_RATE_INVALID');
681: FND_MSG_PUB.Add;
682: Raise FND_API.G_EXC_ERROR;
683: End if;
684: Elsif l_resource_rec.usage_rate_or_amount = 0 then

Line 686: Fnd_Message.Set_Name('BOM', 'BOM_USAGE_RATE_INVALID');

682: Raise FND_API.G_EXC_ERROR;
683: End if;
684: Elsif l_resource_rec.usage_rate_or_amount = 0 then
685: If l_resource_rec.usage_rate_or_amount_inverse <> 0 then
686: Fnd_Message.Set_Name('BOM', 'BOM_USAGE_RATE_INVALID');
687: FND_MSG_PUB.Add;
688: Raise FND_API.G_EXC_ERROR;
689: End if;
690: End if;

Line 717: Fnd_Message.Set_Name('BOM','BOM_USAGE_RATE_INVALID');

713: end if;
714:
715: if (rate_invalid = 0)
716: then
717: Fnd_Message.Set_Name('BOM','BOM_USAGE_RATE_INVALID');
718: FND_MSG_PUB.Add;
719: Raise FND_API.G_EXC_ERROR;
720: end if;
721: --

Line 1309: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_OP_RESOURCE');

1305: End if;
1306: End loop; -- get old values
1307:
1308: If not l_ResourceFound then
1309: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_OP_RESOURCE');
1310: FND_MSG_PUB.Add;
1311: Raise FND_API.G_EXC_ERROR;
1312: End if; -- missing op resource
1313:

Line 1487: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_OP_RESOURCE');

1483: where operation_sequence_id = l_resource_rec.operation_sequence_id
1484: and resource_seq_num = l_resource_rec.resource_seq_num;
1485:
1486: If sql%notfound then
1487: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_OP_RESOURCE');
1488: FND_MSG_PUB.Add;
1489: Raise FND_API.G_EXC_ERROR;
1490: End if; -- missing op resource
1491: