DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT dependencies on AHL_VWP_PROJ_PROD_PVT

Line 2656: l_tasks_tbl AHL_VWP_PROJ_PROD_PVT.Task_Tbl_Type;

2652: -- Kasridha: Changes for Bug#13739171 Ends
2653:
2654: --declare all local variables here
2655: --**********************************
2656: l_tasks_tbl AHL_VWP_PROJ_PROD_PVT.Task_Tbl_Type;
2657: l_visit_task_id NUMBER;
2658: l_create_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type;
2659: l_x_sr_mr_association_tbl AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type;
2660: l_move_item_ins_tbl AHL_PRD_PARTS_CHANGE_PVT.move_item_instance_tbl_type;--amsriniv ER 6014567

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

2909: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2910: fnd_log.string(
2911: fnd_log.level_statement,
2912: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2913: 'Before calling AHL_VWP_PROJ_PROD_PVT.Release_MR...'
2914: );
2915: END IF;
2916: -- FP for ER 5716489 -- start
2917: -- SKPATHAK :: Bug 8343599 :: 04-AUG-2009

Line 2927: AHL_VWP_PROJ_PROD_PVT.Release_MR(

2923:
2924: IF ( nvl(UPPER(p_x_task_tbl(i).WO_Release_flag), 'Y') = 'Y' )
2925: THEN
2926:
2927: AHL_VWP_PROJ_PROD_PVT.Release_MR(
2928: p_api_version => 1.0,
2929: p_init_msg_list => Fnd_Api.G_FALSE,
2930: p_commit => Fnd_Api.G_FALSE,
2931: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 2946: AHL_VWP_PROJ_PROD_PVT.Release_MR(

2942: p_firm_planned_flag => l_firm_planned_flag
2943: );
2944:
2945: ELSE
2946: AHL_VWP_PROJ_PROD_PVT.Release_MR(
2947: p_api_version => 1.0,
2948: p_init_msg_list => Fnd_Api.G_FALSE,
2949: p_commit => Fnd_Api.G_FALSE,
2950: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

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

2967: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2968: fnd_log.string(
2969: fnd_log.level_statement,
2970: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2971: 'After calling AHL_VWP_PROJ_PROD_PVT.Release_MR...Return status ->'||x_return_status
2972: );
2973: END IF;
2974:
2975: IF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN

Line 3086: 'After Calling AHL_VWP_PROJ_PROD_PVT.Move_To_InRepair_Locator.' ||

3082:
3083: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3084: fnd_log.string(fnd_log.level_statement,
3085: L_DEBUG_KEY,
3086: 'After Calling AHL_VWP_PROJ_PROD_PVT.Move_To_InRepair_Locator.' ||
3087: 'Return Status = ' || l_return_status );
3088: END IF;
3089: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3090: x_msg_count := l_msg_count;

Line 3168: l_create_job_task_tbl AHL_VWP_PROJ_PROD_PVT.Task_tbl_type;

3164: p_x_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,
3165: x_return_status OUT NOCOPY VARCHAR2
3166: ) IS
3167:
3168: l_create_job_task_tbl AHL_VWP_PROJ_PROD_PVT.Task_tbl_type;
3169: l_msg_count NUMBER;
3170: l_msg_data VARCHAR2(2000);
3171: l_org_task_id NUMBER;
3172: l_request_type VARCHAR2(60);

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

3325: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3326: fnd_log.string
3327: (l_debug_STMT,
3328: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3329: 'Before calling AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
3330: END IF;
3331:
3332: AHL_VWP_PROJ_PROD_PVT.Create_job_tasks(
3333: p_api_version => 1.0,

Line 3332: AHL_VWP_PROJ_PROD_PVT.Create_job_tasks(

3328: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3329: 'Before calling AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
3330: END IF;
3331:
3332: AHL_VWP_PROJ_PROD_PVT.Create_job_tasks(
3333: p_api_version => 1.0,
3334: p_init_msg_list => FND_API.G_TRUE,
3335: p_commit => FND_API.G_FALSE,
3336: p_validation_level => Fnd_API.G_VALID_LEVEL_FULL,

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

3340: x_msg_count => l_msg_count,
3341: x_msg_data => l_msg_data
3342: );
3343:
3344: -- AHL_VWP_PROJ_PROD_PVT.Create_job_tasks returns x_return_status as success
3345: -- even though visit validation fails. The validation errors are put in the
3346: -- error stack. In this case, the WO creation api will not be called and
3347: -- wo_id returned is null. Task is created.
3348:

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

3353: IF (l_debug_UEXP >= l_debug_LEVEL) THEN
3354: fnd_log.string
3355: (l_debug_UEXP,
3356: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3357: 'Error ' || x_return_status ||' returned from AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
3358: END IF;
3359:
3360: RAISE FND_API.G_EXC_ERROR;
3361: END IF;