DBA Data[Home] [Help]

APPS.AHL_DI_FILEUPLOAD_PVT dependencies on AHL_DI_FILEUPLOAD_PVT

Line 1: PACKAGE BODY AHL_DI_FILEUPLOAD_PVT AS

1: PACKAGE BODY AHL_DI_FILEUPLOAD_PVT AS
2: /* $Header: AHLVFUPB.pls 115.6 2004/01/21 09:07:58 adharia noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_FILEUPLOAD_PVT';
5:

Line 4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_FILEUPLOAD_PVT';

1: PACKAGE BODY AHL_DI_FILEUPLOAD_PVT AS
2: /* $Header: AHLVFUPB.pls 115.6 2004/01/21 09:07:58 adharia noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_FILEUPLOAD_PVT';
5:
6: /*-----------------------------------------------------------*/
7: /* procedure name: UPLOAD_ITEM */
8: /* description: Procedure to insert/update content item for */

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 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 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 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 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 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 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 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 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 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 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 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 720: END AHL_DI_FILEUPLOAD_PVT;

716:
717:
718:
719:
720: END AHL_DI_FILEUPLOAD_PVT;
721: