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_VISITS_PVT dependencies on AHL_LTP_REQST_MATRL_PVT

Line 3156: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');

3152:
3153: -- Create Planned Material if task type is planned or unplanned
3154: IF c_task_rec.task_type_code in ('PLANNED','UNPLANNED') THEN
3155: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3156: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
3157: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Value of Visit Task ID : ' || c_task_rec.visit_task_id);
3158: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Value of Visit ID : ' || l_visit_id);
3159: END IF;
3160:

Line 3162: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials

3158: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Value of Visit ID : ' || l_visit_id);
3159: END IF;
3160:
3161: -- To call LTP Process Materials API for APS Integration
3162: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials
3163: ( p_api_version => 1.0,
3164: p_init_msg_list => FND_API.g_false,
3165: p_commit => FND_API.g_false,
3166: p_validation_level => FND_API.g_valid_level_full,

Line 3178: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials : l_return_status - '||l_return_status);

3174: x_msg_count => l_msg_count,
3175: x_msg_data => l_msg_data );
3176:
3177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3178: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials : l_return_status - '||l_return_status);
3179: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Planned Order Flag : ' || l_planned_order_flag);
3180: END IF;
3181:
3182: IF l_return_status <> 'S' THEN

Line 4872: -- else if any of them is updated then AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials is invoked with operation flag 'U' as earlier.

4868: -- To call LTP Process Materials API for APS Integration by Shbhanda 04-Dec-03
4869: -- changed the condition for fixing the issue 144 , in the CMRO Forum
4870: -- if any of start date,organization, or department is not
4871: -- is invoked with operation flag 'D'
4872: -- else if any of them is updated then AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials is invoked with operation flag 'U' as earlier.
4873:
4874: IF (( c_visit_rec.organization_id IS NOT NULL AND c_visit_rec.department_id IS NOT NULL AND
4875: c_Visit_rec.START_DATE_TIME IS NOT NULL )
4876: AND ( l_date_time_start IS NULL OR l_date_time_start = Fnd_Api.G_MISS_DATE OR

Line 4881: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');

4877: l_visit_rec.organization_id IS NULL OR l_visit_rec.organization_id = Fnd_Api.G_MISS_NUM OR
4878: l_visit_rec.department_id IS NULL OR l_visit_rec.department_id = Fnd_Api.G_MISS_NUM ))
4879: THEN
4880: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4881: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
4882: END IF;
4883:
4884: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (
4885: p_api_version => 1.0,

Line 4884: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (

4880: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4881: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
4882: END IF;
4883:
4884: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (
4885: p_api_version => 1.0,
4886: p_init_msg_list => FND_API.g_false,
4887: p_commit => FND_API.g_false,
4888: p_validation_level => FND_API.g_valid_level_full,

Line 4900: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials - l_return_status : '||l_return_status);

4896: x_msg_count => x_msg_count,
4897: x_msg_data => x_msg_data );
4898:
4899: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4900: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials - l_return_status : '||l_return_status);
4901: END IF;
4902:
4903: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4904: RAISE FND_API.G_EXC_ERROR;

Line 4913: /*AHL_DEBUG_PUB.Debug( l_full_name ||': VISIT UPDATED - Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');

4909: AND ( l_date_time_start IS NOT NULL AND l_date_time_start <> Fnd_Api.G_MISS_DATE
4910: AND l_visit_rec.organization_id IS NOT NULL AND l_visit_rec.organization_id <> Fnd_Api.G_MISS_NUM
4911: AND l_visit_rec.department_id IS NOT NULL AND l_visit_rec.department_id <> Fnd_Api.G_MISS_NUM )
4912: THEN
4913: /*AHL_DEBUG_PUB.Debug( l_full_name ||': VISIT UPDATED - Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
4914: ELSIF (
4915: ( l_date_time_start <> c_Visit_rec.START_DATE_TIME)
4916: OR (l_visit_rec.organization_id <> c_visit_rec.organization_id)
4917: OR (l_visit_rec.department_id <> c_visit_rec.department_id)

Line 4928: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');

4924: Handle_Visit_Org_Change(p_visit_id => l_visit_rec.Visit_Id);
4925: END IF;
4926: -- End Changes by surrkuma on 15-JUL-2010 for Bug 9901811
4927: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4928: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
4929: END IF;
4930:
4931: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011
4932: * There is no need to consider Stage materials for Component Visits

Line 4946: AHL_LTP_REQST_MATRL_PVT.Associate_Stage_Materials (

4942: fnd_log.string(fnd_log.level_statement, L_DEBUG,
4943: 'Before calling Associate_Stage_Materials and mr_id is : '||l_task_detl_rec.mr_id||'l_unit_eff_id: '||l_task_detl_rec.unit_effectivity_id
4944: ||'p_visit_id: '||l_visit_rec.Visit_Id||'l_instance_id: '||l_task_detl_rec.instance_id);
4945: END IF;
4946: AHL_LTP_REQST_MATRL_PVT.Associate_Stage_Materials (
4947: p_api_version => 1.0,
4948: p_init_msg_list => Fnd_Api.G_FALSE,
4949: p_commit => Fnd_Api.G_FALSE,
4950: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 4979: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (

4975: END LOOP;
4976: -- TCHIMIRA :: 16-JUL-2011 :: VWPE: ER:12730539 :: END
4977: END IF; -- if l_is_comp_visit = 'N'
4978:
4979: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (
4980: p_api_version => 1.0,
4981: p_init_msg_list => FND_API.g_false,
4982: p_commit => FND_API.g_false,
4983: p_validation_level => FND_API.g_valid_level_full,

Line 4995: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials - l_return_status : '||l_return_status);

4991: x_msg_count => x_msg_count,
4992: x_msg_data => x_msg_data );
4993:
4994: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4995: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials - l_return_status : '||l_return_status);
4996: END IF;
4997:
4998: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4999: RAISE FND_API.G_EXC_ERROR;

Line 5356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');

5352: IF c_Material%FOUND THEN
5353: l_soft_delete_flag := 'Y';
5354:
5355: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
5357: END IF;
5358:
5359: -- Removing planned materials for the visit
5360: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials

Line 5360: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials

5356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
5357: END IF;
5358:
5359: -- Removing planned materials for the visit
5360: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials
5361: (p_api_version => p_api_version,
5362: p_init_msg_list => Fnd_Api.G_FALSE,
5363: p_commit => Fnd_Api.G_FALSE,
5364: p_visit_id => p_visit_id,

Line 5375: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials - l_return_status : '||l_return_status);

5371: x_msg_count => x_msg_count,
5372: x_msg_data => x_msg_data);
5373:
5374: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5375: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials - l_return_status : '||l_return_status);
5376: END IF;
5377:
5378: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5379: CLOSE c_Material;

Line 6687: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');

6683: CLOSE c_visit;
6684:
6685: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6686: fnd_log.string(fnd_log.level_statement,L_DEBUG,'VISIT STATUS - ' || c_visit_rec.status_code);
6687: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
6688: END IF;
6689:
6690: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (
6691: p_api_version => 1.0,

Line 6690: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (

6686: fnd_log.string(fnd_log.level_statement,L_DEBUG,'VISIT STATUS - ' || c_visit_rec.status_code);
6687: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
6688: END IF;
6689:
6690: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (
6691: p_api_version => 1.0,
6692: p_init_msg_list => FND_API.g_false,
6693: p_commit => FND_API.g_false,
6694: p_validation_level => FND_API.g_valid_level_full,

Line 6707: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials : x_return_status - '||x_return_status);

6703: x_msg_count => x_msg_count,
6704: x_msg_data => x_msg_data );
6705:
6706: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6707: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials : x_return_status - '||x_return_status);
6708: END IF;
6709:
6710: l_msg_count := FND_MSG_PUB.count_msg;
6711: IF l_msg_count > 0 THEN

Line 7033: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');

7029: END IF;
7030:
7031:
7032: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7033: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
7034: END IF;
7035:
7036: -- Call AHL_LTP_REQST_MATRL_PVT.Process_Planned_Material
7037: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials

Line 7036: -- Call AHL_LTP_REQST_MATRL_PVT.Process_Planned_Material

7032: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7033: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
7034: END IF;
7035:
7036: -- Call AHL_LTP_REQST_MATRL_PVT.Process_Planned_Material
7037: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials
7038: (p_api_version => 1.0,
7039: p_init_msg_list => FND_API.g_false,
7040: p_commit => FND_API.g_false,

Line 7037: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials

7033: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
7034: END IF;
7035:
7036: -- Call AHL_LTP_REQST_MATRL_PVT.Process_Planned_Material
7037: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials
7038: (p_api_version => 1.0,
7039: p_init_msg_list => FND_API.g_false,
7040: p_commit => FND_API.g_false,
7041: p_validation_level => FND_API.g_valid_level_full,

Line 7054: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials - l_return_status : '||l_return_status);

7050: x_msg_count => l_msg_count,
7051: x_msg_data => l_msg_data);
7052:
7053: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7054: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials - l_return_status : '||l_return_status);
7055: END IF;
7056:
7057: -- Check return status.
7058: IF l_return_status = FND_API.G_RET_STS_ERROR THEN