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.PV_ENTY_ATTR_VALIDATIONS_PVT dependencies on PVX_UTILITY_PVT

Line 80: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');

76: END IF;
77:
78: -- Debug Message
79: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
80: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
81: end if;
82:
83:
84: -- Initialize API return status to SUCCESS

Line 123: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_enty_attr_validation');

119: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
120: THEN
121: -- Debug message
122: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
123: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_enty_attr_validation');
124: END IF;
125:
126: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Validate_attr_value' );
127:

Line 163: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');

159: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : After Validate' );
160:
161: -- Debug Message
162: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
163: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
164: END IF;
165:
166: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Insert_Row)
167: PV_ENTY_ATTR_VALIDATIONS_PKG.Insert_Row(

Line 202: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');

198:
199:
200: -- Debug Message
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 (

Line 213: WHEN PVX_Utility_PVT.resource_locked THEN

209: );
210:
211: EXCEPTION
212: /*
213: WHEN PVX_Utility_PVT.resource_locked THEN
214: x_return_status := FND_API.g_ret_sts_error;
215: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
216: */
217: WHEN FND_API.G_EXC_ERROR THEN

Line 215: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

211: EXCEPTION
212: /*
213: WHEN PVX_Utility_PVT.resource_locked THEN
214: x_return_status := FND_API.g_ret_sts_error;
215: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
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;

Line 306: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');

302: END IF;
303:
304: -- Debug Message
305: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
306: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
307: END IF;
308:
309: -- Initialize API return status to SUCCESS
310: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 314: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');

310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: -- Debug Message
313: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
314: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');
315: END IF;
316:
317: OPEN c_get_Enty_Attr_Validation( l_tar_enty_attr_validation_rec.validation_id);
318:

Line 334: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');

330: END IF;
331:
332: -- Debug Message
333: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
334: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
335: END IF;
336: CLOSE c_get_Enty_Attr_Validation;
337:
338:

Line 362: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Enty_attr_validation');

358: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
359: THEN
360: -- Debug message
361: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
362: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Enty_attr_validation');
363: END IF;
364:
365: -- Invoke validation procedures
366: Validate_Enty_Attr_Validation(

Line 386: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');

382:
383:
384: -- Debug Message
385: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
386: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
387: END IF;
388:
389: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Update_Row)
390: PV_ENTY_ATTR_VALIDATIONS_PKG.Update_Row(

Line 418: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');

414: END IF;
415:
416: -- Debug Message
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 (

Line 428: WHEN PVX_Utility_PVT.resource_locked THEN

424: ,p_data => x_msg_data
425: );
426: EXCEPTION
427: /*
428: WHEN PVX_Utility_PVT.resource_locked THEN
429: x_return_status := FND_API.g_ret_sts_error;
430: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
431: */
432: WHEN FND_API.G_EXC_ERROR THEN

Line 430: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

426: EXCEPTION
427: /*
428: WHEN PVX_Utility_PVT.resource_locked THEN
429: x_return_status := FND_API.g_ret_sts_error;
430: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
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;

Line 511: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');

507: END IF;
508:
509: -- Debug Message
510: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
511: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
512: END IF;
513: -- Initialize API return status to SUCCESS
514: x_return_status := FND_API.G_RET_STS_SUCCESS;
515:

Line 521: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');

517: -- Api body
518: --
519: -- Debug Message
520: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
521: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
522: END IF;
523:
524: -- Invoke table handler(PV_ENTY_ATTR_VALIDATIONS_PKG.Delete_Row)
525: PV_ENTY_ATTR_VALIDATIONS_PKG.Delete_Row(

Line 539: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');

535: END IF;
536:
537: -- Debug Message
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 (

Line 549: WHEN PVX_Utility_PVT.resource_locked THEN

545: ,p_data => x_msg_data
546: );
547: EXCEPTION
548: /*
549: WHEN PVX_Utility_PVT.resource_locked THEN
550: x_return_status := FND_API.g_ret_sts_error;
551: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
552: */
553: WHEN FND_API.G_EXC_ERROR THEN

Line 551: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

547: EXCEPTION
548: /*
549: WHEN PVX_Utility_PVT.resource_locked THEN
550: x_return_status := FND_API.g_ret_sts_error;
551: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
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;

Line 623: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');

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
623: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
624: END IF;
625:
626: -- Initialize message list if p_init_msg_list is set to TRUE.
627: IF FND_API.to_Boolean( p_init_msg_list )

Line 649: PVX_Utility_PVT.debug_message(l_full_name||': start');

645:
646:
647: ------------------------ lock -------------------------
648: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
649: PVX_Utility_PVT.debug_message(l_full_name||': start');
650: END IF;
651: OPEN c_Enty_Attr_Validation;
652:
653: FETCH c_Enty_Attr_Validation INTO l_ENTY_ATTR_VALIDATION_ID;

Line 673: PVX_Utility_PVT.debug_message(l_full_name ||': end');

669: ,p_count => x_msg_count
670: ,p_data => x_msg_data
671: );
672: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
673: PVX_Utility_PVT.debug_message(l_full_name ||': end');
674: END IF;
675: EXCEPTION
676: /*
677: WHEN PVX_Utility_PVT.resource_locked THEN

Line 677: WHEN PVX_Utility_PVT.resource_locked THEN

673: PVX_Utility_PVT.debug_message(l_full_name ||': end');
674: END IF;
675: EXCEPTION
676: /*
677: WHEN PVX_Utility_PVT.resource_locked THEN
678: x_return_status := FND_API.g_ret_sts_error;
679: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
680: */
681: WHEN FND_API.G_EXC_ERROR THEN

Line 679: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

675: EXCEPTION
676: /*
677: WHEN PVX_Utility_PVT.resource_locked THEN
678: x_return_status := FND_API.g_ret_sts_error;
679: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
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;

Line 730: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

726: --DBMS_OUTPUT.PUT_LINE ('entering check_uk_items');
727:
728: x_return_status := FND_API.g_ret_sts_success;
729: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
730: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
731: 'PV_ENTY_ATTR_VALIDATIONS'
732: ,'VALIDATION_ID = ''' || p_enty_attr_validation_rec.VALIDATION_ID ||''''
733: );
734: ELSE

Line 735: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

731: 'PV_ENTY_ATTR_VALIDATIONS'
732: ,'VALIDATION_ID = ''' || p_enty_attr_validation_rec.VALIDATION_ID ||''''
733: );
734: ELSE
735: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
736: 'PV_ENTY_ATTR_VALIDATIONS'
737: ,'VALIDATION_ID = ''' || p_enty_attr_validation_rec.VALIDATION_ID ||
738: ''' AND VALIDATION_ID <> ' || p_enty_attr_validation_rec.VALIDATION_ID
739: );

Line 1247: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');

1243: END IF;
1244:
1245: -- Debug Message
1246: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1247: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
1248: END IF;
1249:
1250: -- Initialize API return status to SUCCESS
1251: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1255: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');

1251: x_return_status := FND_API.G_RET_STS_SUCCESS;
1252:
1253: -- Debug Message
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 (

Line 1265: WHEN PVX_Utility_PVT.resource_locked THEN

1261: ,p_data => x_msg_data
1262: );
1263: EXCEPTION
1264: /*
1265: WHEN PVX_Utility_PVT.resource_locked THEN
1266: x_return_status := FND_API.g_ret_sts_error;
1267: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1268: */
1269: WHEN FND_API.G_EXC_ERROR THEN

Line 1267: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1263: EXCEPTION
1264: /*
1265: WHEN PVX_Utility_PVT.resource_locked THEN
1266: x_return_status := FND_API.g_ret_sts_error;
1267: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
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;

Line 1334: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');

1330: -- x_return_status := FND_API.G_RET_STS_ERROR;
1331:
1332: -- Debug Message
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 (