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_PARTNER_ACCESSES_PVT dependencies on FND_MSG_PUB

Line 23: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Partner_Accesses_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvprab.pls';
22:
23: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
24: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
25: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26:
27: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

Line 24: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Partner_Accesses_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvprab.pls';
22:
23: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
24: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
25: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26:
27: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
28: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 25: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvprab.pls';
22:
23: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
24: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
25: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26:
27: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
28: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
29: --

Line 114: FND_MSG_PUB.initialize;

110:
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list )
113: THEN
114: FND_MSG_PUB.initialize;
115: END IF;
116:
117: -- Debug Message
118: IF (PV_DEBUG_HIGH_ON) THEN

Line 222: FND_MSG_PUB.add;

218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
219: l_err_msg := substr(to_char(SQLCODE)||'-'||SQLERRM,1,2000);
220: FND_MESSAGE.set_name('PV', 'PV_API_OTHERS_EXCEP');
221: FND_MESSAGE.set_token('ERROR', l_err_msg);
222: FND_MSG_PUB.add;
223: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
224: RAISE FND_API.G_EXC_ERROR;
225: ELSE
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 247: FND_MSG_PUB.Count_And_Get

243: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end.');
244: END IF;
245:
246: -- Standard call to get message count and if count is 1, get message info.
247: FND_MSG_PUB.Count_And_Get
248: (p_count => x_msg_count,
249: p_data => x_msg_data
250: );
251: EXCEPTION

Line 261: FND_MSG_PUB.Count_And_Get (

257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO CREATE_Partner_Accesses_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data
265: );

Line 271: FND_MSG_PUB.Count_And_Get (

267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO CREATE_Partner_Accesses_PVT;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data
275: );

Line 280: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

276:
277: WHEN OTHERS THEN
278: ROLLBACK TO CREATE_Partner_Accesses_PVT;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
281: THEN
282: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
283: END IF;
284: -- Standard call to get message count and if count=1, get the message

Line 282: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

278: ROLLBACK TO CREATE_Partner_Accesses_PVT;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
281: THEN
282: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
283: END IF;
284: -- Standard call to get message count and if count=1, get the message
285: FND_MSG_PUB.Count_And_Get (
286: p_encoded => FND_API.G_FALSE,

Line 285: FND_MSG_PUB.Count_And_Get (

281: THEN
282: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
283: END IF;
284: -- Standard call to get message count and if count=1, get the message
285: FND_MSG_PUB.Count_And_Get (
286: p_encoded => FND_API.G_FALSE,
287: p_count => x_msg_count,
288: p_data => x_msg_data
289: );

Line 370: FND_MSG_PUB.initialize;

366:
367: -- Initialize message list if p_init_msg_list is set to TRUE.
368: IF FND_API.to_Boolean( p_init_msg_list )
369: THEN
370: FND_MSG_PUB.initialize;
371: END IF;
372:
373: -- Debug Message
374: IF (PV_DEBUG_HIGH_ON) THEN

Line 448: PVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

444:
445:
446: -- Debug Message
447: IF (PV_DEBUG_HIGH_ON) THEN
448: PVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
449: END IF;
450:
451: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Update_Row)
452: Pv_Partner_Accesses_Pkg.Update_Row(

Line 490: FND_MSG_PUB.add;

486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
487: l_err_msg := substr(to_char(SQLCODE)||'-'||SQLERRM,1,2000);
488: FND_MESSAGE.set_name('PV', 'PV_API_OTHERS_EXCEP');
489: FND_MESSAGE.set_token('ERROR', l_err_msg);
490: FND_MSG_PUB.add;
491: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
492: RAISE FND_API.G_EXC_ERROR;
493: ELSE
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 515: FND_MSG_PUB.Count_And_Get

511: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
512: END IF;
513:
514: -- Standard call to get message count and if count is 1, get message info.
515: FND_MSG_PUB.Count_And_Get
516: (p_count => x_msg_count,
517: p_data => x_msg_data
518: );
519: EXCEPTION

Line 529: FND_MSG_PUB.Count_And_Get (

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

Line 539: FND_MSG_PUB.Count_And_Get (

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

Line 548: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

544:
545: WHEN OTHERS THEN
546: ROLLBACK TO UPDATE_Partner_Accesses_PVT;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
549: THEN
550: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
551: END IF;
552: -- Standard call to get message count and if count=1, get the message

Line 550: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

546: ROLLBACK TO UPDATE_Partner_Accesses_PVT;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
549: THEN
550: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
551: END IF;
552: -- Standard call to get message count and if count=1, get the message
553: FND_MSG_PUB.Count_And_Get (
554: p_encoded => FND_API.G_FALSE,

Line 553: FND_MSG_PUB.Count_And_Get (

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

Line 629: FND_MSG_PUB.initialize;

625:
626: -- Initialize message list if p_init_msg_list is set to TRUE.
627: IF FND_API.to_Boolean( p_init_msg_list )
628: THEN
629: FND_MSG_PUB.initialize;
630: END IF;
631:
632: -- Debug Message
633: IF (PV_DEBUG_HIGH_ON) THEN

Line 659: FND_MSG_PUB.add;

655: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
656: l_err_msg := substr(to_char(SQLCODE)||'-'||SQLERRM,1,2000);
657: FND_MESSAGE.set_name('PV', 'PV_API_OTHERS_EXCEP');
658: FND_MESSAGE.set_token('ERROR', l_err_msg);
659: FND_MSG_PUB.add;
660: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
661: RAISE FND_API.G_EXC_ERROR;
662: ELSE
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 683: FND_MSG_PUB.Count_And_Get

679: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
680: END IF;
681:
682: -- Standard call to get message count and if count is 1, get message info.
683: FND_MSG_PUB.Count_And_Get
684: (p_count => x_msg_count,
685: p_data => x_msg_data
686: );
687: EXCEPTION

Line 698: FND_MSG_PUB.Count_And_Get (

694: ROLLBACK TO DELETE_Partner_Accesses_PVT;
695: x_return_status := FND_API.G_RET_STS_ERROR;
696:
697: -- Standard call to get message count and if count=1, get the message
698: FND_MSG_PUB.Count_And_Get (
699: p_encoded => FND_API.G_FALSE,
700: p_count => x_msg_count,
701: p_data => x_msg_data
702: );

Line 709: FND_MSG_PUB.Count_And_Get (

705: ROLLBACK TO DELETE_Partner_Accesses_PVT;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707:
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
713: );

Line 719: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

715: WHEN OTHERS THEN
716: ROLLBACK TO DELETE_Partner_Accesses_PVT;
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718:
719: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
720: THEN
721: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
722: END IF;
723:

Line 721: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718:
719: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
720: THEN
721: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
722: END IF;
723:
724: -- Standard call to get message count and if count=1, get the message
725: FND_MSG_PUB.Count_And_Get (

Line 725: FND_MSG_PUB.Count_And_Get (

721: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
722: END IF;
723:
724: -- Standard call to get message count and if count=1, get the message
725: FND_MSG_PUB.Count_And_Get (
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_msg_count,
728: p_data => x_msg_data
729: );

Line 795: FND_MSG_PUB.initialize;

791:
792: -- Initialize message list if p_init_msg_list is set to TRUE.
793: IF FND_API.to_Boolean( p_init_msg_list )
794: THEN
795: FND_MSG_PUB.initialize;
796: END IF;
797:
798: -- Standard call to check for call compatibility.
799: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 824: FND_MSG_PUB.count_and_get(

820: END IF;
821:
822: -------------------- finish --------------------------
823:
824: FND_MSG_PUB.count_and_get(
825: p_encoded => FND_API.g_false,
826: p_count => x_msg_count,
827: p_data => x_msg_data);
828:

Line 844: FND_MSG_PUB.Count_And_Get (

840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO Lock_Partner_Accesses;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,
847: p_data => x_msg_data
848: );

Line 854: FND_MSG_PUB.Count_And_Get (

850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
851: ROLLBACK TO Lock_Partner_Accesses;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: -- Standard call to get message count and if count=1, get the message
854: FND_MSG_PUB.Count_And_Get (
855: p_encoded => FND_API.G_FALSE,
856: p_count => x_msg_count,
857: p_data => x_msg_data
858: );

Line 863: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

859:
860: WHEN OTHERS THEN
861: ROLLBACK TO Lock_Partner_Accesses;
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
864: THEN
865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
866: END IF;
867: -- Standard call to get message count and if count=1, get the message

Line 865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

861: ROLLBACK TO Lock_Partner_Accesses;
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
864: THEN
865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
866: END IF;
867: -- Standard call to get message count and if count=1, get the message
868: FND_MSG_PUB.Count_And_Get (
869: p_encoded => FND_API.G_FALSE,

Line 868: FND_MSG_PUB.Count_And_Get (

864: THEN
865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
866: END IF;
867: -- Standard call to get message count and if count=1, get the message
868: FND_MSG_PUB.Count_And_Get (
869: p_encoded => FND_API.G_FALSE,
870: p_count => x_msg_count,
871: p_data => x_msg_data
872: );

Line 1316: FND_MSG_PUB.initialize;

1312:
1313: -- Initialize message list if p_init_msg_list is set to TRUE.
1314: IF FND_API.to_Boolean( p_init_msg_list )
1315: THEN
1316: FND_MSG_PUB.initialize;
1317: END IF;
1318:
1319: -- Initialize API return status to SUCCESS
1320: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1371: FND_MSG_PUB.Count_And_Get

1367: END IF;
1368:
1369:
1370: -- Standard call to get message count and if count is 1, get message info.
1371: FND_MSG_PUB.Count_And_Get
1372: (p_count => x_msg_count,
1373: p_data => x_msg_data
1374: );
1375: EXCEPTION

Line 1385: FND_MSG_PUB.Count_And_Get (

1381: ROLLBACK TO VALIDATE_Partner_Accesses;
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383:
1384: -- Standard call to get message count and if count=1, get the message
1385: FND_MSG_PUB.Count_And_Get (
1386: p_encoded => FND_API.G_FALSE,
1387: p_count => x_msg_count,
1388: p_data => x_msg_data
1389: );

Line 1396: FND_MSG_PUB.Count_And_Get (

1392: ROLLBACK TO VALIDATE_Partner_Accesses;
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394:
1395: -- Standard call to get message count and if count=1, get the message
1396: FND_MSG_PUB.Count_And_Get (
1397: p_encoded => FND_API.G_FALSE,
1398: p_count => x_msg_count,
1399: p_data => x_msg_data
1400: );

Line 1406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1402: WHEN OTHERS THEN
1403: ROLLBACK TO VALIDATE_Partner_Accesses;
1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405:
1406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1407: THEN
1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1409: END IF;
1410:

Line 1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405:
1406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1407: THEN
1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1409: END IF;
1410:
1411: -- Standard call to get message count and if count=1, get the message
1412: FND_MSG_PUB.Count_And_Get (

Line 1412: FND_MSG_PUB.Count_And_Get (

1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1409: END IF;
1410:
1411: -- Standard call to get message count and if count=1, get the message
1412: FND_MSG_PUB.Count_And_Get (
1413: p_encoded => FND_API.G_FALSE,
1414: p_count => x_msg_count,
1415: p_data => x_msg_data
1416: );

Line 1433: FND_MSG_PUB.initialize;

1429: BEGIN
1430: -- Initialize message list if p_init_msg_list is set to TRUE.
1431: IF FND_API.to_Boolean( p_init_msg_list )
1432: THEN
1433: FND_MSG_PUB.initialize;
1434: END IF;
1435:
1436: -- Initialize API return status to SUCCESS
1437: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1456: FND_MSG_PUB.Count_And_Get

1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453: END IF;
1454:
1455: -- Standard call to get message count and if count is 1, get message info.
1456: FND_MSG_PUB.Count_And_Get
1457: (p_count => x_msg_count,
1458: p_data => x_msg_data
1459: );
1460: END Validate_partner_access_Rec;