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

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

1: PACKAGE BODY AHL_MM_CANNIBALIZATION_PVT AS
2: /* $Header: AHLVCANB.pls 120.0.12020000.2 2012/12/14 07:42:12 shnatu noship $ */
3:
4: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
5: G_DEBUG_LINE_NUM NUMBER;
6:
7: --------------------------------------------------------------------
8: -- Procedure name : process_cannibalization

Line 142: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );

138: BEGIN
139: -- Add debug mesg.
140: IF G_DEBUG = 'Y'
141: THEN
142: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );
143: END IF;
144:
145: SAVEPOINT sp_process_cannibalization;
146:

Line 152: AHL_DEBUG_PUB.enable_debug;

148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: -- Enable Debug.
151: IF (G_DEBUG = 'Y') THEN
152: AHL_DEBUG_PUB.enable_debug;
153: END IF;
154: -- Initilaize message list
155: IF FND_API.to_boolean(p_init_msg_list)
156: THEN

Line 170: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Cannibalization Input Params::' );

166: END IF;
167:
168: -- Print the All the input parameters
169: IF G_DEBUG = 'Y' THEN
170: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Cannibalization Input Params::' );
171: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Demand ASM_ID::'||p_cannibalization_rec.demand_asm_id );
172: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Instance_ID::'||p_cannibalization_rec.supply_instance_id );
173: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Visit_ID::'||p_cannibalization_rec.supply_visit_id );
174: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply MC_Header_ID::'||p_cannibalization_rec.supply_mc_header_id );

Line 171: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Demand ASM_ID::'||p_cannibalization_rec.demand_asm_id );

167:
168: -- Print the All the input parameters
169: IF G_DEBUG = 'Y' THEN
170: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Cannibalization Input Params::' );
171: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Demand ASM_ID::'||p_cannibalization_rec.demand_asm_id );
172: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Instance_ID::'||p_cannibalization_rec.supply_instance_id );
173: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Visit_ID::'||p_cannibalization_rec.supply_visit_id );
174: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply MC_Header_ID::'||p_cannibalization_rec.supply_mc_header_id );
175: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Position_Key::'||p_cannibalization_rec.supply_pos_key );

Line 172: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Instance_ID::'||p_cannibalization_rec.supply_instance_id );

168: -- Print the All the input parameters
169: IF G_DEBUG = 'Y' THEN
170: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Cannibalization Input Params::' );
171: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Demand ASM_ID::'||p_cannibalization_rec.demand_asm_id );
172: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Instance_ID::'||p_cannibalization_rec.supply_instance_id );
173: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Visit_ID::'||p_cannibalization_rec.supply_visit_id );
174: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply MC_Header_ID::'||p_cannibalization_rec.supply_mc_header_id );
175: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Position_Key::'||p_cannibalization_rec.supply_pos_key );
176: END IF;

Line 173: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Visit_ID::'||p_cannibalization_rec.supply_visit_id );

169: IF G_DEBUG = 'Y' THEN
170: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Cannibalization Input Params::' );
171: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Demand ASM_ID::'||p_cannibalization_rec.demand_asm_id );
172: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Instance_ID::'||p_cannibalization_rec.supply_instance_id );
173: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Visit_ID::'||p_cannibalization_rec.supply_visit_id );
174: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply MC_Header_ID::'||p_cannibalization_rec.supply_mc_header_id );
175: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Position_Key::'||p_cannibalization_rec.supply_pos_key );
176: END IF;
177:

Line 174: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply MC_Header_ID::'||p_cannibalization_rec.supply_mc_header_id );

170: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Cannibalization Input Params::' );
171: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Demand ASM_ID::'||p_cannibalization_rec.demand_asm_id );
172: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Instance_ID::'||p_cannibalization_rec.supply_instance_id );
173: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Visit_ID::'||p_cannibalization_rec.supply_visit_id );
174: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply MC_Header_ID::'||p_cannibalization_rec.supply_mc_header_id );
175: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Position_Key::'||p_cannibalization_rec.supply_pos_key );
176: END IF;
177:
178: -- Validate the Demand Inputs (ASM ID)

Line 175: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Position_Key::'||p_cannibalization_rec.supply_pos_key );

171: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Demand ASM_ID::'||p_cannibalization_rec.demand_asm_id );
172: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Instance_ID::'||p_cannibalization_rec.supply_instance_id );
173: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Visit_ID::'||p_cannibalization_rec.supply_visit_id );
174: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply MC_Header_ID::'||p_cannibalization_rec.supply_mc_header_id );
175: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Position_Key::'||p_cannibalization_rec.supply_pos_key );
176: END IF;
177:
178: -- Validate the Demand Inputs (ASM ID)
179: IF(p_cannibalization_rec.demand_asm_id IS NULL)

Line 281: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling create_nr_workorder for cannibalization' );

277: l_cannibalization_sr_rec.instance_id := p_cannibalization_rec.supply_instance_id;
278: --l_cannibalization_sr_rec.expected_resolution_date := SYSDATE;
279:
280: IF G_DEBUG = 'Y' THEN
281: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling create_nr_workorder for cannibalization' );
282: END IF;
283:
284: -- Call Create Non-routine Workorder for Supply WO
285: create_nr_workorder

Line 302: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for cannibalization::l_return_status::'||l_return_status );

298: p_rts_flag => 'Y'
299: );
300:
301: IF G_DEBUG = 'Y' THEN
302: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for cannibalization::l_return_status::'||l_return_status );
303: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for cannibalization::SR_ID::'||l_cannibalization_sr_rec.incident_id );
304: END IF;
305:
306: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 303: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for cannibalization::SR_ID::'||l_cannibalization_sr_rec.incident_id );

299: );
300:
301: IF G_DEBUG = 'Y' THEN
302: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for cannibalization::l_return_status::'||l_return_status );
303: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for cannibalization::SR_ID::'||l_cannibalization_sr_rec.incident_id );
304: END IF;
305:
306: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
307: x_msg_count := l_msg_count;

Line 324: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::after calling Launch_NR_Notification, '||

320: x_return_status => l_return_status
321: );
322:
323: IF (G_DEBUG = 'Y' ) THEN
324: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::after calling Launch_NR_Notification, '||
325: ' l_item_key > '||l_item_key||
326: ', l_return_status'||l_return_status);
327: END IF;
328:

Line 335: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Non-routine Workorder is not created' );

331: FETCH get_wo_det INTO l_get_wo_det;
332: IF (get_wo_det%NOTFOUND)
333: THEN
334: IF (G_DEBUG = 'Y' ) THEN
335: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Non-routine Workorder is not created' );
336: END IF;
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339: CLOSE get_wo_det;

Line 353: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling ahl_mm_reservations_pvt.create_reservation Input parameters' );

349: l_rsv_rec.supply_source_line_detail := NULL;
350: l_rsv_rec.primary_reservation_quantity := 1;
351:
352: IF G_DEBUG = 'Y' THEN
353: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling ahl_mm_reservations_pvt.create_reservation Input parameters' );
354: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.demand_source_line_detail::'||l_rsv_rec.demand_source_line_detail );
355: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_header_id::'||l_rsv_rec.supply_source_header_id );
356: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_line_id::'||l_rsv_rec.supply_source_line_id );
357: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_type_id::'||l_rsv_rec.supply_source_type_id );

Line 354: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.demand_source_line_detail::'||l_rsv_rec.demand_source_line_detail );

350: l_rsv_rec.primary_reservation_quantity := 1;
351:
352: IF G_DEBUG = 'Y' THEN
353: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling ahl_mm_reservations_pvt.create_reservation Input parameters' );
354: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.demand_source_line_detail::'||l_rsv_rec.demand_source_line_detail );
355: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_header_id::'||l_rsv_rec.supply_source_header_id );
356: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_line_id::'||l_rsv_rec.supply_source_line_id );
357: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_type_id::'||l_rsv_rec.supply_source_type_id );
358: END IF;

Line 355: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_header_id::'||l_rsv_rec.supply_source_header_id );

351:
352: IF G_DEBUG = 'Y' THEN
353: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling ahl_mm_reservations_pvt.create_reservation Input parameters' );
354: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.demand_source_line_detail::'||l_rsv_rec.demand_source_line_detail );
355: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_header_id::'||l_rsv_rec.supply_source_header_id );
356: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_line_id::'||l_rsv_rec.supply_source_line_id );
357: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_type_id::'||l_rsv_rec.supply_source_type_id );
358: END IF;
359:

Line 356: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_line_id::'||l_rsv_rec.supply_source_line_id );

352: IF G_DEBUG = 'Y' THEN
353: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling ahl_mm_reservations_pvt.create_reservation Input parameters' );
354: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.demand_source_line_detail::'||l_rsv_rec.demand_source_line_detail );
355: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_header_id::'||l_rsv_rec.supply_source_header_id );
356: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_line_id::'||l_rsv_rec.supply_source_line_id );
357: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_type_id::'||l_rsv_rec.supply_source_type_id );
358: END IF;
359:
360: AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION

Line 357: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_type_id::'||l_rsv_rec.supply_source_type_id );

353: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling ahl_mm_reservations_pvt.create_reservation Input parameters' );
354: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.demand_source_line_detail::'||l_rsv_rec.demand_source_line_detail );
355: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_header_id::'||l_rsv_rec.supply_source_header_id );
356: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_line_id::'||l_rsv_rec.supply_source_line_id );
357: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.supply_source_type_id::'||l_rsv_rec.supply_source_type_id );
358: END IF;
359:
360: AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION
361: (

Line 376: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling ahl_mm_reservations_pvt.create_reservation::l_return_status::'||l_return_status );

372: x_reservation_id => l_reservation_id
373: );
374:
375: IF G_DEBUG = 'Y' THEN
376: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling ahl_mm_reservations_pvt.create_reservation::l_return_status::'||l_return_status );
377: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Reservation ID::'||l_reservation_id );
378: END IF;
379:
380: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 377: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Reservation ID::'||l_reservation_id );

373: );
374:
375: IF G_DEBUG = 'Y' THEN
376: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling ahl_mm_reservations_pvt.create_reservation::l_return_status::'||l_return_status );
377: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Reservation ID::'||l_reservation_id );
378: END IF;
379:
380: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
381: x_msg_count := l_msg_count;

Line 401: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling create_nr_workorder for Replace cannibalization' );

397: l_rep_cannibalization_sr_rec.Instance_id := p_cannibalization_rec.supply_nha_inst_id;
398: --l_rep_cannibalization_sr_rec.expected_resolution_date := SYSDATE;
399:
400: IF G_DEBUG = 'Y' THEN
401: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling create_nr_workorder for Replace cannibalization' );
402: END IF;
403:
404: create_nr_workorder
405: (

Line 421: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for Replace cannibalization::l_return_status::'||l_return_status );

417: p_rts_flag => 'N'
418: );
419:
420: IF G_DEBUG = 'Y' THEN
421: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for Replace cannibalization::l_return_status::'||l_return_status );
422: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for cannibalization::SR_ID::'||l_rep_cannibalization_sr_rec.incident_id );
423: END IF;
424:
425: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 422: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for cannibalization::SR_ID::'||l_rep_cannibalization_sr_rec.incident_id );

418: );
419:
420: IF G_DEBUG = 'Y' THEN
421: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for Replace cannibalization::l_return_status::'||l_return_status );
422: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for cannibalization::SR_ID::'||l_rep_cannibalization_sr_rec.incident_id );
423: END IF;
424:
425: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
426: x_msg_count := l_msg_count;

Line 443: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After calling Launch_NR_Notification, '|| ' l_item_key > '||l_item_key||

439: x_return_status => l_return_status
440: );
441:
442: IF (G_DEBUG = 'Y' ) THEN
443: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After calling Launch_NR_Notification, '|| ' l_item_key > '||l_item_key||
444: ', l_return_status'||l_return_status);
445: END IF;
446:
447: -- Call the Material Requirements API

Line 453: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Replacement Non-routine Workorder is not created' );

449: FETCH get_wo_det INTO l_get_wo_det;
450: IF (get_wo_det%NOTFOUND)
451: THEN
452: IF (G_DEBUG = 'Y' ) THEN
453: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Replacement Non-routine Workorder is not created' );
454: END IF;
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;
457: CLOSE get_wo_det;

Line 460: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Wokorder id:: '||l_get_wo_det.workorder_id );

456: END IF;
457: CLOSE get_wo_det;
458:
459: IF G_DEBUG = 'Y' THEN
460: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Wokorder id:: '||l_get_wo_det.workorder_id );
461: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Supply Item id:: '||l_sup_mat_det_rec.inventory_item_id );
462: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Supply Org id:: '||l_dem_mat_det_rec.organization_id );
463: END IF;
464:

Line 461: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Supply Item id:: '||l_sup_mat_det_rec.inventory_item_id );

457: CLOSE get_wo_det;
458:
459: IF G_DEBUG = 'Y' THEN
460: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Wokorder id:: '||l_get_wo_det.workorder_id );
461: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Supply Item id:: '||l_sup_mat_det_rec.inventory_item_id );
462: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Supply Org id:: '||l_dem_mat_det_rec.organization_id );
463: END IF;
464:
465: -- Get the UOM for item (in the UI Primary UOM is defaulted, considered the same)

Line 462: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Supply Org id:: '||l_dem_mat_det_rec.organization_id );

458:
459: IF G_DEBUG = 'Y' THEN
460: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Wokorder id:: '||l_get_wo_det.workorder_id );
461: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Supply Item id:: '||l_sup_mat_det_rec.inventory_item_id );
462: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Supply Org id:: '||l_dem_mat_det_rec.organization_id );
463: END IF;
464:
465: -- Get the UOM for item (in the UI Primary UOM is defaulted, considered the same)
466: OPEN get_uom(l_dem_mat_det_rec.organization_id , l_sup_mat_det_rec.inventory_item_id);

Line 471: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::UOM not found for given Demand Item and Org' );

467: FETCH get_uom INTO l_primary_uom_code;
468: IF (get_uom%NOTFOUND)
469: THEN
470: IF (G_DEBUG = 'Y' ) THEN
471: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::UOM not found for given Demand Item and Org' );
472: END IF;
473: END IF;
474: CLOSE get_uom;
475:

Line 477: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Primary UOM code::'||l_primary_uom_code );

473: END IF;
474: CLOSE get_uom;
475:
476: IF G_DEBUG = 'Y' THEN
477: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT..Primary UOM code::'||l_primary_uom_code );
478: END IF;
479:
480: -- Map the Input parameters
481: l_rep_can_mat_req_tab(1).operation_flag := 'C';

Line 497: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT.Process_Material_Request for Replace cannibalization' );

493: l_rep_can_mat_req_tab(1).requested_quantity := 1;
494: l_rep_can_mat_req_tab(1).uom_code := l_primary_uom_code;
495:
496: IF G_DEBUG = 'Y' THEN
497: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Before Calling AHL_PP_MATERIALS_PVT.Process_Material_Request for Replace cannibalization' );
498: END IF;
499:
500: AHL_PP_MATERIALS_PVT.Process_Material_Request
501: (

Line 514: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling AHL_PP_MATERIALS_PVT.Process_Material_Request for Replace cannibalization' );

510: x_msg_data => l_msg_data
511: );
512:
513: IF G_DEBUG = 'Y' THEN
514: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling AHL_PP_MATERIALS_PVT.Process_Material_Request for Replace cannibalization' );
515: END IF;
516:
517: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
518: x_msg_count := l_msg_count;

Line 528: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Commited all the work' );

524: IF FND_API.TO_BOOLEAN(p_commit)
525: THEN
526: COMMIT WORK;
527: IF G_DEBUG = 'Y' THEN
528: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Commited all the work' );
529: END IF;
530: END IF;
531:
532:

Line 669: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );

665: BEGIN
666:
667: -- Add debug mesg.
668: IF G_DEBUG = 'Y' THEN
669: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );
670: END IF;
671:
672: SAVEPOINT sp_create_nr_workorder;
673:

Line 678: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Create_SR Input Params::' );

674: -- Initialize API return status to success
675: x_return_status := FND_API.G_RET_STS_SUCCESS;
676:
677: IF G_DEBUG = 'Y' THEN
678: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Create_SR Input Params::' );
679: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || p_x_sr_task_rec.instance_id ||'::severity_id::'|| p_x_sr_task_rec.severity_id);
680: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Summary ::' ||p_x_sr_task_rec.problem_summary||'::expected_resolution_date::'||p_x_sr_task_rec.expected_resolution_date );
681: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Type_id::'||p_x_sr_task_rec.Type_id);
682: END IF;

Line 679: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || p_x_sr_task_rec.instance_id ||'::severity_id::'|| p_x_sr_task_rec.severity_id);

675: x_return_status := FND_API.G_RET_STS_SUCCESS;
676:
677: IF G_DEBUG = 'Y' THEN
678: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Create_SR Input Params::' );
679: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || p_x_sr_task_rec.instance_id ||'::severity_id::'|| p_x_sr_task_rec.severity_id);
680: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Summary ::' ||p_x_sr_task_rec.problem_summary||'::expected_resolution_date::'||p_x_sr_task_rec.expected_resolution_date );
681: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Type_id::'||p_x_sr_task_rec.Type_id);
682: END IF;
683:

Line 680: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Summary ::' ||p_x_sr_task_rec.problem_summary||'::expected_resolution_date::'||p_x_sr_task_rec.expected_resolution_date );

676:
677: IF G_DEBUG = 'Y' THEN
678: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Create_SR Input Params::' );
679: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || p_x_sr_task_rec.instance_id ||'::severity_id::'|| p_x_sr_task_rec.severity_id);
680: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Summary ::' ||p_x_sr_task_rec.problem_summary||'::expected_resolution_date::'||p_x_sr_task_rec.expected_resolution_date );
681: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Type_id::'||p_x_sr_task_rec.Type_id);
682: END IF;
683:
684: -- Initilaize message list

Line 681: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Type_id::'||p_x_sr_task_rec.Type_id);

677: IF G_DEBUG = 'Y' THEN
678: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Create_SR Input Params::' );
679: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || p_x_sr_task_rec.instance_id ||'::severity_id::'|| p_x_sr_task_rec.severity_id);
680: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Summary ::' ||p_x_sr_task_rec.problem_summary||'::expected_resolution_date::'||p_x_sr_task_rec.expected_resolution_date );
681: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Type_id::'||p_x_sr_task_rec.Type_id);
682: END IF;
683:
684: -- Initilaize message list
685: IF FND_API.to_boolean(p_init_msg_list)

Line 711: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After calling AHL_UMP_NONROUTINES_PVT.Create_SR::l_return_status:: '||l_return_status);

707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709:
710: IF G_DEBUG = 'Y' THEN
711: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After calling AHL_UMP_NONROUTINES_PVT.Create_SR::l_return_status:: '||l_return_status);
712: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Request ID->'||p_x_sr_task_rec.incident_id|| '::Service Request Status->'||p_x_sr_task_rec.status_id);
713: END IF;
714:
715: -- retrieve unit effectivity id corresponding to the SR

Line 712: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Request ID->'||p_x_sr_task_rec.incident_id|| '::Service Request Status->'||p_x_sr_task_rec.status_id);

708: END IF;
709:
710: IF G_DEBUG = 'Y' THEN
711: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After calling AHL_UMP_NONROUTINES_PVT.Create_SR::l_return_status:: '||l_return_status);
712: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Request ID->'||p_x_sr_task_rec.incident_id|| '::Service Request Status->'||p_x_sr_task_rec.status_id);
713: END IF;
714:
715: -- retrieve unit effectivity id corresponding to the SR
716: OPEN c_get_ue_id(p_x_sr_task_rec.incident_id);

Line 721: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Request is not created');

717: FETCH c_get_ue_id INTO l_unit_effectivity_id ;
718: IF (c_get_ue_id%NOTFOUND)
719: THEN
720: IF G_DEBUG = 'Y' THEN
721: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Request is not created');
722: END IF;
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END IF;
725: CLOSE c_get_ue_id;

Line 742: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Request is not created');

738: FETCH C_VISIT_START_DATE INTO L_VISIT_DATE;
739: IF (C_VISIT_START_DATE%NOTFOUND)
740: THEN
741: IF G_DEBUG = 'Y' THEN
742: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Request is not created');
743: END IF;
744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
745: END IF;
746: CLOSE C_VISIT_START_DATE;

Line 756: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...' );

752: -- Bug#14033321 ARUNJK END
753: l_create_task_tbl(1).return_to_supply_flag := p_rts_flag;
754:
755: IF G_DEBUG = 'Y' THEN
756: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...' );
757: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::p_visit_id'||p_visit_id);
758: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_unit_effectivity_id->'||l_unit_effectivity_id );
759: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Incident_id->'||p_x_sr_task_rec.incident_id );
760: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_firm_planned_flag->'||l_firm_planned_flag );

Line 757: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::p_visit_id'||p_visit_id);

753: l_create_task_tbl(1).return_to_supply_flag := p_rts_flag;
754:
755: IF G_DEBUG = 'Y' THEN
756: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...' );
757: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::p_visit_id'||p_visit_id);
758: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_unit_effectivity_id->'||l_unit_effectivity_id );
759: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Incident_id->'||p_x_sr_task_rec.incident_id );
760: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_firm_planned_flag->'||l_firm_planned_flag );
761: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).task_start_date ->'||l_create_task_tbl(1).task_start_date );

Line 758: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_unit_effectivity_id->'||l_unit_effectivity_id );

754:
755: IF G_DEBUG = 'Y' THEN
756: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...' );
757: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::p_visit_id'||p_visit_id);
758: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_unit_effectivity_id->'||l_unit_effectivity_id );
759: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Incident_id->'||p_x_sr_task_rec.incident_id );
760: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_firm_planned_flag->'||l_firm_planned_flag );
761: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).task_start_date ->'||l_create_task_tbl(1).task_start_date );
762: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).originating_task_id ->'||l_create_task_tbl(1).originating_task_id );

Line 759: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Incident_id->'||p_x_sr_task_rec.incident_id );

755: IF G_DEBUG = 'Y' THEN
756: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...' );
757: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::p_visit_id'||p_visit_id);
758: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_unit_effectivity_id->'||l_unit_effectivity_id );
759: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Incident_id->'||p_x_sr_task_rec.incident_id );
760: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_firm_planned_flag->'||l_firm_planned_flag );
761: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).task_start_date ->'||l_create_task_tbl(1).task_start_date );
762: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).originating_task_id ->'||l_create_task_tbl(1).originating_task_id );
763: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).return_to_supply_flag ->'||l_create_task_tbl(1).return_to_supply_flag );

Line 760: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_firm_planned_flag->'||l_firm_planned_flag );

756: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...' );
757: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::p_visit_id'||p_visit_id);
758: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_unit_effectivity_id->'||l_unit_effectivity_id );
759: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Incident_id->'||p_x_sr_task_rec.incident_id );
760: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_firm_planned_flag->'||l_firm_planned_flag );
761: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).task_start_date ->'||l_create_task_tbl(1).task_start_date );
762: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).originating_task_id ->'||l_create_task_tbl(1).originating_task_id );
763: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).return_to_supply_flag ->'||l_create_task_tbl(1).return_to_supply_flag );
764: END IF;

Line 761: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).task_start_date ->'||l_create_task_tbl(1).task_start_date );

757: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::p_visit_id'||p_visit_id);
758: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_unit_effectivity_id->'||l_unit_effectivity_id );
759: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Incident_id->'||p_x_sr_task_rec.incident_id );
760: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_firm_planned_flag->'||l_firm_planned_flag );
761: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).task_start_date ->'||l_create_task_tbl(1).task_start_date );
762: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).originating_task_id ->'||l_create_task_tbl(1).originating_task_id );
763: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).return_to_supply_flag ->'||l_create_task_tbl(1).return_to_supply_flag );
764: END IF;
765:

Line 762: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).originating_task_id ->'||l_create_task_tbl(1).originating_task_id );

758: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_unit_effectivity_id->'||l_unit_effectivity_id );
759: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Incident_id->'||p_x_sr_task_rec.incident_id );
760: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_firm_planned_flag->'||l_firm_planned_flag );
761: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).task_start_date ->'||l_create_task_tbl(1).task_start_date );
762: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).originating_task_id ->'||l_create_task_tbl(1).originating_task_id );
763: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).return_to_supply_flag ->'||l_create_task_tbl(1).return_to_supply_flag );
764: END IF;
765:
766: -- STEP 2: Call VWP API to create tasks for Non-routine.

Line 763: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).return_to_supply_flag ->'||l_create_task_tbl(1).return_to_supply_flag );

759: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Incident_id->'||p_x_sr_task_rec.incident_id );
760: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_firm_planned_flag->'||l_firm_planned_flag );
761: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).task_start_date ->'||l_create_task_tbl(1).task_start_date );
762: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).originating_task_id ->'||l_create_task_tbl(1).originating_task_id );
763: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_create_task_tbl(1).return_to_supply_flag ->'||l_create_task_tbl(1).return_to_supply_flag );
764: END IF;
765:
766: -- STEP 2: Call VWP API to create tasks for Non-routine.
767: AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS(

Line 778: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS::Return Status::'||l_return_status );

774: x_msg_data => l_msg_data
775: );
776:
777: IF G_DEBUG = 'Y' THEN
778: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS::Return Status::'||l_return_status );
779: END IF;
780:
781: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
782: x_msg_count := l_msg_count;

Line 787: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.Add_Return_To_Supply...' );

783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785:
786: IF G_DEBUG = 'Y' THEN
787: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.Add_Return_To_Supply...' );
788: END IF;
789:
790: -- STEP 2A: Call update RTS flag API temparoraily -- Remove this call once VWP complets their code
791: IF(p_rts_flag = 'Y')

Line 794: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.Add_Return_To_Supply...service_request_id:::'||l_create_task_tbl(1).service_request_id );

790: -- STEP 2A: Call update RTS flag API temparoraily -- Remove this call once VWP complets their code
791: IF(p_rts_flag = 'Y')
792: THEN
793: IF G_DEBUG = 'Y' THEN
794: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.Add_Return_To_Supply...service_request_id:::'||l_create_task_tbl(1).service_request_id );
795: END IF;
796: -- Get the Planned task to ADD RTS FLAG
797: BEGIN
798: SELECT visit_task_id,object_version_number INTO l_upd_rts_task_tbl(1).visit_task_id,l_upd_rts_task_tbl(1).object_version_number

Line 805: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::No Task created for SR::'||l_create_task_tbl(1).service_request_id);

801: AND task_type_code = 'PLANNED';
802: EXCEPTION
803: WHEN NO_DATA_FOUND THEN
804: IF G_DEBUG = 'Y' THEN
805: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::No Task created for SR::'||l_create_task_tbl(1).service_request_id);
806: END IF;
807: RAISE NO_DATA_FOUND;
808: END;
809:

Line 811: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.Add_Return_To_Supply...visit_task_id:::'||l_upd_rts_task_tbl(1).visit_task_id );

807: RAISE NO_DATA_FOUND;
808: END;
809:
810: IF G_DEBUG = 'Y' THEN
811: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.Add_Return_To_Supply...visit_task_id:::'||l_upd_rts_task_tbl(1).visit_task_id );
812: END IF;
813:
814: AHL_VWP_RULES_PVT.Add_Return_To_Supply
815: (

Line 827: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After calling AHL_VWP_TASKS_PVT.Add_Return_To_Supply::Return Status::'||l_return_status );

823: x_msg_data => l_msg_data
824: );
825:
826: IF G_DEBUG = 'Y' THEN
827: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After calling AHL_VWP_TASKS_PVT.Add_Return_To_Supply::Return Status::'||l_return_status );
828: END IF;
829:
830: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
831: x_msg_count := l_msg_count;

Line 840: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Before calling AHL_VWP_PROJ_PROD_PVT.Release_MR...');

836:
837: -- STEP 3: Call VWP API to push tasks into production.
838:
839: IF G_DEBUG = 'Y' THEN
840: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Before calling AHL_VWP_PROJ_PROD_PVT.Release_MR...');
841: END IF;
842:
843: AHL_VWP_PROJ_PROD_PVT.Release_MR(
844: p_api_version => 1.0,

Line 861: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'After calling AHL_VWP_PROJ_PROD_PVT.Release_MR...Return status ::'||l_return_status);

857: p_firm_planned_flag => l_firm_planned_flag
858: );
859:
860: IF G_DEBUG = 'Y' THEN
861: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'After calling AHL_VWP_PROJ_PROD_PVT.Release_MR...Return status ::'||l_return_status);
862: END IF;
863:
864: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
865: x_msg_count := l_msg_count;

Line 884: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::No Workorder created for SR::'||l_create_task_tbl(1).service_request_id);

880: );
881: EXCEPTION
882: WHEN NO_DATA_FOUND THEN
883: IF G_DEBUG = 'Y' THEN
884: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::No Workorder created for SR::'||l_create_task_tbl(1).service_request_id);
885: END IF;
886: RAISE NO_DATA_FOUND;
887: END;
888:

Line 915: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::End private API:' );

911: p_x_prd_workoper_tbl => l_prd_workoper_tbl
912: );
913:
914: IF G_DEBUG = 'Y' THEN
915: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::End private API:' );
916: END IF;
917:
918: -- Commit if p_commit = FND_API.G_TRUE
919: IF FND_API.TO_BOOLEAN(p_commit)

Line 991: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::.Begin of the API');

987:
988: BEGIN
989:
990: IF (G_DEBUG = 'Y') THEN
991: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::.Begin of the API');
992: END IF;
993:
994: -- initialize procedure return status to success
995: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 998: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':arguments: '||

994: -- initialize procedure return status to success
995: x_return_status := FND_API.G_RET_STS_SUCCESS;
996:
997: IF (G_DEBUG = 'Y') THEN
998: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':arguments: '||
999: ' p_sr_incident_id > '||p_sr_incident_id||
1000: ', p_commit > '||p_commit||
1001: ',p_sr_profile_name>'||p_sr_profile_name||
1002: ',p_wf_sr_obj>'||p_wf_sr_obj||

Line 1025: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':the returned values from AHL_UTILITY_PVT.Get_WF_Process_Name : '||

1021: x_msg_data => l_msg_data,
1022: x_return_status => x_return_status);
1023:
1024: IF (G_DEBUG = 'Y') THEN
1025: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':the returned values from AHL_UTILITY_PVT.Get_WF_Process_Name : '||
1026: ' l_active_flag > '||l_active_flag||
1027: ', l_process_name > '||l_process_name||
1028: ', l_item_type > '||l_item_type||
1029: ', x_return_status > '||x_return_status);

Line 1044: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':before calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification with arguments: '||

1040: l_subject := FND_MESSAGE.GET_STRING(G_APP_NAME, p_wf_sr_sbj);
1041:
1042: IF (G_DEBUG = 'Y')
1043: THEN
1044: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':before calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification with arguments: '||
1045: ' p_object > '||p_wf_sr_obj||
1046: ', p_process_name > '||l_process_name||
1047: ', p_item_type > '||l_item_type||
1048: ', p_subject > '||l_subject||

Line 1071: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':after calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification, '||

1067: x_item_key => x_item_key,
1068: x_return_status => x_return_status);
1069:
1070: IF (G_DEBUG = 'Y') THEN
1071: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':after calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification, '||
1072: ' x_item_key > '||x_item_key||
1073: ', x_return_status > '||x_return_status);
1074: END IF;
1075:

Line 1088: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':At the end of the API');

1084: COMMIT WORK;
1085: END IF;
1086:
1087: IF (G_DEBUG = 'Y') THEN
1088: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':At the end of the API');
1089: END IF;
1090:
1091: END Launch_NR_Notification;
1092: