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

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

56: --
57: -- p_which = 1. write to log
58: -- p_which = 2, write to output
59: --
60: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
61: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
62: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
63: g_log_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
64:

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

57: -- p_which = 1. write to log
58: -- p_which = 2, write to output
59: --
60: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
61: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
62: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
63: g_log_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
64:
65: PROCEDURE Write_Log(p_which number, p_mssg varchar2) IS

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

58: -- p_which = 2, write to output
59: --
60: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
61: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
62: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
63: g_log_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
64:
65: PROCEDURE Write_Log(p_which number, p_mssg varchar2) IS
66: BEGIN

Line 588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

584: END IF;
585: EXCEPTION
586: WHEN OTHERS THEN
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
589: fnd_msg_pub.add_exc_msg('AMS_UTLITY_PVT', 'Get_Resource_Role');
590: END IF;
591: RAISE;
592:

Line 589: fnd_msg_pub.add_exc_msg('AMS_UTLITY_PVT', 'Get_Resource_Role');

585: EXCEPTION
586: WHEN OTHERS THEN
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
589: fnd_msg_pub.add_exc_msg('AMS_UTLITY_PVT', 'Get_Resource_Role');
590: END IF;
591: RAISE;
592:
593: END Get_Resource_Role;

Line 777: FND_MSG_PUB.Add;

773: error_flag := TRUE;
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
776: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_item_name);
777: FND_MSG_PUB.Add;
778: END IF;
779:
780:
781:

Line 1030: FND_MSG_PUB.initialize;

1026: END IF;
1027:
1028: /* Initialize message list if p_init_msg_list is set to TRUE. */
1029: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1030: FND_MSG_PUB.initialize;
1031: END IF;
1032:
1033: /* Initialize API return status to success */
1034: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1073: FND_MSG_PUB.Add;

1069: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1070: THEN
1071: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');
1072: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
1073: FND_MSG_PUB.Add;
1074: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1075: RAISE FND_API.G_EXC_ERROR;
1076: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1105: FND_MSG_PUB.Add;

1101: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1102: THEN
1103: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
1104: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
1105: FND_MSG_PUB.Add;
1106: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1107: RAISE FND_API.G_EXC_ERROR;
1108: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1126: FND_MSG_PUB.Add;

1122: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1123: THEN
1124: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
1125: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
1126: FND_MSG_PUB.Add;
1127: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1128: RAISE FND_API.G_EXC_ERROR;
1129: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1145: FND_MSG_PUB.Add;

1141: /* Check for Procedure's x_return_status */
1142: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1143: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
1144: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
1145: FND_MSG_PUB.Add;
1146: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1173: FND_MSG_PUB.Add;

1169: /* Check for Procedure's x_return_status */
1170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1171: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
1172: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
1173: FND_MSG_PUB.Add;
1174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1175: RAISE FND_API.G_EXC_ERROR;
1176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1270: FND_MSG_PUB.Add;

1266: /* Check for Procedure's x_return_status */
1267: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1268: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
1269: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
1270: FND_MSG_PUB.Add;
1271: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1272: RAISE FND_API.G_EXC_ERROR;
1273: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1294: FND_MSG_PUB.Add;

1290: /* Check for Procedure's x_return_status */
1291: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1292: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
1293: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
1294: FND_MSG_PUB.Add;
1295: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1329: FND_MSG_PUB.Add;

1325: /* Check for Procedure's x_return_status */
1326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1327: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
1328: FND_MESSAGE.SET_TOKEN('ID',p_enrl_request_id);
1329: FND_MSG_PUB.Add;
1330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1331: RAISE FND_API.G_EXC_ERROR;
1332: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1343: FND_MSG_PUB.Count_And_Get

1339: COMMIT WORK;
1340: END IF;
1341:
1342: /* Standard call to get message count and if count is 1, get message info.*/
1343: FND_MSG_PUB.Count_And_Get
1344: ( p_count => x_msg_count ,
1345: p_data => x_msg_data
1346: );
1347: END IF;

Line 1353: FND_MSG_PUB.Count_And_Get

1349: EXCEPTION
1350: WHEN FND_API.G_EXC_ERROR THEN
1351: ROLLBACK TO send_thnkyou_notif_PVT;
1352: x_return_status := FND_API.G_RET_STS_ERROR ;
1353: FND_MSG_PUB.Count_And_Get
1354: ( p_count => x_msg_count ,
1355: p_data => x_msg_data
1356: );
1357:

Line 1361: FND_MSG_PUB.Count_And_Get

1357:
1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1359: ROLLBACK TO send_thnkyou_notif_PVT;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1361: FND_MSG_PUB.Count_And_Get
1362: ( p_count => x_msg_count ,
1363: p_data => x_msg_data
1364: );
1365:

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

1365:
1366: WHEN OTHERS THEN
1367: ROLLBACK TO send_thnkyou_notif_PVT;
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1369: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1370: THEN
1371: FND_MSG_PUB.Add_Exc_Msg
1372: ( G_FILE_NAME
1373: , G_PKG_NAME

Line 1371: FND_MSG_PUB.Add_Exc_Msg

1367: ROLLBACK TO send_thnkyou_notif_PVT;
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1369: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1370: THEN
1371: FND_MSG_PUB.Add_Exc_Msg
1372: ( G_FILE_NAME
1373: , G_PKG_NAME
1374: );
1375: END IF;

Line 1376: FND_MSG_PUB.Count_And_Get

1372: ( G_FILE_NAME
1373: , G_PKG_NAME
1374: );
1375: END IF;
1376: FND_MSG_PUB.Count_And_Get
1377: ( p_count => x_msg_count
1378: , p_data => x_msg_data
1379: );
1380: END send_thnkyou_notif;

Line 1496: FND_MSG_PUB.initialize;

1492: END IF;
1493:
1494: /* Initialize message list if p_init_msg_list is set to TRUE. */
1495: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1496: FND_MSG_PUB.initialize;
1497: END IF;
1498:
1499: /* Initialize API return status to success */
1500: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1544: FND_MSG_PUB.Add;

1540:
1541: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1542: FND_MESSAGE.SET_NAME('PV','PV_MBRSHIP_NOT_EXIST');
1543: FND_MESSAGE.SET_TOKEN('MEMBERSHIP_ID',p_membership_id);
1544: FND_MSG_PUB.Add;
1545: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1546: RAISE FND_API.G_EXC_ERROR;
1547: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1575: FND_MSG_PUB.Add;

1571: /* Check for Procedure's x_return_status */
1572: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1573: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
1574: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',l_enrl_request_id);
1575: FND_MSG_PUB.Add;
1576: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1594: FND_MSG_PUB.Add;

1590:
1591: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1592: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
1593: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
1594: FND_MSG_PUB.Add;
1595: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1596: RAISE FND_API.G_EXC_ERROR;
1597: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1613: FND_MSG_PUB.Add;

1609: /* Check for Procedure's x_return_status */
1610: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1611: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
1612: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
1613: FND_MSG_PUB.Add;
1614: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1615: RAISE FND_API.G_EXC_ERROR;
1616: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1643: FND_MSG_PUB.Add;

1639: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1640: THEN
1641: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
1642: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
1643: FND_MSG_PUB.Add;
1644: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1645: RAISE FND_API.G_EXC_ERROR;
1646: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1768: FND_MSG_PUB.Add;

1764: /* Check for Procedure's x_return_status */
1765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1766: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
1767: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
1768: FND_MSG_PUB.Add;
1769: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1770: RAISE FND_API.G_EXC_ERROR;
1771: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1793: FND_MSG_PUB.Add;

1789: /* Check for Procedure's x_return_status */
1790: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1791: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
1792: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
1793: FND_MSG_PUB.Add;
1794: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1795: RAISE FND_API.G_EXC_ERROR;
1796: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1828: FND_MSG_PUB.Add;

1824: /* Check for Procedure's x_return_status */
1825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1826: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
1827: FND_MESSAGE.SET_TOKEN('ID',p_membership_id);
1828: FND_MSG_PUB.Add;
1829: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1830: RAISE FND_API.G_EXC_ERROR;
1831: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1842: FND_MSG_PUB.Count_And_Get

1838: COMMIT WORK;
1839: END IF;
1840:
1841: -- Standard call to get message count and if count is 1, get message info.
1842: FND_MSG_PUB.Count_And_Get
1843: ( p_count => x_msg_count ,
1844: p_data => x_msg_data
1845: );
1846:

Line 1853: FND_MSG_PUB.Count_And_Get

1849: EXCEPTION
1850: WHEN FND_API.G_EXC_ERROR THEN
1851: ROLLBACK TO send_welcome_notif_PVT;
1852: x_return_status := FND_API.G_RET_STS_ERROR ;
1853: FND_MSG_PUB.Count_And_Get
1854: ( p_count => x_msg_count ,
1855: p_data => x_msg_data
1856: );
1857:

Line 1861: FND_MSG_PUB.Count_And_Get

1857:
1858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1859: ROLLBACK TO send_welcome_notif_PVT;
1860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1861: FND_MSG_PUB.Count_And_Get
1862: ( p_count => x_msg_count ,
1863: p_data => x_msg_data
1864: );
1865:

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

1865:
1866: WHEN OTHERS THEN
1867: ROLLBACK TO send_welcome_notif_PVT;
1868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1870: THEN
1871: FND_MSG_PUB.Add_Exc_Msg
1872: ( G_FILE_NAME
1873: , G_PKG_NAME

Line 1871: FND_MSG_PUB.Add_Exc_Msg

1867: ROLLBACK TO send_welcome_notif_PVT;
1868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1870: THEN
1871: FND_MSG_PUB.Add_Exc_Msg
1872: ( G_FILE_NAME
1873: , G_PKG_NAME
1874: );
1875: END IF;

Line 1876: FND_MSG_PUB.Count_And_Get

1872: ( G_FILE_NAME
1873: , G_PKG_NAME
1874: );
1875: END IF;
1876: FND_MSG_PUB.Count_And_Get
1877: ( p_count => x_msg_count
1878: , p_data => x_msg_data
1879: );
1880: END send_welcome_notif;

Line 1995: FND_MSG_PUB.initialize;

1991: END IF;
1992:
1993: -- Initialize message list if p_init_msg_list is set to TRUE.
1994: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1995: FND_MSG_PUB.initialize;
1996: END IF;
1997:
1998: /* Initialize API return status to success */
1999: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2040: FND_MSG_PUB.Add;

2036:
2037: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2038: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');
2039: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
2040: FND_MSG_PUB.Add;
2041: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2042: RAISE FND_API.G_EXC_ERROR;
2043: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2070: FND_MSG_PUB.Add;

2066: /* Check for API return status */
2067: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2068: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
2069: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
2070: FND_MSG_PUB.Add;
2071: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2072: RAISE FND_API.G_EXC_ERROR;
2073: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2114: FND_MSG_PUB.Add;

2110:
2111: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2112: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
2113: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
2114: FND_MSG_PUB.Add;
2115: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2116: RAISE FND_API.G_EXC_ERROR;
2117: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2132: FND_MSG_PUB.Add;

2128:
2129: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2130: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
2131: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
2132: FND_MSG_PUB.Add;
2133: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2134: RAISE FND_API.G_EXC_ERROR;
2135: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2159: FND_MSG_PUB.Add;

2155:
2156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2157: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
2158: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
2159: FND_MSG_PUB.Add;
2160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2161: RAISE FND_API.G_EXC_ERROR;
2162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2250: FND_MSG_PUB.Add;

2246:
2247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2248: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
2249: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
2250: FND_MSG_PUB.Add;
2251: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2252: RAISE FND_API.G_EXC_ERROR;
2253: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2274: FND_MSG_PUB.Add;

2270:
2271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2272: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
2273: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
2274: FND_MSG_PUB.Add;
2275: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2276: RAISE FND_API.G_EXC_ERROR;
2277: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2310: FND_MSG_PUB.Add;

2306: /* if any error happens rollback only this row, and proceed to next record. otherwise commit */
2307: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2308: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
2309: FND_MESSAGE.SET_TOKEN('ID',p_enrl_request_id);
2310: FND_MSG_PUB.Add;
2311: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2312: RAISE FND_API.G_EXC_ERROR;
2313: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2324: FND_MSG_PUB.Count_And_Get

2320: COMMIT WORK;
2321: END IF;
2322:
2323: -- Standard call to get message count and if count is 1, get message info.
2324: FND_MSG_PUB.Count_And_Get
2325: ( p_count => x_msg_count ,
2326: p_data => x_msg_data
2327: );
2328:

Line 2335: FND_MSG_PUB.Count_And_Get

2331: EXCEPTION
2332: WHEN FND_API.G_EXC_ERROR THEN
2333: ROLLBACK TO send_rejection_notif_PVT;
2334: x_return_status := FND_API.G_RET_STS_ERROR ;
2335: FND_MSG_PUB.Count_And_Get
2336: ( p_count => x_msg_count ,
2337: p_data => x_msg_data
2338: );
2339:

Line 2343: FND_MSG_PUB.Count_And_Get

2339:
2340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2341: ROLLBACK TO send_rejection_notif_PVT;
2342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2343: FND_MSG_PUB.Count_And_Get
2344: ( p_count => x_msg_count ,
2345: p_data => x_msg_data
2346: );
2347:

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

2347:
2348: WHEN OTHERS THEN
2349: ROLLBACK TO send_rejection_notif_PVT;
2350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2351: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2352: THEN
2353: FND_MSG_PUB.Add_Exc_Msg
2354: ( G_FILE_NAME
2355: , G_PKG_NAME

Line 2353: FND_MSG_PUB.Add_Exc_Msg

2349: ROLLBACK TO send_rejection_notif_PVT;
2350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2351: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2352: THEN
2353: FND_MSG_PUB.Add_Exc_Msg
2354: ( G_FILE_NAME
2355: , G_PKG_NAME
2356: );
2357: END IF;

Line 2358: FND_MSG_PUB.Count_And_Get

2354: ( G_FILE_NAME
2355: , G_PKG_NAME
2356: );
2357: END IF;
2358: FND_MSG_PUB.Count_And_Get
2359: ( p_count => x_msg_count
2360: , p_data => x_msg_data
2361: );
2362: END send_rejection_notif;

Line 2477: FND_MSG_PUB.initialize;

2473: END IF;
2474:
2475: -- Initialize message list if p_init_msg_list is set to TRUE.
2476: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2477: FND_MSG_PUB.initialize;
2478: END IF;
2479:
2480: /* Initialize API return status to success */
2481: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2522: FND_MSG_PUB.Add;

2518:
2519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2520: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');
2521: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
2522: FND_MSG_PUB.Add;
2523: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2524: RAISE FND_API.G_EXC_ERROR;
2525: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2552: FND_MSG_PUB.Add;

2548: /* Check the Procedure's x_return_status */
2549: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2550: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
2551: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
2552: FND_MSG_PUB.Add;
2553: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2554: RAISE FND_API.G_EXC_ERROR;
2555: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2572: FND_MSG_PUB.Add;

2568: /* Check the Procedure's x_return_status */
2569: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2570: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
2571: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
2572: FND_MSG_PUB.Add;
2573: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2574: RAISE FND_API.G_EXC_ERROR;
2575: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2591: FND_MSG_PUB.Add;

2587: /* Check the Procedure's x_return_status */
2588: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2589: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
2590: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
2591: FND_MSG_PUB.Add;
2592: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2593: RAISE FND_API.G_EXC_ERROR;
2594: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2618: FND_MSG_PUB.Add;

2614: /* Check the Procedure's x_return_status */
2615: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2616: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
2617: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
2618: FND_MSG_PUB.Add;
2619: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2620: RAISE FND_API.G_EXC_ERROR;
2621: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2711: FND_MSG_PUB.Add;

2707: /* Check the Procedure's x_return_status */
2708: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2709: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
2710: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
2711: FND_MSG_PUB.Add;
2712: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2713: RAISE FND_API.G_EXC_ERROR;
2714: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2736: FND_MSG_PUB.Add;

2732: /* Check the Procedure's x_return_status */
2733: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2734: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
2735: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
2736: FND_MSG_PUB.Add;
2737: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2738: RAISE FND_API.G_EXC_ERROR;
2739: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2772: FND_MSG_PUB.Add;

2768: /* Check for x_return_status */
2769: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2770: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
2771: FND_MESSAGE.SET_TOKEN('ID',p_enrl_request_id);
2772: FND_MSG_PUB.Add;
2773: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2774: RAISE FND_API.G_EXC_ERROR;
2775: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2786: FND_MSG_PUB.Count_And_Get

2782: COMMIT WORK;
2783: END IF;
2784:
2785: -- Standard call to get message count and if count is 1, get message info.
2786: FND_MSG_PUB.Count_And_Get
2787: ( p_count => x_msg_count ,
2788: p_data => x_msg_data
2789: );
2790:

Line 2797: FND_MSG_PUB.Count_And_Get

2793: EXCEPTION
2794: WHEN FND_API.G_EXC_ERROR THEN
2795: ROLLBACK TO send_cntrct_notrcvd_notif_PVT;
2796: x_return_status := FND_API.G_RET_STS_ERROR ;
2797: FND_MSG_PUB.Count_And_Get
2798: ( p_count => x_msg_count ,
2799: p_data => x_msg_data
2800: );
2801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2804: FND_MSG_PUB.Count_And_Get

2800: );
2801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2802: ROLLBACK TO send_cntrct_notrcvd_notif_PVT;
2803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2804: FND_MSG_PUB.Count_And_Get
2805: ( p_count => x_msg_count ,
2806: p_data => x_msg_data
2807: );
2808: WHEN OTHERS THEN

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

2808: WHEN OTHERS THEN
2809: ROLLBACK TO send_cntrct_notrcvd_notif_PVT;
2810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2811:
2812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2813: THEN
2814: FND_MSG_PUB.Add_Exc_Msg
2815: ( G_FILE_NAME
2816: , G_PKG_NAME

Line 2814: FND_MSG_PUB.Add_Exc_Msg

2810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2811:
2812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2813: THEN
2814: FND_MSG_PUB.Add_Exc_Msg
2815: ( G_FILE_NAME
2816: , G_PKG_NAME
2817: );
2818: END IF;

Line 2819: FND_MSG_PUB.Count_And_Get

2815: ( G_FILE_NAME
2816: , G_PKG_NAME
2817: );
2818: END IF;
2819: FND_MSG_PUB.Count_And_Get
2820: ( p_count => x_msg_count
2821: , p_data => x_msg_data
2822: );
2823: END send_cntrct_notrcvd_notif;

Line 2943: FND_MSG_PUB.initialize;

2939: END IF;
2940:
2941: -- Initialize message list if p_init_msg_list is set to TRUE.
2942: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2943: FND_MSG_PUB.initialize;
2944: END IF;
2945:
2946: /* Initialize API return status to success */
2947: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2991: FND_MSG_PUB.Add;

2987: /* Check Procedure's x_return_status */
2988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2989: FND_MESSAGE.SET_NAME('PV','PV_MBRSHIP_NOT_EXIST');
2990: FND_MESSAGE.SET_TOKEN('MEMBERSHIP_ID',p_membership_id);
2991: FND_MSG_PUB.Add;
2992: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3021: FND_MSG_PUB.Add;

3017: /* Check for Procedure's x_return_status */
3018: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3019: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
3020: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',l_enrl_request_id);
3021: FND_MSG_PUB.Add;
3022: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3023: RAISE FND_API.G_EXC_ERROR;
3024: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3065: FND_MSG_PUB.Add;

3061: /* Check the Procedure's x_return_status */
3062: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3063: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
3064: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
3065: FND_MSG_PUB.Add;
3066: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3067: RAISE FND_API.G_EXC_ERROR;
3068: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3084: FND_MSG_PUB.Add;

3080: /* Check the Procedure's x_return_status */
3081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3082: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
3083: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
3084: FND_MSG_PUB.Add;
3085: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3086: RAISE FND_API.G_EXC_ERROR;
3087: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3112: FND_MSG_PUB.Add;

3108: /* Check the Procedure's x_return_status */
3109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3110: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
3111: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
3112: FND_MSG_PUB.Add;
3113: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3114: RAISE FND_API.G_EXC_ERROR;
3115: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3224: FND_MSG_PUB.Add;

3220: /* Check the Procedure's x_return_status */
3221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3222: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
3223: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
3224: FND_MSG_PUB.Add;
3225: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3226: RAISE FND_API.G_EXC_ERROR;
3227: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3249: FND_MSG_PUB.Add;

3245: /* Check the Procedure's x_return_status */
3246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3247: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
3248: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
3249: FND_MSG_PUB.Add;
3250: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3251: RAISE FND_API.G_EXC_ERROR;
3252: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3284: FND_MSG_PUB.Add;

3280: /* Check for x_return_status */
3281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3282: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
3283: FND_MESSAGE.SET_TOKEN('ID',p_membership_id);
3284: FND_MSG_PUB.Add;
3285: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3286: RAISE FND_API.G_EXC_ERROR;
3287: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3298: FND_MSG_PUB.Count_And_Get

3294: COMMIT WORK;
3295: END IF;
3296:
3297: -- Standard call to get message count and if count is 1, get message info.
3298: FND_MSG_PUB.Count_And_Get
3299: ( p_count => x_msg_count ,
3300: p_data => x_msg_data
3301: );
3302:

Line 3309: FND_MSG_PUB.Count_And_Get

3305: EXCEPTION
3306: WHEN FND_API.G_EXC_ERROR THEN
3307: ROLLBACK TO send_mbership_expiry_notif_PVT;
3308: x_return_status := FND_API.G_RET_STS_ERROR ;
3309: FND_MSG_PUB.Count_And_Get
3310: ( p_count => x_msg_count ,
3311: p_data => x_msg_data
3312: );
3313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3316: FND_MSG_PUB.Count_And_Get

3312: );
3313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3314: ROLLBACK TO send_mbership_expiry_notif_PVT;
3315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3316: FND_MSG_PUB.Count_And_Get
3317: ( p_count => x_msg_count ,
3318: p_data => x_msg_data
3319: );
3320: WHEN OTHERS THEN

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

3319: );
3320: WHEN OTHERS THEN
3321: ROLLBACK TO send_mbership_expiry_notif_PVT;
3322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3323: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3324: THEN
3325: FND_MSG_PUB.Add_Exc_Msg
3326: ( G_FILE_NAME
3327: , G_PKG_NAME

Line 3325: FND_MSG_PUB.Add_Exc_Msg

3321: ROLLBACK TO send_mbership_expiry_notif_PVT;
3322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3323: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3324: THEN
3325: FND_MSG_PUB.Add_Exc_Msg
3326: ( G_FILE_NAME
3327: , G_PKG_NAME
3328: );
3329: END IF;

Line 3330: FND_MSG_PUB.Count_And_Get

3326: ( G_FILE_NAME
3327: , G_PKG_NAME
3328: );
3329: END IF;
3330: FND_MSG_PUB.Count_And_Get
3331: ( p_count => x_msg_count
3332: , p_data => x_msg_data
3333: );
3334: END send_mbrship_exp_notif;

Line 3436: FND_MSG_PUB.initialize;

3432: END IF;
3433:
3434: /* Initialize message list if p_init_msg_list is set to TRUE. */
3435: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3436: FND_MSG_PUB.initialize;
3437: END IF;
3438:
3439: /* Initialize API return status to success */
3440: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3501: FND_MSG_PUB.Add;

3497: /* Check the Procedure's x_return_status */
3498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3499: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
3500: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',p_mbrship_chng_rec.resource_id);
3501: FND_MSG_PUB.Add;
3502: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3503: RAISE FND_API.G_EXC_ERROR;
3504: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3522: FND_MSG_PUB.Add;

3518: /* Check the Procedure's x_return_status */
3519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3520: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
3521: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
3522: FND_MSG_PUB.Add;
3523: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3524: RAISE FND_API.G_EXC_ERROR;
3525: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3549: FND_MSG_PUB.Add;

3545: /* Check the Procedure's x_return_status */
3546: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3547: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
3548: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
3549: FND_MSG_PUB.Add;
3550: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3551: RAISE FND_API.G_EXC_ERROR;
3552: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3588: FND_MSG_PUB.Add;

3584: /* Check the Procedure's x_return_status */
3585: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3586: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
3587: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
3588: FND_MSG_PUB.Add;
3589: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3590: RAISE FND_API.G_EXC_ERROR;
3591: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3613: FND_MSG_PUB.Add;

3609: /* Check the Procedure's x_return_status */
3610: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3611: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
3612: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
3613: FND_MSG_PUB.Add;
3614: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3615: RAISE FND_API.G_EXC_ERROR;
3616: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3661: FND_MSG_PUB.Add;

3657: -- Check for x_return_status
3658: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3659: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
3660: FND_MESSAGE.SET_TOKEN('ID',p_mbrship_chng_rec.id);
3661: FND_MSG_PUB.Add;
3662: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3663: RAISE FND_API.G_EXC_ERROR;
3664: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3675: FND_MSG_PUB.Count_And_Get(

3671: COMMIT WORK;
3672: END IF;
3673:
3674: /* Standard call to get message count and if count is 1, get message info. */
3675: FND_MSG_PUB.Count_And_Get(
3676: p_count => x_msg_count ,
3677: p_data => x_msg_data
3678: );
3679:

Line 3684: FND_MSG_PUB.Count_And_Get

3680: EXCEPTION
3681: WHEN FND_API.G_EXC_ERROR THEN
3682: ROLLBACK TO send_mbrship_chng_notif;
3683: x_return_status := FND_API.G_RET_STS_ERROR ;
3684: FND_MSG_PUB.Count_And_Get
3685: ( p_count => x_msg_count ,
3686: p_data => x_msg_data
3687: );
3688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3691: FND_MSG_PUB.Count_And_Get

3687: );
3688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3689: ROLLBACK TO send_mbrship_chng_notif;
3690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3691: FND_MSG_PUB.Count_And_Get
3692: ( p_count => x_msg_count ,
3693: p_data => x_msg_data
3694: );
3695: WHEN OTHERS THEN

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

3694: );
3695: WHEN OTHERS THEN
3696: ROLLBACK TO send_mbrship_chng_notif;
3697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3698: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3699: THEN
3700: FND_MSG_PUB.Add_Exc_Msg
3701: ( G_FILE_NAME
3702: , G_PKG_NAME

Line 3700: FND_MSG_PUB.Add_Exc_Msg

3696: ROLLBACK TO send_mbrship_chng_notif;
3697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3698: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3699: THEN
3700: FND_MSG_PUB.Add_Exc_Msg
3701: ( G_FILE_NAME
3702: , G_PKG_NAME
3703: );
3704: END IF;

Line 3705: FND_MSG_PUB.Count_And_Get

3701: ( G_FILE_NAME
3702: , G_PKG_NAME
3703: );
3704: END IF;
3705: FND_MSG_PUB.Count_And_Get
3706: ( p_count => x_msg_count
3707: , p_data => x_msg_data
3708: );
3709: End send_mbrship_chng_notif;

Line 3785: FND_MSG_PUB.Add;

3781: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');
3782: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');
3783: FND_MESSAGE.SET_TOKEN('ITEM_NAME','MEMBERSHIP_ID');
3784: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_mbrship_id);
3785: FND_MSG_PUB.Add;
3786: END IF;
3787:
3788:
3789: ELSIF (l_notif_type = 'PG_CONTRCT_NRCVD' ) THEN

Line 3812: FND_MSG_PUB.Add;

3808: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');
3809: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');
3810: FND_MESSAGE.SET_TOKEN('ITEM_NAME','ENRL_REQUEST_ID');
3811: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_enrl_req_id);
3812: FND_MSG_PUB.Add;
3813: END IF;
3814:
3815: END IF;
3816:

Line 3824: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3820: EXCEPTION
3821: -- The line below records this function call in the error system
3822: -- in the case of an exception.
3823: WHEN OTHERS THEN
3824: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3825: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'send_ini_rmdr_notif');
3826: END IF;
3827: wf_core.context(G_PKG_NAME,'send_ini_rmdr_notif', itemtype,itemkey,to_char(actid),funcmode);
3828:

Line 3825: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'send_ini_rmdr_notif');

3821: -- The line below records this function call in the error system
3822: -- in the case of an exception.
3823: WHEN OTHERS THEN
3824: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3825: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'send_ini_rmdr_notif');
3826: END IF;
3827: wf_core.context(G_PKG_NAME,'send_ini_rmdr_notif', itemtype,itemkey,to_char(actid),funcmode);
3828:
3829: END send_ini_rmdr_notif;

Line 4325: fnd_msg_pub.Get

4321: CLOSE c_getptrprgm;
4322: Write_log (1,'Error expiring membership in program:'||l_program_name||'for partner: ' || l_partner_name|| 'with Status as :'||x_return_status || 'with error message as: ' || x_msg_data );
4323:
4324: for I in 1 .. x_msg_count LOOP
4325: fnd_msg_pub.Get
4326: ( p_msg_index => FND_MSG_PUB.G_NEXT
4327: ,p_encoded => FND_API.G_FALSE
4328: ,p_data => x_msg_data
4329: ,p_msg_index_out => l_index

Line 4326: ( p_msg_index => FND_MSG_PUB.G_NEXT

4322: Write_log (1,'Error expiring membership in program:'||l_program_name||'for partner: ' || l_partner_name|| 'with Status as :'||x_return_status || 'with error message as: ' || x_msg_data );
4323:
4324: for I in 1 .. x_msg_count LOOP
4325: fnd_msg_pub.Get
4326: ( p_msg_index => FND_MSG_PUB.G_NEXT
4327: ,p_encoded => FND_API.G_FALSE
4328: ,p_data => x_msg_data
4329: ,p_msg_index_out => l_index
4330: );

Line 4375: fnd_msg_pub.Get

4371: FETCH c_getptrprgm INTO l_partner_name,l_program_name;
4372: CLOSE c_getptrprgm;
4373: Write_log (1,'Error in renewing membership in program :'|| l_program_name|| ' for partner: ' || l_partner_name || ' with status as: ' || x_return_status || ' and error message is: ' || x_msg_data );
4374: for I in 1 .. x_msg_count LOOP
4375: fnd_msg_pub.Get
4376: ( p_msg_index => FND_MSG_PUB.G_NEXT
4377: ,p_encoded => FND_API.G_FALSE
4378: ,p_data => x_msg_data
4379: ,p_msg_index_out => l_index

Line 4376: ( p_msg_index => FND_MSG_PUB.G_NEXT

4372: CLOSE c_getptrprgm;
4373: Write_log (1,'Error in renewing membership in program :'|| l_program_name|| ' for partner: ' || l_partner_name || ' with status as: ' || x_return_status || ' and error message is: ' || x_msg_data );
4374: for I in 1 .. x_msg_count LOOP
4375: fnd_msg_pub.Get
4376: ( p_msg_index => FND_MSG_PUB.G_NEXT
4377: ,p_encoded => FND_API.G_FALSE
4378: ,p_data => x_msg_data
4379: ,p_msg_index_out => l_index
4380: );

Line 4415: fnd_msg_pub.Get

4411: FETCH c_getptrprgm INTO l_partner_name,l_program_name;
4412: CLOSE c_getptrprgm;
4413: Write_log (1,'Error activating membership in program '|| l_program_name|| ' for partner ' || l_partner_name ||' with status as ' || x_return_status || ' and the error message is ' || x_msg_data );
4414: for I in 1 .. x_msg_count LOOP
4415: fnd_msg_pub.Get
4416: ( p_msg_index => FND_MSG_PUB.G_NEXT
4417: ,p_encoded => FND_API.G_FALSE
4418: ,p_data => x_msg_data
4419: ,p_msg_index_out => l_index

Line 4416: ( p_msg_index => FND_MSG_PUB.G_NEXT

4412: CLOSE c_getptrprgm;
4413: Write_log (1,'Error activating membership in program '|| l_program_name|| ' for partner ' || l_partner_name ||' with status as ' || x_return_status || ' and the error message is ' || x_msg_data );
4414: for I in 1 .. x_msg_count LOOP
4415: fnd_msg_pub.Get
4416: ( p_msg_index => FND_MSG_PUB.G_NEXT
4417: ,p_encoded => FND_API.G_FALSE
4418: ,p_data => x_msg_data
4419: ,p_msg_index_out => l_index
4420: );

Line 4470: fnd_msg_pub.Get

4466: FETCH c_getptrprgm INTO l_partner_name,l_program_name;
4467: CLOSE c_getptrprgm;
4468: Write_log (1,'Error Creating Enrollment Log for program: '|| l_program_name|| ' for partner ' || l_partner_name || ' with status as ' || x_return_status || ' and error message is ' || x_msg_data );
4469: for I in 1 .. x_msg_count LOOP
4470: fnd_msg_pub.Get
4471: ( p_msg_index => FND_MSG_PUB.G_NEXT
4472: ,p_encoded => FND_API.G_FALSE
4473: ,p_data => x_msg_data
4474: ,p_msg_index_out => l_index

Line 4471: ( p_msg_index => FND_MSG_PUB.G_NEXT

4467: CLOSE c_getptrprgm;
4468: Write_log (1,'Error Creating Enrollment Log for program: '|| l_program_name|| ' for partner ' || l_partner_name || ' with status as ' || x_return_status || ' and error message is ' || x_msg_data );
4469: for I in 1 .. x_msg_count LOOP
4470: fnd_msg_pub.Get
4471: ( p_msg_index => FND_MSG_PUB.G_NEXT
4472: ,p_encoded => FND_API.G_FALSE
4473: ,p_data => x_msg_data
4474: ,p_msg_index_out => l_index
4475: );

Line 4636: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4632:
4633: -- write to log
4634: EXCEPTION
4635: WHEN OTHERS THEN
4636: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4637: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4638: END IF;
4639: wf_core.context(G_PKG_NAME,'set_event_code', itemtype,itemkey,to_char(actid),funcmode);
4640: resultout := 'COMPLETE:' ;

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

4633: -- write to log
4634: EXCEPTION
4635: WHEN OTHERS THEN
4636: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4637: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4638: END IF;
4639: wf_core.context(G_PKG_NAME,'set_event_code', itemtype,itemkey,to_char(actid),funcmode);
4640: resultout := 'COMPLETE:' ;
4641: raise;

Line 4770: FND_MSG_PUB.Add;

4766: /* Check the Procedure's x_return_status */
4767: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4768: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
4769: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notification_id);
4770: FND_MSG_PUB.Add;
4771: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4772: RAISE FND_API.G_EXC_ERROR;
4773: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4796: FND_MSG_PUB.Add;

4792: /* Check the Procedure's x_return_status */
4793: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4794: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
4795: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notification_id);
4796: FND_MSG_PUB.Add;
4797: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4798: RAISE FND_API.G_EXC_ERROR;
4799: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4817: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4813:
4814:
4815: EXCEPTION
4816: WHEN OTHERS THEN
4817: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4818: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4819: END IF;
4820:
4821: --write_to_enrollment_log

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

4814:
4815: EXCEPTION
4816: WHEN OTHERS THEN
4817: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4818: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4819: END IF;
4820:
4821: --write_to_enrollment_log
4822: wf_core.context(G_PKG_NAME,'log_action', itemtype,itemkey,to_char(actid),funcmode);

Line 4949: fnd_msg_pub.initialize;

4945: END IF;
4946: -- Initialize message list if p_init_msg_list is set to TRUE.
4947: IF FND_API.to_Boolean( p_init_msg_list )
4948: THEN
4949: fnd_msg_pub.initialize;
4950: END IF;
4951:
4952:
4953: IF (PV_DEBUG_HIGH_ON) THEN

Line 5002: fnd_msg_pub.Add;

4998: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
4999: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5000: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_NOTIF_CATEGORY' );
5001: FND_MESSAGE.set_token('LOOKUP_CODE', p_target_ctgry );
5002: fnd_msg_pub.Add;
5003: RAISE FND_API.G_EXC_ERROR;
5004: END IF;
5005:
5006: --validate the lookupcode for event

Line 5016: fnd_msg_pub.Add;

5012: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5013: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5014: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_NOTIFICATION_EVENT_TYPE' );
5015: FND_MESSAGE.set_token('LOOKUP_CODE', p_notif_event_code );
5016: fnd_msg_pub.Add;
5017: RAISE FND_API.G_EXC_ERROR;
5018: END IF;
5019:
5020: --validate the lookupcodfe for entity code

Line 5030: fnd_msg_pub.Add;

5026: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5027: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5028: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_TYPE' );
5029: FND_MESSAGE.set_token('LOOKUP_CODE', p_entity_code );
5030: fnd_msg_pub.Add;
5031: RAISE FND_API.G_EXC_ERROR;
5032: END IF;
5033:
5034: --validate the lookup for context code

Line 5118: FND_MSG_PUB.Add;

5114: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
5115: THEN
5116: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');
5117: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_entity_id);
5118: FND_MSG_PUB.Add;
5119: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5120: RAISE FND_API.G_EXC_ERROR;
5121: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5144: FND_MSG_PUB.Add;

5140: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
5141: THEN
5142: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
5143: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_entity_id);
5144: FND_MSG_PUB.Add;
5145: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5146: RAISE FND_API.G_EXC_ERROR;
5147: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5167: FND_MSG_PUB.Add;

5163: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
5164: THEN
5165: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
5166: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
5167: FND_MSG_PUB.Add;
5168: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5169: RAISE FND_API.G_EXC_ERROR;
5170: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5206: FND_MSG_PUB.Add;

5202:
5203: -- raise error if its an invitation. else.. log it and return without sending any notification
5204: IF p_notif_event_code IN ( 'PG_INVITE','VAD_INVITE_IMP') THEN
5205: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_CNTCT_FOR_INVITE');
5206: FND_MSG_PUB.Add;
5207: RAISE FND_API.G_EXC_ERROR;
5208: ELSE
5209: fnd_message.set_name ('PV', 'PV_NO_PRIMARY_USER_EXIST');
5210: fnd_message.set_token ('PARTNER_ID',l_notif_targeted_ptr_id);

Line 5211: FND_MSG_PUB.Add;

5207: RAISE FND_API.G_EXC_ERROR;
5208: ELSE
5209: fnd_message.set_name ('PV', 'PV_NO_PRIMARY_USER_EXIST');
5210: fnd_message.set_token ('PARTNER_ID',l_notif_targeted_ptr_id);
5211: FND_MSG_PUB.Add;
5212: l_string := SUBSTR(fnd_message.get,1,1000);
5213: WRITE_TO_FND_LOG(l_api_name,l_string );
5214: x_return_status := FND_API.G_RET_STS_SUCCESS;
5215: IF x_msg_count is null THEN

Line 5234: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

5230: l_notif_user_id :=substr(l_notif_user_id,2);
5231: l_pt_adhoc_role := 'PV_' || l_itemKey ;
5232: l_role_disp_name :='Primary Users';
5233: -- Debug Message
5234: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
5235: PVX_UTILITY_PVT.debug_message( 'Creating role PT: '|| l_pt_adhoc_role);
5236: END IF;
5237: wf_directory.CreateAdHocRole2
5238: (

Line 5545: FND_MSG_PUB.Add;

5541: /* Check for Procedure's x_return_status */
5542: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5543: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
5544: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_partner_id );
5545: FND_MSG_PUB.Add;
5546: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5547: RAISE FND_API.G_EXC_ERROR;
5548: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5630: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

5626: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
5627: raise FND_API.G_EXC_ERROR;
5628: end if;
5629:
5630: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
5631: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
5632: fnd_message.Set_token('TEXT', 'After Checkforerror');
5633: fnd_msg_pub.Add;
5634: END IF;

Line 5633: fnd_msg_pub.Add;

5629:
5630: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
5631: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
5632: fnd_message.Set_token('TEXT', 'After Checkforerror');
5633: fnd_msg_pub.Add;
5634: END IF;
5635: */
5636: END IF;
5637: -- Standard call to get message count and if count is 1, get message info.

Line 5638: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

5634: END IF;
5635: */
5636: END IF;
5637: -- Standard call to get message count and if count is 1, get message info.
5638: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
5639: p_count => x_msg_count,
5640: p_data => x_msg_data);
5641:
5642: IF (PV_DEBUG_HIGH_ON) THEN

Line 5654: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

5650: EXCEPTION
5651:
5652: WHEN FND_API.G_EXC_ERROR THEN
5653: x_return_status := FND_API.G_RET_STS_ERROR ;
5654: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
5655: p_count => x_msg_count,
5656: p_data => x_msg_data);
5657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 5659: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

5655: p_count => x_msg_count,
5656: p_data => x_msg_data);
5657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5659: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
5660: p_count => x_msg_count,
5661: p_data => x_msg_data);
5662: WHEN OTHERS THEN
5663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5660: p_count => x_msg_count,
5661: p_data => x_msg_data);
5662: WHEN OTHERS THEN
5663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5664: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5665: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
5666: p_count => x_msg_count,
5667: p_data => x_msg_data);
5668: end Send_Workflow_Notification;

Line 5665: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

5661: p_data => x_msg_data);
5662: WHEN OTHERS THEN
5663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5664: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5665: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
5666: p_count => x_msg_count,
5667: p_data => x_msg_data);
5668: end Send_Workflow_Notification;
5669:

Line 5771: fnd_msg_pub.initialize;

5767: END IF;
5768: -- Initialize message list if p_init_msg_list is set to TRUE.
5769: IF FND_API.to_Boolean( p_init_msg_list )
5770: THEN
5771: fnd_msg_pub.initialize;
5772: END IF;
5773:
5774:
5775: IF (PV_DEBUG_HIGH_ON) THEN

Line 5798: FND_MSG_PUB.Add;

5794:
5795: /* Check for Procedure's x_return_status */
5796: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5797: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_CNTCT_FOR_INVITE');
5798: FND_MSG_PUB.Add;
5799: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5800: RAISE FND_API.G_EXC_ERROR;
5801: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5817: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

5813: l_notif_user_id :=substr(l_notif_user_id,2);
5814: l_pt_adhoc_role := 'PV_' || l_itemKey ;
5815: l_role_disp_name :='Primary Users';
5816: -- Debug Message
5817: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
5818: PVX_UTILITY_PVT.debug_message( 'Creating role PT: '|| l_pt_adhoc_role);
5819: END IF;
5820: wf_directory.CreateAdHocRole2
5821: (

Line 5975: FND_MSG_PUB.Add;

5971: /* Check for Procedure's x_return_status */
5972: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5973: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
5974: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_partner_id );
5975: FND_MSG_PUB.Add;
5976: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5977: RAISE FND_API.G_EXC_ERROR;
5978: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6044: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

6040: );
6041:
6042: END IF;
6043: -- Standard call to get message count and if count is 1, get message info.
6044: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
6045: p_count => x_msg_count,
6046: p_data => x_msg_data);
6047:
6048: IF (PV_DEBUG_HIGH_ON) THEN

Line 6060: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

6056: EXCEPTION
6057:
6058: WHEN FND_API.G_EXC_ERROR THEN
6059: x_return_status := FND_API.G_RET_STS_ERROR ;
6060: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
6061: p_count => x_msg_count,
6062: p_data => x_msg_data);
6063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 6065: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

6061: p_count => x_msg_count,
6062: p_data => x_msg_data);
6063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6065: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
6066: p_count => x_msg_count,
6067: p_data => x_msg_data);
6068: WHEN OTHERS THEN
6069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6066: p_count => x_msg_count,
6067: p_data => x_msg_data);
6068: WHEN OTHERS THEN
6069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6070: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6071: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
6072: p_count => x_msg_count,
6073: p_data => x_msg_data);
6074: end Send_Invitations;

Line 6071: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

6067: p_data => x_msg_data);
6068: WHEN OTHERS THEN
6069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6070: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6071: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
6072: p_count => x_msg_count,
6073: p_data => x_msg_data);
6074: end Send_Invitations;
6075: