DBA Data[Home] [Help]

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.11.12020000.2 2012/12/13 05:07:43 shnatu 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.11.12020000.2 2012/12/13 05:07:43 shnatu 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 1679: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',

1675: ROLLBACK TO CREATE_MR_REVISION_PVT;
1676: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1678: THEN
1679: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
1680: p_procedure_name => 'CREATE_MR_REVISION',
1681: p_error_text => SUBSTR(SQLERRM,1,240));
1682: END IF;
1683: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 2057: AHL_FMP_MR_REVISION_PVT.COMPLETE_MR_REVISION

2053: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2054: FND_MSG_PUB.ADD;
2055: END IF;
2056:
2057: AHL_FMP_MR_REVISION_PVT.COMPLETE_MR_REVISION
2058: (
2059: p_api_version =>1.0,
2060: p_init_msg_list =>FND_API.G_FALSE,
2061: p_commit =>FND_API.G_FALSE,

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

2113: ROLLBACK TO INITIATE_MR_APPROVAL_PVT;
2114: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2115: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2116: THEN
2117: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
2118: p_procedure_name => 'INITIATE_MR_APPROVAL',
2119: p_error_text => SUBSTR(SQLERRM,1,240));
2120: END IF;
2121: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

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

2664: ROLLBACK TO COMPLETE_MR_REVISION_PVT;
2665: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2666: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2667: THEN
2668: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
2669: p_procedure_name => 'COMPLETE_MR_REVISION',
2670: p_error_text => SUBSTR(SQLERRM,1,240));
2671: END IF;
2672: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 2772: END AHL_FMP_MR_REVISION_PVT;

2768: IF G_DEBUG='Y' THEN
2769: AHL_DEBUG_PUB.disable_debug;
2770: END IF;
2771: END;
2772: END AHL_FMP_MR_REVISION_PVT;