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_OPERATION_PVT dependencies on FND_MSG_PUB

Line 77: FND_MSG_PUB.initialize;

73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF FND_API.to_Boolean(p_init_msg_list) THEN
77: FND_MSG_PUB.initialize;
78: END IF;
79: -- Initialize API return status to success
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:

Line 119: FND_MSG_PUB.Add;

115:
116: if nvl(l_operation_rec.organization_id, FND_API.G_MISS_NUM) =
117: FND_API.G_MISS_NUM then
118: Fnd_Message.Set_Name('BOM', 'BOM_ORG_ID_MISSING');
119: FND_MSG_PUB.Add;
120: raise FND_API.G_EXC_ERROR;
121: end if; -- organization_id
122:
123: If nvl(l_operation_rec.Assembly_Item_Number, FND_API.G_MISS_CHAR) <>

Line 132: FND_MSG_PUB.Add;

128: item_id_out => l_operation_rec.assembly_item_id,
129: err_text => l_err_text);
130: if l_ret_code <> 0 then
131: Fnd_Message.Set_Name('BOM', 'BOM_ASSY_ITEM_MISSING');
132: FND_MSG_PUB.Add;
133: raise FND_API.G_EXC_ERROR;
134: end if; -- parse failed
135: end if; -- assembly item number
136:

Line 149: FND_MSG_PUB.Add;

145: l_operation_rec.department_id := l_department_rec.department_id;
146: End loop;
147: If l_operation_rec.department_id is null then
148: Fnd_Message.Set_Name('BOM', 'BOM_DEPT_CODE_INVALID');
149: FND_MSG_PUB.Add;
150: raise FND_API.G_EXC_ERROR;
151: End if; -- invalid dept code
152: End if; -- dept code
153:

Line 164: FND_MSG_PUB.Add;

160:
161: If (nvl(l_operation_rec.option_dependent_flag,Fnd_Api.G_Miss_Num) <> Fnd_Api.G_Miss_Num) then
162: If (g_assy_item_type not in (1,2) and l_operation_rec.option_dependent_flag = 1 ) then
163: Fnd_Message.Set_Name('BOM','BOM_OP_DPTFLAG_MUST_BE_NO');
164: FND_MSG_PUB.Add;
165: Raise FND_API.G_EXC_ERROR;
166: End If;
167: Else
168: If g_assy_item_type in ( 1,2 ) then

Line 191: FND_MSG_PUB.Add;

187: End loop;
188: If nvl(l_operation_rec.routing_sequence_id, FND_API.G_MISS_NUM) =
189: FND_API.G_MISS_NUM then
190: Fnd_Message.Set_Name('BOM', 'BOM_RTG_SEQ_INVALID');
191: FND_MSG_PUB.Add;
192: Raise FND_API.G_EXC_ERROR;
193: End if;
194: End if; -- get routing sequence id
195:

Line 212: FND_MSG_PUB.Add;

208: l_StdOp_rec.standard_operation_id;
209: End loop; -- get standard operation id
210: If l_operation_rec.standard_operation_id is null then
211: Fnd_Message.Set_Name('BOM', 'BOM_STD_OP_CODE_INVALID');
212: FND_MSG_PUB.Add;
213: Raise FND_API.G_EXC_ERROR;
214: End if; -- invalid op code
215: End if; -- std op code
216:

Line 221: FND_MSG_PUB.Count_And_Get(

217: x_operation_rec := l_operation_rec;
218: -- End of API body.
219:
220: -- Standard call to get message count and if count is 1, get message info.
221: FND_MSG_PUB.Count_And_Get(
222: p_count => x_msg_count,
223: p_data => x_msg_data
224: );
225: EXCEPTION

Line 228: FND_MSG_PUB.Count_And_Get(

224: );
225: EXCEPTION
226: WHEN FND_API.G_EXC_ERROR THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: FND_MSG_PUB.Count_And_Get(
229: p_count => x_msg_count,
230: p_data => x_msg_data
231: );
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 234: FND_MSG_PUB.Count_And_Get(

230: p_data => x_msg_data
231: );
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: FND_MSG_PUB.Count_And_Get(
235: p_count => x_msg_count,
236: p_data => x_msg_data
237: );
238: WHEN OTHERS THEN

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

236: p_data => x_msg_data
237: );
238: WHEN OTHERS THEN
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
241: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
242: END IF;
243: FND_MSG_PUB.Count_And_Get(
244: p_count => x_msg_count,

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

237: );
238: WHEN OTHERS THEN
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
241: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
242: END IF;
243: FND_MSG_PUB.Count_And_Get(
244: p_count => x_msg_count,
245: p_data => x_msg_data

Line 243: FND_MSG_PUB.Count_And_Get(

239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
241: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
242: END IF;
243: FND_MSG_PUB.Count_And_Get(
244: p_count => x_msg_count,
245: p_data => x_msg_data
246: );
247: END AssignOperation;

Line 414: FND_MSG_PUB.initialize;

410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411: END IF;
412: -- Initialize message list if p_init_msg_list is set to TRUE.
413: IF FND_API.to_Boolean(p_init_msg_list) THEN
414: FND_MSG_PUB.initialize;
415: END IF;
416: -- Initialize API return status to success
417: x_return_status := FND_API.G_RET_STS_SUCCESS;
418:

Line 442: FND_MSG_PUB.Add;

438:
439: -- verify operation seq num is not null
440: If l_operation_rec .operation_seq_num is null then
441: Fnd_Message.Set_Name('BOM', 'BOM_OP_SEQ_NUM_MISSING');
442: FND_MSG_PUB.Add;
443: Raise FND_API.G_EXC_ERROR;
444: End if;
445:
446: -- check effective date entered

Line 449: FND_MSG_PUB.Add;

445:
446: -- check effective date entered
447: If l_operation_rec.new_effectivity_date is null then
448: Fnd_Message.Set_Name('BOM', 'BOM_EFF_DATE_MISSING');
449: FND_MSG_PUB.Add;
450: Raise FND_API.G_EXC_ERROR;
451: End if;
452:
453: -- verify uniqueness of operation

Line 461: FND_MSG_PUB.Add;

457: P_OpSeqNum => l_operation_rec.new_operation_seq_num,
458: P_OpType => l_operation_rec.operation_type,
459: P_EffDate => l_operation_rec.new_effectivity_date) loop
460: Fnd_Message.Set_Name('BOM', 'BOM_OPERATION_DUPLICATE');
461: FND_MSG_PUB.Add;
462: Raise FND_API.G_EXC_ERROR;
463: End loop;
464:
465: -- check for existence of routing

Line 470: FND_MSG_PUB.Add;

466:
467: For l_routing_rec in l_routing_csr(
468: P_RtgSeqId => l_operation_rec.routing_sequence_id) loop
469: Fnd_Message.Set_Name('BOM', 'BOM_RTG_SEQ_INVALID');
470: FND_MSG_PUB.Add;
471: Raise FND_API.G_EXC_ERROR;
472: End loop; -- routing existence
473:
474: -- make sure there is no overlapping operations

Line 484: FND_MSG_PUB.Add;

480: P_OpType => l_operation_rec.operation_type,
481: P_EffDate => l_operation_rec.new_effectivity_date,
482: P_DisDate => l_operation_rec.disable_date) loop
483: Fnd_Message.Set_Name('BOM', 'BOM_IMPL_OP_OVERLAP');
484: FND_MSG_PUB.Add;
485: Raise FND_API.G_EXC_ERROR;
486: End loop;
487:
488: -- verify that the routing does not have a common. If so, it cannot have

Line 493: FND_MSG_PUB.Add;

489: -- operations
490: For l_common_rec in l_common_csr(
491: P_RtgSeqId => l_operation_rec.routing_sequence_id) loop
492: Fnd_Message.Set_Name('BOM', 'BOM_COMMON_OP');
493: FND_MSG_PUB.Add;
494: Raise FND_API.G_EXC_ERROR;
495: End loop;
496:
497: -- Op Code is mandatory for Processes and Line Operations

Line 501: FND_MSG_PUB.Add;

497: -- Op Code is mandatory for Processes and Line Operations
498: If l_operation_rec.operation_type in (g_process, g_LineOp) and
499: l_operation_rec.standard_operation_id is null then
500: Fnd_Message.Set_Name('BOM', 'BOM_STD_OP_REQUIRED');
501: FND_MSG_PUB.Add;
502: Raise FND_API.G_EXC_ERROR;
503: End if; -- mandatory op code
504:
505: -- can not reference null op code

Line 524: FND_MSG_PUB.Add;

520: -- Cannot set copied operation to referenced
521: If l_PrevRefFlag = g_no and l_operation_rec.reference_flag = g_yes then
522: Fnd_Message.Set_Name('BOM', 'BOM_COPY_REF_OPERATION');
523: Fnd_Message.Set_Token('OPERATION', l_PrevStdCode);
524: FND_MSG_PUB.Add;
525: Raise FND_API.G_EXC_ERROR;
526: End if;
527:
528: -- Standard Operation has changed to not null value

Line 534: FND_MSG_PUB.Add;

530: -- check resources
531: For l_resource_rec in l_OpResources_csr(
532: P_OpSeqId => l_operation_rec.operation_sequence_id) loop
533: Fnd_Message.Set_Name('BOM', 'BOM_CANNOT_COPY_STD_OP');
534: FND_MSG_PUB.Add;
535: Raise FND_API.G_EXC_ERROR;
536: End loop; -- resources exist, cannot copy
537: l_StdOpFound := false;
538: For l_StdOp_rec in l_StdOp_csr(

Line 569: FND_MSG_PUB.Add;

565: l_operation_rec.operation_yield_enabled := nvl(l_operation_rec.operation_yield_enabled,l_StdOp_rec.operation_yield_enabled);
566: End loop; -- copy standard operation
567: If not l_StdOpFound then
568: Fnd_Message.Set_Name('BOM', 'BOM_STD_OP_ID_INVALID');
569: FND_MSG_PUB.Add;
570: Raise FND_API.G_EXC_ERROR;
571: End if; -- invalid op code
572: -- copy op resources
573: l_UserId := nvl(Fnd_Global.USER_ID, -1);

Line 723: FND_MSG_PUB.Add;

719: l_operation_rec.operation_yield_enabled := l_StdOp_rec.operation_yield_enabled;
720: End loop; -- copy standard operation
721: If not l_StdOpFound then
722: Fnd_Message.Set_Name('BOM', 'BOM_STD_OP_ID_INVALID');
723: FND_MSG_PUB.Add;
724: Raise FND_API.G_EXC_ERROR;
725: End if; -- invalid op code
726: End if; -- referenced
727:

Line 734: FND_MSG_PUB.Add;

730: P_RtgSeqId => l_operation_rec.routing_sequence_id,
731: P_DeptId => l_operation_rec.department_id,
732: P_EffDate => l_operation_rec.new_effectivity_date) loop
733: Fnd_Message.Set_Name('BOM', 'BOM_DEPT_ID_INVALID');
734: FND_MSG_PUB.Add;
735: Raise FND_API.G_EXC_ERROR;
736: End loop; -- invalid department
737:
738: -- validate operation details

Line 758: FND_MSG_PUB.Add;

754: or (l_operation_rec.include_in_rollup not in (1,2))
755: or (l_operation_rec.operation_yield_enabled not in (1,2))
756: then
757: Fnd_Message.Set_Name('BOM', 'BOM_OPERATION_ERROR');
758: FND_MSG_PUB.Add;
759: Raise FND_API.G_EXC_ERROR;
760: End if; -- etc, etc, etc
761:
762: -- CFM validation

Line 802: FND_MSG_PUB.Add;

798: If nvl(l_operation_rec.operation_type, g_event) <> g_event and
799: (l_operation_rec.process_op_seq_id is not null or
800: l_operation_rec.line_op_seq_id is not null) then
801: Fnd_Message.Set_Name('BOM', 'BOM_PARENT_OP_NULL');
802: FND_MSG_PUB.Add;
803: Raise FND_API.G_EXC_ERROR;
804: End if; -- only events can have parents
805:
806: For l_process_rec in l_parents_csr(

Line 809: FND_MSG_PUB.Add;

805:
806: For l_process_rec in l_parents_csr(
807: P_ParentSeqId => l_operation_rec.process_op_seq_id) loop
808: Fnd_Message.Set_Name('BOM', 'BOM_PARENT_OP_INVALID');
809: FND_MSG_PUB.Add;
810: Raise FND_API.G_EXC_ERROR;
811: End loop; -- invalid process
812:
813: For l_LineOp_rec in l_parents_csr(

Line 816: FND_MSG_PUB.Add;

812:
813: For l_LineOp_rec in l_parents_csr(
814: P_ParentSeqId => l_operation_rec.line_op_seq_id) loop
815: Fnd_Message.Set_Name('BOM', 'BOM_PARENT_OP_INVALID');
816: FND_MSG_PUB.Add;
817: Raise FND_API.G_EXC_ERROR;
818: End loop; -- invalid line operation
819:
820: x_operation_rec := l_operation_rec;

Line 830: FND_MSG_PUB.Count_And_Get(

826: COMMIT WORK;
827: END IF;
828:
829: -- Standard call to get message count and if count is 1, get message info.
830: FND_MSG_PUB.Count_And_Get(
831: p_count => x_msg_count,
832: p_data => x_msg_data
833: );
834: EXCEPTION

Line 838: FND_MSG_PUB.Count_And_Get(

834: EXCEPTION
835: WHEN FND_API.G_EXC_ERROR THEN
836: ROLLBACK TO ValidateOperation_Pvt;
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: FND_MSG_PUB.Count_And_Get(
839: p_count => x_msg_count,
840: p_data => x_msg_data
841: );
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 845: FND_MSG_PUB.Count_And_Get(

841: );
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
843: ROLLBACK TO ValidateOperation_Pvt;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: FND_MSG_PUB.Count_And_Get(
846: p_count => x_msg_count,
847: p_data => x_msg_data
848: );
849: WHEN OTHERS THEN

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

848: );
849: WHEN OTHERS THEN
850: ROLLBACK TO ValidateOperation_Pvt;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
853: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
854: END IF;
855: FND_MSG_PUB.Count_And_Get(
856: p_count => x_msg_count,

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

849: WHEN OTHERS THEN
850: ROLLBACK TO ValidateOperation_Pvt;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
853: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
854: END IF;
855: FND_MSG_PUB.Count_And_Get(
856: p_count => x_msg_count,
857: p_data => x_msg_data

Line 855: FND_MSG_PUB.Count_And_Get(

851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
853: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
854: END IF;
855: FND_MSG_PUB.Count_And_Get(
856: p_count => x_msg_count,
857: p_data => x_msg_data
858: );
859: End ValidateOperation;

Line 897: FND_MSG_PUB.initialize;

893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;
895: -- Initialize message list if p_init_msg_list is set to TRUE.
896: IF FND_API.to_Boolean(p_init_msg_list) THEN
897: FND_MSG_PUB.initialize;
898: END IF;
899: -- Initialize API return status to success
900: x_return_status := FND_API.G_RET_STS_SUCCESS;
901:

Line 1283: FND_MSG_PUB.Count_And_Get(

1279: IF FND_API.To_Boolean(p_commit) THEN
1280: COMMIT WORK;
1281: END IF;
1282: -- Standard call to get message count and if count is 1, get message info.
1283: FND_MSG_PUB.Count_And_Get(
1284: p_count => x_msg_count,
1285: p_data => x_msg_data
1286: );
1287: EXCEPTION

Line 1291: FND_MSG_PUB.Count_And_Get(

1287: EXCEPTION
1288: WHEN FND_API.G_EXC_ERROR THEN
1289: ROLLBACK TO CreateOperation_Pvt;
1290: x_return_status := FND_API.G_RET_STS_ERROR;
1291: FND_MSG_PUB.Count_And_Get(
1292: p_count => x_msg_count,
1293: p_data => x_msg_data
1294: );
1295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1298: FND_MSG_PUB.Count_And_Get(

1294: );
1295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1296: ROLLBACK TO CreateOperation_Pvt;
1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: FND_MSG_PUB.Count_And_Get(
1299: p_count => x_msg_count,
1300: p_data => x_msg_data
1301: );
1302: WHEN OTHERS THEN

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

1301: );
1302: WHEN OTHERS THEN
1303: ROLLBACK TO CreateOperation_Pvt;
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1306: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1307: END IF;
1308: FND_MSG_PUB.Count_And_Get(
1309: p_count => x_msg_count,

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

1302: WHEN OTHERS THEN
1303: ROLLBACK TO CreateOperation_Pvt;
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1306: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1307: END IF;
1308: FND_MSG_PUB.Count_And_Get(
1309: p_count => x_msg_count,
1310: p_data => x_msg_data

Line 1308: FND_MSG_PUB.Count_And_Get(

1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1306: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1307: END IF;
1308: FND_MSG_PUB.Count_And_Get(
1309: p_count => x_msg_count,
1310: p_data => x_msg_data
1311: );
1312: End CreateOperation;

Line 1362: FND_MSG_PUB.initialize;

1358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1359: END IF;
1360: -- Initialize message list if p_init_msg_list is set to TRUE.
1361: IF FND_API.to_Boolean(p_init_msg_list) THEN
1362: FND_MSG_PUB.initialize;
1363: END IF;
1364: -- Initialize API return status to success
1365: x_return_status := FND_API.G_RET_STS_SUCCESS;
1366:

Line 1589: FND_MSG_PUB.Add;

1585: End loop; -- get old values
1586:
1587: If not l_OperFound then
1588: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_OPERATION');
1589: FND_MSG_PUB.Add;
1590: Raise FND_API.G_EXC_ERROR;
1591: End if; -- missing operation
1592:
1593: If p_validation_level > FND_API.G_VALID_LEVEL_NONE then

Line 1712: FND_MSG_PUB.Count_And_Get(

1708: IF FND_API.To_Boolean( p_commit ) THEN
1709: COMMIT WORK;
1710: END IF;
1711: -- Standard call to get message count and if count is 1, get message info.
1712: FND_MSG_PUB.Count_And_Get(
1713: p_count => x_msg_count,
1714: p_data => x_msg_data
1715: );
1716: EXCEPTION

Line 1720: FND_MSG_PUB.Count_And_Get(

1716: EXCEPTION
1717: WHEN FND_API.G_EXC_ERROR THEN
1718: ROLLBACK TO UpdateOperation_Pvt;
1719: x_return_status := FND_API.G_RET_STS_ERROR;
1720: FND_MSG_PUB.Count_And_Get(
1721: p_count => x_msg_count,
1722: p_data => x_msg_data
1723: );
1724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1727: FND_MSG_PUB.Count_And_Get(

1723: );
1724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1725: ROLLBACK TO UpdateOperation_Pvt;
1726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1727: FND_MSG_PUB.Count_And_Get(
1728: p_count => x_msg_count,
1729: p_data => x_msg_data
1730: );
1731: WHEN OTHERS THEN

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

1730: );
1731: WHEN OTHERS THEN
1732: ROLLBACK TO UpdateOperation_Pvt;
1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1734: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1735: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1736: END IF;
1737: FND_MSG_PUB.Count_And_Get(
1738: p_count => x_msg_count,

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

1731: WHEN OTHERS THEN
1732: ROLLBACK TO UpdateOperation_Pvt;
1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1734: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1735: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1736: END IF;
1737: FND_MSG_PUB.Count_And_Get(
1738: p_count => x_msg_count,
1739: p_data => x_msg_data

Line 1737: FND_MSG_PUB.Count_And_Get(

1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1734: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1735: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1736: END IF;
1737: FND_MSG_PUB.Count_And_Get(
1738: p_count => x_msg_count,
1739: p_data => x_msg_data
1740: );
1741: End UpdateOperation;

Line 1805: FND_MSG_PUB.initialize;

1801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1802: END IF;
1803: -- Initialize message list if p_init_msg_list is set to TRUE.
1804: IF FND_API.to_Boolean(p_init_msg_list) THEN
1805: FND_MSG_PUB.initialize;
1806: END IF;
1807: -- Initialize API return status to success
1808: x_return_status := FND_API.G_RET_STS_SUCCESS;
1809:

Line 1864: Fnd_Msg_Pub.Add_Exc_Msg (

1860: user_id => l_UserId,
1861: err_text => l_msg_data
1862: );
1863: If l_ReturnCode <> 0 then
1864: Fnd_Msg_Pub.Add_Exc_Msg (
1865: p_pkg_name => 'MODAL_DELETE',
1866: p_procedure_name => 'DELETE_MANAGER_OI',
1867: p_error_text => l_msg_data
1868: );

Line 1875: FND_MSG_PUB.Add;

1871: End loop; -- Add to delete group
1872:
1873: If not l_OperFound then
1874: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_OPERATION');
1875: FND_MSG_PUB.Add;
1876: Raise FND_API.G_EXC_ERROR;
1877: End if; -- missing operation
1878:
1879: x_operation_rec := l_operation_rec;

Line 1887: FND_MSG_PUB.Count_And_Get(

1883: IF FND_API.To_Boolean(p_commit) THEN
1884: COMMIT WORK;
1885: END IF;
1886: -- Standard call to get message count and if count is 1, get message info.
1887: FND_MSG_PUB.Count_And_Get(
1888: p_count => x_msg_count,
1889: p_data => x_msg_data
1890: );
1891: EXCEPTION

Line 1895: FND_MSG_PUB.Count_And_Get(

1891: EXCEPTION
1892: WHEN FND_API.G_EXC_ERROR THEN
1893: ROLLBACK TO DeleteOperation_Pvt;
1894: x_return_status := FND_API.G_RET_STS_ERROR;
1895: FND_MSG_PUB.Count_And_Get(
1896: p_count => x_msg_count,
1897: p_data => x_msg_data
1898: );
1899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1902: FND_MSG_PUB.Count_And_Get(

1898: );
1899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1900: ROLLBACK TO DeleteOperation_Pvt;
1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1902: FND_MSG_PUB.Count_And_Get(
1903: p_count => x_msg_count,
1904: p_data => x_msg_data
1905: );
1906: WHEN OTHERS THEN

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

1905: );
1906: WHEN OTHERS THEN
1907: ROLLBACK TO DeleteOperation_Pvt;
1908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1909: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1910: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1911: END IF;
1912: FND_MSG_PUB.Count_And_Get(
1913: p_count => x_msg_count,

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

1906: WHEN OTHERS THEN
1907: ROLLBACK TO DeleteOperation_Pvt;
1908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1909: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1910: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1911: END IF;
1912: FND_MSG_PUB.Count_And_Get(
1913: p_count => x_msg_count,
1914: p_data => x_msg_data

Line 1912: FND_MSG_PUB.Count_And_Get(

1908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1909: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1910: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1911: END IF;
1912: FND_MSG_PUB.Count_And_Get(
1913: p_count => x_msg_count,
1914: p_data => x_msg_data
1915: );
1916: End DeleteOperation;