DBA Data[Home] [Help]

APPS.DPP_APPROVAL_PVT dependencies on DPP_APPROVAL_PVT

Line 1: PACKAGE BODY DPP_APPROVAL_PVT AS

1: PACKAGE BODY DPP_APPROVAL_PVT AS
2: /* $Header: dppvappb.pls 120.14 2008/04/02 09:28:02 sdasan noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_APPROVAL_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'dppvappb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_APPROVAL_PVT';

1: PACKAGE BODY DPP_APPROVAL_PVT AS
2: /* $Header: dppvappb.pls 120.14 2008/04/02 09:28:02 sdasan noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_APPROVAL_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'dppvappb.pls';
6:
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 642: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

638: FND_MSG_PUB.add;
639: RAISE FND_API.G_EXC_ERROR;
640: WHEN OTHERS THEN
641: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
642: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
643: fnd_message.set_token('ERRNO', sqlcode);
644: fnd_message.set_token('REASON', sqlerrm);
645: FND_MSG_PUB.add;
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 682: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

678: FND_MSG_PUB.add;
679: RAISE FND_API.G_EXC_ERROR;
680: WHEN OTHERS THEN
681: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
682: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
683: fnd_message.set_token('ERRNO', sqlcode);
684: fnd_message.set_token('REASON', sqlerrm);
685: FND_MSG_PUB.add;
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 701: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

697: FND_MSG_PUB.add;
698: RAISE FND_API.G_EXC_ERROR;
699: WHEN OTHERS THEN
700: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
701: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
702: fnd_message.set_token('ERRNO', sqlcode);
703: fnd_message.set_token('REASON', sqlerrm);
704: FND_MSG_PUB.add;
705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 728: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

724: FND_MSG_PUB.add;
725: RAISE FND_API.G_EXC_ERROR;
726: WHEN OTHERS THEN
727: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
728: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
729: fnd_message.set_token('ERRNO', sqlcode);
730: fnd_message.set_token('REASON', sqlerrm);
731: FND_MSG_PUB.add;
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 748: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

744: FND_MSG_PUB.add;
745: RAISE FND_API.G_EXC_ERROR;
746: WHEN OTHERS THEN
747: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
748: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
749: fnd_message.set_token('ERRNO', sqlcode);
750: fnd_message.set_token('REASON', sqlerrm);
751: FND_MSG_PUB.add;
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1768: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

1764: WHERE transaction_header_id = p_approval_rec.object_id;
1765: EXCEPTION
1766: WHEN NO_DATA_FOUND THEN
1767: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1768: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
1769: fnd_message.set_token('ERRNO', sqlcode);
1770: fnd_message.set_token('REASON', 'Invalid Transaction Header ID');
1771: FND_MSG_PUB.add;
1772: RAISE FND_API.G_EXC_ERROR;

Line 1775: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

1771: FND_MSG_PUB.add;
1772: RAISE FND_API.G_EXC_ERROR;
1773: WHEN OTHERS THEN
1774: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1775: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
1776: fnd_message.set_token('ERRNO', sqlcode);
1777: fnd_message.set_token('REASON', sqlerrm);
1778: FND_MSG_PUB.add;
1779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1926: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');

1922: EXCEPTION
1923: WHEN OTHERS THEN
1924: ROLLBACK;
1925: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1926: fnd_message.set_token('ROUTINE', 'DPP_APPROVAL_PVT');
1927: fnd_message.set_token('ERRNO', sqlcode);
1928: fnd_message.set_token('REASON', sqlerrm);
1929: FND_MSG_PUB.add;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2022: END DPP_APPROVAL_PVT;

2018: END IF;
2019: --
2020: END Process_User_Action;
2021:
2022: END DPP_APPROVAL_PVT;