eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_VWP_PROJ_PROD_PVT

Line 1: PACKAGE BODY AHL_VWP_PROJ_PROD_PVT AS

1: PACKAGE BODY AHL_VWP_PROJ_PROD_PVT AS
2: /* $Header: AHLVPRDB.pls 120.88.12020000.4 2013/03/13 06:34:41 prakkum ship $ */
3:
4: -- Global CONSTANTS
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_PROJ_PROD_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_PROJ_PROD_PVT';

1: PACKAGE BODY AHL_VWP_PROJ_PROD_PVT AS
2: /* $Header: AHLVPRDB.pls 120.88.12020000.4 2013/03/13 06:34:41 prakkum ship $ */
3:
4: -- Global CONSTANTS
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_PROJ_PROD_PVT';
6: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
7: --G_DEBUG VARCHAR2(1):= FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
8: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
9:

Line 575: fnd_log.string (l_log_statement,L_DEBUG_KEY, 'Before Calling AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production, visit status: '||l_visit_status);

571:
572: --CHANGES by jrotich bug #13028686 END
573:
574: IF (l_log_statement >= l_log_current_level)THEN
575: fnd_log.string (l_log_statement,L_DEBUG_KEY, 'Before Calling AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production, visit status: '||l_visit_status);
576: END IF;
577:
578: --Valdate before push to production happens
579: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production

Line 579: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production

575: fnd_log.string (l_log_statement,L_DEBUG_KEY, 'Before Calling AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production, visit status: '||l_visit_status);
576: END IF;
577:
578: --Valdate before push to production happens
579: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production
580: (p_api_version => l_api_version,
581: p_init_msg_list => p_init_msg_list,
582: p_commit => l_commit,
583: p_validation_level => p_validation_level,

Line 592: fnd_log.string (l_log_statement, L_DEBUG_KEY, 'After Calling AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production - l_return_status = '||l_return_status);

588: x_msg_count => l_msg_count,
589: x_msg_data => l_msg_data);
590:
591: IF (l_log_statement >= l_log_current_level)THEN
592: fnd_log.string (l_log_statement, L_DEBUG_KEY, 'After Calling AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production - l_return_status = '||l_return_status);
593: END IF;
594:
595: IF l_error_tbl_type.COUNT > 0 THEN
596: l_return_status := l_validate_error;

Line 603: fnd_log.string ( l_log_statement, L_DEBUG_KEY,'Errors from AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production - '||x_msg_count);

599: -- Check Error Message stack.
600: x_msg_count := FND_MSG_PUB.count_msg;
601:
602: IF (l_log_statement >= l_log_current_level)THEN
603: fnd_log.string ( l_log_statement, L_DEBUG_KEY,'Errors from AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production - '||x_msg_count);
604: END IF;
605: RAISE Fnd_Api.g_exc_error;
606: ELSE
607: --salogan::Commented the repeated code CP ER 9299910::01-JUN-2009::BEGIN

Line 778: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Release_visit');

774: SELECT visit_id INTO l_visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;
775:
776: IF l_visit_id IS NOT NULL THEN
777:
778: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Release_visit');
779: fnd_file.put_line(fnd_file.log, 'visit_id -> '||l_visit_id);
780:
781:
782: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063

Line 785: AHL_VWP_PROJ_PROD_PVT.plan_visit(

781:
782: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063
783: --If the caller if 'FORMS' or 'JAVA', then the request has been launched for Plan_Visit else for P2P
784: IF p_caller IN ('FORMS', 'JAVA') THEN
785: AHL_VWP_PROJ_PROD_PVT.plan_visit(
786: p_api_version => p_api_version,
787: p_init_msg_list => Fnd_Api.G_FALSE,
788: p_commit => Fnd_Api.g_false,
789: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 806: AHL_VWP_PROJ_PROD_PVT.Release_Visit(

802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: END IF;
804: END IF;
805: ELSE
806: AHL_VWP_PROJ_PROD_PVT.Release_Visit(
807: p_api_version => p_api_version,
808: p_module_type => 'JSP', --passing p_module_type as JSP
809: p_visit_id => l_visit_id,
810: p_release_flag => p_release_flag,

Line 6472: AHL_VWP_PROJ_PROD_PVT.Integrate_to_Projects

6468: L_DEBUG_KEY,
6469: 'Before calling INTEGRATE_TO_PROJECTS');
6470: END IF;
6471:
6472: AHL_VWP_PROJ_PROD_PVT.Integrate_to_Projects
6473: (p_api_version => l_api_version,
6474: p_init_msg_list => p_init_msg_list,
6475: p_commit => l_commit,
6476: p_validation_level => p_validation_level,

Line 7932: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production

7928: fnd_log.string (l_log_statement,L_DEBUG_KEY, 'Before Calling Validate Before Production');
7929: END IF;
7930:
7931: --Valdate before push to production happens
7932: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production
7933: (p_api_version => l_api_version,
7934: p_init_msg_list => p_init_msg_list,
7935: p_commit => l_commit,
7936: p_validation_level => p_validation_level,

Line 8039: AHL_VWP_PROJ_PROD_PVT.Push_to_Production

8035: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Push_to_Production');
8036: END IF;
8037:
8038: --Call push to production with module type 'CST'
8039: AHL_VWP_PROJ_PROD_PVT.Push_to_Production
8040: (p_api_version => l_api_version,
8041: p_init_msg_list => p_init_msg_list,
8042: p_commit => l_commit,
8043: p_validation_level => p_validation_level,

Line 8296: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production

8292: 'Before calling VALIDATE_BEFORE_PRODUCTION');
8293: END IF;
8294:
8295: --Validate visit before pushing the tasks to production
8296: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production
8297: (p_api_version => l_api_version,
8298: p_init_msg_list => p_init_msg_list,
8299: p_commit => 'F',
8300: p_validation_level => p_validation_level,

Line 8337: AHL_VWP_PROJ_PROD_PVT.Validate_tasks_bef_production(

8333: 'Before calling VALIDATE_TASKS_BEF_PRODUCTION. p_module_type = ' || p_module_type);
8334: END IF;
8335:
8336: --Validate tasks before push to production happens
8337: AHL_VWP_PROJ_PROD_PVT.Validate_tasks_bef_production(
8338: p_visit_id => p_visit_id,
8339: p_tasks_tbl => p_tasks_tbl,
8340: x_tasks_tbl => l_tasks_tbl,
8341: x_return_status => l_return_status,

Line 8423: AHL_VWP_PROJ_PROD_PVT.Aggregate_Task_Material_Reqrs

8419:
8420: --Total the material requirements for a specific item at task level
8421: FOR i IN l_tasks_tbl.FIRST..l_tasks_tbl.LAST
8422: LOOP
8423: AHL_VWP_PROJ_PROD_PVT.Aggregate_Task_Material_Reqrs
8424: ( p_api_version => p_api_version,
8425: p_init_msg_list => p_init_msg_list,
8426: p_commit => p_commit,
8427: p_validation_level => p_validation_level,

Line 8556: AHL_VWP_PROJ_PROD_PVT.Push_tasks_to_production

8552: 'Before calling PUSH_TASKS_TO_PRODUCTION for visit id: ' ||p_visit_id);
8553: END IF;
8554:
8555: --push the selected tasks to production
8556: AHL_VWP_PROJ_PROD_PVT.Push_tasks_to_production
8557: ( p_api_version => l_api_version,
8558: p_init_msg_list => p_init_msg_list,
8559: p_validation_level => p_validation_level,
8560: p_module_type => p_module_type,

Line 9495: AHL_VWP_PROJ_PROD_PVT.Integrate_to_Projects

9491: 'Before calling INTEGRATE_TO_PROJECTS for Visit Id ' || p_visit_id);
9492: END IF;
9493:
9494: --create the project id for the visit.
9495: AHL_VWP_PROJ_PROD_PVT.Integrate_to_Projects
9496: (p_api_version => l_api_version,
9497: p_init_msg_list => p_init_msg_list,
9498: p_commit => 'F',
9499: p_validation_level => p_validation_level,

Line 9828: AHL_VWP_PROJ_PROD_PVT.Get_Task_Relationships

9824: L_DEBUG_KEY,
9825: 'Before calling Get_Task_Relationships for task id: ' ||p_tasks_tbl(i).visit_task_id);
9826: END IF;
9827:
9828: AHL_VWP_PROJ_PROD_PVT.Get_Task_Relationships
9829: ( p_visit_id => p_visit_id,
9830: p_visit_number => c_visit_dtl_rec.visit_number,
9831: p_visit_task_id => c_visit_tsk_dtl_rec.visit_task_id,
9832: p_x_relationship_tbl => l_prd_workorder_rel_tbl

Line 9852: AHL_VWP_PROJ_PROD_PVT.Get_Task_Dependencies

9848: 'Before calling Get_Task_Dependencies for tasks');
9849: END IF;
9850:
9851: FOR i IN p_tasks_tbl.FIRST..p_tasks_tbl.LAST LOOP
9852: AHL_VWP_PROJ_PROD_PVT.Get_Task_Dependencies
9853: (
9854: p_visit_number => c_visit_dtl_rec.visit_number,
9855: p_visit_task_id => p_tasks_tbl(i).visit_task_id,
9856: p_visit_task_number => p_tasks_tbl(i).visit_task_number,

Line 12356: AHL_VWP_PROJ_PROD_PVT.Aggregate_Task_Material_Reqrs

12352: L_DEBUG_KEY,
12353: 'Before calling AGGREGATE_TASK_MATERIAL_REQRS for Visit Task Id: ' || l_visit_task_id);
12354: END IF;
12355:
12356: AHL_VWP_PROJ_PROD_PVT.Aggregate_Task_Material_Reqrs
12357: (p_api_version => p_api_version,
12358: p_init_msg_list => p_init_msg_list,
12359: p_commit => p_commit,
12360: p_validation_level => p_validation_level,

Line 14254: 'ahl.plsql.AHL_VWP_PROJ_PROD_PVT.plan_visit.begin',

14250: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
14251: fnd_log.string
14252: (
14253: fnd_log.level_procedure,
14254: 'ahl.plsql.AHL_VWP_PROJ_PROD_PVT.plan_visit.begin',
14255: 'At the start of PLSQL procedure, Visit ID : ' || p_visit_id
14256: );
14257: END IF;
14258:

Line 14288: 'ahl.plsql.AHL_VWP_PROJ_PROD_PVT.plan_visit',

14284: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
14285: fnd_log.string
14286: (
14287: fnd_log.level_exception,
14288: 'ahl.plsql.AHL_VWP_PROJ_PROD_PVT.plan_visit',
14289: 'Visit id is mandatory but found null in input '
14290: );
14291: END IF;
14292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 14307: 'ahl.plsql.AHL_VWP_PROJ_PROD_PVT.plan_visit',

14303: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
14304: fnd_log.string
14305: (
14306: fnd_log.level_exception,
14307: 'ahl.plsql.AHL_VWP_PROJ_PROD_PVT.plan_visit',
14308: 'Input Visit id is INVALID '
14309: );
14310: END IF;
14311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 14338: 'Before calling ahl vwp proj prod pvt.release visit'

14334: fnd_log.string
14335: (
14336: fnd_log.level_procedure,
14337: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
14338: 'Before calling ahl vwp proj prod pvt.release visit'
14339: );
14340: END IF;
14341:
14342: AHL_VWP_PROJ_PROD_PVT.RELEASE_VISIT (

Line 14342: AHL_VWP_PROJ_PROD_PVT.RELEASE_VISIT (

14338: 'Before calling ahl vwp proj prod pvt.release visit'
14339: );
14340: END IF;
14341:
14342: AHL_VWP_PROJ_PROD_PVT.RELEASE_VISIT (
14343: p_api_version => l_api_version,
14344: p_init_msg_list => Fnd_Api.g_false,
14345: p_commit => Fnd_Api.g_false,
14346: p_validation_level => p_validation_level,

Line 14359: 'After calling ahl vwp proj prod pvt.Release Visit : '|| l_return_status

14355: fnd_log.string
14356: (
14357: fnd_log.level_procedure,
14358: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
14359: 'After calling ahl vwp proj prod pvt.Release Visit : '|| l_return_status
14360: );
14361: END IF;
14362:
14363: END IF; -- released required flag

Line 14428: 'ahl.plsql.AHL_VWP_PROJ_PROD_PVT.plan_visit.end',

14424: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
14425: fnd_log.string
14426: (
14427: fnd_log.level_procedure,
14428: 'ahl.plsql.AHL_VWP_PROJ_PROD_PVT.plan_visit.end',
14429: 'At the end of PLSQL procedure'
14430: );
14431: END IF;
14432:

Line 14740: AHL_VWP_PROJ_PROD_PVT.Validate_tasks_bef_production(

14736: 'Before calling Validate_tasks_bef_production l_task_tbl_in.count '||l_task_tbl_in.count);
14737: END IF;
14738: IF l_count_val > 0 THEN
14739: --Validate tasks before push to production happens
14740: AHL_VWP_PROJ_PROD_PVT.Validate_tasks_bef_production(
14741: p_visit_id => p_visit_id,
14742: p_tasks_tbl => l_task_tbl_in,
14743: x_tasks_tbl => l_task_tbl_out,
14744: x_return_status => l_return_status,

Line 14822: AHL_VWP_PROJ_PROD_PVT.Integrate_to_Projects

14818: 'Before calling INTEGRATE_TO_PROJECTS for Visit Id ' || p_visit_id);
14819: END IF;
14820:
14821: --update the project for the visit.
14822: AHL_VWP_PROJ_PROD_PVT.Integrate_to_Projects
14823: (p_api_version => l_api_version,
14824: p_init_msg_list => FND_API.G_FALSE,
14825: p_commit => FND_API.G_FALSE,
14826: p_validation_level => p_validation_level,

Line 15039: AHL_VWP_PROJ_PROD_PVT.Get_Task_Relationships

15035: L_DEBUG_KEY,
15036: 'Before calling Get_Task_Relationships for task id: ' ||l_task_rec.visit_task_id);
15037: END IF;
15038:
15039: AHL_VWP_PROJ_PROD_PVT.Get_Task_Relationships
15040: ( p_visit_id => p_visit_id,
15041: p_visit_number => l_visit_dtl_rec.visit_number,
15042: p_visit_task_id => l_task_rec.visit_task_id,
15043: p_x_relationship_tbl => l_prd_workorder_rel_tbl

Line 15064: AHL_VWP_PROJ_PROD_PVT.Get_Task_Dependencies

15060: END IF;
15061:
15062: FOR i in p_stages_tbl.FIRST..p_stages_tbl.LAST LOOP --for stages
15063: FOR l_task_rec IN get_stage_tasks( p_stages_tbl(i).stage_id ) LOOP
15064: AHL_VWP_PROJ_PROD_PVT.Get_Task_Dependencies
15065: (
15066: p_visit_number => l_visit_dtl_rec.visit_number,
15067: p_visit_task_id => l_task_rec.visit_task_id,
15068: p_visit_task_number => l_task_rec.visit_task_number,

Line 15521: END AHL_VWP_PROJ_PROD_PVT;

15517: RETURN l_transaction_tsk_id;
15518:
15519: END Get_RB_Transaction_Task;
15520:
15521: END AHL_VWP_PROJ_PROD_PVT;