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

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

11:
12:
13:
14:
15: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
16:
17:
18:
19: PROCEDURE UPLOAD_ITEM

Line 69: AHL_DEBUG_PUB.enable_debug;

65: SAVEPOINT UPLOAD_ITEM;
66:
67: -- Check if API is called in debug mode. If yes, enable debug.
68: IF G_DEBUG='Y' THEN
69: AHL_DEBUG_PUB.enable_debug;
70:
71: END IF;
72: -- Debug info.
73: IF G_DEBUG='Y' THEN

Line 74: AHL_DEBUG_PUB.debug( 'enter private AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');

70:
71: END IF;
72: -- Debug info.
73: IF G_DEBUG='Y' THEN
74: AHL_DEBUG_PUB.debug( 'enter private AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');
75:
76:
77: END IF;
78:

Line 114: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_DOC REV ID:'||p_x_ahl_fileupload_rec.p_revision_id||': invalid');

110: WHEN no_data_found THEN
111: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');
112: FND_MSG_PUB.ADD;
113: IF G_DEBUG='Y' THEN
114: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_DOC REV ID:'||p_x_ahl_fileupload_rec.p_revision_id||': invalid');
115:
116:
117: END IF;
118: x_return_status := FND_API.G_RET_STS_ERROR;

Line 127: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_DOC REV null');

123: ELSE
124: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_NULL');
125: FND_MSG_PUB.ADD;
126: IF G_DEBUG='Y' THEN
127: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_DOC REV null');
128:
129: END IF;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: END IF;

Line 147: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_ATTACH_FILE_NOT_EXISTS');

143: WHERE FILE_ID = p_x_ahl_fileupload_rec.p_file_id;
144: EXCEPTION
145: WHEN no_data_found THEN
146: IF G_DEBUG='Y' THEN
147: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_ATTACH_FILE_NOT_EXISTS');
148: END IF;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: WHEN OTHERS THEN
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 156: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_ATTACH_FILE IS Null');

152: RAISE;
153: END;
154: ELSE
155: IF G_DEBUG='Y' THEN
156: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_ATTACH_FILE IS Null');
157: END IF;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: END IF;
160:

Line 164: AHL_DEBUG_PUB.debug( 'checking for already existing file ');

160:
161:
162: -- check if association exists
163: IF G_DEBUG='Y' THEN
164: AHL_DEBUG_PUB.debug( 'checking for already existing file ');
165: END IF;
166:
167: open c_does_attach_exist (p_x_ahl_fileupload_rec.p_revision_id);
168:

Line 172: AHL_DEBUG_PUB.debug( 'l_attach_doc value '|| l_attach_doc.file_id);

168:
169: LOOP
170: fetch c_does_attach_exist into l_attach_doc;
171: exit when c_does_attach_exist%NOTFOUND;
172: AHL_DEBUG_PUB.debug( 'l_attach_doc value '|| l_attach_doc.file_id);
173: AHL_DEBUG_PUB.debug( 'l_attach_doc value '|| l_attach_doc.file_name);
174: l_is_exist_mid := l_attach_doc.file_id;
175:
176: END LOOP;

Line 173: AHL_DEBUG_PUB.debug( 'l_attach_doc value '|| l_attach_doc.file_name);

169: LOOP
170: fetch c_does_attach_exist into l_attach_doc;
171: exit when c_does_attach_exist%NOTFOUND;
172: AHL_DEBUG_PUB.debug( 'l_attach_doc value '|| l_attach_doc.file_id);
173: AHL_DEBUG_PUB.debug( 'l_attach_doc value '|| l_attach_doc.file_name);
174: l_is_exist_mid := l_attach_doc.file_id;
175:
176: END LOOP;
177: close c_does_attach_exist;

Line 197: AHL_DEBUG_PUB.debug('completed delete if there are any ');

193: );
194:
195: end if;
196: IF G_DEBUG='Y' THEN
197: AHL_DEBUG_PUB.debug('completed delete if there are any ');
198: END IF;
199:
200: -- get new associationid from sequence.
201:

Line 254: AHL_DEBUG_PUB.debug( 'End of private api UPLOAD_ITEM');

250: COMMIT;
251: END IF;
252: -- Debug info
253: IF G_DEBUG='Y' THEN
254: AHL_DEBUG_PUB.debug( 'End of private api UPLOAD_ITEM');
255:
256:
257: END IF;
258: -- Check if API is called in debug mode. If yes, disable debug.

Line 260: AHL_DEBUG_PUB.disable_debug;

256:
257: END IF;
258: -- Check if API is called in debug mode. If yes, disable debug.
259: IF G_DEBUG='Y' THEN
260: AHL_DEBUG_PUB.disable_debug;
261:
262: END IF;
263:
264: EXCEPTION

Line 272: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

268: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,
270: p_data => x_msg_data);
271: IF G_DEBUG='Y' THEN
272: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
273: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');
274:
275: -- Check if API is called in debug mode. If yes, disable debug.
276: AHL_DEBUG_PUB.disable_debug;

Line 273: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');

269: p_count => x_msg_count,
270: p_data => x_msg_data);
271: IF G_DEBUG='Y' THEN
272: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
273: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');
274:
275: -- Check if API is called in debug mode. If yes, disable debug.
276: AHL_DEBUG_PUB.disable_debug;
277:

Line 276: AHL_DEBUG_PUB.disable_debug;

272: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
273: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');
274:
275: -- Check if API is called in debug mode. If yes, disable debug.
276: AHL_DEBUG_PUB.disable_debug;
277:
278: END IF;
279:
280: WHEN FND_API.G_EXC_ERROR THEN

Line 288: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

284: p_count => x_msg_count,
285: p_data => X_msg_data);
286: -- Debug info.
287: IF G_DEBUG='Y' THEN
288: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
289: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');
290:
291: -- Check if API is called in debug mode. If yes, disable debug.
292: AHL_DEBUG_PUB.disable_debug;

Line 289: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');

285: p_data => X_msg_data);
286: -- Debug info.
287: IF G_DEBUG='Y' THEN
288: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
289: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');
290:
291: -- Check if API is called in debug mode. If yes, disable debug.
292: AHL_DEBUG_PUB.disable_debug;
293:

Line 292: AHL_DEBUG_PUB.disable_debug;

288: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
289: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');
290:
291: -- Check if API is called in debug mode. If yes, disable debug.
292: AHL_DEBUG_PUB.disable_debug;
293:
294: END IF;
295:
296: WHEN OTHERS THEN

Line 310: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

306: p_data => x_msg_data);
307:
308: -- Debug info.
309: IF G_DEBUG='Y' THEN
310: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
311: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');
312:
313: -- Check if API is called in debug mode. If yes, disable debug.
314: AHL_DEBUG_PUB.disable_debug;

Line 311: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');

307:
308: -- Debug info.
309: IF G_DEBUG='Y' THEN
310: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
311: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');
312:
313: -- Check if API is called in debug mode. If yes, disable debug.
314: AHL_DEBUG_PUB.disable_debug;
315:

Line 314: AHL_DEBUG_PUB.disable_debug;

310: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
311: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.UPLOAD_ITEM');
312:
313: -- Check if API is called in debug mode. If yes, disable debug.
314: AHL_DEBUG_PUB.disable_debug;
315:
316: END IF;
317:
318: END UPLOAD_ITEM;

Line 357: AHL_DEBUG_PUB.enable_debug;

353: SAVEPOINT Delete_Item;
354:
355: -- Check if API is called in debug mode. If yes, enable debug.
356: IF G_DEBUG='Y' THEN
357: AHL_DEBUG_PUB.enable_debug;
358:
359: END IF;
360: -- Debug info.
361: IF G_DEBUG='Y' THEN

Line 362: AHL_DEBUG_PUB.debug( 'enter private AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');

358:
359: END IF;
360: -- Debug info.
361: IF G_DEBUG='Y' THEN
362: AHL_DEBUG_PUB.debug( 'enter private AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');
363: END IF;
364:
365:
366: -- Standard call to check for call compatibility.

Line 389: AHL_DEBUG_PUB.debug( 'enter private AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');

385:
386: --Validate Document Revision Id
387:
388: IF G_DEBUG='Y' THEN
389: AHL_DEBUG_PUB.debug( 'enter private AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');
390: END IF;
391:
392: IF (p_x_ahl_fileupload_rec.p_revision_id IS NOT NULL) THEN
393: BEGIN

Line 401: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_DOC_REV_ID_INVALID');

397: WHERE DOC_REVISION_ID = p_x_ahl_fileupload_rec.p_revision_id;
398: EXCEPTION
399: WHEN no_data_found THEN
400: IF G_DEBUG='Y' THEN
401: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_DOC_REV_ID_INVALID');
402:
403:
404: END IF;
405: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');

Line 414: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_DOC_REV_ID is null');

410: RAISE;
411: END;
412: ELSE
413: IF G_DEBUG='Y' THEN
414: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_DOC_REV_ID is null');
415:
416:
417: END IF;
418: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_REV_ID_INVALID');

Line 435: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_ATTACH_FILE_NOT_EXISTS');

431: WHERE FILE_ID = p_x_ahl_fileupload_rec.p_file_id;
432: EXCEPTION
433: WHEN no_data_found THEN
434: IF G_DEBUG='Y' THEN
435: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_ATTACH_FILE_NOT_EXISTS');
436:
437:
438: END IF;
439: x_return_status := FND_API.G_RET_STS_ERROR;

Line 446: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_ATTACH_FILE IS Null');

442: RAISE;
443: END;
444: ELSE
445: IF G_DEBUG='Y' THEN
446: AHL_DEBUG_PUB.debug( 'ERROR: AHL_DI_ATTACH_FILE IS Null');
447:
448:
449: END IF;
450: x_return_status := FND_API.G_RET_STS_ERROR;

Line 459: AHL_DEBUG_PUB.debug( 'checking for already existing file ');

455:
456: l_assoc_id := 0;
457:
458: IF G_DEBUG='Y' THEN
459: AHL_DEBUG_PUB.debug( 'checking for already existing file ');
460: END IF;
461:
462: open c_get_association_id (p_x_ahl_fileupload_rec.p_revision_id);
463:

Line 467: AHL_DEBUG_PUB.debug( 'l_assoc_id value to be deleted'|| l_assoc_id);

463:
464: LOOP
465: fetch c_get_association_id into l_assoc_id;
466: exit when c_get_association_id %NOTFOUND;
467: AHL_DEBUG_PUB.debug( 'l_assoc_id value to be deleted'|| l_assoc_id);
468: END LOOP;
469: close c_get_association_id;
470:
471: -- if association id not found then raise error.

Line 479: AHL_DEBUG_PUB.debug( 'ERROR: the file association to be deleted is not found ');

475: FND_MSG_PUB.ADD;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477:
478: IF G_DEBUG='Y' THEN
479: AHL_DEBUG_PUB.debug( 'ERROR: the file association to be deleted is not found ');
480: END IF;
481:
482: END IF;
483:

Line 508: AHL_DEBUG_PUB.debug( 'exit private AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');

504: END IF;
505:
506: -- Debug info.
507: IF G_DEBUG='Y' THEN
508: AHL_DEBUG_PUB.debug( 'exit private AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');
509: END IF;
510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 519: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

515: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
516: p_count => x_msg_count,
517: p_data => x_msg_data);
518: IF G_DEBUG='Y' THEN
519: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
520: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEMS');
521:
522:
523: -- Check if API is called in debug mode. If yes, disable debug.

Line 520: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEMS');

516: p_count => x_msg_count,
517: p_data => x_msg_data);
518: IF G_DEBUG='Y' THEN
519: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
520: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEMS');
521:
522:
523: -- Check if API is called in debug mode. If yes, disable debug.
524: AHL_DEBUG_PUB.disable_debug;

Line 524: AHL_DEBUG_PUB.disable_debug;

520: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEMS');
521:
522:
523: -- Check if API is called in debug mode. If yes, disable debug.
524: AHL_DEBUG_PUB.disable_debug;
525:
526: END IF;
527:
528: WHEN FND_API.G_EXC_ERROR THEN

Line 536: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

532: p_count => x_msg_count,
533: p_data => X_msg_data);
534: -- Debug info.
535: IF G_DEBUG='Y' THEN
536: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
537: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEMS:');
538:
539:
540: -- Check if API is called in debug mode. If yes, disable debug.

Line 537: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEMS:');

533: p_data => X_msg_data);
534: -- Debug info.
535: IF G_DEBUG='Y' THEN
536: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
537: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEMS:');
538:
539:
540: -- Check if API is called in debug mode. If yes, disable debug.
541: AHL_DEBUG_PUB.disable_debug;

Line 541: AHL_DEBUG_PUB.disable_debug;

537: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEMS:');
538:
539:
540: -- Check if API is called in debug mode. If yes, disable debug.
541: AHL_DEBUG_PUB.disable_debug;
542:
543: END IF;
544:
545: WHEN OTHERS THEN

Line 559: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

555: p_data => x_msg_data);
556:
557: -- Debug info.
558: IF G_DEBUG='Y' THEN
559: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
560: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');
561:
562:
563: -- Check if API is called in debug mode. If yes, disable debug.

Line 560: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');

556:
557: -- Debug info.
558: IF G_DEBUG='Y' THEN
559: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
560: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');
561:
562:
563: -- Check if API is called in debug mode. If yes, disable debug.
564: AHL_DEBUG_PUB.disable_debug;

Line 564: AHL_DEBUG_PUB.disable_debug;

560: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');
561:
562:
563: -- Check if API is called in debug mode. If yes, disable debug.
564: AHL_DEBUG_PUB.disable_debug;
565:
566: END IF;
567:
568:

Line 595: AHL_DEBUG_PUB.enable_debug;

591: BEGIN
592: -- Standard Start of API savepoint
593: SAVEPOINT process_item;
594: IF G_DEBUG='Y' THEN
595: AHL_DEBUG_PUB.enable_debug;
596:
597: END IF;
598: -- Debug info.
599: IF G_DEBUG='Y' THEN

Line 600: AHL_DEBUG_PUB.debug( 'enter private AHL_DI_FILEUPLOAD_PVT.PROCESS_ITEM');

596:
597: END IF;
598: -- Debug info.
599: IF G_DEBUG='Y' THEN
600: AHL_DEBUG_PUB.debug( 'enter private AHL_DI_FILEUPLOAD_PVT.PROCESS_ITEM');
601:
602:
603: END IF;
604:

Line 656: AHL_DEBUG_PUB.debug( 'exit private AHL_DI_FILEUPLOAD_PVT.PROCESS_ITEM');

652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:
655: IF G_DEBUG='Y' THEN
656: AHL_DEBUG_PUB.debug( 'exit private AHL_DI_FILEUPLOAD_PVT.PROCESS_ITEM');
657: END IF;
658: EXCEPTION
659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: ROLLBACK TO process_item;

Line 666: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

662: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data);
665: IF G_DEBUG='Y' THEN
666: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
667: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.PROCESS_ITEM');
668:
669:
670: -- Check if API is called in debug mode. If yes, disable debug.

Line 667: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.PROCESS_ITEM');

663: p_count => x_msg_count,
664: p_data => x_msg_data);
665: IF G_DEBUG='Y' THEN
666: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
667: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.PROCESS_ITEM');
668:
669:
670: -- Check if API is called in debug mode. If yes, disable debug.
671: AHL_DEBUG_PUB.disable_debug;

Line 671: AHL_DEBUG_PUB.disable_debug;

667: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.PROCESS_ITEM');
668:
669:
670: -- Check if API is called in debug mode. If yes, disable debug.
671: AHL_DEBUG_PUB.disable_debug;
672:
673: END IF;
674:
675: WHEN FND_API.G_EXC_ERROR THEN

Line 683: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

679: p_count => x_msg_count,
680: p_data => X_msg_data);
681: -- Debug info.
682: IF G_DEBUG='Y' THEN
683: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
684: AHL_DEBUG_PUB.debug( 'AHL_DI_CONTENT_MGMT_PVT.PROCESS_ITEM');
685:
686:
687: -- Check if API is called in debug mode. If yes, disable debug.

Line 684: AHL_DEBUG_PUB.debug( 'AHL_DI_CONTENT_MGMT_PVT.PROCESS_ITEM');

680: p_data => X_msg_data);
681: -- Debug info.
682: IF G_DEBUG='Y' THEN
683: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
684: AHL_DEBUG_PUB.debug( 'AHL_DI_CONTENT_MGMT_PVT.PROCESS_ITEM');
685:
686:
687: -- Check if API is called in debug mode. If yes, disable debug.
688: AHL_DEBUG_PUB.disable_debug;

Line 688: AHL_DEBUG_PUB.disable_debug;

684: AHL_DEBUG_PUB.debug( 'AHL_DI_CONTENT_MGMT_PVT.PROCESS_ITEM');
685:
686:
687: -- Check if API is called in debug mode. If yes, disable debug.
688: AHL_DEBUG_PUB.disable_debug;
689:
690: END IF;
691:
692: WHEN OTHERS THEN

Line 706: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

702: p_data => x_msg_data);
703:
704: -- Debug info.
705: IF G_DEBUG='Y' THEN
706: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
707: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.PROCESS_ITEM');
708:
709:
710: -- Check if API is called in debug mode. If yes, disable debug.

Line 707: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.PROCESS_ITEM');

703:
704: -- Debug info.
705: IF G_DEBUG='Y' THEN
706: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
707: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.PROCESS_ITEM');
708:
709:
710: -- Check if API is called in debug mode. If yes, disable debug.
711: AHL_DEBUG_PUB.disable_debug;

Line 711: AHL_DEBUG_PUB.disable_debug;

707: AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.PROCESS_ITEM');
708:
709:
710: -- Check if API is called in debug mode. If yes, disable debug.
711: AHL_DEBUG_PUB.disable_debug;
712:
713: END IF;
714:
715: END PROCESS_ITEM;