APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_FMP_MR_REVISION_PVT

Line 1: PACKAGE BODY AHL_FMP_MR_REVISION_PVT AS

1: PACKAGE BODY AHL_FMP_MR_REVISION_PVT AS
2: /* $Header: AHLVMRRB.pls 120.5.12010000.2 2008/12/29 01:03:58 sracha ship $ */
3:
4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_REVISION_PVT';
5: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

Line 4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_REVISION_PVT';

1: PACKAGE BODY AHL_FMP_MR_REVISION_PVT AS
2: /* $Header: AHLVMRRB.pls 120.5.12010000.2 2008/12/29 01:03:58 sracha ship $ */
3:
4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_REVISION_PVT';
5: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
6: G_APPLN_USAGE VARCHAR2(30) :=LTRIM(RTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
7:
8: TYPE TEMP_MR_ROUTE_REC IS RECORD

Line 149: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',

145: WHEN OTHERS THEN
146: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
150: p_procedure_name => 'VALIDATE_MR_REV',
151: p_error_text => SUBSTR(SQLERRM,1,240));
152: END IF;
153: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 1285: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',

1281: ROLLBACK TO CREATE_MR_REVISION_PVT;
1282: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1283: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1284: THEN
1285: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
1286: p_procedure_name => 'CREATE_MR_REVISION',
1287: p_error_text => SUBSTR(SQLERRM,1,240));
1288: END IF;
1289: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 1663: AHL_FMP_MR_REVISION_PVT.COMPLETE_MR_REVISION

1659: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1660: FND_MSG_PUB.ADD;
1661: END IF;
1662:
1663: AHL_FMP_MR_REVISION_PVT.COMPLETE_MR_REVISION
1664: (
1665: p_api_version =>1.0,
1666: p_init_msg_list =>FND_API.G_FALSE,
1667: p_commit =>FND_API.G_FALSE,

Line 1723: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',

1719: ROLLBACK TO INITIATE_MR_APPROVAL_PVT;
1720: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1722: THEN
1723: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
1724: p_procedure_name => 'INITIATE_MR_APPROVAL',
1725: p_error_text => SUBSTR(SQLERRM,1,240));
1726: END IF;
1727: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 2133: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',

2129: ROLLBACK TO COMPLETE_MR_REVISION_PVT;
2130: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2132: THEN
2133: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
2134: p_procedure_name => 'COMPLETE_MR_REVISION',
2135: p_error_text => SUBSTR(SQLERRM,1,240));
2136: END IF;
2137: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 2237: END AHL_FMP_MR_REVISION_PVT;

2233: IF G_DEBUG='Y' THEN
2234: AHL_DEBUG_PUB.disable_debug;
2235: END IF;
2236: END;
2237: END AHL_FMP_MR_REVISION_PVT;