DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on FND_FILE

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

11826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11827: END IF;
11828:
11829: -- 2. Dump all input parameters
11830: fnd_file.put_line(fnd_file.log, '************* Synch_Wo_Projtask_Times : API input parameters**************');
11831: fnd_file.put_line(fnd_file.log, 'p_visit_id -> '|| p_visit_id);
11832: fnd_file.put_line(fnd_file.log, 'p_organization_id -> '||p_organization_id);
11833: fnd_file.put_line(fnd_file.log, 'p_department_id -> '|| p_department_id);
11834: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);

Line 11831: fnd_file.put_line(fnd_file.log, 'p_visit_id -> '|| p_visit_id);

11827: END IF;
11828:
11829: -- 2. Dump all input parameters
11830: fnd_file.put_line(fnd_file.log, '************* Synch_Wo_Projtask_Times : API input parameters**************');
11831: fnd_file.put_line(fnd_file.log, 'p_visit_id -> '|| p_visit_id);
11832: fnd_file.put_line(fnd_file.log, 'p_organization_id -> '||p_organization_id);
11833: fnd_file.put_line(fnd_file.log, 'p_department_id -> '|| p_department_id);
11834: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
11835: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);

Line 11832: fnd_file.put_line(fnd_file.log, 'p_organization_id -> '||p_organization_id);

11828:
11829: -- 2. Dump all input parameters
11830: fnd_file.put_line(fnd_file.log, '************* Synch_Wo_Projtask_Times : API input parameters**************');
11831: fnd_file.put_line(fnd_file.log, 'p_visit_id -> '|| p_visit_id);
11832: fnd_file.put_line(fnd_file.log, 'p_organization_id -> '||p_organization_id);
11833: fnd_file.put_line(fnd_file.log, 'p_department_id -> '|| p_department_id);
11834: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
11835: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
11836: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);

Line 11833: fnd_file.put_line(fnd_file.log, 'p_department_id -> '|| p_department_id);

11829: -- 2. Dump all input parameters
11830: fnd_file.put_line(fnd_file.log, '************* Synch_Wo_Projtask_Times : API input parameters**************');
11831: fnd_file.put_line(fnd_file.log, 'p_visit_id -> '|| p_visit_id);
11832: fnd_file.put_line(fnd_file.log, 'p_organization_id -> '||p_organization_id);
11833: fnd_file.put_line(fnd_file.log, 'p_department_id -> '|| p_department_id);
11834: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
11835: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
11836: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
11837: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());

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

11830: fnd_file.put_line(fnd_file.log, '************* Synch_Wo_Projtask_Times : API input parameters**************');
11831: fnd_file.put_line(fnd_file.log, 'p_visit_id -> '|| p_visit_id);
11832: fnd_file.put_line(fnd_file.log, 'p_organization_id -> '||p_organization_id);
11833: fnd_file.put_line(fnd_file.log, 'p_department_id -> '|| p_department_id);
11834: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
11835: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
11836: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
11837: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
11838:

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

11831: fnd_file.put_line(fnd_file.log, 'p_visit_id -> '|| p_visit_id);
11832: fnd_file.put_line(fnd_file.log, 'p_organization_id -> '||p_organization_id);
11833: fnd_file.put_line(fnd_file.log, 'p_department_id -> '|| p_department_id);
11834: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
11835: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
11836: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
11837: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
11838:
11839: l_wo_count := 0;

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

11832: fnd_file.put_line(fnd_file.log, 'p_organization_id -> '||p_organization_id);
11833: fnd_file.put_line(fnd_file.log, 'p_department_id -> '|| p_department_id);
11834: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
11835: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
11836: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
11837: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
11838:
11839: l_wo_count := 0;
11840:

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

11833: fnd_file.put_line(fnd_file.log, 'p_department_id -> '|| p_department_id);
11834: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
11835: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
11836: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
11837: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
11838:
11839: l_wo_count := 0;
11840:
11841: -- 3. Only visit number is passed

Line 11855: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');

11851: l_prd_workorder_tbl(l_wo_count).visit_task_id := c_wo_rec.visit_task_id;
11852: l_wo_count := l_wo_count + 1;
11853: END LOOP;
11854:
11855: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');
11856: fnd_file.put_line(fnd_file.log, 'visit_id -> '||p_visit_id);
11857: fnd_file.put_line(fnd_file.log, 'total no of work orders -> '||l_prd_workorder_tbl.count);
11858:
11859: -- 7. Call AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times to synchronize work order

Line 11856: fnd_file.put_line(fnd_file.log, 'visit_id -> '||p_visit_id);

11852: l_wo_count := l_wo_count + 1;
11853: END LOOP;
11854:
11855: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');
11856: fnd_file.put_line(fnd_file.log, 'visit_id -> '||p_visit_id);
11857: fnd_file.put_line(fnd_file.log, 'total no of work orders -> '||l_prd_workorder_tbl.count);
11858:
11859: -- 7. Call AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times to synchronize work order
11860: -- schedule times with project taks times.

Line 11857: fnd_file.put_line(fnd_file.log, 'total no of work orders -> '||l_prd_workorder_tbl.count);

11853: END LOOP;
11854:
11855: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');
11856: fnd_file.put_line(fnd_file.log, 'visit_id -> '||p_visit_id);
11857: fnd_file.put_line(fnd_file.log, 'total no of work orders -> '||l_prd_workorder_tbl.count);
11858:
11859: -- 7. Call AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times to synchronize work order
11860: -- schedule times with project taks times.
11861: -- fnd_file.put_line(fnd_file.log,'HERE GOES THE CALL TO API AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');

Line 11861: -- fnd_file.put_line(fnd_file.log,'HERE GOES THE CALL TO API AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');

11857: fnd_file.put_line(fnd_file.log, 'total no of work orders -> '||l_prd_workorder_tbl.count);
11858:
11859: -- 7. Call AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times to synchronize work order
11860: -- schedule times with project taks times.
11861: -- fnd_file.put_line(fnd_file.log,'HERE GOES THE CALL TO API AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');
11862: AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times(
11863: p_prd_workorder_tbl => l_prd_workorder_tbl,
11864: p_commit => Fnd_Api.G_TRUE,
11865: x_return_status => l_return_status,

Line 11872: fnd_file.put_line(fnd_file.log, 'Following error occured while synchronizing task times..');

11868: );
11869:
11870: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11871:
11872: fnd_file.put_line(fnd_file.log, 'Following error occured while synchronizing task times..');
11873:
11874: retcode := 2; -- error!!
11875:
11876: LOOP

Line 11882: fnd_file.put_line(fnd_file.log, l_err_msg);

11878: IF l_err_msg IS NULL
11879: THEN
11880: EXIT;
11881: END IF;
11882: fnd_file.put_line(fnd_file.log, l_err_msg);
11883: END LOOP;
11884:
11885: END IF;
11886:

Line 11906: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');

11902: l_prd_workorder_tbl(l_wo_count).visit_task_id := c_wo_rec.visit_task_id;
11903: l_wo_count := l_wo_count + 1;
11904: END LOOP;
11905:
11906: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');
11907: fnd_file.put_line(fnd_file.log, 'visit_id -> '||c_visit_rec.visit_id);
11908: fnd_file.put_line(fnd_file.log, 'total no of work orders -> '||l_prd_workorder_tbl.count);
11909:
11910: -- 7. Call AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times to synchronize work order

Line 11907: fnd_file.put_line(fnd_file.log, 'visit_id -> '||c_visit_rec.visit_id);

11903: l_wo_count := l_wo_count + 1;
11904: END LOOP;
11905:
11906: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');
11907: fnd_file.put_line(fnd_file.log, 'visit_id -> '||c_visit_rec.visit_id);
11908: fnd_file.put_line(fnd_file.log, 'total no of work orders -> '||l_prd_workorder_tbl.count);
11909:
11910: -- 7. Call AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times to synchronize work order
11911: -- schedule times with project taks times.

Line 11908: fnd_file.put_line(fnd_file.log, 'total no of work orders -> '||l_prd_workorder_tbl.count);

11904: END LOOP;
11905:
11906: fnd_file.put_line(fnd_file.log, 'before calling AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');
11907: fnd_file.put_line(fnd_file.log, 'visit_id -> '||c_visit_rec.visit_id);
11908: fnd_file.put_line(fnd_file.log, 'total no of work orders -> '||l_prd_workorder_tbl.count);
11909:
11910: -- 7. Call AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times to synchronize work order
11911: -- schedule times with project taks times.
11912: -- fnd_file.put_line(fnd_file.log,'HERE GOES THE CALL TO API AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');

Line 11912: -- fnd_file.put_line(fnd_file.log,'HERE GOES THE CALL TO API AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');

11908: fnd_file.put_line(fnd_file.log, 'total no of work orders -> '||l_prd_workorder_tbl.count);
11909:
11910: -- 7. Call AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times to synchronize work order
11911: -- schedule times with project taks times.
11912: -- fnd_file.put_line(fnd_file.log,'HERE GOES THE CALL TO API AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times');
11913: AHL_VWP_PROJ_PROD_PVT.Update_Project_Task_Times(
11914: p_prd_workorder_tbl => l_prd_workorder_tbl,
11915: p_commit => Fnd_Api.G_TRUE,
11916: x_return_status => l_return_status,

Line 11923: fnd_file.put_line(fnd_file.log, 'Following error occured while synchronizing task times..');

11919: );
11920:
11921: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11922:
11923: fnd_file.put_line(fnd_file.log, 'Following error occured while synchronizing task times..');
11924:
11925: retcode := 2; -- error!!
11926:
11927: LOOP

Line 11933: fnd_file.put_line(fnd_file.log, l_err_msg);

11929: IF l_err_msg IS NULL
11930: THEN
11931: EXIT;
11932: END IF;
11933: fnd_file.put_line(fnd_file.log, l_err_msg);
11934: END LOOP;
11935:
11936: END IF;
11937: