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 PV_PG_NOTIF_UTILITY_PVT

Line 1: PACKAGE BODY PV_PG_NOTIF_UTILITY_PVT as

1: PACKAGE BODY PV_PG_NOTIF_UTILITY_PVT as
2: /* $Header: pvxvpnub.pls 120.9 2011/04/20 06:30:21 hekkiral ship $ */
3:
4: /*----------------------------------------------------------------------------
5: -- HISTORY

Line 49: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_PG_NOTIF_UTILITY_PVT';

45: -- 31-OCT-2005 kvattiku In send_welcome_notif, commented out and modified code so that the URL is
46: obtained from profile. (fix for bug 4666288)
47: -----------------------------------------------------------------------------*/
48:
49: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_PG_NOTIF_UTILITY_PVT';
50: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvpnub.pls';
51:
52: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
53: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 3373: p_mbrship_chng_rec IN PV_PG_NOTIF_UTILITY_PVT.mbrship_chng_rec_type

3369: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3370: x_return_status OUT NOCOPY VARCHAR2 ,
3371: x_msg_count OUT NOCOPY NUMBER ,
3372: x_msg_data OUT NOCOPY VARCHAR2 ,
3373: p_mbrship_chng_rec IN PV_PG_NOTIF_UTILITY_PVT.mbrship_chng_rec_type
3374: )
3375: IS
3376:
3377: /* Declaration of local variables. */

Line 3770: PV_PG_NOTIF_UTILITY_PVT.send_mbrship_exp_notif (

3766: ITEMKEY => l_itemkey,
3767: ANAME => 'MEMBERSHIP_ID' );
3768:
3769: /* Call the send_membership_expiry_notif */
3770: PV_PG_NOTIF_UTILITY_PVT.send_mbrship_exp_notif (
3771: p_api_version => 1.0 ,
3772: p_init_msg_list => FND_API.G_FALSE ,
3773: p_commit => FND_API.G_FALSE ,
3774: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

Line 3797: PV_PG_NOTIF_UTILITY_PVT.send_cntrct_notrcvd_notif (

3793: ITEMKEY => l_itemkey,
3794: ANAME => 'ENROLLMENT_REQUEST_ID' );
3795:
3796: /* Call the send_cntrct_notrcvd_notif */
3797: PV_PG_NOTIF_UTILITY_PVT.send_cntrct_notrcvd_notif (
3798: p_api_version => 1.0 ,
3799: p_init_msg_list => FND_API.G_FALSE ,
3800: p_commit => FND_API.G_FALSE ,
3801: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

Line 4080: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification

4076: IF ( c_get_memberships%NOTFOUND) THEN
4077: Close c_get_memberships;
4078: exit;
4079: END IF;
4080: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification
4081: (
4082: p_api_version_number => p_api_version_number
4083: , p_init_msg_list => p_init_msg_list
4084: , p_commit => p_commit

Line 4116: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification

4112: IF ( c_get_enrollment_requests%NOTFOUND) THEN
4113: Close c_get_enrollment_requests;
4114: exit;
4115: END IF;
4116: PV_PG_NOTIF_UTILITY_PVT.Send_Workflow_Notification
4117: (
4118: p_api_version_number => p_api_version_number
4119: , p_init_msg_list => p_init_msg_list
4120: , p_commit => p_commit

Line 4151: Write_log (1, 'Error in PV_PG_NOTIF_UTILITY_PVT.Prtnr_Prgm_Enrl_notif');

4147: ERRBUF := ERRBUF || sqlerrm;
4148: RETCODE := FND_API.G_RET_STS_ERROR;
4149: ROLLBACK ;
4150: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
4151: Write_log (1, 'Error in PV_PG_NOTIF_UTILITY_PVT.Prtnr_Prgm_Enrl_notif');
4152: Write_log (1, 'SQLCODE ' || to_char(SQLCODE) ||
4153: ' SQLERRM ' || substr(SQLERRM, 1, 100));
4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: ERRBUF := ERRBUF||sqlerrm;

Line 4159: Write_log (1, 'Unexpected error in Error in PV_PG_NOTIF_UTILITY_PVT.Prtnr_Prgm_Enrl_notif');

4155: ERRBUF := ERRBUF||sqlerrm;
4156: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
4157: ROLLBACK ;
4158: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
4159: Write_log (1, 'Unexpected error in Error in PV_PG_NOTIF_UTILITY_PVT.Prtnr_Prgm_Enrl_notif');
4160: Write_log (1, 'SQLCODE ' || to_char(SQLCODE) ||
4161: ' SQLERRM ' || substr(SQLERRM, 1, 100));
4162: WHEN OTHERS THEN
4163: ERRBUF := ERRBUF||sqlerrm;

Line 4167: Write_log (1, 'Other error in Error in PV_PG_NOTIF_UTILITY_PVT.Prtnr_Prgm_Enrl_notif');

4163: ERRBUF := ERRBUF||sqlerrm;
4164: RETCODE := '2';
4165: ROLLBACK ;
4166: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
4167: Write_log (1, 'Other error in Error in PV_PG_NOTIF_UTILITY_PVT.Prtnr_Prgm_Enrl_notif');
4168: Write_log (1, 'SQLCODE ' || to_char(SQLCODE) ||
4169: ' SQLERRM ' || substr(SQLERRM, 1, 100));
4170: END Prtnr_Prgm_Enrl_notif;
4171:

Line 4490: Write_log (1, 'Error in Updating Membership Status(PV_PG_NOTIF_UTILITY_PVT.Expire_Memberships)');

4486: ERRBUF := ERRBUF || sqlerrm;
4487: RETCODE := FND_API.G_RET_STS_ERROR;
4488: ROLLBACK TO Expire_Memberships;
4489: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
4490: Write_log (1, 'Error in Updating Membership Status(PV_PG_NOTIF_UTILITY_PVT.Expire_Memberships)');
4491: Write_log (1, 'SQLCODE ' || to_char(SQLCODE) ||
4492: ' SQLERRM ' || substr(SQLERRM, 1, 100));
4493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4494: ERRBUF := ERRBUF||sqlerrm;

Line 4498: Write_log (1, 'Unexpected error in in Updating Membership Status(PV_PG_NOTIF_UTILITY_PVT.Expire_Memberships)');

4494: ERRBUF := ERRBUF||sqlerrm;
4495: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
4496: ROLLBACK TO Expire_Memberships;
4497: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
4498: Write_log (1, 'Unexpected error in in Updating Membership Status(PV_PG_NOTIF_UTILITY_PVT.Expire_Memberships)');
4499: Write_log (1, 'SQLCODE ' || to_char(SQLCODE) ||
4500: ' SQLERRM ' || substr(SQLERRM, 1, 100));
4501: WHEN OTHERS THEN
4502: ERRBUF := ERRBUF||sqlerrm;

Line 4506: Write_log (1, 'Other error in in Updating Membership Status(PV_PG_NOTIF_UTILITY_PVT.Expire_Memberships)');

4502: ERRBUF := ERRBUF||sqlerrm;
4503: RETCODE := '2';
4504: ROLLBACK TO Expire_Memberships;
4505: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
4506: Write_log (1, 'Other error in in Updating Membership Status(PV_PG_NOTIF_UTILITY_PVT.Expire_Memberships)');
4507: Write_log (1, 'SQLCODE ' || to_char(SQLCODE) ||
4508: ' SQLERRM ' || substr(SQLERRM, 1, 100));
4509: END Expire_Memberships;
4510:

Line 6078: END PV_PG_NOTIF_UTILITY_PVT;

6074: end Send_Invitations;
6075:
6076:
6077:
6078: END PV_PG_NOTIF_UTILITY_PVT;