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_AVF_OPER_VSTS_PVT dependencies on FND_FILE

Line 315: fnd_file.put_line(fnd_file.log, 'List of Operational Visit Numbers created ');

311: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
312: END IF;
313:
314: -- Added for logging visit numbers :: SATRAJEN
315: fnd_file.put_line(fnd_file.log, 'List of Operational Visit Numbers created ');
316:
317: -- Loop through all the flight schedule records whose status is Created.
318: FOR flight_schedule_rec IN get_flight_schedule_rows('C') LOOP
319: -- store all the flight params in the record

Line 4253: fnd_file.put_line(fnd_file.log, 'Validation Failure: No departure visit created, since flight '||flt_dets_rec.flight_number||' is already departured.');

4249: FETCH get_flight_details INTO flt_dets_rec;
4250: CLOSE get_flight_details;
4251:
4252: IF l_end_date < p_present_time THEN
4253: fnd_file.put_line(fnd_file.log, 'Validation Failure: No departure visit created, since flight '||flt_dets_rec.flight_number||' is already departured.');
4254: ELSE
4255: fnd_file.put_line(fnd_file.log, 'Validation Failure: No departure visit created, since visit start date for flight '||flt_dets_rec.flight_number||' is deriving to past.');
4256: END IF;
4257: p_is_creation_success := 'N'; -- Flag as creation failed due to validations

Line 4255: fnd_file.put_line(fnd_file.log, 'Validation Failure: No departure visit created, since visit start date for flight '||flt_dets_rec.flight_number||' is deriving to past.');

4251:
4252: IF l_end_date < p_present_time THEN
4253: fnd_file.put_line(fnd_file.log, 'Validation Failure: No departure visit created, since flight '||flt_dets_rec.flight_number||' is already departured.');
4254: ELSE
4255: fnd_file.put_line(fnd_file.log, 'Validation Failure: No departure visit created, since visit start date for flight '||flt_dets_rec.flight_number||' is deriving to past.');
4256: END IF;
4257: p_is_creation_success := 'N'; -- Flag as creation failed due to validations
4258:
4259: ELSE

Line 4303: fnd_file.put_line(fnd_file.log, 'Validation Failure: Had problems with the MRs associated. So departure visit creation for flight '||flt_dets_rec.flight_number||' is not successful.');

4299: OPEN get_flight_details(p_flight_schedule_rec.unit_schedule_id);
4300: FETCH get_flight_details INTO flt_dets_rec;
4301: CLOSE get_flight_details;
4302:
4303: fnd_file.put_line(fnd_file.log, 'Validation Failure: Had problems with the MRs associated. So departure visit creation for flight '||flt_dets_rec.flight_number||' is not successful.');
4304: ELSE
4305: x_return_status := l_return_status ;
4306: x_msg_count := FND_MSG_PUB.count_msg;
4307: IF (l_log_statement >= l_log_current_level) THEN

Line 4324: fnd_file.put_line(fnd_file.log, 'Created departure visit number -> '||l_visit_number);

4320: l_visit_number := NULL;
4321: OPEN get_visit_number(l_visit_rec.visit_id);
4322: FETCH get_visit_number INTO l_visit_number;
4323: CLOSE get_visit_number;
4324: fnd_file.put_line(fnd_file.log, 'Created departure visit number -> '||l_visit_number);
4325: -- End of logging
4326: END IF;
4327: -- SATRAJEN :: Bug 14336467 :: Prevent Erroring out when the called from Operational Visit Procedure. :: END
4328: END IF; -- IF l_is_org_in_curr_OU = 'X'

Line 4514: fnd_file.put_line(fnd_file.log, 'Validation Failure: No arrival visit created, since visit start date for flight '||flt_dets_rec.flight_number||' is deriving to past.');

4510: FETCH get_flight_details INTO flt_dets_rec;
4511: CLOSE get_flight_details;
4512:
4513: -- Do not create a visit
4514: fnd_file.put_line(fnd_file.log, 'Validation Failure: No arrival visit created, since visit start date for flight '||flt_dets_rec.flight_number||' is deriving to past.');
4515: p_is_creation_success := 'N'; -- Flag as creation failed due to validations
4516:
4517: ELSE
4518: -- IF the visit org is NOT in current OU, do not create the visit

Line 4560: fnd_file.put_line(fnd_file.log, 'Validation Failure: Had problems with the MRs associated. So arrival visit creation for flight '||flt_dets_rec.flight_number||' is not successful.');

4556: OPEN get_flight_details(p_flight_schedule_rec.unit_schedule_id);
4557: FETCH get_flight_details INTO flt_dets_rec;
4558: CLOSE get_flight_details;
4559:
4560: fnd_file.put_line(fnd_file.log, 'Validation Failure: Had problems with the MRs associated. So arrival visit creation for flight '||flt_dets_rec.flight_number||' is not successful.');
4561: ELSE
4562: x_return_status := l_return_status ;
4563: x_msg_count := FND_MSG_PUB.count_msg;
4564: IF (l_log_statement >= l_log_current_level) THEN

Line 4581: fnd_file.put_line(fnd_file.log, 'Created arrival visit number -> '||l_visit_number);

4577: l_visit_number := NULL;
4578: OPEN get_visit_number(l_visit_rec.visit_id);
4579: FETCH get_visit_number INTO l_visit_number;
4580: CLOSE get_visit_number;
4581: fnd_file.put_line(fnd_file.log, 'Created arrival visit number -> '||l_visit_number);
4582: -- End of logging
4583: END IF;
4584: -- SATRAJEN :: Bug 14336467 :: Prevent Erroring out when the called from Operational Visit Procedure. :: END
4585: END IF; -- IF l_is_org_in_curr_OU = 'X'

Line 4764: fnd_file.put_line(fnd_file.log, 'Validation Failure: No downtime visit created, since visit start date for flight '||flt_dets_rec.flight_number||' is deriving to past');

4760: FETCH get_flight_details INTO flt_dets_rec;
4761: CLOSE get_flight_details;
4762:
4763: IF (l_start_date < p_present_time ) THEN
4764: fnd_file.put_line(fnd_file.log, 'Validation Failure: No downtime visit created, since visit start date for flight '||flt_dets_rec.flight_number||' is deriving to past');
4765: p_is_creation_success := 'N'; -- Flag as creation of visit failed due to validations
4766: END IF;
4767:
4768: -- SATRAJEN :: BUG 14475778 :: Checking the condition only if p_is_creation_success := Y from previous contidition :: 13-AUG-2012

Line 4772: fnd_file.put_line(fnd_file.log, 'Validation Failure: No downtime visit created, since duration of visit for flight '||flt_dets_rec.flight_number||' is lesser than visit type duration');

4768: -- SATRAJEN :: BUG 14475778 :: Checking the condition only if p_is_creation_success := Y from previous contidition :: 13-AUG-2012
4769: -- SATRAJEN :: BUG 14481051 :: Calculation prob in l_vst_type_est_dur :: 13-AUG-2012
4770: --IF (l_end_date - l_vst_type_est_dur) < l_start_date THEN
4771: IF ((p_is_creation_success<>'N') AND ((l_end_date - (l_vst_type_est_dur/24)) < l_start_date)) THEN
4772: fnd_file.put_line(fnd_file.log, 'Validation Failure: No downtime visit created, since duration of visit for flight '||flt_dets_rec.flight_number||' is lesser than visit type duration');
4773: p_is_creation_success := 'N'; -- Flag as creation of visit failed due to validations
4774: END IF;
4775:
4776: -- Bug 14336486 :: PRAKKUM :: 12/07/2012 :: END

Line 4844: fnd_file.put_line(fnd_file.log, 'Validation Failure: Had problems with the MRs associated. So downtime visit creation for flight '||flt_dets_rec.flight_number||' is not successful.');

4840: x_return_status := FND_API.G_RET_STS_SUCCESS;
4841: p_is_creation_success := 'N'; -- Flag as creation of visit failed due to validations
4842: -- Remove message from FND
4843: FND_MSG_PUB.Delete_Msg(p_msg_index => FND_MSG_PUB.count_msg);
4844: fnd_file.put_line(fnd_file.log, 'Validation Failure: Had problems with the MRs associated. So downtime visit creation for flight '||flt_dets_rec.flight_number||' is not successful.');
4845: ELSE
4846: x_return_status := l_return_status ;
4847: x_msg_count := FND_MSG_PUB.count_msg;
4848: IF (l_log_statement >= l_log_current_level) THEN

Line 4865: fnd_file.put_line(fnd_file.log, 'Created downtime visit number -> '||l_visit_number);

4861: l_visit_number := NULL;
4862: OPEN get_visit_number(l_visit_rec.visit_id);
4863: FETCH get_visit_number INTO l_visit_number;
4864: CLOSE get_visit_number;
4865: fnd_file.put_line(fnd_file.log, 'Created downtime visit number -> '||l_visit_number);
4866: -- End of logging
4867: END IF;
4868: -- SATRAJEN :: Bug 14336467 :: Prevent Erroring out when the called from Operational Visit Procedure. :: END
4869: END IF; -- IF l_is_org_in_curr_OU = 'X'

Line 5076: fnd_file.put_line(fnd_file.log, '*API input parameters**');

5072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5073: END IF;
5074:
5075: -- 2. Dump all input parameters
5076: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
5077: fnd_file.put_line(fnd_file.log, 'p_oper_flag -> '|| p_oper_flag);
5078: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
5079: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
5080: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);

Line 5077: fnd_file.put_line(fnd_file.log, 'p_oper_flag -> '|| p_oper_flag);

5073: END IF;
5074:
5075: -- 2. Dump all input parameters
5076: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
5077: fnd_file.put_line(fnd_file.log, 'p_oper_flag -> '|| p_oper_flag);
5078: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
5079: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
5080: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
5081: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());

Line 5078: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);

5074:
5075: -- 2. Dump all input parameters
5076: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
5077: fnd_file.put_line(fnd_file.log, 'p_oper_flag -> '|| p_oper_flag);
5078: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
5079: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
5080: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
5081: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
5082:

Line 5079: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);

5075: -- 2. Dump all input parameters
5076: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
5077: fnd_file.put_line(fnd_file.log, 'p_oper_flag -> '|| p_oper_flag);
5078: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
5079: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
5080: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
5081: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
5082:
5083:

Line 5080: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);

5076: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
5077: fnd_file.put_line(fnd_file.log, 'p_oper_flag -> '|| p_oper_flag);
5078: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
5079: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
5080: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
5081: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
5082:
5083:
5084: IF p_oper_flag = 'C' THEN

Line 5081: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());

5077: fnd_file.put_line(fnd_file.log, 'p_oper_flag -> '|| p_oper_flag);
5078: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
5079: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
5080: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
5081: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
5082:
5083:
5084: IF p_oper_flag = 'C' THEN
5085:

Line 5086: fnd_file.put_line(fnd_file.log, 'before calling Create_Oper_Visit');

5082:
5083:
5084: IF p_oper_flag = 'C' THEN
5085:
5086: fnd_file.put_line(fnd_file.log, 'before calling Create_Oper_Visit');
5087:
5088: Create_Oper_Visit (
5089: p_api_version => 1.0,
5090: p_init_msg_list => FND_API.G_FALSE,

Line 5100: fnd_file.put_line(fnd_file.log, 'Following error occured during the call to Create_Oper_Visit..');

5096: );
5097:
5098: l_msg_count := FND_MSG_PUB.Count_Msg;
5099: IF (l_msg_count > 0) THEN
5100: fnd_file.put_line(fnd_file.log, 'Following error occured during the call to Create_Oper_Visit..');
5101: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5102: RAISE FND_API.G_EXC_ERROR;
5103: ELSE
5104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5113: fnd_file.put_line(fnd_file.log, 'before calling Update_Oper_Visit');

5109:
5110:
5111: ELSIF p_oper_flag = 'U' THEN
5112:
5113: fnd_file.put_line(fnd_file.log, 'before calling Update_Oper_Visit');
5114:
5115: Update_Oper_Visit (
5116: p_api_version => 1.0,
5117: p_init_msg_list => FND_API.G_FALSE,

Line 5127: fnd_file.put_line(fnd_file.log, 'Following error occured during the call to Update_Oper_Visit..');

5123: );
5124:
5125: l_msg_count := FND_MSG_PUB.Count_Msg;
5126: IF (l_msg_count > 0) THEN
5127: fnd_file.put_line(fnd_file.log, 'Following error occured during the call to Update_Oper_Visit..');
5128: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5129: RAISE FND_API.G_EXC_ERROR;
5130: ELSE
5131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5150: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);

5146: p_encoded => FND_API.G_FALSE,
5147: p_data => l_err_msg,
5148: p_msg_index_out => l_msg_index_out);
5149:
5150: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
5151: END LOOP;
5152:
5153:
5154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5165: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);

5161: p_encoded => FND_API.G_FALSE,
5162: p_data => l_err_msg,
5163: p_msg_index_out => l_msg_index_out);
5164:
5165: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
5166: END LOOP;
5167:
5168:
5169: WHEN OTHERS THEN

Line 5185: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);

5181: p_encoded => FND_API.G_FALSE,
5182: p_data => l_err_msg,
5183: p_msg_index_out => l_msg_index_out);
5184:
5185: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
5186: END LOOP;
5187:
5188:
5189: END Process_Operational_visits;

Line 6025: fnd_file.put_line(fnd_file.log, 'Disconnected downtime visit number -> '||vst_details_rec.visit_number);

6021:
6022: IF vst_details_rec.visit_number IS NOT NULL THEN
6023: IF vst_details_rec.auto_flag IS NOT NULL THEN
6024: IF vst_details_rec.auto_flag = 'T' THEN
6025: fnd_file.put_line(fnd_file.log, 'Disconnected downtime visit number -> '||vst_details_rec.visit_number);
6026: ELSIF vst_details_rec.auto_flag = 'D' THEN
6027: fnd_file.put_line(fnd_file.log, 'Disconnected departure visit number -> '||vst_details_rec.visit_number);
6028: ELSIF vst_details_rec.auto_flag = 'A' THEN
6029: fnd_file.put_line(fnd_file.log, 'Disconnected arrival visit number -> '||vst_details_rec.visit_number);

Line 6027: fnd_file.put_line(fnd_file.log, 'Disconnected departure visit number -> '||vst_details_rec.visit_number);

6023: IF vst_details_rec.auto_flag IS NOT NULL THEN
6024: IF vst_details_rec.auto_flag = 'T' THEN
6025: fnd_file.put_line(fnd_file.log, 'Disconnected downtime visit number -> '||vst_details_rec.visit_number);
6026: ELSIF vst_details_rec.auto_flag = 'D' THEN
6027: fnd_file.put_line(fnd_file.log, 'Disconnected departure visit number -> '||vst_details_rec.visit_number);
6028: ELSIF vst_details_rec.auto_flag = 'A' THEN
6029: fnd_file.put_line(fnd_file.log, 'Disconnected arrival visit number -> '||vst_details_rec.visit_number);
6030: END IF;
6031: ELSE

Line 6029: fnd_file.put_line(fnd_file.log, 'Disconnected arrival visit number -> '||vst_details_rec.visit_number);

6025: fnd_file.put_line(fnd_file.log, 'Disconnected downtime visit number -> '||vst_details_rec.visit_number);
6026: ELSIF vst_details_rec.auto_flag = 'D' THEN
6027: fnd_file.put_line(fnd_file.log, 'Disconnected departure visit number -> '||vst_details_rec.visit_number);
6028: ELSIF vst_details_rec.auto_flag = 'A' THEN
6029: fnd_file.put_line(fnd_file.log, 'Disconnected arrival visit number -> '||vst_details_rec.visit_number);
6030: END IF;
6031: ELSE
6032: fnd_file.put_line(fnd_file.log, 'Disconnected visit number -> '||vst_details_rec.visit_number);
6033: END IF;

Line 6032: fnd_file.put_line(fnd_file.log, 'Disconnected visit number -> '||vst_details_rec.visit_number);

6028: ELSIF vst_details_rec.auto_flag = 'A' THEN
6029: fnd_file.put_line(fnd_file.log, 'Disconnected arrival visit number -> '||vst_details_rec.visit_number);
6030: END IF;
6031: ELSE
6032: fnd_file.put_line(fnd_file.log, 'Disconnected visit number -> '||vst_details_rec.visit_number);
6033: END IF;
6034: END IF;
6035: -- For Logging :: END
6036: