DBA Data[Home] [Help]

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on FND_FILE

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

761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END IF;
763:
764: -- 2. Dump all input parameters
765: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
766: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
767: fnd_file.put_line(fnd_file.log, 'p_caller -> '|| p_caller);
768: fnd_file.put_line(fnd_file.log, 'p_release_flag -> '||p_release_flag);
769: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);

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

762: END IF;
763:
764: -- 2. Dump all input parameters
765: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
766: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
767: fnd_file.put_line(fnd_file.log, 'p_caller -> '|| p_caller);
768: fnd_file.put_line(fnd_file.log, 'p_release_flag -> '||p_release_flag);
769: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
770: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);

Line 767: fnd_file.put_line(fnd_file.log, 'p_caller -> '|| p_caller);

763:
764: -- 2. Dump all input parameters
765: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
766: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
767: fnd_file.put_line(fnd_file.log, 'p_caller -> '|| p_caller);
768: fnd_file.put_line(fnd_file.log, 'p_release_flag -> '||p_release_flag);
769: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
770: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
771: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);

Line 768: fnd_file.put_line(fnd_file.log, 'p_release_flag -> '||p_release_flag);

764: -- 2. Dump all input parameters
765: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
766: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
767: fnd_file.put_line(fnd_file.log, 'p_caller -> '|| p_caller);
768: fnd_file.put_line(fnd_file.log, 'p_release_flag -> '||p_release_flag);
769: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
770: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
771: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
772: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());

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

765: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
766: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
767: fnd_file.put_line(fnd_file.log, 'p_caller -> '|| p_caller);
768: fnd_file.put_line(fnd_file.log, 'p_release_flag -> '||p_release_flag);
769: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
770: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
771: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
772: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
773:

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

766: fnd_file.put_line(fnd_file.log, 'p_visit_number -> '|| p_visit_number);
767: fnd_file.put_line(fnd_file.log, 'p_caller -> '|| p_caller);
768: fnd_file.put_line(fnd_file.log, 'p_release_flag -> '||p_release_flag);
769: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
770: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
771: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
772: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
773:
774: SELECT visit_id INTO l_visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;

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

767: fnd_file.put_line(fnd_file.log, 'p_caller -> '|| p_caller);
768: fnd_file.put_line(fnd_file.log, 'p_release_flag -> '||p_release_flag);
769: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
770: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
771: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
772: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
773:
774: SELECT visit_id INTO l_visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;
775:

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

768: fnd_file.put_line(fnd_file.log, 'p_release_flag -> '||p_release_flag);
769: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
770: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
771: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
772: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
773:
774: SELECT visit_id INTO l_visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;
775:
776: IF l_visit_id IS NOT NULL THEN

Line 778: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Release_visit');

774: SELECT visit_id INTO l_visit_id FROM AHL_VISITS_B WHERE visit_number = p_visit_number;
775:
776: IF l_visit_id IS NOT NULL THEN
777:
778: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Release_visit');
779: fnd_file.put_line(fnd_file.log, 'visit_id -> '||l_visit_id);
780:
781:
782: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063

Line 779: fnd_file.put_line(fnd_file.log, 'visit_id -> '||l_visit_id);

775:
776: IF l_visit_id IS NOT NULL THEN
777:
778: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Release_visit');
779: fnd_file.put_line(fnd_file.log, 'visit_id -> '||l_visit_id);
780:
781:
782: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063
783: --If the caller if 'FORMS' or 'JAVA', then the request has been launched for Plan_Visit else for P2P

Line 798: fnd_file.put_line(fnd_file.log, 'Following error occured while plan visit..');

794: x_msg_data => l_msg_data);
795:
796: l_msg_count := FND_MSG_PUB.Count_Msg;
797: IF (l_msg_count > 0) THEN
798: fnd_file.put_line(fnd_file.log, 'Following error occured while plan visit..');
799: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
800: RAISE FND_API.G_EXC_ERROR;
801: ELSE
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 817: fnd_file.put_line(fnd_file.log, 'Following error occured while pushing the visit to production..');

813: x_msg_data => l_msg_data);
814:
815: l_msg_count := FND_MSG_PUB.Count_Msg;
816: IF (l_msg_count > 0) THEN
817: fnd_file.put_line(fnd_file.log, 'Following error occured while pushing the visit to production..');
818: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
819: RAISE FND_API.G_EXC_ERROR;
820: ELSE
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

834: p_encoded => FND_API.G_FALSE,
835: p_data => l_err_msg,
836: p_msg_index_out => l_msg_index_out);
837:
838: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
839: END LOOP;
840:
841:
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

849: p_encoded => FND_API.G_FALSE,
850: p_data => l_err_msg,
851: p_msg_index_out => l_msg_index_out);
852:
853: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
854: END LOOP;
855:
856:
857: WHEN OTHERS THEN

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

869: p_encoded => FND_API.G_FALSE,
870: p_data => l_err_msg,
871: p_msg_index_out => l_msg_index_out);
872:
873: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_err_msg);
874: END LOOP;
875:
876:
877: END BG_Push_to_Production;