DBA Data[Home] [Help]

APPS.GHR_PROCESS_SF52 dependencies on GHR_PROCESS_LOG

Line 22: p_program_name in ghr_process_log.program_name%type,

18: Procedure Dual_Action_SF52(p_sf52_data in out nocopy ghr_pa_requests%rowtype,
19: p_process_type in varchar2 default 'CURRENT');
20:
21: procedure create_ghr_errorlog(
22: p_program_name in ghr_process_log.program_name%type,
23: p_log_text in ghr_process_log.log_text%type,
24: p_message_name in ghr_process_log.message_name%type,
25: p_log_date in ghr_process_log.log_date%type
26: );

Line 23: p_log_text in ghr_process_log.log_text%type,

19: p_process_type in varchar2 default 'CURRENT');
20:
21: procedure create_ghr_errorlog(
22: p_program_name in ghr_process_log.program_name%type,
23: p_log_text in ghr_process_log.log_text%type,
24: p_message_name in ghr_process_log.message_name%type,
25: p_log_date in ghr_process_log.log_date%type
26: );
27:

Line 24: p_message_name in ghr_process_log.message_name%type,

20:
21: procedure create_ghr_errorlog(
22: p_program_name in ghr_process_log.program_name%type,
23: p_log_text in ghr_process_log.log_text%type,
24: p_message_name in ghr_process_log.message_name%type,
25: p_log_date in ghr_process_log.log_date%type
26: );
27:
28: Procedure Update_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype,

Line 25: p_log_date in ghr_process_log.log_date%type

21: procedure create_ghr_errorlog(
22: p_program_name in ghr_process_log.program_name%type,
23: p_log_text in ghr_process_log.log_text%type,
24: p_message_name in ghr_process_log.message_name%type,
25: p_log_date in ghr_process_log.log_date%type
26: );
27:
28: Procedure Update_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype,
29: p_result out nocopy Boolean);

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

3031: END IF;
3032: if l_retcode = 2 then
3033: retcode := 2;
3034: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
3035: errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
3036: -- Bug 2639698 Sundar
3037: elsif l_retcode = 5 then
3038: retcode := 2;
3039: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);

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

3036: -- Bug 2639698 Sundar
3037: elsif l_retcode = 5 then
3038: retcode := 2;
3039: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
3040: errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
3041: -- End Bug 2639698 Sundar
3042: elsif l_retcode is not NULL then
3043: -- Warning
3044: retcode := 1;

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

3041: -- End Bug 2639698 Sundar
3042: elsif l_retcode is not NULL then
3043: -- Warning
3044: retcode := 1;
3045: errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;
3046: elsif l_retcode is null then
3047: retcode := 0;
3048: end if;
3049: hr_utility.set_location( 'Leaving : ' || l_proc, 20);

Line 3452: p_program_name in ghr_process_log.program_name%type,

3448:
3449:
3450:
3451: procedure create_ghr_errorlog(
3452: p_program_name in ghr_process_log.program_name%type,
3453: p_log_text in ghr_process_log.log_text%type,
3454: p_message_name in ghr_process_log.message_name%type,
3455: p_log_date in ghr_process_log.log_date%type
3456: ) is

Line 3453: p_log_text in ghr_process_log.log_text%type,

3449:
3450:
3451: procedure create_ghr_errorlog(
3452: p_program_name in ghr_process_log.program_name%type,
3453: p_log_text in ghr_process_log.log_text%type,
3454: p_message_name in ghr_process_log.message_name%type,
3455: p_log_date in ghr_process_log.log_date%type
3456: ) is
3457:

Line 3454: p_message_name in ghr_process_log.message_name%type,

3450:
3451: procedure create_ghr_errorlog(
3452: p_program_name in ghr_process_log.program_name%type,
3453: p_log_text in ghr_process_log.log_text%type,
3454: p_message_name in ghr_process_log.message_name%type,
3455: p_log_date in ghr_process_log.log_date%type
3456: ) is
3457:
3458: l_proc varchar2(30):='create_ghr_errorlog';

Line 3455: p_log_date in ghr_process_log.log_date%type

3451: procedure create_ghr_errorlog(
3452: p_program_name in ghr_process_log.program_name%type,
3453: p_log_text in ghr_process_log.log_text%type,
3454: p_message_name in ghr_process_log.message_name%type,
3455: p_log_date in ghr_process_log.log_date%type
3456: ) is
3457:
3458: l_proc varchar2(30):='create_ghr_errorlog';
3459: Begin

Line 3461: insert into ghr_process_log

3457:
3458: l_proc varchar2(30):='create_ghr_errorlog';
3459: Begin
3460: hr_utility.set_location( 'Entering : ' || l_proc, 10);
3461: insert into ghr_process_log
3462: (process_log_id
3463: ,program_name
3464: ,log_text
3465: ,message_name

Line 3469: (ghr_process_log_s.nextval

3465: ,message_name
3466: ,log_date
3467: )
3468: values
3469: (ghr_process_log_s.nextval
3470: ,p_program_name
3471: ,p_log_text
3472: ,p_message_name
3473: ,p_log_date