DBA Data[Home] [Help]

APPS.PV_ENTY_ATTR_VALUE_PVT dependencies on STANDARD

Line 79: -- Standard Start of API savepoint

75: l_meaning VARCHAR2(80);
76:
77:
78: BEGIN
79: -- Standard Start of API savepoint
80: SAVEPOINT Create_Attr_Value_PVT;
81:
82: -- Standard call to check for call compatibility.
83: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

78: BEGIN
79: -- Standard Start of API savepoint
80: SAVEPOINT Create_Attr_Value_PVT;
81:
82: -- Standard call to check for call compatibility.
83: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
84: p_api_version_number,
85: l_api_name,
86: G_PKG_NAME)

Line 277: -- Standard check for p_commit

273: --
274: -- End of API body
275: --
276:
277: -- Standard check for p_commit
278: IF FND_API.to_Boolean( p_commit )
279: THEN
280: COMMIT WORK;
281: END IF;

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

285: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
286: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
287: END IF;
288:
289: -- Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get (
291: p_count => x_msg_count
292: ,p_data => x_msg_data
293: );

Line 304: -- Standard call to get message count and if count=1, get the message

300: */
301: WHEN FND_API.G_EXC_ERROR THEN
302: ROLLBACK TO Create_Attr_Value_PVT;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: -- Standard call to get message count and if count=1, get the message
305: FND_MSG_PUB.Count_And_Get (
306: p_encoded => FND_API.G_FALSE
307: ,p_count => x_msg_count
308: ,p_data => x_msg_data

Line 314: -- Standard call to get message count and if count=1, get the message

310:
311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
312: ROLLBACK TO Create_Attr_Value_PVT;
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: -- Standard call to get message count and if count=1, get the message
315: FND_MSG_PUB.Count_And_Get (
316: p_encoded => FND_API.G_FALSE
317: ,p_count => x_msg_count
318: ,p_data => x_msg_data

Line 328: -- Standard call to get message count and if count=1, get the message

324: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
325: THEN
326: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
327: END IF;
328: -- Standard call to get message count and if count=1, get the message
329: FND_MSG_PUB.Count_And_Get (
330: p_encoded => FND_API.G_FALSE
331: ,p_count => x_msg_count
332: ,p_data => x_msg_data

Line 368: -- Standard Start of API savepoint

364: l_tar_enty_attr_val_rec PV_Enty_Attr_Value_PVT.enty_attr_val_rec_type := p_enty_attr_val_rec;
365: l_rowid ROWID;
366:
367: BEGIN
368: -- Standard Start of API savepoint
369: SAVEPOINT Update_Attr_Value_PVT;
370:
371: -- Standard call to check for call compatibility.
372: IF NOT FND_API.Compatible_API_Call (

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

367: BEGIN
368: -- Standard Start of API savepoint
369: SAVEPOINT Update_Attr_Value_PVT;
370:
371: -- Standard call to check for call compatibility.
372: IF NOT FND_API.Compatible_API_Call (
373: l_api_version_number
374: ,p_api_version_number
375: ,l_api_name

Line 506: -- Standard check for p_commit

502: --
503: -- End of API body.
504: --
505:
506: -- Standard check for p_commit
507: IF FND_API.to_Boolean( p_commit )
508: THEN
509: COMMIT WORK;
510: END IF;

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

512: -- Debug Message
513: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
514: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
515: END IF;
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_MSG_PUB.Count_And_Get (
518: p_count => x_msg_count
519: ,p_data => x_msg_data
520: );

Line 530: -- Standard call to get message count and if count=1, get the message

526: */
527: WHEN FND_API.G_EXC_ERROR THEN
528: ROLLBACK TO Update_Attr_Value_PVT;
529: x_return_status := FND_API.G_RET_STS_ERROR;
530: -- Standard call to get message count and if count=1, get the message
531: FND_MSG_PUB.Count_And_Get (
532: p_encoded => FND_API.G_FALSE
533: ,p_count => x_msg_count
534: ,p_data => x_msg_data

Line 540: -- Standard call to get message count and if count=1, get the message

536:
537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
538: ROLLBACK TO Update_Attr_Value_PVT;
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: -- Standard call to get message count and if count=1, get the message
541: FND_MSG_PUB.Count_And_Get (
542: p_encoded => FND_API.G_FALSE
543: ,p_count => x_msg_count
544: ,p_data => x_msg_data

Line 554: -- Standard call to get message count and if count=1, get the message

550: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
551: THEN
552: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
553: END IF;
554: -- Standard call to get message count and if count=1, get the message
555: FND_MSG_PUB.Count_And_Get (
556: p_encoded => FND_API.G_FALSE
557: ,p_count => x_msg_count
558: ,p_data => x_msg_data

Line 584: -- Standard Start of API savepoint

580: l_api_version_number CONSTANT NUMBER := 1.0;
581: l_object_version_number NUMBER;
582:
583: BEGIN
584: -- Standard Start of API savepoint
585: SAVEPOINT Delete_Attr_Value_PVT;
586:
587: -- Standard call to check for call compatibility.
588: IF NOT FND_API.Compatible_API_Call (

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

583: BEGIN
584: -- Standard Start of API savepoint
585: SAVEPOINT Delete_Attr_Value_PVT;
586:
587: -- Standard call to check for call compatibility.
588: IF NOT FND_API.Compatible_API_Call (
589: l_api_version_number
590: ,p_api_version_number
591: ,l_api_name

Line 625: -- Standard check for p_commit

621: --
622: -- End of API body
623: --
624:
625: -- Standard check for p_commit
626: IF FND_API.to_Boolean( p_commit )
627: THEN
628: COMMIT WORK;
629: END IF;

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

631: -- Debug Message
632: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
633: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
634: END IF;
635: -- Standard call to get message count and if count is 1, get message info.
636: FND_MSG_PUB.Count_And_Get (
637: p_count => x_msg_count
638: ,p_data => x_msg_data
639: );

Line 649: -- Standard call to get message count and if count=1, get the message

645: */
646: WHEN FND_API.G_EXC_ERROR THEN
647: ROLLBACK TO Delete_Attr_Value_PVT;
648: x_return_status := FND_API.G_RET_STS_ERROR;
649: -- Standard call to get message count and if count=1, get the message
650: FND_MSG_PUB.Count_And_Get (
651: p_encoded => FND_API.G_FALSE
652: ,p_count => x_msg_count
653: ,p_data => x_msg_data

Line 659: -- Standard call to get message count and if count=1, get the message

655:
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: ROLLBACK TO Delete_Attr_Value_PVT;
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: -- Standard call to get message count and if count=1, get the message
660: FND_MSG_PUB.Count_And_Get (
661: p_encoded => FND_API.G_FALSE
662: ,p_count => x_msg_count
663: ,p_data => x_msg_data

Line 673: -- Standard call to get message count and if count=1, get the message

669: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
670: THEN
671: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
672: END IF;
673: -- Standard call to get message count and if count=1, get the message
674: FND_MSG_PUB.Count_And_Get (
675: p_encoded => FND_API.G_FALSE
676: ,p_count => x_msg_count
677: ,p_data => x_msg_data

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

717: THEN
718: FND_MSG_PUB.initialize;
719: END IF;
720:
721: -- Standard call to check for call compatibility.
722: IF NOT FND_API.Compatible_API_Call (
723: l_api_version_number
724: ,p_api_version_number
725: ,l_api_name

Line 773: -- Standard call to get message count and if count=1, get the message

769: */
770: WHEN FND_API.G_EXC_ERROR THEN
771: ROLLBACK TO Lock_Attr_Value_PVT;
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: -- Standard call to get message count and if count=1, get the message
774: FND_MSG_PUB.Count_And_Get (
775: p_encoded => FND_API.G_FALSE
776: ,p_count => x_msg_count
777: ,p_data => x_msg_data

Line 783: -- Standard call to get message count and if count=1, get the message

779:
780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
781: ROLLBACK TO Lock_Attr_Value_PVT;
782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783: -- Standard call to get message count and if count=1, get the message
784: FND_MSG_PUB.Count_And_Get (
785: p_encoded => FND_API.G_FALSE
786: ,p_count => x_msg_count
787: ,p_data => x_msg_data

Line 797: -- Standard call to get message count and if count=1, get the message

793: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
794: THEN
795: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
796: END IF;
797: -- Standard call to get message count and if count=1, get the message
798: FND_MSG_PUB.Count_And_Get (
799: p_encoded => FND_API.G_FALSE
800: ,p_count => x_msg_count
801: ,p_data => x_msg_data

Line 1412: -- Standard Start of API savepoint

1408: BEGIN
1409:
1410: --DBMS_OUTPUT.PUT_LINE ('Enter Validate Procedure with mode= '||p_validation_mode);
1411:
1412: -- Standard Start of API savepoint
1413: SAVEPOINT Validate_attr_value;
1414:
1415: -- Standard call to check for call compatibility.
1416: IF NOT FND_API.Compatible_API_Call (

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

1411:
1412: -- Standard Start of API savepoint
1413: SAVEPOINT Validate_attr_value;
1414:
1415: -- Standard call to check for call compatibility.
1416: IF NOT FND_API.Compatible_API_Call (
1417: l_api_version_number
1418: ,p_api_version_number
1419: ,l_api_name

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

1481: -- Debug Message
1482: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1483: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1484: END IF;
1485: -- Standard call to get message count and if count is 1, get message info.
1486: FND_MSG_PUB.Count_And_Get (
1487: p_count => x_msg_count
1488: ,p_data => x_msg_data
1489: );

Line 1499: -- Standard call to get message count and if count=1, get the message

1495: */
1496: WHEN FND_API.G_EXC_ERROR THEN
1497: ROLLBACK TO Validate_attr_value;
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499: -- Standard call to get message count and if count=1, get the message
1500: FND_MSG_PUB.Count_And_Get (
1501: p_encoded => FND_API.G_FALSE
1502: ,p_count => x_msg_count
1503: ,p_data => x_msg_data

Line 1509: -- Standard call to get message count and if count=1, get the message

1505:
1506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1507: ROLLBACK TO Validate_attr_value;
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1509: -- Standard call to get message count and if count=1, get the message
1510: FND_MSG_PUB.Count_And_Get (
1511: p_encoded => FND_API.G_FALSE
1512: ,p_count => x_msg_count
1513: ,p_data => x_msg_data

Line 1523: -- Standard call to get message count and if count=1, get the message

1519: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1520: THEN
1521: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1522: END IF;
1523: -- Standard call to get message count and if count=1, get the message
1524: FND_MSG_PUB.Count_And_Get (
1525: p_encoded => FND_API.G_FALSE
1526: ,p_count => x_msg_count
1527: ,p_data => x_msg_data

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

1557: -- Debug Message
1558: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1559: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1560: END IF;
1561: -- Standard call to get message count and if count is 1, get message info.
1562: FND_MSG_PUB.Count_And_Get (
1563: p_count => x_msg_count
1564: ,p_data => x_msg_data
1565: );