DBA Data[Home] [Help]

APPS.GHR_PROC_FUT_MT dependencies on GHR_PROCESS_LOG

Line 455: p_errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';

451: --hr_utility.trace_off;
452: -- Assigning Return codes
453: IF l_completion_status = 2 THEN
454: p_retcode := 2;
455: p_errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
456: ELSIF l_completion_status = 1 THEN
457: p_retcode := 1;
458: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;
459: ELSE

Line 458: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;

454: p_retcode := 2;
455: p_errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
456: ELSIF l_completion_status = 1 THEN
457: p_retcode := 1;
458: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;
459: ELSE
460: p_retcode := 0;
461: END IF;
462:

Line 823: p_errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';

819:
820: IF l_retcode = 2 THEN
821: p_retcode := 2;
822: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
823: p_errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
824: ELSIF l_retcode = 5 THEN
825: p_retcode := 2;
826: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
827: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';

Line 827: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';

823: p_errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
824: ELSIF l_retcode = 5 THEN
825: p_retcode := 2;
826: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
827: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
828: ELSIF l_retcode IS NOT NULL THEN
829: -- Warning
830: p_retcode := 1;
831: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;

Line 831: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;

827: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
828: ELSIF l_retcode IS NOT NULL THEN
829: -- Warning
830: p_retcode := 1;
831: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;
832: ELSIF l_retcode IS NULL THEN
833: p_retcode := 0;
834: END IF;
835:

Line 857: p_program_name in ghr_process_log.program_name%type,

853: -- This procedure inserts the log text into Federal Process log
854: -- ============================================================================
855:
856: PROCEDURE create_ghr_errorlog(
857: p_program_name in ghr_process_log.program_name%type,
858: p_log_text in ghr_process_log.log_text%type,
859: p_message_name in ghr_process_log.message_name%type,
860: p_log_date in ghr_process_log.log_date%type
861: ) is

Line 858: p_log_text in ghr_process_log.log_text%type,

854: -- ============================================================================
855:
856: PROCEDURE create_ghr_errorlog(
857: p_program_name in ghr_process_log.program_name%type,
858: p_log_text in ghr_process_log.log_text%type,
859: p_message_name in ghr_process_log.message_name%type,
860: p_log_date in ghr_process_log.log_date%type
861: ) is
862:

Line 859: p_message_name in ghr_process_log.message_name%type,

855:
856: PROCEDURE create_ghr_errorlog(
857: p_program_name in ghr_process_log.program_name%type,
858: p_log_text in ghr_process_log.log_text%type,
859: p_message_name in ghr_process_log.message_name%type,
860: p_log_date in ghr_process_log.log_date%type
861: ) is
862:
863: l_proc varchar2(30);

Line 860: p_log_date in ghr_process_log.log_date%type

856: PROCEDURE create_ghr_errorlog(
857: p_program_name in ghr_process_log.program_name%type,
858: p_log_text in ghr_process_log.log_text%type,
859: p_message_name in ghr_process_log.message_name%type,
860: p_log_date in ghr_process_log.log_date%type
861: ) is
862:
863: l_proc varchar2(30);
864: Begin

Line 867: insert into ghr_process_log

863: l_proc varchar2(30);
864: Begin
865: l_proc := 'create_ghr_errorlog';
866: hr_utility.set_location( 'Entering : ' || l_proc, 10);
867: insert into ghr_process_log
868: (process_log_id
869: ,program_name
870: ,log_text
871: ,message_name

Line 875: (ghr_process_log_s.nextval

871: ,message_name
872: ,log_date
873: )
874: values
875: (ghr_process_log_s.nextval
876: ,p_program_name
877: ,p_log_text
878: ,p_message_name
879: ,p_log_date