APPS.AHL_FMP_MR_ROUTE_PVT dependencies on AHL_FMP_MR_ROUTE_PVT

Line 1: PACKAGE BODY AHL_FMP_MR_ROUTE_PVT AS

1: PACKAGE BODY AHL_FMP_MR_ROUTE_PVT AS
2: /* $Header: AHLVMRUB.pls 120.2 2006/02/02 23:29:59 amsriniv noship $ */
3:
4: G_PKG_NAME VARCHAR2(30) :='AHL_FMP_MR_ROUTE_PVT';
5: G_APPLN_USAGE VARCHAR2(30) :=FND_PROFILE.VALUE('AHL_APPLN_USAGE');

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

1: PACKAGE BODY AHL_FMP_MR_ROUTE_PVT AS
2: /* $Header: AHLVMRUB.pls 120.2 2006/02/02 23:29:59 amsriniv noship $ */
3:
4: G_PKG_NAME VARCHAR2(30) :='AHL_FMP_MR_ROUTE_PVT';
5: G_APPLN_USAGE VARCHAR2(30) :=FND_PROFILE.VALUE('AHL_APPLN_USAGE');
6: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
7: PROCEDURE DEFAULT_MISSING_ATTRIBS
8: (p_x_mr_route_tbl IN OUT NOCOPY AHL_FMP_MR_ROUTE_PVT.MR_ROUTE_tbl)

Line 8: (p_x_mr_route_tbl IN OUT NOCOPY AHL_FMP_MR_ROUTE_PVT.MR_ROUTE_tbl)

4: G_PKG_NAME VARCHAR2(30) :='AHL_FMP_MR_ROUTE_PVT';
5: G_APPLN_USAGE VARCHAR2(30) :=FND_PROFILE.VALUE('AHL_APPLN_USAGE');
6: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
7: PROCEDURE DEFAULT_MISSING_ATTRIBS
8: (p_x_mr_route_tbl IN OUT NOCOPY AHL_FMP_MR_ROUTE_PVT.MR_ROUTE_tbl)
9: AS
10: Cursor CurGetRouteDet(C_MR_ROUTE_ID IN NUMBER)
11: is
12: SELECT

Line 746: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_ROUTE_PVT',

742: ROLLBACK TO PROCESS_MR_ROUTES_PVT;
743: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
745: THEN
746: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_ROUTE_PVT',
747: p_procedure_name => 'PROCESS_MR_ROUTE',
748: p_error_text => SUBSTR(SQLERRM,1,240));
749: END IF;
750: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 760: END AHL_FMP_MR_ROUTE_PVT;

756:
757: END;
758:
759:
760: END AHL_FMP_MR_ROUTE_PVT;