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

Line 223: hr_utility.set_location('Get Fnc txn sht nam:'||p_transaction_short_name, 51);

219: begin
220: --
221: -- Context Assumption : context on the copy entity txns is the reference.
222: --
223: hr_utility.set_location('Get Fnc txn sht nam:'||p_transaction_short_name, 51);
224: hr_utility.set_location(' context :'||p_context, 52);
225: hr_utility.set_location(' table route:'||p_table_route_id, 53);
226: p_function_type_cd := '' ;
227: p_pre_copy_function_name := '' ;

Line 224: hr_utility.set_location(' context :'||p_context, 52);

220: --
221: -- Context Assumption : context on the copy entity txns is the reference.
222: --
223: hr_utility.set_location('Get Fnc txn sht nam:'||p_transaction_short_name, 51);
224: hr_utility.set_location(' context :'||p_context, 52);
225: hr_utility.set_location(' table route:'||p_table_route_id, 53);
226: p_function_type_cd := '' ;
227: p_pre_copy_function_name := '' ;
228: p_copy_function_name := '' ;

Line 225: hr_utility.set_location(' table route:'||p_table_route_id, 53);

221: -- Context Assumption : context on the copy entity txns is the reference.
222: --
223: hr_utility.set_location('Get Fnc txn sht nam:'||p_transaction_short_name, 51);
224: hr_utility.set_location(' context :'||p_context, 52);
225: hr_utility.set_location(' table route:'||p_table_route_id, 53);
226: p_function_type_cd := '' ;
227: p_pre_copy_function_name := '' ;
228: p_copy_function_name := '' ;
229: p_post_copy_function_name := '' ;

Line 234: hr_utility.set_location(' appl shrt nam :'||rec.application_short_name||'-'||erec.application_short_name, 53);

230: --
231: for rec in c_con loop
232: --
233: for erec in c_all loop
234: hr_utility.set_location(' appl shrt nam :'||rec.application_short_name||'-'||erec.application_short_name, 53);
235: hr_utility.set_location(' Leg code :'||rec.legislation_code||'-'||erec.legislation_code, 54);
236: hr_utility.set_location(' Resp Key :'||rec.responsibility_key||'-'||erec.responsibility_key, 55);
237: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and
238: nvl(rec.legislation_code,hr_api.g_varchar2) = nvl(erec.legislation_code,hr_api.g_varchar2) and

Line 235: hr_utility.set_location(' Leg code :'||rec.legislation_code||'-'||erec.legislation_code, 54);

231: for rec in c_con loop
232: --
233: for erec in c_all loop
234: hr_utility.set_location(' appl shrt nam :'||rec.application_short_name||'-'||erec.application_short_name, 53);
235: hr_utility.set_location(' Leg code :'||rec.legislation_code||'-'||erec.legislation_code, 54);
236: hr_utility.set_location(' Resp Key :'||rec.responsibility_key||'-'||erec.responsibility_key, 55);
237: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and
238: nvl(rec.legislation_code,hr_api.g_varchar2) = nvl(erec.legislation_code,hr_api.g_varchar2) and
239: nvl(rec.responsibility_key,hr_api.g_varchar2) = nvl(erec.responsibility_key,hr_api.g_varchar2) then

Line 236: hr_utility.set_location(' Resp Key :'||rec.responsibility_key||'-'||erec.responsibility_key, 55);

232: --
233: for erec in c_all loop
234: hr_utility.set_location(' appl shrt nam :'||rec.application_short_name||'-'||erec.application_short_name, 53);
235: hr_utility.set_location(' Leg code :'||rec.legislation_code||'-'||erec.legislation_code, 54);
236: hr_utility.set_location(' Resp Key :'||rec.responsibility_key||'-'||erec.responsibility_key, 55);
237: if nvl(rec.application_short_name,hr_api.g_varchar2) = nvl(erec.application_short_name,hr_api.g_varchar2) and
238: nvl(rec.legislation_code,hr_api.g_varchar2) = nvl(erec.legislation_code,hr_api.g_varchar2) and
239: nvl(rec.responsibility_key,hr_api.g_varchar2) = nvl(erec.responsibility_key,hr_api.g_varchar2) then
240: --

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

309: end get_function_details;
310: --
311: Begin
312: --
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: -- populate local variables with
316: -- transaction_category_id => which identifies the transaction
317: -- master_table_route_id => the master table associated with the transaction

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

387: pqh_process_batch_log.start_log (p_batch_id => p_copy_entity_txn_id,
388: p_module_cd => nvl(l_transaction_short_name, 'ERROR- GEN CPY') ,
389: p_log_context => l_name ) ;
390: --
391: hr_utility.set_location(' '||l_proc ||' rec2', 5);
392: --
393: for rec2 in c_target loop
394: --
395: update pqh_copy_entity_results

Line 417: hr_utility.set_location(' '||l_proc ||' rec3', 5);

413: l_reset_flag := 'N' ;
414: --
415: -- for every target record repoplated PLtable with new PK details
416: --
417: hr_utility.set_location(' '||l_proc ||' rec3', 5);
418: --
419: for rec3 in c_attribs(rec2.copy_entity_txn_id, l_master_table_route_id, 'PRIMARY_KEY') loop
420: --
421: dynamic_pltab_populate (p_ddf_column_name => rec3.ddf_column_name

Line 436: hr_utility.set_location(' '||l_proc ||' rec4', 5);

432: -- for every target record repoplated PLtable with column details of new rec
433: --
434: l_reset_flag := 'Y' ;
435: --
436: hr_utility.set_location(' '||l_proc ||' rec4', 5);
437: --
438: for rec4 in c_change(rec2.copy_entity_txn_id, l_master_table_route_id) loop
439: --
440: -- poplated PLtable with new changeable details which the user postentially could have changed

Line 456: hr_utility.set_location(l_proc||' : after change', 111);

452: l_reset_flag := 'N' ;
453: --
454: end loop; -- c_change
455: --
456: hr_utility.set_location(l_proc||' : after change', 111);
457: --
458: for rec5 in c_attribs(rec2.copy_entity_txn_id, l_master_table_route_id, 'PARAMETER') loop
459: --
460: -- poplated PLtable with parameter details which the transaction expects on the global table

Line 471: hr_utility.set_location(l_proc||' : after attribs', 111);

467: , p_reset_flag => 'N' -- delete before populate flag
468: , p_source_flag => 'N' ) ; -- specify source/target PLtable
469: end loop; -- c_attribs
470: --
471: hr_utility.set_location(l_proc||' : after attribs', 111);
472: --
473: -- the following loop is only for debugging purposes
474: --
475: for i in nvl(PQH_GENERIC.g_source_pk_table.first,0)..nvl(PQH_GENERIC.g_source_pk_table.last,-1) loop

Line 477: hr_utility.set_location(i||'S- '||PQH_GENERIC.g_source_pk_table(i).column_name||'- '

473: -- the following loop is only for debugging purposes
474: --
475: for i in nvl(PQH_GENERIC.g_source_pk_table.first,0)..nvl(PQH_GENERIC.g_source_pk_table.last,-1) loop
476: begin
477: hr_utility.set_location(i||'S- '||PQH_GENERIC.g_source_pk_table(i).column_name||'- '
478: || PQH_GENERIC.g_source_pk_table(i).column_type||'- '
479: || PQH_GENERIC.g_source_pk_table(i).value,11);
480: hr_utility.set_location(i||'T- '||PQH_GENERIC.g_target_pk_table(i).column_name||'- '
481: || PQH_GENERIC.g_target_pk_table(i).column_type||'- '

Line 480: hr_utility.set_location(i||'T- '||PQH_GENERIC.g_target_pk_table(i).column_name||'- '

476: begin
477: hr_utility.set_location(i||'S- '||PQH_GENERIC.g_source_pk_table(i).column_name||'- '
478: || PQH_GENERIC.g_source_pk_table(i).column_type||'- '
479: || PQH_GENERIC.g_source_pk_table(i).value,11);
480: hr_utility.set_location(i||'T- '||PQH_GENERIC.g_target_pk_table(i).column_name||'- '
481: || PQH_GENERIC.g_target_pk_table(i).column_type||'- '
482: || PQH_GENERIC.g_target_pk_table(i).value,11);
483: exception when others then null;
484: end;

Line 492: hr_utility.set_location('on master '||p_master_required_flag, 5);

488: --
489: -- check if master copy is required (in case of duplicate rec on form, master would not be required)
490: --
491: if p_master_required_flag = 'Y' then
492: hr_utility.set_location('on master '||p_master_required_flag, 5);
493: -- start of bug 5052820
494: --
495: if (pqh_generic.g_gbl_context ='Global Position Update'
496: and l_dt_mode ='UPDATE_CHANGE_INSERT') then

Line 531: hr_utility.set_location('on master heading for upd', 499);

527: , p_pre_copy_proc => l_pre_copy_function_name
528: , p_copy_proc => l_copy_function_name
529: , p_post_copy_proc => l_post_copy_function_name);
530: --
531: hr_utility.set_location('on master heading for upd', 499);
532: update pqh_copy_entity_results
533: set number_of_copies = '0'
534: where copy_entity_result_id = rec2.copy_entity_result_id
535: and status in ('COMPLETED','DPT_ERR') ;

Line 538: hr_utility.set_location('on master exception', 500);

534: where copy_entity_result_id = rec2.copy_entity_result_id
535: and status in ('COMPLETED','DPT_ERR') ;
536: exception
537: when others then
538: hr_utility.set_location('on master exception', 500);
539: pqh_generic.v_err := sqlerrm;
540: Raise_Error(p_copy_entity_result_id => rec2.copy_entity_result_id,
541: p_msg_code => 'ERR:');
542: end ;

Line 551: hr_utility.set_location('On Details ', 51);

547: -- Dependent starts
548: g_level := 2 ; -- 2 implying the first dependents
549: --
550: if ( p_master_required_flag = 'Y' and g_success) or p_master_required_flag <> 'Y' then
551: hr_utility.set_location('On Details ', 51);
552: --
553: for rec7 in c_dep_details(rec2.copy_entity_txn_id) loop
554: hr_utility.set_location('on dependent '||rec7.table_route_id, 5);
555: --

Line 554: hr_utility.set_location('on dependent '||rec7.table_route_id, 5);

550: if ( p_master_required_flag = 'Y' and g_success) or p_master_required_flag <> 'Y' then
551: hr_utility.set_location('On Details ', 51);
552: --
553: for rec7 in c_dep_details(rec2.copy_entity_txn_id) loop
554: hr_utility.set_location('on dependent '||rec7.table_route_id, 5);
555: --
556: l_function_context := get_function_details
557: ( p_table_route_id => rec7.table_route_id
558: , p_transaction_short_name => l_transaction_short_name

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

586: -- End Dependent
587: --
588: end loop; --c_target
589: --
590: hr_utility.set_location('Leaving:'||l_proc, 10);
591: --
592: pqh_process_batch_log.end_log ;
593: --
594: End generic_fn;

Line 702: hr_utility.trace('Starting.. ');

698: argument99 varchar2 default null ,
699: argument100 varchar2 default null
700: ) is
701: begin
702: hr_utility.trace('Starting.. ');
703: hr_utility.trace(argument1);
704: --
705: pqh_generic.g_calling_mode := 'CONCURRENT' ;
706: pqh_generic.v_err := '';

Line 703: hr_utility.trace(argument1);

699: argument100 varchar2 default null
700: ) is
701: begin
702: hr_utility.trace('Starting.. ');
703: hr_utility.trace(argument1);
704: --
705: pqh_generic.g_calling_mode := 'CONCURRENT' ;
706: pqh_generic.v_err := '';
707: g_conc_warn_flag := false;

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

803: and sat.enable_flag = 'Y'
804: and sat.context = pqh_generic.g_gbl_context ;
805: begin
806: --
807: hr_utility.set_location('Entering:'||l_proc, 5);
808: --
809: -- Build table attributes, parameters and variables
810: --
811: for e_rec in c_attrib('SELECT') loop

Line 826: l_string := l_string||' hr_utility.set_location(''Rec.Eff strt dt''||rec.effective_start_date,1000); ';

822: end if; --c_attrib%rowcount = 1
823: --
824:
825: if e_rec.param = 'EFFECTIVE_START_DATE' then
826: l_string := l_string||' hr_utility.set_location(''Rec.Eff strt dt''||rec.effective_start_date,1000); ';
827: end if ;
828:
829: end loop; -- c_attrib loop
830: --

Line 831: --hr_utility.set_location(' '||l_proc||' param/attribs', 10);

827: end if ;
828:
829: end loop; -- c_attrib loop
830: --
831: --hr_utility.set_location(' '||l_proc||' param/attribs', 10);
832: --
833: -- parameters are for the functions
834: -- attributes are for variable definitions
835: --

Line 858: --hr_utility.set_location(' '||l_proc||' pri key', 10);

854: if instr(upper(l_attribute), 'L_EFFECTIVE_DATE') = 0 then
855: l_attribute := l_attribute ||' l_effective_date date;';
856: end if;
857: --
858: --hr_utility.set_location(' '||l_proc||' pri key', 10);
859: --
860: --
861: -- loop to store values on the target table which would potentially affect the child records
862: --

Line 883: hr_utility.set_location(' '||l_proc||' repl where', 10);

879: l_log := ' pqh_generic.log_error(p_table_route_id => '||p_table_route_id||',p_err_key => L_'|| e_rec.param ||');';
880: --
881: end loop; -- c_attrib
882: --
883: hr_utility.set_location(' '||l_proc||' repl where', 10);
884: --
885: --
886: -- Replace where clause
887: --

Line 905: hr_utility.set_location(l_proc||' pcp: '||l_pre_copy_proc,5);

901: l_pre_copy_proc := 'null ';
902: else
903: l_pre_copy_proc := p_pre_copy_proc||'('||l_parameter||')';
904: end if; --p_pre_copy_proc is not null
905: hr_utility.set_location(l_proc||' pcp: '||l_pre_copy_proc,5);
906: --
907: if p_copy_proc is null then
908: l_copy_proc := 'null ';
909: else

Line 912: hr_utility.set_location(l_proc||' cp: '||p_copy_proc,5);

908: l_copy_proc := 'null ';
909: else
910: l_copy_proc := p_copy_proc||'('||l_parameter||')';
911: end if; --p_copy_proc is not null
912: hr_utility.set_location(l_proc||' cp: '||p_copy_proc,5);
913: --
914: if p_post_copy_proc is null then
915: l_post_copy_proc := 'null ';
916: else

Line 919: hr_utility.set_location(l_proc||' pcp: '||l_post_copy_proc,5);

915: l_post_copy_proc := 'null ';
916: else
917: l_post_copy_proc := p_post_copy_proc||'('||l_parameter||')';
918: end if; --p_post_copy_proc is not null
919: hr_utility.set_location(l_proc||' pcp: '||l_post_copy_proc,5);
920: --
921: -- set session date incase the same is not set.
922: --
923: if (upd_where='N') then

Line 958: hr_utility.set_location(l_proc||' L_efffective_date: '||to_char(pqh_generic.get_src_effective_date,'MM/DD/RRRR'),51);

954:
955: end if;
956: -- bug 5052820 modified the above l_set_session by changing the call to get_trg_effective_date
957:
958: hr_utility.set_location(l_proc||' L_efffective_date: '||to_char(pqh_generic.get_src_effective_date,'MM/DD/RRRR'),51);
959: --
960: /**
961: * Bug Fix: 3032847
962: * Describe: to copy the work choice

Line 996: hr_utility.trace('BEGIN SPOOL DYN STATEMENT-PQH_GENERIC ');

992: || 'end; ' ;
993: --
994: -- trace the dyn statement
995: --
996: hr_utility.trace('BEGIN SPOOL DYN STATEMENT-PQH_GENERIC ');
997:
998: hr_utility.trace(substr(l_l,1,2000 ));
999: hr_utility.trace(substr(l_l,2001,2000 ));
1000: hr_utility.trace(substr(l_l,4001,2000 ));

Line 998: hr_utility.trace(substr(l_l,1,2000 ));

994: -- trace the dyn statement
995: --
996: hr_utility.trace('BEGIN SPOOL DYN STATEMENT-PQH_GENERIC ');
997:
998: hr_utility.trace(substr(l_l,1,2000 ));
999: hr_utility.trace(substr(l_l,2001,2000 ));
1000: hr_utility.trace(substr(l_l,4001,2000 ));
1001: hr_utility.trace(substr(l_l,6001,2000 ));
1002: hr_utility.trace(substr(l_l,8001,2000 ));

Line 999: hr_utility.trace(substr(l_l,2001,2000 ));

995: --
996: hr_utility.trace('BEGIN SPOOL DYN STATEMENT-PQH_GENERIC ');
997:
998: hr_utility.trace(substr(l_l,1,2000 ));
999: hr_utility.trace(substr(l_l,2001,2000 ));
1000: hr_utility.trace(substr(l_l,4001,2000 ));
1001: hr_utility.trace(substr(l_l,6001,2000 ));
1002: hr_utility.trace(substr(l_l,8001,2000 ));
1003: hr_utility.trace(substr(l_l,10001,2000 ));

Line 1000: hr_utility.trace(substr(l_l,4001,2000 ));

996: hr_utility.trace('BEGIN SPOOL DYN STATEMENT-PQH_GENERIC ');
997:
998: hr_utility.trace(substr(l_l,1,2000 ));
999: hr_utility.trace(substr(l_l,2001,2000 ));
1000: hr_utility.trace(substr(l_l,4001,2000 ));
1001: hr_utility.trace(substr(l_l,6001,2000 ));
1002: hr_utility.trace(substr(l_l,8001,2000 ));
1003: hr_utility.trace(substr(l_l,10001,2000 ));
1004: hr_utility.trace(substr(l_l,12001,2000 ));

Line 1001: hr_utility.trace(substr(l_l,6001,2000 ));

997:
998: hr_utility.trace(substr(l_l,1,2000 ));
999: hr_utility.trace(substr(l_l,2001,2000 ));
1000: hr_utility.trace(substr(l_l,4001,2000 ));
1001: hr_utility.trace(substr(l_l,6001,2000 ));
1002: hr_utility.trace(substr(l_l,8001,2000 ));
1003: hr_utility.trace(substr(l_l,10001,2000 ));
1004: hr_utility.trace(substr(l_l,12001,2000 ));
1005: hr_utility.trace(substr(l_l,14001,2000 ));

Line 1002: hr_utility.trace(substr(l_l,8001,2000 ));

998: hr_utility.trace(substr(l_l,1,2000 ));
999: hr_utility.trace(substr(l_l,2001,2000 ));
1000: hr_utility.trace(substr(l_l,4001,2000 ));
1001: hr_utility.trace(substr(l_l,6001,2000 ));
1002: hr_utility.trace(substr(l_l,8001,2000 ));
1003: hr_utility.trace(substr(l_l,10001,2000 ));
1004: hr_utility.trace(substr(l_l,12001,2000 ));
1005: hr_utility.trace(substr(l_l,14001,2000 ));
1006: hr_utility.trace(substr(l_l,16001,2000 ));

Line 1003: hr_utility.trace(substr(l_l,10001,2000 ));

999: hr_utility.trace(substr(l_l,2001,2000 ));
1000: hr_utility.trace(substr(l_l,4001,2000 ));
1001: hr_utility.trace(substr(l_l,6001,2000 ));
1002: hr_utility.trace(substr(l_l,8001,2000 ));
1003: hr_utility.trace(substr(l_l,10001,2000 ));
1004: hr_utility.trace(substr(l_l,12001,2000 ));
1005: hr_utility.trace(substr(l_l,14001,2000 ));
1006: hr_utility.trace(substr(l_l,16001,2000 ));
1007: hr_utility.trace(substr(l_l,18001,2000 ));

Line 1004: hr_utility.trace(substr(l_l,12001,2000 ));

1000: hr_utility.trace(substr(l_l,4001,2000 ));
1001: hr_utility.trace(substr(l_l,6001,2000 ));
1002: hr_utility.trace(substr(l_l,8001,2000 ));
1003: hr_utility.trace(substr(l_l,10001,2000 ));
1004: hr_utility.trace(substr(l_l,12001,2000 ));
1005: hr_utility.trace(substr(l_l,14001,2000 ));
1006: hr_utility.trace(substr(l_l,16001,2000 ));
1007: hr_utility.trace(substr(l_l,18001,2000 ));
1008: hr_utility.trace(substr(l_l,20001,2000 ));

Line 1005: hr_utility.trace(substr(l_l,14001,2000 ));

1001: hr_utility.trace(substr(l_l,6001,2000 ));
1002: hr_utility.trace(substr(l_l,8001,2000 ));
1003: hr_utility.trace(substr(l_l,10001,2000 ));
1004: hr_utility.trace(substr(l_l,12001,2000 ));
1005: hr_utility.trace(substr(l_l,14001,2000 ));
1006: hr_utility.trace(substr(l_l,16001,2000 ));
1007: hr_utility.trace(substr(l_l,18001,2000 ));
1008: hr_utility.trace(substr(l_l,20001,2000 ));
1009: hr_utility.trace(substr(l_l,22001,2000 ));

Line 1006: hr_utility.trace(substr(l_l,16001,2000 ));

1002: hr_utility.trace(substr(l_l,8001,2000 ));
1003: hr_utility.trace(substr(l_l,10001,2000 ));
1004: hr_utility.trace(substr(l_l,12001,2000 ));
1005: hr_utility.trace(substr(l_l,14001,2000 ));
1006: hr_utility.trace(substr(l_l,16001,2000 ));
1007: hr_utility.trace(substr(l_l,18001,2000 ));
1008: hr_utility.trace(substr(l_l,20001,2000 ));
1009: hr_utility.trace(substr(l_l,22001,2000 ));
1010: hr_utility.trace(substr(l_l,24001,2000 ));

Line 1007: hr_utility.trace(substr(l_l,18001,2000 ));

1003: hr_utility.trace(substr(l_l,10001,2000 ));
1004: hr_utility.trace(substr(l_l,12001,2000 ));
1005: hr_utility.trace(substr(l_l,14001,2000 ));
1006: hr_utility.trace(substr(l_l,16001,2000 ));
1007: hr_utility.trace(substr(l_l,18001,2000 ));
1008: hr_utility.trace(substr(l_l,20001,2000 ));
1009: hr_utility.trace(substr(l_l,22001,2000 ));
1010: hr_utility.trace(substr(l_l,24001,2000 ));
1011: hr_utility.trace(substr(l_l,26001,2000 ));

Line 1008: hr_utility.trace(substr(l_l,20001,2000 ));

1004: hr_utility.trace(substr(l_l,12001,2000 ));
1005: hr_utility.trace(substr(l_l,14001,2000 ));
1006: hr_utility.trace(substr(l_l,16001,2000 ));
1007: hr_utility.trace(substr(l_l,18001,2000 ));
1008: hr_utility.trace(substr(l_l,20001,2000 ));
1009: hr_utility.trace(substr(l_l,22001,2000 ));
1010: hr_utility.trace(substr(l_l,24001,2000 ));
1011: hr_utility.trace(substr(l_l,26001,2000 ));
1012: hr_utility.trace(substr(l_l,28001,2000 ));

Line 1009: hr_utility.trace(substr(l_l,22001,2000 ));

1005: hr_utility.trace(substr(l_l,14001,2000 ));
1006: hr_utility.trace(substr(l_l,16001,2000 ));
1007: hr_utility.trace(substr(l_l,18001,2000 ));
1008: hr_utility.trace(substr(l_l,20001,2000 ));
1009: hr_utility.trace(substr(l_l,22001,2000 ));
1010: hr_utility.trace(substr(l_l,24001,2000 ));
1011: hr_utility.trace(substr(l_l,26001,2000 ));
1012: hr_utility.trace(substr(l_l,28001,2000 ));
1013: hr_utility.trace(substr(l_l,30001,2000 ));

Line 1010: hr_utility.trace(substr(l_l,24001,2000 ));

1006: hr_utility.trace(substr(l_l,16001,2000 ));
1007: hr_utility.trace(substr(l_l,18001,2000 ));
1008: hr_utility.trace(substr(l_l,20001,2000 ));
1009: hr_utility.trace(substr(l_l,22001,2000 ));
1010: hr_utility.trace(substr(l_l,24001,2000 ));
1011: hr_utility.trace(substr(l_l,26001,2000 ));
1012: hr_utility.trace(substr(l_l,28001,2000 ));
1013: hr_utility.trace(substr(l_l,30001,2000 ));
1014: --hr_utility.trace(' ');

Line 1011: hr_utility.trace(substr(l_l,26001,2000 ));

1007: hr_utility.trace(substr(l_l,18001,2000 ));
1008: hr_utility.trace(substr(l_l,20001,2000 ));
1009: hr_utility.trace(substr(l_l,22001,2000 ));
1010: hr_utility.trace(substr(l_l,24001,2000 ));
1011: hr_utility.trace(substr(l_l,26001,2000 ));
1012: hr_utility.trace(substr(l_l,28001,2000 ));
1013: hr_utility.trace(substr(l_l,30001,2000 ));
1014: --hr_utility.trace(' ');
1015: hr_utility.trace('END SPOOL DYN STATEMENT-PQH_GENERIC ');

Line 1012: hr_utility.trace(substr(l_l,28001,2000 ));

1008: hr_utility.trace(substr(l_l,20001,2000 ));
1009: hr_utility.trace(substr(l_l,22001,2000 ));
1010: hr_utility.trace(substr(l_l,24001,2000 ));
1011: hr_utility.trace(substr(l_l,26001,2000 ));
1012: hr_utility.trace(substr(l_l,28001,2000 ));
1013: hr_utility.trace(substr(l_l,30001,2000 ));
1014: --hr_utility.trace(' ');
1015: hr_utility.trace('END SPOOL DYN STATEMENT-PQH_GENERIC ');
1016: --

Line 1013: hr_utility.trace(substr(l_l,30001,2000 ));

1009: hr_utility.trace(substr(l_l,22001,2000 ));
1010: hr_utility.trace(substr(l_l,24001,2000 ));
1011: hr_utility.trace(substr(l_l,26001,2000 ));
1012: hr_utility.trace(substr(l_l,28001,2000 ));
1013: hr_utility.trace(substr(l_l,30001,2000 ));
1014: --hr_utility.trace(' ');
1015: hr_utility.trace('END SPOOL DYN STATEMENT-PQH_GENERIC ');
1016: --
1017: --

Line 1014: --hr_utility.trace(' ');

1010: hr_utility.trace(substr(l_l,24001,2000 ));
1011: hr_utility.trace(substr(l_l,26001,2000 ));
1012: hr_utility.trace(substr(l_l,28001,2000 ));
1013: hr_utility.trace(substr(l_l,30001,2000 ));
1014: --hr_utility.trace(' ');
1015: hr_utility.trace('END SPOOL DYN STATEMENT-PQH_GENERIC ');
1016: --
1017: --
1018: -- Build PL/SQL Statement

Line 1015: hr_utility.trace('END SPOOL DYN STATEMENT-PQH_GENERIC ');

1011: hr_utility.trace(substr(l_l,26001,2000 ));
1012: hr_utility.trace(substr(l_l,28001,2000 ));
1013: hr_utility.trace(substr(l_l,30001,2000 ));
1014: --hr_utility.trace(' ');
1015: hr_utility.trace('END SPOOL DYN STATEMENT-PQH_GENERIC ');
1016: --
1017: --
1018: -- Build PL/SQL Statement
1019: --

Line 1020: hr_utility.set_location(l_proc||' : Starting function calls ',5);

1016: --
1017: --
1018: -- Build PL/SQL Statement
1019: --
1020: hr_utility.set_location(l_proc||' : Starting function calls ',5);
1021: execute immediate l_l;
1022: /* 'declare '
1023:
1024: || l_attribute

Line 1033: || 'hr_utility.set_location(''Start dyn statement'',1); '

1029: || ' where '
1030: || l_where
1031: || '; '
1032: || 'begin '
1033: || 'hr_utility.set_location(''Start dyn statement'',1); '
1034: || l_set_session
1035: || 'hr_utility.set_location(''after session_date: eff dt= ''||l_effective_date ,1); '
1036: || 'hr_utility.set_location(''effective start Date''||l_effective_start_date ,1); '
1037: || 'for Rec in c_at loop '

Line 1035: || 'hr_utility.set_location(''after session_date: eff dt= ''||l_effective_date ,1); '

1031: || '; '
1032: || 'begin '
1033: || 'hr_utility.set_location(''Start dyn statement'',1); '
1034: || l_set_session
1035: || 'hr_utility.set_location(''after session_date: eff dt= ''||l_effective_date ,1); '
1036: || 'hr_utility.set_location(''effective start Date''||l_effective_start_date ,1); '
1037: || 'for Rec in c_at loop '
1038: || 'begin '
1039: || 'hr_utility.set_location(''inside loop'',1); '

Line 1036: || 'hr_utility.set_location(''effective start Date''||l_effective_start_date ,1); '

1032: || 'begin '
1033: || 'hr_utility.set_location(''Start dyn statement'',1); '
1034: || l_set_session
1035: || 'hr_utility.set_location(''after session_date: eff dt= ''||l_effective_date ,1); '
1036: || 'hr_utility.set_location(''effective start Date''||l_effective_start_date ,1); '
1037: || 'for Rec in c_at loop '
1038: || 'begin '
1039: || 'hr_utility.set_location(''inside loop'',1); '
1040: || l_string

Line 1039: || 'hr_utility.set_location(''inside loop'',1); '

1035: || 'hr_utility.set_location(''after session_date: eff dt= ''||l_effective_date ,1); '
1036: || 'hr_utility.set_location(''effective start Date''||l_effective_start_date ,1); '
1037: || 'for Rec in c_at loop '
1038: || 'begin '
1039: || 'hr_utility.set_location(''inside loop'',1); '
1040: || l_string
1041: || l_pre_copy_proc
1042: || '; '
1043: || l_copy_proc

Line 1056: hr_utility.set_location(nvl(substr(PQH_GENERIC.v_err,1 ,100),'Completed...'),5);

1052: || 'end; '
1053: || 'end loop; '
1054: || 'end; ' ;
1055: */
1056: hr_utility.set_location(nvl(substr(PQH_GENERIC.v_err,1 ,100),'Completed...'),5);
1057: hr_utility.set_location(nvl(substr(PQH_GENERIC.v_err,100,100),'************'),5);
1058:
1059: end process_copy;
1060:

Line 1057: hr_utility.set_location(nvl(substr(PQH_GENERIC.v_err,100,100),'************'),5);

1053: || 'end loop; '
1054: || 'end; ' ;
1055: */
1056: hr_utility.set_location(nvl(substr(PQH_GENERIC.v_err,1 ,100),'Completed...'),5);
1057: hr_utility.set_location(nvl(substr(PQH_GENERIC.v_err,100,100),'************'),5);
1058:
1059: end process_copy;
1060:
1061: procedure populate_table

Line 1071: hr_utility.set_location('Entering :'||g_package||'populate_table ',25);

1067: begin
1068: --
1069: -- to replace the where params.. a global plsql table is to be populated.
1070: --
1071: hr_utility.set_location('Entering :'||g_package||'populate_table ',25);
1072: pqh_refresh_data.g_refresh_tab.delete;
1073: --
1074: for i in nvl(PQH_GENERIC.g_source_pk_table.first,0)..nvl(PQH_GENERIC.g_source_pk_table.last,-1) loop
1075: --

Line 1109: hr_utility.set_location('Leaving :'||g_package||'populate_table ',25);

1105: pqh_refresh_data.g_refresh_tab(i).refresh_flag := 'N';
1106: pqh_refresh_data.g_refresh_tab(i).updt_flag := 'N';
1107: --
1108: end loop ; --for i in PQH_GENERIC.g_source_pk_table.first..PQH_GENERIC.g_source_pk_table.last loop
1109: hr_utility.set_location('Leaving :'||g_package||'populate_table ',25);
1110: end populate_table;
1111:
1112: procedure Raise_Error(p_copy_entity_result_id in number,
1113: p_msg_code in varchar2)

Line 1121: hr_utility.set_location(pqh_generic.v_err,10);

1117: -- update the status with error/warning message
1118: --
1119: rollback ;
1120: --
1121: hr_utility.set_location(pqh_generic.v_err,10);
1122: -- update pqh_copy_entity_results
1123: -- set status = substr(substr(p_msg_code,1,1)||replace(pqh_generic.v_err,'ORA'),1,30)
1124: -- ,number_of_copies = '0'
1125: -- where copy_entity_result_id = p_copy_entity_result_id;

Line 1134: hr_utility.set_location('**********************',10);

1130: fnd_file.new_line (fnd_file.log,1);
1131: fnd_file.put_line (fnd_file.log, pqh_generic.v_err);
1132: end if;
1133: pqh_generic.v_err := '';
1134: hr_utility.set_location('**********************',10);
1135: hr_utility.set_location(sqlerrm,10);
1136: hr_utility.set_location('.......Oops..Error !!!',10);
1137: hr_utility.set_location('**********************',10);
1138: --hr_utility.raise_error;

Line 1135: hr_utility.set_location(sqlerrm,10);

1131: fnd_file.put_line (fnd_file.log, pqh_generic.v_err);
1132: end if;
1133: pqh_generic.v_err := '';
1134: hr_utility.set_location('**********************',10);
1135: hr_utility.set_location(sqlerrm,10);
1136: hr_utility.set_location('.......Oops..Error !!!',10);
1137: hr_utility.set_location('**********************',10);
1138: --hr_utility.raise_error;
1139: end Raise_Error;

Line 1136: hr_utility.set_location('.......Oops..Error !!!',10);

1132: end if;
1133: pqh_generic.v_err := '';
1134: hr_utility.set_location('**********************',10);
1135: hr_utility.set_location(sqlerrm,10);
1136: hr_utility.set_location('.......Oops..Error !!!',10);
1137: hr_utility.set_location('**********************',10);
1138: --hr_utility.raise_error;
1139: end Raise_Error;
1140: --

Line 1137: hr_utility.set_location('**********************',10);

1133: pqh_generic.v_err := '';
1134: hr_utility.set_location('**********************',10);
1135: hr_utility.set_location(sqlerrm,10);
1136: hr_utility.set_location('.......Oops..Error !!!',10);
1137: hr_utility.set_location('**********************',10);
1138: --hr_utility.raise_error;
1139: end Raise_Error;
1140: --
1141: function assign_part( p_column_name in varchar2 ,

Line 1138: --hr_utility.raise_error;

1134: hr_utility.set_location('**********************',10);
1135: hr_utility.set_location(sqlerrm,10);
1136: hr_utility.set_location('.......Oops..Error !!!',10);
1137: hr_utility.set_location('**********************',10);
1138: --hr_utility.raise_error;
1139: end Raise_Error;
1140: --
1141: function assign_part( p_column_name in varchar2 ,
1142: p_attrib_type in varchar2 ) return varchar2 is

Line 1186: hr_utility.set_location('assign :'||' := '''||l_val||'''',100);

1182: l_val := PQH_GENERIC.g_target_pk_table(i).value ;
1183: return('L_'||p_column_name||' := '''||replace(l_val,'''','''''')||''';' );
1184: end if; --if l_type =
1185: --
1186: hr_utility.set_location('assign :'||' := '''||l_val||'''',100);
1187: end if;
1188: end loop;
1189: --
1190: -- If no match was found then return assign only where the attribute type is not PARAMETER

Line 1273: hr_utility.set_location('Entering : '||g_package||'assign_value '||p_source_flag,15);

1269: begin
1270: --
1271: -- This populated the source and target plsql table with details to be used at a later point and time
1272: --
1273: hr_utility.set_location('Entering : '||g_package||'assign_value '||p_source_flag,15);
1274: hr_utility.set_location(' : '||'column_name '||substr(p_column_name,1,60),15);
1275: hr_utility.set_location(' : '||'column_type '||substr(p_column_type,1,60),15);
1276: hr_utility.set_location(' : '||'value ' ||substr(p_value,1,60),15);
1277: hr_utility.set_location(' : '||'reset_flag ' ||substr(p_reset_flag,1,60),15);

Line 1274: hr_utility.set_location(' : '||'column_name '||substr(p_column_name,1,60),15);

1270: --
1271: -- This populated the source and target plsql table with details to be used at a later point and time
1272: --
1273: hr_utility.set_location('Entering : '||g_package||'assign_value '||p_source_flag,15);
1274: hr_utility.set_location(' : '||'column_name '||substr(p_column_name,1,60),15);
1275: hr_utility.set_location(' : '||'column_type '||substr(p_column_type,1,60),15);
1276: hr_utility.set_location(' : '||'value ' ||substr(p_value,1,60),15);
1277: hr_utility.set_location(' : '||'reset_flag ' ||substr(p_reset_flag,1,60),15);
1278: --

Line 1275: hr_utility.set_location(' : '||'column_type '||substr(p_column_type,1,60),15);

1271: -- This populated the source and target plsql table with details to be used at a later point and time
1272: --
1273: hr_utility.set_location('Entering : '||g_package||'assign_value '||p_source_flag,15);
1274: hr_utility.set_location(' : '||'column_name '||substr(p_column_name,1,60),15);
1275: hr_utility.set_location(' : '||'column_type '||substr(p_column_type,1,60),15);
1276: hr_utility.set_location(' : '||'value ' ||substr(p_value,1,60),15);
1277: hr_utility.set_location(' : '||'reset_flag ' ||substr(p_reset_flag,1,60),15);
1278: --
1279: if upper(p_source_flag) = 'Y' then

Line 1276: hr_utility.set_location(' : '||'value ' ||substr(p_value,1,60),15);

1272: --
1273: hr_utility.set_location('Entering : '||g_package||'assign_value '||p_source_flag,15);
1274: hr_utility.set_location(' : '||'column_name '||substr(p_column_name,1,60),15);
1275: hr_utility.set_location(' : '||'column_type '||substr(p_column_type,1,60),15);
1276: hr_utility.set_location(' : '||'value ' ||substr(p_value,1,60),15);
1277: hr_utility.set_location(' : '||'reset_flag ' ||substr(p_reset_flag,1,60),15);
1278: --
1279: if upper(p_source_flag) = 'Y' then
1280: --

Line 1277: hr_utility.set_location(' : '||'reset_flag ' ||substr(p_reset_flag,1,60),15);

1273: hr_utility.set_location('Entering : '||g_package||'assign_value '||p_source_flag,15);
1274: hr_utility.set_location(' : '||'column_name '||substr(p_column_name,1,60),15);
1275: hr_utility.set_location(' : '||'column_type '||substr(p_column_type,1,60),15);
1276: hr_utility.set_location(' : '||'value ' ||substr(p_value,1,60),15);
1277: hr_utility.set_location(' : '||'reset_flag ' ||substr(p_reset_flag,1,60),15);
1278: --
1279: if upper(p_source_flag) = 'Y' then
1280: --
1281: if p_reset_flag = 'Y' then

Line 1338: hr_utility.set_location('Leaving : '||g_package||'assign_value ',15);

1334: PQH_GENERIC.g_target_pk_table(l_count+1).value := p_value ;
1335: end if; --l_check
1336: end if; -- p_source_flag = 'Y'
1337: --
1338: hr_utility.set_location('Leaving : '||g_package||'assign_value ',15);
1339: end assign_value;
1340: --
1341: Procedure dynamic_pltab_populate (p_ddf_column_name in varchar2
1342: , p_copy_entity_result_id in number

Line 1352: hr_utility.set_location('Entering :'||g_package||'dynamic_pltab_pop '||p_source_flag,11);

1348: begin
1349: --
1350: -- Assigns values to the plsql table from identified ddf_column
1351: --
1352: hr_utility.set_location('Entering :'||g_package||'dynamic_pltab_pop '||p_source_flag,11);
1353: hr_utility.set_location(' : '||'ddf_column_name ='||p_ddf_column_name,15);
1354: hr_utility.set_location(' : '||'column_name ='||p_column_name,15);
1355: execute immediate 'declare '
1356: || 'cursor c1 is '

Line 1353: hr_utility.set_location(' : '||'ddf_column_name ='||p_ddf_column_name,15);

1349: --
1350: -- Assigns values to the plsql table from identified ddf_column
1351: --
1352: hr_utility.set_location('Entering :'||g_package||'dynamic_pltab_pop '||p_source_flag,11);
1353: hr_utility.set_location(' : '||'ddf_column_name ='||p_ddf_column_name,15);
1354: hr_utility.set_location(' : '||'column_name ='||p_column_name,15);
1355: execute immediate 'declare '
1356: || 'cursor c1 is '
1357: || 'select cer.'||p_ddf_column_name ||' value '

Line 1354: hr_utility.set_location(' : '||'column_name ='||p_column_name,15);

1350: -- Assigns values to the plsql table from identified ddf_column
1351: --
1352: hr_utility.set_location('Entering :'||g_package||'dynamic_pltab_pop '||p_source_flag,11);
1353: hr_utility.set_location(' : '||'ddf_column_name ='||p_ddf_column_name,15);
1354: hr_utility.set_location(' : '||'column_name ='||p_column_name,15);
1355: execute immediate 'declare '
1356: || 'cursor c1 is '
1357: || 'select cer.'||p_ddf_column_name ||' value '
1358: || 'from pqh_copy_entity_results cer '

Line 1371: hr_utility.set_location('Leaving :'||g_package||'dynamic_pltab_pop ',11);

1367: || ',p_source_flag => '''|| p_source_flag ||''' ); '
1368: || 'end loop; '
1369: || 'end; ';
1370:
1371: hr_utility.set_location('Leaving :'||g_package||'dynamic_pltab_pop ',11);
1372: end dynamic_pltab_populate;
1373:
1374:
1375: function get_alias(p_column_name in varchar2) return varchar2

Line 1471: hr_utility.trace('Result id :'||l_copy_entity_result_id);

1467: --
1468: -- This procedure needs to be completed with error logging mechanisms
1469: -- and status updates for TXN/SRC/TGT Records
1470: --
1471: hr_utility.trace('Result id :'||l_copy_entity_result_id);
1472: hr_utility.trace('Call mode :'||l_calling_mode);
1473: hr_utility.trace('Table id :'||p_table_route_id);
1474: hr_utility.trace('Err Key :'||p_err_key);
1475: hr_utility.trace('Err :'||substr(v_err,1,255));

Line 1472: hr_utility.trace('Call mode :'||l_calling_mode);

1468: -- This procedure needs to be completed with error logging mechanisms
1469: -- and status updates for TXN/SRC/TGT Records
1470: --
1471: hr_utility.trace('Result id :'||l_copy_entity_result_id);
1472: hr_utility.trace('Call mode :'||l_calling_mode);
1473: hr_utility.trace('Table id :'||p_table_route_id);
1474: hr_utility.trace('Err Key :'||p_err_key);
1475: hr_utility.trace('Err :'||substr(v_err,1,255));
1476: hr_utility.trace('Err :'||substr(v_err,255,255));

Line 1473: hr_utility.trace('Table id :'||p_table_route_id);

1469: -- and status updates for TXN/SRC/TGT Records
1470: --
1471: hr_utility.trace('Result id :'||l_copy_entity_result_id);
1472: hr_utility.trace('Call mode :'||l_calling_mode);
1473: hr_utility.trace('Table id :'||p_table_route_id);
1474: hr_utility.trace('Err Key :'||p_err_key);
1475: hr_utility.trace('Err :'||substr(v_err,1,255));
1476: hr_utility.trace('Err :'||substr(v_err,255,255));
1477: hr_utility.trace('Err :'||substr(v_err,510,255));

Line 1474: hr_utility.trace('Err Key :'||p_err_key);

1470: --
1471: hr_utility.trace('Result id :'||l_copy_entity_result_id);
1472: hr_utility.trace('Call mode :'||l_calling_mode);
1473: hr_utility.trace('Table id :'||p_table_route_id);
1474: hr_utility.trace('Err Key :'||p_err_key);
1475: hr_utility.trace('Err :'||substr(v_err,1,255));
1476: hr_utility.trace('Err :'||substr(v_err,255,255));
1477: hr_utility.trace('Err :'||substr(v_err,510,255));
1478: --

Line 1475: hr_utility.trace('Err :'||substr(v_err,1,255));

1471: hr_utility.trace('Result id :'||l_copy_entity_result_id);
1472: hr_utility.trace('Call mode :'||l_calling_mode);
1473: hr_utility.trace('Table id :'||p_table_route_id);
1474: hr_utility.trace('Err Key :'||p_err_key);
1475: hr_utility.trace('Err :'||substr(v_err,1,255));
1476: hr_utility.trace('Err :'||substr(v_err,255,255));
1477: hr_utility.trace('Err :'||substr(v_err,510,255));
1478: --
1479: if nvl(pqh_generic.g_level,1) = 2 then

Line 1476: hr_utility.trace('Err :'||substr(v_err,255,255));

1472: hr_utility.trace('Call mode :'||l_calling_mode);
1473: hr_utility.trace('Table id :'||p_table_route_id);
1474: hr_utility.trace('Err Key :'||p_err_key);
1475: hr_utility.trace('Err :'||substr(v_err,1,255));
1476: hr_utility.trace('Err :'||substr(v_err,255,255));
1477: hr_utility.trace('Err :'||substr(v_err,510,255));
1478: --
1479: if nvl(pqh_generic.g_level,1) = 2 then
1480: pqh_process_batch_log.set_context_level (p_txn_id => nvl(p_err_key, l_copy_entity_result_id),

Line 1477: hr_utility.trace('Err :'||substr(v_err,510,255));

1473: hr_utility.trace('Table id :'||p_table_route_id);
1474: hr_utility.trace('Err Key :'||p_err_key);
1475: hr_utility.trace('Err :'||substr(v_err,1,255));
1476: hr_utility.trace('Err :'||substr(v_err,255,255));
1477: hr_utility.trace('Err :'||substr(v_err,510,255));
1478: --
1479: if nvl(pqh_generic.g_level,1) = 2 then
1480: pqh_process_batch_log.set_context_level (p_txn_id => nvl(p_err_key, l_copy_entity_result_id),
1481: p_txn_table_route_id => p_table_route_id,