APPS.AHL_PRD_NONROUTINE_PVT dependencies on AHL_VWP_PROJ_PROD_PVT

Line 2162: l_tasks_tbl AHL_VWP_PROJ_PROD_PVT.Task_Tbl_Type;

2158: --amsriniv ER 6014567 End
2159:
2160: --declare all local variables here
2161: --**********************************
2162: l_tasks_tbl AHL_VWP_PROJ_PROD_PVT.Task_Tbl_Type;
2163: l_visit_task_id NUMBER;
2164: l_create_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type;
2165: l_x_sr_mr_association_tbl AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type;
2166: l_move_item_ins_tbl AHL_PRD_PARTS_CHANGE_PVT.move_item_instance_tbl_type;--amsriniv ER 6014567

Line 2341: 'Before calling AHL_VWP_PROJ_PROD_PVT.Release_MR...'

2337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2338: fnd_log.string(
2339: fnd_log.level_statement,
2340: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2341: 'Before calling AHL_VWP_PROJ_PROD_PVT.Release_MR...'
2342: );
2343: END IF;
2344: --FP for ER 5716489 -- start
2345: IF ( nvl(UPPER(p_x_task_tbl(i).WO_Release_flag), 'Y') = 'Y' )

Line 2348: AHL_VWP_PROJ_PROD_PVT.Release_MR(

2344: --FP for ER 5716489 -- start
2345: IF ( nvl(UPPER(p_x_task_tbl(i).WO_Release_flag), 'Y') = 'Y' )
2346: THEN
2347:
2348: AHL_VWP_PROJ_PROD_PVT.Release_MR(
2349: p_api_version => 1.0,
2350: p_init_msg_list => Fnd_Api.G_FALSE,
2351: p_commit => Fnd_Api.G_FALSE,
2352: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 2364: AHL_VWP_PROJ_PROD_PVT.Release_MR(

2360: x_msg_data => x_msg_data
2361: );
2362:
2363: ELSE
2364: AHL_VWP_PROJ_PROD_PVT.Release_MR(
2365: p_api_version => 1.0,
2366: p_init_msg_list => Fnd_Api.G_FALSE,
2367: p_commit => Fnd_Api.G_FALSE,
2368: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 2386: 'After calling AHL_VWP_PROJ_PROD_PVT.Release_MR...Return status ->'||x_return_status

2382: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2383: fnd_log.string(
2384: fnd_log.level_statement,
2385: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2386: 'After calling AHL_VWP_PROJ_PROD_PVT.Release_MR...Return status ->'||x_return_status
2387: );
2388: END IF;
2389:
2390: IF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN

Line 2503: l_create_job_task_tbl AHL_VWP_PROJ_PROD_PVT.Task_tbl_type;

2499: p_x_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,
2500: x_return_status OUT NOCOPY VARCHAR2
2501: ) IS
2502:
2503: l_create_job_task_tbl AHL_VWP_PROJ_PROD_PVT.Task_tbl_type;
2504: l_msg_count NUMBER;
2505: l_msg_data VARCHAR2(2000);
2506: l_org_task_id NUMBER;
2507: l_request_type VARCHAR2(60);

Line 2664: 'Before calling AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');

2660: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2661: fnd_log.string
2662: (l_debug_STMT,
2663: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2664: 'Before calling AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
2665: END IF;
2666:
2667: AHL_VWP_PROJ_PROD_PVT.Create_job_tasks(
2668: p_api_version => 1.0,

Line 2667: AHL_VWP_PROJ_PROD_PVT.Create_job_tasks(

2663: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2664: 'Before calling AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
2665: END IF;
2666:
2667: AHL_VWP_PROJ_PROD_PVT.Create_job_tasks(
2668: p_api_version => 1.0,
2669: p_init_msg_list => FND_API.G_TRUE,
2670: p_commit => FND_API.G_FALSE,
2671: p_validation_level => Fnd_API.G_VALID_LEVEL_FULL,

Line 2679: -- AHL_VWP_PROJ_PROD_PVT.Create_job_tasks returns x_return_status as success

2675: x_msg_count => l_msg_count,
2676: x_msg_data => l_msg_data
2677: );
2678:
2679: -- AHL_VWP_PROJ_PROD_PVT.Create_job_tasks returns x_return_status as success
2680: -- even though visit validation fails. The validation errors are put in the
2681: -- error stack. In this case, the WO creation api will not be called and
2682: -- wo_id returned is null. Task is created.
2683:

Line 2692: 'Error ' || x_return_status ||' returned from AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');

2688: IF (l_debug_UEXP >= l_debug_LEVEL) THEN
2689: fnd_log.string
2690: (l_debug_UEXP,
2691: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2692: 'Error ' || x_return_status ||' returned from AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
2693: END IF;
2694:
2695: RAISE FND_API.G_EXC_ERROR;
2696: END IF;