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 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 629: standard_rate_flag,

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

Line 665: Where standard_operation_id = l_operation_rec.standard_operation_id;

661: l_ProgramUpdate,
662: schedule_seq_num, -- Bug#14550670
663: principle_flag -- Bug#14550670
664: From bom_std_op_resources
665: Where standard_operation_id = l_operation_rec.standard_operation_id;
666: -- copy attachment
667: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
668: X_from_entity_name => 'BOM_STANDARD_OPERATIONS',
669: X_from_pk1_value => to_char(

Line 668: X_from_entity_name => 'BOM_STANDARD_OPERATIONS',

664: From bom_std_op_resources
665: Where standard_operation_id = l_operation_rec.standard_operation_id;
666: -- copy attachment
667: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
668: X_from_entity_name => 'BOM_STANDARD_OPERATIONS',
669: X_from_pk1_value => to_char(
670: l_operation_rec.standard_operation_id),
671: X_from_pk2_value => null,
672: X_from_pk3_value => null,

Line 670: l_operation_rec.standard_operation_id),

666: -- copy attachment
667: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
668: X_from_entity_name => 'BOM_STANDARD_OPERATIONS',
669: X_from_pk1_value => to_char(
670: l_operation_rec.standard_operation_id),
671: X_from_pk2_value => null,
672: X_from_pk3_value => null,
673: X_from_pk4_value => null,
674: X_from_pk5_value => null,

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

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

Line 696: P_StdOpId => l_operation_rec.standard_operation_id) loop

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

Line 724: End loop; -- copy standard operation

720: l_operation_rec.attribute14 := l_StdOp_rec.attribute14;
721: l_operation_rec.attribute15 := l_StdOp_rec.attribute15;
722: l_operation_rec.backflush_flag := l_StdOp_rec.backflush_flag;
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;

Line 828: -- Standard check of p_commit.

824: x_operation_rec := l_operation_rec;
825:
826: -- End of API body.
827:
828: -- Standard check of p_commit.
829: IF FND_API.To_Boolean(p_commit) THEN
830: COMMIT WORK;
831: END IF;
832:

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

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

Line 892: -- Standard Start of API savepoint

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

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

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

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

924: Fnd_Api.G_Miss_Num then
925: l_operation_rec.new_operation_seq_num := l_operation_rec.operation_seq_num;
926: End if;
927:
928: If l_operation_rec.standard_operation_id = Fnd_Api.G_Miss_Num then
929: l_operation_rec.standard_operation_id := null;
930: End if;
931:
932: If l_operation_rec.department_id = Fnd_Api.G_Miss_Num then

Line 929: l_operation_rec.standard_operation_id := null;

925: l_operation_rec.new_operation_seq_num := l_operation_rec.operation_seq_num;
926: End if;
927:
928: If l_operation_rec.standard_operation_id = Fnd_Api.G_Miss_Num then
929: l_operation_rec.standard_operation_id := null;
930: End if;
931:
932: If l_operation_rec.department_id = Fnd_Api.G_Miss_Num then
933: l_operation_rec.department_id := null;

Line 1175: standard_operation_id,

1171: last_updated_by,
1172: creation_date,
1173: created_by,
1174: last_update_login,
1175: standard_operation_id,
1176: department_id,
1177: operation_lead_time_percent,
1178: minimum_transfer_quantity,
1179: count_point_type,

Line 1231: l_operation_rec.standard_operation_id,

1227: l_UserId,
1228: sysdate,
1229: l_UserId,
1230: l_LoginId,
1231: l_operation_rec.standard_operation_id,
1232: l_operation_rec.department_id,
1233: l_operation_rec.operation_lead_time_percent,
1234: l_operation_rec.minimum_transfer_quantity,
1235: l_operation_rec.count_point_type,

Line 1282: -- Standard check of p_commit.

1278:
1279: x_operation_rec := l_operation_rec;
1280: -- End of API body.
1281:
1282: -- Standard check of p_commit.
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.

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

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

Line 1357: -- Standard Start of API savepoint

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

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

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

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

1412: l_operation_rec.new_operation_seq_num :=
1413: l_OldOper_rec.operation_seq_num;
1414: End if;
1415:
1416: If l_operation_rec.standard_operation_id = Fnd_Api.G_Miss_Num then
1417: l_operation_rec.standard_operation_id :=
1418: l_OldOper_rec.standard_operation_id;
1419: End if;
1420:

Line 1417: l_operation_rec.standard_operation_id :=

1413: l_OldOper_rec.operation_seq_num;
1414: End if;
1415:
1416: If l_operation_rec.standard_operation_id = Fnd_Api.G_Miss_Num then
1417: l_operation_rec.standard_operation_id :=
1418: l_OldOper_rec.standard_operation_id;
1419: End if;
1420:
1421: If l_operation_rec.department_id = Fnd_Api.G_Miss_Num then

Line 1418: l_OldOper_rec.standard_operation_id;

1414: End if;
1415:
1416: If l_operation_rec.standard_operation_id = Fnd_Api.G_Miss_Num then
1417: l_operation_rec.standard_operation_id :=
1418: l_OldOper_rec.standard_operation_id;
1419: End if;
1420:
1421: If l_operation_rec.department_id = Fnd_Api.G_Miss_Num then
1422: l_operation_rec.department_id := l_OldOper_rec.department_id;

Line 1637: standard_operation_id = l_operation_rec.standard_operation_id,

1633: last_updated_by = l_UserId,
1634: creation_date = sysdate,
1635: created_by = l_UserId,
1636: last_update_login = l_LoginId,
1637: standard_operation_id = l_operation_rec.standard_operation_id,
1638: department_id = l_operation_rec.department_id,
1639: operation_lead_time_percent =
1640: l_operation_rec.operation_lead_time_percent,
1641: minimum_transfer_quantity = l_operation_rec.minimum_transfer_quantity,

Line 1711: -- Standard check of p_commit.

1707: --bugFix 1690706 End
1708: x_operation_rec := l_operation_rec;
1709: -- End of API body.
1710:
1711: -- Standard check of p_commit.
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.

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

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

Line 1800: -- Standard Start of API savepoint

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

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

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

Line 1886: -- Standard check of p_commit.

1882:
1883: x_operation_rec := l_operation_rec;
1884: -- End of API body.
1885:
1886: -- Standard check of p_commit.
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.

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

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