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.26.12020000.2 2012/12/07 07:59:01 sareepar 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 225: AHL_DEBUG_PUB.enable_debug;

221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: -- Enable Debug.
224: IF (G_DEBUG = 'Y') THEN
225: AHL_DEBUG_PUB.enable_debug;
226: END IF;
227:
228: -- Add debug mesg.
229: IF (G_DEBUG = 'Y') THEN

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

226: END IF;
227:
228: -- Add debug mesg.
229: IF (G_DEBUG = 'Y') THEN
230: AHL_DEBUG_PUB.debug('Begin private API:' || G_PKG_NAME || '.' || l_api_name);
231: END IF;
232:
233: --------------------------------------------------------------------------------
234: -- Clear id's if the module type is 'JSP'.

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

242: -- Call write to log procedure to log the input parameter
243: -- values for debug
244: IF (G_DEBUG = 'Y') THEN
245: write_to_log(p_sr_tasK_tbl => p_x_sr_task_tbl);
246: AHL_DEBUG_PUB.debug('INPUT - module_type :'||p_module_type);
247: END IF;
248:
249:
250: l_convert_validate_status := FND_API.G_RET_STS_SUCCESS;

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

284:
285: END IF;
286:
287: IF (G_DEBUG = 'Y') THEN
288: AHL_DEBUG_PUB.debug('PROC : Calling Convert_val_to_id procedure');
289: END IF;
290:
291: -- Call value to id conversion
292: Convert_val_to_id( p_x_sr_task_rec => l_sr_task_rec,

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

296: l_convert_validate_status := FND_API.G_RET_STS_ERROR;
297: END IF;
298:
299: IF (G_DEBUG = 'Y') THEN
300: AHL_DEBUG_PUB.debug('PROC : Calling Default_and_validate_param procedure');
301: END IF;
302:
303: -- Call the Default and validate param procedure
304: Default_and_validate_param( p_x_sr_task_rec => l_sr_task_rec,

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

325:
326: IF ( upper(l_sr_task_rec.operation_type) = 'CREATE') THEN
327:
328: IF (G_DEBUG = 'Y') THEN
329: AHL_DEBUG_PUB.debug('PROC : Calling the Create SR procedure');
330: END IF;
331:
332: -- Call Create Service Request procedure
333:

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

341:
342: ELSIF ( upper(l_sr_task_rec.operation_type) = 'UPDATE' ) THEN
343:
344: IF (G_DEBUG = 'Y') THEN
345: AHL_DEBUG_PUB.debug('PROC : Calling the Update SR procedure');
346: END IF;
347:
348: -- Call Update Service Request procedure
349: -- MR NR ER -- start

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

401:
402: -- NR MR ER -- start
403: /*
404: IF (G_DEBUG = 'Y') THEN
405: AHL_DEBUG_PUB.debug('PROC : Calling the Create Task procedure');
406: END IF;
407:
408: -- call Create VWP Task Api
409:

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

543: CLOSE c_get_sr_details;
544:
545: -- NR MR ER -- end
546: IF (G_DEBUG = 'Y') THEN
547: AHL_DEBUG_PUB.debug('PROC : Calling the Update SR procedure');
548: END IF;
549: -- Call Update Service Request procedure
550: Update_sr( p_x_sr_task_rec => l_sr_task_rec,
551: x_return_status => l_return_status);

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

602: COMMIT WORK;
603: END IF;
604:
605: IF (G_DEBUG = 'Y') THEN
606: AHL_DEBUG_PUB.debug('END - Successfully completion of '||G_PKG_NAME||'.'||l_api_name||' API ');
607: END IF;
608:
609: -- Count and Get messages
610: FND_MSG_PUB.count_and_get

Line 618: AHL_DEBUG_PUB.disable_debug;

614: );
615:
616: -- Disable debug (if enabled)
617: IF (G_DEBUG = 'Y') THEN
618: AHL_DEBUG_PUB.disable_debug;
619: END IF;
620:
621: EXCEPTION
622: WHEN FND_API.G_EXC_ERROR THEN

Line 631: AHL_DEBUG_PUB.disable_debug;

627: p_encoded => fnd_api.g_false);
628:
629: -- Disable debug
630: IF (G_DEBUG = 'Y') THEN
631: AHL_DEBUG_PUB.disable_debug;
632: END IF;
633:
634:
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 644: AHL_DEBUG_PUB.disable_debug;

640: p_encoded => fnd_api.g_false);
641:
642: -- Disable debug
643: IF (G_DEBUG = 'Y') THEN
644: AHL_DEBUG_PUB.disable_debug;
645: END IF;
646:
647: WHEN OTHERS THEN
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 661: AHL_DEBUG_PUB.disable_debug;

657: p_encoded => fnd_api.g_false);
658:
659: -- Disable debug
660: IF (G_DEBUG = 'Y') THEN
661: AHL_DEBUG_PUB.disable_debug;
662: END IF;
663:
664: END Process_nonroutine_job;
665:

Line 2188: AHL_DEBUG_PUB.debug('Input SR type:ID:' || l_service_request_rec.type_name || ':' || l_service_request_rec.type_id );

2184: IF (get_inc_type_id%FOUND) THEN
2185: l_service_request_rec.type_name := p_x_sr_task_rec.type_name;
2186: l_default_sr_flag := FALSE;
2187: IF (G_DEBUG = 'Y') THEN
2188: AHL_DEBUG_PUB.debug('Input SR type:ID:' || l_service_request_rec.type_name || ':' || l_service_request_rec.type_id );
2189: END IF;
2190: END IF;
2191: CLOSE get_inc_type_id;
2192: END IF;

Line 2206: AHL_DEBUG_PUB.debug('Defaulting SR type:ID:' || l_service_request_rec.type_name || ':' || l_service_request_rec.type_id );

2202: x_return_status := FND_API.G_RET_STS_ERROR;
2203: END IF;
2204:
2205: IF (G_DEBUG = 'Y') THEN
2206: AHL_DEBUG_PUB.debug('Defaulting SR type:ID:' || l_service_request_rec.type_name || ':' || l_service_request_rec.type_id );
2207: END IF;
2208:
2209: CLOSE default_incident_type_id;
2210: END IF;

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

2225: -- Call write to log procedure to log the input parameter
2226: -- values for debug
2227:
2228: IF (G_DEBUG = 'Y') THEN
2229: AHL_DEBUG_PUB.debug('Inputs for CS_SERVICEREQUEST_PUB.Create_ServiceRequest:');
2230: write_sr_to_log(
2231: p_service_request_rec => l_service_request_rec,
2232: p_notes_table => l_notes_table,
2233: p_contacts_table => l_contacts_table

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

3614: Procedure write_to_log(p_sr_tasK_tbl IN ahl_prd_nonroutine_pvt.sr_task_tbl_type)
3615: IS
3616: BEGIN
3617: FOR i IN p_sr_task_tbl.FIRST..p_sr_task_tbl.LAST LOOP
3618: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);
3619: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);
3620: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
3621: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
3622: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);

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

3615: IS
3616: BEGIN
3617: FOR i IN p_sr_task_tbl.FIRST..p_sr_task_tbl.LAST LOOP
3618: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);
3619: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);
3620: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
3621: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
3622: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
3623: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);

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

3616: BEGIN
3617: FOR i IN p_sr_task_tbl.FIRST..p_sr_task_tbl.LAST LOOP
3618: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);
3619: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);
3620: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
3621: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
3622: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
3623: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
3624: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);

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

3617: FOR i IN p_sr_task_tbl.FIRST..p_sr_task_tbl.LAST LOOP
3618: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);
3619: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);
3620: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
3621: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
3622: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
3623: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
3624: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
3625: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);

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

3618: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);
3619: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);
3620: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
3621: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
3622: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
3623: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
3624: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
3625: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
3626: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);

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

3619: AHL_DEBUG_PUB.debug('INPUT - Type Name('||i||'):'||p_sr_task_tbl(i).type_name);
3620: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
3621: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
3622: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
3623: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
3624: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
3625: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
3626: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
3627: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);

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

3620: AHL_DEBUG_PUB.debug('INPUT - Status Id('||i||'):'||p_sr_task_tbl(i).status_id);
3621: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
3622: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
3623: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
3624: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
3625: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
3626: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
3627: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
3628: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);

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

3621: AHL_DEBUG_PUB.debug('INPUT - Status Name('||i||'):'||p_sr_task_tbl(i).status_name);
3622: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
3623: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
3624: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
3625: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
3626: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
3627: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
3628: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
3629: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);

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

3622: AHL_DEBUG_PUB.debug('INPUT - Severity Id('||i||'):'||p_sr_task_tbl(i).severity_id);
3623: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
3624: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
3625: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
3626: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
3627: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
3628: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
3629: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
3630: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);

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

3623: AHL_DEBUG_PUB.debug('INPUT - Severity Name('||i||'):'||p_sr_task_tbl(i).severity_name);
3624: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
3625: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
3626: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
3627: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
3628: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
3629: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
3630: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
3631: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);

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

3624: AHL_DEBUG_PUB.debug('INPUT - Urgency id('||i||'):'||p_sr_task_tbl(i).Urgency_id);
3625: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
3626: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
3627: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
3628: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
3629: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
3630: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
3631: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
3632: AHL_DEBUG_PUB.debug('INPUT - Summary ('||i||'):'||p_sr_task_tbl(i).Summary);

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

3625: AHL_DEBUG_PUB.debug('INPUT - Urgency name('||i||'):'||p_sr_task_tbl(i).Urgency_name);
3626: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
3627: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
3628: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
3629: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
3630: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
3631: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
3632: AHL_DEBUG_PUB.debug('INPUT - Summary ('||i||'):'||p_sr_task_tbl(i).Summary);
3633: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);

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

3626: AHL_DEBUG_PUB.debug('INPUT - Customer type('||i||'):'||p_sr_task_tbl(i).Customer_type);
3627: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
3628: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
3629: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
3630: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
3631: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
3632: AHL_DEBUG_PUB.debug('INPUT - Summary ('||i||'):'||p_sr_task_tbl(i).Summary);
3633: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
3634: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);

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

3627: AHL_DEBUG_PUB.debug('INPUT - Customer id('||i||'):'||p_sr_task_tbl(i).Customer_id);
3628: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
3629: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
3630: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
3631: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
3632: AHL_DEBUG_PUB.debug('INPUT - Summary ('||i||'):'||p_sr_task_tbl(i).Summary);
3633: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
3634: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
3635: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);

Line 3632: AHL_DEBUG_PUB.debug('INPUT - Summary ('||i||'):'||p_sr_task_tbl(i).Summary);

3628: AHL_DEBUG_PUB.debug('INPUT - Customer name('||i||'):'||p_sr_task_tbl(i).Customer_name);
3629: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
3630: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
3631: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
3632: AHL_DEBUG_PUB.debug('INPUT - Summary ('||i||'):'||p_sr_task_tbl(i).Summary);
3633: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
3634: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
3635: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
3636: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);

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

3629: AHL_DEBUG_PUB.debug('INPUT - Contact type('||i||'):'||p_sr_task_tbl(i).Contact_type);
3630: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
3631: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
3632: AHL_DEBUG_PUB.debug('INPUT - Summary ('||i||'):'||p_sr_task_tbl(i).Summary);
3633: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
3634: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
3635: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
3636: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
3637: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);

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

3630: AHL_DEBUG_PUB.debug('INPUT - Contact Id('||i||'):'||p_sr_task_tbl(i).Contact_id);
3631: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
3632: AHL_DEBUG_PUB.debug('INPUT - Summary ('||i||'):'||p_sr_task_tbl(i).Summary);
3633: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
3634: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
3635: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
3636: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
3637: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);
3638: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);

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

3631: AHL_DEBUG_PUB.debug('INPUT - Contact name('||i||'):'||p_sr_task_tbl(i).Contact_name);
3632: AHL_DEBUG_PUB.debug('INPUT - Summary ('||i||'):'||p_sr_task_tbl(i).Summary);
3633: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
3634: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
3635: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
3636: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
3637: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);
3638: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);
3639: AHL_DEBUG_PUB.debug('INPUT - Operation type('||i||'):'||p_sr_task_tbl(i).operation_type);

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

3632: AHL_DEBUG_PUB.debug('INPUT - Summary ('||i||'):'||p_sr_task_tbl(i).Summary);
3633: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
3634: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
3635: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
3636: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
3637: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);
3638: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);
3639: AHL_DEBUG_PUB.debug('INPUT - Operation type('||i||'):'||p_sr_task_tbl(i).operation_type);
3640: END LOOP;

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

3633: AHL_DEBUG_PUB.debug('INPUT - Instance Id('||i||'):'||p_sr_task_tbl(i).Instance_id);
3634: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
3635: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
3636: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
3637: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);
3638: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);
3639: AHL_DEBUG_PUB.debug('INPUT - Operation type('||i||'):'||p_sr_task_tbl(i).operation_type);
3640: END LOOP;
3641:

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

3634: AHL_DEBUG_PUB.debug('INPUT - Instance number('||i||'):'||p_sr_task_tbl(i).Instance_number);
3635: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
3636: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
3637: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);
3638: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);
3639: AHL_DEBUG_PUB.debug('INPUT - Operation type('||i||'):'||p_sr_task_tbl(i).operation_type);
3640: END LOOP;
3641:
3642: END write_to_log;

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

3635: AHL_DEBUG_PUB.debug('INPUT - Visit Id('||i||'):'||p_sr_task_tbl(i).visit_id);
3636: AHL_DEBUG_PUB.debug('INPUT - Visit number('||i||'):'||p_sr_task_tbl(i).visit_number);
3637: AHL_DEBUG_PUB.debug('INPUT - Originating wo id('||i||'):'||p_sr_task_tbl(i).originating_wo_id);
3638: AHL_DEBUG_PUB.debug('INPUT - Incident obj ver num('||i||'):'||p_sr_task_tbl(i).incident_object_version_number);
3639: AHL_DEBUG_PUB.debug('INPUT - Operation type('||i||'):'||p_sr_task_tbl(i).operation_type);
3640: END LOOP;
3641:
3642: END write_to_log;
3643:

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

3653: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
3654: )
3655: IS
3656: BEGIN
3657: AHL_DEBUG_PUB.debug('SR Rec:');
3658: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);
3659: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
3660: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
3661: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);

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

3654: )
3655: IS
3656: BEGIN
3657: AHL_DEBUG_PUB.debug('SR Rec:');
3658: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);
3659: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
3660: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
3661: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
3662: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);

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

3655: IS
3656: BEGIN
3657: AHL_DEBUG_PUB.debug('SR Rec:');
3658: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);
3659: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
3660: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
3661: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
3662: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
3663: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);

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

3656: BEGIN
3657: AHL_DEBUG_PUB.debug('SR Rec:');
3658: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);
3659: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
3660: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
3661: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
3662: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
3663: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
3664: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);

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

3657: AHL_DEBUG_PUB.debug('SR Rec:');
3658: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);
3659: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
3660: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
3661: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
3662: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
3663: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
3664: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
3665: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);

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

3658: AHL_DEBUG_PUB.debug('request_date:'||p_service_request_rec.request_date);
3659: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
3660: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
3661: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
3662: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
3663: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
3664: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
3665: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3666: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);

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

3659: AHL_DEBUG_PUB.debug('type_id:'||p_service_request_rec.type_id);
3660: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
3661: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
3662: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
3663: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
3664: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
3665: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3666: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3667: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);

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

3660: AHL_DEBUG_PUB.debug('type_name:'||p_service_request_rec.type_name);
3661: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
3662: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
3663: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
3664: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
3665: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3666: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3667: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3668: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);

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

3661: AHL_DEBUG_PUB.debug('status_id:'||p_service_request_rec.status_id);
3662: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
3663: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
3664: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
3665: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3666: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3667: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3668: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3669: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);

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

3662: AHL_DEBUG_PUB.debug('status_name:'||p_service_request_rec.status_name);
3663: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
3664: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
3665: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3666: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3667: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3668: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3669: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3670: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);

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

3663: AHL_DEBUG_PUB.debug('severity_id:'||p_service_request_rec.severity_id);
3664: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
3665: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3666: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3667: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3668: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3669: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3670: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);
3671: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);

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

3664: AHL_DEBUG_PUB.debug('severity_name:'||p_service_request_rec.severity_name);
3665: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3666: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3667: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3668: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3669: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3670: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);
3671: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);
3672: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);

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

3665: AHL_DEBUG_PUB.debug('urgency_id:'||p_service_request_rec.urgency_id);
3666: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3667: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3668: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3669: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3670: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);
3671: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);
3672: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);
3673:

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

3666: AHL_DEBUG_PUB.debug('summary:'||p_service_request_rec.summary);
3667: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3668: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3669: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3670: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);
3671: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);
3672: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);
3673:
3674: -- Contacts

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

3667: AHL_DEBUG_PUB.debug('caller_type:'||p_service_request_rec.caller_type);
3668: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3669: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3670: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);
3671: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);
3672: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);
3673:
3674: -- Contacts
3675: AHL_DEBUG_PUB.debug('Contacts:');

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

3668: AHL_DEBUG_PUB.debug('customer_id:'||p_service_request_rec.customer_id);
3669: AHL_DEBUG_PUB.debug('problem_code:'||p_service_request_rec.problem_code);
3670: AHL_DEBUG_PUB.debug('resolution_code:'||p_service_request_rec.resolution_code);
3671: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);
3672: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);
3673:
3674: -- Contacts
3675: AHL_DEBUG_PUB.debug('Contacts:');
3676: AHL_DEBUG_PUB.debug('party_id:'||p_contacts_table(1).party_id);

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

3671: AHL_DEBUG_PUB.debug('creation_program_code:'||p_service_request_rec.creation_program_code);
3672: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);
3673:
3674: -- Contacts
3675: AHL_DEBUG_PUB.debug('Contacts:');
3676: AHL_DEBUG_PUB.debug('party_id:'||p_contacts_table(1).party_id);
3677: AHL_DEBUG_PUB.debug('contact_type:'||p_contacts_table(1).contact_type);
3678: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);
3679:

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

3672: AHL_DEBUG_PUB.debug('urgency_name:'||p_service_request_rec.urgency_name);
3673:
3674: -- Contacts
3675: AHL_DEBUG_PUB.debug('Contacts:');
3676: AHL_DEBUG_PUB.debug('party_id:'||p_contacts_table(1).party_id);
3677: AHL_DEBUG_PUB.debug('contact_type:'||p_contacts_table(1).contact_type);
3678: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);
3679:
3680: -- Notes

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

3673:
3674: -- Contacts
3675: AHL_DEBUG_PUB.debug('Contacts:');
3676: AHL_DEBUG_PUB.debug('party_id:'||p_contacts_table(1).party_id);
3677: AHL_DEBUG_PUB.debug('contact_type:'||p_contacts_table(1).contact_type);
3678: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);
3679:
3680: -- Notes
3681: AHL_DEBUG_PUB.debug('Notes:');

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

3674: -- Contacts
3675: AHL_DEBUG_PUB.debug('Contacts:');
3676: AHL_DEBUG_PUB.debug('party_id:'||p_contacts_table(1).party_id);
3677: AHL_DEBUG_PUB.debug('contact_type:'||p_contacts_table(1).contact_type);
3678: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);
3679:
3680: -- Notes
3681: AHL_DEBUG_PUB.debug('Notes:');
3682: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);

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

3677: AHL_DEBUG_PUB.debug('contact_type:'||p_contacts_table(1).contact_type);
3678: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);
3679:
3680: -- Notes
3681: AHL_DEBUG_PUB.debug('Notes:');
3682: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);
3683: AHL_DEBUG_PUB.debug('note_detail:'||p_notes_table(1).note_detail);
3684: AHL_DEBUG_PUB.debug('note_type:'||p_notes_table(1).note_type);
3685: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);

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

3678: AHL_DEBUG_PUB.debug('primary_flag:'||p_contacts_table(1).primary_flag);
3679:
3680: -- Notes
3681: AHL_DEBUG_PUB.debug('Notes:');
3682: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);
3683: AHL_DEBUG_PUB.debug('note_detail:'||p_notes_table(1).note_detail);
3684: AHL_DEBUG_PUB.debug('note_type:'||p_notes_table(1).note_type);
3685: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);
3686: END write_sr_to_log;

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

3679:
3680: -- Notes
3681: AHL_DEBUG_PUB.debug('Notes:');
3682: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);
3683: AHL_DEBUG_PUB.debug('note_detail:'||p_notes_table(1).note_detail);
3684: AHL_DEBUG_PUB.debug('note_type:'||p_notes_table(1).note_type);
3685: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);
3686: END write_sr_to_log;
3687:

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

3680: -- Notes
3681: AHL_DEBUG_PUB.debug('Notes:');
3682: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);
3683: AHL_DEBUG_PUB.debug('note_detail:'||p_notes_table(1).note_detail);
3684: AHL_DEBUG_PUB.debug('note_type:'||p_notes_table(1).note_type);
3685: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);
3686: END write_sr_to_log;
3687:
3688:

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

3681: AHL_DEBUG_PUB.debug('Notes:');
3682: AHL_DEBUG_PUB.debug('note:'||p_notes_table(1).note);
3683: AHL_DEBUG_PUB.debug('note_detail:'||p_notes_table(1).note_detail);
3684: AHL_DEBUG_PUB.debug('note_type:'||p_notes_table(1).note_type);
3685: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);
3686: END write_sr_to_log;
3687:
3688:
3689: END AHL_PRD_NONROUTINE_PVT;