2576: X_MSG_DATA => l_msg_data,
2577: P_UNIT_EFFECTIVITY_ID => l_delete_unit_effectivity_tbl(ue_count)
2578: );
2579:
2580: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2581: fnd_log.string
2582: (
2583: fnd_log.level_statement,
2584: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2577: P_UNIT_EFFECTIVITY_ID => l_delete_unit_effectivity_tbl(ue_count)
2578: );
2579:
2580: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2581: fnd_log.string
2582: (
2583: fnd_log.level_statement,
2584: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2585: 'After Calling ahl Ump Unplanned Pvt status : '|| l_return_status
2579:
2580: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2581: fnd_log.string
2582: (
2583: fnd_log.level_statement,
2584: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2585: 'After Calling ahl Ump Unplanned Pvt status : '|| l_return_status
2586: );
2587: END IF;
2618: x_msg_count => l_msg_count,
2619: x_msg_data => l_msg_data
2620: );
2621:
2622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2623: fnd_log.string
2624: (
2625: fnd_log.level_statement,
2626: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2619: x_msg_data => l_msg_data
2620: );
2621:
2622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2623: fnd_log.string
2624: (
2625: fnd_log.level_statement,
2626: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2627: 'After Calling ahl Vwp Visits stages Pvt status : '|| l_return_status
2621:
2622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2623: fnd_log.string
2624: (
2625: fnd_log.level_statement,
2626: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2627: 'After Calling ahl Vwp Visits stages Pvt status : '|| l_return_status
2628: );
2629: END IF;
3680: */
3681: IF l_primary_visit_id IS NOT NULL THEN
3682: l_visit_tbl(l_visit_count).visit_id := l_primary_visit_id;
3683: l_visit_tbl(l_visit_count).operation_flag := 'D';
3684: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3685: fnd_log.string
3686: (
3687: fnd_log.level_statement,
3688: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3681: IF l_primary_visit_id IS NOT NULL THEN
3682: l_visit_tbl(l_visit_count).visit_id := l_primary_visit_id;
3683: l_visit_tbl(l_visit_count).operation_flag := 'D';
3684: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3685: fnd_log.string
3686: (
3687: fnd_log.level_statement,
3688: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3689: 'Before Calling ahl Vwp Visits Pvt Process Visit Records : '|| l_visit_count
3683: l_visit_tbl(l_visit_count).operation_flag := 'D';
3684: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3685: fnd_log.string
3686: (
3687: fnd_log.level_statement,
3688: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3689: 'Before Calling ahl Vwp Visits Pvt Process Visit Records : '|| l_visit_count
3690: );
3691: END IF;
3701: x_msg_count => l_msg_count,
3702: x_msg_data => l_msg_data
3703: );
3704:
3705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3706: THEN
3707: fnd_log.string
3708: (
3709: fnd_log.level_statement,
3703: );
3704:
3705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3706: THEN
3707: fnd_log.string
3708: (
3709: fnd_log.level_statement,
3710: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3711: 'After Calling ahl Vwp Visits Pvt status : '|| l_return_status
3705: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3706: THEN
3707: fnd_log.string
3708: (
3709: fnd_log.level_statement,
3710: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3711: 'After Calling ahl Vwp Visits Pvt status : '|| l_return_status
3712: );
3713: END IF;
3820: l_prim_visit_rec.UNIT_SCHEDULE_ID := l_simul_visit_rec.UNIT_SCHEDULE_ID;
3821: l_prim_visit_rec.OPERATION_FLAG := 'U';
3822: l_prim_visit_tbl(0) := l_prim_visit_rec;
3823:
3824: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3825: fnd_log.string
3826: (
3827: fnd_log.level_statement,
3828: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3821: l_prim_visit_rec.OPERATION_FLAG := 'U';
3822: l_prim_visit_tbl(0) := l_prim_visit_rec;
3823:
3824: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3825: fnd_log.string
3826: (
3827: fnd_log.level_statement,
3828: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3829: 'Before Calling ahl Vwp Visits Pvt Process Visit Records for visit : '|| l_primary_visit_id
3823:
3824: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3825: fnd_log.string
3826: (
3827: fnd_log.level_statement,
3828: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3829: 'Before Calling ahl Vwp Visits Pvt Process Visit Records for visit : '|| l_primary_visit_id
3830: );
3831:
3843: x_msg_count => l_msg_count,
3844: x_msg_data => l_msg_data
3845: );
3846:
3847: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3848: fnd_log.string
3849: (
3850: fnd_log.level_statement,
3851: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3844: x_msg_data => l_msg_data
3845: );
3846:
3847: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3848: fnd_log.string
3849: (
3850: fnd_log.level_statement,
3851: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3852: 'After Calling ahl Vwp Visits Pvt status : '|| l_return_status
3846:
3847: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3848: fnd_log.string
3849: (
3850: fnd_log.level_statement,
3851: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3852: 'After Calling ahl Vwp Visits Pvt status : '|| l_return_status
3853: );
3854:
4443: x_msg_data => l_msg_data,
4444: p_visit_id => l_primary_visit_id
4445: );
4446:
4447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4448: fnd_log.string
4449: (
4450: fnd_log.level_statement,
4451: 'ahl.plsql.'||L_FULL_NAME,
4444: p_visit_id => l_primary_visit_id
4445: );
4446:
4447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4448: fnd_log.string
4449: (
4450: fnd_log.level_statement,
4451: 'ahl.plsql.'||L_FULL_NAME,
4452: 'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times'
4446:
4447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4448: fnd_log.string
4449: (
4450: fnd_log.level_statement,
4451: 'ahl.plsql.'||L_FULL_NAME,
4452: 'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times'
4453: );
4454: END IF;
4485: x_return_status => l_return_status,
4486: x_msg_count => l_msg_count,
4487: x_msg_data => l_msg_data
4488: );
4489: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4490: fnd_log.string
4491: (
4492: fnd_log.level_statement,
4493: 'ahl.plsql.'||L_FULL_NAME,
4486: x_msg_count => l_msg_count,
4487: x_msg_data => l_msg_data
4488: );
4489: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4490: fnd_log.string
4491: (
4492: fnd_log.level_statement,
4493: 'ahl.plsql.'||L_FULL_NAME,
4494: ' After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials With p_operation_flag U '
4488: );
4489: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4490: fnd_log.string
4491: (
4492: fnd_log.level_statement,
4493: 'ahl.plsql.'||L_FULL_NAME,
4494: ' After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials With p_operation_flag U '
4495: );
4496: END IF;
4510: x_return_status => l_return_status,
4511: x_msg_count => l_msg_count,
4512: x_msg_data => l_msg_data
4513: );
4514: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4515: fnd_log.string
4516: (
4517: fnd_log.level_statement,
4518: 'ahl.plsql.'||L_FULL_NAME,
4511: x_msg_count => l_msg_count,
4512: x_msg_data => l_msg_data
4513: );
4514: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4515: fnd_log.string
4516: (
4517: fnd_log.level_statement,
4518: 'ahl.plsql.'||L_FULL_NAME,
4519: ' After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials With p_operation_flag D '
4513: );
4514: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4515: fnd_log.string
4516: (
4517: fnd_log.level_statement,
4518: 'ahl.plsql.'||L_FULL_NAME,
4519: ' After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials With p_operation_flag D '
4520: );
4521: END IF;