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.GHR_HISTORY_API dependencies on HR_UTILITY

Line 59: hr_utility.set_location('Entering:'|| l_proc, 5);

55: p_date_effective in date default null)
56: is
57: l_proc varchar2(30):='set_g_session_var';
58: begin
59: hr_utility.set_location('Entering:'|| l_proc, 5);
60: g_session_var.pa_request_id := nvl(p_pa_request_id, g_session_var.pa_request_id);
61: g_session_var.noa_id := nvl(p_noa_id,g_session_var.noa_id);
62: g_session_var.altered_pa_request_id := nvl(p_altered_pa_request_id, g_session_var.altered_pa_request_id);
63: g_session_var.noa_id_correct := nvl(p_noa_id_correct, g_session_var.noa_id_correct);

Line 67: hr_utility.set_location(' Leaving:'||l_proc, 10);

63: g_session_var.noa_id_correct := nvl(p_noa_id_correct, g_session_var.noa_id_correct);
64: g_session_var.person_id := nvl(p_person_id, g_session_var.person_id);
65: g_session_var.assignment_id := nvl(p_assignment_id, g_session_var.assignment_id);
66: g_session_var.date_effective := nvl(p_date_effective, g_session_var.date_effective);
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: end set_g_session_var;
69:
70: -- ---------------------------------------------------------------------------
71: -- |--------------------------< get_g_session_var >---------------------------|

Line 111: hr_utility.set_location('Entering:'|| l_proc, 5);

107: p_date_effective out nocopy date) is
108:
109: l_proc varchar2(30):='get_g_session_var';
110: begin
111: hr_utility.set_location('Entering:'|| l_proc, 5);
112: p_pa_request_id := g_session_var.pa_request_id;
113: p_noa_id := g_session_var.noa_id;
114: p_altered_pa_request_id := g_session_var.altered_pa_request_id;
115: p_noa_id_correct := g_session_var.noa_id_correct;

Line 119: hr_utility.set_location(' Leaving:'||l_proc, 10);

115: p_noa_id_correct := g_session_var.noa_id_correct;
116: p_person_id := g_session_var.person_id;
117: p_assignment_id := g_session_var.assignment_id;
118: p_date_effective := g_session_var.date_effective;
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120: exception when others then
121: --
122: -- Reset IN OUT parameters and set OUT parameters
123: --

Line 168: hr_utility.set_location('Entering:'|| l_proc, 5);

164:
165: Procedure set_g_session_var( p_session_var in g_session_var_type) is
166: l_proc varchar2(30):='set_g_session_var 2';
167: begin
168: hr_utility.set_location('Entering:'|| l_proc, 5);
169: g_session_var.pa_request_id := nvl( p_session_var.pa_request_id, g_session_var.pa_request_id);
170: g_session_var.noa_id := nvl(p_session_var.noa_id, g_session_var.noa_id);
171: g_session_var.altered_pa_request_id := nvl(p_session_var.altered_pa_request_id, g_session_var.altered_pa_request_id);
172: g_session_var.noa_id_correct := nvl(p_session_var.noa_id_correct, g_session_var.noa_id_correct);

Line 179: hr_utility.set_location(' Leaving:'||l_proc, 10);

175: g_session_var.program_name := p_session_var.program_name;
176: g_session_var.fire_trigger := p_session_var.fire_trigger;
177: g_session_var.date_effective := nvl(p_session_var.date_effective, g_session_var.date_effective);
178: g_session_var.pa_history_id := p_session_var.pa_history_id;
179: hr_utility.set_location(' Leaving:'||l_proc, 10);
180: end set_g_session_var;
181:
182: -- ---------------------------------------------------------------------------
183: -- |--------------------------< get_g_session_var >---------------------------|

Line 216: hr_utility.set_location('Entering:'|| l_proc, 5);

212:
213: Procedure get_g_session_var( p_session_var out nocopy g_session_var_type) is
214: l_proc varchar2(30):='get_g_session_var 2';
215: begin
216: hr_utility.set_location('Entering:'|| l_proc, 5);
217: p_session_var.pa_request_id := g_session_var.pa_request_id;
218: p_session_var.noa_id := g_session_var.noa_id;
219: p_session_var.altered_pa_request_id := g_session_var.altered_pa_request_id;
220: p_session_var.noa_id_correct := g_session_var.noa_id_correct;

Line 227: hr_utility.set_location(' Leaving:'||l_proc, 10);

223: p_session_var.program_name := g_session_var.program_name;
224: p_session_var.fire_trigger := g_session_var.fire_trigger;
225: p_session_var.date_effective := g_session_var.date_effective;
226: p_session_var.pa_history_id := g_session_var.pa_history_id;
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: exception when others then
229: --
230: -- Reset IN OUT parameters and set OUT parameters
231: --

Line 296: hr_utility.set_location('Entering:'|| l_proc, 5);

292: indx binary_integer;
293: l_row_touched boolean;
294: Begin
295:
296: hr_utility.set_location('Entering:'|| l_proc, 5);
297: hr_utility.set_location(l_proc || '. program_name :' || p_program_name, 6);
298: hr_utility.set_location(l_proc || '. operation :' || p_operation, 7);
299: if lower(p_program_name) = 'core' or
300: lower(p_program_name) = 'sf50' then

Line 297: hr_utility.set_location(l_proc || '. program_name :' || p_program_name, 6);

293: l_row_touched boolean;
294: Begin
295:
296: hr_utility.set_location('Entering:'|| l_proc, 5);
297: hr_utility.set_location(l_proc || '. program_name :' || p_program_name, 6);
298: hr_utility.set_location(l_proc || '. operation :' || p_operation, 7);
299: if lower(p_program_name) = 'core' or
300: lower(p_program_name) = 'sf50' then
301: if lower(p_operation) = 'insert' then

Line 298: hr_utility.set_location(l_proc || '. operation :' || p_operation, 7);

294: Begin
295:
296: hr_utility.set_location('Entering:'|| l_proc, 5);
297: hr_utility.set_location(l_proc || '. program_name :' || p_program_name, 6);
298: hr_utility.set_location(l_proc || '. operation :' || p_operation, 7);
299: if lower(p_program_name) = 'core' or
300: lower(p_program_name) = 'sf50' then
301: if lower(p_operation) = 'insert' then
302: -- Check if this record was previously updated/created within this session

Line 306: hr_utility.set_location(l_proc, 15);

302: -- Check if this record was previously updated/created within this session
303: -- so it should already be in the rg. then don't add row since it is already in rg.
304: l_row_touched := row_already_touched(p_row_id);
305: if l_row_touched then
306: hr_utility.set_location(l_proc, 15);
307: null;
308: else
309: hr_utility.set_location(l_proc, 20);
310: -- track the fact that this row was touched in this session.

Line 309: hr_utility.set_location(l_proc, 20);

305: if l_row_touched then
306: hr_utility.set_location(l_proc, 15);
307: null;
308: else
309: hr_utility.set_location(l_proc, 20);
310: -- track the fact that this row was touched in this session.
311: indx := add_row_operation_info_rg(
312: p_table_name => upper(p_table_name),
313: p_table_pk_id => p_table_pk_id,

Line 322: hr_utility.set_location(l_proc || 'row touched', 25);

318: -- Check if this record was previously updated/created within this session
319: -- so it should be in the rg. then don't update pre. and pre-update.
320: l_row_touched := row_already_touched(p_row_id);
321: if l_row_touched then
322: hr_utility.set_location(l_proc || 'row touched', 25);
323: null;
324: else
325: hr_utility.set_location(l_proc || 'row not touched', 30);
326: -- track the fact that this row was touched in this session.

Line 325: hr_utility.set_location(l_proc || 'row not touched', 30);

321: if l_row_touched then
322: hr_utility.set_location(l_proc || 'row touched', 25);
323: null;
324: else
325: hr_utility.set_location(l_proc || 'row not touched', 30);
326: -- track the fact that this row was touched in this session.
327: indx := add_row_operation_info_rg(
328: p_table_name => p_table_name,
329: p_table_pk_id => p_table_pk_id,

Line 336: hr_utility.set_location(l_proc, 35);

332: -- since this is an update, save the pre values for this row
333: add_row_pre_update_record_rg(p_old_record_data, indx);
334: end if;
335: else /* delete */
336: hr_utility.set_location(l_proc, 35);
337: null;
338: end if;
339: else /* If called from any other process */
340: -- To be worked out.

Line 343: hr_utility.set_location('ERROR: Program is unsupported. Program name : ' || p_program_name || l_proc, 40);

339: else /* If called from any other process */
340: -- To be worked out.
341: -- It may need to be handled the way we'll handle core
342: -- Until then, throw an error since this program name is not yet supported.
343: hr_utility.set_location('ERROR: Program is unsupported. Program name : ' || p_program_name || l_proc, 40);
344: hr_utility.set_message(8301,'GHR_38494_UNKNOWN_PROGRAM_NAME');
345: hr_utility.set_message_token('PROGRAM_NAME',p_program_name);
346: hr_utility.raise_error;
347: end if;

Line 344: hr_utility.set_message(8301,'GHR_38494_UNKNOWN_PROGRAM_NAME');

340: -- To be worked out.
341: -- It may need to be handled the way we'll handle core
342: -- Until then, throw an error since this program name is not yet supported.
343: hr_utility.set_location('ERROR: Program is unsupported. Program name : ' || p_program_name || l_proc, 40);
344: hr_utility.set_message(8301,'GHR_38494_UNKNOWN_PROGRAM_NAME');
345: hr_utility.set_message_token('PROGRAM_NAME',p_program_name);
346: hr_utility.raise_error;
347: end if;
348: hr_utility.set_location('Leaving:'|| l_proc, 45);

Line 345: hr_utility.set_message_token('PROGRAM_NAME',p_program_name);

341: -- It may need to be handled the way we'll handle core
342: -- Until then, throw an error since this program name is not yet supported.
343: hr_utility.set_location('ERROR: Program is unsupported. Program name : ' || p_program_name || l_proc, 40);
344: hr_utility.set_message(8301,'GHR_38494_UNKNOWN_PROGRAM_NAME');
345: hr_utility.set_message_token('PROGRAM_NAME',p_program_name);
346: hr_utility.raise_error;
347: end if;
348: hr_utility.set_location('Leaving:'|| l_proc, 45);
349: End set_operation_info;

Line 346: hr_utility.raise_error;

342: -- Until then, throw an error since this program name is not yet supported.
343: hr_utility.set_location('ERROR: Program is unsupported. Program name : ' || p_program_name || l_proc, 40);
344: hr_utility.set_message(8301,'GHR_38494_UNKNOWN_PROGRAM_NAME');
345: hr_utility.set_message_token('PROGRAM_NAME',p_program_name);
346: hr_utility.raise_error;
347: end if;
348: hr_utility.set_location('Leaving:'|| l_proc, 45);
349: End set_operation_info;
350:

Line 348: hr_utility.set_location('Leaving:'|| l_proc, 45);

344: hr_utility.set_message(8301,'GHR_38494_UNKNOWN_PROGRAM_NAME');
345: hr_utility.set_message_token('PROGRAM_NAME',p_program_name);
346: hr_utility.raise_error;
347: end if;
348: hr_utility.set_location('Leaving:'|| l_proc, 45);
349: End set_operation_info;
350:
351: -- ---------------------------------------------------------------------------
352: -- |--------------------------< add_row_operation_info_rg >-------------------|

Line 391: hr_utility.set_location('Entering:'|| l_proc, 5);

387:
388: indx binary_integer;
389: l_proc varchar2(30):='add_row_operation_info_rg';
390: BEGIN
391: hr_utility.set_location('Entering:'|| l_proc, 5);
392: indx := g_operation_info.COUNT+1;
393: g_operation_info(indx).table_name := p_table_name;
394: g_operation_info(indx).table_pk_id := p_table_pk_id;
395: g_operation_info(indx).operation := p_operation;

Line 397: hr_utility.set_location('Leaving:'|| l_proc, 10);

393: g_operation_info(indx).table_name := p_table_name;
394: g_operation_info(indx).table_pk_id := p_table_pk_id;
395: g_operation_info(indx).operation := p_operation;
396: g_operation_info(indx).row_id := p_row_id;
397: hr_utility.set_location('Leaving:'|| l_proc, 10);
398: return indx;
399: END;
400:
401: -- ---------------------------------------------------------------------------

Line 437: hr_utility.set_location('Entering:'|| l_proc, 5);

433: p_ind in binary_integer) is
434: l_proc varchar2(30) := 'add_row_pre_update_record_rg';
435: l_hist_data ghr_pa_history%rowtype;
436: begin
437: hr_utility.set_location('Entering:'|| l_proc, 5);
438: -- local variable is used to temporarily hold the data because the
439: -- assignment did not work for some unknown reason (a bug in PL/SQL??)
440: -- when doing the assignment with p_pre_update directly.
441: l_hist_data := p_pre_update_rg;

Line 443: hr_utility.set_location('Leaving:'|| l_proc, 10);

439: -- assignment did not work for some unknown reason (a bug in PL/SQL??)
440: -- when doing the assignment with p_pre_update directly.
441: l_hist_data := p_pre_update_rg;
442: g_pre_update(p_ind) := l_hist_data;
443: hr_utility.set_location('Leaving:'|| l_proc, 10);
444: End add_row_pre_update_record_rg ;
445:
446:
447: -- ---------------------------------------------------------------------------

Line 453: -- Displays the g_session_var information using hr_utility.set_location calls.

449: -- ---------------------------------------------------------------------------
450: -- {Start Of Comments}
451: --
452: -- Description:
453: -- Displays the g_session_var information using hr_utility.set_location calls.
454: -- (trace must be on to see this information). This procedure is meant to be
455: -- used for debugging only.
456: --
457: -- Pre-Requisities:

Line 481: hr_utility.set_location('Entering:' || l_proc, 5);

477: Procedure display_g_session_var is
478: l_ind binary_integer;
479: l_proc varchar2(30):='display_g_session_var';
480: begin
481: hr_utility.set_location('Entering:' || l_proc, 5);
482: hr_utility.set_location('pa_request_id=' ||g_session_var.pa_request_id, 6);
483: hr_utility.set_location('NOA_ID='||g_session_var.noa_id, 7);
484: hr_utility.set_location('altered_pa_request_id=' || g_session_var.altered_pa_request_id, 8);
485: hr_utility.set_location('NOA_ID_CORRECT=' || g_session_var.noa_id_correct, 9);

Line 482: hr_utility.set_location('pa_request_id=' ||g_session_var.pa_request_id, 6);

478: l_ind binary_integer;
479: l_proc varchar2(30):='display_g_session_var';
480: begin
481: hr_utility.set_location('Entering:' || l_proc, 5);
482: hr_utility.set_location('pa_request_id=' ||g_session_var.pa_request_id, 6);
483: hr_utility.set_location('NOA_ID='||g_session_var.noa_id, 7);
484: hr_utility.set_location('altered_pa_request_id=' || g_session_var.altered_pa_request_id, 8);
485: hr_utility.set_location('NOA_ID_CORRECT=' || g_session_var.noa_id_correct, 9);
486: hr_utility.set_location('PERSON_ID=' || g_session_var.person_id, 10 );

Line 483: hr_utility.set_location('NOA_ID='||g_session_var.noa_id, 7);

479: l_proc varchar2(30):='display_g_session_var';
480: begin
481: hr_utility.set_location('Entering:' || l_proc, 5);
482: hr_utility.set_location('pa_request_id=' ||g_session_var.pa_request_id, 6);
483: hr_utility.set_location('NOA_ID='||g_session_var.noa_id, 7);
484: hr_utility.set_location('altered_pa_request_id=' || g_session_var.altered_pa_request_id, 8);
485: hr_utility.set_location('NOA_ID_CORRECT=' || g_session_var.noa_id_correct, 9);
486: hr_utility.set_location('PERSON_ID=' || g_session_var.person_id, 10 );
487: hr_utility.set_location('ASSIGNMENT_ID=' || g_session_var.assignment_id, 11);

Line 484: hr_utility.set_location('altered_pa_request_id=' || g_session_var.altered_pa_request_id, 8);

480: begin
481: hr_utility.set_location('Entering:' || l_proc, 5);
482: hr_utility.set_location('pa_request_id=' ||g_session_var.pa_request_id, 6);
483: hr_utility.set_location('NOA_ID='||g_session_var.noa_id, 7);
484: hr_utility.set_location('altered_pa_request_id=' || g_session_var.altered_pa_request_id, 8);
485: hr_utility.set_location('NOA_ID_CORRECT=' || g_session_var.noa_id_correct, 9);
486: hr_utility.set_location('PERSON_ID=' || g_session_var.person_id, 10 );
487: hr_utility.set_location('ASSIGNMENT_ID=' || g_session_var.assignment_id, 11);
488:

Line 485: hr_utility.set_location('NOA_ID_CORRECT=' || g_session_var.noa_id_correct, 9);

481: hr_utility.set_location('Entering:' || l_proc, 5);
482: hr_utility.set_location('pa_request_id=' ||g_session_var.pa_request_id, 6);
483: hr_utility.set_location('NOA_ID='||g_session_var.noa_id, 7);
484: hr_utility.set_location('altered_pa_request_id=' || g_session_var.altered_pa_request_id, 8);
485: hr_utility.set_location('NOA_ID_CORRECT=' || g_session_var.noa_id_correct, 9);
486: hr_utility.set_location('PERSON_ID=' || g_session_var.person_id, 10 );
487: hr_utility.set_location('ASSIGNMENT_ID=' || g_session_var.assignment_id, 11);
488:
489: for l_ind in 1 .. g_pre_update.count LOOP

Line 486: hr_utility.set_location('PERSON_ID=' || g_session_var.person_id, 10 );

482: hr_utility.set_location('pa_request_id=' ||g_session_var.pa_request_id, 6);
483: hr_utility.set_location('NOA_ID='||g_session_var.noa_id, 7);
484: hr_utility.set_location('altered_pa_request_id=' || g_session_var.altered_pa_request_id, 8);
485: hr_utility.set_location('NOA_ID_CORRECT=' || g_session_var.noa_id_correct, 9);
486: hr_utility.set_location('PERSON_ID=' || g_session_var.person_id, 10 );
487: hr_utility.set_location('ASSIGNMENT_ID=' || g_session_var.assignment_id, 11);
488:
489: for l_ind in 1 .. g_pre_update.count LOOP
490: null;

Line 487: hr_utility.set_location('ASSIGNMENT_ID=' || g_session_var.assignment_id, 11);

483: hr_utility.set_location('NOA_ID='||g_session_var.noa_id, 7);
484: hr_utility.set_location('altered_pa_request_id=' || g_session_var.altered_pa_request_id, 8);
485: hr_utility.set_location('NOA_ID_CORRECT=' || g_session_var.noa_id_correct, 9);
486: hr_utility.set_location('PERSON_ID=' || g_session_var.person_id, 10 );
487: hr_utility.set_location('ASSIGNMENT_ID=' || g_session_var.assignment_id, 11);
488:
489: for l_ind in 1 .. g_pre_update.count LOOP
490: null;
491: end loop;

Line 493: hr_utility.set_location('Leaving:' || l_proc, 10);

489: for l_ind in 1 .. g_pre_update.count LOOP
490: null;
491: end loop;
492:
493: hr_utility.set_location('Leaving:' || l_proc, 10);
494: exception
495: when others then
496: raise;
497: end display_g_session_var;

Line 534: hr_utility.set_location('Entering:'|| l_proc, 5);

530: Function row_already_touched(p_row_id in rowid) return boolean is
531: ind binary_integer;
532: l_proc varchar2(30) := 'row_already_touched' ;
533: Begin
534: hr_utility.set_location('Entering:'|| l_proc, 5);
535: if g_operation_info.COUNT > 0 then
536: ind := g_operation_info.FIRST;
537: hr_utility.set_location(l_proc, 10);
538: LOOP

Line 537: hr_utility.set_location(l_proc, 10);

533: Begin
534: hr_utility.set_location('Entering:'|| l_proc, 5);
535: if g_operation_info.COUNT > 0 then
536: ind := g_operation_info.FIRST;
537: hr_utility.set_location(l_proc, 10);
538: LOOP
539: if g_operation_info(ind).row_id = p_row_id then
540: return TRUE ;
541: END IF;

Line 545: hr_utility.set_location('Leaving:'|| l_proc, 15);

541: END IF;
542: Exit when ind = g_operation_info.LAST;
543: ind := g_operation_info.NEXT(ind);
544: END LOOP;
545: hr_utility.set_location('Leaving:'|| l_proc, 15);
546: return FALSE;
547: END IF;
548: return FALSE;
549: End;

Line 582: hr_utility.set_location('Entering:'|| l_proc, 5);

578: -- ---------------------------------------------------------------------------
579: Procedure reinit_g_session_var is
580: l_proc varchar2(30):='reinit_g_session_var';
581: begin
582: hr_utility.set_location('Entering:'|| l_proc, 5);
583: g_session_var.pa_request_id := null;
584: g_session_var.noa_id := null;
585: g_session_var.altered_pa_request_id := null;
586: g_session_var.noa_id_correct := null;

Line 596: hr_utility.set_location('Leaving:' || l_proc, 10);

592: g_session_var.pa_history_id := null;
593: g_pre_update.delete;
594: g_operation_info.delete;
595:
596: hr_utility.set_location('Leaving:' || l_proc, 10);
597:
598: end reinit_g_session_var;
599:
600: Procedure fetch_history_info(

Line 626: hr_utility.set_location('Entering:'|| l_proc, 5);

622: l_hist_data ghr_pa_history%rowtype;
623: l_proc varchar2(30) := 'fetch_history_info';
624:
625: begin
626: hr_utility.set_location('Entering:'|| l_proc, 5);
627: --
628: -- Remember IN OUT parameter IN values
629: l_hist_data := p_hist_data;
630:

Line 632: hr_utility.set_location(l_proc, 10);

628: -- Remember IN OUT parameter IN values
629: l_hist_data := p_hist_data;
630:
631: if ( lower(p_table_name) = lower(ghr_history_api.g_peop_table) ) then
632: hr_utility.set_location(l_proc, 10);
633: ghr_history_fetch.fetch_people(p_person_id => p_person_id,
634: p_date_effective => p_date_effective,
635: p_altered_pa_request_id => p_altered_pa_request_id,
636: p_noa_id_corrected => p_noa_id_corrected,

Line 645: hr_utility.set_location(l_proc, 15);

641:
642: ghr_history_conv_rg.conv_people_rg_to_hist_rg( p_people_data => l_people_data,
643: p_history_data => p_hist_data );
644: elsif ( lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) ) then
645: hr_utility.set_location(l_proc, 15);
646: ghr_history_fetch.fetch_asgei(p_assignment_extra_info_id => p_table_pk_id,
647: p_date_effective => p_date_effective,
648: p_altered_pa_request_id => p_altered_pa_request_id,
649: p_noa_id_corrected => p_noa_id_corrected,

Line 659: hr_utility.set_location(l_proc, 25);

655: p_asgnei_data => l_asgei_data,
656: p_history_data => p_hist_data );
657:
658: elsif ( lower(p_table_name) = lower(ghr_history_api.g_asgn_table) ) then
659: hr_utility.set_location(l_proc, 25);
660: ghr_history_fetch.fetch_assignment (
661: p_assignment_id => p_table_pk_id,
662: p_date_effective => p_date_effective,
663: p_altered_pa_request_id => p_altered_pa_request_id,

Line 675: hr_utility.set_location(l_proc, 35);

671: p_assignment_data => l_asgn_data,
672: p_history_data => p_hist_data );
673:
674: elsif ( lower(p_table_name) = lower(ghr_history_api.g_peopei_table) ) then
675: hr_utility.set_location(l_proc, 35);
676: ghr_history_fetch.fetch_peopleei(
677: p_person_extra_info_id => p_table_pk_id,
678: p_date_effective => p_date_effective,
679: p_altered_pa_request_id => p_altered_pa_request_id,

Line 691: hr_utility.set_location(l_proc, 35);

687: p_people_ei_data => l_peopleei_data,
688: p_history_data => p_hist_data );
689:
690: elsif ( lower(p_table_name) = lower(ghr_history_api.g_eleevl_table) ) then
691: hr_utility.set_location(l_proc, 35);
692: ghr_history_fetch.fetch_element_entry_value(
693: p_element_entry_value_id => p_table_pk_id,
694: p_date_effective => p_date_effective,
695: p_altered_pa_request_id => p_altered_pa_request_id,

Line 707: hr_utility.set_location(l_proc, 35);

703: p_element_entval_data => l_element_entry_value_data,
704: p_history_data => p_hist_data );
705:
706: elsif ( lower(p_table_name) = lower(ghr_history_api.g_eleent_table) ) then
707: hr_utility.set_location(l_proc, 35);
708: ghr_history_fetch.fetch_element_entries(
709: p_element_entry_id => p_table_pk_id,
710: p_date_effective => p_date_effective,
711: p_altered_pa_request_id => p_altered_pa_request_id,

Line 723: hr_utility.set_location(l_proc, 35);

719: p_element_entries_data => l_element_entry_data,
720: p_history_data => p_hist_data );
721:
722: elsif ( lower(p_table_name) = lower(ghr_history_api.g_posnei_table) ) then
723: hr_utility.set_location(l_proc, 35);
724: ghr_history_fetch.fetch_positionei(
725: p_position_extra_info_id => p_table_pk_id,
726: p_date_effective => p_date_effective,
727: p_altered_pa_request_id => p_altered_pa_request_id,

Line 739: hr_utility.set_location(l_proc, 40);

735: p_position_ei_data => l_posnei_data,
736: p_history_data => p_hist_data );
737:
738: elsif ( lower(p_table_name) = lower(ghr_history_api.g_perana_table) ) then
739: hr_utility.set_location(l_proc, 40);
740: ghr_history_fetch.fetch_person_analyses (
741: p_person_analysis_id => p_table_pk_id,
742: p_date_effective => p_date_effective,
743: p_altered_pa_request_id => p_altered_pa_request_id,

Line 754: hr_utility.set_location(l_proc, 40);

750: ghr_history_conv_rg.conv_peranalyses_rg_to_hist_rg(
751: p_peranalyses_data => l_peranalyses_data,
752: p_history_data => p_hist_data);
753: elsif ( lower(p_table_name) = lower(ghr_history_api.g_addres_table) ) then
754: hr_utility.set_location(l_proc, 40);
755: ghr_history_fetch.fetch_address(
756: p_address_id => p_table_pk_id,
757: p_date_effective => p_date_effective,
758: p_altered_pa_request_id => p_altered_pa_request_id,

Line 769: hr_utility.set_location(l_proc, 40);

765: ghr_history_conv_rg.conv_addresses_rg_to_hist_rg(
766: p_addresses_data => l_address_data,
767: p_history_data => p_hist_data);
768: elsif ( lower(p_table_name) = lower(ghr_history_api.g_posn_table) ) then
769: hr_utility.set_location(l_proc, 40);
770: ghr_history_fetch.fetch_position(
771: p_position_id => p_table_pk_id,
772: p_date_effective => p_date_effective,
773: p_altered_pa_request_id => p_altered_pa_request_id,

Line 785: hr_utility.set_location('ERROR: Table is unsupported. Table name : ' || p_table_name || l_proc, 45);

781: p_position_data => l_position_data,
782: p_history_data => p_hist_data);
783:
784: else
785: hr_utility.set_location('ERROR: Table is unsupported. Table name : ' || p_table_name || l_proc, 45);
786: hr_utility.set_message(8301,'GHR_38495_UNKNOWN_TABLE_NAME');
787: hr_utility.set_message_token('TABLE_NAME',p_table_name);
788: hr_utility.raise_error;
789: end if;

Line 786: hr_utility.set_message(8301,'GHR_38495_UNKNOWN_TABLE_NAME');

782: p_history_data => p_hist_data);
783:
784: else
785: hr_utility.set_location('ERROR: Table is unsupported. Table name : ' || p_table_name || l_proc, 45);
786: hr_utility.set_message(8301,'GHR_38495_UNKNOWN_TABLE_NAME');
787: hr_utility.set_message_token('TABLE_NAME',p_table_name);
788: hr_utility.raise_error;
789: end if;
790:

Line 787: hr_utility.set_message_token('TABLE_NAME',p_table_name);

783:
784: else
785: hr_utility.set_location('ERROR: Table is unsupported. Table name : ' || p_table_name || l_proc, 45);
786: hr_utility.set_message(8301,'GHR_38495_UNKNOWN_TABLE_NAME');
787: hr_utility.set_message_token('TABLE_NAME',p_table_name);
788: hr_utility.raise_error;
789: end if;
790:
791: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 788: hr_utility.raise_error;

784: else
785: hr_utility.set_location('ERROR: Table is unsupported. Table name : ' || p_table_name || l_proc, 45);
786: hr_utility.set_message(8301,'GHR_38495_UNKNOWN_TABLE_NAME');
787: hr_utility.set_message_token('TABLE_NAME',p_table_name);
788: hr_utility.raise_error;
789: end if;
790:
791: hr_utility.set_location(' Leaving:'||l_proc, 20);
792: exception when others then

Line 791: hr_utility.set_location(' Leaving:'||l_proc, 20);

787: hr_utility.set_message_token('TABLE_NAME',p_table_name);
788: hr_utility.raise_error;
789: end if;
790:
791: hr_utility.set_location(' Leaving:'||l_proc, 20);
792: exception when others then
793: --
794: -- Reset IN OUT parameters and set OUT parameters
795: --

Line 931: hr_utility.set_location( 'Entering : ' || l_proc, 10);

927: l_session_var g_session_var_type;
928: l_proc varchar2(30):='get_asgn_peop';
929:
930: Begin
931: hr_utility.set_location( 'Entering : ' || l_proc, 10);
932: --
933: -- Remember IN OUT parameter IN values
934: l_session_var := p_session_var;
935:

Line 938: hr_utility.set_location( l_proc, 20);

934: l_session_var := p_session_var;
935:
936: if p_session_var.assignment_id is null and
937: p_session_var.position_id is not null then
938: hr_utility.set_location( l_proc, 20);
939: open c1 (p_session_var.position_id);
940: fetch c1 into
941: p_session_var.assignment_id,
942: p_session_var.person_id;

Line 944: hr_utility.set_location( l_proc, 30);

940: fetch c1 into
941: p_session_var.assignment_id,
942: p_session_var.person_id;
943: if c1%notfound then
944: hr_utility.set_location( l_proc, 30);
945: end if;
946: close c1;
947: end if;
948:

Line 951: hr_utility.set_location( l_proc, 40);

947: end if;
948:
949: if p_session_var.assignment_id is null and
950: p_session_var.element_entry_id is not null then
951: hr_utility.set_location( l_proc, 40);
952: open c3( p_session_var.element_entry_id);
953: Fetch c3 into
954: p_session_var.assignment_id;
955: if c3%notfound then

Line 956: hr_utility.set_location( l_proc, 50);

952: open c3( p_session_var.element_entry_id);
953: Fetch c3 into
954: p_session_var.assignment_id;
955: if c3%notfound then
956: hr_utility.set_location( l_proc, 50);
957: end if;
958: close c3;
959: end if;
960:

Line 963: hr_utility.set_location( l_proc, 60);

959: end if;
960:
961: if p_session_var.person_id is null and
962: p_session_var.assignment_id is not null then
963: hr_utility.set_location( l_proc, 60);
964: open c2(p_session_var.assignment_id);
965: fetch c2 into
966: p_session_var.person_id;
967: if c2%notfound then

Line 968: hr_utility.set_location( l_proc, 20);

964: open c2(p_session_var.assignment_id);
965: fetch c2 into
966: p_session_var.person_id;
967: if c2%notfound then
968: hr_utility.set_location( l_proc, 20);
969: end if;
970: close c2;
971:
972: end if;

Line 982: hr_utility.set_location('Entering:'|| l_proc, 5);

978: raise;
979: End;
980:
981: BEGIN
982: hr_utility.set_location('Entering:'|| l_proc, 5);
983: /* set fire_trigger to N so that none of the cascading will cause triggers to be fired.
984: must be turned back on when cascading is complete. */
985: get_g_session_var (l_session_var);
986: l_session_var.fire_trigger := 'N';

Line 990: hr_utility.set_location(l_proc, 10);

986: l_session_var.fire_trigger := 'N';
987: -- set session variables (person_id, assignment_id) if value is null
988: get_asgn_peop( l_session_var);
989: set_g_session_var (l_session_var);
990: hr_utility.set_location(l_proc, 10);
991:
992: -- The following loop will loop thru all database rows that were touched in this session (everything in
993: -- g_operation_info rg). For every row, the corresponding history information will be inserted into
994: -- ghr_pa_history.

Line 997: hr_utility.set_location(l_proc || 'in post process' || to_char(indx) || g_operation_info(indx).operation, 10);

993: -- g_operation_info rg). For every row, the corresponding history information will be inserted into
994: -- ghr_pa_history.
995: WHILE indx <= g_operation_info.COUNT
996: LOOP
997: hr_utility.set_location(l_proc || 'in post process' || to_char(indx) || g_operation_info(indx).operation, 10);
998: l_hist_data := l_dummy_hist_data;
999: l_pre_record := l_dummy_hist_data;
1000: l_post_data := l_dummy_hist_data;
1001:

Line 1019: hr_utility.set_location(l_proc || 'using pre_update', 9158);

1015: lower(ghr_history_api.g_asgn_table),lower(ghr_history_api.g_peop_table),
1016: lower(ghr_history_api.g_posn_table),
1017: lower(ghr_history_api.g_eleent_table)) AND l_session_var.noa_id_correct is NULL AND
1018: lower(g_operation_info(indx).operation) = 'update') then
1019: hr_utility.set_location(l_proc || 'using pre_update', 9158);
1020: l_pre_record := g_pre_update(indx);
1021: -- Pre-record found
1022: l_return_Status := NULL;
1023: else

Line 1024: hr_utility.set_location(l_proc || 'calling fetch_history_info', 9157);

1020: l_pre_record := g_pre_update(indx);
1021: -- Pre-record found
1022: l_return_Status := NULL;
1023: else
1024: hr_utility.set_location(l_proc || 'calling fetch_history_info', 9157);
1025: -- Fetch Pre-record
1026: fetch_history_info(
1027: p_table_name => g_operation_info(indx).table_name,
1028: p_hist_data => l_hist_data,

Line 1039: hr_utility.set_location('l_pre_record.pa_history_id: ' || l_pre_record.pa_history_id || l_proc,2009);

1035:
1036: l_pre_record := l_hist_data;
1037:
1038: end if;
1039: hr_utility.set_location('l_pre_record.pa_history_id: ' || l_pre_record.pa_history_id || l_proc,2009);
1040: hr_utility.set_location('l_pre_record.information1: ' || l_pre_record.information1 || l_proc,2010);
1041: hr_utility.set_location('l_pre_record.person_id: ' || l_pre_record.person_id || l_proc,2011);
1042: hr_utility.set_location('l_pre_record.effective_date: ' || l_pre_record.effective_date || l_proc,2012);
1043: hr_utility.set_location('l_pre_record.information9: ' || l_pre_record.information9 || l_proc,2019);

Line 1040: hr_utility.set_location('l_pre_record.information1: ' || l_pre_record.information1 || l_proc,2010);

1036: l_pre_record := l_hist_data;
1037:
1038: end if;
1039: hr_utility.set_location('l_pre_record.pa_history_id: ' || l_pre_record.pa_history_id || l_proc,2009);
1040: hr_utility.set_location('l_pre_record.information1: ' || l_pre_record.information1 || l_proc,2010);
1041: hr_utility.set_location('l_pre_record.person_id: ' || l_pre_record.person_id || l_proc,2011);
1042: hr_utility.set_location('l_pre_record.effective_date: ' || l_pre_record.effective_date || l_proc,2012);
1043: hr_utility.set_location('l_pre_record.information9: ' || l_pre_record.information9 || l_proc,2019);
1044: hr_utility.set_location('l_pre_record.information10: ' || l_pre_record.information10 || l_proc,2020);

Line 1041: hr_utility.set_location('l_pre_record.person_id: ' || l_pre_record.person_id || l_proc,2011);

1037:
1038: end if;
1039: hr_utility.set_location('l_pre_record.pa_history_id: ' || l_pre_record.pa_history_id || l_proc,2009);
1040: hr_utility.set_location('l_pre_record.information1: ' || l_pre_record.information1 || l_proc,2010);
1041: hr_utility.set_location('l_pre_record.person_id: ' || l_pre_record.person_id || l_proc,2011);
1042: hr_utility.set_location('l_pre_record.effective_date: ' || l_pre_record.effective_date || l_proc,2012);
1043: hr_utility.set_location('l_pre_record.information9: ' || l_pre_record.information9 || l_proc,2019);
1044: hr_utility.set_location('l_pre_record.information10: ' || l_pre_record.information10 || l_proc,2020);
1045: hr_utility.set_location('l_pre_record.information11: ' || l_pre_record.information11 || l_proc,2021);

Line 1042: hr_utility.set_location('l_pre_record.effective_date: ' || l_pre_record.effective_date || l_proc,2012);

1038: end if;
1039: hr_utility.set_location('l_pre_record.pa_history_id: ' || l_pre_record.pa_history_id || l_proc,2009);
1040: hr_utility.set_location('l_pre_record.information1: ' || l_pre_record.information1 || l_proc,2010);
1041: hr_utility.set_location('l_pre_record.person_id: ' || l_pre_record.person_id || l_proc,2011);
1042: hr_utility.set_location('l_pre_record.effective_date: ' || l_pre_record.effective_date || l_proc,2012);
1043: hr_utility.set_location('l_pre_record.information9: ' || l_pre_record.information9 || l_proc,2019);
1044: hr_utility.set_location('l_pre_record.information10: ' || l_pre_record.information10 || l_proc,2020);
1045: hr_utility.set_location('l_pre_record.information11: ' || l_pre_record.information11 || l_proc,2021);
1046: hr_utility.set_location('l_pre_record.information12: ' || l_pre_record.information12 || l_proc,2022);

Line 1043: hr_utility.set_location('l_pre_record.information9: ' || l_pre_record.information9 || l_proc,2019);

1039: hr_utility.set_location('l_pre_record.pa_history_id: ' || l_pre_record.pa_history_id || l_proc,2009);
1040: hr_utility.set_location('l_pre_record.information1: ' || l_pre_record.information1 || l_proc,2010);
1041: hr_utility.set_location('l_pre_record.person_id: ' || l_pre_record.person_id || l_proc,2011);
1042: hr_utility.set_location('l_pre_record.effective_date: ' || l_pre_record.effective_date || l_proc,2012);
1043: hr_utility.set_location('l_pre_record.information9: ' || l_pre_record.information9 || l_proc,2019);
1044: hr_utility.set_location('l_pre_record.information10: ' || l_pre_record.information10 || l_proc,2020);
1045: hr_utility.set_location('l_pre_record.information11: ' || l_pre_record.information11 || l_proc,2021);
1046: hr_utility.set_location('l_pre_record.information12: ' || l_pre_record.information12 || l_proc,2022);
1047: hr_utility.set_location('l_pre_record.information13: ' || l_pre_record.information13 || l_proc,2023);

Line 1044: hr_utility.set_location('l_pre_record.information10: ' || l_pre_record.information10 || l_proc,2020);

1040: hr_utility.set_location('l_pre_record.information1: ' || l_pre_record.information1 || l_proc,2010);
1041: hr_utility.set_location('l_pre_record.person_id: ' || l_pre_record.person_id || l_proc,2011);
1042: hr_utility.set_location('l_pre_record.effective_date: ' || l_pre_record.effective_date || l_proc,2012);
1043: hr_utility.set_location('l_pre_record.information9: ' || l_pre_record.information9 || l_proc,2019);
1044: hr_utility.set_location('l_pre_record.information10: ' || l_pre_record.information10 || l_proc,2020);
1045: hr_utility.set_location('l_pre_record.information11: ' || l_pre_record.information11 || l_proc,2021);
1046: hr_utility.set_location('l_pre_record.information12: ' || l_pre_record.information12 || l_proc,2022);
1047: hr_utility.set_location('l_pre_record.information13: ' || l_pre_record.information13 || l_proc,2023);
1048: hr_utility.set_location('l_pre_record.information14: ' || l_pre_record.information14 || l_proc,2024);

Line 1045: hr_utility.set_location('l_pre_record.information11: ' || l_pre_record.information11 || l_proc,2021);

1041: hr_utility.set_location('l_pre_record.person_id: ' || l_pre_record.person_id || l_proc,2011);
1042: hr_utility.set_location('l_pre_record.effective_date: ' || l_pre_record.effective_date || l_proc,2012);
1043: hr_utility.set_location('l_pre_record.information9: ' || l_pre_record.information9 || l_proc,2019);
1044: hr_utility.set_location('l_pre_record.information10: ' || l_pre_record.information10 || l_proc,2020);
1045: hr_utility.set_location('l_pre_record.information11: ' || l_pre_record.information11 || l_proc,2021);
1046: hr_utility.set_location('l_pre_record.information12: ' || l_pre_record.information12 || l_proc,2022);
1047: hr_utility.set_location('l_pre_record.information13: ' || l_pre_record.information13 || l_proc,2023);
1048: hr_utility.set_location('l_pre_record.information14: ' || l_pre_record.information14 || l_proc,2024);
1049:

Line 1046: hr_utility.set_location('l_pre_record.information12: ' || l_pre_record.information12 || l_proc,2022);

1042: hr_utility.set_location('l_pre_record.effective_date: ' || l_pre_record.effective_date || l_proc,2012);
1043: hr_utility.set_location('l_pre_record.information9: ' || l_pre_record.information9 || l_proc,2019);
1044: hr_utility.set_location('l_pre_record.information10: ' || l_pre_record.information10 || l_proc,2020);
1045: hr_utility.set_location('l_pre_record.information11: ' || l_pre_record.information11 || l_proc,2021);
1046: hr_utility.set_location('l_pre_record.information12: ' || l_pre_record.information12 || l_proc,2022);
1047: hr_utility.set_location('l_pre_record.information13: ' || l_pre_record.information13 || l_proc,2023);
1048: hr_utility.set_location('l_pre_record.information14: ' || l_pre_record.information14 || l_proc,2024);
1049:
1050: IF g_operation_info(indx).operation = 'insert' THEN

Line 1047: hr_utility.set_location('l_pre_record.information13: ' || l_pre_record.information13 || l_proc,2023);

1043: hr_utility.set_location('l_pre_record.information9: ' || l_pre_record.information9 || l_proc,2019);
1044: hr_utility.set_location('l_pre_record.information10: ' || l_pre_record.information10 || l_proc,2020);
1045: hr_utility.set_location('l_pre_record.information11: ' || l_pre_record.information11 || l_proc,2021);
1046: hr_utility.set_location('l_pre_record.information12: ' || l_pre_record.information12 || l_proc,2022);
1047: hr_utility.set_location('l_pre_record.information13: ' || l_pre_record.information13 || l_proc,2023);
1048: hr_utility.set_location('l_pre_record.information14: ' || l_pre_record.information14 || l_proc,2024);
1049:
1050: IF g_operation_info(indx).operation = 'insert' THEN
1051: IF l_return_status IS NULL THEN

Line 1048: hr_utility.set_location('l_pre_record.information14: ' || l_pre_record.information14 || l_proc,2024);

1044: hr_utility.set_location('l_pre_record.information10: ' || l_pre_record.information10 || l_proc,2020);
1045: hr_utility.set_location('l_pre_record.information11: ' || l_pre_record.information11 || l_proc,2021);
1046: hr_utility.set_location('l_pre_record.information12: ' || l_pre_record.information12 || l_proc,2022);
1047: hr_utility.set_location('l_pre_record.information13: ' || l_pre_record.information13 || l_proc,2023);
1048: hr_utility.set_location('l_pre_record.information14: ' || l_pre_record.information14 || l_proc,2024);
1049:
1050: IF g_operation_info(indx).operation = 'insert' THEN
1051: IF l_return_status IS NULL THEN
1052: hr_utility.set_location(l_proc || 'Insert: history found.', 15);

Line 1052: hr_utility.set_location(l_proc || 'Insert: history found.', 15);

1048: hr_utility.set_location('l_pre_record.information14: ' || l_pre_record.information14 || l_proc,2024);
1049:
1050: IF g_operation_info(indx).operation = 'insert' THEN
1051: IF l_return_status IS NULL THEN
1052: hr_utility.set_location(l_proc || 'Insert: history found.', 15);
1053: -- inserting with pre-values
1054: l_pre_values_flag := 'Y';
1055: l_dml_operation := ghr_history_api.g_ins_operation;
1056: ELSE

Line 1057: hr_utility.set_location(l_proc || 'Insert: history NOT found.', 20);

1053: -- inserting with pre-values
1054: l_pre_values_flag := 'Y';
1055: l_dml_operation := ghr_history_api.g_ins_operation;
1056: ELSE
1057: hr_utility.set_location(l_proc || 'Insert: history NOT found.', 20);
1058: -- inserting with no pre-values
1059: l_dml_operation := ghr_history_api.g_ins_operation;
1060: l_pre_values_flag := 'N';
1061: END IF;

Line 1064: hr_utility.set_location(l_proc || 'Update.', 25);

1060: l_pre_values_flag := 'N';
1061: END IF;
1062: ELSIF g_operation_info(indx).operation = 'update' THEN
1063: -- set pre-record rg
1064: hr_utility.set_location(l_proc || 'Update.', 25);
1065: IF l_return_status IS NULL THEN
1066: hr_utility.set_location(l_proc || 'Update: history found.', 15);
1067: -- set Pre_record_rg and other flags
1068: -- updating with pre-values

Line 1066: hr_utility.set_location(l_proc || 'Update: history found.', 15);

1062: ELSIF g_operation_info(indx).operation = 'update' THEN
1063: -- set pre-record rg
1064: hr_utility.set_location(l_proc || 'Update.', 25);
1065: IF l_return_status IS NULL THEN
1066: hr_utility.set_location(l_proc || 'Update: history found.', 15);
1067: -- set Pre_record_rg and other flags
1068: -- updating with pre-values
1069: l_pre_values_flag := 'Y';
1070: l_dml_operation := ghr_history_api.g_upd_operation;

Line 1072: hr_utility.set_location(l_proc || 'Update: history NOT found.', 20);

1068: -- updating with pre-values
1069: l_pre_values_flag := 'Y';
1070: l_dml_operation := ghr_history_api.g_upd_operation;
1071: ELSE
1072: hr_utility.set_location(l_proc || 'Update: history NOT found.', 20);
1073: -- updating with no pre-values
1074: l_dml_operation := ghr_history_api.g_upd_operation;
1075: l_pre_values_flag := 'N';
1076: END IF;

Line 1080: hr_utility.set_location(l_proc || 'Fetch history info for post-update.', 30);

1076: END IF;
1077: END IF;
1078:
1079:
1080: hr_utility.set_location(l_proc || 'Fetch history info for post-update.', 30);
1081: -- get post_update using rowid.
1082: -- Need only pass rowid, other parms should be changed to be nullable.
1083: fetch_history_info(
1084: p_table_name => g_operation_info(indx).table_name,

Line 1103: hr_utility.set_location(l_proc || 'Add post-record record', 35);

1099: l_post_data.pre_values_flag := l_pre_values_flag;
1100: l_post_data.dml_operation := l_dml_operation;
1101: -- set post-update-rg
1102: init_record_data(l_session_var, l_post_data, indx);
1103: hr_utility.set_location(l_proc || 'Add post-record record', 35);
1104: hr_utility.set_location(l_proc || l_post_data.effective_date,36);
1105: hr_utility.set_location(l_proc || l_return_status,37);
1106:
1107: hr_utility.set_location(l_proc || 'Insert in pa history: effective_date = .' || to_char(l_post_data.effective_date), 40);

Line 1104: hr_utility.set_location(l_proc || l_post_data.effective_date,36);

1100: l_post_data.dml_operation := l_dml_operation;
1101: -- set post-update-rg
1102: init_record_data(l_session_var, l_post_data, indx);
1103: hr_utility.set_location(l_proc || 'Add post-record record', 35);
1104: hr_utility.set_location(l_proc || l_post_data.effective_date,36);
1105: hr_utility.set_location(l_proc || l_return_status,37);
1106:
1107: hr_utility.set_location(l_proc || 'Insert in pa history: effective_date = .' || to_char(l_post_data.effective_date), 40);
1108: hr_utility.set_location(l_proc || 'Insert in pa history: Process_date = .' || to_char(l_post_data.Process_date), 45);

Line 1105: hr_utility.set_location(l_proc || l_return_status,37);

1101: -- set post-update-rg
1102: init_record_data(l_session_var, l_post_data, indx);
1103: hr_utility.set_location(l_proc || 'Add post-record record', 35);
1104: hr_utility.set_location(l_proc || l_post_data.effective_date,36);
1105: hr_utility.set_location(l_proc || l_return_status,37);
1106:
1107: hr_utility.set_location(l_proc || 'Insert in pa history: effective_date = .' || to_char(l_post_data.effective_date), 40);
1108: hr_utility.set_location(l_proc || 'Insert in pa history: Process_date = .' || to_char(l_post_data.Process_date), 45);
1109: hr_utility.set_location(l_proc || 'Insert in pa history: table_name = .' || l_post_data.table_name, 50);

Line 1107: hr_utility.set_location(l_proc || 'Insert in pa history: effective_date = .' || to_char(l_post_data.effective_date), 40);

1103: hr_utility.set_location(l_proc || 'Add post-record record', 35);
1104: hr_utility.set_location(l_proc || l_post_data.effective_date,36);
1105: hr_utility.set_location(l_proc || l_return_status,37);
1106:
1107: hr_utility.set_location(l_proc || 'Insert in pa history: effective_date = .' || to_char(l_post_data.effective_date), 40);
1108: hr_utility.set_location(l_proc || 'Insert in pa history: Process_date = .' || to_char(l_post_data.Process_date), 45);
1109: hr_utility.set_location(l_proc || 'Insert in pa history: table_name = .' || l_post_data.table_name, 50);
1110: hr_utility.set_location(l_proc || 'Insert in pa history: pa_request_id = .' || to_char(l_post_data.pa_request_id), 60);
1111: hr_utility.set_location(l_proc || 'Insert in pa history: nature_of_action_id = .' || to_char(l_post_data.nature_of_action_id), 65);

Line 1108: hr_utility.set_location(l_proc || 'Insert in pa history: Process_date = .' || to_char(l_post_data.Process_date), 45);

1104: hr_utility.set_location(l_proc || l_post_data.effective_date,36);
1105: hr_utility.set_location(l_proc || l_return_status,37);
1106:
1107: hr_utility.set_location(l_proc || 'Insert in pa history: effective_date = .' || to_char(l_post_data.effective_date), 40);
1108: hr_utility.set_location(l_proc || 'Insert in pa history: Process_date = .' || to_char(l_post_data.Process_date), 45);
1109: hr_utility.set_location(l_proc || 'Insert in pa history: table_name = .' || l_post_data.table_name, 50);
1110: hr_utility.set_location(l_proc || 'Insert in pa history: pa_request_id = .' || to_char(l_post_data.pa_request_id), 60);
1111: hr_utility.set_location(l_proc || 'Insert in pa history: nature_of_action_id = .' || to_char(l_post_data.nature_of_action_id), 65);
1112: hr_utility.set_location(l_proc || 'Insert in pa history: dml_operation = .' || l_post_data.dml_operation, 75);

Line 1109: hr_utility.set_location(l_proc || 'Insert in pa history: table_name = .' || l_post_data.table_name, 50);

1105: hr_utility.set_location(l_proc || l_return_status,37);
1106:
1107: hr_utility.set_location(l_proc || 'Insert in pa history: effective_date = .' || to_char(l_post_data.effective_date), 40);
1108: hr_utility.set_location(l_proc || 'Insert in pa history: Process_date = .' || to_char(l_post_data.Process_date), 45);
1109: hr_utility.set_location(l_proc || 'Insert in pa history: table_name = .' || l_post_data.table_name, 50);
1110: hr_utility.set_location(l_proc || 'Insert in pa history: pa_request_id = .' || to_char(l_post_data.pa_request_id), 60);
1111: hr_utility.set_location(l_proc || 'Insert in pa history: nature_of_action_id = .' || to_char(l_post_data.nature_of_action_id), 65);
1112: hr_utility.set_location(l_proc || 'Insert in pa history: dml_operation = .' || l_post_data.dml_operation, 75);
1113:

Line 1110: hr_utility.set_location(l_proc || 'Insert in pa history: pa_request_id = .' || to_char(l_post_data.pa_request_id), 60);

1106:
1107: hr_utility.set_location(l_proc || 'Insert in pa history: effective_date = .' || to_char(l_post_data.effective_date), 40);
1108: hr_utility.set_location(l_proc || 'Insert in pa history: Process_date = .' || to_char(l_post_data.Process_date), 45);
1109: hr_utility.set_location(l_proc || 'Insert in pa history: table_name = .' || l_post_data.table_name, 50);
1110: hr_utility.set_location(l_proc || 'Insert in pa history: pa_request_id = .' || to_char(l_post_data.pa_request_id), 60);
1111: hr_utility.set_location(l_proc || 'Insert in pa history: nature_of_action_id = .' || to_char(l_post_data.nature_of_action_id), 65);
1112: hr_utility.set_location(l_proc || 'Insert in pa history: dml_operation = .' || l_post_data.dml_operation, 75);
1113:
1114: ghr_pah_ins.ins(

Line 1111: hr_utility.set_location(l_proc || 'Insert in pa history: nature_of_action_id = .' || to_char(l_post_data.nature_of_action_id), 65);

1107: hr_utility.set_location(l_proc || 'Insert in pa history: effective_date = .' || to_char(l_post_data.effective_date), 40);
1108: hr_utility.set_location(l_proc || 'Insert in pa history: Process_date = .' || to_char(l_post_data.Process_date), 45);
1109: hr_utility.set_location(l_proc || 'Insert in pa history: table_name = .' || l_post_data.table_name, 50);
1110: hr_utility.set_location(l_proc || 'Insert in pa history: pa_request_id = .' || to_char(l_post_data.pa_request_id), 60);
1111: hr_utility.set_location(l_proc || 'Insert in pa history: nature_of_action_id = .' || to_char(l_post_data.nature_of_action_id), 65);
1112: hr_utility.set_location(l_proc || 'Insert in pa history: dml_operation = .' || l_post_data.dml_operation, 75);
1113:
1114: ghr_pah_ins.ins(
1115: p_pa_history_id => pa_history_id ,

Line 1112: hr_utility.set_location(l_proc || 'Insert in pa history: dml_operation = .' || l_post_data.dml_operation, 75);

1108: hr_utility.set_location(l_proc || 'Insert in pa history: Process_date = .' || to_char(l_post_data.Process_date), 45);
1109: hr_utility.set_location(l_proc || 'Insert in pa history: table_name = .' || l_post_data.table_name, 50);
1110: hr_utility.set_location(l_proc || 'Insert in pa history: pa_request_id = .' || to_char(l_post_data.pa_request_id), 60);
1111: hr_utility.set_location(l_proc || 'Insert in pa history: nature_of_action_id = .' || to_char(l_post_data.nature_of_action_id), 65);
1112: hr_utility.set_location(l_proc || 'Insert in pa history: dml_operation = .' || l_post_data.dml_operation, 75);
1113:
1114: ghr_pah_ins.ins(
1115: p_pa_history_id => pa_history_id ,
1116: p_pa_request_id => l_post_data.pa_request_id ,

Line 1335: hr_utility.set_location(l_proc || ' g_do_not_cascade ' || ghr_ses_conv_pkg.g_do_not_cascade, 76);

1331: lower(ghr_history_api.g_eleent_table),
1332: lower(ghr_history_api.g_perana_table)) then
1333: -- this is the normal case for most of the tables we are tracking.
1334:
1335: hr_utility.set_location(l_proc || ' g_do_not_cascade ' || ghr_ses_conv_pkg.g_do_not_cascade, 76);
1336:
1337: if nvl(ghr_ses_conv_pkg.g_do_not_cascade,'N') <> 'Y' then
1338: ghr_history_cascade.Cascade_History_Data(
1339: p_table_name => upper(g_operation_info(indx).table_name),

Line 1370: hr_utility.set_location('ERROR: no date effective row found in history' || l_proc, 38);

1366: p_result_code => l_return_status ,
1367: p_pa_history_id => l_pa_history_id);
1368: if (l_return_status is not null) then
1369: -- this should never happen, but just in case
1370: hr_utility.set_location('ERROR: no date effective row found in history' || l_proc, 38);
1371: hr_utility.set_message(8301,'GHR_38360_NO_RECFND_FOR_DATE');
1372: hr_utility.raise_error;
1373: end if;
1374: ghr_history_conv_rg.conv_element_entval_rg_to_hist(

Line 1371: hr_utility.set_message(8301,'GHR_38360_NO_RECFND_FOR_DATE');

1367: p_pa_history_id => l_pa_history_id);
1368: if (l_return_status is not null) then
1369: -- this should never happen, but just in case
1370: hr_utility.set_location('ERROR: no date effective row found in history' || l_proc, 38);
1371: hr_utility.set_message(8301,'GHR_38360_NO_RECFND_FOR_DATE');
1372: hr_utility.raise_error;
1373: end if;
1374: ghr_history_conv_rg.conv_element_entval_rg_to_hist(
1375: p_element_entval_data => l_eleevl_data,

Line 1372: hr_utility.raise_error;

1368: if (l_return_status is not null) then
1369: -- this should never happen, but just in case
1370: hr_utility.set_location('ERROR: no date effective row found in history' || l_proc, 38);
1371: hr_utility.set_message(8301,'GHR_38360_NO_RECFND_FOR_DATE');
1372: hr_utility.raise_error;
1373: end if;
1374: ghr_history_conv_rg.conv_element_entval_rg_to_hist(
1375: p_element_entval_data => l_eleevl_data,
1376: p_history_data => l_eleevl_hist_data );

Line 1395: hr_utility.set_location(l_proc || ' g_do_not_cascade ' || ghr_ses_conv_pkg.g_do_not_cascade, 78);

1391:
1392: if l_interv_on_table then
1393: -- if changes were cascaded in the history table then we may have to cascade
1394: -- changes in database tables
1395: hr_utility.set_location(l_proc || ' g_do_not_cascade ' || ghr_ses_conv_pkg.g_do_not_cascade, 78);
1396:
1397: if nvl(ghr_ses_conv_pkg.g_do_not_cascade,'N') <> 'Y' then
1398: IF NVL(l_post_data.information5,'N') <> 'GHR_US_RETAINED_GRADE' then -- Bug 2715828/3021003
1399: -- NO need to cascade for Retained Grade.

Line 1417: hr_utility.set_location(l_proc, 15);

1413: end if;
1414:
1415: indx := indx + 1;
1416: END LOOP;
1417: hr_utility.set_location(l_proc, 15);
1418:
1419: /* set fire_trigger to Y. Cascading is complete. All triggers should be set to fire again. */
1420: get_g_session_var (l_session_var);
1421: l_session_var.fire_trigger := 'Y';

Line 1428: hr_utility.set_location('Entering GHR_HISTORY_API.Post_forms_commit_process',1729);

1424:
1425: Procedure Post_forms_commit_process( p_eff_date in date) is
1426: l_session_var g_session_var_type;
1427: Begin
1428: hr_utility.set_location('Entering GHR_HISTORY_API.Post_forms_commit_process',1729);
1429: /*Start Bug:7529592 */
1430: get_g_session_var (l_session_var);
1431:
1432: IF(p_eff_date <> l_session_var.date_effective) THEN

Line 1448: hr_utility.set_location('Leaving GHR_HISTORY_API.Post_forms_commit_process',1729);

1444: reinit_g_session_var;
1445:
1446: ghr_api.g_api_dml := FALSE;
1447: new_form_instance_process;
1448: hr_utility.set_location('Leaving GHR_HISTORY_API.Post_forms_commit_process',1729);
1449:
1450: end post_forms_commit_process;
1451:
1452: Procedure New_form_instance_process is

Line 1503: hr_utility.set_message(8301, 'GHR_SESSION_DATE_NOT_FND');

1499: open c_getsessdate;
1500: fetch c_getsessdate into p_sess_date;
1501: if c_getsessdate%notfound then
1502: close c_getsessdate;
1503: hr_utility.set_message(8301, 'GHR_SESSION_DATE_NOT_FND');
1504: hr_utility.raise_error;
1505: end if;
1506: close c_getsessdate ;
1507: End get_session_date ;

Line 1504: hr_utility.raise_error;

1500: fetch c_getsessdate into p_sess_date;
1501: if c_getsessdate%notfound then
1502: close c_getsessdate;
1503: hr_utility.set_message(8301, 'GHR_SESSION_DATE_NOT_FND');
1504: hr_utility.raise_error;
1505: end if;
1506: close c_getsessdate ;
1507: End get_session_date ;
1508: