APPS.AHL_FMP_MR_ROUTE_SEQNCE_PVT dependencies on AHL_FMP_MR_ROUTE_SEQNCE_PVT

Line 1: PACKAGE BODY AHL_FMP_MR_ROUTE_SEQNCE_PVT AS

1: PACKAGE BODY AHL_FMP_MR_ROUTE_SEQNCE_PVT AS
2: /* $Header: AHLVMRSB.pls 120.0 2005/05/26 00:59:55 appldev noship $ */
3:
4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_ROUTE_SEQNCE_PVT';
5: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

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

1: PACKAGE BODY AHL_FMP_MR_ROUTE_SEQNCE_PVT AS
2: /* $Header: AHLVMRSB.pls 120.0 2005/05/26 00:59:55 appldev noship $ */
3:
4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_ROUTE_SEQNCE_PVT';
5: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
6: G_APPLN_USAGE VARCHAR2(30):=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
7: -- TAMAL
8: -- Procedure to check for correct route sequence w.r.t stage information for given mr_route...

Line 86: (p_x_mr_routeseq_tbl IN OUT NOCOPY AHL_FMP_MR_ROUTE_SEQNCE_PVT.MR_ROUTE_SEQ_TBL)

82: END VALIDATE_ROUTE_STAGE_SEQ;
83: -- TAMAL
84:
85: PROCEDURE DEFAULT_MISSING_ATTRIBS
86: (p_x_mr_routeseq_tbl IN OUT NOCOPY AHL_FMP_MR_ROUTE_SEQNCE_PVT.MR_ROUTE_SEQ_TBL)
87: AS
88: CURSOR CurGetSeqDet(c_MR_ROUTE_SEQUENCE_ID NUMBER)
89: Is
90: Select

Line 1057: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_ROUTE_SEQNCE_PVT',

1053: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054:
1055: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1056: THEN
1057: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_ROUTE_SEQNCE_PVT',
1058: p_procedure_name => 'PROCESS_MR_ROUTE_SEQ',
1059: p_error_text => SUBSTR(SQLERRM,1,240));
1060: END IF;
1061: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 1068: END AHL_FMP_MR_ROUTE_SEQNCE_PVT;

1064: END;
1065:
1066:
1067:
1068: END AHL_FMP_MR_ROUTE_SEQNCE_PVT;