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

Line 5: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');

1: PACKAGE BODY AHL_PRD_NONROUTINE_PVT AS
2: /* $Header: AHLVPNRB.pls 120.10.12010000.3 2008/12/25 15:20:54 bachandr ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_NONROUTINE_PVT';
5: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
6: -----------------------------------
7: -- Declare Local Procedures --
8: -----------------------------------
9:

Line 209: AHL_DEBUG_PUB.enable_debug;

205: x_return_status := FND_API.G_RET_STS_SUCCESS;
206:
207: -- Enable Debug.
208: IF (G_DEBUG = 'Y') THEN
209: AHL_DEBUG_PUB.enable_debug;
210: END IF;
211:
212: -- Add debug mesg.
213: IF (G_DEBUG = 'Y') THEN

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

210: END IF;
211:
212: -- Add debug mesg.
213: IF (G_DEBUG = 'Y') THEN
214: AHL_DEBUG_PUB.debug('Begin private API:' || G_PKG_NAME || '.' || l_api_name);
215: END IF;
216:
217: --------------------------------------------------------------------------------
218: -- Clear id's if the module type is 'JSP'.

Line 230: AHL_DEBUG_PUB.debug('INPUT - module_type :'||p_module_type);

226: -- Call write to log procedure to log the input parameter
227: -- values for debug
228: IF (G_DEBUG = 'Y') THEN
229: write_to_log(p_sr_tasK_tbl => p_x_sr_task_tbl);
230: AHL_DEBUG_PUB.debug('INPUT - module_type :'||p_module_type);
231: END IF;
232:
233:
234: l_convert_validate_status := FND_API.G_RET_STS_SUCCESS;

Line 272: AHL_DEBUG_PUB.debug('PROC : Calling Convert_val_to_id procedure');

268:
269: END IF;
270:
271: IF (G_DEBUG = 'Y') THEN
272: AHL_DEBUG_PUB.debug('PROC : Calling Convert_val_to_id procedure');
273: END IF;
274:
275: -- Call value to id conversion
276: Convert_val_to_id( p_x_sr_task_rec => l_sr_task_rec,

Line 284: AHL_DEBUG_PUB.debug('PROC : Calling Default_and_validate_param procedure');

280: l_convert_validate_status := FND_API.G_RET_STS_ERROR;
281: END IF;
282:
283: IF (G_DEBUG = 'Y') THEN
284: AHL_DEBUG_PUB.debug('PROC : Calling Default_and_validate_param procedure');
285: END IF;
286:
287: -- Call the Default and validate param procedure
288: Default_and_validate_param( p_x_sr_task_rec => l_sr_task_rec,

Line 312: AHL_DEBUG_PUB.debug('PROC : Calling the Create SR procedure');

308:
309: IF ( upper(l_sr_task_rec.operation_type) = 'CREATE') THEN
310:
311: IF (G_DEBUG = 'Y') THEN
312: AHL_DEBUG_PUB.debug('PROC : Calling the Create SR procedure');
313: END IF;
314:
315: -- Call Create Service Request procedure
316:

Line 328: AHL_DEBUG_PUB.debug('PROC : Calling the Update SR procedure');

324:
325: ELSIF ( upper(l_sr_task_rec.operation_type) = 'UPDATE' ) THEN
326:
327: IF (G_DEBUG = 'Y') THEN
328: AHL_DEBUG_PUB.debug('PROC : Calling the Update SR procedure');
329: END IF;
330:
331: -- Call Update Service Request procedure
332: -- MR NR ER -- start

Line 386: AHL_DEBUG_PUB.debug('PROC : Calling the Create Task procedure');

382: FND_MSG_PUB.Initialize;
383: END IF;
384:
385: IF (G_DEBUG = 'Y') THEN
386: AHL_DEBUG_PUB.debug('PROC : Calling the Create Task procedure');
387: END IF;
388:
389: -- call Create VWP Task Api
390:

Line 490: AHL_DEBUG_PUB.debug('PROC : Calling the Update SR procedure');

486: CLOSE c_get_sr_details;
487:
488: -- NR MR ER -- end
489: IF (G_DEBUG = 'Y') THEN
490: AHL_DEBUG_PUB.debug('PROC : Calling the Update SR procedure');
491: END IF;
492: -- Call Update Service Request procedure
493: Update_sr( p_x_sr_task_rec => l_sr_task_rec,
494: x_return_status => l_return_status);

Line 549: AHL_DEBUG_PUB.debug('END - Successfully completion of '||G_PKG_NAME||'.'||l_api_name||' API ');

545: COMMIT WORK;
546: END IF;
547:
548: IF (G_DEBUG = 'Y') THEN
549: AHL_DEBUG_PUB.debug('END - Successfully completion of '||G_PKG_NAME||'.'||l_api_name||' API ');
550: END IF;
551:
552: -- Count and Get messages
553: FND_MSG_PUB.count_and_get

Line 561: AHL_DEBUG_PUB.disable_debug;

557: );
558:
559: -- Disable debug (if enabled)
560: IF (G_DEBUG = 'Y') THEN
561: AHL_DEBUG_PUB.disable_debug;
562: END IF;
563:
564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR THEN

Line 574: AHL_DEBUG_PUB.disable_debug;

570: p_encoded => fnd_api.g_false);
571:
572: -- Disable debug
573: IF (G_DEBUG = 'Y') THEN
574: AHL_DEBUG_PUB.disable_debug;
575: END IF;
576:
577:
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 587: AHL_DEBUG_PUB.disable_debug;

583: p_encoded => fnd_api.g_false);
584:
585: -- Disable debug
586: IF (G_DEBUG = 'Y') THEN
587: AHL_DEBUG_PUB.disable_debug;
588: END IF;
589:
590: WHEN OTHERS THEN
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 604: AHL_DEBUG_PUB.disable_debug;

600: p_encoded => fnd_api.g_false);
601:
602: -- Disable debug
603: IF (G_DEBUG = 'Y') THEN
604: AHL_DEBUG_PUB.disable_debug;
605: END IF;
606:
607: END Process_nonroutine_job;
608:

Line 1987: AHL_DEBUG_PUB.debug('Inputs for CS_SERVICEREQUEST_PUB.Create_ServiceRequest:');

1983: -- Call write to log procedure to log the input parameter
1984: -- values for debug
1985:
1986: IF (G_DEBUG = 'Y') THEN
1987: AHL_DEBUG_PUB.debug('Inputs for CS_SERVICEREQUEST_PUB.Create_ServiceRequest:');
1988: write_sr_to_log(
1989: p_service_request_rec => l_service_request_rec,
1990: p_notes_table => l_notes_table,
1991: p_contacts_table => l_contacts_table

Line 2953: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);

2949: Procedure write_to_log(p_sr_tasK_tbl IN ahl_prd_nonroutine_pvt.sr_task_tbl_type)
2950: IS
2951: BEGIN
2952: FOR i IN p_sr_task_tbl.FIRST..p_sr_task_tbl.LAST LOOP
2953: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);
2954: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);
2955: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
2956: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
2957: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);

Line 2954: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);

2950: IS
2951: BEGIN
2952: FOR i IN p_sr_task_tbl.FIRST..p_sr_task_tbl.LAST LOOP
2953: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);
2954: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);
2955: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
2956: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
2957: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
2958: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);

Line 2955: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);

2951: BEGIN
2952: FOR i IN p_sr_task_tbl.FIRST..p_sr_task_tbl.LAST LOOP
2953: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);
2954: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);
2955: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
2956: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
2957: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
2958: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
2959: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);

Line 2956: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);

2952: FOR i IN p_sr_task_tbl.FIRST..p_sr_task_tbl.LAST LOOP
2953: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);
2954: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);
2955: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
2956: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
2957: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
2958: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
2959: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
2960: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);

Line 2957: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);

2953: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);
2954: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);
2955: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
2956: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
2957: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
2958: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
2959: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
2960: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
2961: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);

Line 2958: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);

2954: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);
2955: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
2956: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
2957: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
2958: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
2959: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
2960: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
2961: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
2962: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);

Line 2959: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);

2955: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
2956: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
2957: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
2958: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
2959: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
2960: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
2961: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
2962: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
2963: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);

Line 2960: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);

2956: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
2957: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
2958: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
2959: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
2960: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
2961: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
2962: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
2963: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
2964: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);

Line 2961: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);

2957: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
2958: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
2959: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
2960: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
2961: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
2962: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
2963: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
2964: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
2965: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);

Line 2962: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);

2958: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
2959: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
2960: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
2961: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
2962: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
2963: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
2964: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
2965: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
2966: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);

Line 2963: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);

2959: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
2960: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
2961: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
2962: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
2963: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
2964: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
2965: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
2966: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
2967: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);

Line 2964: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);

2960: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
2961: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
2962: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
2963: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
2964: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
2965: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
2966: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
2967: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
2968: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);

Line 2965: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);

2961: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
2962: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
2963: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
2964: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
2965: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
2966: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
2967: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
2968: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
2969: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);

Line 2966: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);

2962: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
2963: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
2964: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
2965: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
2966: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
2967: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
2968: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
2969: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
2970: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);

Line 2967: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);

2963: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
2964: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
2965: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
2966: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
2967: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
2968: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
2969: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
2970: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
2971: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);

Line 2968: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);

2964: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
2965: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
2966: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
2967: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
2968: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
2969: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
2970: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
2971: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);
2972: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);

Line 2969: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);

2965: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
2966: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
2967: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
2968: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
2969: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
2970: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
2971: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);
2972: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);
2973: AHL_DEBUG_PUB.debug('INPUT - Operation type('||i||'):'||p_sr_task_tbl(i).operation_type);

Line 2970: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);

2966: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
2967: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
2968: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
2969: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
2970: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
2971: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);
2972: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);
2973: AHL_DEBUG_PUB.debug('INPUT - Operation type('||i||'):'||p_sr_task_tbl(i).operation_type);
2974: END LOOP;

Line 2971: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);

2967: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
2968: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
2969: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
2970: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
2971: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);
2972: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);
2973: AHL_DEBUG_PUB.debug('INPUT - Operation type('||i||'):'||p_sr_task_tbl(i).operation_type);
2974: END LOOP;
2975:

Line 2972: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);

2968: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
2969: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
2970: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
2971: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);
2972: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);
2973: AHL_DEBUG_PUB.debug('INPUT - Operation type('||i||'):'||p_sr_task_tbl(i).operation_type);
2974: END LOOP;
2975:
2976: END write_to_log;

Line 2973: AHL_DEBUG_PUB.debug('INPUT - Operation type('||i||'):'||p_sr_task_tbl(i).operation_type);

2969: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
2970: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
2971: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);
2972: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);
2973: AHL_DEBUG_PUB.debug('INPUT - Operation type('||i||'):'||p_sr_task_tbl(i).operation_type);
2974: END LOOP;
2975:
2976: END write_to_log;
2977:

Line 2991: AHL_DEBUG_PUB.debug('SR Rec:');

2987: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
2988: )
2989: IS
2990: BEGIN
2991: AHL_DEBUG_PUB.debug('SR Rec:');
2992: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);
2993: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
2994: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
2995: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);

Line 2992: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);

2988: )
2989: IS
2990: BEGIN
2991: AHL_DEBUG_PUB.debug('SR Rec:');
2992: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);
2993: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
2994: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
2995: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
2996: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);

Line 2993: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);

2989: IS
2990: BEGIN
2991: AHL_DEBUG_PUB.debug('SR Rec:');
2992: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);
2993: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
2994: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
2995: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
2996: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
2997: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);

Line 2994: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);

2990: BEGIN
2991: AHL_DEBUG_PUB.debug('SR Rec:');
2992: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);
2993: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
2994: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
2995: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
2996: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
2997: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
2998: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);

Line 2995: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);

2991: AHL_DEBUG_PUB.debug('SR Rec:');
2992: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);
2993: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
2994: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
2995: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
2996: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
2997: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
2998: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
2999: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);

Line 2996: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);

2992: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);
2993: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
2994: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
2995: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
2996: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
2997: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
2998: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
2999: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3000: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);

Line 2997: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);

2993: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
2994: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
2995: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
2996: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
2997: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
2998: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
2999: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3000: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3001: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);

Line 2998: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);

2994: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
2995: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
2996: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
2997: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
2998: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
2999: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3000: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3001: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3002: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);

Line 2999: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);

2995: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
2996: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
2997: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
2998: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
2999: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3000: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3001: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3002: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3003: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);

Line 3000: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);

2996: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
2997: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
2998: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
2999: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3000: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3001: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3002: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3003: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3004: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);

Line 3001: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);

2997: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
2998: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
2999: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3000: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3001: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3002: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3003: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3004: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);
3005: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);

Line 3002: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);

2998: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
2999: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3000: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3001: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3002: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3003: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3004: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);
3005: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);
3006: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);

Line 3003: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);

2999: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3000: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3001: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3002: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3003: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3004: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);
3005: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);
3006: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);
3007:

Line 3004: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);

3000: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3001: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3002: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3003: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3004: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);
3005: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);
3006: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);
3007:
3008: -- Contacts

Line 3005: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);

3001: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3002: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3003: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3004: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);
3005: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);
3006: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);
3007:
3008: -- Contacts
3009: AHL_DEBUG_PUB.debug('Contacts:');

Line 3006: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);

3002: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3003: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3004: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);
3005: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);
3006: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);
3007:
3008: -- Contacts
3009: AHL_DEBUG_PUB.debug('Contacts:');
3010: AHL_DEBUG_PUB.debug('party_id:'||p_contacts_table(1).party_id);

Line 3009: AHL_DEBUG_PUB.debug('Contacts:');

3005: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);
3006: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);
3007:
3008: -- Contacts
3009: AHL_DEBUG_PUB.debug('Contacts:');
3010: AHL_DEBUG_PUB.debug('party_id:'||p_contacts_table(1).party_id);
3011: AHL_DEBUG_PUB.debug('contact_type:'||p_contacts_table(1).contact_type);
3012: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);
3013:

Line 3010: AHL_DEBUG_PUB.debug('party_id:'||p_contacts_table(1).party_id);

3006: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);
3007:
3008: -- Contacts
3009: AHL_DEBUG_PUB.debug('Contacts:');
3010: AHL_DEBUG_PUB.debug('party_id:'||p_contacts_table(1).party_id);
3011: AHL_DEBUG_PUB.debug('contact_type:'||p_contacts_table(1).contact_type);
3012: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);
3013:
3014: -- Notes

Line 3011: AHL_DEBUG_PUB.debug('contact_type:'||p_contacts_table(1).contact_type);

3007:
3008: -- Contacts
3009: AHL_DEBUG_PUB.debug('Contacts:');
3010: AHL_DEBUG_PUB.debug('party_id:'||p_contacts_table(1).party_id);
3011: AHL_DEBUG_PUB.debug('contact_type:'||p_contacts_table(1).contact_type);
3012: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);
3013:
3014: -- Notes
3015: AHL_DEBUG_PUB.debug('Notes:');

Line 3012: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);

3008: -- Contacts
3009: AHL_DEBUG_PUB.debug('Contacts:');
3010: AHL_DEBUG_PUB.debug('party_id:'||p_contacts_table(1).party_id);
3011: AHL_DEBUG_PUB.debug('contact_type:'||p_contacts_table(1).contact_type);
3012: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);
3013:
3014: -- Notes
3015: AHL_DEBUG_PUB.debug('Notes:');
3016: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);

Line 3015: AHL_DEBUG_PUB.debug('Notes:');

3011: AHL_DEBUG_PUB.debug('contact_type:'||p_contacts_table(1).contact_type);
3012: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);
3013:
3014: -- Notes
3015: AHL_DEBUG_PUB.debug('Notes:');
3016: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);
3017: AHL_DEBUG_PUB.debug('note_detail:'||p_notes_table(1).note_detail);
3018: AHL_DEBUG_PUB.debug('note_type:'||p_notes_table(1).note_type);
3019: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);

Line 3016: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);

3012: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);
3013:
3014: -- Notes
3015: AHL_DEBUG_PUB.debug('Notes:');
3016: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);
3017: AHL_DEBUG_PUB.debug('note_detail:'||p_notes_table(1).note_detail);
3018: AHL_DEBUG_PUB.debug('note_type:'||p_notes_table(1).note_type);
3019: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);
3020: END write_sr_to_log;

Line 3017: AHL_DEBUG_PUB.debug('note_detail:'||p_notes_table(1).note_detail);

3013:
3014: -- Notes
3015: AHL_DEBUG_PUB.debug('Notes:');
3016: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);
3017: AHL_DEBUG_PUB.debug('note_detail:'||p_notes_table(1).note_detail);
3018: AHL_DEBUG_PUB.debug('note_type:'||p_notes_table(1).note_type);
3019: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);
3020: END write_sr_to_log;
3021:

Line 3018: AHL_DEBUG_PUB.debug('note_type:'||p_notes_table(1).note_type);

3014: -- Notes
3015: AHL_DEBUG_PUB.debug('Notes:');
3016: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);
3017: AHL_DEBUG_PUB.debug('note_detail:'||p_notes_table(1).note_detail);
3018: AHL_DEBUG_PUB.debug('note_type:'||p_notes_table(1).note_type);
3019: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);
3020: END write_sr_to_log;
3021:
3022:

Line 3019: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);

3015: AHL_DEBUG_PUB.debug('Notes:');
3016: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);
3017: AHL_DEBUG_PUB.debug('note_detail:'||p_notes_table(1).note_detail);
3018: AHL_DEBUG_PUB.debug('note_type:'||p_notes_table(1).note_type);
3019: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);
3020: END write_sr_to_log;
3021:
3022:
3023: END AHL_PRD_NONROUTINE_PVT;