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_KW_CHEQUE_REPORT dependencies on HR_UTILITY

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

362: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pd_l),l_str_pd_l);
363:
364:
365:
366: hr_utility.set_location('Entering CHQR ',10);
367:
368: i := 0;
369:
370: If p_sort = 'ORG' then

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

491: End If;
492:
493: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
494:
495: hr_utility.set_location('Finished creating xml data for Procedure CHQR ',20);
496:
497: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
498: clob_to_blob(l_xfdf_string,l_xfdf_blob);
499:

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

499:
500:
501: /*EXCEPTION
502: WHEN utl_file.invalid_path then
503: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
504: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
505: hr_utility.raise_error;
506: --
507: WHEN utl_file.invalid_mode then

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

500:
501: /*EXCEPTION
502: WHEN utl_file.invalid_path then
503: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
504: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
505: hr_utility.raise_error;
506: --
507: WHEN utl_file.invalid_mode then
508: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 505: hr_utility.raise_error;

501: /*EXCEPTION
502: WHEN utl_file.invalid_path then
503: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
504: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
505: hr_utility.raise_error;
506: --
507: WHEN utl_file.invalid_mode then
508: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
509: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

504: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
505: hr_utility.raise_error;
506: --
507: WHEN utl_file.invalid_mode then
508: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
509: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
510: hr_utility.raise_error;
511: --
512: WHEN utl_file.invalid_filehandle then

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

505: hr_utility.raise_error;
506: --
507: WHEN utl_file.invalid_mode then
508: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
509: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
510: hr_utility.raise_error;
511: --
512: WHEN utl_file.invalid_filehandle then
513: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 510: hr_utility.raise_error;

506: --
507: WHEN utl_file.invalid_mode then
508: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
509: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
510: hr_utility.raise_error;
511: --
512: WHEN utl_file.invalid_filehandle then
513: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
514: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

509: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
510: hr_utility.raise_error;
511: --
512: WHEN utl_file.invalid_filehandle then
513: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
514: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
515: hr_utility.raise_error;
516: --
517: WHEN utl_file.invalid_operation then

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

510: hr_utility.raise_error;
511: --
512: WHEN utl_file.invalid_filehandle then
513: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
514: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
515: hr_utility.raise_error;
516: --
517: WHEN utl_file.invalid_operation then
518: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 515: hr_utility.raise_error;

511: --
512: WHEN utl_file.invalid_filehandle then
513: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
514: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
515: hr_utility.raise_error;
516: --
517: WHEN utl_file.invalid_operation then
518: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
519: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

514: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
515: hr_utility.raise_error;
516: --
517: WHEN utl_file.invalid_operation then
518: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
519: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
520: hr_utility.raise_error;
521: --
522: WHEN utl_file.read_error then

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

515: hr_utility.raise_error;
516: --
517: WHEN utl_file.invalid_operation then
518: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
519: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
520: hr_utility.raise_error;
521: --
522: WHEN utl_file.read_error then
523: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 520: hr_utility.raise_error;

516: --
517: WHEN utl_file.invalid_operation then
518: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
519: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
520: hr_utility.raise_error;
521: --
522: WHEN utl_file.read_error then
523: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

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

519: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
520: hr_utility.raise_error;
521: --
522: WHEN utl_file.read_error then
523: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
525: hr_utility.raise_error;
526: --
527: WHEN others THEN

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

520: hr_utility.raise_error;
521: --
522: WHEN utl_file.read_error then
523: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
525: hr_utility.raise_error;
526: --
527: WHEN others THEN
528: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 525: hr_utility.raise_error;

521: --
522: WHEN utl_file.read_error then
523: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
525: hr_utility.raise_error;
526: --
527: WHEN others THEN
528: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
529: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

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

524: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
525: hr_utility.raise_error;
526: --
527: WHEN others THEN
528: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
529: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
531: hr_utility.raise_error;*/
532: END CHEQUE_LISTING;

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

525: hr_utility.raise_error;
526: --
527: WHEN others THEN
528: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
529: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
531: hr_utility.raise_error;*/
532: END CHEQUE_LISTING;
533: -------------------------------------------------------------------------------------------

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

526: --
527: WHEN others THEN
528: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
529: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
531: hr_utility.raise_error;*/
532: END CHEQUE_LISTING;
533: -------------------------------------------------------------------------------------------
534:

Line 531: hr_utility.raise_error;*/

527: WHEN others THEN
528: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
529: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
531: hr_utility.raise_error;*/
532: END CHEQUE_LISTING;
533: -------------------------------------------------------------------------------------------
534:
535: PROCEDURE WritetoCLOB

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

545: l_str7 varchar2(1000);
546: l_str8 varchar2(240);
547: l_str9 varchar2(240);
548: BEGIN
549: hr_utility.set_location('Entered Procedure Write to clob ',100);
550: l_str1 := '
551:
552: ' ;
553: l_str2 := '