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.PAY_AE_CHEQUE_REPORT dependencies on HR_UTILITY

Line 335: hr_utility.set_location('Entering CHQR ',10);

331: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pd_l),l_str_pd_l);
332:
333:
334:
335: hr_utility.set_location('Entering CHQR ',10);
336:
337: i := 0;
338:
339: If p_sort = 'ORG' then

Line 464: hr_utility.set_location('Finished creating xml data for Procedure CHQR ',20);

460: End If;
461:
462: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
463:
464: hr_utility.set_location('Finished creating xml data for Procedure CHQR ',20);
465:
466: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
467: clob_to_blob(l_xfdf_string,l_xfdf_blob);
468:

Line 472: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

468:
469:
470: /*EXCEPTION
471: WHEN utl_file.invalid_path then
472: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
473: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
474: hr_utility.raise_error;
475: --
476: WHEN utl_file.invalid_mode then

Line 473: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

469:
470: /*EXCEPTION
471: WHEN utl_file.invalid_path then
472: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
473: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
474: hr_utility.raise_error;
475: --
476: WHEN utl_file.invalid_mode then
477: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 474: hr_utility.raise_error;

470: /*EXCEPTION
471: WHEN utl_file.invalid_path then
472: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
473: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
474: hr_utility.raise_error;
475: --
476: WHEN utl_file.invalid_mode then
477: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
478: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 477: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

473: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
474: hr_utility.raise_error;
475: --
476: WHEN utl_file.invalid_mode then
477: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
478: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
479: hr_utility.raise_error;
480: --
481: WHEN utl_file.invalid_filehandle then

Line 478: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

474: hr_utility.raise_error;
475: --
476: WHEN utl_file.invalid_mode then
477: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
478: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
479: hr_utility.raise_error;
480: --
481: WHEN utl_file.invalid_filehandle then
482: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 479: hr_utility.raise_error;

475: --
476: WHEN utl_file.invalid_mode then
477: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
478: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
479: hr_utility.raise_error;
480: --
481: WHEN utl_file.invalid_filehandle then
482: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
483: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 482: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

478: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
479: hr_utility.raise_error;
480: --
481: WHEN utl_file.invalid_filehandle then
482: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
483: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
484: hr_utility.raise_error;
485: --
486: WHEN utl_file.invalid_operation then

Line 483: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

479: hr_utility.raise_error;
480: --
481: WHEN utl_file.invalid_filehandle then
482: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
483: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
484: hr_utility.raise_error;
485: --
486: WHEN utl_file.invalid_operation then
487: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 484: hr_utility.raise_error;

480: --
481: WHEN utl_file.invalid_filehandle then
482: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
483: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
484: hr_utility.raise_error;
485: --
486: WHEN utl_file.invalid_operation then
487: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
488: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 487: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

483: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
484: hr_utility.raise_error;
485: --
486: WHEN utl_file.invalid_operation then
487: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
488: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
489: hr_utility.raise_error;
490: --
491: WHEN utl_file.read_error then

Line 488: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

484: hr_utility.raise_error;
485: --
486: WHEN utl_file.invalid_operation then
487: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
488: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
489: hr_utility.raise_error;
490: --
491: WHEN utl_file.read_error then
492: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 489: hr_utility.raise_error;

485: --
486: WHEN utl_file.invalid_operation then
487: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
488: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
489: hr_utility.raise_error;
490: --
491: WHEN utl_file.read_error then
492: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
493: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 492: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

488: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
489: hr_utility.raise_error;
490: --
491: WHEN utl_file.read_error then
492: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
493: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
494: hr_utility.raise_error;
495: --
496: WHEN others THEN

Line 493: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

489: hr_utility.raise_error;
490: --
491: WHEN utl_file.read_error then
492: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
493: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
494: hr_utility.raise_error;
495: --
496: WHEN others THEN
497: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 494: hr_utility.raise_error;

490: --
491: WHEN utl_file.read_error then
492: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
493: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
494: hr_utility.raise_error;
495: --
496: WHEN others THEN
497: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
498: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

Line 497: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

493: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
494: hr_utility.raise_error;
495: --
496: WHEN others THEN
497: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
498: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
499: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
500: hr_utility.raise_error;*/
501: END CHEQUE_LISTING;

Line 498: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

494: hr_utility.raise_error;
495: --
496: WHEN others THEN
497: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
498: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
499: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
500: hr_utility.raise_error;*/
501: END CHEQUE_LISTING;
502: -------------------------------------------------------------------------------------------

Line 499: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

495: --
496: WHEN others THEN
497: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
498: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
499: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
500: hr_utility.raise_error;*/
501: END CHEQUE_LISTING;
502: -------------------------------------------------------------------------------------------
503:

Line 500: hr_utility.raise_error;*/

496: WHEN others THEN
497: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
498: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
499: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
500: hr_utility.raise_error;*/
501: END CHEQUE_LISTING;
502: -------------------------------------------------------------------------------------------
503:
504: PROCEDURE WritetoCLOB

Line 518: hr_utility.set_location('Entered Procedure Write to clob ',100);

514: l_str7 varchar2(1000);
515: l_str8 varchar2(240);
516: l_str9 varchar2(240);
517: BEGIN
518: hr_utility.set_location('Entered Procedure Write to clob ',100);
519: l_str1 := '
520:
521: ' ;
522: l_str2 := '