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 727: FND_MSG_PUB.Add;

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

Line 738: FND_MSG_PUB.Add;

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

Line 762: FND_MSG_PUB.Add;

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

Line 806: FND_MSG_PUB.Add;

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

Line 813: FND_MSG_PUB.Add;

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

Line 820: FND_MSG_PUB.Add;

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

Line 834: FND_MSG_PUB.Count_And_Get(

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

Line 842: FND_MSG_PUB.Count_And_Get(

838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN
840: ROLLBACK TO ValidateOperation_Pvt;
841: x_return_status := FND_API.G_RET_STS_ERROR;
842: FND_MSG_PUB.Count_And_Get(
843: p_count => x_msg_count,
844: p_data => x_msg_data
845: );
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 849: FND_MSG_PUB.Count_And_Get(

845: );
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847: ROLLBACK TO ValidateOperation_Pvt;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: FND_MSG_PUB.Count_And_Get(
850: p_count => x_msg_count,
851: p_data => x_msg_data
852: );
853: WHEN OTHERS THEN

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

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

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

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

Line 859: FND_MSG_PUB.Count_And_Get(

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

Line 901: FND_MSG_PUB.initialize;

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

Line 1287: FND_MSG_PUB.Count_And_Get(

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

Line 1295: FND_MSG_PUB.Count_And_Get(

1291: EXCEPTION
1292: WHEN FND_API.G_EXC_ERROR THEN
1293: ROLLBACK TO CreateOperation_Pvt;
1294: x_return_status := FND_API.G_RET_STS_ERROR;
1295: FND_MSG_PUB.Count_And_Get(
1296: p_count => x_msg_count,
1297: p_data => x_msg_data
1298: );
1299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1302: FND_MSG_PUB.Count_And_Get(

1298: );
1299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1300: ROLLBACK TO CreateOperation_Pvt;
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1302: FND_MSG_PUB.Count_And_Get(
1303: p_count => x_msg_count,
1304: p_data => x_msg_data
1305: );
1306: WHEN OTHERS THEN

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

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

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

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

Line 1312: FND_MSG_PUB.Count_And_Get(

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

Line 1366: FND_MSG_PUB.initialize;

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

Line 1593: FND_MSG_PUB.Add;

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

Line 1716: FND_MSG_PUB.Count_And_Get(

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

Line 1724: FND_MSG_PUB.Count_And_Get(

1720: EXCEPTION
1721: WHEN FND_API.G_EXC_ERROR THEN
1722: ROLLBACK TO UpdateOperation_Pvt;
1723: x_return_status := FND_API.G_RET_STS_ERROR;
1724: FND_MSG_PUB.Count_And_Get(
1725: p_count => x_msg_count,
1726: p_data => x_msg_data
1727: );
1728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1731: FND_MSG_PUB.Count_And_Get(

1727: );
1728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1729: ROLLBACK TO UpdateOperation_Pvt;
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731: FND_MSG_PUB.Count_And_Get(
1732: p_count => x_msg_count,
1733: p_data => x_msg_data
1734: );
1735: WHEN OTHERS THEN

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

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

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

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

Line 1741: FND_MSG_PUB.Count_And_Get(

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

Line 1809: FND_MSG_PUB.initialize;

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

Line 1868: Fnd_Msg_Pub.Add_Exc_Msg (

1864: user_id => l_UserId,
1865: err_text => l_msg_data
1866: );
1867: If l_ReturnCode <> 0 then
1868: Fnd_Msg_Pub.Add_Exc_Msg (
1869: p_pkg_name => 'MODAL_DELETE',
1870: p_procedure_name => 'DELETE_MANAGER_OI',
1871: p_error_text => l_msg_data
1872: );

Line 1879: FND_MSG_PUB.Add;

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

Line 1891: FND_MSG_PUB.Count_And_Get(

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

Line 1899: FND_MSG_PUB.Count_And_Get(

1895: EXCEPTION
1896: WHEN FND_API.G_EXC_ERROR THEN
1897: ROLLBACK TO DeleteOperation_Pvt;
1898: x_return_status := FND_API.G_RET_STS_ERROR;
1899: FND_MSG_PUB.Count_And_Get(
1900: p_count => x_msg_count,
1901: p_data => x_msg_data
1902: );
1903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1906: FND_MSG_PUB.Count_And_Get(

1902: );
1903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1904: ROLLBACK TO DeleteOperation_Pvt;
1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1906: FND_MSG_PUB.Count_And_Get(
1907: p_count => x_msg_count,
1908: p_data => x_msg_data
1909: );
1910: WHEN OTHERS THEN

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

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

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

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

Line 1916: FND_MSG_PUB.Count_And_Get(

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