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_PRD_WORKORDER_PVT dependencies on AHL_DEBUG_PUB

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

1: PACKAGE BODY AHL_PRD_WORKORDER_PVT AS
2: /* $Header: AHLVPRJB.pls 120.32.12010000.5 2009/01/12 23:31:35 sikumar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_WORKORDER_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 143: AHL_DEBUG_PUB.debug( 'Debug Log Directory Path:'||x_output_dir );

139: x_debug_file_name := 'EAMDEBUG.log';
140: x_debug_file_mode := 'a';
141:
142: IF ( G_DEBUG = 'Y' ) THEN
143: AHL_DEBUG_PUB.debug( 'Debug Log Directory Path:'||x_output_dir );
144: AHL_DEBUG_PUB.debug( 'Debug Log File Name:'||x_debug_file_name );
145: END IF;
146:
147: END set_eam_debug_params;

Line 144: AHL_DEBUG_PUB.debug( 'Debug Log File Name:'||x_debug_file_name );

140: x_debug_file_mode := 'a';
141:
142: IF ( G_DEBUG = 'Y' ) THEN
143: AHL_DEBUG_PUB.debug( 'Debug Log Directory Path:'||x_output_dir );
144: AHL_DEBUG_PUB.debug( 'Debug Log File Name:'||x_debug_file_name );
145: END IF;
146:
147: END set_eam_debug_params;
148: -- End of Modification

Line 808: AHL_DEBUG_PUB.debug( 'p_x_prd_workorder_rec.SCHEDULED_START_DATE : ' || to_char(p_x_prd_workorder_rec.SCHEDULED_START_DATE,'DD-MON-YY hh24:mi:ss') );

804: p_date_ss => l_sec);
805:
806: END IF;
807: IF ( G_DEBUG = 'Y' ) THEN
808: AHL_DEBUG_PUB.debug( 'p_x_prd_workorder_rec.SCHEDULED_START_DATE : ' || to_char(p_x_prd_workorder_rec.SCHEDULED_START_DATE,'DD-MON-YY hh24:mi:ss') );
809: END IF;
810:
811: IF p_x_prd_workorder_rec.SCHEDULED_END_DATE IS NOT NULL AND
812: p_x_prd_workorder_rec.SCHEDULED_END_DATE <> FND_API.G_MISS_DATE

Line 835: AHL_DEBUG_PUB.debug( 'p_x_prd_workorder_rec.SCHEDULED_END_DATE : ' || to_char(p_x_prd_workorder_rec.SCHEDULED_END_DATE,'DD-MON-YY hh24:mi:ss') );

831:
832:
833: END IF;
834: IF ( G_DEBUG = 'Y' ) THEN
835: AHL_DEBUG_PUB.debug( 'p_x_prd_workorder_rec.SCHEDULED_END_DATE : ' || to_char(p_x_prd_workorder_rec.SCHEDULED_END_DATE,'DD-MON-YY hh24:mi:ss') );
836: END IF;
837: END IF; -- l_wo_status <> '17'
838:
839: -- portion of the code to get workorder seconds from the DB.

Line 862: AHL_DEBUG_PUB.debug( 'p_x_prd_workorder_rec.ACTUAL_START_DATE : ' || to_char(p_x_prd_workorder_rec.ACTUAL_START_DATE,'DD-MON-YY hh24:mi:ss') );

858: p_date_hh24 => p_x_prd_workorder_rec.ACTUAL_START_HR,
859: p_date_mi => p_x_prd_workorder_rec.ACTUAL_START_MI,
860: p_date_ss => l_sec);
861: IF ( G_DEBUG = 'Y' ) THEN
862: AHL_DEBUG_PUB.debug( 'p_x_prd_workorder_rec.ACTUAL_START_DATE : ' || to_char(p_x_prd_workorder_rec.ACTUAL_START_DATE,'DD-MON-YY hh24:mi:ss') );
863: END IF;
864:
865: END IF;
866:

Line 883: AHL_DEBUG_PUB.debug( 'p_x_prd_workorder_rec.ACTUAL_START_DATE : ' || to_char(p_x_prd_workorder_rec.ACTUAL_END_DATE,'DD-MON-YY hh24:mi:ss') );

879: p_date_hh24 => p_x_prd_workorder_rec.ACTUAL_END_HR,
880: p_date_mi => p_x_prd_workorder_rec.ACTUAL_END_MI,
881: p_date_ss => l_sec);
882: IF ( G_DEBUG = 'Y' ) THEN
883: AHL_DEBUG_PUB.debug( 'p_x_prd_workorder_rec.ACTUAL_START_DATE : ' || to_char(p_x_prd_workorder_rec.ACTUAL_END_DATE,'DD-MON-YY hh24:mi:ss') );
884: END IF;
885:
886: END IF;
887:

Line 1612: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'p_object_id:' || p_object_id );

1608:
1609: BEGIN
1610:
1611: IF ( G_DEBUG = 'Y' ) THEN
1612: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'p_object_id:' || p_object_id );
1613: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'p_association_type:' || p_association_type);
1614: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'p_organization_id:' || p_organization_id);
1615: END IF;
1616:

Line 1613: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'p_association_type:' || p_association_type);

1609: BEGIN
1610:
1611: IF ( G_DEBUG = 'Y' ) THEN
1612: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'p_object_id:' || p_object_id );
1613: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'p_association_type:' || p_association_type);
1614: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'p_organization_id:' || p_organization_id);
1615: END IF;
1616:
1617: l_final_department_id := NULL;

Line 1614: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'p_organization_id:' || p_organization_id);

1610:
1611: IF ( G_DEBUG = 'Y' ) THEN
1612: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'p_object_id:' || p_object_id );
1613: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'p_association_type:' || p_association_type);
1614: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'p_organization_id:' || p_organization_id);
1615: END IF;
1616:
1617: l_final_department_id := NULL;
1618: x_object_resource_found := 'N';

Line 1626: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'Found Route/Oper Res:' || l_rt_oper_resource_rec.aso_resource_id );

1622: FETCH get_rt_oper_resources INTO l_rt_oper_resource_rec;
1623: EXIT WHEN get_rt_oper_resources%NOTFOUND;
1624:
1625: IF ( G_DEBUG = 'Y' ) THEN
1626: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'Found Route/Oper Res:' || l_rt_oper_resource_rec.aso_resource_id );
1627: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'Resource Name:' || l_rt_oper_resource_rec.name);
1628: END IF;
1629:
1630: -- Atleast one Resource Requirement Found for the Route

Line 1627: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'Resource Name:' || l_rt_oper_resource_rec.name);

1623: EXIT WHEN get_rt_oper_resources%NOTFOUND;
1624:
1625: IF ( G_DEBUG = 'Y' ) THEN
1626: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'Found Route/Oper Res:' || l_rt_oper_resource_rec.aso_resource_id );
1627: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'Resource Name:' || l_rt_oper_resource_rec.name);
1628: END IF;
1629:
1630: -- Atleast one Resource Requirement Found for the Route
1631: x_object_resource_found := 'Y';

Line 1641: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_return_status:' || l_return_status );

1637: l_department_id,
1638: l_department_name,
1639: l_return_status);
1640: IF ( G_DEBUG = 'Y' ) THEN
1641: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_return_status:' || l_return_status );
1642: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_department_id:' || l_department_id);
1643: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_department_name:' || l_department_name);
1644: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_final_department_id:' || l_final_department_id);
1645: END IF;

Line 1642: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_department_id:' || l_department_id);

1638: l_department_name,
1639: l_return_status);
1640: IF ( G_DEBUG = 'Y' ) THEN
1641: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_return_status:' || l_return_status );
1642: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_department_id:' || l_department_id);
1643: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_department_name:' || l_department_name);
1644: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_final_department_id:' || l_final_department_id);
1645: END IF;
1646:

Line 1643: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_department_name:' || l_department_name);

1639: l_return_status);
1640: IF ( G_DEBUG = 'Y' ) THEN
1641: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_return_status:' || l_return_status );
1642: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_department_id:' || l_department_id);
1643: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_department_name:' || l_department_name);
1644: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_final_department_id:' || l_final_department_id);
1645: END IF;
1646:
1647: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1644: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_final_department_id:' || l_final_department_id);

1640: IF ( G_DEBUG = 'Y' ) THEN
1641: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_return_status:' || l_return_status );
1642: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_department_id:' || l_department_id);
1643: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_department_name:' || l_department_name);
1644: AHL_DEBUG_PUB.debug( 'Get_Default_Rt_Op_dept-'|| 'l_final_department_id:' || l_final_department_id);
1645: END IF;
1646:
1647: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1648: RAISE FND_API.G_EXC_ERROR;

Line 2746: AHL_DEBUG_PUB.debug( 'Get_Operations'|| ' - Before Get_Default_Rt_Op_dept' );

2742: -- Added for FP bug# 7238868
2743: IF (p_workorder_rec.ROUTE_ID IS NOT NULL ) THEN
2744:
2745: IF ( G_DEBUG = 'Y' ) THEN
2746: AHL_DEBUG_PUB.debug( 'Get_Operations'|| ' - Before Get_Default_Rt_Op_dept' );
2747: END IF;
2748:
2749: -- Get default department from route/oper resources.
2750: Get_Default_Rt_Op_dept(p_object_id => p_workorder_rec.ROUTE_ID,

Line 2759: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );

2755: x_department_name => l_department_name,
2756: x_object_resource_found => l_route_found);
2757:
2758: IF ( G_DEBUG = 'Y' ) THEN
2759: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );
2760: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);
2761: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_name:' || l_department_name);
2762: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_route_found:' || l_route_found);
2763: END IF;

Line 2760: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);

2756: x_object_resource_found => l_route_found);
2757:
2758: IF ( G_DEBUG = 'Y' ) THEN
2759: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );
2760: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);
2761: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_name:' || l_department_name);
2762: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_route_found:' || l_route_found);
2763: END IF;
2764:

Line 2761: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_name:' || l_department_name);

2757:
2758: IF ( G_DEBUG = 'Y' ) THEN
2759: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );
2760: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);
2761: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_name:' || l_department_name);
2762: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_route_found:' || l_route_found);
2763: END IF;
2764:
2765: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2762: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_route_found:' || l_route_found);

2758: IF ( G_DEBUG = 'Y' ) THEN
2759: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );
2760: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);
2761: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_name:' || l_department_name);
2762: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_route_found:' || l_route_found);
2763: END IF;
2764:
2765: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2766: RAISE FND_API.G_EXC_ERROR;

Line 2790: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );

2786: x_department_name => l_department_name,
2787: x_object_resource_found => l_oper_found);
2788:
2789: IF ( G_DEBUG = 'Y' ) THEN
2790: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );
2791: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);
2792: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_name:' || l_department_name);
2793: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_oper_found:' || l_oper_found);
2794: END IF;

Line 2791: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);

2787: x_object_resource_found => l_oper_found);
2788:
2789: IF ( G_DEBUG = 'Y' ) THEN
2790: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );
2791: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);
2792: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_name:' || l_department_name);
2793: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_oper_found:' || l_oper_found);
2794: END IF;
2795:

Line 2792: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_name:' || l_department_name);

2788:
2789: IF ( G_DEBUG = 'Y' ) THEN
2790: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );
2791: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);
2792: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_name:' || l_department_name);
2793: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_oper_found:' || l_oper_found);
2794: END IF;
2795:
2796: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2793: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_oper_found:' || l_oper_found);

2789: IF ( G_DEBUG = 'Y' ) THEN
2790: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );
2791: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);
2792: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_name:' || l_department_name);
2793: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_oper_found:' || l_oper_found);
2794: END IF;
2795:
2796: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2797: RAISE FND_API.G_EXC_ERROR;

Line 2895: AHL_DEBUG_PUB.enable_debug;

2891:
2892: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2893:
2894: IF G_DEBUG='Y' THEN
2895: AHL_DEBUG_PUB.enable_debug;
2896: END IF;
2897:
2898: -- User Hooks
2899: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'CREATE_JOB', 'B', 'C' )) then

Line 2913: AHL_DEBUG_PUB.debug( l_api_name || ' - Before validate_workorder' );

2909: END IF;
2910: END IF;
2911:
2912: IF ( G_DEBUG = 'Y' ) THEN
2913: AHL_DEBUG_PUB.debug( l_api_name || ' - Before validate_workorder' );
2914: END IF;
2915:
2916: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
2917: validate_workorder

Line 2931: AHL_DEBUG_PUB.debug( l_api_name || ' - Before default_attributes' );

2927: END IF;
2928: END IF;
2929:
2930: IF ( G_DEBUG = 'Y' ) THEN
2931: AHL_DEBUG_PUB.debug( l_api_name || ' - Before default_attributes' );
2932: END IF;
2933:
2934: default_attributes
2935: (

Line 2940: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Insert into AHL_WORKORDERS' );

2936: p_x_prd_workorder_rec =>p_x_prd_workorder_rec
2937: );
2938:
2939: IF ( G_DEBUG = 'Y' ) THEN
2940: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Insert into AHL_WORKORDERS' );
2941: END IF;
2942:
2943: -- Begin OGMA Issue # 105 - Balaji
2944: -- update VWP planned task quantity current instance quantity

Line 3047: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Insert into AHL_WORKORDER_TXNS' );

3043: p_x_prd_workorder_rec.ATTRIBUTE15
3044: );
3045:
3046: IF ( G_DEBUG = 'Y' ) THEN
3047: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Insert into AHL_WORKORDER_TXNS' );
3048: END IF;
3049:
3050: INSERT INTO AHL_WORKORDER_TXNS
3051: (

Line 3127: AHL_DEBUG_PUB.debug( l_api_name || ' - Before get_operations. Route ID: '|| p_x_prd_workorder_rec.route_id );

3123:
3124: IF ( p_x_prd_workorder_rec.master_workorder_flag = 'N' ) THEN
3125:
3126: IF ( G_DEBUG = 'Y' ) THEN
3127: AHL_DEBUG_PUB.debug( l_api_name || ' - Before get_operations. Route ID: '|| p_x_prd_workorder_rec.route_id );
3128: END IF;
3129:
3130: get_operations
3131: (

Line 3137: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations . Total Operations : '|| x_operation_tbl.COUNT );

3133: p_x_operations_tbl => x_operation_tbl
3134: );
3135:
3136: IF ( G_DEBUG = 'Y' ) THEN
3137: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations . Total Operations : '|| x_operation_tbl.COUNT );
3138: END IF;
3139:
3140: AHL_PRD_OPERATIONS_PVT.process_operations
3141: (

Line 3162: AHL_DEBUG_PUB.debug( l_api_name || ' - Before get_rt_resource_req' );

3158:
3159: IF ( p_x_prd_workorder_rec.route_id IS NOT NULL ) THEN
3160:
3161: IF ( G_DEBUG = 'Y' ) THEN
3162: AHL_DEBUG_PUB.debug( l_api_name || ' - Before get_rt_resource_req' );
3163: END IF;
3164:
3165: get_rt_resource_req
3166: (

Line 3175: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );

3171:
3172: IF ( x_resource_tbl.COUNT > 0 ) THEN
3173:
3174: IF ( G_DEBUG = 'Y' ) THEN
3175: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );
3176: END IF;
3177:
3178: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require
3179: (

Line 3199: AHL_DEBUG_PUB.debug( l_api_name || ' - Before get_rt_material_req' );

3195: END IF;
3196: END IF;
3197:
3198: IF ( G_DEBUG = 'Y' ) THEN
3199: AHL_DEBUG_PUB.debug( l_api_name || ' - Before get_rt_material_req' );
3200: END IF;
3201: --Code changes made by Srini
3202:
3203: AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials

Line 3222: AHL_DEBUG_PUB.debug( l_api_name || ' - After AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials' );

3218: RAISE FND_API.G_EXC_ERROR;
3219: END IF;
3220:
3221: IF ( G_DEBUG = 'Y' ) THEN
3222: AHL_DEBUG_PUB.debug( l_api_name || ' - After AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials' );
3223: END IF;
3224:
3225: END IF;
3226:

Line 3232: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_EAM_JOB_PVT.create_eam_workorder' );

3228:
3229: IF ( p_wip_load_flag = 'Y' ) THEN
3230:
3231: IF ( G_DEBUG = 'Y' ) THEN
3232: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_EAM_JOB_PVT.create_eam_workorder' );
3233: END IF;
3234:
3235: AHL_EAM_JOB_PVT.create_eam_workorder
3236: (

Line 3257: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Update AHL_WORKORDERS with wip_entity_id' );

3253: RAISE FND_API.G_EXC_ERROR;
3254: ELSE
3255:
3256: IF ( G_DEBUG = 'Y' ) THEN
3257: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Update AHL_WORKORDERS with wip_entity_id' );
3258: END IF;
3259:
3260: UPDATE AHL_WORKORDERS
3261: SET wip_entity_id = p_x_prd_workorder_rec.wip_entity_id

Line 3289: AHL_DEBUG_PUB.debug( l_api_name || ' - Success' );

3285: END IF;
3286: END IF;
3287:
3288: IF ( G_DEBUG = 'Y' ) THEN
3289: AHL_DEBUG_PUB.debug( l_api_name || ' - Success' );
3290: END IF;
3291:
3292: IF G_DEBUG='Y' THEN
3293: AHL_DEBUG_PUB.disable_debug;

Line 3293: AHL_DEBUG_PUB.disable_debug;

3289: AHL_DEBUG_PUB.debug( l_api_name || ' - Success' );
3290: END IF;
3291:
3292: IF G_DEBUG='Y' THEN
3293: AHL_DEBUG_PUB.disable_debug;
3294: END IF;
3295:
3296: EXCEPTION
3297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3565: AHL_DEBUG_PUB.enable_debug;

3561:
3562: x_return_status:=FND_API.G_RET_STS_SUCCESS;
3563:
3564: IF G_DEBUG='Y' THEN
3565: AHL_DEBUG_PUB.enable_debug;
3566: END IF;
3567:
3568: IF ( G_DEBUG = 'Y' ) THEN
3569: AHL_DEBUG_PUB.debug( l_api_name || ' - Before default_missing_attributes' );

Line 3569: AHL_DEBUG_PUB.debug( l_api_name || ' - Before default_missing_attributes' );

3565: AHL_DEBUG_PUB.enable_debug;
3566: END IF;
3567:
3568: IF ( G_DEBUG = 'Y' ) THEN
3569: AHL_DEBUG_PUB.debug( l_api_name || ' - Before default_missing_attributes' );
3570: END IF;
3571: --Modified by Srini
3572: /*IF p_module_type = 'API'
3573: THEN

Line 3610: AHL_DEBUG_PUB.debug( l_api_name || ' - Before convert_values_to_ids' );

3606:
3607: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
3608:
3609: IF ( G_DEBUG = 'Y' ) THEN
3610: AHL_DEBUG_PUB.debug( l_api_name || ' - Before convert_values_to_ids' );
3611: END IF;
3612:
3613: convert_values_to_ids
3614: (

Line 3629: AHL_DEBUG_PUB.debug( l_api_name || ' - Before validate_workorder' );

3625:
3626: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
3627:
3628: IF ( G_DEBUG = 'Y' ) THEN
3629: AHL_DEBUG_PUB.debug( l_api_name || ' - Before validate_workorder' );
3630: END IF;
3631:
3632: validate_workorder
3633: (

Line 3695: AHL_DEBUG_PUB.debug( l_api_name || ' Before - AHL_PRD_WO_LOGIN_PVT.Workorder_Logout');

3691: -- Log all technicians out of the workorder being cancelled.
3692: IF (p_x_prd_workorder_rec.status_code IN (G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
3693: G_JOB_STATUS_CANCELLED)) THEN
3694: IF ( G_DEBUG = 'Y' ) THEN
3695: AHL_DEBUG_PUB.debug( l_api_name || ' Before - AHL_PRD_WO_LOGIN_PVT.Workorder_Logout');
3696: AHL_DEBUG_PUB.debug( 'Workorder Status:' || p_x_prd_workorder_rec.status_code);
3697: END IF;
3698:
3699: OPEN c_get_login_recs(p_x_prd_workorder_rec.workorder_id);

Line 3696: AHL_DEBUG_PUB.debug( 'Workorder Status:' || p_x_prd_workorder_rec.status_code);

3692: IF (p_x_prd_workorder_rec.status_code IN (G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
3693: G_JOB_STATUS_CANCELLED)) THEN
3694: IF ( G_DEBUG = 'Y' ) THEN
3695: AHL_DEBUG_PUB.debug( l_api_name || ' Before - AHL_PRD_WO_LOGIN_PVT.Workorder_Logout');
3696: AHL_DEBUG_PUB.debug( 'Workorder Status:' || p_x_prd_workorder_rec.status_code);
3697: END IF;
3698:
3699: OPEN c_get_login_recs(p_x_prd_workorder_rec.workorder_id);
3700: LOOP

Line 3722: AHL_DEBUG_PUB.debug( l_api_name || ' Before - AHL_PRD_WO_LOGIN_PVT.Workorder_Logout');

3718: END LOOP;
3719: CLOSE c_get_login_recs;
3720:
3721: IF ( G_DEBUG = 'Y' ) THEN
3722: AHL_DEBUG_PUB.debug( l_api_name || ' Before - AHL_PRD_WO_LOGIN_PVT.Workorder_Logout');
3723: AHL_DEBUG_PUB.debug( 'Return Status:' || l_return_status);
3724: END IF;
3725:
3726: END IF; -- p_x_prd_workorder_rec.STATUS_CODE

Line 3723: AHL_DEBUG_PUB.debug( 'Return Status:' || l_return_status);

3719: CLOSE c_get_login_recs;
3720:
3721: IF ( G_DEBUG = 'Y' ) THEN
3722: AHL_DEBUG_PUB.debug( l_api_name || ' Before - AHL_PRD_WO_LOGIN_PVT.Workorder_Logout');
3723: AHL_DEBUG_PUB.debug( 'Return Status:' || l_return_status);
3724: END IF;
3725:
3726: END IF; -- p_x_prd_workorder_rec.STATUS_CODE
3727:

Line 3739: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Updating AHL_WORKORDERS' );

3735: p_x_prd_workorder_rec.HOLD_REASON_CODE := NULL;
3736: END IF;
3737:
3738: IF ( G_DEBUG = 'Y' ) THEN
3739: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Updating AHL_WORKORDERS' );
3740: END IF;
3741:
3742: -- Begin OGMA Issue # 105 - Balaji
3743: -- update VWP planned task quantity current instance quantity

Line 3813: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_TXNS' );

3809: RAISE FND_API.G_EXC_ERROR;
3810: END IF;
3811:
3812: IF ( G_DEBUG = 'Y' ) THEN
3813: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_TXNS' );
3814: END IF;
3815:
3816: INSERT INTO AHL_WORKORDER_TXNS
3817: (

Line 3888: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'dept id:' || p_x_prd_workorder_rec.department_id);

3884: FETCH get_operation_details INTO p_x_prd_workoper_tbl(i).operation_id;
3885: CLOSE get_operation_details;
3886:
3887: IF ( G_DEBUG = 'Y' ) THEN
3888: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'dept id:' || p_x_prd_workorder_rec.department_id);
3889: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'dept ID(Oper):' || p_x_prd_workoper_tbl(i).DEPARTMENT_ID);
3890: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'deptnameD(Oper):' || p_x_prd_workoper_tbl(i).DEPARTMENT_NAME);
3891:
3892: END IF;

Line 3889: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'dept ID(Oper):' || p_x_prd_workoper_tbl(i).DEPARTMENT_ID);

3885: CLOSE get_operation_details;
3886:
3887: IF ( G_DEBUG = 'Y' ) THEN
3888: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'dept id:' || p_x_prd_workorder_rec.department_id);
3889: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'dept ID(Oper):' || p_x_prd_workoper_tbl(i).DEPARTMENT_ID);
3890: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'deptnameD(Oper):' || p_x_prd_workoper_tbl(i).DEPARTMENT_NAME);
3891:
3892: END IF;
3893:

Line 3890: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'deptnameD(Oper):' || p_x_prd_workoper_tbl(i).DEPARTMENT_NAME);

3886:
3887: IF ( G_DEBUG = 'Y' ) THEN
3888: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'dept id:' || p_x_prd_workorder_rec.department_id);
3889: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'dept ID(Oper):' || p_x_prd_workoper_tbl(i).DEPARTMENT_ID);
3890: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'deptnameD(Oper):' || p_x_prd_workoper_tbl(i).DEPARTMENT_NAME);
3891:
3892: END IF;
3893:
3894: --IF (p_x_prd_workoper_tbl(i).DEPARTMENT_ID = p_x_prd_workorder_rec.department_id) THEN

Line 3905: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );

3901: x_department_name => l_department_name,
3902: x_object_resource_found => l_oper_found);
3903:
3904: IF ( G_DEBUG = 'Y' ) THEN
3905: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );
3906: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);
3907: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_oper_found:' || l_oper_found);
3908: END IF;
3909:

Line 3906: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);

3902: x_object_resource_found => l_oper_found);
3903:
3904: IF ( G_DEBUG = 'Y' ) THEN
3905: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );
3906: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);
3907: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_oper_found:' || l_oper_found);
3908: END IF;
3909:
3910: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3907: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_oper_found:' || l_oper_found);

3903:
3904: IF ( G_DEBUG = 'Y' ) THEN
3905: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_return_status:' || l_return_status );
3906: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_department_id:' || l_department_id);
3907: AHL_DEBUG_PUB.debug( 'Get_Operations'|| 'l_oper_found:' || l_oper_found);
3908: END IF;
3909:
3910: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3911: RAISE FND_API.G_EXC_ERROR;

Line 3965: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations' );

3961:
3962: END LOOP;
3963:
3964: IF ( G_DEBUG = 'Y' ) THEN
3965: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PRD_OPERATIONS_PVT.process_operations' );
3966: END IF;
3967:
3968: AHL_PRD_OPERATIONS_PVT.process_operations
3969: (

Line 3990: AHL_DEBUG_PUB.debug( l_api_name || ' - Before get_op_resource_req' );

3986:
3987: IF ( p_wip_load_flag = 'Y' ) THEN
3988:
3989: IF ( G_DEBUG = 'Y' ) THEN
3990: AHL_DEBUG_PUB.debug( l_api_name || ' - Before get_op_resource_req' );
3991: END IF;
3992:
3993: -- Get the Resource Requirements for New Operations
3994: get_op_resource_req

Line 4002: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );

3998: p_x_resource_tbl => l_resource_tbl
3999: );
4000:
4001: IF ( G_DEBUG = 'Y' ) THEN
4002: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );
4003: END IF;
4004:
4005: IF ( l_resource_tbl.COUNT > 0 ) THEN
4006: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require

Line 4027: AHL_DEBUG_PUB.debug( l_api_name || ' - Before get_op_material_req' );

4023: END IF;
4024: END IF;
4025:
4026: IF ( G_DEBUG = 'Y' ) THEN
4027: AHL_DEBUG_PUB.debug( l_api_name || ' - Before get_op_material_req' );
4028: END IF;
4029:
4030: -- Get the Material Requirements for New Operations
4031: get_op_material_req

Line 4039: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_MATERIALS_PVT.create_material_reqst' );

4035: p_x_material_tbl => l_material_tbl
4036: );
4037:
4038: IF ( G_DEBUG = 'Y' ) THEN
4039: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_MATERIALS_PVT.create_material_reqst' );
4040: END IF;
4041:
4042: IF ( l_material_tbl.COUNT > 0 ) THEN
4043: AHL_PP_MATERIALS_PVT.create_material_reqst

Line 4069: AHL_DEBUG_PUB.debug( l_api_name || ' - Getting parent_workorders' );

4065:
4066: IF ( p_wip_load_flag = 'Y' ) THEN
4067:
4068: IF ( G_DEBUG = 'Y' ) THEN
4069: AHL_DEBUG_PUB.debug( l_api_name || ' - Getting parent_workorders' );
4070: END IF;
4071:
4072: FOR parent_csr IN get_parent_workorders( p_x_prd_workorder_rec.wip_entity_id ) LOOP
4073: l_parent_workorder_rec.workorder_id := parent_csr.workorder_id;

Line 4077: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder_id :' || l_parent_workorder_rec.workorder_id );

4073: l_parent_workorder_rec.workorder_id := parent_csr.workorder_id;
4074: l_parent_workorder_rec.object_version_number := parent_csr.object_version_number;
4075:
4076: IF ( G_DEBUG = 'Y' ) THEN
4077: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder_id :' || l_parent_workorder_rec.workorder_id );
4078: END IF;
4079:
4080: FOR child_csr IN get_child_workorders( parent_csr.wip_entity_id ) LOOP
4081:

Line 4202: AHL_DEBUG_PUB.debug( l_api_name || ' - Before update_job for parent workorder' );

4198: l_parent_workorder_rec.status_code := parent_csr.status_code;
4199: END IF;
4200:
4201: IF ( G_DEBUG = 'Y' ) THEN
4202: AHL_DEBUG_PUB.debug( l_api_name || ' - Before update_job for parent workorder' );
4203: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-status_code: '|| l_parent_workorder_rec.status_code );
4204: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_start_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_start_date , 'DD-MON-YYYY HH24:MI' ) );
4205: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_end_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_end_date , 'DD-MON-YYYY HH24:MI' ) );
4206: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_start_date: '|| TO_CHAR(l_parent_workorder_rec.actual_start_date , 'DD-MON-YYYY HH24:MI' ) );

Line 4203: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-status_code: '|| l_parent_workorder_rec.status_code );

4199: END IF;
4200:
4201: IF ( G_DEBUG = 'Y' ) THEN
4202: AHL_DEBUG_PUB.debug( l_api_name || ' - Before update_job for parent workorder' );
4203: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-status_code: '|| l_parent_workorder_rec.status_code );
4204: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_start_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_start_date , 'DD-MON-YYYY HH24:MI' ) );
4205: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_end_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_end_date , 'DD-MON-YYYY HH24:MI' ) );
4206: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_start_date: '|| TO_CHAR(l_parent_workorder_rec.actual_start_date , 'DD-MON-YYYY HH24:MI' ) );
4207: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_end_date: '|| TO_CHAR(l_parent_workorder_rec.actual_end_date , 'DD-MON-YYYY HH24:MI' ) );

Line 4204: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_start_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_start_date , 'DD-MON-YYYY HH24:MI' ) );

4200:
4201: IF ( G_DEBUG = 'Y' ) THEN
4202: AHL_DEBUG_PUB.debug( l_api_name || ' - Before update_job for parent workorder' );
4203: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-status_code: '|| l_parent_workorder_rec.status_code );
4204: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_start_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_start_date , 'DD-MON-YYYY HH24:MI' ) );
4205: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_end_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_end_date , 'DD-MON-YYYY HH24:MI' ) );
4206: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_start_date: '|| TO_CHAR(l_parent_workorder_rec.actual_start_date , 'DD-MON-YYYY HH24:MI' ) );
4207: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_end_date: '|| TO_CHAR(l_parent_workorder_rec.actual_end_date , 'DD-MON-YYYY HH24:MI' ) );
4208: END IF;

Line 4205: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_end_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_end_date , 'DD-MON-YYYY HH24:MI' ) );

4201: IF ( G_DEBUG = 'Y' ) THEN
4202: AHL_DEBUG_PUB.debug( l_api_name || ' - Before update_job for parent workorder' );
4203: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-status_code: '|| l_parent_workorder_rec.status_code );
4204: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_start_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_start_date , 'DD-MON-YYYY HH24:MI' ) );
4205: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_end_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_end_date , 'DD-MON-YYYY HH24:MI' ) );
4206: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_start_date: '|| TO_CHAR(l_parent_workorder_rec.actual_start_date , 'DD-MON-YYYY HH24:MI' ) );
4207: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_end_date: '|| TO_CHAR(l_parent_workorder_rec.actual_end_date , 'DD-MON-YYYY HH24:MI' ) );
4208: END IF;
4209:

Line 4206: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_start_date: '|| TO_CHAR(l_parent_workorder_rec.actual_start_date , 'DD-MON-YYYY HH24:MI' ) );

4202: AHL_DEBUG_PUB.debug( l_api_name || ' - Before update_job for parent workorder' );
4203: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-status_code: '|| l_parent_workorder_rec.status_code );
4204: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_start_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_start_date , 'DD-MON-YYYY HH24:MI' ) );
4205: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_end_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_end_date , 'DD-MON-YYYY HH24:MI' ) );
4206: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_start_date: '|| TO_CHAR(l_parent_workorder_rec.actual_start_date , 'DD-MON-YYYY HH24:MI' ) );
4207: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_end_date: '|| TO_CHAR(l_parent_workorder_rec.actual_end_date , 'DD-MON-YYYY HH24:MI' ) );
4208: END IF;
4209:
4210: -- Bug # 7643668 (FP for Bug # 6493302) -- start

Line 4207: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_end_date: '|| TO_CHAR(l_parent_workorder_rec.actual_end_date , 'DD-MON-YYYY HH24:MI' ) );

4203: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-status_code: '|| l_parent_workorder_rec.status_code );
4204: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_start_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_start_date , 'DD-MON-YYYY HH24:MI' ) );
4205: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-scheduled_end_date: '|| TO_CHAR(l_parent_workorder_rec.scheduled_end_date , 'DD-MON-YYYY HH24:MI' ) );
4206: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_start_date: '|| TO_CHAR(l_parent_workorder_rec.actual_start_date , 'DD-MON-YYYY HH24:MI' ) );
4207: AHL_DEBUG_PUB.debug( l_api_name || ' - parent workorder-actual_end_date: '|| TO_CHAR(l_parent_workorder_rec.actual_end_date , 'DD-MON-YYYY HH24:MI' ) );
4208: END IF;
4209:
4210: -- Bug # 7643668 (FP for Bug # 6493302) -- start
4211: -- Unless any of scheduled date, actual date or status changes for a

Line 4276: AHL_DEBUG_PUB.debug( l_api_name || ' - update_job for parent_workorder successful' );

4272: RAISE FND_API.G_EXC_ERROR;
4273: END IF;
4274:
4275: IF ( G_DEBUG = 'Y' ) THEN
4276: AHL_DEBUG_PUB.debug( l_api_name || ' - update_job for parent_workorder successful' );
4277: END IF;
4278:
4279: END IF;
4280: -- Bug # 7643668 (FP for Bug # 6493302) -- end

Line 4284: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_EAM_JOB_PVT.update_job_operations' );

4280: -- Bug # 7643668 (FP for Bug # 6493302) -- end
4281: END LOOP;
4282:
4283: IF ( G_DEBUG = 'Y' ) THEN
4284: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_EAM_JOB_PVT.update_job_operations' );
4285: END IF;
4286:
4287: AHL_EAM_JOB_PVT.update_job_operations
4288: (

Line 4309: AHL_DEBUG_PUB.debug( l_api_name || ' - AHL_EAM_JOB_PVT.update_job_operations succesful' );

4305: RAISE FND_API.G_EXC_ERROR;
4306: END IF;
4307:
4308: IF ( G_DEBUG = 'Y' ) THEN
4309: AHL_DEBUG_PUB.debug( l_api_name || ' - AHL_EAM_JOB_PVT.update_job_operations succesful' );
4310: END IF;
4311:
4312: END IF; -- For WIP Load Flag
4313:

Line 4319: AHL_DEBUG_PUB.debug( l_api_name || ' Before - AHL_RSV_RESERVATIONS_PVT.Delete_Reservation');

4315: -- Delete existing reservations if cancelling or completing a workorder.
4316: IF (p_x_prd_workorder_rec.status_code IN (G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4317: G_JOB_STATUS_CANCELLED, G_JOB_STATUS_DELETED)) THEN
4318: IF ( G_DEBUG = 'Y' ) THEN
4319: AHL_DEBUG_PUB.debug( l_api_name || ' Before - AHL_RSV_RESERVATIONS_PVT.Delete_Reservation');
4320: AHL_DEBUG_PUB.debug( 'Workorder Status:' || p_x_prd_workorder_rec.status_code);
4321: END IF;
4322:
4323: FOR get_scheduled_mater_rec IN get_scheduled_mater_csr(p_x_prd_workorder_rec.workorder_id)

Line 4320: AHL_DEBUG_PUB.debug( 'Workorder Status:' || p_x_prd_workorder_rec.status_code);

4316: IF (p_x_prd_workorder_rec.status_code IN (G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4317: G_JOB_STATUS_CANCELLED, G_JOB_STATUS_DELETED)) THEN
4318: IF ( G_DEBUG = 'Y' ) THEN
4319: AHL_DEBUG_PUB.debug( l_api_name || ' Before - AHL_RSV_RESERVATIONS_PVT.Delete_Reservation');
4320: AHL_DEBUG_PUB.debug( 'Workorder Status:' || p_x_prd_workorder_rec.status_code);
4321: END IF;
4322:
4323: FOR get_scheduled_mater_rec IN get_scheduled_mater_csr(p_x_prd_workorder_rec.workorder_id)
4324: LOOP

Line 4340: AHL_DEBUG_PUB.debug('Delete_Reservation failed for schedule material ID: '

4336:
4337: -- Check return status.
4338: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4339: IF ( G_DEBUG = 'Y' ) THEN
4340: AHL_DEBUG_PUB.debug('Delete_Reservation failed for schedule material ID: '
4341: || get_scheduled_mater_rec.scheduled_material_id);
4342: END IF; -- G_DEBUG.
4343:
4344: EXIT;

Line 4463: AHL_DEBUG_PUB.debug( l_api_name || ' - Success' );

4459: END IF;
4460: END IF;
4461:
4462: IF ( G_DEBUG = 'Y' ) THEN
4463: AHL_DEBUG_PUB.debug( l_api_name || ' - Success' );
4464: END IF;
4465:
4466: IF G_DEBUG='Y' THEN
4467: AHL_DEBUG_PUB.disable_debug;

Line 4467: AHL_DEBUG_PUB.disable_debug;

4463: AHL_DEBUG_PUB.debug( l_api_name || ' - Success' );
4464: END IF;
4465:
4466: IF G_DEBUG='Y' THEN
4467: AHL_DEBUG_PUB.disable_debug;
4468: END IF;
4469:
4470: EXCEPTION
4471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4550: AHL_DEBUG_PUB.enable_debug;

4546:
4547: x_return_status:=FND_API.G_RET_STS_SUCCESS;
4548:
4549: IF G_DEBUG='Y' THEN
4550: AHL_DEBUG_PUB.enable_debug;
4551: END IF;
4552:
4553: FOR i IN p_x_prd_workorder_tbl.FIRST..p_x_prd_workorder_tbl.LAST LOOP
4554:

Line 4570: AHL_DEBUG_PUB.debug( 'Processing Batch : ' || p_x_prd_workorder_tbl(i).batch_id || ' Header : ' || p_x_prd_workorder_tbl(i).header_id );

4566: RAISE FND_API.G_EXC_ERROR;
4567: END IF;
4568:
4569: IF ( G_DEBUG = 'Y' ) THEN
4570: AHL_DEBUG_PUB.debug( 'Processing Batch : ' || p_x_prd_workorder_tbl(i).batch_id || ' Header : ' || p_x_prd_workorder_tbl(i).header_id );
4571: END IF;
4572: IF ( p_x_prd_workorder_tbl(i).dml_operation = 'C' ) THEN
4573:
4574: -- Check if atleast one relationship record exists

Line 4598: AHL_DEBUG_PUB.debug( 'Invoking create_job API for Workorder ' || i );

4594: l_wo_rel_rec_found := FALSE;
4595: END IF;
4596: */
4597: IF ( G_DEBUG = 'Y' ) THEN
4598: AHL_DEBUG_PUB.debug( 'Invoking create_job API for Workorder ' || i );
4599: END IF;
4600:
4601: create_job
4602: (

Line 4624: AHL_DEBUG_PUB.debug( 'create_job API Success' );

4620: RAISE FND_API.G_EXC_ERROR;
4621: END IF;
4622:
4623: IF ( G_DEBUG = 'Y' ) THEN
4624: AHL_DEBUG_PUB.debug( 'create_job API Success' );
4625: END IF;
4626:
4627: IF ( G_DEBUG = 'Y' ) THEN
4628: AHL_DEBUG_PUB.debug( 'Mapping Job Header Record Number : ' || i );

Line 4628: AHL_DEBUG_PUB.debug( 'Mapping Job Header Record Number : ' || i );

4624: AHL_DEBUG_PUB.debug( 'create_job API Success' );
4625: END IF;
4626:
4627: IF ( G_DEBUG = 'Y' ) THEN
4628: AHL_DEBUG_PUB.debug( 'Mapping Job Header Record Number : ' || i );
4629: END IF;
4630:
4631: -- Map all input AHL Job Header record attributes to the
4632: -- corresponding EAM Job Header record attributes.

Line 4640: AHL_DEBUG_PUB.debug( 'Job Header Record Mapping Complete' );

4636: x_eam_wo_rec => l_eam_wo_tbl(i)
4637: );
4638:
4639: IF ( G_DEBUG = 'Y' ) THEN
4640: AHL_DEBUG_PUB.debug( 'Job Header Record Mapping Complete' );
4641: END IF;
4642:
4643: -- Map all input AHL Operation record attributes to the
4644: -- corresponding EAM Operation record attributes.

Line 4649: AHL_DEBUG_PUB.debug( 'Mapping Operation Record Number : ' || j );

4645: IF ( l_operation_tbl.COUNT > 0 ) THEN
4646: FOR j IN l_operation_tbl.FIRST..l_operation_tbl.LAST LOOP
4647:
4648: IF ( G_DEBUG = 'Y' ) THEN
4649: AHL_DEBUG_PUB.debug( 'Mapping Operation Record Number : ' || j );
4650: END IF;
4651:
4652: total_operations := total_operations + 1;
4653:

Line 4666: AHL_DEBUG_PUB.debug( 'Operations Record Mapping Complete' );

4662:
4663: END LOOP;
4664:
4665: IF ( G_DEBUG = 'Y' ) THEN
4666: AHL_DEBUG_PUB.debug( 'Operations Record Mapping Complete' );
4667: END IF;
4668: END IF;
4669:
4670: -- Map all input AHL Material Requirement record attributes to the

Line 4676: AHL_DEBUG_PUB.debug( 'Mapping Material Requirement Record Number : ' || j );

4672: IF ( l_material_tbl.COUNT > 0 ) THEN
4673: FOR j IN l_material_tbl.FIRST..l_material_tbl.LAST LOOP
4674:
4675: IF ( G_DEBUG = 'Y' ) THEN
4676: AHL_DEBUG_PUB.debug( 'Mapping Material Requirement Record Number : ' || j );
4677: END IF;
4678:
4679: total_materials := total_materials + 1;
4680:

Line 4693: AHL_DEBUG_PUB.debug( 'Material Requirements Record Mapping Complete' );

4689:
4690: END LOOP;
4691:
4692: IF ( G_DEBUG = 'Y' ) THEN
4693: AHL_DEBUG_PUB.debug( 'Material Requirements Record Mapping Complete' );
4694: END IF;
4695:
4696: END IF;
4697:

Line 4704: AHL_DEBUG_PUB.debug( 'Mapping Resource Requirement Record Number : ' || j );

4700: IF ( l_resource_tbl.COUNT > 0 ) THEN
4701: FOR j IN l_resource_tbl.FIRST..l_resource_tbl.LAST LOOP
4702:
4703: IF ( G_DEBUG = 'Y' ) THEN
4704: AHL_DEBUG_PUB.debug( 'Mapping Resource Requirement Record Number : ' || j );
4705: END IF;
4706:
4707: total_resources := total_resources + 1;
4708:

Line 4721: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Mapping Complete' );

4717:
4718: END LOOP;
4719:
4720: IF ( G_DEBUG = 'Y' ) THEN
4721: AHL_DEBUG_PUB.debug( 'Resource Requirement Record Mapping Complete' );
4722: END IF;
4723:
4724: END IF;
4725:

Line 4741: AHL_DEBUG_PUB.debug( 'Invoking update_job API for Workorder ' || i );

4737:
4738: ELSIF ( p_x_prd_workorder_tbl(i).dml_operation = 'U' ) THEN
4739:
4740: IF ( G_DEBUG = 'Y' ) THEN
4741: AHL_DEBUG_PUB.debug( 'Invoking update_job API for Workorder ' || i );
4742: END IF;
4743:
4744: update_job
4745: (

Line 4765: AHL_DEBUG_PUB.debug( 'update_job API Success' );

4761: RAISE FND_API.G_EXC_ERROR;
4762: END IF;
4763:
4764: IF ( G_DEBUG = 'Y' ) THEN
4765: AHL_DEBUG_PUB.debug( 'update_job API Success' );
4766: END IF;
4767:
4768: IF ( G_DEBUG = 'Y' ) THEN
4769: AHL_DEBUG_PUB.debug( 'Mapping Job Header Record Number : ' || i );

Line 4769: AHL_DEBUG_PUB.debug( 'Mapping Job Header Record Number : ' || i );

4765: AHL_DEBUG_PUB.debug( 'update_job API Success' );
4766: END IF;
4767:
4768: IF ( G_DEBUG = 'Y' ) THEN
4769: AHL_DEBUG_PUB.debug( 'Mapping Job Header Record Number : ' || i );
4770: END IF;
4771:
4772: -- Map all input AHL Job Header record attributes to the
4773: -- corresponding EAM Job Header record attributes.

Line 4781: AHL_DEBUG_PUB.debug( 'Job Header Record Mapping Complete' );

4777: x_eam_wo_rec => l_eam_wo_tbl(i)
4778: );
4779:
4780: IF ( G_DEBUG = 'Y' ) THEN
4781: AHL_DEBUG_PUB.debug( 'Job Header Record Mapping Complete' );
4782: END IF;
4783:
4784: END IF;
4785:

Line 4792: AHL_DEBUG_PUB.debug( 'Mapping WO Relationship Record Number : ' || i );

4788: IF ( p_prd_workorder_rel_tbl.COUNT > 0 ) THEN
4789: FOR i IN p_prd_workorder_rel_tbl.FIRST..p_prd_workorder_rel_tbl.LAST LOOP
4790:
4791: IF ( G_DEBUG = 'Y' ) THEN
4792: AHL_DEBUG_PUB.debug( 'Mapping WO Relationship Record Number : ' || i );
4793: END IF;
4794:
4795: -- Map all input AHL Workorder Relationship attributes to the
4796: -- corresponding EAM Workorder Relationship attributes.

Line 4804: AHL_DEBUG_PUB.debug( 'WO Relationship Record Mapping Complete' );

4800: x_eam_wo_relations_rec => l_eam_wo_relations_tbl(i)
4801: );
4802:
4803: IF ( G_DEBUG = 'Y' ) THEN
4804: AHL_DEBUG_PUB.debug( 'WO Relationship Record Mapping Complete' );
4805: END IF;
4806: END LOOP;
4807: END IF;
4808:

Line 4810: AHL_DEBUG_PUB.debug( 'Invoking AHL_EAM_JOB_PVT.process_eam_workorders API');

4806: END LOOP;
4807: END IF;
4808:
4809: IF ( G_DEBUG = 'Y' ) THEN
4810: AHL_DEBUG_PUB.debug( 'Invoking AHL_EAM_JOB_PVT.process_eam_workorders API');
4811: AHL_DEBUG_PUB.debug( 'Total Workorders : ' || l_eam_wo_tbl.COUNT);
4812: AHL_DEBUG_PUB.debug( 'Total Operations : ' || l_eam_op_tbl.COUNT);
4813: AHL_DEBUG_PUB.debug( 'Total Resources : ' || l_eam_res_req_tbl.COUNT);
4814: AHL_DEBUG_PUB.debug( 'Total Materials : ' || l_eam_mat_req_tbl.COUNT);

Line 4811: AHL_DEBUG_PUB.debug( 'Total Workorders : ' || l_eam_wo_tbl.COUNT);

4807: END IF;
4808:
4809: IF ( G_DEBUG = 'Y' ) THEN
4810: AHL_DEBUG_PUB.debug( 'Invoking AHL_EAM_JOB_PVT.process_eam_workorders API');
4811: AHL_DEBUG_PUB.debug( 'Total Workorders : ' || l_eam_wo_tbl.COUNT);
4812: AHL_DEBUG_PUB.debug( 'Total Operations : ' || l_eam_op_tbl.COUNT);
4813: AHL_DEBUG_PUB.debug( 'Total Resources : ' || l_eam_res_req_tbl.COUNT);
4814: AHL_DEBUG_PUB.debug( 'Total Materials : ' || l_eam_mat_req_tbl.COUNT);
4815: AHL_DEBUG_PUB.debug( 'Total Relationships : ' || l_eam_wo_relations_tbl.COUNT);

Line 4812: AHL_DEBUG_PUB.debug( 'Total Operations : ' || l_eam_op_tbl.COUNT);

4808:
4809: IF ( G_DEBUG = 'Y' ) THEN
4810: AHL_DEBUG_PUB.debug( 'Invoking AHL_EAM_JOB_PVT.process_eam_workorders API');
4811: AHL_DEBUG_PUB.debug( 'Total Workorders : ' || l_eam_wo_tbl.COUNT);
4812: AHL_DEBUG_PUB.debug( 'Total Operations : ' || l_eam_op_tbl.COUNT);
4813: AHL_DEBUG_PUB.debug( 'Total Resources : ' || l_eam_res_req_tbl.COUNT);
4814: AHL_DEBUG_PUB.debug( 'Total Materials : ' || l_eam_mat_req_tbl.COUNT);
4815: AHL_DEBUG_PUB.debug( 'Total Relationships : ' || l_eam_wo_relations_tbl.COUNT);
4816: END IF;

Line 4813: AHL_DEBUG_PUB.debug( 'Total Resources : ' || l_eam_res_req_tbl.COUNT);

4809: IF ( G_DEBUG = 'Y' ) THEN
4810: AHL_DEBUG_PUB.debug( 'Invoking AHL_EAM_JOB_PVT.process_eam_workorders API');
4811: AHL_DEBUG_PUB.debug( 'Total Workorders : ' || l_eam_wo_tbl.COUNT);
4812: AHL_DEBUG_PUB.debug( 'Total Operations : ' || l_eam_op_tbl.COUNT);
4813: AHL_DEBUG_PUB.debug( 'Total Resources : ' || l_eam_res_req_tbl.COUNT);
4814: AHL_DEBUG_PUB.debug( 'Total Materials : ' || l_eam_mat_req_tbl.COUNT);
4815: AHL_DEBUG_PUB.debug( 'Total Relationships : ' || l_eam_wo_relations_tbl.COUNT);
4816: END IF;
4817:

Line 4814: AHL_DEBUG_PUB.debug( 'Total Materials : ' || l_eam_mat_req_tbl.COUNT);

4810: AHL_DEBUG_PUB.debug( 'Invoking AHL_EAM_JOB_PVT.process_eam_workorders API');
4811: AHL_DEBUG_PUB.debug( 'Total Workorders : ' || l_eam_wo_tbl.COUNT);
4812: AHL_DEBUG_PUB.debug( 'Total Operations : ' || l_eam_op_tbl.COUNT);
4813: AHL_DEBUG_PUB.debug( 'Total Resources : ' || l_eam_res_req_tbl.COUNT);
4814: AHL_DEBUG_PUB.debug( 'Total Materials : ' || l_eam_mat_req_tbl.COUNT);
4815: AHL_DEBUG_PUB.debug( 'Total Relationships : ' || l_eam_wo_relations_tbl.COUNT);
4816: END IF;
4817:
4818:

Line 4815: AHL_DEBUG_PUB.debug( 'Total Relationships : ' || l_eam_wo_relations_tbl.COUNT);

4811: AHL_DEBUG_PUB.debug( 'Total Workorders : ' || l_eam_wo_tbl.COUNT);
4812: AHL_DEBUG_PUB.debug( 'Total Operations : ' || l_eam_op_tbl.COUNT);
4813: AHL_DEBUG_PUB.debug( 'Total Resources : ' || l_eam_res_req_tbl.COUNT);
4814: AHL_DEBUG_PUB.debug( 'Total Materials : ' || l_eam_mat_req_tbl.COUNT);
4815: AHL_DEBUG_PUB.debug( 'Total Relationships : ' || l_eam_wo_relations_tbl.COUNT);
4816: END IF;
4817:
4818:
4819: AHL_EAM_JOB_PVT.process_eam_workorders

Line 4840: AHL_DEBUG_PUB.debug( 'AHL_EAM_JOB_PVT.process_eam_workorders API Success' );

4836: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4837: RAISE FND_API.G_EXC_ERROR;
4838: ELSE
4839: IF ( G_DEBUG = 'Y' ) THEN
4840: AHL_DEBUG_PUB.debug( 'AHL_EAM_JOB_PVT.process_eam_workorders API Success' );
4841: END IF;
4842:
4843: FOR i IN p_x_prd_workorder_tbl.FIRST..p_x_prd_workorder_tbl.LAST LOOP
4844:

Line 4847: AHL_DEBUG_PUB.debug( l_api_name || 'Updating AHL_WORKORDERS with wip_entity_id for Workorder ' || i );

4843: FOR i IN p_x_prd_workorder_tbl.FIRST..p_x_prd_workorder_tbl.LAST LOOP
4844:
4845: IF ( p_x_prd_workorder_tbl(i).dml_operation = 'C' ) THEN
4846: IF ( G_DEBUG = 'Y' ) THEN
4847: AHL_DEBUG_PUB.debug( l_api_name || 'Updating AHL_WORKORDERS with wip_entity_id for Workorder ' || i );
4848: END IF;
4849:
4850: UPDATE AHL_WORKORDERS
4851: SET wip_entity_id = l_eam_wo_tbl(i).wip_entity_id,

Line 4860: AHL_DEBUG_PUB.debug( l_api_name || 'Before calling Create Job Dispostions ' || i );

4856:
4857: WHERE workorder_id = p_x_prd_workorder_tbl(i).workorder_id;
4858:
4859: IF ( G_DEBUG = 'Y' ) THEN
4860: AHL_DEBUG_PUB.debug( l_api_name || 'Before calling Create Job Dispostions ' || i );
4861: AHL_DEBUG_PUB.debug( 'Workorder Id: ' || p_x_prd_workorder_tbl(i).workorder_id );
4862:
4863: END IF;
4864:

Line 4861: AHL_DEBUG_PUB.debug( 'Workorder Id: ' || p_x_prd_workorder_tbl(i).workorder_id );

4857: WHERE workorder_id = p_x_prd_workorder_tbl(i).workorder_id;
4858:
4859: IF ( G_DEBUG = 'Y' ) THEN
4860: AHL_DEBUG_PUB.debug( l_api_name || 'Before calling Create Job Dispostions ' || i );
4861: AHL_DEBUG_PUB.debug( 'Workorder Id: ' || p_x_prd_workorder_tbl(i).workorder_id );
4862:
4863: END IF;
4864:
4865: --Call disposition API Post 11.5.10 Changes

Line 4882: AHL_DEBUG_PUB.debug( l_api_name || 'Updating AHL_WORKORDERS with status code for Workorder ' || i );

4878: END IF;
4879:
4880: ELSIF ( p_x_prd_workorder_tbl(i).dml_operation = 'U' ) THEN
4881: IF ( G_DEBUG = 'Y' ) THEN
4882: AHL_DEBUG_PUB.debug( l_api_name || 'Updating AHL_WORKORDERS with status code for Workorder ' || i );
4883: END IF;
4884: --
4885: UPDATE AHL_WORKORDERS
4886: SET status_code = l_eam_wo_tbl(i).status_type,

Line 4905: AHL_DEBUG_PUB.disable_debug;

4901:
4902: END IF;
4903:
4904: IF G_DEBUG='Y' THEN
4905: AHL_DEBUG_PUB.disable_debug;
4906: END IF;
4907:
4908: EXCEPTION
4909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5078: AHL_DEBUG_PUB.enable_debug;

5074:
5075: x_return_status:=FND_API.G_RET_STS_SUCCESS;
5076:
5077: IF G_DEBUG='Y' THEN
5078: AHL_DEBUG_PUB.enable_debug;
5079: END IF;
5080: -- Validate Inputs
5081: IF ( ( p_workorder_id IS NULL OR
5082: p_workorder_id = FND_API.G_MISS_NUM ) AND

Line 5455: AHL_DEBUG_PUB.disable_debug;

5451: COMMIT;
5452: END IF;
5453:
5454: IF G_DEBUG='Y' THEN
5455: AHL_DEBUG_PUB.disable_debug;
5456: END IF;
5457:
5458: EXCEPTION
5459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5624: AHL_DEBUG_PUB.enable_debug;

5620:
5621: x_return_status:=FND_API.G_RET_STS_SUCCESS;
5622:
5623: IF G_DEBUG='Y' THEN
5624: AHL_DEBUG_PUB.enable_debug;
5625: END IF;
5626:
5627: -- Validate Inputs
5628: IF ( ( p_workorder_id IS NULL OR

Line 6225: AHL_DEBUG_PUB.enable_debug;

6221:
6222: x_return_status:=FND_API.G_RET_STS_SUCCESS;
6223:
6224: IF G_DEBUG='Y' THEN
6225: AHL_DEBUG_PUB.enable_debug;
6226: END IF;
6227:
6228: --sikumar: added for FP for ER 5571241 -- Check if user has permission to cancel jobs.
6229: IF AHL_PRD_UTIL_PKG.Is_Wo_Cancel_Allowed = FND_API.G_FALSE THEN

Line 7376: AHL_DEBUG_PUB.disable_debug;

7372: COMMIT;
7373: END IF;
7374:
7375: IF G_DEBUG='Y' THEN
7376: AHL_DEBUG_PUB.disable_debug;
7377: END IF;
7378:
7379: EXCEPTION
7380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7795: AHL_DEBUG_PUB.debug( 'after dates descripency'||p_x_scheduled_end_date );

7791: --
7792: IF p_x_scheduled_end_date <> latest_schedule_dates_rec.scheduled_completion_date THEN
7793: --
7794: IF ( G_DEBUG = 'Y' ) THEN
7795: AHL_DEBUG_PUB.debug( 'after dates descripency'||p_x_scheduled_end_date );
7796: AHL_DEBUG_PUB.debug( 'after dates descripency'||latest_schedule_dates_rec.scheduled_completion_date );
7797:
7798: END IF;
7799:

Line 7796: AHL_DEBUG_PUB.debug( 'after dates descripency'||latest_schedule_dates_rec.scheduled_completion_date );

7792: IF p_x_scheduled_end_date <> latest_schedule_dates_rec.scheduled_completion_date THEN
7793: --
7794: IF ( G_DEBUG = 'Y' ) THEN
7795: AHL_DEBUG_PUB.debug( 'after dates descripency'||p_x_scheduled_end_date );
7796: AHL_DEBUG_PUB.debug( 'after dates descripency'||latest_schedule_dates_rec.scheduled_completion_date );
7797:
7798: END IF;
7799:
7800: l_prd_workorder_tbl(1).DML_OPERATION := 'U';

Line 7809: AHL_DEBUG_PUB.debug( 'Calling process_jobs API' );

7805: l_prd_workorder_tbl(1).BATCH_ID := 1;
7806: l_prd_workorder_tbl(1).HEADER_ID := 0;
7807:
7808: IF ( G_DEBUG = 'Y' ) THEN
7809: AHL_DEBUG_PUB.debug( 'Calling process_jobs API' );
7810: END IF;
7811:
7812: process_jobs
7813: (