DBA Data[Home] [Help]

APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on FND_FILE

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

3839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3840: END IF;
3841:
3842: -- 2. Dump all input parameters
3843: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
3844: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
3845: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
3846: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
3847: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);

Line 3844: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);

3840: END IF;
3841:
3842: -- 2. Dump all input parameters
3843: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
3844: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
3845: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
3846: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
3847: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
3848: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());

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

3841:
3842: -- 2. Dump all input parameters
3843: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
3844: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
3845: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
3846: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
3847: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
3848: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
3849:

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

3842: -- 2. Dump all input parameters
3843: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
3844: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
3845: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
3846: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
3847: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
3848: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
3849:
3850: SELECT visit_id INTO l_cost_price_rec.visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;

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

3843: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
3844: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
3845: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
3846: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
3847: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
3848: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
3849:
3850: SELECT visit_id INTO l_cost_price_rec.visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;
3851:

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

3844: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
3845: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
3846: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
3847: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
3848: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
3849:
3850: SELECT visit_id INTO l_cost_price_rec.visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;
3851:
3852: IF l_cost_price_rec.visit_id IS NOT NULL THEN

Line 3853: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost');

3849:
3850: SELECT visit_id INTO l_cost_price_rec.visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;
3851:
3852: IF l_cost_price_rec.visit_id IS NOT NULL THEN
3853: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost');
3854: fnd_file.put_line(fnd_file.log, 'visit_id -> '||l_cost_price_rec.visit_id);
3855:
3856: estimate_visit_cost(
3857: p_api_version => 1.0,

Line 3854: fnd_file.put_line(fnd_file.log, 'visit_id -> '||l_cost_price_rec.visit_id);

3850: SELECT visit_id INTO l_cost_price_rec.visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;
3851:
3852: IF l_cost_price_rec.visit_id IS NOT NULL THEN
3853: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost');
3854: fnd_file.put_line(fnd_file.log, 'visit_id -> '||l_cost_price_rec.visit_id);
3855:
3856: estimate_visit_cost(
3857: p_api_version => 1.0,
3858: p_init_msg_list => FND_API.G_TRUE,

Line 3869: fnd_file.put_line(fnd_file.log, 'Following error occured while estimating visit cost.');

3865: x_msg_data => l_msg_data);
3866:
3867: l_msg_count := FND_MSG_PUB.Count_Msg;
3868: IF (l_msg_count > 0) THEN
3869: fnd_file.put_line(fnd_file.log, 'Following error occured while estimating visit cost.');
3870: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3871: RAISE FND_API.G_EXC_ERROR;
3872: ELSE
3873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3885: p_encoded => FND_API.G_FALSE,
3886: p_data => l_err_msg,
3887: p_msg_index_out => l_msg_index_out);
3888:
3889: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
3890: END LOOP;
3891:
3892:
3893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3900: p_encoded => FND_API.G_FALSE,
3901: p_data => l_err_msg,
3902: p_msg_index_out => l_msg_index_out);
3903:
3904: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
3905: END LOOP;
3906:
3907:
3908: WHEN OTHERS THEN

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

3920: p_encoded => FND_API.G_FALSE,
3921: p_data => l_err_msg,
3922: p_msg_index_out => l_msg_index_out);
3923:
3924: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
3925: END LOOP;
3926:
3927:
3928: END bg_exec_estimate_visit_cost;