DBA Data[Home] [Help]

APPS.PV_ENTY_ATTR_VALIDATIONS_PVT dependencies on STANDARD

Line 60: -- Standard Start of API savepoint

56: FROM PV_ENTY_ATTR_VALIDATIONS
57: WHERE VALIDATION_ID = l_id;
58:
59: BEGIN
60: -- Standard Start of API savepoint
61: SAVEPOINT Create_Enty_Attr_Validation;
62:
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

59: BEGIN
60: -- Standard Start of API savepoint
61: SAVEPOINT Create_Enty_Attr_Validation;
62:
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
65: p_api_version_number,
66: l_api_name,
67: G_PKG_NAME)

Line 193: -- Standard check for p_commit

189: --
190: -- End of API body
191: --
192:
193: -- Standard check for p_commit
194: IF FND_API.to_Boolean( p_commit )
195: THEN
196: COMMIT WORK;
197: END IF;

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

201: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
202: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
203: END IF;
204:
205: -- Standard call to get message count and if count is 1, get message info.
206: FND_MSG_PUB.Count_And_Get (
207: p_count => x_msg_count
208: ,p_data => x_msg_data
209: );

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

216: */
217: WHEN FND_API.G_EXC_ERROR THEN
218: ROLLBACK TO Create_Enty_Attr_Validation;
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: -- Standard call to get message count and if count=1, get the message
221: FND_MSG_PUB.Count_And_Get (
222: p_encoded => FND_API.G_FALSE
223: ,p_count => x_msg_count
224: ,p_data => x_msg_data

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

226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO Create_Enty_Attr_Validation;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: -- Standard call to get message count and if count=1, get the message
231: FND_MSG_PUB.Count_And_Get (
232: p_encoded => FND_API.G_FALSE
233: ,p_count => x_msg_count
234: ,p_data => x_msg_data

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

240: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
241: THEN
242: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
243: END IF;
244: -- Standard call to get message count and if count=1, get the message
245: FND_MSG_PUB.Count_And_Get (
246: p_encoded => FND_API.G_FALSE
247: ,p_count => x_msg_count
248: ,p_data => x_msg_data

Line 284: -- Standard Start of API savepoint

280: l_tar_enty_attr_validation_rec PV_ENTY_ATTR_VALIDATIONS_PVT.enty_attr_validation_rec_type := p_enty_attr_validation_rec;
281: l_rowid ROWID;
282:
283: BEGIN
284: -- Standard Start of API savepoint
285: SAVEPOINT Update_Enty_Attr_Validation;
286:
287: -- Standard call to check for call compatibility.
288: IF NOT FND_API.Compatible_API_Call (

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

283: BEGIN
284: -- Standard Start of API savepoint
285: SAVEPOINT Update_Enty_Attr_Validation;
286:
287: -- Standard call to check for call compatibility.
288: IF NOT FND_API.Compatible_API_Call (
289: l_api_version_number
290: ,p_api_version_number
291: ,l_api_name

Line 410: -- Standard check for p_commit

406: --
407: -- End of API body.
408: --
409:
410: -- Standard check for p_commit
411: IF FND_API.to_Boolean( p_commit )
412: THEN
413: COMMIT WORK;
414: END IF;

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

417: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
418: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
419: END IF;
420:
421: -- Standard call to get message count and if count is 1, get message info.
422: FND_MSG_PUB.Count_And_Get (
423: p_count => x_msg_count
424: ,p_data => x_msg_data
425: );

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

431: */
432: WHEN FND_API.G_EXC_ERROR THEN
433: ROLLBACK TO Update_Enty_Attr_Validation;
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: -- Standard call to get message count and if count=1, get the message
436: FND_MSG_PUB.Count_And_Get (
437: p_encoded => FND_API.G_FALSE
438: ,p_count => x_msg_count
439: ,p_data => x_msg_data

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

441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: ROLLBACK TO Update_Enty_Attr_Validation;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: -- Standard call to get message count and if count=1, get the message
446: FND_MSG_PUB.Count_And_Get (
447: p_encoded => FND_API.G_FALSE
448: ,p_count => x_msg_count
449: ,p_data => x_msg_data

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

455: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
456: THEN
457: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
458: END IF;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (
461: p_encoded => FND_API.G_FALSE
462: ,p_count => x_msg_count
463: ,p_data => x_msg_data

Line 489: -- Standard Start of API savepoint

485: l_api_version_number CONSTANT NUMBER := 1.0;
486: l_object_version_number NUMBER;
487:
488: BEGIN
489: -- Standard Start of API savepoint
490: SAVEPOINT Delete_Enty_Attr_Validation;
491:
492: -- Standard call to check for call compatibility.
493: IF NOT FND_API.Compatible_API_Call (

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

488: BEGIN
489: -- Standard Start of API savepoint
490: SAVEPOINT Delete_Enty_Attr_Validation;
491:
492: -- Standard call to check for call compatibility.
493: IF NOT FND_API.Compatible_API_Call (
494: l_api_version_number
495: ,p_api_version_number
496: ,l_api_name

Line 531: -- Standard check for p_commit

527: --
528: -- End of API body
529: --
530:
531: -- Standard check for p_commit
532: IF FND_API.to_Boolean( p_commit )
533: THEN
534: COMMIT WORK;
535: END IF;

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

538: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
539: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
540: END IF;
541:
542: -- Standard call to get message count and if count is 1, get message info.
543: FND_MSG_PUB.Count_And_Get (
544: p_count => x_msg_count
545: ,p_data => x_msg_data
546: );

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

552: */
553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO Delete_Enty_Attr_Validation;
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: -- Standard call to get message count and if count=1, get the message
557: FND_MSG_PUB.Count_And_Get (
558: p_encoded => FND_API.G_FALSE
559: ,p_count => x_msg_count
560: ,p_data => x_msg_data

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

562:
563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: ROLLBACK TO Delete_Enty_Attr_Validation;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566: -- Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE
569: ,p_count => x_msg_count
570: ,p_data => x_msg_data

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

576: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
577: THEN
578: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
579: END IF;
580: -- Standard call to get message count and if count=1, get the message
581: FND_MSG_PUB.Count_And_Get (
582: p_encoded => FND_API.G_FALSE
583: ,p_count => x_msg_count
584: ,p_data => x_msg_data

Line 618: -- Standard Start of API savepoint

614: FOR UPDATE NOWAIT;
615:
616: BEGIN
617:
618: -- Standard Start of API savepoint
619: SAVEPOINT Lock_Enty_Attr_Validation;
620:
621: -- Debug Message
622: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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

628: THEN
629: FND_MSG_PUB.initialize;
630: END IF;
631:
632: -- Standard call to check for call compatibility.
633: IF NOT FND_API.Compatible_API_Call (
634: l_api_version_number
635: ,p_api_version_number
636: ,l_api_name

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

680: */
681: WHEN FND_API.G_EXC_ERROR THEN
682: ROLLBACK TO Lock_Enty_Attr_Validation;
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE
687: ,p_count => x_msg_count
688: ,p_data => x_msg_data

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

690:
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: ROLLBACK TO Lock_Enty_Attr_Validation;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: -- Standard call to get message count and if count=1, get the message
695: FND_MSG_PUB.Count_And_Get (
696: p_encoded => FND_API.G_FALSE
697: ,p_count => x_msg_count
698: ,p_data => x_msg_data

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

704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
705: THEN
706: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
707: END IF;
708: -- Standard call to get message count and if count=1, get the message
709: FND_MSG_PUB.Count_And_Get (
710: p_encoded => FND_API.G_FALSE
711: ,p_count => x_msg_count
712: ,p_data => x_msg_data

Line 1187: -- Standard Start of API savepoint

1183: BEGIN
1184:
1185: --DBMS_OUTPUT.PUT_LINE ('Enter Validate Procedure with mode= '||p_validation_mode);
1186:
1187: -- Standard Start of API savepoint
1188: SAVEPOINT Validate_Enty_Attr_Validation;
1189:
1190: -- Standard call to check for call compatibility.
1191: IF NOT FND_API.Compatible_API_Call (

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

1186:
1187: -- Standard Start of API savepoint
1188: SAVEPOINT Validate_Enty_Attr_Validation;
1189:
1190: -- Standard call to check for call compatibility.
1191: IF NOT FND_API.Compatible_API_Call (
1192: l_api_version_number
1193: ,p_api_version_number
1194: ,l_api_name

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

1254: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1255: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1256: END IF;
1257:
1258: -- Standard call to get message count and if count is 1, get message info.
1259: FND_MSG_PUB.Count_And_Get (
1260: p_count => x_msg_count
1261: ,p_data => x_msg_data
1262: );

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

1268: */
1269: WHEN FND_API.G_EXC_ERROR THEN
1270: ROLLBACK TO Validate_Enty_Attr_Validation;
1271: x_return_status := FND_API.G_RET_STS_ERROR;
1272: -- Standard call to get message count and if count=1, get the message
1273: FND_MSG_PUB.Count_And_Get (
1274: p_encoded => FND_API.G_FALSE
1275: ,p_count => x_msg_count
1276: ,p_data => x_msg_data

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

1278:
1279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1280: ROLLBACK TO Validate_Enty_Attr_Validation;
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282: -- Standard call to get message count and if count=1, get the message
1283: FND_MSG_PUB.Count_And_Get (
1284: p_encoded => FND_API.G_FALSE
1285: ,p_count => x_msg_count
1286: ,p_data => x_msg_data

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

1292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1293: THEN
1294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1295: END IF;
1296: -- Standard call to get message count and if count=1, get the message
1297: FND_MSG_PUB.Count_And_Get (
1298: p_encoded => FND_API.G_FALSE
1299: ,p_count => x_msg_count
1300: ,p_data => x_msg_data

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

1333: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1334: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1335: END IF;
1336:
1337: -- Standard call to get message count and if count is 1, get message info.
1338: FND_MSG_PUB.Count_And_Get (
1339: p_count => x_msg_count
1340: ,p_data => x_msg_data
1341: );