eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_OPRESOURCE_PVT dependencies on FND_MSG_PUB

Line 95: FND_MSG_PUB.initialize;

91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93: -- Initialize message list if p_init_msg_list is set to TRUE.
94: IF FND_API.to_Boolean(p_init_msg_list) THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97: -- Initialize API return status to success
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:

Line 126: FND_MSG_PUB.Add;

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
130:

Line 141: FND_MSG_PUB.Add;

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
145:

Line 171: FND_MSG_PUB.Add;

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;
175: If not l_EventFound then

Line 177: FND_MSG_PUB.Add;

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?
181:

Line 197: FND_MSG_PUB.Add;

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:
201: -- Get resource_id

Line 212: FND_MSG_PUB.Add;

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
216:

Line 228: FND_MSG_PUB.Add;

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
232:

Line 283: FND_MSG_PUB.Count_And_Get(

279: x_resource_rec := l_resource_rec;
280: -- End of API body.
281:
282: -- Standard call to get message count and if count is 1, get message info.
283: FND_MSG_PUB.Count_And_Get(
284: p_count => x_msg_count,
285: p_data => x_msg_data
286: );
287: EXCEPTION

Line 290: FND_MSG_PUB.Count_And_Get(

286: );
287: EXCEPTION
288: WHEN FND_API.G_EXC_ERROR THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: FND_MSG_PUB.Count_And_Get(
291: p_count => x_msg_count,
292: p_data => x_msg_data
293: );
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 296: FND_MSG_PUB.Count_And_Get(

292: p_data => x_msg_data
293: );
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: FND_MSG_PUB.Count_And_Get(
297: p_count => x_msg_count,
298: p_data => x_msg_data
299: );
300: WHEN OTHERS THEN

Line 302: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

298: p_data => x_msg_data
299: );
300: WHEN OTHERS THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
303: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
304: END IF;
305: FND_MSG_PUB.Count_And_Get(
306: p_count => x_msg_count,

Line 303: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

299: );
300: WHEN OTHERS THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
303: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
304: END IF;
305: FND_MSG_PUB.Count_And_Get(
306: p_count => x_msg_count,
307: p_data => x_msg_data

Line 305: FND_MSG_PUB.Count_And_Get(

301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
303: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
304: END IF;
305: FND_MSG_PUB.Count_And_Get(
306: p_count => x_msg_count,
307: p_data => x_msg_data
308: );
309: END AssignResource;

Line 460: FND_MSG_PUB.initialize;

456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: END IF;
458: -- Initialize message list if p_init_msg_list is set to TRUE.
459: IF FND_API.to_Boolean(p_init_msg_list) THEN
460: FND_MSG_PUB.initialize;
461: END IF;
462: -- Initialize API return status to success
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:

Line 490: FND_MSG_PUB.Add;

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:
494: -- check for null resource seq num

Line 497: FND_MSG_PUB.Add;

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:
501: -- check for duplicate resource seq num/operation sequence id

Line 507: FND_MSG_PUB.Add;

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:
511: -- validate resource exists and is enabled and belongs to dept

Line 516: FND_MSG_PUB.Add;

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:
520: -- Check if resource is available 24 hours

Line 539: FND_MSG_PUB.Add;

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

Line 565: FND_MSG_PUB.Add;

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
569: Fnd_Message.Set_Name('BOM', 'BOM_OP_RES_SCHED_NO');

Line 570: 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
574:

Line 584: FND_MSG_PUB.Add;

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
588:

Line 595: FND_MSG_PUB.Add;

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
599:

Line 607: FND_MSG_PUB.Add;

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
611: Fnd_Message.Set_Name('BOM', 'BOM_NEGATIVE_USAGE_RATE');

Line 612: 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
616:

Line 620: FND_MSG_PUB.Add;

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:
624: -- check if basis type,standard rate flag, schedule flag

Line 631: FND_MSG_PUB.Add;

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:
635: -- Only one PO move per operation

Line 641: FND_MSG_PUB.Add;

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
645:

Line 652: FND_MSG_PUB.Add;

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

Line 660: FND_MSG_PUB.Add;

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:
664: -- Bug 2514018 Check Principle Flag

Line 669: FND_MSG_PUB.Add;

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
673:

Line 681: FND_MSG_PUB.Add;

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
685: If l_resource_rec.usage_rate_or_amount_inverse <> 0 then

Line 687: FND_MSG_PUB.Add;

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;
691: */

Line 718: FND_MSG_PUB.Add;

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: --
722:

Line 727: FND_MSG_PUB.Count_And_Get(

723: x_resource_rec := l_resource_rec;
724: -- End of API body.
725:
726: -- Standard call to get message count and if count is 1, get message info.
727: FND_MSG_PUB.Count_And_Get(
728: p_count => x_msg_count,
729: p_data => x_msg_data
730: );
731: EXCEPTION

Line 734: FND_MSG_PUB.Count_And_Get(

730: );
731: EXCEPTION
732: WHEN FND_API.G_EXC_ERROR THEN
733: x_return_status := FND_API.G_RET_STS_ERROR;
734: FND_MSG_PUB.Count_And_Get(
735: p_count => x_msg_count,
736: p_data => x_msg_data
737: );
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 740: FND_MSG_PUB.Count_And_Get(

736: p_data => x_msg_data
737: );
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: FND_MSG_PUB.Count_And_Get(
741: p_count => x_msg_count,
742: p_data => x_msg_data
743: );
744: WHEN OTHERS THEN

Line 746: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

742: p_data => x_msg_data
743: );
744: WHEN OTHERS THEN
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
747: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
748: END IF;
749: FND_MSG_PUB.Count_And_Get(
750: p_count => x_msg_count,

Line 747: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

743: );
744: WHEN OTHERS THEN
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
747: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
748: END IF;
749: FND_MSG_PUB.Count_And_Get(
750: p_count => x_msg_count,
751: p_data => x_msg_data

Line 749: FND_MSG_PUB.Count_And_Get(

745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
747: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
748: END IF;
749: FND_MSG_PUB.Count_And_Get(
750: p_count => x_msg_count,
751: p_data => x_msg_data
752: );
753: END ValidateResource;

Line 787: FND_MSG_PUB.initialize;

783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784: END IF;
785: -- Initialize message list if p_init_msg_list is set to TRUE.
786: IF FND_API.to_Boolean(p_init_msg_list) THEN
787: FND_MSG_PUB.initialize;
788: END IF;
789: -- Initialize API return status to success
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:

Line 1084: FND_MSG_PUB.Count_And_Get(

1080: IF FND_API.To_Boolean(p_commit) THEN
1081: COMMIT WORK;
1082: END IF;
1083: -- Standard call to get message count and if count is 1, get message info.
1084: FND_MSG_PUB.Count_And_Get(
1085: p_count => x_msg_count,
1086: p_data => x_msg_data
1087: );
1088: EXCEPTION

Line 1092: FND_MSG_PUB.Count_And_Get(

1088: EXCEPTION
1089: WHEN FND_API.G_EXC_ERROR THEN
1090: ROLLBACK TO CreateResource_Pvt;
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: FND_MSG_PUB.Count_And_Get(
1093: p_count => x_msg_count,
1094: p_data => x_msg_data
1095: );
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1099: FND_MSG_PUB.Count_And_Get(

1095: );
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1097: ROLLBACK TO CreateResource_Pvt;
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1099: FND_MSG_PUB.Count_And_Get(
1100: p_count => x_msg_count,
1101: p_data => x_msg_data
1102: );
1103: WHEN OTHERS THEN

Line 1106: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1102: );
1103: WHEN OTHERS THEN
1104: ROLLBACK TO CreateResource_Pvt;
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1107: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1108: END IF;
1109: FND_MSG_PUB.Count_And_Get(
1110: p_count => x_msg_count,

Line 1107: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1103: WHEN OTHERS THEN
1104: ROLLBACK TO CreateResource_Pvt;
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1107: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1108: END IF;
1109: FND_MSG_PUB.Count_And_Get(
1110: p_count => x_msg_count,
1111: p_data => x_msg_data

Line 1109: FND_MSG_PUB.Count_And_Get(

1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1107: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1108: END IF;
1109: FND_MSG_PUB.Count_And_Get(
1110: p_count => x_msg_count,
1111: p_data => x_msg_data
1112: );
1113: END CreateResource;

Line 1154: FND_MSG_PUB.initialize;

1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: END IF;
1152: -- Initialize message list if p_init_msg_list is set to TRUE.
1153: IF FND_API.to_Boolean(p_init_msg_list) THEN
1154: FND_MSG_PUB.initialize;
1155: END IF;
1156: -- Initialize API return status to success
1157: x_return_status := FND_API.G_RET_STS_SUCCESS;
1158:

Line 1310: FND_MSG_PUB.Add;

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:
1314: If p_validation_level > FND_API.G_VALID_LEVEL_NONE then

Line 1396: FND_MSG_PUB.Count_And_Get(

1392: IF FND_API.To_Boolean(p_commit) THEN
1393: COMMIT WORK;
1394: END IF;
1395: -- Standard call to get message count and if count is 1, get message info.
1396: FND_MSG_PUB.Count_And_Get(
1397: p_count => x_msg_count,
1398: p_data => x_msg_data
1399: );
1400: EXCEPTION

Line 1404: FND_MSG_PUB.Count_And_Get(

1400: EXCEPTION
1401: WHEN FND_API.G_EXC_ERROR THEN
1402: ROLLBACK TO UpdateResource_Pvt;
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: FND_MSG_PUB.Count_And_Get(
1405: p_count => x_msg_count,
1406: p_data => x_msg_data
1407: );
1408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1411: FND_MSG_PUB.Count_And_Get(

1407: );
1408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1409: ROLLBACK TO UpdateResource_Pvt;
1410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1411: FND_MSG_PUB.Count_And_Get(
1412: p_count => x_msg_count,
1413: p_data => x_msg_data
1414: );
1415: WHEN OTHERS THEN

Line 1418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1414: );
1415: WHEN OTHERS THEN
1416: ROLLBACK TO UpdateResource_Pvt;
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1419: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1420: END IF;
1421: FND_MSG_PUB.Count_And_Get(
1422: p_count => x_msg_count,

Line 1419: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1415: WHEN OTHERS THEN
1416: ROLLBACK TO UpdateResource_Pvt;
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1419: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1420: END IF;
1421: FND_MSG_PUB.Count_And_Get(
1422: p_count => x_msg_count,
1423: p_data => x_msg_data

Line 1421: FND_MSG_PUB.Count_And_Get(

1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1419: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1420: END IF;
1421: FND_MSG_PUB.Count_And_Get(
1422: p_count => x_msg_count,
1423: p_data => x_msg_data
1424: );
1425: END UpdateResource;

Line 1453: FND_MSG_PUB.initialize;

1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: END IF;
1451: -- Initialize message list if p_init_msg_list is set to TRUE.
1452: IF FND_API.to_Boolean(p_init_msg_list) THEN
1453: FND_MSG_PUB.initialize;
1454: END IF;
1455: -- Initialize API return status to success
1456: x_return_status := FND_API.G_RET_STS_SUCCESS;
1457:

Line 1488: FND_MSG_PUB.Add;

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:
1492: -- End of API body.

Line 1499: FND_MSG_PUB.Count_And_Get(

1495: IF FND_API.To_Boolean(p_commit) THEN
1496: COMMIT WORK;
1497: END IF;
1498: -- Standard call to get message count and if count is 1, get message info.
1499: FND_MSG_PUB.Count_And_Get(
1500: p_count => x_msg_count,
1501: p_data => x_msg_data
1502: );
1503: EXCEPTION

Line 1507: FND_MSG_PUB.Count_And_Get(

1503: EXCEPTION
1504: WHEN FND_API.G_EXC_ERROR THEN
1505: ROLLBACK TO DeleteResource_Pvt;
1506: x_return_status := FND_API.G_RET_STS_ERROR;
1507: FND_MSG_PUB.Count_And_Get(
1508: p_count => x_msg_count,
1509: p_data => x_msg_data
1510: );
1511: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1514: FND_MSG_PUB.Count_And_Get(

1510: );
1511: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1512: ROLLBACK TO DeleteResource_Pvt;
1513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1514: FND_MSG_PUB.Count_And_Get(
1515: p_count => x_msg_count,
1516: p_data => x_msg_data
1517: );
1518: WHEN OTHERS THEN

Line 1521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1517: );
1518: WHEN OTHERS THEN
1519: ROLLBACK TO DeleteResource_Pvt;
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1522: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1523: END IF;
1524: FND_MSG_PUB.Count_And_Get(
1525: p_count => x_msg_count,

Line 1522: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1518: WHEN OTHERS THEN
1519: ROLLBACK TO DeleteResource_Pvt;
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1522: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1523: END IF;
1524: FND_MSG_PUB.Count_And_Get(
1525: p_count => x_msg_count,
1526: p_data => x_msg_data

Line 1524: FND_MSG_PUB.Count_And_Get(

1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1522: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1523: END IF;
1524: FND_MSG_PUB.Count_And_Get(
1525: p_count => x_msg_count,
1526: p_data => x_msg_data
1527: );
1528: END DeleteResource;