DBA Data[Home] [Help]

APPS.HZ_POPULATE_TIMEZONE_PKG dependencies on HZ_POPULATE_TIMEZONE_PKG

Line 1: PACKAGE BODY HZ_POPULATE_TIMEZONE_PKG AS

1: PACKAGE BODY HZ_POPULATE_TIMEZONE_PKG AS
2: /* $Header: ARHTZCPB.pls 115.4 2004/06/09 19:50:22 awu noship $ */
3:
4: PROCEDURE Debug_Message(
5: p_msg_level IN NUMBER,

Line 390: ERRBUF := ERRBUF||'Error in HZ_POPULATE_TIMEZONE_PKG.PHONE_TIMEZONE:'||to_char(sqlcode)||sqlerrm;

386: log('Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
387:
388: EXCEPTION
389: WHEN OTHERS THEN
390: ERRBUF := ERRBUF||'Error in HZ_POPULATE_TIMEZONE_PKG.PHONE_TIMEZONE:'||to_char(sqlcode)||sqlerrm;
391: RETCODE := '2';
392: log('Error in HZ_POPULATE_TIMEZONE_PKG.PHONE_TIMEZONE:'||sqlerrm);
393:
394: end PHONE_TIMEZONE;

Line 392: log('Error in HZ_POPULATE_TIMEZONE_PKG.PHONE_TIMEZONE:'||sqlerrm);

388: EXCEPTION
389: WHEN OTHERS THEN
390: ERRBUF := ERRBUF||'Error in HZ_POPULATE_TIMEZONE_PKG.PHONE_TIMEZONE:'||to_char(sqlcode)||sqlerrm;
391: RETCODE := '2';
392: log('Error in HZ_POPULATE_TIMEZONE_PKG.PHONE_TIMEZONE:'||sqlerrm);
393:
394: end PHONE_TIMEZONE;
395:
396: PROCEDURE LOCATION_TIMEZONE(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY

Line 544: ERRBUF := ERRBUF||'Error in HZ_POPULATE_TIMEZONE_PKG.PHONE_TIMEZONE:'||to_char(sqlcode)||sqlerrm;

540: Write_Log(G_DEBUG_CONCURRENT, 1, 'Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
541:
542: EXCEPTION
543: WHEN OTHERS THEN
544: ERRBUF := ERRBUF||'Error in HZ_POPULATE_TIMEZONE_PKG.PHONE_TIMEZONE:'||to_char(sqlcode)||sqlerrm;
545: RETCODE := '2';
546: Write_Log(G_DEBUG_CONCURRENT, 1,'Error in HZ_POPULATE_TIMEZONE_PKG.PHONE_TIMEZONE:');
547: Write_Log(G_DEBUG_CONCURRENT, 1,sqlerrm);
548: --l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

Line 546: Write_Log(G_DEBUG_CONCURRENT, 1,'Error in HZ_POPULATE_TIMEZONE_PKG.PHONE_TIMEZONE:');

542: EXCEPTION
543: WHEN OTHERS THEN
544: ERRBUF := ERRBUF||'Error in HZ_POPULATE_TIMEZONE_PKG.PHONE_TIMEZONE:'||to_char(sqlcode)||sqlerrm;
545: RETCODE := '2';
546: Write_Log(G_DEBUG_CONCURRENT, 1,'Error in HZ_POPULATE_TIMEZONE_PKG.PHONE_TIMEZONE:');
547: Write_Log(G_DEBUG_CONCURRENT, 1,sqlerrm);
548: --l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
549: --IF l_status = TRUE THEN
550: -- Write_Log(G_DEBUG_CONCURRENT, 1, 'Error, can not complete Concurrent Program') ;

Line 555: END HZ_POPULATE_TIMEZONE_PKG;

551: --END IF;
552:
553: end location_timezone;
554:
555: END HZ_POPULATE_TIMEZONE_PKG;