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 2917: errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';

2913: END IF;
2914: if l_retcode = 2 then
2915: retcode := 2;
2916: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
2917: errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
2918: -- Bug 2639698 Sundar
2919: elsif l_retcode = 5 then
2920: retcode := 2;
2921: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);

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

2918: -- Bug 2639698 Sundar
2919: elsif l_retcode = 5 then
2920: retcode := 2;
2921: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
2922: errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
2923: -- End Bug 2639698 Sundar
2924: elsif l_retcode is not NULL then
2925: -- Warning
2926: retcode := 1;

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

2923: -- End Bug 2639698 Sundar
2924: elsif l_retcode is not NULL then
2925: -- Warning
2926: retcode := 1;
2927: errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;
2928: elsif l_retcode is null then
2929: retcode := 0;
2930: end if;
2931: hr_utility.set_location( 'Leaving : ' || l_proc, 20);

Line 3326: p_program_name in ghr_process_log.program_name%type,

3322:
3323:
3324:
3325: procedure create_ghr_errorlog(
3326: p_program_name in ghr_process_log.program_name%type,
3327: p_log_text in ghr_process_log.log_text%type,
3328: p_message_name in ghr_process_log.message_name%type,
3329: p_log_date in ghr_process_log.log_date%type
3330: ) is

Line 3327: p_log_text in ghr_process_log.log_text%type,

3323:
3324:
3325: procedure create_ghr_errorlog(
3326: p_program_name in ghr_process_log.program_name%type,
3327: p_log_text in ghr_process_log.log_text%type,
3328: p_message_name in ghr_process_log.message_name%type,
3329: p_log_date in ghr_process_log.log_date%type
3330: ) is
3331:

Line 3328: p_message_name in ghr_process_log.message_name%type,

3324:
3325: procedure create_ghr_errorlog(
3326: p_program_name in ghr_process_log.program_name%type,
3327: p_log_text in ghr_process_log.log_text%type,
3328: p_message_name in ghr_process_log.message_name%type,
3329: p_log_date in ghr_process_log.log_date%type
3330: ) is
3331:
3332: l_proc varchar2(30):='create_ghr_errorlog';

Line 3329: p_log_date in ghr_process_log.log_date%type

3325: procedure create_ghr_errorlog(
3326: p_program_name in ghr_process_log.program_name%type,
3327: p_log_text in ghr_process_log.log_text%type,
3328: p_message_name in ghr_process_log.message_name%type,
3329: p_log_date in ghr_process_log.log_date%type
3330: ) is
3331:
3332: l_proc varchar2(30):='create_ghr_errorlog';
3333: Begin

Line 3335: insert into ghr_process_log

3331:
3332: l_proc varchar2(30):='create_ghr_errorlog';
3333: Begin
3334: hr_utility.set_location( 'Entering : ' || l_proc, 10);
3335: insert into ghr_process_log
3336: (process_log_id
3337: ,program_name
3338: ,log_text
3339: ,message_name

Line 3343: (ghr_process_log_s.nextval

3339: ,message_name
3340: ,log_date
3341: )
3342: values
3343: (ghr_process_log_s.nextval
3344: ,p_program_name
3345: ,p_log_text
3346: ,p_message_name
3347: ,p_log_date