eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_COMPLETIONS_PVT dependencies on AHL_DEBUG_PUB

Line 5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

1: PACKAGE BODY AHL_COMPLETIONS_PVT AS
2: /* $Header: AHLVPRCB.pls 120.45.12010000.4 2009/01/09 22:28:16 sikumar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_COMPLETIONS_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: -- Operation Statuses
8: G_OP_STATUS_UNCOMPLETE VARCHAR2(2) := '2'; --Uncomplete
9: G_OP_STATUS_COMPLETE VARCHAR2(2) := '1'; --Complete

Line 1120: AHL_DEBUG_PUB.debug( 'before validating actual dates for wo_op_id->'||p_operation_rec.workorder_operation_id);

1116: -- rroy
1117: -- ACL Changes
1118:
1119: IF ( G_DEBUG = 'Y' ) THEN
1120: AHL_DEBUG_PUB.debug( 'before validating actual dates for wo_op_id->'||p_operation_rec.workorder_operation_id);
1121: AHL_DEBUG_PUB.debug( 'p_operation_rec.actual_start_date->'||TO_CHAR(p_operation_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1122: AHL_DEBUG_PUB.debug( 'p_operation_rec.actual_end_date->'||TO_CHAR(p_operation_rec.actual_end_date,'DD-MON-YYYY HH24:MI:SS'));
1123: END IF;
1124:

Line 1121: AHL_DEBUG_PUB.debug( 'p_operation_rec.actual_start_date->'||TO_CHAR(p_operation_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));

1117: -- ACL Changes
1118:
1119: IF ( G_DEBUG = 'Y' ) THEN
1120: AHL_DEBUG_PUB.debug( 'before validating actual dates for wo_op_id->'||p_operation_rec.workorder_operation_id);
1121: AHL_DEBUG_PUB.debug( 'p_operation_rec.actual_start_date->'||TO_CHAR(p_operation_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1122: AHL_DEBUG_PUB.debug( 'p_operation_rec.actual_end_date->'||TO_CHAR(p_operation_rec.actual_end_date,'DD-MON-YYYY HH24:MI:SS'));
1123: END IF;
1124:
1125: IF (NVL(p_validate_date, FND_API.G_TRUE) = FND_API.G_TRUE) THEN

Line 1122: AHL_DEBUG_PUB.debug( 'p_operation_rec.actual_end_date->'||TO_CHAR(p_operation_rec.actual_end_date,'DD-MON-YYYY HH24:MI:SS'));

1118:
1119: IF ( G_DEBUG = 'Y' ) THEN
1120: AHL_DEBUG_PUB.debug( 'before validating actual dates for wo_op_id->'||p_operation_rec.workorder_operation_id);
1121: AHL_DEBUG_PUB.debug( 'p_operation_rec.actual_start_date->'||TO_CHAR(p_operation_rec.actual_start_date,'DD-MON-YYYY HH24:MI:SS'));
1122: AHL_DEBUG_PUB.debug( 'p_operation_rec.actual_end_date->'||TO_CHAR(p_operation_rec.actual_end_date,'DD-MON-YYYY HH24:MI:SS'));
1123: END IF;
1124:
1125: IF (NVL(p_validate_date, FND_API.G_TRUE) = FND_API.G_TRUE) THEN
1126: l_return_status :=

Line 2379: AHL_DEBUG_PUB.debug( 'Ctr ID:' || TO_CHAR( l_ctr_rdg_tbl(l_ctr_count).counter_id ) || ' Reset Value :' || TO_CHAR( l_ctr_rdg_tbl(l_ctr_count).counter_reading ) );

2375: l_ctr_rdg_tbl(l_ctr_count).valid_flag := 'Y';
2376: l_ctr_rdg_tbl(l_ctr_count).override_valid_flag := 'N';
2377:
2378: IF ( G_DEBUG = 'Y' ) THEN
2379: AHL_DEBUG_PUB.debug( 'Ctr ID:' || TO_CHAR( l_ctr_rdg_tbl(l_ctr_count).counter_id ) || ' Reset Value :' || TO_CHAR( l_ctr_rdg_tbl(l_ctr_count).counter_reading ) );
2380: END IF;
2381:
2382: IF ( p_x_counter_tbl(i).counter_reading <> 0 ) THEN
2383: l_ctr_rdg_tbl(l_ctr_count).reset_flag := 'Y';

Line 2396: AHL_DEBUG_PUB.debug( 'Reset Ctr ID:' || TO_CHAR( l_ctr_rdg_tbl(l_ctr_count).counter_id ) || ' Pre-Reset:' || TO_CHAR( l_ctr_rdg_tbl(l_ctr_count).pre_reset_last_rdg ) || ' Adj:' || TO_CHAR( l_ctr_rdg_tbl(l_ctr_count).misc_reading ) );

2392: l_ctr_rdg_tbl(l_ctr_count).pre_reset_last_rdg := p_x_counter_tbl(i).reset_value;
2393: l_ctr_rdg_tbl(l_ctr_count).post_reset_first_rdg := p_x_counter_tbl(i).reset_value;
2394: /* end of fix -- IB(Anju) suggested as part of fix for bug#6267502 */
2395: IF ( G_DEBUG = 'Y' ) THEN
2396: AHL_DEBUG_PUB.debug( 'Reset Ctr ID:' || TO_CHAR( l_ctr_rdg_tbl(l_ctr_count).counter_id ) || ' Pre-Reset:' || TO_CHAR( l_ctr_rdg_tbl(l_ctr_count).pre_reset_last_rdg ) || ' Adj:' || TO_CHAR( l_ctr_rdg_tbl(l_ctr_count).misc_reading ) );
2397: END IF;
2398: END IF;
2399:
2400: -- Store the Reset Value as the Current Reading ( for UMP )

Line 2751: AHL_DEBUG_PUB.enable_debug;

2747:
2748: BEGIN
2749: -- Enable Debug (optional)
2750: IF ( G_DEBUG = 'Y' ) THEN
2751: AHL_DEBUG_PUB.enable_debug;
2752: END IF;
2753:
2754: -- Initialize API return status to success
2755: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2982: AHL_DEBUG_PUB.disable_debug;

2978: END IF;
2979:
2980: -- Disable debug (if enabled)
2981: IF ( G_DEBUG = 'Y' ) THEN
2982: AHL_DEBUG_PUB.disable_debug;
2983: END IF;
2984:
2985: EXCEPTION
2986:

Line 2998: AHL_DEBUG_PUB.disable_debug;

2994: p_data => x_msg_data
2995: );
2996:
2997: IF ( G_DEBUG = 'Y' ) THEN
2998: AHL_DEBUG_PUB.disable_debug;
2999: END IF;
3000:
3001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3002: ROLLBACK TO complete_operation_PVT;

Line 3012: AHL_DEBUG_PUB.disable_debug;

3008: p_data => x_msg_data
3009: );
3010:
3011: IF ( G_DEBUG = 'Y' ) THEN
3012: AHL_DEBUG_PUB.disable_debug;
3013: END IF;
3014:
3015: WHEN OTHERS THEN
3016: ROLLBACK TO complete_operation_PVT;

Line 3035: AHL_DEBUG_PUB.disable_debug;

3031: p_data => x_msg_data
3032: );
3033:
3034: IF ( G_DEBUG = 'Y' ) THEN
3035: AHL_DEBUG_PUB.disable_debug;
3036: END IF;
3037: END complete_operation;
3038:
3039: PROCEDURE complete_workorder

Line 3171: AHL_DEBUG_PUB.enable_debug;

3167:
3168: BEGIN
3169: -- Enable Debug (optional)
3170: IF ( G_DEBUG = 'Y' ) THEN
3171: AHL_DEBUG_PUB.enable_debug;
3172: END IF;
3173:
3174: -- Initialize API return status to success
3175: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3574: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Could Not Complete MR Instance with UE : ' || TO_CHAR( l_workorder_rec.unit_effectivity_id ) || ' associated to Workorder : ' || TO_CHAR( p_workorder_id ) || ' because of...' );

3570:
3571: -- Abort for Unexpected errors, but, continue for other errors.
3572: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
3573: IF ( G_DEBUG = 'Y' ) THEN
3574: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Could Not Complete MR Instance with UE : ' || TO_CHAR( l_workorder_rec.unit_effectivity_id ) || ' associated to Workorder : ' || TO_CHAR( p_workorder_id ) || ' because of...' );
3575: FOR I IN 1..l_msg_count LOOP
3576: FND_MSG_PUB.get
3577: (
3578: p_msg_index => i,

Line 3584: AHL_DEBUG_PUB.debug(' Error : ' || I || ': ' || l_msg_data);

3580: p_data => l_msg_data,
3581: p_msg_index_out => l_msg_index_out
3582: );
3583:
3584: AHL_DEBUG_PUB.debug(' Error : ' || I || ': ' || l_msg_data);
3585: END LOOP;
3586: END IF;
3587:
3588: -- Initialize message list since errors are not reported

Line 3600: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Completed MR Instance with UE : ' || TO_CHAR( l_workorder_rec.unit_effectivity_id ) || ' associated to Workorder : ' || TO_CHAR( p_workorder_id ) || ' Successfuly...' );

3596: x_msg_count := l_msg_count;
3597: RETURN;
3598: ELSE
3599: IF ( G_DEBUG = 'Y' ) THEN
3600: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Completed MR Instance with UE : ' || TO_CHAR( l_workorder_rec.unit_effectivity_id ) || ' associated to Workorder : ' || TO_CHAR( p_workorder_id ) || ' Successfuly...' );
3601: END IF;
3602:
3603: -- Re-set the API savepoint because, complete_mr_instance commits
3604: IF FND_API.to_boolean( p_commit ) THEN

Line 3620: AHL_DEBUG_PUB.disable_debug;

3616: END IF;
3617:
3618: -- Disable debug (if enabled)
3619: IF ( G_DEBUG = 'Y' ) THEN
3620: AHL_DEBUG_PUB.disable_debug;
3621: END IF;
3622:
3623: EXCEPTION
3624:

Line 3636: AHL_DEBUG_PUB.disable_debug;

3632: p_data => x_msg_data
3633: );
3634:
3635: IF ( G_DEBUG = 'Y' ) THEN
3636: AHL_DEBUG_PUB.disable_debug;
3637: END IF;
3638:
3639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3640: ROLLBACK TO complete_workorder_PVT;

Line 3650: AHL_DEBUG_PUB.disable_debug;

3646: p_data => x_msg_data
3647: );
3648:
3649: IF ( G_DEBUG = 'Y' ) THEN
3650: AHL_DEBUG_PUB.disable_debug;
3651: END IF;
3652:
3653: WHEN OTHERS THEN
3654: ROLLBACK TO complete_workorder_PVT;

Line 3673: AHL_DEBUG_PUB.disable_debug;

3669: p_data => x_msg_data
3670: );
3671:
3672: IF ( G_DEBUG = 'Y' ) THEN
3673: AHL_DEBUG_PUB.disable_debug;
3674: END IF;
3675: END complete_workorder;
3676:
3677: PROCEDURE defer_workorder

Line 3704: AHL_DEBUG_PUB.enable_debug;

3700:
3701: BEGIN
3702: -- Enable Debug (optional)
3703: IF ( G_DEBUG = 'Y' ) THEN
3704: AHL_DEBUG_PUB.enable_debug;
3705: END IF;
3706:
3707: -- Initialize API return status to success
3708: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3869: AHL_DEBUG_PUB.disable_debug;

3865: END IF;
3866:
3867: -- Disable debug (if enabled)
3868: IF ( G_DEBUG = 'Y' ) THEN
3869: AHL_DEBUG_PUB.disable_debug;
3870: END IF;
3871:
3872: EXCEPTION
3873:

Line 3885: AHL_DEBUG_PUB.disable_debug;

3881: p_data => x_msg_data
3882: );
3883:
3884: IF ( G_DEBUG = 'Y' ) THEN
3885: AHL_DEBUG_PUB.disable_debug;
3886: END IF;
3887:
3888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3889: ROLLBACK TO defer_workorder_PVT;

Line 3899: AHL_DEBUG_PUB.disable_debug;

3895: p_data => x_msg_data
3896: );
3897:
3898: IF ( G_DEBUG = 'Y' ) THEN
3899: AHL_DEBUG_PUB.disable_debug;
3900: END IF;
3901:
3902: WHEN OTHERS THEN
3903: ROLLBACK TO defer_workorder_PVT;

Line 3922: AHL_DEBUG_PUB.disable_debug;

3918: p_data => x_msg_data
3919: );
3920:
3921: IF ( G_DEBUG = 'Y' ) THEN
3922: AHL_DEBUG_PUB.disable_debug;
3923: END IF;
3924:
3925: END defer_workorder;
3926:

Line 3970: AHL_DEBUG_PUB.enable_debug;

3966:
3967: BEGIN
3968: -- Enable Debug (optional)
3969: IF ( G_DEBUG = 'Y' ) THEN
3970: AHL_DEBUG_PUB.enable_debug;
3971: END IF;
3972:
3973: -- Initialize API return status to success
3974: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4011: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' Inputs:' );

4007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4008: END IF;
4009:
4010: IF ( G_DEBUG = 'Y' ) THEN
4011: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' Inputs:' );
4012: AHL_DEBUG_PUB.debug( 'unit_effectivity_id:' || p_x_mr_rec.unit_effectivity_id );
4013: AHL_DEBUG_PUB.debug( 'ue_object_version_no:' || p_x_mr_rec.ue_object_version_no );
4014: AHL_DEBUG_PUB.debug( 'item_instance_id:' || p_x_mr_rec.item_instance_id );
4015: AHL_DEBUG_PUB.debug( 'mr_header_id:' || p_x_mr_rec.mr_header_id );

Line 4012: AHL_DEBUG_PUB.debug( 'unit_effectivity_id:' || p_x_mr_rec.unit_effectivity_id );

4008: END IF;
4009:
4010: IF ( G_DEBUG = 'Y' ) THEN
4011: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' Inputs:' );
4012: AHL_DEBUG_PUB.debug( 'unit_effectivity_id:' || p_x_mr_rec.unit_effectivity_id );
4013: AHL_DEBUG_PUB.debug( 'ue_object_version_no:' || p_x_mr_rec.ue_object_version_no );
4014: AHL_DEBUG_PUB.debug( 'item_instance_id:' || p_x_mr_rec.item_instance_id );
4015: AHL_DEBUG_PUB.debug( 'mr_header_id:' || p_x_mr_rec.mr_header_id );
4016: AHL_DEBUG_PUB.debug( 'incident_id:' || p_x_mr_rec.incident_id );

Line 4013: AHL_DEBUG_PUB.debug( 'ue_object_version_no:' || p_x_mr_rec.ue_object_version_no );

4009:
4010: IF ( G_DEBUG = 'Y' ) THEN
4011: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' Inputs:' );
4012: AHL_DEBUG_PUB.debug( 'unit_effectivity_id:' || p_x_mr_rec.unit_effectivity_id );
4013: AHL_DEBUG_PUB.debug( 'ue_object_version_no:' || p_x_mr_rec.ue_object_version_no );
4014: AHL_DEBUG_PUB.debug( 'item_instance_id:' || p_x_mr_rec.item_instance_id );
4015: AHL_DEBUG_PUB.debug( 'mr_header_id:' || p_x_mr_rec.mr_header_id );
4016: AHL_DEBUG_PUB.debug( 'incident_id:' || p_x_mr_rec.incident_id );
4017: AHL_DEBUG_PUB.debug( 'mr_title:' || p_x_mr_rec.mr_title );

Line 4014: AHL_DEBUG_PUB.debug( 'item_instance_id:' || p_x_mr_rec.item_instance_id );

4010: IF ( G_DEBUG = 'Y' ) THEN
4011: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' Inputs:' );
4012: AHL_DEBUG_PUB.debug( 'unit_effectivity_id:' || p_x_mr_rec.unit_effectivity_id );
4013: AHL_DEBUG_PUB.debug( 'ue_object_version_no:' || p_x_mr_rec.ue_object_version_no );
4014: AHL_DEBUG_PUB.debug( 'item_instance_id:' || p_x_mr_rec.item_instance_id );
4015: AHL_DEBUG_PUB.debug( 'mr_header_id:' || p_x_mr_rec.mr_header_id );
4016: AHL_DEBUG_PUB.debug( 'incident_id:' || p_x_mr_rec.incident_id );
4017: AHL_DEBUG_PUB.debug( 'mr_title:' || p_x_mr_rec.mr_title );
4018: AHL_DEBUG_PUB.debug( 'ue_status_code:' || p_x_mr_rec.ue_status_code );

Line 4015: AHL_DEBUG_PUB.debug( 'mr_header_id:' || p_x_mr_rec.mr_header_id );

4011: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' Inputs:' );
4012: AHL_DEBUG_PUB.debug( 'unit_effectivity_id:' || p_x_mr_rec.unit_effectivity_id );
4013: AHL_DEBUG_PUB.debug( 'ue_object_version_no:' || p_x_mr_rec.ue_object_version_no );
4014: AHL_DEBUG_PUB.debug( 'item_instance_id:' || p_x_mr_rec.item_instance_id );
4015: AHL_DEBUG_PUB.debug( 'mr_header_id:' || p_x_mr_rec.mr_header_id );
4016: AHL_DEBUG_PUB.debug( 'incident_id:' || p_x_mr_rec.incident_id );
4017: AHL_DEBUG_PUB.debug( 'mr_title:' || p_x_mr_rec.mr_title );
4018: AHL_DEBUG_PUB.debug( 'ue_status_code:' || p_x_mr_rec.ue_status_code );
4019: AHL_DEBUG_PUB.debug( 'qa_inspection_type:' || p_x_mr_rec.qa_inspection_type );

Line 4016: AHL_DEBUG_PUB.debug( 'incident_id:' || p_x_mr_rec.incident_id );

4012: AHL_DEBUG_PUB.debug( 'unit_effectivity_id:' || p_x_mr_rec.unit_effectivity_id );
4013: AHL_DEBUG_PUB.debug( 'ue_object_version_no:' || p_x_mr_rec.ue_object_version_no );
4014: AHL_DEBUG_PUB.debug( 'item_instance_id:' || p_x_mr_rec.item_instance_id );
4015: AHL_DEBUG_PUB.debug( 'mr_header_id:' || p_x_mr_rec.mr_header_id );
4016: AHL_DEBUG_PUB.debug( 'incident_id:' || p_x_mr_rec.incident_id );
4017: AHL_DEBUG_PUB.debug( 'mr_title:' || p_x_mr_rec.mr_title );
4018: AHL_DEBUG_PUB.debug( 'ue_status_code:' || p_x_mr_rec.ue_status_code );
4019: AHL_DEBUG_PUB.debug( 'qa_inspection_type:' || p_x_mr_rec.qa_inspection_type );
4020: AHL_DEBUG_PUB.debug( 'actual_end_date:' || p_x_mr_rec.actual_end_date );

Line 4017: AHL_DEBUG_PUB.debug( 'mr_title:' || p_x_mr_rec.mr_title );

4013: AHL_DEBUG_PUB.debug( 'ue_object_version_no:' || p_x_mr_rec.ue_object_version_no );
4014: AHL_DEBUG_PUB.debug( 'item_instance_id:' || p_x_mr_rec.item_instance_id );
4015: AHL_DEBUG_PUB.debug( 'mr_header_id:' || p_x_mr_rec.mr_header_id );
4016: AHL_DEBUG_PUB.debug( 'incident_id:' || p_x_mr_rec.incident_id );
4017: AHL_DEBUG_PUB.debug( 'mr_title:' || p_x_mr_rec.mr_title );
4018: AHL_DEBUG_PUB.debug( 'ue_status_code:' || p_x_mr_rec.ue_status_code );
4019: AHL_DEBUG_PUB.debug( 'qa_inspection_type:' || p_x_mr_rec.qa_inspection_type );
4020: AHL_DEBUG_PUB.debug( 'actual_end_date:' || p_x_mr_rec.actual_end_date );
4021: AHL_DEBUG_PUB.debug( 'qa_plan_id:' || p_x_mr_rec.qa_plan_id );

Line 4018: AHL_DEBUG_PUB.debug( 'ue_status_code:' || p_x_mr_rec.ue_status_code );

4014: AHL_DEBUG_PUB.debug( 'item_instance_id:' || p_x_mr_rec.item_instance_id );
4015: AHL_DEBUG_PUB.debug( 'mr_header_id:' || p_x_mr_rec.mr_header_id );
4016: AHL_DEBUG_PUB.debug( 'incident_id:' || p_x_mr_rec.incident_id );
4017: AHL_DEBUG_PUB.debug( 'mr_title:' || p_x_mr_rec.mr_title );
4018: AHL_DEBUG_PUB.debug( 'ue_status_code:' || p_x_mr_rec.ue_status_code );
4019: AHL_DEBUG_PUB.debug( 'qa_inspection_type:' || p_x_mr_rec.qa_inspection_type );
4020: AHL_DEBUG_PUB.debug( 'actual_end_date:' || p_x_mr_rec.actual_end_date );
4021: AHL_DEBUG_PUB.debug( 'qa_plan_id:' || p_x_mr_rec.qa_plan_id );
4022: AHL_DEBUG_PUB.debug( 'qa_collection_id:' || p_x_mr_rec.qa_collection_id );

Line 4019: AHL_DEBUG_PUB.debug( 'qa_inspection_type:' || p_x_mr_rec.qa_inspection_type );

4015: AHL_DEBUG_PUB.debug( 'mr_header_id:' || p_x_mr_rec.mr_header_id );
4016: AHL_DEBUG_PUB.debug( 'incident_id:' || p_x_mr_rec.incident_id );
4017: AHL_DEBUG_PUB.debug( 'mr_title:' || p_x_mr_rec.mr_title );
4018: AHL_DEBUG_PUB.debug( 'ue_status_code:' || p_x_mr_rec.ue_status_code );
4019: AHL_DEBUG_PUB.debug( 'qa_inspection_type:' || p_x_mr_rec.qa_inspection_type );
4020: AHL_DEBUG_PUB.debug( 'actual_end_date:' || p_x_mr_rec.actual_end_date );
4021: AHL_DEBUG_PUB.debug( 'qa_plan_id:' || p_x_mr_rec.qa_plan_id );
4022: AHL_DEBUG_PUB.debug( 'qa_collection_id:' || p_x_mr_rec.qa_collection_id );
4023: END IF;

Line 4020: AHL_DEBUG_PUB.debug( 'actual_end_date:' || p_x_mr_rec.actual_end_date );

4016: AHL_DEBUG_PUB.debug( 'incident_id:' || p_x_mr_rec.incident_id );
4017: AHL_DEBUG_PUB.debug( 'mr_title:' || p_x_mr_rec.mr_title );
4018: AHL_DEBUG_PUB.debug( 'ue_status_code:' || p_x_mr_rec.ue_status_code );
4019: AHL_DEBUG_PUB.debug( 'qa_inspection_type:' || p_x_mr_rec.qa_inspection_type );
4020: AHL_DEBUG_PUB.debug( 'actual_end_date:' || p_x_mr_rec.actual_end_date );
4021: AHL_DEBUG_PUB.debug( 'qa_plan_id:' || p_x_mr_rec.qa_plan_id );
4022: AHL_DEBUG_PUB.debug( 'qa_collection_id:' || p_x_mr_rec.qa_collection_id );
4023: END IF;
4024:

Line 4021: AHL_DEBUG_PUB.debug( 'qa_plan_id:' || p_x_mr_rec.qa_plan_id );

4017: AHL_DEBUG_PUB.debug( 'mr_title:' || p_x_mr_rec.mr_title );
4018: AHL_DEBUG_PUB.debug( 'ue_status_code:' || p_x_mr_rec.ue_status_code );
4019: AHL_DEBUG_PUB.debug( 'qa_inspection_type:' || p_x_mr_rec.qa_inspection_type );
4020: AHL_DEBUG_PUB.debug( 'actual_end_date:' || p_x_mr_rec.actual_end_date );
4021: AHL_DEBUG_PUB.debug( 'qa_plan_id:' || p_x_mr_rec.qa_plan_id );
4022: AHL_DEBUG_PUB.debug( 'qa_collection_id:' || p_x_mr_rec.qa_collection_id );
4023: END IF;
4024:
4025: -- Validate the status to check if the MR/SR status is valid for Sign off

Line 4022: AHL_DEBUG_PUB.debug( 'qa_collection_id:' || p_x_mr_rec.qa_collection_id );

4018: AHL_DEBUG_PUB.debug( 'ue_status_code:' || p_x_mr_rec.ue_status_code );
4019: AHL_DEBUG_PUB.debug( 'qa_inspection_type:' || p_x_mr_rec.qa_inspection_type );
4020: AHL_DEBUG_PUB.debug( 'actual_end_date:' || p_x_mr_rec.actual_end_date );
4021: AHL_DEBUG_PUB.debug( 'qa_plan_id:' || p_x_mr_rec.qa_plan_id );
4022: AHL_DEBUG_PUB.debug( 'qa_collection_id:' || p_x_mr_rec.qa_collection_id );
4023: END IF;
4024:
4025: -- Validate the status to check if the MR/SR status is valid for Sign off
4026: l_return_status :=

Line 4072: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || 'Getting Reset Counters' );

4068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4069: END IF;
4070:
4071: IF ( G_DEBUG = 'Y' ) THEN
4072: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || 'Getting Reset Counters' );
4073: END IF;
4074:
4075: -- Get the Reset Counter Readings for all Counters associted with
4076: -- the MR and the Item Instance.

Line 4097: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || 'Resetting Counters' );

4093:
4094: IF ( l_reset_counter_tbl IS NOT NULL AND l_reset_counter_tbl.COUNT > 0 ) THEN
4095:
4096: IF ( G_DEBUG = 'Y' ) THEN
4097: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || 'Resetting Counters' );
4098: END IF;
4099:
4100: -- Reset all the Counters with Reset Values specified in FMP
4101: l_return_status :=

Line 4126: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || 'Getting CP Counters' );

4122:
4123: END IF;
4124:
4125: IF ( G_DEBUG = 'Y' ) THEN
4126: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || 'Getting CP Counters' );
4127: END IF;
4128:
4129: -- Get the Current Counter Readings for all Counters associted with
4130: -- the Item Instance.

Line 4152: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || 'Updating UMP' );

4148: IF ( l_counter_tbl.COUNT > 0 ) THEN
4149: */
4150:
4151: IF ( G_DEBUG = 'Y' ) THEN
4152: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || 'Updating UMP' );
4153: END IF;
4154:
4155: -- Record Accomplishment in UMP for UMP MR Instance
4156: l_return_status :=

Line 4274: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

4270:
4271: -- Abort for Unexpected errors, but, continue for other errors.
4272: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
4273: IF ( G_DEBUG = 'Y' ) THEN
4274: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
4275: ||' : Could Not Complete Parent MR Instance with UE : '
4276: ||TO_CHAR( parent_csr.unit_effectivity_id )
4277: || ' associated to UE : ' || TO_CHAR( p_x_mr_rec.unit_effectivity_id )
4278: || ' because of...' );

Line 4288: AHL_DEBUG_PUB.debug(' Error : ' || I || ': ' || l_msg_data);

4284: p_data => l_msg_data,
4285: p_msg_index_out => l_msg_index_out
4286: );
4287:
4288: AHL_DEBUG_PUB.debug(' Error : ' || I || ': ' || l_msg_data);
4289: END LOOP;
4290: END IF;
4291:
4292: -- Initialize message list since errors are not reported

Line 4304: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Completed MR Instance with UE : ' || TO_CHAR( parent_csr.unit_effectivity_id ) || ' associated to UE : ' || TO_CHAR( p_x_mr_rec.unit_effectivity_id ) || ' Successfuly...' );

4300: x_msg_count := l_msg_count;
4301: RETURN;
4302: ELSE
4303: IF ( G_DEBUG = 'Y' ) THEN
4304: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Completed MR Instance with UE : ' || TO_CHAR( parent_csr.unit_effectivity_id ) || ' associated to UE : ' || TO_CHAR( p_x_mr_rec.unit_effectivity_id ) || ' Successfuly...' );
4305: END IF;
4306:
4307: -- Re-establish the save point because the complete_mr_instance Commits
4308: IF FND_API.to_boolean( p_commit ) THEN

Line 4322: AHL_DEBUG_PUB.disable_debug;

4318: END IF;
4319:
4320: -- Disable debug (if enabled)
4321: IF ( G_DEBUG = 'Y' ) THEN
4322: AHL_DEBUG_PUB.disable_debug;
4323: END IF;
4324:
4325: EXCEPTION
4326:

Line 4338: AHL_DEBUG_PUB.disable_debug;

4334: p_data => x_msg_data
4335: );
4336:
4337: IF ( G_DEBUG = 'Y' ) THEN
4338: AHL_DEBUG_PUB.disable_debug;
4339: END IF;
4340:
4341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4342: ROLLBACK TO complete_mr_instance_PVT;

Line 4352: AHL_DEBUG_PUB.disable_debug;

4348: p_data => x_msg_data
4349: );
4350:
4351: IF ( G_DEBUG = 'Y' ) THEN
4352: AHL_DEBUG_PUB.disable_debug;
4353: END IF;
4354:
4355: WHEN OTHERS THEN
4356: ROLLBACK TO complete_mr_instance_PVT;

Line 4375: AHL_DEBUG_PUB.disable_debug;

4371: p_data => x_msg_data
4372: );
4373:
4374: IF ( G_DEBUG = 'Y' ) THEN
4375: AHL_DEBUG_PUB.disable_debug;
4376: END IF;
4377: END complete_mr_instance;
4378:
4379: -- Function added in 11.5.10 for getting the status of an MR instance.

Line 5097: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Getting ' || l_ctr || ' th WO of Visit - ' || wo_csr.workorder_name );

5093: l_ctr := l_ctr + 1;
5094: l_workorder_tbl(l_ctr).parent_object_id := wo_csr.parent_object_id;
5095:
5096: IF ( G_DEBUG = 'Y' ) THEN
5097: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Getting ' || l_ctr || ' th WO of Visit - ' || wo_csr.workorder_name );
5098: END IF;
5099:
5100: -- Check if Incomplete Master Workorder
5101: IF ( wo_csr.master_workorder_flag = 'Y' AND

Line 5108: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : This is a Master Workorder ' );

5104: wo_csr.status_code <> G_JOB_STATUS_CLOSED AND
5105: wo_csr.status_code <> G_JOB_STATUS_CANCELLED ) THEN
5106:
5107: IF ( G_DEBUG = 'Y' ) THEN
5108: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : This is a Master Workorder ' );
5109: END IF;
5110:
5111: -- Since Master Workorders are obtained after the child Workorders
5112: -- It is enough to iterate through these child Workorders obtained

Line 5162: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

5158: END IF;
5159: */--End ER # 4757222
5160:
5161: IF ( G_DEBUG = 'Y' ) THEN
5162: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
5163: || ' : Calculated ACtual Start Date - '
5164: || to_char( l_workorder_tbl(l_ctr).actual_start_date, 'DD-MON-YYYY HH24:MI' )
5165: || ' Calculated Actual End Date - '
5166: || to_char( l_workorder_tbl(l_ctr).actual_end_date, 'DD-MON-YYYY HH24:MI' ) );

Line 5194: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Storing ACtual Start Date of Child - ' || to_char( wo_csr.actual_start_date, 'DD-MON-YYYY HH24:MI' ) || ' Actual End Date' || to_char( wo_csr.actual_end_date, 'DD-MON-YYYY HH24:MI' ) );

5190:
5191: ELSE
5192:
5193: IF ( G_DEBUG = 'Y' ) THEN
5194: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Storing ACtual Start Date of Child - ' || to_char( wo_csr.actual_start_date, 'DD-MON-YYYY HH24:MI' ) || ' Actual End Date' || to_char( wo_csr.actual_end_date, 'DD-MON-YYYY HH24:MI' ) );
5195: END IF;
5196:
5197: -- Store the Child Wo or Complete Master Wo Actual Dates as it is
5198: l_workorder_tbl(l_ctr).actual_start_date := wo_csr.actual_start_date;

Line 5307: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Getting Visit Dependencies' );

5303: l_api_name VARCHAR2(30) := 'complete_visit_mr_wos';
5304: BEGIN
5305:
5306: IF ( G_DEBUG = 'Y' ) THEN
5307: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Getting Visit Dependencies' );
5308: END IF;
5309:
5310: -- Get all the completion dependencies in a Visit
5311: FOR parent_csr IN get_visit_dependencies( p_wip_entity_id ) LOOP

Line 5323: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Completion Dependencies do not exist' );

5319: -- There are no Completion Dependencies.
5320: IF ( l_parent_wo_tbl.COUNT = 0 ) THEN
5321:
5322: IF ( G_DEBUG = 'Y' ) THEN
5323: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Completion Dependencies do not exist' );
5324: END IF;
5325:
5326: -- Complete all Workorders
5327: FOR i IN p_x_workorder_tbl.FIRST..p_x_workorder_tbl.LAST LOOP

Line 5334: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Completing Workorder - ' || p_x_workorder_tbl(i).workorder_name || ' ID - ' || p_x_workorder_tbl(i).workorder_id );

5330: -- Master Workorders are completed automatically
5331: IF ( p_x_workorder_tbl(i).master_workorder_flag = 'N' ) THEN
5332:
5333: IF ( G_DEBUG = 'Y' ) THEN
5334: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Completing Workorder - ' || p_x_workorder_tbl(i).workorder_name || ' ID - ' || p_x_workorder_tbl(i).workorder_id );
5335: END IF;
5336:
5337: complete_workorder
5338: (

Line 5363: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Completion Dependencies exist' );

5359:
5360: ELSE
5361:
5362: IF ( G_DEBUG = 'Y' ) THEN
5363: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Completion Dependencies exist' );
5364: END IF;
5365:
5366: -- Since Completion dependencies exist multiple iterations may be
5367: -- required for completing the Visit or MR Workorders

Line 5372: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin Iteration - ' || l_iteration_ctr );

5368: -- Break out when all the Wos of the Visit or MR are complete
5369: WHILE TRUE LOOP
5370:
5371: IF ( G_DEBUG = 'Y' ) THEN
5372: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin Iteration - ' || l_iteration_ctr );
5373: END IF;
5374:
5375: -- Increment Iteration counter
5376: l_iteration_ctr := l_iteration_ctr + 1;

Line 5391: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Need to Complete WO - ' || p_x_workorder_tbl(i).workorder_name );

5387: IF ( p_x_workorder_tbl(i).master_workorder_flag = 'N' AND
5388: NVL(p_x_workorder_tbl(i).status_code,'X') <> NVL(G_JOB_STATUS_COMPLETE,'Y') ) THEN
5389:
5390: IF ( G_DEBUG = 'Y' ) THEN
5391: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Need to Complete WO - ' || p_x_workorder_tbl(i).workorder_name );
5392: END IF;
5393:
5394: -- Reset for Every Iteration of a Child Workorder
5395: l_parent_wo_cmpl := TRUE;

Line 5445: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Workorder cannot be completed in this iteration because one or more parents are not complete ' );

5441: -- Break out of the iterate parents loop
5442: IF ( l_parent_wo_cmpl = FALSE ) THEN
5443:
5444: IF ( G_DEBUG = 'Y' ) THEN
5445: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Workorder cannot be completed in this iteration because one or more parents are not complete ' );
5446: END IF;
5447:
5448: EXIT;
5449: END IF;

Line 5457: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Workorder can be completed in this iteration because all parents are complete ' );

5453: -- All the Parents of a child WO are complete
5454: IF ( l_parent_wo_cmpl = TRUE ) THEN
5455:
5456: IF ( G_DEBUG = 'Y' ) THEN
5457: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Workorder can be completed in this iteration because all parents are complete ' );
5458: END IF;
5459:
5460: -- Complete the Child Workorder
5461: complete_workorder

Line 5501: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : All Workorders are completed in this iteration ' );

5497: -- If all the Wos of the Visit or MR are complete in this iteration
5498: -- Break out of the outermost loop
5499: IF ( l_all_wos_cmpl = TRUE ) THEN
5500: IF ( G_DEBUG = 'Y' ) THEN
5501: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : All Workorders are completed in this iteration ' );
5502: END IF;
5503:
5504: EXIT;
5505: END IF;

Line 5935: AHL_DEBUG_PUB.enable_debug;

5931: BEGIN
5932:
5933: -- Enable Debug (optional)
5934: IF ( G_DEBUG = 'Y' ) THEN
5935: AHL_DEBUG_PUB.enable_debug;
5936: END IF;
5937:
5938: -- Initialize API return status to success
5939: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5950: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Validating Inputs' );

5946: FND_MSG_PUB.initialize;
5947: END IF;
5948:
5949: IF ( G_DEBUG = 'Y' ) THEN
5950: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Validating Inputs' );
5951: END IF;
5952:
5953: -- Validate all the inputs of the API
5954: l_return_status :=

Line 5967: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.unit_effectivity_id - ' || p_signoff_mr_rec.unit_effectivity_id );

5963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5964: END IF;
5965:
5966: IF ( G_DEBUG = 'Y' ) THEN
5967: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.unit_effectivity_id - ' || p_signoff_mr_rec.unit_effectivity_id );
5968: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.object_version_number - ' || p_signoff_mr_rec.object_version_number );
5969: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.signoff_child_mrs_flag - ' || p_signoff_mr_rec.signoff_child_mrs_flag );
5970: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.complete_job_ops_flag - ' || p_signoff_mr_rec.complete_job_ops_flag );
5971: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.default_actual_dates_flag - ' || p_signoff_mr_rec.default_actual_dates_flag );

Line 5968: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.object_version_number - ' || p_signoff_mr_rec.object_version_number );

5964: END IF;
5965:
5966: IF ( G_DEBUG = 'Y' ) THEN
5967: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.unit_effectivity_id - ' || p_signoff_mr_rec.unit_effectivity_id );
5968: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.object_version_number - ' || p_signoff_mr_rec.object_version_number );
5969: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.signoff_child_mrs_flag - ' || p_signoff_mr_rec.signoff_child_mrs_flag );
5970: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.complete_job_ops_flag - ' || p_signoff_mr_rec.complete_job_ops_flag );
5971: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.default_actual_dates_flag - ' || p_signoff_mr_rec.default_actual_dates_flag );
5972: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_start_date - ' || p_signoff_mr_rec.actual_start_date );

Line 5969: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.signoff_child_mrs_flag - ' || p_signoff_mr_rec.signoff_child_mrs_flag );

5965:
5966: IF ( G_DEBUG = 'Y' ) THEN
5967: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.unit_effectivity_id - ' || p_signoff_mr_rec.unit_effectivity_id );
5968: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.object_version_number - ' || p_signoff_mr_rec.object_version_number );
5969: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.signoff_child_mrs_flag - ' || p_signoff_mr_rec.signoff_child_mrs_flag );
5970: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.complete_job_ops_flag - ' || p_signoff_mr_rec.complete_job_ops_flag );
5971: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.default_actual_dates_flag - ' || p_signoff_mr_rec.default_actual_dates_flag );
5972: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_start_date - ' || p_signoff_mr_rec.actual_start_date );
5973: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_end_date - ' || p_signoff_mr_rec.actual_end_date );

Line 5970: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.complete_job_ops_flag - ' || p_signoff_mr_rec.complete_job_ops_flag );

5966: IF ( G_DEBUG = 'Y' ) THEN
5967: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.unit_effectivity_id - ' || p_signoff_mr_rec.unit_effectivity_id );
5968: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.object_version_number - ' || p_signoff_mr_rec.object_version_number );
5969: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.signoff_child_mrs_flag - ' || p_signoff_mr_rec.signoff_child_mrs_flag );
5970: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.complete_job_ops_flag - ' || p_signoff_mr_rec.complete_job_ops_flag );
5971: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.default_actual_dates_flag - ' || p_signoff_mr_rec.default_actual_dates_flag );
5972: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_start_date - ' || p_signoff_mr_rec.actual_start_date );
5973: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_end_date - ' || p_signoff_mr_rec.actual_end_date );
5974: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.transact_resource_flag - ' || p_signoff_mr_rec.transact_resource_flag );

Line 5971: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.default_actual_dates_flag - ' || p_signoff_mr_rec.default_actual_dates_flag );

5967: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.unit_effectivity_id - ' || p_signoff_mr_rec.unit_effectivity_id );
5968: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.object_version_number - ' || p_signoff_mr_rec.object_version_number );
5969: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.signoff_child_mrs_flag - ' || p_signoff_mr_rec.signoff_child_mrs_flag );
5970: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.complete_job_ops_flag - ' || p_signoff_mr_rec.complete_job_ops_flag );
5971: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.default_actual_dates_flag - ' || p_signoff_mr_rec.default_actual_dates_flag );
5972: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_start_date - ' || p_signoff_mr_rec.actual_start_date );
5973: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_end_date - ' || p_signoff_mr_rec.actual_end_date );
5974: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.transact_resource_flag - ' || p_signoff_mr_rec.transact_resource_flag );
5975: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.employee_number - ' || p_signoff_mr_rec.employee_number );

Line 5972: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_start_date - ' || p_signoff_mr_rec.actual_start_date );

5968: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.object_version_number - ' || p_signoff_mr_rec.object_version_number );
5969: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.signoff_child_mrs_flag - ' || p_signoff_mr_rec.signoff_child_mrs_flag );
5970: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.complete_job_ops_flag - ' || p_signoff_mr_rec.complete_job_ops_flag );
5971: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.default_actual_dates_flag - ' || p_signoff_mr_rec.default_actual_dates_flag );
5972: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_start_date - ' || p_signoff_mr_rec.actual_start_date );
5973: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_end_date - ' || p_signoff_mr_rec.actual_end_date );
5974: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.transact_resource_flag - ' || p_signoff_mr_rec.transact_resource_flag );
5975: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.employee_number - ' || p_signoff_mr_rec.employee_number );
5976: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.serial_number - ' || p_signoff_mr_rec.serial_number );

Line 5973: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_end_date - ' || p_signoff_mr_rec.actual_end_date );

5969: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.signoff_child_mrs_flag - ' || p_signoff_mr_rec.signoff_child_mrs_flag );
5970: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.complete_job_ops_flag - ' || p_signoff_mr_rec.complete_job_ops_flag );
5971: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.default_actual_dates_flag - ' || p_signoff_mr_rec.default_actual_dates_flag );
5972: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_start_date - ' || p_signoff_mr_rec.actual_start_date );
5973: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_end_date - ' || p_signoff_mr_rec.actual_end_date );
5974: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.transact_resource_flag - ' || p_signoff_mr_rec.transact_resource_flag );
5975: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.employee_number - ' || p_signoff_mr_rec.employee_number );
5976: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.serial_number - ' || p_signoff_mr_rec.serial_number );
5977: END IF;

Line 5974: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.transact_resource_flag - ' || p_signoff_mr_rec.transact_resource_flag );

5970: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.complete_job_ops_flag - ' || p_signoff_mr_rec.complete_job_ops_flag );
5971: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.default_actual_dates_flag - ' || p_signoff_mr_rec.default_actual_dates_flag );
5972: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_start_date - ' || p_signoff_mr_rec.actual_start_date );
5973: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_end_date - ' || p_signoff_mr_rec.actual_end_date );
5974: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.transact_resource_flag - ' || p_signoff_mr_rec.transact_resource_flag );
5975: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.employee_number - ' || p_signoff_mr_rec.employee_number );
5976: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.serial_number - ' || p_signoff_mr_rec.serial_number );
5977: END IF;
5978:

Line 5975: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.employee_number - ' || p_signoff_mr_rec.employee_number );

5971: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.default_actual_dates_flag - ' || p_signoff_mr_rec.default_actual_dates_flag );
5972: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_start_date - ' || p_signoff_mr_rec.actual_start_date );
5973: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_end_date - ' || p_signoff_mr_rec.actual_end_date );
5974: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.transact_resource_flag - ' || p_signoff_mr_rec.transact_resource_flag );
5975: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.employee_number - ' || p_signoff_mr_rec.employee_number );
5976: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.serial_number - ' || p_signoff_mr_rec.serial_number );
5977: END IF;
5978:
5979: -- Invoke Complete MR Instance API if this is not a top-down signoff

Line 5976: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.serial_number - ' || p_signoff_mr_rec.serial_number );

5972: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_start_date - ' || p_signoff_mr_rec.actual_start_date );
5973: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.actual_end_date - ' || p_signoff_mr_rec.actual_end_date );
5974: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.transact_resource_flag - ' || p_signoff_mr_rec.transact_resource_flag );
5975: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.employee_number - ' || p_signoff_mr_rec.employee_number );
5976: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Inputs - p_signoff_mr_rec.serial_number - ' || p_signoff_mr_rec.serial_number );
5977: END IF;
5978:
5979: -- Invoke Complete MR Instance API if this is not a top-down signoff
5980: IF ( p_signoff_mr_rec.signoff_child_mrs_flag = 'N' AND

Line 5985: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Not Top Down Signoff ' );

5981: p_signoff_mr_rec.complete_job_ops_flag = 'N' AND
5982: p_signoff_mr_rec.transact_resource_flag = 'N' ) THEN
5983:
5984: IF ( G_DEBUG = 'Y' ) THEN
5985: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Not Top Down Signoff ' );
5986: END IF;
5987:
5988: l_ctr := l_ctr + 1;
5989: l_child_mr_tbl(l_ctr).unit_effectivity_id := p_signoff_mr_rec.unit_effectivity_id;

Line 6017: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing UE' );

6013:
6014: END IF;
6015:
6016: IF ( G_DEBUG = 'Y' ) THEN
6017: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing UE' );
6018: END IF;
6019:
6020: -- Get the UE Details
6021: OPEN get_ue_details( p_signoff_mr_rec.unit_effectivity_id );

Line 6092: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing Child UEs' );

6088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6089: END IF;
6090:
6091: IF ( G_DEBUG = 'Y' ) THEN
6092: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing Child UEs' );
6093: END IF;
6094:
6095: -- Balaji added the following loop for the BAE bug.
6096: -- The cursor get_child_ue_details doesnt UEs at the leaf node first

Line 6119: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Child UE Table Size '||l_child_ue_tbl.COUNT );

6115: END IF;
6116: END LOOP;
6117:
6118: IF ( G_DEBUG = 'Y' ) THEN
6119: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Child UE Table Size '||l_child_ue_tbl.COUNT );
6120: END IF;
6121: -- Get the Child UE Details
6122: IF l_child_ue_tbl.COUNT > 0 THEN
6123:

Line 6128: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_child_ue_tbl(l_ue_count).title '||l_child_ue_tbl(l_ue_count).title );

6124: -- Reverse the order of signing off the Ues. First child UE then its parent
6125: -- etc.,Balaji modified the code for BAE bug.
6126: FOR l_ue_count IN REVERSE l_child_ue_tbl.FIRST..l_child_ue_tbl.LAST LOOP
6127: IF ( G_DEBUG = 'Y' ) THEN
6128: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_child_ue_tbl(l_ue_count).title '||l_child_ue_tbl(l_ue_count).title );
6129: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : ump_status_code '||l_child_ue_tbl(l_ue_count).ump_status_code );
6130: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_child_ue_tbl(l_ue_count).qa_collection_id '||l_child_ue_tbl(l_ue_count).qa_collection_id );
6131: END IF;
6132: -- If top down signoff is required for the Child UEs

Line 6129: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : ump_status_code '||l_child_ue_tbl(l_ue_count).ump_status_code );

6125: -- etc.,Balaji modified the code for BAE bug.
6126: FOR l_ue_count IN REVERSE l_child_ue_tbl.FIRST..l_child_ue_tbl.LAST LOOP
6127: IF ( G_DEBUG = 'Y' ) THEN
6128: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_child_ue_tbl(l_ue_count).title '||l_child_ue_tbl(l_ue_count).title );
6129: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : ump_status_code '||l_child_ue_tbl(l_ue_count).ump_status_code );
6130: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_child_ue_tbl(l_ue_count).qa_collection_id '||l_child_ue_tbl(l_ue_count).qa_collection_id );
6131: END IF;
6132: -- If top down signoff is required for the Child UEs
6133: IF ( p_signoff_mr_rec.signoff_child_mrs_flag = 'Y' ) THEN

Line 6130: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_child_ue_tbl(l_ue_count).qa_collection_id '||l_child_ue_tbl(l_ue_count).qa_collection_id );

6126: FOR l_ue_count IN REVERSE l_child_ue_tbl.FIRST..l_child_ue_tbl.LAST LOOP
6127: IF ( G_DEBUG = 'Y' ) THEN
6128: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_child_ue_tbl(l_ue_count).title '||l_child_ue_tbl(l_ue_count).title );
6129: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : ump_status_code '||l_child_ue_tbl(l_ue_count).ump_status_code );
6130: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_child_ue_tbl(l_ue_count).qa_collection_id '||l_child_ue_tbl(l_ue_count).qa_collection_id );
6131: END IF;
6132: -- If top down signoff is required for the Child UEs
6133: IF ( p_signoff_mr_rec.signoff_child_mrs_flag = 'Y' ) THEN
6134:

Line 6185: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_ue_status_code '||l_ue_status_code );

6181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6182: END IF;
6183:
6184: IF ( G_DEBUG = 'Y' ) THEN
6185: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_ue_status_code '||l_ue_status_code );
6186: END IF;
6187:
6188: l_ctr := l_ctr + 1;
6189: l_child_mr_tbl(l_ctr).unit_effectivity_id := l_child_ue_tbl(l_ue_count).unit_effectivity_id;

Line 6227: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing UE Workorders' );

6223:
6224: l_ctr := 0;
6225:
6226: IF ( G_DEBUG = 'Y' ) THEN
6227: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing UE Workorders' );
6228: END IF;
6229:
6230: -- Get all the Workorders for the UE
6231: FOR wo_csr IN get_ue_workorders( l_mr_rec.wip_entity_id ) LOOP

Line 6392: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

6388: l_workorder_tbl(l_ctr).actual_end_date := wo_csr.actual_end_date;
6389: END IF;
6390:
6391: IF ( G_DEBUG = 'Y' ) THEN
6392: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6393: || ' : Wo Name - ' || l_workorder_tbl(l_ctr).workorder_name
6394: || ' WO ID - ' || l_workorder_tbl(l_ctr).workorder_id
6395: || ' Actual Start Date - ' || l_workorder_tbl(l_ctr).actual_start_date
6396: || ' Actual End Date - ' || l_workorder_tbl(l_ctr).actual_end_date );

Line 6551: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

6547: */
6548: l_ctr := 0;
6549:
6550: IF ( G_DEBUG = 'Y' ) THEN
6551: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6552: || ' : Before Processing Resource Transactions' );
6553: END IF;
6554:
6555: -- Check if Resources need to transacted

Line 6662: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

6658:
6659: END IF; -- Check Transact Resource Flag
6660:
6661: IF ( G_DEBUG = 'Y' ) THEN
6662: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6663: || ' : Before Calling resource request table:' ||l_resource_req_tbl.COUNT);
6664: END IF;
6665:
6666: IF ( l_resource_req_tbl.COUNT > 0 ) THEN

Line 6745: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

6741: -- Subtract the consumed quantity from the required quantity
6742: l_resource_req_tbl(i).transaction_quantity := l_resource_req_tbl(i).usage_rate_or_amount - l_txn_qty - l_pending_txn_qty;
6743:
6744: IF ( G_DEBUG = 'Y' ) THEN
6745: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6746: || ' :l_resource_req_tbl(i).usage_rate_or_amount--> :' ||l_resource_req_tbl(i).usage_rate_or_amount);
6747: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6748: || ' :l_txn_qty--> :' ||l_txn_qty);
6749: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

Line 6747: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

6743:
6744: IF ( G_DEBUG = 'Y' ) THEN
6745: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6746: || ' :l_resource_req_tbl(i).usage_rate_or_amount--> :' ||l_resource_req_tbl(i).usage_rate_or_amount);
6747: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6748: || ' :l_txn_qty--> :' ||l_txn_qty);
6749: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6750: || ' :l_txn_qty--> :' ||l_pending_txn_qty);
6751: END IF;

Line 6749: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

6745: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6746: || ' :l_resource_req_tbl(i).usage_rate_or_amount--> :' ||l_resource_req_tbl(i).usage_rate_or_amount);
6747: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6748: || ' :l_txn_qty--> :' ||l_txn_qty);
6749: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6750: || ' :l_txn_qty--> :' ||l_pending_txn_qty);
6751: END IF;
6752:
6753: -- If the required qty is greater than zero then txn needs to be performed

Line 6799: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

6795:
6796: END LOOP; -- Iterate Requirements
6797:
6798: IF ( G_DEBUG = 'Y' ) THEN
6799: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6800: || ' : size of l_prd_resrc_txn_tbl is:' ||l_prd_resrc_txn_tbl.COUNT);
6801: END IF;
6802:
6803: --IF ( l_res_txn_tbl.COUNT > 0 ) THEN

Line 6848: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing UE Operations' );

6844:
6845: l_ctr := 0;
6846:
6847: IF ( G_DEBUG = 'Y' ) THEN
6848: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing UE Operations' );
6849: END IF;
6850:
6851: -- Get all the Workorder Operations for the UE
6852: FOR op_csr IN get_ue_operations( l_mr_rec.wip_entity_id ) LOOP

Line 6979: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

6975: END IF;
6976: /*End ER # 4757222*/
6977: /* Bug # 4955278 - end */
6978: IF ( G_DEBUG = 'Y' ) THEN
6979: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
6980: || ' : Wo Name - ' || l_operation_tbl(l_ctr).workorder_name
6981: || ' OP Seq - ' || op_csr.operation_seq_num || ' WO OP ID - '
6982: || l_operation_tbl(l_ctr).workorder_operation_id || ' Actual Start Date - '
6983: || TO_CHAR(l_operation_tbl(l_ctr).actual_start_date,'DD-MON-YYYY HH24:MI:SS') || ' Actual End Date - '

Line 7024: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

7020: FOR l_unassoc_ue_op_rec IN get_unassoc_ue_op( l_mr_rec.wip_entity_id )
7021: LOOP
7022:
7023: IF ( G_DEBUG = 'Y' ) THEN
7024: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
7025: || ' : Wo op id - ' ||l_unassoc_ue_op_rec.workorder_operation_id);
7026: END IF;
7027:
7028: IF ( p_signoff_mr_rec.complete_job_ops_flag = 'Y' ) THEN

Line 7150: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

7146: END IF;
7147: /* Bug # 4955278 - end */
7148:
7149: IF ( G_DEBUG = 'Y' ) THEN
7150: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
7151: || ' : Wo Name - ' || l_operation_tbl(l_ctr).workorder_name
7152: || ' OP Seq - ' || l_unassoc_ue_op_rec.operation_seq_num || ' WO OP ID - '
7153: || l_operation_tbl(l_ctr).workorder_operation_id || ' Actual Start Date - '
7154: || l_operation_tbl(l_ctr).actual_start_date || ' Actual End Date - '

Line 7177: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

7173: END IF; -- IF l_ctr = 0 THEN
7174: -- end of changes for bug 4087041
7175:
7176: IF ( G_DEBUG = 'Y' ) THEN
7177: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
7178: || ' : Before Updating Operations. Total - ' || l_operation_tbl.COUNT );
7179: END IF;
7180:
7181: -- R12

Line 7211: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

7207: END IF;
7208:
7209: --Balaji-debug
7210: IF ( G_DEBUG = 'Y' ) THEN
7211: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
7212: || ' : Actual start date - ' || to_char(l_operation_tbl(i).actual_start_date,'DD-MM-YYYY HH24:MI'));
7213: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
7214: || ' : Actual end date - ' || to_char(l_operation_tbl(i).actual_end_date,'DD-MM-YYYY HH24:MI'));
7215: END IF;

Line 7213: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

7209: --Balaji-debug
7210: IF ( G_DEBUG = 'Y' ) THEN
7211: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
7212: || ' : Actual start date - ' || to_char(l_operation_tbl(i).actual_start_date,'DD-MM-YYYY HH24:MI'));
7213: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
7214: || ' : Actual end date - ' || to_char(l_operation_tbl(i).actual_end_date,'DD-MM-YYYY HH24:MI'));
7215: END IF;
7216:
7217: l_operation_tbl(i).object_version_number := l_operation_tbl(i).object_version_number + 1;

Line 7223: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

7219: END IF;
7220: END IF;
7221:
7222: IF ( G_DEBUG = 'Y' ) THEN
7223: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
7224: || ' : Before Updating Workorders. Total - ' || l_workorder_tbl.COUNT );
7225: END IF;
7226:
7227:

Line 7229: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Completing Operations' );

7225: END IF;
7226:
7227:
7228: IF ( G_DEBUG = 'Y' ) THEN
7229: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Completing Operations' );
7230: END IF;
7231:
7232: -- Invoke Complete Operation API to Complete All Operations
7233: IF ( l_operation_tbl.COUNT > 0 ) THEN

Line 7237: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

7233: IF ( l_operation_tbl.COUNT > 0 ) THEN
7234: FOR i IN l_operation_tbl.FIRST..l_operation_tbl.LAST LOOP
7235:
7236: IF ( G_DEBUG = 'Y' ) THEN
7237: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
7238: || ' : Before Completing Operation - ' || l_operation_tbl(i).workorder_operation_id );
7239: END IF;
7240:
7241: -- R12

Line 7379: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Updating Master Workorders' );

7375: l_actual_start_date := p_signoff_mr_rec.actual_start_date;
7376: l_actual_end_date := p_signoff_mr_rec.actual_end_date;
7377: END IF;
7378: IF ( G_DEBUG = 'Y' ) THEN
7379: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Updating Master Workorders' );
7380: END IF;
7381:
7382: -- Update the Actual Dates for Master Workorders in the Visit
7383: l_return_status :=

Line 7402: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Completing WOs' );

7398: END IF;
7399:
7400:
7401: IF ( G_DEBUG = 'Y' ) THEN
7402: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Completing WOs' );
7403: END IF;
7404:
7405: -- Complete All MR Workorders in the Order of Completion Dependencies
7406: IF ( l_workorder_tbl.COUNT > 0 ) THEN

Line 7423: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Completing UEs' );

7419:
7420: END IF;
7421:
7422: IF ( G_DEBUG = 'Y' ) THEN
7423: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Completing UEs' );
7424: END IF;
7425:
7426: -- Invoke Complete MR Instance API to Complete All UEs
7427: IF ( l_child_mr_tbl.COUNT > 0 ) THEN

Line 7455: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

7451: RAISE FND_API.G_EXC_ERROR;
7452: END IF;
7453:
7454: IF ( G_DEBUG = 'Y' ) THEN
7455: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
7456: || ' : Before Completing MR - ' || l_child_mr_tbl(i).unit_effectivity_id );
7457: END IF;
7458:
7459: complete_mr_instance

Line 7484: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Recording Counter Readings' );

7480: END LOOP;
7481: END IF;
7482:
7483: IF ( G_DEBUG = 'Y' ) THEN
7484: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Recording Counter Readings' );
7485: END IF;
7486:
7487: -- Record Counter Readings for all WOs
7488: IF ( l_workorder_tbl.COUNT > 0 AND

Line 7543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

7539: --END IF;
7540: END IF;
7541:
7542: IF ( G_DEBUG = 'Y' ) THEN
7543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
7544: || ' : Before Firing QA Actions for UE, WO and OP' );
7545: END IF;
7546:
7547: -- Fire QA Actions for all UEs

Line 7639: AHL_DEBUG_PUB.disable_debug;

7635: END IF;
7636:
7637: -- Disable debug (if enabled)
7638: IF ( G_DEBUG = 'Y' ) THEN
7639: AHL_DEBUG_PUB.disable_debug;
7640: END IF;
7641:
7642: EXCEPTION
7643:

Line 7655: AHL_DEBUG_PUB.disable_debug;

7651: p_data => x_msg_data
7652: );
7653:
7654: IF ( G_DEBUG = 'Y' ) THEN
7655: AHL_DEBUG_PUB.disable_debug;
7656: END IF;
7657:
7658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7659: ROLLBACK TO signoff_mr_instance_PVT;

Line 7669: AHL_DEBUG_PUB.disable_debug;

7665: p_data => x_msg_data
7666: );
7667:
7668: IF ( G_DEBUG = 'Y' ) THEN
7669: AHL_DEBUG_PUB.disable_debug;
7670: END IF;
7671:
7672: WHEN OTHERS THEN
7673: ROLLBACK TO signoff_mr_instance_PVT;

Line 7692: AHL_DEBUG_PUB.disable_debug;

7688: p_data => x_msg_data
7689: );
7690:
7691: IF ( G_DEBUG = 'Y' ) THEN
7692: AHL_DEBUG_PUB.disable_debug;
7693: END IF;
7694: END signoff_mr_instance;
7695:
7696: PROCEDURE close_visit

Line 8041: AHL_DEBUG_PUB.enable_debug;

8037: BEGIN
8038:
8039: -- Enable Debug (optional)
8040: IF ( G_DEBUG = 'Y' ) THEN
8041: AHL_DEBUG_PUB.enable_debug;
8042: END IF;
8043:
8044: -- Initialize API return status to success
8045: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8056: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Validating Inputs' );

8052: FND_MSG_PUB.initialize;
8053: END IF;
8054:
8055: IF ( G_DEBUG = 'Y' ) THEN
8056: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Validating Inputs' );
8057: END IF;
8058:
8059: -- Validate all the inputs of the API
8060: l_return_status :=

Line 8073: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8070: END IF;
8071:
8072: IF ( G_DEBUG = 'Y' ) THEN
8073: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8074: || ' : Inputs - p_close_visit_rec.visit_id - ' || p_close_visit_rec.visit_id );
8075: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8076: || ' : Inputs - p_close_visit_rec.object_version_number - ' || p_close_visit_rec.object_version_number );
8077: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

Line 8075: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8071:
8072: IF ( G_DEBUG = 'Y' ) THEN
8073: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8074: || ' : Inputs - p_close_visit_rec.visit_id - ' || p_close_visit_rec.visit_id );
8075: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8076: || ' : Inputs - p_close_visit_rec.object_version_number - ' || p_close_visit_rec.object_version_number );
8077: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8078: || ' : Inputs - p_close_visit_rec.signoff_mrs_flag - ' || p_close_visit_rec.signoff_mrs_flag );
8079: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

Line 8077: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8073: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8074: || ' : Inputs - p_close_visit_rec.visit_id - ' || p_close_visit_rec.visit_id );
8075: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8076: || ' : Inputs - p_close_visit_rec.object_version_number - ' || p_close_visit_rec.object_version_number );
8077: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8078: || ' : Inputs - p_close_visit_rec.signoff_mrs_flag - ' || p_close_visit_rec.signoff_mrs_flag );
8079: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8080: || ' : Inputs - p_close_visit_rec.complete_job_ops_flag - ' || p_close_visit_rec.complete_job_ops_flag );
8081: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

Line 8079: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8075: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8076: || ' : Inputs - p_close_visit_rec.object_version_number - ' || p_close_visit_rec.object_version_number );
8077: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8078: || ' : Inputs - p_close_visit_rec.signoff_mrs_flag - ' || p_close_visit_rec.signoff_mrs_flag );
8079: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8080: || ' : Inputs - p_close_visit_rec.complete_job_ops_flag - ' || p_close_visit_rec.complete_job_ops_flag );
8081: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8082: || ' : Inputs - p_close_visit_rec.default_actual_dates_flag - '
8083: || p_close_visit_rec.default_actual_dates_flag );

Line 8081: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8077: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8078: || ' : Inputs - p_close_visit_rec.signoff_mrs_flag - ' || p_close_visit_rec.signoff_mrs_flag );
8079: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8080: || ' : Inputs - p_close_visit_rec.complete_job_ops_flag - ' || p_close_visit_rec.complete_job_ops_flag );
8081: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8082: || ' : Inputs - p_close_visit_rec.default_actual_dates_flag - '
8083: || p_close_visit_rec.default_actual_dates_flag );
8084: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8085: || ' : Inputs - p_close_visit_rec.actual_start_date - ' || p_close_visit_rec.actual_start_date );

Line 8084: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8080: || ' : Inputs - p_close_visit_rec.complete_job_ops_flag - ' || p_close_visit_rec.complete_job_ops_flag );
8081: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8082: || ' : Inputs - p_close_visit_rec.default_actual_dates_flag - '
8083: || p_close_visit_rec.default_actual_dates_flag );
8084: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8085: || ' : Inputs - p_close_visit_rec.actual_start_date - ' || p_close_visit_rec.actual_start_date );
8086: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8087: || ' : Inputs - p_close_visit_rec.actual_end_date - ' || p_close_visit_rec.actual_end_date );
8088: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

Line 8086: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8082: || ' : Inputs - p_close_visit_rec.default_actual_dates_flag - '
8083: || p_close_visit_rec.default_actual_dates_flag );
8084: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8085: || ' : Inputs - p_close_visit_rec.actual_start_date - ' || p_close_visit_rec.actual_start_date );
8086: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8087: || ' : Inputs - p_close_visit_rec.actual_end_date - ' || p_close_visit_rec.actual_end_date );
8088: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8089: || ' : Inputs - p_close_visit_rec.transact_resource_flag - '
8090: || p_close_visit_rec.transact_resource_flag );

Line 8088: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8084: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8085: || ' : Inputs - p_close_visit_rec.actual_start_date - ' || p_close_visit_rec.actual_start_date );
8086: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8087: || ' : Inputs - p_close_visit_rec.actual_end_date - ' || p_close_visit_rec.actual_end_date );
8088: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8089: || ' : Inputs - p_close_visit_rec.transact_resource_flag - '
8090: || p_close_visit_rec.transact_resource_flag );
8091: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8092: || ' : Inputs - p_close_visit_rec.employee_number - ' || p_close_visit_rec.employee_number );

Line 8091: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8087: || ' : Inputs - p_close_visit_rec.actual_end_date - ' || p_close_visit_rec.actual_end_date );
8088: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8089: || ' : Inputs - p_close_visit_rec.transact_resource_flag - '
8090: || p_close_visit_rec.transact_resource_flag );
8091: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8092: || ' : Inputs - p_close_visit_rec.employee_number - ' || p_close_visit_rec.employee_number );
8093: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8094: || ' : Inputs - p_close_visit_rec.serial_number - ' || p_close_visit_rec.serial_number );
8095: END IF;

Line 8093: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8089: || ' : Inputs - p_close_visit_rec.transact_resource_flag - '
8090: || p_close_visit_rec.transact_resource_flag );
8091: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8092: || ' : Inputs - p_close_visit_rec.employee_number - ' || p_close_visit_rec.employee_number );
8093: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8094: || ' : Inputs - p_close_visit_rec.serial_number - ' || p_close_visit_rec.serial_number );
8095: END IF;
8096:
8097: -- Invoke VWP Close Visit API if this is not a top-down signoff

Line 8103: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Not Top Down Signoff ' );

8099: p_close_visit_rec.complete_job_ops_flag = 'N' AND
8100: p_close_visit_rec.transact_resource_flag = 'N' ) THEN
8101:
8102: IF ( G_DEBUG = 'Y' ) THEN
8103: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Not Top Down Signoff ' );
8104: END IF;
8105:
8106: AHL_VWP_VISITS_PVT.close_visit
8107: (

Line 8132: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing Visit' );

8128:
8129: END IF;
8130:
8131: IF ( G_DEBUG = 'Y' ) THEN
8132: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing Visit' );
8133: END IF;
8134:
8135: -- Get the Visit Details
8136: OPEN get_visit_details( p_close_visit_rec.visit_id );

Line 8165: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing MRs in the Visit' );

8161: FND_MSG_PUB.add;
8162: END IF;
8163:
8164: IF ( G_DEBUG = 'Y' ) THEN
8165: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing MRs in the Visit' );
8166: END IF;
8167:
8168: -- Get all the Top UE Details for the Visit
8169: FOR mr_csr IN get_visit_ue_details( p_close_visit_rec.visit_id ) LOOP

Line 8289: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_ue_status_code '||l_ue_status_code );

8285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8286: END IF;
8287:
8288: IF ( G_DEBUG = 'Y' ) THEN
8289: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_ue_status_code '||l_ue_status_code );
8290: END IF;
8291: IF ( G_DEBUG = 'Y' ) THEN
8292: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8293: || ' : Child MR needs Signoff - ' || l_child_ue_tbl(l_ue_count).unit_effectivity_id );

Line 8292: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8288: IF ( G_DEBUG = 'Y' ) THEN
8289: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : l_ue_status_code '||l_ue_status_code );
8290: END IF;
8291: IF ( G_DEBUG = 'Y' ) THEN
8292: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8293: || ' : Child MR needs Signoff - ' || l_child_ue_tbl(l_ue_count).unit_effectivity_id );
8294: END IF;
8295: l_ctr := l_ctr + 1;
8296: l_child_mr_tbl(l_ctr).unit_effectivity_id := l_child_ue_tbl(l_ue_count).unit_effectivity_id;

Line 8310: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8306: -- Store the Top UEs in a table of records for Signing off
8307: IF ( nvl(mr_csr.ump_status_code,'x') <> nvl(G_MR_STATUS_SIGNED_OFF,'y') ) THEN
8308:
8309: IF ( G_DEBUG = 'Y' ) THEN
8310: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8311: || ' : Top MR needs Signoff - ' || mr_csr.unit_effectivity_id );
8312: END IF;
8313:
8314: l_ctr := l_ctr + 1;

Line 8345: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing Visit WOs' );

8341:
8342: l_ctr := 0;
8343:
8344: IF ( G_DEBUG = 'Y' ) THEN
8345: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing Visit WOs' );
8346: END IF;
8347:
8348: -- Get all the Workorders for the Visit
8349: FOR wo_csr IN get_visit_workorders( l_visit_rec.visit_id ) LOOP

Line 8511: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

8507: */
8508: /*End ER # 4757222*/
8509:
8510: IF ( G_DEBUG = 'Y' ) THEN
8511: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
8512: || ' : Wo Name - ' || l_workorder_tbl(l_ctr).workorder_name
8513: || ' WO ID - ' || l_workorder_tbl(l_ctr).workorder_id
8514: || ' Actual Start Date - ' || l_workorder_tbl(l_ctr).actual_start_date
8515: || ' Actual End Date - ' || l_workorder_tbl(l_ctr).actual_end_date );

Line 8540: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing Visit WO' );

8536: END IF;
8537: END LOOP;
8538:
8539: IF ( G_DEBUG = 'Y' ) THEN
8540: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing Visit WO' );
8541: END IF;
8542:
8543: -- Add the Visit Workorder for Updates
8544: -- Do not process Visit Workorder if it is already Complete

Line 8607: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing Resource Transactions' );

8603: */
8604: l_ctr := 0;
8605:
8606: IF ( G_DEBUG = 'Y' ) THEN
8607: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing Resource Transactions' );
8608: END IF;
8609:
8610: -- Check if Resource Transactions are required
8611: IF ( p_close_visit_rec.transact_resource_flag = 'Y' ) THEN

Line 8827: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing WO Operations' );

8823:
8824: l_ctr := 0;
8825:
8826: IF ( G_DEBUG = 'Y' ) THEN
8827: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Processing WO Operations' );
8828: END IF;
8829:
8830: -- Get all the Workorder Operations for the Visit
8831: FOR op_csr IN get_visit_operations( l_visit_rec.visit_id ) LOOP

Line 9005: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name

9001: END IF;
9002: */
9003:
9004: IF ( G_DEBUG = 'Y' ) THEN
9005: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name
9006: || ' : Wo Name - ' || l_operation_tbl(l_ctr).workorder_name
9007: || ' OP Seq - ' || op_csr.operation_seq_num || ' WO OP ID - '
9008: || l_operation_tbl(l_ctr).workorder_operation_id || ' Actual Start Date - '
9009: || l_operation_tbl(l_ctr).actual_start_date || ' Actual End Date - '

Line 9029: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Updating Operation Actual Dates' );

9025: END LOOP;
9026:
9027:
9028: IF ( G_DEBUG = 'Y' ) THEN
9029: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Updating Operation Actual Dates' );
9030: END IF;
9031:
9032: -- perform the Operation Updates
9033: -- If the dates are to be defaulted then this will be done in the Completions API itself

Line 9065: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Completing Operations' );

9061:
9062: END IF;
9063:
9064: IF ( G_DEBUG = 'Y' ) THEN
9065: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Completing Operations' );
9066: END IF;
9067:
9068: -- Invoke Complete Operation API to Complete All Operations
9069: IF ( l_operation_tbl.COUNT > 0 ) THEN

Line 9096: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Updating WO Actual Dates' );

9092: END LOOP;
9093: END IF;
9094:
9095: IF ( G_DEBUG = 'Y' ) THEN
9096: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Updating WO Actual Dates' );
9097: END IF;
9098:
9099: -- Perform the Workorder Updates
9100: -- After operation updates and operation completion

Line 9185: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Updating Actual Dates for Master WOs in Visit' );

9181: l_actual_end_date := p_close_visit_rec.actual_end_date;
9182: END IF;
9183:
9184: IF ( G_DEBUG = 'Y' ) THEN
9185: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Updating Actual Dates for Master WOs in Visit' );
9186: END IF;
9187:
9188: -- Update the Actual Dates for Master Workorders in the Visit
9189: l_return_status :=

Line 9208: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Completing WOs' );

9204: END IF;
9205:
9206:
9207: IF ( G_DEBUG = 'Y' ) THEN
9208: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Completing WOs' );
9209: END IF;
9210:
9211: -- Complete All Visit Workorders in the Order of Completion Dependencies
9212: IF ( l_workorder_tbl.COUNT > 0 ) THEN

Line 9229: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Signing off MRs' );

9225:
9226: END IF;
9227:
9228: IF ( G_DEBUG = 'Y' ) THEN
9229: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Signing off MRs' );
9230: END IF;
9231:
9232: -- Invoke Complete MR Instance API to Complete All UEs
9233: IF ( l_child_mr_tbl.COUNT > 0 ) THEN

Line 9293: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Closing Visit' );

9289: END LOOP;
9290: END IF;
9291:
9292: IF ( G_DEBUG = 'Y' ) THEN
9293: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Closing Visit' );
9294: END IF;
9295:
9296: -- Invoke close_visit API to close the Visit in VWP and Projects
9297: AHL_VWP_VISITS_PVT.close_visit

Line 9324: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Getting Counters' );

9320: G_CTR_READING_PLAN_ID IS NOT NULL AND
9321: l_visit_rec.item_instance_id IS NOT NULL ) THEN
9322:
9323: IF ( G_DEBUG = 'Y' ) THEN
9324: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Getting Counters' );
9325: END IF;
9326:
9327: -- Bug # 6750836 -- Start
9328:

Line 9332: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Recording WO Counter Readings' );

9328:
9329: --IF ( l_counter_tbl.COUNT > 0 ) THEN
9330:
9331: IF ( G_DEBUG = 'Y' ) THEN
9332: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Recording WO Counter Readings' );
9333: END IF;
9334:
9335: -- Record Counter Readings for all the Workorders.
9336: FOR i IN l_workorder_tbl.FIRST..l_workorder_tbl.LAST LOOP

Line 9382: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Firing QA Actions' );

9378: -- Bug # 6750836 -- end
9379: END IF;
9380:
9381: IF ( G_DEBUG = 'Y' ) THEN
9382: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Before Firing QA Actions' );
9383: END IF;
9384:
9385: -- Fire QA Actions for all MRs
9386: IF ( l_child_mr_tbl.COUNT > 0 ) THEN

Line 9476: AHL_DEBUG_PUB.disable_debug;

9472: END IF;
9473:
9474: -- Disable debug (if enabled)
9475: IF ( G_DEBUG = 'Y' ) THEN
9476: AHL_DEBUG_PUB.disable_debug;
9477: END IF;
9478:
9479: EXCEPTION
9480:

Line 9492: AHL_DEBUG_PUB.disable_debug;

9488: p_data => x_msg_data
9489: );
9490:
9491: IF ( G_DEBUG = 'Y' ) THEN
9492: AHL_DEBUG_PUB.disable_debug;
9493: END IF;
9494:
9495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9496: ROLLBACK TO close_visit_PVT;

Line 9506: AHL_DEBUG_PUB.disable_debug;

9502: p_data => x_msg_data
9503: );
9504:
9505: IF ( G_DEBUG = 'Y' ) THEN
9506: AHL_DEBUG_PUB.disable_debug;
9507: END IF;
9508:
9509: WHEN OTHERS THEN
9510: ROLLBACK TO close_visit_PVT;

Line 9529: AHL_DEBUG_PUB.disable_debug;

9525: p_data => x_msg_data
9526: );
9527:
9528: IF ( G_DEBUG = 'Y' ) THEN
9529: AHL_DEBUG_PUB.disable_debug;
9530: END IF;
9531: END close_visit;
9532:
9533: ------------------------------------------------------------------------------------------------

Line 10260: AHL_DEBUG_PUB.debug( 'Start complete_master_wo: Input Params:');

10256:
10257: BEGIN
10258:
10259: IF ( G_DEBUG = 'Y' ) THEN
10260: AHL_DEBUG_PUB.debug( 'Start complete_master_wo: Input Params:');
10261: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_visit_id:' || p_visit_id);
10262: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_ue_id:' || p_ue_id);
10263: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_workorder_id:' || p_workorder_id);
10264: END IF;

Line 10261: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_visit_id:' || p_visit_id);

10257: BEGIN
10258:
10259: IF ( G_DEBUG = 'Y' ) THEN
10260: AHL_DEBUG_PUB.debug( 'Start complete_master_wo: Input Params:');
10261: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_visit_id:' || p_visit_id);
10262: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_ue_id:' || p_ue_id);
10263: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_workorder_id:' || p_workorder_id);
10264: END IF;
10265:

Line 10262: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_ue_id:' || p_ue_id);

10258:
10259: IF ( G_DEBUG = 'Y' ) THEN
10260: AHL_DEBUG_PUB.debug( 'Start complete_master_wo: Input Params:');
10261: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_visit_id:' || p_visit_id);
10262: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_ue_id:' || p_ue_id);
10263: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_workorder_id:' || p_workorder_id);
10264: END IF;
10265:
10266: IF(p_visit_id IS NOT NULL) THEN

Line 10263: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_workorder_id:' || p_workorder_id);

10259: IF ( G_DEBUG = 'Y' ) THEN
10260: AHL_DEBUG_PUB.debug( 'Start complete_master_wo: Input Params:');
10261: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_visit_id:' || p_visit_id);
10262: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_ue_id:' || p_ue_id);
10263: AHL_DEBUG_PUB.debug( 'In complete_master_wo: p_workorder_id:' || p_workorder_id);
10264: END IF;
10265:
10266: IF(p_visit_id IS NOT NULL) THEN
10267: OPEN get_visit_master_wo(p_visit_id);

Line 10292: AHL_DEBUG_PUB.debug( 'In complete_master_wo: workorder_id:ovn:wip_entity_id:' || l_workorder_id

10288: RETURN FND_API.G_RET_STS_ERROR;
10289: END IF;
10290:
10291: IF ( G_DEBUG = 'Y' ) THEN
10292: AHL_DEBUG_PUB.debug( 'In complete_master_wo: workorder_id:ovn:wip_entity_id:' || l_workorder_id
10293: || ':' || l_ovn || ':' || l_wip_entity_id);
10294: END IF;
10295:
10296: -- Check if all workorders are cancelled.

Line 10301: AHL_DEBUG_PUB.debug('In complete_master_wo: processing for cancelled mwo');

10297: OPEN chk_cmplt_wo_exists(l_wip_entity_id);
10298: FETCH chk_cmplt_wo_exists INTO l_junk;
10299: IF (chk_cmplt_wo_exists%NOTFOUND) THEN
10300: IF ( G_DEBUG = 'Y' ) THEN
10301: AHL_DEBUG_PUB.debug('In complete_master_wo: processing for cancelled mwo');
10302: END IF;
10303:
10304: CLOSE chk_cmplt_wo_exists;
10305: -- all jobs cancelled.

Line 10387: AHL_DEBUG_PUB.debug('End complete_master_wo: l_return_status:' || l_return_status);

10383: END IF; -- l_workorder_id IS NOT NULL ..
10384: END IF; -- chk_cmplt_wo_exists%NOTFOUND
10385:
10386: IF ( G_DEBUG = 'Y' ) THEN
10387: AHL_DEBUG_PUB.debug('End complete_master_wo: l_return_status:' || l_return_status);
10388: END IF;
10389:
10390: RETURN l_return_status;
10391: