DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VWP_PROJ_PROD_PVT

Line 2570: 'After Calling AHL_VWP_PROJ_PROD_PVT.plan_visit. Return Status = ' || l_return_status );

2566:
2567: IF (l_log_statement >= l_log_current_level) THEN
2568: fnd_log.string(l_log_statement,
2569: L_DEBUG,
2570: 'After Calling AHL_VWP_PROJ_PROD_PVT.plan_visit. Return Status = ' || l_return_status );
2571: END IF;
2572:
2573: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
2574: x_msg_count := l_msg_count;

Line 2725: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_PROJ_PROD_PVT.Release_Visit');

2721: END IF;
2722:
2723: IF l_release_flag IS NOT NULL THEN
2724: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2725: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_PROJ_PROD_PVT.Release_Visit');
2726: END IF;
2727:
2728: AHL_VWP_PROJ_PROD_PVT.Release_Visit (
2729: p_api_version => 1.0,

Line 2728: AHL_VWP_PROJ_PROD_PVT.Release_Visit (

2724: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2725: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_PROJ_PROD_PVT.Release_Visit');
2726: END IF;
2727:
2728: AHL_VWP_PROJ_PROD_PVT.Release_Visit (
2729: p_api_version => 1.0,
2730: /*p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
2731: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
2732: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FU */

Line 2741: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_PROJ_PROD_PVT.Release_Visit - x_return_status : '||x_return_status);

2737: x_msg_count => x_msg_count,
2738: x_msg_data => x_msg_data);
2739:
2740: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2741: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_PROJ_PROD_PVT.Release_Visit - x_return_status : '||x_return_status);
2742: END IF;
2743: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: STARTS
2744: -- If visit is created in planning status, draft WOs should be automatically created for the visit tasks
2745: ELSIF l_Visit_rec.visit_create_type = 'PLANNING' THEN

Line 2746: AHL_VWP_PROJ_PROD_PVT.plan_visit(

2742: END IF;
2743: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: STARTS
2744: -- If visit is created in planning status, draft WOs should be automatically created for the visit tasks
2745: ELSIF l_Visit_rec.visit_create_type = 'PLANNING' THEN
2746: AHL_VWP_PROJ_PROD_PVT.plan_visit(
2747: p_api_version => l_api_version,
2748: p_init_msg_list => p_init_msg_list,
2749: p_commit => Fnd_Api.g_false,
2750: p_validation_level => p_validation_level,

Line 2759: 'After Calling AHL_VWP_PROJ_PROD_PVT.plan_visit. Return Status = ' || x_return_status );

2755:
2756: IF (l_log_statement >= l_log_current_level) THEN
2757: fnd_log.string(l_log_statement,
2758: L_DEBUG,
2759: 'After Calling AHL_VWP_PROJ_PROD_PVT.plan_visit. Return Status = ' || x_return_status );
2760: END IF;
2761:
2762: END IF;
2763: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: END

Line 5161: AHL_VWP_PROJ_PROD_PVT.Delete_Task_To_project(

5157: VISIT_TASK_ID = p_Visit_Task_Id
5158: OR
5159: PARENT_TASK_ID = p_Visit_Task_Id;
5160:
5161: AHL_VWP_PROJ_PROD_PVT.Delete_Task_To_project(
5162: p_api_version => p_api_version,
5163: p_init_msg_list => p_init_msg_list,
5164: p_commit => Fnd_Api.g_false,
5165: p_validation_level => p_validation_level,

Line 5512: fnd_log.string (fnd_log.level_statement,L_DEBUG,'before calling AHL_VWP_PROJ_PROD_PVT.Update_project');

5508: IF l_visit_rec.PROJECT_ID IS NOT NULL THEN
5509: IF l_soft_delete_flag = 'Y' THEN
5510: -- Update the project status to 'Rejected'
5511: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5512: fnd_log.string (fnd_log.level_statement,L_DEBUG,'before calling AHL_VWP_PROJ_PROD_PVT.Update_project');
5513: END IF;
5514:
5515: AHL_VWP_PROJ_PROD_PVT.Update_project
5516: ( p_api_version => p_api_version,

Line 5515: AHL_VWP_PROJ_PROD_PVT.Update_project

5511: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5512: fnd_log.string (fnd_log.level_statement,L_DEBUG,'before calling AHL_VWP_PROJ_PROD_PVT.Update_project');
5513: END IF;
5514:
5515: AHL_VWP_PROJ_PROD_PVT.Update_project
5516: ( p_api_version => p_api_version,
5517: p_init_msg_list => l_init_msg_list,
5518: p_commit => l_commit,
5519: p_validation_level => p_validation_level,

Line 5528: fnd_log.string (fnd_log.level_statement,L_DEBUG,'after calling AHL_VWP_PROJ_PROD_PVT.Update_project - l_return_status : '||l_return_status);

5524: x_msg_data => x_msg_data
5525: );
5526:
5527: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5528: fnd_log.string (fnd_log.level_statement,L_DEBUG,'after calling AHL_VWP_PROJ_PROD_PVT.Update_project - l_return_status : '||l_return_status);
5529: END IF;
5530:
5531: IF NVL(l_return_status, 'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
5532: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRJ_UPDATE_FAILED'); -- Failed to update job

Line 5540: fnd_log.string (fnd_log.level_statement,L_DEBUG,'before calling AHL_VWP_PROJ_PROD_PVT.Delete_Project ');

5536: ELSE
5537: -- When a visit is hard deleted than the related projects is also deleted
5538: -- Call Delete_Project local procedure to delete project and its tasks
5539: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5540: fnd_log.string (fnd_log.level_statement,L_DEBUG,'before calling AHL_VWP_PROJ_PROD_PVT.Delete_Project ');
5541: END IF;
5542:
5543: AHL_VWP_PROJ_PROD_PVT.Delete_Project
5544: ( p_api_version => p_api_version,

Line 5543: AHL_VWP_PROJ_PROD_PVT.Delete_Project

5539: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5540: fnd_log.string (fnd_log.level_statement,L_DEBUG,'before calling AHL_VWP_PROJ_PROD_PVT.Delete_Project ');
5541: END IF;
5542:
5543: AHL_VWP_PROJ_PROD_PVT.Delete_Project
5544: ( p_api_version => p_api_version,
5545: p_init_msg_list => l_init_msg_list,
5546: p_commit => l_commit,
5547: p_validation_level => p_validation_level,

Line 5555: fnd_log.string (fnd_log.level_statement,L_DEBUG,'after calling AHL_VWP_PROJ_PROD_PVT.Delete_Project - l_return_status : '||l_return_status);

5551: x_msg_count => x_msg_count,
5552: x_msg_data => x_msg_data);
5553:
5554: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5555: fnd_log.string (fnd_log.level_statement,L_DEBUG,'after calling AHL_VWP_PROJ_PROD_PVT.Delete_Project - l_return_status : '||l_return_status);
5556: END IF;
5557:
5558: IF NVL(l_return_status, 'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
5559: -- Method call was not successful, raise error

Line 6614: AHL_VWP_PROJ_PROD_PVT.Update_Project (

6610: IF l_chk_flag = 'Y' THEN
6611: -- yazhou 28Sept2005 starts
6612: -- bug fix #4626717
6613: /* Call Update_Project procedure to update project status to CLOSED
6614: AHL_VWP_PROJ_PROD_PVT.Update_Project (
6615: p_api_version => p_api_version,
6616: p_init_msg_list => p_init_msg_list,
6617: p_commit => Fnd_Api.g_false,
6618: p_validation_level => p_validation_level,

Line 7105: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_PROJ_PROD_PVT.Update_Project');

7101: -- if not null then update PA_PROJECTS_ALL and set the
7102: -- project status code to 'CLOSED'
7103: IF c_visit_rec.PROJECT_ID IS NOT NULL THEN
7104: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7105: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_PROJ_PROD_PVT.Update_Project');
7106: END IF;
7107:
7108: AHL_VWP_PROJ_PROD_PVT.Update_Project(
7109: p_api_version => p_api_version,

Line 7108: AHL_VWP_PROJ_PROD_PVT.Update_Project(

7104: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7105: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_PROJ_PROD_PVT.Update_Project');
7106: END IF;
7107:
7108: AHL_VWP_PROJ_PROD_PVT.Update_Project(
7109: p_api_version => p_api_version,
7110: p_init_msg_list => p_init_msg_list,
7111: p_commit => Fnd_Api.g_false,
7112: p_validation_level => p_validation_level,

Line 7121: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_PROJ_PROD_PVT.Update_Project - x_return_status : '||x_return_status);

7117: x_msg_data => x_msg_data);
7118: --The following END IF was commented out by jeli on 07/27/04, otherwise it couldn't pass the compilation.
7119:
7120: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7121: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_PROJ_PROD_PVT.Update_Project - x_return_status : '||x_return_status);
7122: END IF;
7123:
7124: IF NVL(x_return_status, 'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
7125: -- Method call was not successful, raise error

Line 7495: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_PROJ_PROD_PVT.Release_Visit');

7491: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
7492: END IF;
7493:
7494: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7495: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_PROJ_PROD_PVT.Release_Visit');
7496: END IF;
7497:
7498: AHL_VWP_PROJ_PROD_PVT.Release_Visit (
7499: p_api_version => l_api_version,

Line 7498: AHL_VWP_PROJ_PROD_PVT.Release_Visit (

7494: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7495: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_PROJ_PROD_PVT.Release_Visit');
7496: END IF;
7497:
7498: AHL_VWP_PROJ_PROD_PVT.Release_Visit (
7499: p_api_version => l_api_version,
7500: p_visit_id => l_visit_rec.visit_id,
7501: p_module_type => 'VWP',
7502: p_release_flag => NUll,

Line 7510: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_PROJ_PROD_PVT.Release_Visit : l_return_status - '||l_return_status);

7506: X_MSG_DATA => l_msg_data
7507: );
7508:
7509: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7510: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_PROJ_PROD_PVT.Release_Visit : l_return_status - '||l_return_status);
7511: END IF;
7512:
7513: IF l_return_status <> 'S' THEN
7514: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;