DBA Data[Home] [Help]

APPS.PRP_RTTAP_INT_PVT dependencies on PRP_RTTAP_INT_PVT

Line 1: PACKAGE BODY PRP_RTTAP_INT_PVT as

1: PACKAGE BODY PRP_RTTAP_INT_PVT as
2: /* $Header: PRPVRTPB.pls 120.4 2006/02/20 16:59:24 hekkiral noship $ */
3:
4: G_PROPOSAL_ID NUMBER;
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PRP_RTTAP_INT_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PRP_RTTAP_INT_PVT';

1: PACKAGE BODY PRP_RTTAP_INT_PVT as
2: /* $Header: PRPVRTPB.pls 120.4 2006/02/20 16:59:24 hekkiral noship $ */
3:
4: G_PROPOSAL_ID NUMBER;
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PRP_RTTAP_INT_PVT';
6:
7: PROCEDURE LOG_MESSAGES(
8: P_LOG_MESSAGE IN VARCHAR2,
9: P_MODULE_NAME IN VARCHAR2,

Line 455: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','EXPLODE_TEAMS',SQLERRM);

451: WHEN others THEN
452: x_errbuf := SQLERRM;
453: x_retcode := SQLCODE;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','EXPLODE_TEAMS',SQLERRM);
456: -- Log Debug Messages.
457: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
458: P_MODULE_NAME => 'Insert_Terr_Accesses',
459: p_LOG_MESSAGE => 'Error While Exploding Teams.. ' ||' x_errbuf: ' || x_errbuf);

Line 565: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','EXPLODE_GROUPS',SQLERRM);

561: WHEN OTHERS THEN
562: x_errbuf := SQLERRM;
563: x_retcode := SQLCODE;
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','EXPLODE_GROUPS',SQLERRM);
566: -- Log Debug Messages.
567: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
568: P_MODULE_NAME => 'Insert_Terr_Accesses',
569: p_LOG_MESSAGE => 'Error While Exploding Groups.. ' ||' x_errbuf: ' || x_errbuf);

Line 627: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','INSERT_ACCESS',SQLERRM);

623: WHEN OTHERS THEN
624: x_errbuf := SQLERRM;
625: x_retcode := SQLCODE;
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','INSERT_ACCESS',SQLERRM);
628: -- Log Debug Messages.
629: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
630: P_MODULE_NAME => 'Insert_Terr_Accesses',
631: p_LOG_MESSAGE => 'Error While Inserting into PRP_Accesses... ' ||' x_errbuf: ' || x_errbuf);

Line 697: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','INSERT_TERR_ACCESSES',SQLERRM);

693: x_errbuf := SQLERRM;
694: x_retcode := SQLCODE;
695: x_return_status := FND_API.G_RET_STS_ERROR;
696:
697: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','INSERT_TERR_ACCESSES',SQLERRM);
698: -- Log Debug Messages.
699: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
700: P_MODULE_NAME => 'Insert_Terr_Accesses',
701: p_LOG_MESSAGE => 'Error While Inserting into PRP_Terroritory_Accesses... ' ||' x_errbuf: ' || x_errbuf);

Line 731: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','PERFORM_CLEANUP',SQLERRM);

727: WHEN OTHERS THEN
728: x_errbuf := SQLERRM;
729: x_retcode := SQLCODE;
730: x_return_status := FND_API.G_RET_STS_ERROR;
731: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','PERFORM_CLEANUP',SQLERRM);
732: -- Log Debug Messages.
733: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
734: P_MODULE_NAME => 'Insert_Terr_Accesses',
735: p_LOG_MESSAGE => 'Error in Perform_Cleanup... ' ||' x_errbuf: ' || x_errbuf);

Line 739: END PRP_RTTAP_INT_PVT;

735: p_LOG_MESSAGE => 'Error in Perform_Cleanup... ' ||' x_errbuf: ' || x_errbuf);
736: END PERFORM_CLEANUP;
737: /************************** End Perform Cleanup ***************/
738:
739: END PRP_RTTAP_INT_PVT;
740: