[Home] [Help]
1011: l_notif_rule_active VARCHAR2(1):='N';
1012: l_log_params_tbl PVX_UTILITY_PVT.log_params_tbl_type;
1013:
1014: BEGIN
1015: /* Standard Start of API savepoint */
1016: SAVEPOINT send_thnkyou_notif_PVT;
1017:
1018: /* Standard call to check for call compatibility. */
1019: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1014: BEGIN
1015: /* Standard Start of API savepoint */
1016: SAVEPOINT send_thnkyou_notif_PVT;
1017:
1018: /* Standard call to check for call compatibility. */
1019: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1020: p_api_version ,
1021: l_api_name ,
1022: G_PKG_NAME
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335: END IF;
1336:
1337: /* Standard check of p_commit. */
1338: IF FND_API.To_Boolean( p_commit ) THEN
1339: COMMIT WORK;
1340: END IF;
1341:
1338: IF FND_API.To_Boolean( p_commit ) THEN
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: );
1477: l_prtner_portal_url VARCHAR2(4000);
1478: l_login_url VARCHAR2(4000);
1479:
1480: BEGIN
1481: /* Standard Start of API savepoint */
1482: SAVEPOINT send_welcome_notif_PVT;
1483:
1484: /* Standard call to check for call compatibility. */
1485: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1480: BEGIN
1481: /* Standard Start of API savepoint */
1482: SAVEPOINT send_welcome_notif_PVT;
1483:
1484: /* Standard call to check for call compatibility. */
1485: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1486: p_api_version ,
1487: l_api_name ,
1488: G_PKG_NAME
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: END IF;
1834: END IF;
1835:
1836: -- Standard check of p_commit.
1837: IF FND_API.To_Boolean( p_commit ) THEN
1838: COMMIT WORK;
1839: END IF;
1840:
1837: IF FND_API.To_Boolean( p_commit ) THEN
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: );
1976: l_notif_rule_active VARCHAR2(1):='N';
1977: l_log_params_tbl PVX_UTILITY_PVT.log_params_tbl_type;
1978:
1979: BEGIN
1980: -- Standard Start of API savepoint
1981: SAVEPOINT send_rejection_notif_PVT;
1982:
1983: -- Standard call to check for call compatibility.
1984: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1979: BEGIN
1980: -- Standard Start of API savepoint
1981: SAVEPOINT send_rejection_notif_PVT;
1982:
1983: -- Standard call to check for call compatibility.
1984: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1985: p_api_version ,
1986: l_api_name ,
1987: G_PKG_NAME
2314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2315: END IF;
2316: END IF;
2317:
2318: -- Standard check of p_commit.
2319: IF FND_API.To_Boolean( p_commit ) THEN
2320: COMMIT WORK;
2321: END IF;
2322:
2319: IF FND_API.To_Boolean( p_commit ) THEN
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: );
2458: l_notif_rule_active VARCHAR2(1):='N';
2459: l_log_params_tbl PVX_UTILITY_PVT.log_params_tbl_type;
2460:
2461: BEGIN
2462: -- Standard Start of API savepoint
2463: SAVEPOINT send_cntrct_notrcvd_notif_PVT;
2464:
2465: -- Standard call to check for call compatibility.
2466: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2461: BEGIN
2462: -- Standard Start of API savepoint
2463: SAVEPOINT send_cntrct_notrcvd_notif_PVT;
2464:
2465: -- Standard call to check for call compatibility.
2466: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2467: p_api_version ,
2468: l_api_name ,
2469: G_PKG_NAME
2776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2777: END IF;
2778: END IF;
2779:
2780: -- Standard check of p_commit.
2781: IF FND_API.To_Boolean( p_commit ) THEN
2782: COMMIT WORK;
2783: END IF;
2784:
2781: IF FND_API.To_Boolean( p_commit ) THEN
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: );
2924: l_prtner_portal_url VARCHAR2(2000);
2925: l_login_url VARCHAR2(4000);
2926:
2927: BEGIN
2928: -- Standard Start of API savepoint
2929: SAVEPOINT send_mbership_expiry_notif_PVT;
2930:
2931: -- Standard call to check for call compatibility.
2932: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2927: BEGIN
2928: -- Standard Start of API savepoint
2929: SAVEPOINT send_mbership_expiry_notif_PVT;
2930:
2931: -- Standard call to check for call compatibility.
2932: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2933: p_api_version ,
2934: l_api_name ,
2935: G_PKG_NAME
3288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3289: END IF;
3290: END IF;
3291:
3292: -- Standard check of p_commit.
3293: IF FND_API.To_Boolean( p_commit ) THEN
3294: COMMIT WORK;
3295: END IF;
3296:
3293: IF FND_API.To_Boolean( p_commit ) THEN
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: );
3418: l_log_params_tbl PVX_UTILITY_PVT.log_params_tbl_type;
3419:
3420: BEGIN
3421:
3422: /* Standard Start of API savepoint */
3423: SAVEPOINT send_mbrship_chng_notif;
3424:
3425: /* Standard call to check for call compatibility. */
3426: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3421:
3422: /* Standard Start of API savepoint */
3423: SAVEPOINT send_mbrship_chng_notif;
3424:
3425: /* Standard call to check for call compatibility. */
3426: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3427: p_api_version ,
3428: l_api_name ,
3429: G_PKG_NAME
3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3666: END IF;
3667: END IF;
3668:
3669: /* Set OUT values Standard check of p_commit. */
3670: IF FND_API.To_Boolean( p_commit ) THEN
3671: COMMIT WORK;
3672: END IF;
3673:
3670: IF FND_API.To_Boolean( p_commit ) THEN
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: );
4257: l_index number;
4258:
4259: BEGIN
4260:
4261: /* Standard Start of API savepoint */
4262: SAVEPOINT Expire_Memberships;
4263:
4264: /* Logic to update the membership status to EXPIRE for all the EXPIRED members */
4265: Write_log (1, 'Updating the Membership Status to EXPIRED -');
4935: WHERE inv.invite_header_id=inv_hdr_id
4936: AND inv.invite_for_program_id =prgm.program_id;
4937:
4938: BEGIN
4939: -- Standard call to check for call compatibility.
4940: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4941: p_api_version_number,
4942: l_api_name,
4943: G_PKG_NAME) THEN
5044: FND_MESSAGE.set_token('LOOKUP_CODE', p_context_code );
5045: RAISE FND_API.G_EXC_ERROR;
5046: END IF;
5047: */
5048: IF p_entity_code IN ( 'GLOBAL', 'SUBSIDIARY', 'STANDARD' ) THEN
5049: l_entity_code := 'PARTNER';
5050: ELSE
5051: l_entity_code := p_entity_code;
5052: END IF;
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.
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:
5757: FROM fnd_currencies_vl
5758: WHERE currency_code = currencyCode;
5759:
5760: BEGIN
5761: -- Standard call to check for call compatibility.
5762: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
5763: p_api_version_number,
5764: l_api_name,
5765: G_PKG_NAME) THEN
6039: , ItemKey => l_itemKey
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: