APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VWP_VISITS_PVT

Line 1: PACKAGE BODY AHL_VWP_VISITS_PVT AS

1: PACKAGE BODY AHL_VWP_VISITS_PVT AS
2: /* $Header: AHLVVSTB.pls 120.38.12020000.3 2013/03/20 09:31:49 prakkum ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_VISITS_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';

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

1: PACKAGE BODY AHL_VWP_VISITS_PVT AS
2: /* $Header: AHLVVSTB.pls 120.38.12020000.3 2013/03/20 09:31:49 prakkum ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_VISITS_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
6: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
7:
8: ------------------------------------

Line 1083: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_VISITS_PVT',

1079: ROLLBACK TO Process_Visit;
1080: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1082: THEN
1083: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_VISITS_PVT',
1084: p_procedure_name => 'Process_Visit',
1085: p_error_text => SUBSTR(SQLERRM,1,240));
1086: END IF;
1087: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3547: select AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) IS_OLD_VISIT FROM DUAL;

3543: l_latest_wo_end_date DATE; */
3544:
3545: -- PRAKKUM :: 28-JUN-2011 :: VWPE :: ER 12730539 :: To find visit is old or new
3546: CURSOR c_is_old_visit(p_visit_id IN NUMBER) IS
3547: select AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) IS_OLD_VISIT FROM DUAL;
3548:
3549: l_is_old_visit_dets c_is_old_visit%RowType;
3550:
3551: -- TCHIMIRA ::28-JUN-2011 :: VWP: ER:12673125 :: START

Line 5793: AHL_VWP_VISITS_PVT.Is_Old_Visit (p_visit_rec.visit_id) = 'Y') THEN

5789: CLOSE chk_comp_visit_csr;
5790:
5791: -- Step 2
5792: IF (l_is_comp_visit = 'Y' AND
5793: AHL_VWP_VISITS_PVT.Is_Old_Visit (p_visit_rec.visit_id) = 'Y') THEN
5794: l_is_comp_visit := 'N';
5795: END IF;
5796:
5797: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011

Line 7778: fnd_log.string(l_log_statement,'ahl.plsql.AHL_VWP_VISITS_PVT.Get_Message_Stack',

7774: p_msg_index_out => l_msg_index_out);
7775:
7776: x_message_stack_tbl(i) := l_msg_data;
7777: IF (l_log_statement >= l_log_current_level) THEN
7778: fnd_log.string(l_log_statement,'ahl.plsql.AHL_VWP_VISITS_PVT.Get_Message_Stack',
7779: 'Error - '||l_msg_data);
7780: END IF;
7781: END LOOP;
7782: END IF;

Line 7956: END AHL_VWP_VISITS_PVT;

7952: END Is_Old_Visit;
7953:
7954: -- PRAKKUM :: VWPE: ER:12730539 :: 23-JUN-2011 :: END
7955:
7956: END AHL_VWP_VISITS_PVT;