DBA Data[Home] [Help]

APPS.GHR_PROC_FUT_MT dependencies on GHR_PROCESS_LOG

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

465: --hr_utility.trace_off;
466: -- Assigning Return codes
467: IF l_completion_status = 2 THEN
468: p_retcode := 2;
469: p_errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
470: ELSIF l_completion_status = 1 THEN
471: p_retcode := 1;
472: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;
473: ELSE

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

468: p_retcode := 2;
469: p_errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
470: ELSIF l_completion_status = 1 THEN
471: p_retcode := 1;
472: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;
473: ELSE
474: p_retcode := 0;
475: END IF;
476:

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

841:
842: IF l_retcode = 2 THEN
843: p_retcode := 2;
844: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
845: p_errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
846: ELSIF l_retcode = 5 THEN
847: p_retcode := 2;
848: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
849: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';

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

845: p_errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
846: ELSIF l_retcode = 5 THEN
847: p_retcode := 2;
848: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
849: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
850: ELSIF l_retcode IS NOT NULL THEN
851: -- Warning
852: p_retcode := 1;
853: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;

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

849: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
850: ELSIF l_retcode IS NOT NULL THEN
851: -- Warning
852: p_retcode := 1;
853: p_errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;
854: ELSIF l_retcode IS NULL THEN
855: p_retcode := 0;
856: END IF;
857:

Line 879: p_program_name in ghr_process_log.program_name%type,

875: -- This procedure inserts the log text into Federal Process log
876: -- ============================================================================
877:
878: PROCEDURE create_ghr_errorlog(
879: p_program_name in ghr_process_log.program_name%type,
880: p_log_text in ghr_process_log.log_text%type,
881: p_message_name in ghr_process_log.message_name%type,
882: p_log_date in ghr_process_log.log_date%type
883: ) is

Line 880: p_log_text in ghr_process_log.log_text%type,

876: -- ============================================================================
877:
878: PROCEDURE create_ghr_errorlog(
879: p_program_name in ghr_process_log.program_name%type,
880: p_log_text in ghr_process_log.log_text%type,
881: p_message_name in ghr_process_log.message_name%type,
882: p_log_date in ghr_process_log.log_date%type
883: ) is
884:

Line 881: p_message_name in ghr_process_log.message_name%type,

877:
878: PROCEDURE create_ghr_errorlog(
879: p_program_name in ghr_process_log.program_name%type,
880: p_log_text in ghr_process_log.log_text%type,
881: p_message_name in ghr_process_log.message_name%type,
882: p_log_date in ghr_process_log.log_date%type
883: ) is
884:
885: l_proc varchar2(30);

Line 882: p_log_date in ghr_process_log.log_date%type

878: PROCEDURE create_ghr_errorlog(
879: p_program_name in ghr_process_log.program_name%type,
880: p_log_text in ghr_process_log.log_text%type,
881: p_message_name in ghr_process_log.message_name%type,
882: p_log_date in ghr_process_log.log_date%type
883: ) is
884:
885: l_proc varchar2(30);
886: Begin

Line 889: insert into ghr_process_log

885: l_proc varchar2(30);
886: Begin
887: l_proc := 'create_ghr_errorlog';
888: hr_utility.set_location( 'Entering : ' || l_proc, 10);
889: insert into ghr_process_log
890: (process_log_id
891: ,program_name
892: ,log_text
893: ,message_name

Line 897: (ghr_process_log_s.nextval

893: ,message_name
894: ,log_date
895: )
896: values
897: (ghr_process_log_s.nextval
898: ,p_program_name
899: ,p_log_text
900: ,p_message_name
901: ,p_log_date