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 930: hr_utility.set_location( 'Entering : ' || l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1075: END IF;
1076: END IF;
1077:
1078:
1079: hr_utility.set_location(l_proc || 'Fetch history info for post-update.', 30);
1080: -- get post_update using rowid.
1081: -- Need only pass rowid, other parms should be changed to be nullable.
1082: fetch_history_info(
1083: 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.dml_operation := l_dml_operation;
1100:
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:
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 1494: hr_utility.set_message(8301, 'GHR_SESSION_DATE_NOT_FND');

1490: open c_getsessdate;
1491: fetch c_getsessdate into p_sess_date;
1492: if c_getsessdate%notfound then
1493: close c_getsessdate;
1494: hr_utility.set_message(8301, 'GHR_SESSION_DATE_NOT_FND');
1495: hr_utility.raise_error;
1496: end if;
1497: close c_getsessdate ;
1498: End get_session_date ;

Line 1495: hr_utility.raise_error;

1491: fetch c_getsessdate into p_sess_date;
1492: if c_getsessdate%notfound then
1493: close c_getsessdate;
1494: hr_utility.set_message(8301, 'GHR_SESSION_DATE_NOT_FND');
1495: hr_utility.raise_error;
1496: end if;
1497: close c_getsessdate ;
1498: End get_session_date ;
1499: