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_PRD_WORKORDER_PVT

Line 3406: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

3402: l_is_dept_changed BOOLEAN default false;
3403:
3404: -- Define local record datatypes
3405: l_visit_rec Visit_Rec_Type := p_x_visit_rec;
3406: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3407: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
3408: l_Space_Assignment_Rec ahl_ltp_space_assign_pub.Space_Assignment_Rec;
3409: --TCHIMIRA::P2P CP ER 9151144::09-DEC-2009
3410: l_is_comp_visit VARCHAR2(1) := AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_visit_rec.visit_id);

Line 3407: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

3403:
3404: -- Define local record datatypes
3405: l_visit_rec Visit_Rec_Type := p_x_visit_rec;
3406: l_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
3407: l_workoper_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
3408: l_Space_Assignment_Rec ahl_ltp_space_assign_pub.Space_Assignment_Rec;
3409: --TCHIMIRA::P2P CP ER 9151144::09-DEC-2009
3410: l_is_comp_visit VARCHAR2(1) := AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_visit_rec.visit_id);
3411: l_auto_visit_type_flag VARCHAR2(1);--TCHIMIRA :: 14-Jun-2012 :: ER 14015560

Line 4244: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs');

4240: IF c_visit_WO%FOUND THEN
4241: CLOSE c_visit_WO;
4242:
4243: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4244: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs');
4245: END IF;
4246:
4247: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
4248: (p_api_version => 1.0,

Line 4247: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

4243: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4244: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs');
4245: END IF;
4246:
4247: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
4248: (p_api_version => 1.0,
4249: p_init_msg_list => FND_API.G_TRUE,
4250: p_commit => FND_API.G_FALSE,
4251: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4262: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs - l_return_status : '||l_return_status);

4258: p_unit_effectivity_id => NULL,
4259: p_workorder_id => NULL);
4260:
4261: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4262: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs - l_return_status : '||l_return_status);
4263: END IF;
4264:
4265: IF l_return_status <> 'S' THEN
4266: RAISE Fnd_Api.G_EXC_ERROR;

Line 4290: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs');

4286: IF c_visit_WO%found THEN
4287: close c_visit_WO;
4288:
4289: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4290: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs');
4291: END IF;
4292:
4293: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
4294: (p_api_version => 1.0,

Line 4293: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

4289: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4290: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs');
4291: END IF;
4292:
4293: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
4294: (p_api_version => 1.0,
4295: p_init_msg_list => FND_API.G_TRUE,
4296: p_commit => FND_API.G_FALSE,
4297: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4308: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs - l_return_status : '||l_return_status);

4304: p_unit_effectivity_id => NULL,
4305: p_workorder_id => NULL);
4306:
4307: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4308: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs - l_return_status : '||l_return_status);
4309: END IF;
4310:
4311: IF l_return_status <> 'S' THEN
4312: RAISE Fnd_Api.G_EXC_ERROR;

Line 4334: fnd_log.string(fnd_log.level_statement,L_DEBUG,'VISIT - Before calling AHL_PRD_WORKORDER_PVT.update_job API');

4330: -- l_workorder_rec.SCHEDULED_START_DATE := l_date_time_start;
4331: -- l_workorder_rec.SCHEDULED_END_DATE := l_visit_end_date;
4332:
4333: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4334: fnd_log.string(fnd_log.level_statement,L_DEBUG,'VISIT - Before calling AHL_PRD_WORKORDER_PVT.update_job API');
4335: END IF;
4336:
4337: AHL_PRD_WORKORDER_PVT.update_job
4338: ( p_api_version =>1.0,

Line 4337: AHL_PRD_WORKORDER_PVT.update_job

4333: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4334: fnd_log.string(fnd_log.level_statement,L_DEBUG,'VISIT - Before calling AHL_PRD_WORKORDER_PVT.update_job API');
4335: END IF;
4336:
4337: AHL_PRD_WORKORDER_PVT.update_job
4338: ( p_api_version =>1.0,
4339: p_init_msg_list =>fnd_api.g_false,
4340: p_commit =>fnd_api.g_false,
4341: p_validation_level =>p_validation_level,

Line 4358: fnd_log.string(fnd_log.level_statement,L_DEBUG,'VISIT - After calling AHL_PRD_WORKORDER_PVT.update_job API - l_return_status : '||l_return_status);

4354: RAISE Fnd_Api.G_EXC_ERROR;
4355: END IF;
4356:
4357: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4358: fnd_log.string(fnd_log.level_statement,L_DEBUG,'VISIT - After calling AHL_PRD_WORKORDER_PVT.update_job API - l_return_status : '||l_return_status);
4359: END IF;
4360: END IF; -- End of visit workorder found
4361: CLOSE c_visit_WO;
4362:

Line 4393: fnd_log.string(fnd_log.level_statement,L_DEBUG,'TASK - Before calling AHL_PRD_WORKORDER_PVT.update_job');

4389: l_workorder_rec.OBJECT_VERSION_NUMBER := l_task_workrec.object_version_number;
4390:
4391: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4392: fnd_log.string(fnd_log.level_statement,L_DEBUG,'TASK - Workorder Id = ' || l_workorder_rec.WORKORDER_ID);
4393: fnd_log.string(fnd_log.level_statement,L_DEBUG,'TASK - Before calling AHL_PRD_WORKORDER_PVT.update_job');
4394: END IF;
4395:
4396: AHL_PRD_WORKORDER_PVT.update_job
4397: ( p_api_version =>1.0,

Line 4396: AHL_PRD_WORKORDER_PVT.update_job

4392: fnd_log.string(fnd_log.level_statement,L_DEBUG,'TASK - Workorder Id = ' || l_workorder_rec.WORKORDER_ID);
4393: fnd_log.string(fnd_log.level_statement,L_DEBUG,'TASK - Before calling AHL_PRD_WORKORDER_PVT.update_job');
4394: END IF;
4395:
4396: AHL_PRD_WORKORDER_PVT.update_job
4397: ( p_api_version =>1.0,
4398: p_init_msg_list =>fnd_api.g_false,
4399: p_commit =>fnd_api.g_false,
4400: p_validation_level =>p_validation_level,

Line 4412: fnd_log.string(fnd_log.level_statement,L_DEBUG,'TASK - After calling AHL_PRD_WORKORDER_PVT.update_job - l_return_status : '||l_return_status);

4408: P_X_PRD_WORKOPER_TBL =>l_workoper_tbl
4409: );
4410:
4411: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4412: fnd_log.string(fnd_log.level_statement,L_DEBUG,'TASK - After calling AHL_PRD_WORKORDER_PVT.update_job - l_return_status : '||l_return_status);
4413: END IF;
4414:
4415: IF l_return_status <> 'S' THEN
4416: CLOSE c_Task_WO;

Line 4574: 'Before calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs');

4570:
4571: IF (l_log_statement >= l_log_current_level) THEN
4572: fnd_log.string(l_log_statement,
4573: L_DEBUG,
4574: 'Before calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs');
4575: END IF;
4576:
4577: AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs(
4578: P_API_VERSION => 1.0,

Line 4577: AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs(

4573: L_DEBUG,
4574: 'Before calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs');
4575: END IF;
4576:
4577: AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs(
4578: P_API_VERSION => 1.0,
4579: x_return_status => l_return_status,
4580: x_msg_count => l_msg_count,
4581: x_msg_data => l_msg_data,

Line 4589: 'After calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs. Return Status = ' || l_return_status);

4585:
4586: IF (l_log_statement >= l_log_current_level) THEN
4587: fnd_log.string(l_log_statement,
4588: L_DEBUG,
4589: 'After calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs. Return Status = ' || l_return_status);
4590: END IF;
4591:
4592: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
4593: IF (l_log_statement >= l_log_current_level) THEN

Line 4596: 'Errors from AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs. Message count: ' ||

4592: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
4593: IF (l_log_statement >= l_log_current_level) THEN
4594: fnd_log.string(l_log_statement,
4595: L_DEBUG,
4596: 'Errors from AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs. Message count: ' ||
4597: l_msg_count || ', message data: ' || l_msg_data);
4598: END IF;
4599: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4600: RAISE FND_API.G_EXC_ERROR;

Line 5293: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

5289:
5290: l_tasks_rec c_tasks_csr%ROWTYPE;
5291:
5292: -- Local record of Workorder used while calling update job method.
5293: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
5294: l_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
5295:
5296: BEGIN
5297: --------------------- Initialize -----------------------

Line 5294: l_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;

5290: l_tasks_rec c_tasks_csr%ROWTYPE;
5291:
5292: -- Local record of Workorder used while calling update job method.
5293: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
5294: l_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKOPER_TBL;
5295:
5296: BEGIN
5297: --------------------- Initialize -----------------------
5298: SAVEPOINT Delete_Visit;

Line 5471: fnd_log.string (fnd_log.level_statement,L_DEBUG,'before calling AHL_PRD_WORKORDER_PVT.update_job - Workorder Id : '||l_prd_workorder_rec.workorder_id);

5467: l_prd_workorder_rec.object_version_number := l_active_workorder_rec.object_version_number;
5468: l_prd_workorder_rec.STATUS_CODE:='22'; --Deleted Status Refer DLD to Verify.
5469:
5470: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5471: fnd_log.string (fnd_log.level_statement,L_DEBUG,'before calling AHL_PRD_WORKORDER_PVT.update_job - Workorder Id : '||l_prd_workorder_rec.workorder_id);
5472: END IF;
5473:
5474: AHL_PRD_WORKORDER_PVT.update_job
5475: ( p_api_version =>1.0,

Line 5474: AHL_PRD_WORKORDER_PVT.update_job

5470: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5471: fnd_log.string (fnd_log.level_statement,L_DEBUG,'before calling AHL_PRD_WORKORDER_PVT.update_job - Workorder Id : '||l_prd_workorder_rec.workorder_id);
5472: END IF;
5473:
5474: AHL_PRD_WORKORDER_PVT.update_job
5475: ( p_api_version =>1.0,
5476: p_init_msg_list =>fnd_api.g_false,
5477: p_commit =>fnd_api.g_false,
5478: p_validation_level =>p_validation_level,

Line 5490: fnd_log.string (fnd_log.level_statement,L_DEBUG,'after calling AHL_PRD_WORKORDER_PVT.update_job - l_return_status : '||l_return_status);

5486: p_x_prd_workoper_tbl =>l_workorder_tbl
5487: );
5488:
5489: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5490: fnd_log.string (fnd_log.level_statement,L_DEBUG,'after calling AHL_PRD_WORKORDER_PVT.update_job - l_return_status : '||l_return_status);
5491: END IF;
5492:
5493: IF NVL(l_return_status, 'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
5494: CLOSE c_active_workorder;

Line 6434: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs l_workorder_id= '||l_workorder_id);

6430: FETCH get_default_stage_wo INTO l_workorder_id;
6431: CLOSE get_default_stage_wo;
6432:
6433: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6434: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs l_workorder_id= '||l_workorder_id);
6435: END IF;
6436:
6437: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
6438: (p_api_version => 1.0,

Line 6437: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

6433: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6434: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs l_workorder_id= '||l_workorder_id);
6435: END IF;
6436:
6437: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
6438: (p_api_version => 1.0,
6439: p_init_msg_list => FND_API.G_FALSE,
6440: p_commit => FND_API.G_FALSE,
6441: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 6452: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs - l_return_status : '||l_return_status);

6448: p_unit_effectivity_id => NULL,
6449: p_workorder_id => l_workorder_id);
6450:
6451: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6452: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs - l_return_status : '||l_return_status);
6453: END IF;
6454:
6455: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
6456: x_msg_count := l_msg_count;

Line 6939: -- All work order status validation will now be done by AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

6935: END IF;
6936:
6937: -- Changed by jaramana on 05-NOV-2009
6938: -- Removed the validations added for the bug 9087120
6939: -- All work order status validation will now be done by AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
6940:
6941: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6942: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs');
6943: END IF;

Line 6942: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs');

6938: -- Removed the validations added for the bug 9087120
6939: -- All work order status validation will now be done by AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
6940:
6941: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6942: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs');
6943: END IF;
6944: -- Added by shbhanda for Transit check changes on 06/25/2004
6945: -- Code Start
6946: -- Call Cancel_Visit_Jobs API

Line 6947: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

6943: END IF;
6944: -- Added by shbhanda for Transit check changes on 06/25/2004
6945: -- Code Start
6946: -- Call Cancel_Visit_Jobs API
6947: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
6948: (p_api_version => 1.0,
6949: -- SKPATHAK :: Bug 9115894 :: 20-NOV-2009 :: pass p_init_msg_list as false not true
6950: p_init_msg_list => FND_API.G_FALSE,
6951: p_commit => FND_API.G_FALSE,

Line 6964: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs - l_return_status : '||l_return_status);

6960: p_unit_effectivity_id => NULL,
6961: p_workorder_id => NULL);
6962:
6963: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6964: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs - l_return_status : '||l_return_status);
6965: END IF;
6966: -- SKPATHAK :: Bug 9115894 :: 13-NOV-2009
6967: -- If return status is V, same should be carried over to the caller
6968: IF l_return_status = G_VALIDATION_ERROR_STATUS THEN

Line 7578: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.RESCHEDULE_VISIT_JOBS');

7574: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
7575: END IF;
7576:
7577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7578: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.RESCHEDULE_VISIT_JOBS');
7579: END IF;
7580:
7581: AHL_PRD_WORKORDER_PVT.RESCHEDULE_VISIT_JOBS(
7582: P_API_VERSION => l_api_version,

Line 7581: AHL_PRD_WORKORDER_PVT.RESCHEDULE_VISIT_JOBS(

7577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7578: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_PRD_WORKORDER_PVT.RESCHEDULE_VISIT_JOBS');
7579: END IF;
7580:
7581: AHL_PRD_WORKORDER_PVT.RESCHEDULE_VISIT_JOBS(
7582: P_API_VERSION => l_api_version,
7583: X_RETURN_STATUS => l_return_status,
7584: X_MSG_COUNT => l_msg_count,
7585: X_MSG_DATA => l_msg_data,

Line 7591: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_PRD_WORKORDER_PVT.RESCHEDULE_VISIT_JOBS - l_return_status : '||l_return_status);

7587: p_x_scheduled_start_date => l_visit_rec.START_DATE,
7588: p_x_scheduled_end_date => l_visit_rec.PLAN_END_DATE);
7589:
7590: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7591: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_PRD_WORKORDER_PVT.RESCHEDULE_VISIT_JOBS - l_return_status : '||l_return_status);
7592: END IF;
7593:
7594: IF l_return_status <> 'S' THEN
7595: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;