DBA Data[Home] [Help]

APPS.BOM_OPERATION_PVT dependencies on STANDARD

Line 60: select bso.standard_operation_id

56: nvl(P_Alternate, 'Primary Alternate');
57:
58: cursor l_StdOp_csr(P_Code varchar2, P_OpType number,
59: P_RtgSeqId number) is
60: select bso.standard_operation_id
61: from bom_standard_operations bso,
62: bom_operational_routings bor
63: where bso.organization_id = bor.organization_id
64: and nvl(bso.line_id, -1) = nvl(bor.line_id, -1)

Line 61: from bom_standard_operations bso,

57:
58: cursor l_StdOp_csr(P_Code varchar2, P_OpType number,
59: P_RtgSeqId number) is
60: select bso.standard_operation_id
61: from bom_standard_operations bso,
62: bom_operational_routings bor
63: where bso.organization_id = bor.organization_id
64: and nvl(bso.line_id, -1) = nvl(bor.line_id, -1)
65: and nvl(bso.operation_type, g_event) =

Line 70: -- Standard call to check for call compatibility.

66: nvl(P_OpType, g_event)
67: and bso.operation_code = P_Code
68: and bor.routing_sequence_id = P_RtgSeqId;
69: BEGIN
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
72: G_PKG_NAME) THEN
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;

Line 202: l_operation_rec.standard_operation_id := null;

198: End if;
199:
200: If nvl(l_operation_rec.operation_code, Fnd_Api.G_Miss_Char) <>
201: Fnd_Api.G_Miss_Char then
202: l_operation_rec.standard_operation_id := null;
203: For l_StdOp_rec in l_StdOp_csr(
204: P_Code => l_operation_rec.operation_code,
205: P_OpType => l_operation_rec.operation_type,
206: P_RtgSeqId => l_operation_rec.routing_sequence_id) loop

Line 207: l_operation_rec.standard_operation_id :=

203: For l_StdOp_rec in l_StdOp_csr(
204: P_Code => l_operation_rec.operation_code,
205: P_OpType => l_operation_rec.operation_type,
206: P_RtgSeqId => l_operation_rec.routing_sequence_id) loop
207: l_operation_rec.standard_operation_id :=
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');

Line 208: l_StdOp_rec.standard_operation_id;

204: P_Code => l_operation_rec.operation_code,
205: P_OpType => l_operation_rec.operation_type,
206: P_RtgSeqId => l_operation_rec.routing_sequence_id) loop
207: l_operation_rec.standard_operation_id :=
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;

Line 209: End loop; -- get standard operation id

205: P_OpType => l_operation_rec.operation_type,
206: P_RtgSeqId => l_operation_rec.routing_sequence_id) loop
207: l_operation_rec.standard_operation_id :=
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;

Line 210: If l_operation_rec.standard_operation_id is null then

206: P_RtgSeqId => l_operation_rec.routing_sequence_id) loop
207: l_operation_rec.standard_operation_id :=
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

Line 220: -- Standard call to get message count and if count is 1, get message info.

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

Line 324: Select bos.standard_operation_id,

320: l_PrevStdOp number := null;
321: l_PrevStdCode varchar2(4) := null;
322: l_PrevRefFlag number := null;
323: cursor l_OldOpCode_csr(P_OpSeqId number) is
324: Select bos.standard_operation_id,
325: bso.operation_code,
326: nvl(bos.reference_flag, 2) reference_flag
327: From bom_operation_sequences bos,
328: bom_standard_operations bso

Line 328: bom_standard_operations bso

324: Select bos.standard_operation_id,
325: bso.operation_code,
326: nvl(bos.reference_flag, 2) reference_flag
327: From bom_operation_sequences bos,
328: bom_standard_operations bso
329: Where operation_sequence_id = P_OpSeqId
330: And bos.standard_operation_id =
331: bso.standard_operation_id;
332: cursor l_OpResources_csr(P_OpSeqId number) is

Line 330: And bos.standard_operation_id =

326: nvl(bos.reference_flag, 2) reference_flag
327: From bom_operation_sequences bos,
328: bom_standard_operations bso
329: Where operation_sequence_id = P_OpSeqId
330: And bos.standard_operation_id =
331: bso.standard_operation_id;
332: cursor l_OpResources_csr(P_OpSeqId number) is
333: Select 'x' dummy
334: From dual

Line 331: bso.standard_operation_id;

327: From bom_operation_sequences bos,
328: bom_standard_operations bso
329: Where operation_sequence_id = P_OpSeqId
330: And bos.standard_operation_id =
331: bso.standard_operation_id;
332: cursor l_OpResources_csr(P_OpSeqId number) is
333: Select 'x' dummy
334: From dual
335: Where exists(

Line 372: from bom_standard_operations bso,

368: bso.ATTRIBUTE13,
369: bso.ATTRIBUTE14,
370: bso.ATTRIBUTE15,
371: bso.OPERATION_YIELD_ENABLED
372: from bom_standard_operations bso,
373: bom_operational_routings bor
374: where bso.standard_operation_id = P_StdOpId
375: and bor.routing_sequence_id = P_RtgSeqId
376: and bso.organization_id = bor.organization_id

Line 374: where bso.standard_operation_id = P_StdOpId

370: bso.ATTRIBUTE15,
371: bso.OPERATION_YIELD_ENABLED
372: from bom_standard_operations bso,
373: bom_operational_routings bor
374: where bso.standard_operation_id = P_StdOpId
375: and bor.routing_sequence_id = P_RtgSeqId
376: and bso.organization_id = bor.organization_id
377: and nvl(bso.line_id, -1) = nvl(bor.line_id, -1)
378: and nvl(bso.operation_type, g_event) =

Line 405: -- Standard Start of API savepoint

401: Select 'x' dummy
402: from bom_operation_resources
403: where operation_sequence_id = P_ParentSeqId;
404: BEGIN
405: -- Standard Start of API savepoint
406: SAVEPOINT ValidateOperation_Pvt;
407: -- Standard call to check for call compatibility.
408: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
409: G_PKG_NAME) THEN

Line 407: -- Standard call to check for call compatibility.

403: where operation_sequence_id = P_ParentSeqId;
404: BEGIN
405: -- Standard Start of API savepoint
406: SAVEPOINT ValidateOperation_Pvt;
407: -- Standard call to check for call compatibility.
408: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
409: G_PKG_NAME) THEN
410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411: END IF;

Line 499: l_operation_rec.standard_operation_id is null then

495: End loop;
496:
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

Line 506: If l_operation_rec.standard_operation_id is null then

502: Raise FND_API.G_EXC_ERROR;
503: End if; -- mandatory op code
504:
505: -- can not reference null op code
506: If l_operation_rec.standard_operation_id is null then
507: l_operation_rec.reference_flag := g_no;
508: End if; -- null op code
509:
510: -- Copy and reference logic

Line 512: -- get previous standard operation

508: End if; -- null op code
509:
510: -- Copy and reference logic
511:
512: -- get previous standard operation
513: For l_OldOp_rec in l_OldOpCode_csr(
514: P_OpSeqId => l_operation_rec.operation_sequence_id) loop
515: l_PrevStdOp := l_OldOp_rec.standard_operation_id;
516: l_PrevRefFlag := l_OldOp_rec.reference_flag;

Line 515: l_PrevStdOp := l_OldOp_rec.standard_operation_id;

511:
512: -- get previous standard operation
513: For l_OldOp_rec in l_OldOpCode_csr(
514: P_OpSeqId => l_operation_rec.operation_sequence_id) loop
515: l_PrevStdOp := l_OldOp_rec.standard_operation_id;
516: l_PrevRefFlag := l_OldOp_rec.reference_flag;
517: l_PrevStdCode := l_OldOp_rec.operation_code;
518: End loop;
519:

Line 528: -- Standard Operation has changed to not null value

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
529: If nvl(l_PrevStdOp, -1) <> l_operation_rec.standard_operation_id then
530: -- check resources
531: For l_resource_rec in l_OpResources_csr(
532: P_OpSeqId => l_operation_rec.operation_sequence_id) loop

Line 529: If nvl(l_PrevStdOp, -1) <> l_operation_rec.standard_operation_id then

525: Raise FND_API.G_EXC_ERROR;
526: End if;
527:
528: -- Standard Operation has changed to not null value
529: If nvl(l_PrevStdOp, -1) <> l_operation_rec.standard_operation_id then
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');

Line 541: P_StdOpId => l_operation_rec.standard_operation_id) loop

537: l_StdOpFound := false;
538: For l_StdOp_rec in l_StdOp_csr(
539: P_OpType => l_operation_rec.operation_type,
540: P_RtgSeqId => l_operation_rec.routing_sequence_id,
541: P_StdOpId => l_operation_rec.standard_operation_id) loop
542: l_StdOpFound := true;
543: l_operation_rec.department_id := nvl(l_operation_rec.department_id,l_StdOp_rec.department_id);
544: l_operation_rec.minimum_transfer_quantity :=nvl(l_operation_rec.minimum_transfer_quantity,l_StdOp_rec.minimum_transfer_quantity);
545: l_operation_rec.count_point_type := nvl(l_operation_rec.count_point_type,l_StdOp_rec.count_point_type);

Line 566: End loop; -- copy standard operation

562: l_operation_rec.attribute14 := nvl(l_operation_rec.attribute14,l_StdOp_rec.attribute14);
563: l_operation_rec.attribute15 := nvl(l_operation_rec.attribute15,l_StdOp_rec.attribute15);
564: l_operation_rec.backflush_flag := nvl(l_operation_rec.backflush_flag,l_StdOp_rec.backflush_flag);
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;

Line 589: standard_rate_flag,

585: operation_sequence_id,
586: resource_seq_num,
587: resource_id,
588: activity_id,
589: standard_rate_flag,
590: assigned_units,
591: usage_rate_or_amount,
592: usage_rate_or_amount_inverse,
593: basis_type,

Line 627: standard_rate_flag,

623: l_operation_rec.operation_sequence_id,
624: resource_seq_num,
625: resource_id,
626: activity_id,
627: standard_rate_flag,
628: assigned_units,
629: usage_rate_or_amount,
630: usage_rate_or_amount_inverse,
631: basis_type,

Line 661: Where standard_operation_id = l_operation_rec.standard_operation_id;

657: l_ApplicationId,
658: l_ProgramId,
659: l_ProgramUpdate
660: From bom_std_op_resources
661: Where standard_operation_id = l_operation_rec.standard_operation_id;
662: -- copy attachment
663: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
664: X_from_entity_name => 'BOM_STANDARD_OPERATIONS',
665: X_from_pk1_value => to_char(

Line 664: X_from_entity_name => 'BOM_STANDARD_OPERATIONS',

660: From bom_std_op_resources
661: Where standard_operation_id = l_operation_rec.standard_operation_id;
662: -- copy attachment
663: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
664: X_from_entity_name => 'BOM_STANDARD_OPERATIONS',
665: X_from_pk1_value => to_char(
666: l_operation_rec.standard_operation_id),
667: X_from_pk2_value => null,
668: X_from_pk3_value => null,

Line 666: l_operation_rec.standard_operation_id),

662: -- copy attachment
663: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
664: X_from_entity_name => 'BOM_STANDARD_OPERATIONS',
665: X_from_pk1_value => to_char(
666: l_operation_rec.standard_operation_id),
667: X_from_pk2_value => null,
668: X_from_pk3_value => null,
669: X_from_pk4_value => null,
670: X_from_pk5_value => null,

Line 686: -- columns corresponding to columns in Standard Operations should not be

682: X_request_id => l_RequestId
683: );
684: End if; -- copy
685:
686: -- columns corresponding to columns in Standard Operations should not be
687: -- changed when referenced.
688: If l_operation_rec.reference_flag = g_yes then
689: For l_StdOp_rec in l_StdOp_csr(
690: P_OpType => l_operation_rec.operation_type,

Line 692: P_StdOpId => l_operation_rec.standard_operation_id) loop

688: If l_operation_rec.reference_flag = g_yes then
689: For l_StdOp_rec in l_StdOp_csr(
690: P_OpType => l_operation_rec.operation_type,
691: P_RtgSeqId => l_operation_rec.routing_sequence_id,
692: P_StdOpId => l_operation_rec.standard_operation_id) loop
693: l_StdOpFound := true;
694: l_operation_rec.department_id := l_StdOp_rec.department_id;
695: l_operation_rec.minimum_transfer_quantity :=
696: l_StdOp_rec.minimum_transfer_quantity;

Line 720: End loop; -- copy standard operation

716: l_operation_rec.attribute14 := l_StdOp_rec.attribute14;
717: l_operation_rec.attribute15 := l_StdOp_rec.attribute15;
718: l_operation_rec.backflush_flag := l_StdOp_rec.backflush_flag;
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;

Line 824: -- Standard check of p_commit.

820: x_operation_rec := l_operation_rec;
821:
822: -- End of API body.
823:
824: -- Standard check of p_commit.
825: IF FND_API.To_Boolean(p_commit) THEN
826: COMMIT WORK;
827: END IF;
828:

Line 829: -- Standard call to get message count and if count is 1, get message info.

825: IF FND_API.To_Boolean(p_commit) THEN
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: );

Line 888: -- Standard Start of API savepoint

884: cursor l_NewOper_csr is
885: Select bom_operation_sequences_s.nextval new_op_seq_id
886: from dual;
887: BEGIN
888: -- Standard Start of API savepoint
889: SAVEPOINT CreateOperation_Pvt;
890: -- Standard call to check for call compatibility.
891: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
892: G_PKG_NAME) THEN

Line 890: -- Standard call to check for call compatibility.

886: from dual;
887: BEGIN
888: -- Standard Start of API savepoint
889: SAVEPOINT CreateOperation_Pvt;
890: -- Standard call to check for call compatibility.
891: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
892: G_PKG_NAME) THEN
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;

Line 924: If l_operation_rec.standard_operation_id = Fnd_Api.G_Miss_Num then

920: Fnd_Api.G_Miss_Num then
921: l_operation_rec.new_operation_seq_num := l_operation_rec.operation_seq_num;
922: End if;
923:
924: If l_operation_rec.standard_operation_id = Fnd_Api.G_Miss_Num then
925: l_operation_rec.standard_operation_id := null;
926: End if;
927:
928: If l_operation_rec.department_id = Fnd_Api.G_Miss_Num then

Line 925: l_operation_rec.standard_operation_id := null;

921: l_operation_rec.new_operation_seq_num := l_operation_rec.operation_seq_num;
922: End if;
923:
924: If l_operation_rec.standard_operation_id = Fnd_Api.G_Miss_Num then
925: l_operation_rec.standard_operation_id := null;
926: End if;
927:
928: If l_operation_rec.department_id = Fnd_Api.G_Miss_Num then
929: l_operation_rec.department_id := null;

Line 1171: standard_operation_id,

1167: last_updated_by,
1168: creation_date,
1169: created_by,
1170: last_update_login,
1171: standard_operation_id,
1172: department_id,
1173: operation_lead_time_percent,
1174: minimum_transfer_quantity,
1175: count_point_type,

Line 1227: l_operation_rec.standard_operation_id,

1223: l_UserId,
1224: sysdate,
1225: l_UserId,
1226: l_LoginId,
1227: l_operation_rec.standard_operation_id,
1228: l_operation_rec.department_id,
1229: l_operation_rec.operation_lead_time_percent,
1230: l_operation_rec.minimum_transfer_quantity,
1231: l_operation_rec.count_point_type,

Line 1278: -- Standard check of p_commit.

1274:
1275: x_operation_rec := l_operation_rec;
1276: -- End of API body.
1277:
1278: -- Standard check of p_commit.
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.

Line 1282: -- Standard call to get message count and if count is 1, get message info.

1278: -- Standard check of p_commit.
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: );

Line 1353: -- Standard Start of API savepoint

1349: g_LineOp, bos.effectivity_date,
1350: P_EffDate));
1351: l_OperFound BOOLEAN := false;
1352: BEGIN
1353: -- Standard Start of API savepoint
1354: SAVEPOINT UpdateOperation_Pvt;
1355: -- Standard call to check for call compatibility.
1356: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1357: G_PKG_NAME) THEN

Line 1355: -- Standard call to check for call compatibility.

1351: l_OperFound BOOLEAN := false;
1352: BEGIN
1353: -- Standard Start of API savepoint
1354: SAVEPOINT UpdateOperation_Pvt;
1355: -- Standard call to check for call compatibility.
1356: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1357: G_PKG_NAME) THEN
1358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1359: END IF;

Line 1412: If l_operation_rec.standard_operation_id = Fnd_Api.G_Miss_Num then

1408: l_operation_rec.new_operation_seq_num :=
1409: l_OldOper_rec.operation_seq_num;
1410: End if;
1411:
1412: If l_operation_rec.standard_operation_id = Fnd_Api.G_Miss_Num then
1413: l_operation_rec.standard_operation_id :=
1414: l_OldOper_rec.standard_operation_id;
1415: End if;
1416:

Line 1413: l_operation_rec.standard_operation_id :=

1409: l_OldOper_rec.operation_seq_num;
1410: End if;
1411:
1412: If l_operation_rec.standard_operation_id = Fnd_Api.G_Miss_Num then
1413: l_operation_rec.standard_operation_id :=
1414: l_OldOper_rec.standard_operation_id;
1415: End if;
1416:
1417: If l_operation_rec.department_id = Fnd_Api.G_Miss_Num then

Line 1414: l_OldOper_rec.standard_operation_id;

1410: End if;
1411:
1412: If l_operation_rec.standard_operation_id = Fnd_Api.G_Miss_Num then
1413: l_operation_rec.standard_operation_id :=
1414: l_OldOper_rec.standard_operation_id;
1415: End if;
1416:
1417: If l_operation_rec.department_id = Fnd_Api.G_Miss_Num then
1418: l_operation_rec.department_id := l_OldOper_rec.department_id;

Line 1633: standard_operation_id = l_operation_rec.standard_operation_id,

1629: last_updated_by = l_UserId,
1630: creation_date = sysdate,
1631: created_by = l_UserId,
1632: last_update_login = l_LoginId,
1633: standard_operation_id = l_operation_rec.standard_operation_id,
1634: department_id = l_operation_rec.department_id,
1635: operation_lead_time_percent =
1636: l_operation_rec.operation_lead_time_percent,
1637: minimum_transfer_quantity = l_operation_rec.minimum_transfer_quantity,

Line 1707: -- Standard check of p_commit.

1703: --bugFix 1690706 End
1704: x_operation_rec := l_operation_rec;
1705: -- End of API body.
1706:
1707: -- Standard check of p_commit.
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.

Line 1711: -- Standard call to get message count and if count is 1, get message info.

1707: -- Standard check of p_commit.
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: );

Line 1796: -- Standard Start of API savepoint

1792: And organization_id = P_OrgId;
1793: l_operation constant number := 5; -- delete type
1794: l_ReturnCode number;
1795: BEGIN
1796: -- Standard Start of API savepoint
1797: SAVEPOINT DeleteOperation_Pvt;
1798: -- Standard call to check for call compatibility.
1799: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1800: G_PKG_NAME) THEN

Line 1798: -- Standard call to check for call compatibility.

1794: l_ReturnCode number;
1795: BEGIN
1796: -- Standard Start of API savepoint
1797: SAVEPOINT DeleteOperation_Pvt;
1798: -- Standard call to check for call compatibility.
1799: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1800: G_PKG_NAME) THEN
1801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1802: END IF;

Line 1882: -- Standard check of p_commit.

1878:
1879: x_operation_rec := l_operation_rec;
1880: -- End of API body.
1881:
1882: -- Standard check of p_commit.
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.

Line 1886: -- Standard call to get message count and if count is 1, get message info.

1882: -- Standard check of p_commit.
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: );