DBA Data[Home] [Help]

APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on FND_CONCURRENT

Line 4150: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

4146: WHEN FND_API.G_EXC_ERROR THEN
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

Line 4158: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 4166: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

4162: WHEN OTHERS THEN
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;

Line 4489: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

4485: WHEN FND_API.G_EXC_ERROR THEN
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

Line 4497: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

4493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 4505: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

4501: WHEN OTHERS THEN
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;