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_USER_RESP_PVT dependencies on STANDARD

Line 440: -- Standard Start of API savepoint

436: l_object_version_number NUMBER;
437: BEGIN
438: ---- Initialize----------------
439:
440: -- Standard Start of API savepoint
441: SAVEPOINT assign_resp;
442:
443: -- Standard call to check for call compatibility.
444: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

439:
440: -- Standard Start of API savepoint
441: SAVEPOINT assign_resp;
442:
443: -- Standard call to check for call compatibility.
444: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
445: ,p_api_version_number
446: ,l_api_name
447: ,G_PKG_NAME

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

510: EXCEPTION
511: WHEN Fnd_Api.G_EXC_ERROR THEN
512: ROLLBACK TO assign_resp;
513: x_return_status := Fnd_Api.G_RET_STS_ERROR;
514: -- Standard call to get message count and if count=1, get the message
515: Fnd_Msg_Pub.Count_And_Get (
516: p_encoded => Fnd_Api.G_FALSE
517: ,p_count => x_msg_count
518: ,p_data => x_msg_data

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

520:
521: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
522: ROLLBACK TO assign_resp;
523: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
524: -- Standard call to get message count and if count=1, get the message
525: Fnd_Msg_Pub.Count_And_Get (
526: p_encoded => Fnd_Api.G_FALSE
527: ,p_count => x_msg_count
528: ,p_data => x_msg_data

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

534: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
535: THEN
536: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
537: END IF;
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

Line 576: -- Standard Start of API savepoint

572:
573: BEGIN
574: ---- Initialize----------------
575:
576: -- Standard Start of API savepoint
577: SAVEPOINT revoke_resp;
578:
579: -- Standard call to check for call compatibility.
580: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

575:
576: -- Standard Start of API savepoint
577: SAVEPOINT revoke_resp;
578:
579: -- Standard call to check for call compatibility.
580: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
581: ,p_api_version_number
582: ,l_api_name
583: ,G_PKG_NAME

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

625: EXCEPTION
626: WHEN Fnd_Api.G_EXC_ERROR THEN
627: ROLLBACK TO revoke_resp;
628: x_return_status := Fnd_Api.G_RET_STS_ERROR;
629: -- Standard call to get message count and if count=1, get the message
630: Fnd_Msg_Pub.Count_And_Get (
631: p_encoded => Fnd_Api.G_FALSE
632: ,p_count => x_msg_count
633: ,p_data => x_msg_data

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

635:
636: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
637: ROLLBACK TO revoke_resp;
638: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
639: -- Standard call to get message count and if count=1, get the message
640: Fnd_Msg_Pub.Count_And_Get (
641: p_encoded => Fnd_Api.G_FALSE
642: ,p_count => x_msg_count
643: ,p_data => x_msg_data

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

649: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
652: END IF;
653: -- Standard call to get message count and if count=1, get the message
654: Fnd_Msg_Pub.Count_And_Get (
655: p_encoded => Fnd_Api.G_FALSE
656: ,p_count => x_msg_count
657: ,p_data => x_msg_data

Line 697: -- Standard Start of API savepoint

693:
694: BEGIN
695: ---- Initialize----------------
696:
697: -- Standard Start of API savepoint
698: SAVEPOINT revoke_resp;
699:
700:
701: -- Standard call to check for call compatibility.

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

697: -- Standard Start of API savepoint
698: SAVEPOINT revoke_resp;
699:
700:
701: -- Standard call to check for call compatibility.
702: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
703: ,p_api_version_number
704: ,l_api_name
705: ,G_PKG_NAME

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

778: EXCEPTION
779: WHEN Fnd_Api.G_EXC_ERROR THEN
780: ROLLBACK TO revoke_resp;
781: x_return_status := Fnd_Api.G_RET_STS_ERROR;
782: -- Standard call to get message count and if count=1, get the message
783: Fnd_Msg_Pub.Count_And_Get (
784: p_encoded => Fnd_Api.G_FALSE
785: ,p_count => x_msg_count
786: ,p_data => x_msg_data

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

788:
789: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
790: ROLLBACK TO revoke_resp;
791: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
792: -- Standard call to get message count and if count=1, get the message
793: Fnd_Msg_Pub.Count_And_Get (
794: p_encoded => Fnd_Api.G_FALSE
795: ,p_count => x_msg_count
796: ,p_data => x_msg_data

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

802: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
803: THEN
804: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
805: END IF;
806: -- Standard call to get message count and if count=1, get the message
807: Fnd_Msg_Pub.Count_And_Get (
808: p_encoded => Fnd_Api.G_FALSE
809: ,p_count => x_msg_count
810: ,p_data => x_msg_data

Line 916: -- Standard Start of API savepoint

912:
913: BEGIN
914: ---- Initialize----------------
915:
916: -- Standard Start of API savepoint
917: SAVEPOINT get_default_resp;
918:
919: -- Standard call to check for call compatibility.
920: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

915:
916: -- Standard Start of API savepoint
917: SAVEPOINT get_default_resp;
918:
919: -- Standard call to check for call compatibility.
920: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
921: ,p_api_version_number
922: ,l_api_name
923: ,G_PKG_NAME

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

1027:
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: ROLLBACK TO get_default_resp;
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: -- Standard call to get message count and if count=1, get the message
1032: FND_MSG_PUB.Count_And_Get (
1033: p_encoded => FND_API.G_FALSE,
1034: p_count => x_msg_count,
1035: p_data => x_msg_data

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

1037:
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO get_default_resp;
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: -- Standard call to get message count and if count=1, get the message
1042: FND_MSG_PUB.Count_And_Get (
1043: p_encoded => FND_API.G_FALSE,
1044: p_count => x_msg_count,
1045: p_data => x_msg_data

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

1051: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1052: THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1054: END IF;
1055: -- Standard call to get message count and if count=1, get the message
1056: FND_MSG_PUB.Count_And_Get (
1057: p_encoded => FND_API.G_FALSE,
1058: p_count => x_msg_count,
1059: p_data => x_msg_data

Line 1112: -- Standard Start of API savepoint

1108:
1109: BEGIN
1110: ---- Initialize----------------
1111:
1112: -- Standard Start of API savepoint
1113: SAVEPOINT get_default_org_resp;
1114:
1115: -- Standard call to check for call compatibility.
1116: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

1111:
1112: -- Standard Start of API savepoint
1113: SAVEPOINT get_default_org_resp;
1114:
1115: -- Standard call to check for call compatibility.
1116: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
1117: ,p_api_version_number
1118: ,l_api_name
1119: ,G_PKG_NAME

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

1223:
1224: WHEN FND_API.G_EXC_ERROR THEN
1225: ROLLBACK TO get_default_org_resp;
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227: -- Standard call to get message count and if count=1, get the message
1228: FND_MSG_PUB.Count_And_Get (
1229: p_encoded => FND_API.G_FALSE,
1230: p_count => x_msg_count,
1231: p_data => x_msg_data

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

1233:
1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1235: ROLLBACK TO get_default_org_resp;
1236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1237: -- Standard call to get message count and if count=1, get the message
1238: FND_MSG_PUB.Count_And_Get (
1239: p_encoded => FND_API.G_FALSE,
1240: p_count => x_msg_count,
1241: p_data => x_msg_data

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

1247: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1248: THEN
1249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1250: END IF;
1251: -- Standard call to get message count and if count=1, get the message
1252: FND_MSG_PUB.Count_And_Get (
1253: p_encoded => FND_API.G_FALSE,
1254: p_count => x_msg_count,
1255: p_data => x_msg_data

Line 1306: -- Standard Start of API savepoint

1302:
1303: BEGIN
1304: ---- Initialize----------------
1305:
1306: -- Standard Start of API savepoint
1307: SAVEPOINT get_program_resp;
1308:
1309: -- Standard call to check for call compatibility.
1310: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

1305:
1306: -- Standard Start of API savepoint
1307: SAVEPOINT get_program_resp;
1308:
1309: -- Standard call to check for call compatibility.
1310: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
1311: ,p_api_version_number
1312: ,l_api_name
1313: ,G_PKG_NAME

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

1411:
1412: WHEN FND_API.G_EXC_ERROR THEN
1413: ROLLBACK TO get_program_resp;
1414: x_return_status := FND_API.G_RET_STS_ERROR;
1415: -- Standard call to get message count and if count=1, get the message
1416: FND_MSG_PUB.Count_And_Get (
1417: p_encoded => FND_API.G_FALSE,
1418: p_count => x_msg_count,
1419: p_data => x_msg_data

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

1421:
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: ROLLBACK TO get_program_resp;
1424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1425: -- Standard call to get message count and if count=1, get the message
1426: FND_MSG_PUB.Count_And_Get (
1427: p_encoded => FND_API.G_FALSE,
1428: p_count => x_msg_count,
1429: p_data => x_msg_data

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

1435: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1438: END IF;
1439: -- Standard call to get message count and if count=1, get the message
1440: FND_MSG_PUB.Count_And_Get (
1441: p_encoded => FND_API.G_FALSE,
1442: p_count => x_msg_count,
1443: p_data => x_msg_data

Line 1494: -- Standard Start of API savepoint

1490:
1491: BEGIN
1492: ---- Initialize----------------
1493:
1494: -- Standard Start of API savepoint
1495: SAVEPOINT get_store_prgm_resps;
1496:
1497: -- Standard call to check for call compatibility.
1498: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

1493:
1494: -- Standard Start of API savepoint
1495: SAVEPOINT get_store_prgm_resps;
1496:
1497: -- Standard call to check for call compatibility.
1498: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
1499: ,p_api_version_number
1500: ,l_api_name
1501: ,G_PKG_NAME

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

1553:
1554: WHEN FND_API.G_EXC_ERROR THEN
1555: ROLLBACK TO get_store_prgm_resps;
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: -- Standard call to get message count and if count=1, get the message
1558: FND_MSG_PUB.Count_And_Get (
1559: p_encoded => FND_API.G_FALSE,
1560: p_count => x_msg_count,
1561: p_data => x_msg_data

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

1563:
1564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1565: ROLLBACK TO get_store_prgm_resps;
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1567: -- Standard call to get message count and if count=1, get the message
1568: FND_MSG_PUB.Count_And_Get (
1569: p_encoded => FND_API.G_FALSE,
1570: p_count => x_msg_count,
1571: p_data => x_msg_data

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

1577: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1578: THEN
1579: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1580: END IF;
1581: -- Standard call to get message count and if count=1, get the message
1582: FND_MSG_PUB.Count_And_Get (
1583: p_encoded => FND_API.G_FALSE,
1584: p_count => x_msg_count,
1585: p_data => x_msg_data

Line 1629: -- Standard Start of API savepoint

1625:
1626: BEGIN
1627: ---- Initialize----------------
1628:
1629: -- Standard Start of API savepoint
1630: SAVEPOINT get_store_prgm_resps;
1631:
1632: -- Standard call to check for call compatibility.
1633: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

1628:
1629: -- Standard Start of API savepoint
1630: SAVEPOINT get_store_prgm_resps;
1631:
1632: -- Standard call to check for call compatibility.
1633: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
1634: ,p_api_version_number
1635: ,l_api_name
1636: ,G_PKG_NAME

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

1692:
1693: WHEN FND_API.G_EXC_ERROR THEN
1694: ROLLBACK TO get_store_prgm_resps;
1695: x_return_status := FND_API.G_RET_STS_ERROR;
1696: -- Standard call to get message count and if count=1, get the message
1697: FND_MSG_PUB.Count_And_Get (
1698: p_encoded => FND_API.G_FALSE,
1699: p_count => x_msg_count,
1700: p_data => x_msg_data

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

1702:
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: ROLLBACK TO get_store_prgm_resps;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1706: -- Standard call to get message count and if count=1, get the message
1707: FND_MSG_PUB.Count_And_Get (
1708: p_encoded => FND_API.G_FALSE,
1709: p_count => x_msg_count,
1710: p_data => x_msg_data

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

1716: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1717: THEN
1718: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1719: END IF;
1720: -- Standard call to get message count and if count=1, get the message
1721: FND_MSG_PUB.Count_And_Get (
1722: p_encoded => FND_API.G_FALSE,
1723: p_count => x_msg_count,
1724: p_data => x_msg_data

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

1872: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1873:
1874: WHEN FND_API.G_EXC_ERROR THEN
1875: x_return_status := FND_API.G_RET_STS_ERROR;
1876: -- Standard call to get message count and if count=1, get the message
1877: FND_MSG_PUB.Count_And_Get (
1878: p_encoded => FND_API.G_FALSE,
1879: p_count => x_msg_count,
1880: p_data => x_msg_data

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

1881: );
1882:
1883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1885: -- Standard call to get message count and if count=1, get the message
1886: FND_MSG_PUB.Count_And_Get (
1887: p_encoded => FND_API.G_FALSE,
1888: p_count => x_msg_count,
1889: p_data => x_msg_data

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

1894: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1895: THEN
1896: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1897: END IF;
1898: -- Standard call to get message count and if count=1, get the message
1899: FND_MSG_PUB.Count_And_Get (
1900: p_encoded => FND_API.G_FALSE,
1901: p_count => x_msg_count,
1902: p_data => x_msg_data

Line 1932: -- Standard Start of API savepoint

1928:
1929: BEGIN
1930: ---- Initialize----------------
1931:
1932: -- Standard Start of API savepoint
1933: SAVEPOINT assign_first_user_resp;
1934:
1935: -- Standard call to check for call compatibility.
1936: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

1931:
1932: -- Standard Start of API savepoint
1933: SAVEPOINT assign_first_user_resp;
1934:
1935: -- Standard call to check for call compatibility.
1936: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
1937: ,p_api_version_number
1938: ,l_api_name
1939: ,G_PKG_NAME

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

2029:
2030: WHEN FND_API.G_EXC_ERROR THEN
2031: ROLLBACK TO assign_first_user_resp;
2032: x_return_status := FND_API.G_RET_STS_ERROR;
2033: -- Standard call to get message count and if count=1, get the message
2034: FND_MSG_PUB.Count_And_Get (
2035: p_encoded => FND_API.G_FALSE,
2036: p_count => x_msg_count,
2037: p_data => x_msg_data

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

2039:
2040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2041: ROLLBACK TO assign_first_user_resp;
2042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2043: -- Standard call to get message count and if count=1, get the message
2044: FND_MSG_PUB.Count_And_Get (
2045: p_encoded => FND_API.G_FALSE,
2046: p_count => x_msg_count,
2047: p_data => x_msg_data

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

2053: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2054: THEN
2055: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2056: END IF;
2057: -- Standard call to get message count and if count=1, get the message
2058: FND_MSG_PUB.Count_And_Get (
2059: p_encoded => FND_API.G_FALSE,
2060: p_count => x_msg_count,
2061: p_data => x_msg_data

Line 2111: -- Standard Start of API savepoint

2107: l_user_ids_tbl JTF_NUMBER_TABLE;
2108: BEGIN
2109: ---- Initialize----------------
2110:
2111: -- Standard Start of API savepoint
2112: SAVEPOINT assign_user_resps;
2113:
2114: -- Standard call to check for call compatibility.
2115: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

2110:
2111: -- Standard Start of API savepoint
2112: SAVEPOINT assign_user_resps;
2113:
2114: -- Standard call to check for call compatibility.
2115: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
2116: ,p_api_version_number
2117: ,l_api_name
2118: ,G_PKG_NAME

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

2318:
2319: WHEN FND_API.G_EXC_ERROR THEN
2320: ROLLBACK TO assign_user_resps;
2321: x_return_status := FND_API.G_RET_STS_ERROR;
2322: -- Standard call to get message count and if count=1, get the message
2323: FND_MSG_PUB.Count_And_Get (
2324: p_encoded => FND_API.G_FALSE,
2325: p_count => x_msg_count,
2326: p_data => x_msg_data

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

2328:
2329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2330: ROLLBACK TO assign_user_resps;
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2332: -- Standard call to get message count and if count=1, get the message
2333: FND_MSG_PUB.Count_And_Get (
2334: p_encoded => FND_API.G_FALSE,
2335: p_count => x_msg_count,
2336: p_data => x_msg_data

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

2342: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2343: THEN
2344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2345: END IF;
2346: -- Standard call to get message count and if count=1, get the message
2347: FND_MSG_PUB.Count_And_Get (
2348: p_encoded => FND_API.G_FALSE,
2349: p_count => x_msg_count,
2350: p_data => x_msg_data

Line 2384: -- Standard Start of API savepoint

2380:
2381: BEGIN
2382: ---- Initialize----------------
2383:
2384: -- Standard Start of API savepoint
2385: SAVEPOINT assign_user_resps_2;
2386:
2387: -- Standard call to check for call compatibility.
2388: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

2383:
2384: -- Standard Start of API savepoint
2385: SAVEPOINT assign_user_resps_2;
2386:
2387: -- Standard call to check for call compatibility.
2388: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
2389: ,p_api_version_number
2390: ,l_api_name
2391: ,G_PKG_NAME

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

2456:
2457: WHEN FND_API.G_EXC_ERROR THEN
2458: ROLLBACK TO assign_user_resps_2;
2459: x_return_status := FND_API.G_RET_STS_ERROR;
2460: -- Standard call to get message count and if count=1, get the message
2461: FND_MSG_PUB.Count_And_Get (
2462: p_encoded => FND_API.G_FALSE,
2463: p_count => x_msg_count,
2464: p_data => x_msg_data

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

2466:
2467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2468: ROLLBACK TO assign_user_resps_2;
2469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2470: -- Standard call to get message count and if count=1, get the message
2471: FND_MSG_PUB.Count_And_Get (
2472: p_encoded => FND_API.G_FALSE,
2473: p_count => x_msg_count,
2474: p_data => x_msg_data

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

2480: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2481: THEN
2482: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2483: END IF;
2484: -- Standard call to get message count and if count=1, get the message
2485: FND_MSG_PUB.Count_And_Get (
2486: p_encoded => FND_API.G_FALSE,
2487: p_count => x_msg_count,
2488: p_data => x_msg_data

Line 2561: -- Standard Start of API savepoint

2557:
2558: BEGIN
2559: ---- Initialize----------------
2560:
2561: -- Standard Start of API savepoint
2562: SAVEPOINT switch_user_resp;
2563:
2564: -- Standard call to check for call compatibility.
2565: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

2560:
2561: -- Standard Start of API savepoint
2562: SAVEPOINT switch_user_resp;
2563:
2564: -- Standard call to check for call compatibility.
2565: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
2566: ,p_api_version_number
2567: ,l_api_name
2568: ,G_PKG_NAME

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

2686:
2687: WHEN FND_API.G_EXC_ERROR THEN
2688: ROLLBACK TO switch_user_resp;
2689: x_return_status := FND_API.G_RET_STS_ERROR;
2690: -- Standard call to get message count and if count=1, get the message
2691: FND_MSG_PUB.Count_And_Get (
2692: p_encoded => FND_API.G_FALSE,
2693: p_count => x_msg_count,
2694: p_data => x_msg_data

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

2696:
2697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2698: ROLLBACK TO switch_user_resp;
2699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2700: -- Standard call to get message count and if count=1, get the message
2701: FND_MSG_PUB.Count_And_Get (
2702: p_encoded => FND_API.G_FALSE,
2703: p_count => x_msg_count,
2704: p_data => x_msg_data

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

2710: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2711: THEN
2712: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2713: END IF;
2714: -- Standard call to get message count and if count=1, get the message
2715: FND_MSG_PUB.Count_And_Get (
2716: p_encoded => FND_API.G_FALSE,
2717: p_count => x_msg_count,
2718: p_data => x_msg_data

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

2864:
2865: WHEN FND_API.G_EXC_ERROR THEN
2866: RAISE FND_API.G_EXC_ERROR;
2867: x_return_status := FND_API.G_RET_STS_ERROR;
2868: -- Standard call to get message count and if count=1, get the message
2869: FND_MSG_PUB.Count_And_Get (
2870: p_encoded => FND_API.G_FALSE,
2871: p_count => x_msg_count,
2872: p_data => x_msg_data

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

2874:
2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2878: -- Standard call to get message count and if count=1, get the message
2879: FND_MSG_PUB.Count_And_Get (
2880: p_encoded => FND_API.G_FALSE,
2881: p_count => x_msg_count,
2882: p_data => x_msg_data

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

2888: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2889: THEN
2890: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2891: END IF;
2892: -- Standard call to get message count and if count=1, get the message
2893: FND_MSG_PUB.Count_And_Get (
2894: p_encoded => FND_API.G_FALSE,
2895: p_count => x_msg_count,
2896: p_data => x_msg_data

Line 2967: -- Standard Start of API savepoint

2963: l_no_revoke BOOLEAN;
2964: BEGIN
2965: ---- Initialize----------------
2966:
2967: -- Standard Start of API savepoint
2968: SAVEPOINT manage_ter_exp_memb_resp;
2969:
2970: -- Standard call to check for call compatibility.
2971: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

2966:
2967: -- Standard Start of API savepoint
2968: SAVEPOINT manage_ter_exp_memb_resp;
2969:
2970: -- Standard call to check for call compatibility.
2971: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
2972: ,p_api_version_number
2973: ,l_api_name
2974: ,G_PKG_NAME

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

3206:
3207: WHEN FND_API.G_EXC_ERROR THEN
3208: ROLLBACK TO manage_ter_exp_memb_resp;
3209: x_return_status := FND_API.G_RET_STS_ERROR;
3210: -- Standard call to get message count and if count=1, get the message
3211: FND_MSG_PUB.Count_And_Get (
3212: p_encoded => FND_API.G_FALSE,
3213: p_count => x_msg_count,
3214: p_data => x_msg_data

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

3216:
3217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3218: ROLLBACK TO manage_ter_exp_memb_resp;
3219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3220: -- Standard call to get message count and if count=1, get the message
3221: FND_MSG_PUB.Count_And_Get (
3222: p_encoded => FND_API.G_FALSE,
3223: p_count => x_msg_count,
3224: p_data => x_msg_data

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

3230: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3231: THEN
3232: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3233: END IF;
3234: -- Standard call to get message count and if count=1, get the message
3235: FND_MSG_PUB.Count_And_Get (
3236: p_encoded => FND_API.G_FALSE,
3237: p_count => x_msg_count,
3238: p_data => x_msg_data

Line 3288: -- Standard Start of API savepoint

3284:
3285: BEGIN
3286: ---- Initialize----------------
3287:
3288: -- Standard Start of API savepoint
3289: SAVEPOINT manage_active_memb_resp;
3290:
3291: -- Standard call to check for call compatibility.
3292: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

3287:
3288: -- Standard Start of API savepoint
3289: SAVEPOINT manage_active_memb_resp;
3290:
3291: -- Standard call to check for call compatibility.
3292: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
3293: ,p_api_version_number
3294: ,l_api_name
3295: ,G_PKG_NAME

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

3721:
3722: WHEN FND_API.G_EXC_ERROR THEN
3723: ROLLBACK TO manage_active_memb_resp;
3724: x_return_status := FND_API.G_RET_STS_ERROR;
3725: -- Standard call to get message count and if count=1, get the message
3726: FND_MSG_PUB.Count_And_Get (
3727: p_encoded => FND_API.G_FALSE,
3728: p_count => x_msg_count,
3729: p_data => x_msg_data

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

3731:
3732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3733: ROLLBACK TO manage_active_memb_resp;
3734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3735: -- Standard call to get message count and if count=1, get the message
3736: FND_MSG_PUB.Count_And_Get (
3737: p_encoded => FND_API.G_FALSE,
3738: p_count => x_msg_count,
3739: p_data => x_msg_data

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

3745: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3746: THEN
3747: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3748: END IF;
3749: -- Standard call to get message count and if count=1, get the message
3750: FND_MSG_PUB.Count_And_Get (
3751: p_encoded => FND_API.G_FALSE,
3752: p_count => x_msg_count,
3753: p_data => x_msg_data

Line 3790: -- Standard Start of API savepoint

3786:
3787: BEGIN
3788: ---- Initialize----------------
3789:
3790: -- Standard Start of API savepoint
3791: SAVEPOINT manage_memb_resp;
3792:
3793: -- Standard call to check for call compatibility.
3794: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

3789:
3790: -- Standard Start of API savepoint
3791: SAVEPOINT manage_memb_resp;
3792:
3793: -- Standard call to check for call compatibility.
3794: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
3795: ,p_api_version_number
3796: ,l_api_name
3797: ,G_PKG_NAME

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

3874:
3875: WHEN FND_API.G_EXC_ERROR THEN
3876: ROLLBACK TO manage_memb_resp;
3877: x_return_status := FND_API.G_RET_STS_ERROR;
3878: -- Standard call to get message count and if count=1, get the message
3879: FND_MSG_PUB.Count_And_Get (
3880: p_encoded => FND_API.G_FALSE,
3881: p_count => x_msg_count,
3882: p_data => x_msg_data

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

3884:
3885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3886: ROLLBACK TO manage_memb_resp;
3887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3888: -- Standard call to get message count and if count=1, get the message
3889: FND_MSG_PUB.Count_And_Get (
3890: p_encoded => FND_API.G_FALSE,
3891: p_count => x_msg_count,
3892: p_data => x_msg_data

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

3898: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3899: THEN
3900: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3901: END IF;
3902: -- Standard call to get message count and if count=1, get the message
3903: FND_MSG_PUB.Count_And_Get (
3904: p_encoded => FND_API.G_FALSE,
3905: p_count => x_msg_count,
3906: p_data => x_msg_data

Line 3961: -- Standard Start of API savepoint

3957:
3958: BEGIN
3959: ---- Initialize----------------
3960:
3961: -- Standard Start of API savepoint
3962: SAVEPOINT delete_resp_mapping;
3963:
3964: -- Standard call to check for call compatibility.
3965: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

3960:
3961: -- Standard Start of API savepoint
3962: SAVEPOINT delete_resp_mapping;
3963:
3964: -- Standard call to check for call compatibility.
3965: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
3966: ,p_api_version_number
3967: ,l_api_name
3968: ,G_PKG_NAME

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

4239:
4240: WHEN FND_API.G_EXC_ERROR THEN
4241: ROLLBACK TO delete_resp_mapping;
4242: x_return_status := FND_API.G_RET_STS_ERROR;
4243: -- Standard call to get message count and if count=1, get the message
4244: FND_MSG_PUB.Count_And_Get (
4245: p_encoded => FND_API.G_FALSE,
4246: p_count => x_msg_count,
4247: p_data => x_msg_data

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

4249:
4250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4251: ROLLBACK TO delete_resp_mapping;
4252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4253: -- Standard call to get message count and if count=1, get the message
4254: FND_MSG_PUB.Count_And_Get (
4255: p_encoded => FND_API.G_FALSE,
4256: p_count => x_msg_count,
4257: p_data => x_msg_data

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

4263: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4264: THEN
4265: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4266: END IF;
4267: -- Standard call to get message count and if count=1, get the message
4268: FND_MSG_PUB.Count_And_Get (
4269: p_encoded => FND_API.G_FALSE,
4270: p_count => x_msg_count,
4271: p_data => x_msg_data

Line 4322: -- Standard Start of API savepoint

4318:
4319: BEGIN
4320: ---- Initialize----------------
4321:
4322: -- Standard Start of API savepoint
4323: SAVEPOINT update_resp_mapping;
4324:
4325: -- Standard call to check for call compatibility.
4326: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

4321:
4322: -- Standard Start of API savepoint
4323: SAVEPOINT update_resp_mapping;
4324:
4325: -- Standard call to check for call compatibility.
4326: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
4327: ,p_api_version_number
4328: ,l_api_name
4329: ,G_PKG_NAME

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

4476:
4477: WHEN FND_API.G_EXC_ERROR THEN
4478: ROLLBACK TO update_resp_mapping;
4479: x_return_status := FND_API.G_RET_STS_ERROR;
4480: -- Standard call to get message count and if count=1, get the message
4481: FND_MSG_PUB.Count_And_Get (
4482: p_encoded => FND_API.G_FALSE,
4483: p_count => x_msg_count,
4484: p_data => x_msg_data

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

4486:
4487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4488: ROLLBACK TO update_resp_mapping;
4489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4490: -- Standard call to get message count and if count=1, get the message
4491: FND_MSG_PUB.Count_And_Get (
4492: p_encoded => FND_API.G_FALSE,
4493: p_count => x_msg_count,
4494: p_data => x_msg_data

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

4500: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4501: THEN
4502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4503: END IF;
4504: -- Standard call to get message count and if count=1, get the message
4505: FND_MSG_PUB.Count_And_Get (
4506: p_encoded => FND_API.G_FALSE,
4507: p_count => x_msg_count,
4508: p_data => x_msg_data

Line 4586: -- Standard Start of API savepoint

4582: l_ptnr_resp_id NUMBER;
4583: BEGIN
4584: ---- Initialize----------------
4585:
4586: -- Standard Start of API savepoint
4587: SAVEPOINT create_resp_mapping;
4588:
4589: -- Standard call to check for call compatibility.
4590: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

4585:
4586: -- Standard Start of API savepoint
4587: SAVEPOINT create_resp_mapping;
4588:
4589: -- Standard call to check for call compatibility.
4590: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
4591: ,p_api_version_number
4592: ,l_api_name
4593: ,G_PKG_NAME

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

4890:
4891: WHEN FND_API.G_EXC_ERROR THEN
4892: ROLLBACK TO create_resp_mapping;
4893: x_return_status := FND_API.G_RET_STS_ERROR;
4894: -- Standard call to get message count and if count=1, get the message
4895: FND_MSG_PUB.Count_And_Get (
4896: p_encoded => FND_API.G_FALSE,
4897: p_count => x_msg_count,
4898: p_data => x_msg_data

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

4900:
4901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4902: ROLLBACK TO create_resp_mapping;
4903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4904: -- Standard call to get message count and if count=1, get the message
4905: FND_MSG_PUB.Count_And_Get (
4906: p_encoded => FND_API.G_FALSE,
4907: p_count => x_msg_count,
4908: p_data => x_msg_data

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

4914: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4915: THEN
4916: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4917: END IF;
4918: -- Standard call to get message count and if count=1, get the message
4919: FND_MSG_PUB.Count_And_Get (
4920: p_encoded => FND_API.G_FALSE,
4921: p_count => x_msg_count,
4922: p_data => x_msg_data

Line 4977: -- Standard Start of API savepoint

4973:
4974: BEGIN
4975: ---- Initialize----------------
4976:
4977: -- Standard Start of API savepoint
4978: SAVEPOINT revoke_user_resps;
4979:
4980: -- Standard call to check for call compatibility.
4981: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

4976:
4977: -- Standard Start of API savepoint
4978: SAVEPOINT revoke_user_resps;
4979:
4980: -- Standard call to check for call compatibility.
4981: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
4982: ,p_api_version_number
4983: ,l_api_name
4984: ,G_PKG_NAME

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

5058:
5059: WHEN FND_API.G_EXC_ERROR THEN
5060: ROLLBACK TO revoke_user_resps;
5061: x_return_status := FND_API.G_RET_STS_ERROR;
5062: -- Standard call to get message count and if count=1, get the message
5063: FND_MSG_PUB.Count_And_Get (
5064: p_encoded => FND_API.G_FALSE,
5065: p_count => x_msg_count,
5066: p_data => x_msg_data

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

5068:
5069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5070: ROLLBACK TO revoke_user_resps;
5071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5072: -- Standard call to get message count and if count=1, get the message
5073: FND_MSG_PUB.Count_And_Get (
5074: p_encoded => FND_API.G_FALSE,
5075: p_count => x_msg_count,
5076: p_data => x_msg_data

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

5082: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5083: THEN
5084: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5085: END IF;
5086: -- Standard call to get message count and if count=1, get the message
5087: FND_MSG_PUB.Count_And_Get (
5088: p_encoded => FND_API.G_FALSE,
5089: p_count => x_msg_count,
5090: p_data => x_msg_data

Line 5124: -- Standard Start of API savepoint

5120:
5121: BEGIN
5122: ---- Initialize----------------
5123:
5124: -- Standard Start of API savepoint
5125: SAVEPOINT revoke_user_resps;
5126:
5127: -- Standard call to check for call compatibility.
5128: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

5123:
5124: -- Standard Start of API savepoint
5125: SAVEPOINT revoke_user_resps;
5126:
5127: -- Standard call to check for call compatibility.
5128: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
5129: ,p_api_version_number
5130: ,l_api_name
5131: ,G_PKG_NAME

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

5189:
5190: WHEN FND_API.G_EXC_ERROR THEN
5191: ROLLBACK TO revoke_user_resps;
5192: x_return_status := FND_API.G_RET_STS_ERROR;
5193: -- Standard call to get message count and if count=1, get the message
5194: FND_MSG_PUB.Count_And_Get (
5195: p_encoded => FND_API.G_FALSE,
5196: p_count => x_msg_count,
5197: p_data => x_msg_data

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

5199:
5200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5201: ROLLBACK TO revoke_user_resps;
5202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5203: -- Standard call to get message count and if count=1, get the message
5204: FND_MSG_PUB.Count_And_Get (
5205: p_encoded => FND_API.G_FALSE,
5206: p_count => x_msg_count,
5207: p_data => x_msg_data

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

5213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5214: THEN
5215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5216: END IF;
5217: -- Standard call to get message count and if count=1, get the message
5218: FND_MSG_PUB.Count_And_Get (
5219: p_encoded => FND_API.G_FALSE,
5220: p_count => x_msg_count,
5221: p_data => x_msg_data

Line 5264: -- Standard Start of API savepoint

5260: l_exist NUMBER;
5261: BEGIN
5262: ---- Initialize----------------
5263:
5264: -- Standard Start of API savepoint
5265: SAVEPOINT manage_store_resp_on_create;
5266:
5267: -- Standard call to check for call compatibility.
5268: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

5263:
5264: -- Standard Start of API savepoint
5265: SAVEPOINT manage_store_resp_on_create;
5266:
5267: -- Standard call to check for call compatibility.
5268: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
5269: ,p_api_version_number
5270: ,l_api_name
5271: ,G_PKG_NAME

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

5383:
5384: WHEN FND_API.G_EXC_ERROR THEN
5385: ROLLBACK TO manage_store_resp_on_create;
5386: x_return_status := FND_API.G_RET_STS_ERROR;
5387: -- Standard call to get message count and if count=1, get the message
5388: FND_MSG_PUB.Count_And_Get (
5389: p_encoded => FND_API.G_FALSE,
5390: p_count => x_msg_count,
5391: p_data => x_msg_data

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

5393:
5394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5395: ROLLBACK TO manage_store_resp_on_create;
5396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5397: -- Standard call to get message count and if count=1, get the message
5398: FND_MSG_PUB.Count_And_Get (
5399: p_encoded => FND_API.G_FALSE,
5400: p_count => x_msg_count,
5401: p_data => x_msg_data

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

5407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5408: THEN
5409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5410: END IF;
5411: -- Standard call to get message count and if count=1, get the message
5412: FND_MSG_PUB.Count_And_Get (
5413: p_encoded => FND_API.G_FALSE,
5414: p_count => x_msg_count,
5415: p_data => x_msg_data

Line 5482: -- Standard Start of API savepoint

5478:
5479: BEGIN
5480: ---- Initialize----------------
5481:
5482: -- Standard Start of API savepoint
5483: SAVEPOINT manage_store_resp_on_delete;
5484:
5485: -- Standard call to check for call compatibility.
5486: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

5481:
5482: -- Standard Start of API savepoint
5483: SAVEPOINT manage_store_resp_on_delete;
5484:
5485: -- Standard call to check for call compatibility.
5486: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
5487: ,p_api_version_number
5488: ,l_api_name
5489: ,G_PKG_NAME

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

5608:
5609: WHEN FND_API.G_EXC_ERROR THEN
5610: ROLLBACK TO manage_store_resp_on_delete;
5611: x_return_status := FND_API.G_RET_STS_ERROR;
5612: -- Standard call to get message count and if count=1, get the message
5613: FND_MSG_PUB.Count_And_Get (
5614: p_encoded => FND_API.G_FALSE,
5615: p_count => x_msg_count,
5616: p_data => x_msg_data

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

5618:
5619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5620: ROLLBACK TO manage_store_resp_on_delete;
5621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5622: -- Standard call to get message count and if count=1, get the message
5623: FND_MSG_PUB.Count_And_Get (
5624: p_encoded => FND_API.G_FALSE,
5625: p_count => x_msg_count,
5626: p_data => x_msg_data

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

5632: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5633: THEN
5634: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5635: END IF;
5636: -- Standard call to get message count and if count=1, get the message
5637: FND_MSG_PUB.Count_And_Get (
5638: p_encoded => FND_API.G_FALSE,
5639: p_count => x_msg_count,
5640: p_data => x_msg_data

Line 5757: -- Standard Start of API savepoint

5753:
5754: BEGIN
5755: ---- Initialize----------------
5756:
5757: -- Standard Start of API savepoint
5758: SAVEPOINT assign_default_resp;
5759:
5760: -- Standard call to check for call compatibility.
5761: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

5756:
5757: -- Standard Start of API savepoint
5758: SAVEPOINT assign_default_resp;
5759:
5760: -- Standard call to check for call compatibility.
5761: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
5762: ,p_api_version_number
5763: ,l_api_name
5764: ,G_PKG_NAME

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

5940:
5941: WHEN FND_API.G_EXC_ERROR THEN
5942: ROLLBACK TO assign_default_resp;
5943: x_return_status := FND_API.G_RET_STS_ERROR;
5944: -- Standard call to get message count and if count=1, get the message
5945: FND_MSG_PUB.Count_And_Get (
5946: p_encoded => FND_API.G_FALSE,
5947: p_count => x_msg_count,
5948: p_data => x_msg_data

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

5950:
5951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5952: ROLLBACK TO assign_default_resp;
5953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5954: -- Standard call to get message count and if count=1, get the message
5955: FND_MSG_PUB.Count_And_Get (
5956: p_encoded => FND_API.G_FALSE,
5957: p_count => x_msg_count,
5958: p_data => x_msg_data

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

5964: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5965: THEN
5966: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5967: END IF;
5968: -- Standard call to get message count and if count=1, get the message
5969: FND_MSG_PUB.Count_And_Get (
5970: p_encoded => FND_API.G_FALSE,
5971: p_count => x_msg_count,
5972: p_data => x_msg_data

Line 6023: -- Standard Start of API savepoint

6019: l_exist NUMBER;
6020: BEGIN
6021: ---- Initialize----------------
6022:
6023: -- Standard Start of API savepoint
6024: SAVEPOINT manage_resp_on_address_change;
6025:
6026: -- Standard call to check for call compatibility.
6027: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

6022:
6023: -- Standard Start of API savepoint
6024: SAVEPOINT manage_resp_on_address_change;
6025:
6026: -- Standard call to check for call compatibility.
6027: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
6028: ,p_api_version_number
6029: ,l_api_name
6030: ,G_PKG_NAME

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

6326:
6327: WHEN FND_API.G_EXC_ERROR THEN
6328: ROLLBACK TO manage_resp_on_address_change;
6329: x_return_status := FND_API.G_RET_STS_ERROR;
6330: -- Standard call to get message count and if count=1, get the message
6331: FND_MSG_PUB.Count_And_Get (
6332: p_encoded => FND_API.G_FALSE,
6333: p_count => x_msg_count,
6334: p_data => x_msg_data

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

6336:
6337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6338: ROLLBACK TO manage_resp_on_address_change;
6339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6340: -- Standard call to get message count and if count=1, get the message
6341: FND_MSG_PUB.Count_And_Get (
6342: p_encoded => FND_API.G_FALSE,
6343: p_count => x_msg_count,
6344: p_data => x_msg_data

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

6350: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6351: THEN
6352: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6353: END IF;
6354: -- Standard call to get message count and if count=1, get the message
6355: FND_MSG_PUB.Count_And_Get (
6356: p_encoded => FND_API.G_FALSE,
6357: p_count => x_msg_count,
6358: p_data => x_msg_data

Line 6395: -- Standard Start of API savepoint

6391:
6392: BEGIN
6393: ---- Initialize----------------
6394:
6395: -- Standard Start of API savepoint
6396: SAVEPOINT revoke_default_resp;
6397:
6398: -- Standard call to check for call compatibility.
6399: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

6394:
6395: -- Standard Start of API savepoint
6396: SAVEPOINT revoke_default_resp;
6397:
6398: -- Standard call to check for call compatibility.
6399: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
6400: ,p_api_version_number
6401: ,l_api_name
6402: ,G_PKG_NAME

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

6514:
6515: WHEN FND_API.G_EXC_ERROR THEN
6516: ROLLBACK TO revoke_default_resp;
6517: x_return_status := FND_API.G_RET_STS_ERROR;
6518: -- Standard call to get message count and if count=1, get the message
6519: FND_MSG_PUB.Count_And_Get (
6520: p_encoded => FND_API.G_FALSE,
6521: p_count => x_msg_count,
6522: p_data => x_msg_data

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

6524:
6525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6526: ROLLBACK TO revoke_default_resp;
6527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6528: -- Standard call to get message count and if count=1, get the message
6529: FND_MSG_PUB.Count_And_Get (
6530: p_encoded => FND_API.G_FALSE,
6531: p_count => x_msg_count,
6532: p_data => x_msg_data

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

6538: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6539: THEN
6540: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6541: END IF;
6542: -- Standard call to get message count and if count=1, get the message
6543: FND_MSG_PUB.Count_And_Get (
6544: p_encoded => FND_API.G_FALSE,
6545: p_count => x_msg_count,
6546: p_data => x_msg_data

Line 6591: -- Standard Start of API savepoint

6587:
6588: BEGIN
6589: ---- Initialize----------------
6590:
6591: -- Standard Start of API savepoint
6592: SAVEPOINT assign_user_resps;
6593:
6594: -- Standard call to check for call compatibility.
6595: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

6590:
6591: -- Standard Start of API savepoint
6592: SAVEPOINT assign_user_resps;
6593:
6594: -- Standard call to check for call compatibility.
6595: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
6596: ,p_api_version_number
6597: ,l_api_name
6598: ,G_PKG_NAME

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

6699:
6700: WHEN FND_API.G_EXC_ERROR THEN
6701: ROLLBACK TO assign_user_resps;
6702: x_return_status := FND_API.G_RET_STS_ERROR;
6703: -- Standard call to get message count and if count=1, get the message
6704: FND_MSG_PUB.Count_And_Get (
6705: p_encoded => FND_API.G_FALSE,
6706: p_count => x_msg_count,
6707: p_data => x_msg_data

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

6709:
6710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6711: ROLLBACK TO assign_user_resps;
6712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6713: -- Standard call to get message count and if count=1, get the message
6714: FND_MSG_PUB.Count_And_Get (
6715: p_encoded => FND_API.G_FALSE,
6716: p_count => x_msg_count,
6717: p_data => x_msg_data

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

6723: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6724: THEN
6725: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6726: END IF;
6727: -- Standard call to get message count and if count=1, get the message
6728: FND_MSG_PUB.Count_And_Get (
6729: p_encoded => FND_API.G_FALSE,
6730: p_count => x_msg_count,
6731: p_data => x_msg_data

Line 7121: -- Standard Start of API savepoint

7117:
7118: BEGIN
7119: ---- Initialize----------------
7120:
7121: -- Standard Start of API savepoint
7122: SAVEPOINT manage_merged_party_memb_resp;
7123:
7124: -- Standard call to check for call compatibility.
7125: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number

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

7120:
7121: -- Standard Start of API savepoint
7122: SAVEPOINT manage_merged_party_memb_resp;
7123:
7124: -- Standard call to check for call compatibility.
7125: IF NOT Fnd_Api.Compatible_API_Call (l_api_version_number
7126: ,p_api_version_number
7127: ,l_api_name
7128: ,G_PKG_NAME

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

7370:
7371: WHEN FND_API.G_EXC_ERROR THEN
7372: ROLLBACK TO manage_merged_party_memb_resp;
7373: x_return_status := FND_API.G_RET_STS_ERROR;
7374: -- Standard call to get message count and if count=1, get the message
7375: FND_MSG_PUB.Count_And_Get (
7376: p_encoded => FND_API.G_FALSE,
7377: p_count => x_msg_count,
7378: p_data => x_msg_data

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

7380:
7381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7382: ROLLBACK TO manage_merged_party_memb_resp;
7383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7384: -- Standard call to get message count and if count=1, get the message
7385: FND_MSG_PUB.Count_And_Get (
7386: p_encoded => FND_API.G_FALSE,
7387: p_count => x_msg_count,
7388: p_data => x_msg_data

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

7394: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7395: THEN
7396: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7397: END IF;
7398: -- Standard call to get message count and if count=1, get the message
7399: FND_MSG_PUB.Count_And_Get (
7400: p_encoded => FND_API.G_FALSE,
7401: p_count => x_msg_count,
7402: p_data => x_msg_data