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

Line 38: hr_utility.trace('p_display_sequence'||p_display_sequence);

34: l_rec csr_row_id%ROWTYPE;
35: l_user_row_id number(15);
36:
37: BEGIN
38: hr_utility.trace('p_display_sequence'||p_display_sequence);
39: open csr_row_id;
40: fetch csr_row_id into l_rec;
41: if csr_row_id%NOTFOUND then
42: -- creation

Line 43: hr_utility.trace('Creating new record');

39: open csr_row_id;
40: fetch csr_row_id into l_rec;
41: if csr_row_id%NOTFOUND then
42: -- creation
43: hr_utility.trace('Creating new record');
44: select nvl(max(DISPLAY_SEQUENCE),0)+1 into p_display_sequence from pay_user_rows_f pur,
45: pay_user_tables put
46: where put.user_table_name=p_user_table_name
47: and pur.user_table_id=put.user_table_id;

Line 87: hr_utility.trace('Updating record');

83: and put.business_group_id is NULL;
84:
85: else
86: -- update
87: hr_utility.trace('Updating record');
88: p_display_sequence := l_rec.display_sequence;
89: if l_rec.effective_start_date = p_effective_date then
90: -- correction mode
91: hr_utility.trace('Correction mode');

Line 91: hr_utility.trace('Correction mode');

87: hr_utility.trace('Updating record');
88: p_display_sequence := l_rec.display_sequence;
89: if l_rec.effective_start_date = p_effective_date then
90: -- correction mode
91: hr_utility.trace('Correction mode');
92: update pay_user_rows_f pur
93: set pur.row_low_range_or_name=p_row_low_range_or_name
94: where pur.rowid=l_rec.row_id;
95:

Line 98: hr_utility.trace('Update mode');

94: where pur.rowid=l_rec.row_id;
95:
96: else
97: -- update mode
98: hr_utility.trace('Update mode');
99: l_user_row_id := l_rec.user_row_id;
100: --create new entry
101: insert into pay_user_rows_f(
102: USER_ROW_ID,

Line 143: hr_utility.trace('p_display_sequence'||p_display_sequence);

139:
140: end if;
141: end if;
142: close csr_row_id;
143: hr_utility.trace('p_display_sequence'||p_display_sequence);
144: END upload_row;
145: --
146:
147: PROCEDURE upload_value(

Line 184: hr_utility.trace('Uploading values');

180: between puci.effective_start_date and puci.effective_end_date;
181:
182: l_rec csr_instance_id%ROWTYPE;
183: BEGIN
184: hr_utility.trace('Uploading values');
185: open csr_instance_id;
186: fetch csr_instance_id into l_rec;
187: if csr_instance_id%NOTFOUND then
188: -- create new record

Line 189: hr_utility.trace('Creating new record');

185: open csr_instance_id;
186: fetch csr_instance_id into l_rec;
187: if csr_instance_id%NOTFOUND then
188: -- create new record
189: hr_utility.trace('Creating new record');
190: insert into pay_user_column_instances_f(
191: USER_COLUMN_INSTANCE_ID,
192: EFFECTIVE_START_DATE,
193: EFFECTIVE_END_DATE,

Line 238: hr_utility.trace('Updaing record');

234: between pur.effective_start_date and pur.effective_end_date;
235:
236: else
237: -- update already present record
238: hr_utility.trace('Updaing record');
239: if l_rec.effective_start_date = p_effective_date then
240: -- correction mode
241: hr_utility.trace('Correction mode');
242: update pay_user_column_instances_f puci

Line 241: hr_utility.trace('Correction mode');

237: -- update already present record
238: hr_utility.trace('Updaing record');
239: if l_rec.effective_start_date = p_effective_date then
240: -- correction mode
241: hr_utility.trace('Correction mode');
242: update pay_user_column_instances_f puci
243: set puci.value=p_value
244: where puci.rowid=l_rec.row_id;
245:

Line 249: hr_utility.trace('Update mode');

245:
246: else
247: -- update mode
248: -- entering new record
249: hr_utility.trace('Update mode');
250: insert into pay_user_column_instances_f(
251: USER_COLUMN_INSTANCE_ID,
252: EFFECTIVE_START_DATE,
253: EFFECTIVE_END_DATE,

Line 329: --hr_utility.trace_on(null,'Jhonny');

325: l_area_type varchar2(1) default null;
326: l_user_table_value varchar2(50) default null;
327:
328: BEGIN
329: --hr_utility.trace_on(null,'Jhonny');
330: hr_utility.trace(p_directory);
331: hr_utility.trace(p_filename);
332: hr_utility.trace(p_mode);
333: hr_utility.trace(p_effective_date);

Line 330: hr_utility.trace(p_directory);

326: l_user_table_value varchar2(50) default null;
327:
328: BEGIN
329: --hr_utility.trace_on(null,'Jhonny');
330: hr_utility.trace(p_directory);
331: hr_utility.trace(p_filename);
332: hr_utility.trace(p_mode);
333: hr_utility.trace(p_effective_date);
334: hr_utility.trace(p_business_group_id);

Line 331: hr_utility.trace(p_filename);

327:
328: BEGIN
329: --hr_utility.trace_on(null,'Jhonny');
330: hr_utility.trace(p_directory);
331: hr_utility.trace(p_filename);
332: hr_utility.trace(p_mode);
333: hr_utility.trace(p_effective_date);
334: hr_utility.trace(p_business_group_id);
335:

Line 332: hr_utility.trace(p_mode);

328: BEGIN
329: --hr_utility.trace_on(null,'Jhonny');
330: hr_utility.trace(p_directory);
331: hr_utility.trace(p_filename);
332: hr_utility.trace(p_mode);
333: hr_utility.trace(p_effective_date);
334: hr_utility.trace(p_business_group_id);
335:
336: if (p_mode = 'UPDATE') then

Line 333: hr_utility.trace(p_effective_date);

329: --hr_utility.trace_on(null,'Jhonny');
330: hr_utility.trace(p_directory);
331: hr_utility.trace(p_filename);
332: hr_utility.trace(p_mode);
333: hr_utility.trace(p_effective_date);
334: hr_utility.trace(p_business_group_id);
335:
336: if (p_mode = 'UPDATE') then
337: l_eff_date := to_date(p_effective_date,'RRRR-MM-DD HH24:MI:SS');

Line 334: hr_utility.trace(p_business_group_id);

330: hr_utility.trace(p_directory);
331: hr_utility.trace(p_filename);
332: hr_utility.trace(p_mode);
333: hr_utility.trace(p_effective_date);
334: hr_utility.trace(p_business_group_id);
335:
336: if (p_mode = 'UPDATE') then
337: l_eff_date := to_date(p_effective_date,'RRRR-MM-DD HH24:MI:SS');
338: end if;

Line 339: hr_utility.trace(p_effective_date);

335:
336: if (p_mode = 'UPDATE') then
337: l_eff_date := to_date(p_effective_date,'RRRR-MM-DD HH24:MI:SS');
338: end if;
339: hr_utility.trace(p_effective_date);
340:
341: begin
342: l_file_handler := UTL_FILE.FOPEN(p_directory,p_filename,'R');
343: exception when others then

Line 344: hr_utility.trace('Unable to open file, check the directory or file provided');

340:
341: begin
342: l_file_handler := UTL_FILE.FOPEN(p_directory,p_filename,'R');
343: exception when others then
344: hr_utility.trace('Unable to open file, check the directory or file provided');
345: RAISE;
346: end;
347:
348: LOOP

Line 367: -- else hr_utility.trace('Skipping since this is position : '||delim_count);

363: WHEN 5 THEN l_sirsup := substr(l_user_table_value,1,length(l_user_table_value)-4);
364: WHEN 6 THEN l_unit_type := l_user_table_value;
365: WHEN 7 THEN l_level := l_user_table_value;
366: WHEN 8 THEN l_area_type := substr(l_user_table_value,2,length(l_user_table_value)-2);
367: -- else hr_utility.trace('Skipping since this is position : '||delim_count);
368: END CASE;
369: l_start_postn := l_delim_postn+1;
370: l_delim_count := l_delim_count +1;
371: exit when l_delim_count = 9;

Line 373: hr_utility.trace('siruta : ' ||l_siruta);

369: l_start_postn := l_delim_postn+1;
370: l_delim_count := l_delim_count +1;
371: exit when l_delim_count = 9;
372: end loop;
373: hr_utility.trace('siruta : ' ||l_siruta);
374: hr_utility.trace('locality : ' ||l_locality);
375: hr_utility.trace('postal_code : ' ||l_postal_code);
376: hr_utility.trace('county_code : ' ||l_county_code);
377: hr_utility.trace('sirsup : ' ||l_sirsup);

Line 374: hr_utility.trace('locality : ' ||l_locality);

370: l_delim_count := l_delim_count +1;
371: exit when l_delim_count = 9;
372: end loop;
373: hr_utility.trace('siruta : ' ||l_siruta);
374: hr_utility.trace('locality : ' ||l_locality);
375: hr_utility.trace('postal_code : ' ||l_postal_code);
376: hr_utility.trace('county_code : ' ||l_county_code);
377: hr_utility.trace('sirsup : ' ||l_sirsup);
378: hr_utility.trace('unit_type : ' ||l_unit_type);

Line 375: hr_utility.trace('postal_code : ' ||l_postal_code);

371: exit when l_delim_count = 9;
372: end loop;
373: hr_utility.trace('siruta : ' ||l_siruta);
374: hr_utility.trace('locality : ' ||l_locality);
375: hr_utility.trace('postal_code : ' ||l_postal_code);
376: hr_utility.trace('county_code : ' ||l_county_code);
377: hr_utility.trace('sirsup : ' ||l_sirsup);
378: hr_utility.trace('unit_type : ' ||l_unit_type);
379: hr_utility.trace('level_niv : ' ||l_level);

Line 376: hr_utility.trace('county_code : ' ||l_county_code);

372: end loop;
373: hr_utility.trace('siruta : ' ||l_siruta);
374: hr_utility.trace('locality : ' ||l_locality);
375: hr_utility.trace('postal_code : ' ||l_postal_code);
376: hr_utility.trace('county_code : ' ||l_county_code);
377: hr_utility.trace('sirsup : ' ||l_sirsup);
378: hr_utility.trace('unit_type : ' ||l_unit_type);
379: hr_utility.trace('level_niv : ' ||l_level);
380: hr_utility.trace('area_type : ' ||l_area_type);

Line 377: hr_utility.trace('sirsup : ' ||l_sirsup);

373: hr_utility.trace('siruta : ' ||l_siruta);
374: hr_utility.trace('locality : ' ||l_locality);
375: hr_utility.trace('postal_code : ' ||l_postal_code);
376: hr_utility.trace('county_code : ' ||l_county_code);
377: hr_utility.trace('sirsup : ' ||l_sirsup);
378: hr_utility.trace('unit_type : ' ||l_unit_type);
379: hr_utility.trace('level_niv : ' ||l_level);
380: hr_utility.trace('area_type : ' ||l_area_type);
381: -- create row

Line 378: hr_utility.trace('unit_type : ' ||l_unit_type);

374: hr_utility.trace('locality : ' ||l_locality);
375: hr_utility.trace('postal_code : ' ||l_postal_code);
376: hr_utility.trace('county_code : ' ||l_county_code);
377: hr_utility.trace('sirsup : ' ||l_sirsup);
378: hr_utility.trace('unit_type : ' ||l_unit_type);
379: hr_utility.trace('level_niv : ' ||l_level);
380: hr_utility.trace('area_type : ' ||l_area_type);
381: -- create row
382:

Line 379: hr_utility.trace('level_niv : ' ||l_level);

375: hr_utility.trace('postal_code : ' ||l_postal_code);
376: hr_utility.trace('county_code : ' ||l_county_code);
377: hr_utility.trace('sirsup : ' ||l_sirsup);
378: hr_utility.trace('unit_type : ' ||l_unit_type);
379: hr_utility.trace('level_niv : ' ||l_level);
380: hr_utility.trace('area_type : ' ||l_area_type);
381: -- create row
382:
383: upload_row(

Line 380: hr_utility.trace('area_type : ' ||l_area_type);

376: hr_utility.trace('county_code : ' ||l_county_code);
377: hr_utility.trace('sirsup : ' ||l_sirsup);
378: hr_utility.trace('unit_type : ' ||l_unit_type);
379: hr_utility.trace('level_niv : ' ||l_level);
380: hr_utility.trace('area_type : ' ||l_area_type);
381: -- create row
382:
383: upload_row(
384: P_USER_TABLE_NAME => 'RO_LOCALITY_DETAILS',

Line 390: hr_utility.trace('l_display_sequence : '||l_display_sequence);

386: P_ROW_LOW_RANGE_OR_NAME => l_siruta,
387: P_BUSINESS_GROUP_ID => p_business_group_id,
388: P_DISPLAY_SEQUENCE => l_display_sequence);
389:
390: hr_utility.trace('l_display_sequence : '||l_display_sequence);
391:
392: -- create column
393:
394: upload_value(

Line 457: hr_utility.trace('Closing file');

453: --UTL_FILE.FCLOSE(file_handler);
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: UTL_FILE.FCLOSE(l_file_handler);
457: hr_utility.trace('Closing file');
458: -- hr_utility.trace_off();
459:
460: END enter_user_table_values;
461:

Line 458: -- hr_utility.trace_off();

454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: UTL_FILE.FCLOSE(l_file_handler);
457: hr_utility.trace('Closing file');
458: -- hr_utility.trace_off();
459:
460: END enter_user_table_values;
461:
462:

Line 514: hr_utility.set_location ('insert row', 30);

510: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
511: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
512: );
513:
514: hr_utility.set_location ('insert row', 30);
515:
516: end lookup_insert_row;
517:
518: -- Procedure to update a row in fnd_lookup_values table

Line 566: hr_utility.set_location ('update row', 30);

562: X_LAST_UPDATE_DATE => p_effective_date,
563: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
564: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
565:
566: hr_utility.set_location ('update row', 30);
567: end lookup_update_row;
568:
569: -- procedure to read from file for lookups
570: -- and insert/update

Line 595: --hr_utility.trace_on(null,'Jhonny');

591: l_user_table_value VARCHAR2(300) default null;
592:
593:
594: BEGIN
595: --hr_utility.trace_on(null,'Jhonny');
596: hr_utility.trace(p_directory);
597: hr_utility.trace(p_filename);
598: hr_utility.trace(p_effective_date);
599: hr_utility.trace(p_business_group_id);

Line 596: hr_utility.trace(p_directory);

592:
593:
594: BEGIN
595: --hr_utility.trace_on(null,'Jhonny');
596: hr_utility.trace(p_directory);
597: hr_utility.trace(p_filename);
598: hr_utility.trace(p_effective_date);
599: hr_utility.trace(p_business_group_id);
600:

Line 597: hr_utility.trace(p_filename);

593:
594: BEGIN
595: --hr_utility.trace_on(null,'Jhonny');
596: hr_utility.trace(p_directory);
597: hr_utility.trace(p_filename);
598: hr_utility.trace(p_effective_date);
599: hr_utility.trace(p_business_group_id);
600:
601: l_effective_date := to_date(p_effective_date,'RRRR-MM-DD HH24:MI:SS');

Line 598: hr_utility.trace(p_effective_date);

594: BEGIN
595: --hr_utility.trace_on(null,'Jhonny');
596: hr_utility.trace(p_directory);
597: hr_utility.trace(p_filename);
598: hr_utility.trace(p_effective_date);
599: hr_utility.trace(p_business_group_id);
600:
601: l_effective_date := to_date(p_effective_date,'RRRR-MM-DD HH24:MI:SS');
602: hr_utility.trace(l_effective_date);

Line 599: hr_utility.trace(p_business_group_id);

595: --hr_utility.trace_on(null,'Jhonny');
596: hr_utility.trace(p_directory);
597: hr_utility.trace(p_filename);
598: hr_utility.trace(p_effective_date);
599: hr_utility.trace(p_business_group_id);
600:
601: l_effective_date := to_date(p_effective_date,'RRRR-MM-DD HH24:MI:SS');
602: hr_utility.trace(l_effective_date);
603:

Line 602: hr_utility.trace(l_effective_date);

598: hr_utility.trace(p_effective_date);
599: hr_utility.trace(p_business_group_id);
600:
601: l_effective_date := to_date(p_effective_date,'RRRR-MM-DD HH24:MI:SS');
602: hr_utility.trace(l_effective_date);
603:
604: BEGIN
605: select security_group_id
606: into l_security_group_id

Line 614: hr_utility.trace(l_security_group_id);

610: when others then
611: l_security_group_id := 0;
612: END;
613:
614: hr_utility.trace(l_security_group_id);
615:
616: BEGIN
617: l_file_handler := UTL_FILE.FOPEN(p_directory,p_filename,'R');
618: exception when others then

Line 619: hr_utility.trace('Unable to open file, check the directory or file provided');

615:
616: BEGIN
617: l_file_handler := UTL_FILE.FOPEN(p_directory,p_filename,'R');
618: exception when others then
619: hr_utility.trace('Unable to open file, check the directory or file provided');
620: RAISE;
621: END;
622:
623: LOOP

Line 652: hr_utility.trace('l_lookup_code : ' ||l_lookup_code);

648: exit when l_delim_count = 3;
649:
650: END LOOP;
651:
652: hr_utility.trace('l_lookup_code : ' ||l_lookup_code);
653: hr_utility.trace('l_description : ' ||l_description);
654:
655: if l_lookup_code is not null and l_description is not null then
656: if length(l_lookup_code) > 30 then

Line 653: hr_utility.trace('l_description : ' ||l_description);

649:
650: END LOOP;
651:
652: hr_utility.trace('l_lookup_code : ' ||l_lookup_code);
653: hr_utility.trace('l_description : ' ||l_description);
654:
655: if l_lookup_code is not null and l_description is not null then
656: if length(l_lookup_code) > 30 then
657: hr_utility.trace('Length of'||l_lookup_code||'is greater than column size.Please check and handle accordingly.');

Line 657: hr_utility.trace('Length of'||l_lookup_code||'is greater than column size.Please check and handle accordingly.');

653: hr_utility.trace('l_description : ' ||l_description);
654:
655: if l_lookup_code is not null and l_description is not null then
656: if length(l_lookup_code) > 30 then
657: hr_utility.trace('Length of'||l_lookup_code||'is greater than column size.Please check and handle accordingly.');
658: else
659: if length(l_description) > 240 then
660: hr_utility.trace('Length of'||l_description||'is greater than column size.Please check and handle accordingly.');
661: l_description := substr(l_description,0,240);

Line 660: hr_utility.trace('Length of'||l_description||'is greater than column size.Please check and handle accordingly.');

656: if length(l_lookup_code) > 30 then
657: hr_utility.trace('Length of'||l_lookup_code||'is greater than column size.Please check and handle accordingly.');
658: else
659: if length(l_description) > 240 then
660: hr_utility.trace('Length of'||l_description||'is greater than column size.Please check and handle accordingly.');
661: l_description := substr(l_description,0,240);
662: end if;
663:
664: hr_utility.trace('l_lookup_code : ' ||l_lookup_code);

Line 664: hr_utility.trace('l_lookup_code : ' ||l_lookup_code);

660: hr_utility.trace('Length of'||l_description||'is greater than column size.Please check and handle accordingly.');
661: l_description := substr(l_description,0,240);
662: end if;
663:
664: hr_utility.trace('l_lookup_code : ' ||l_lookup_code);
665: hr_utility.trace('l_description : ' ||l_description);
666:
667: BEGIN
668: select 'Y'

Line 665: hr_utility.trace('l_description : ' ||l_description);

661: l_description := substr(l_description,0,240);
662: end if;
663:
664: hr_utility.trace('l_lookup_code : ' ||l_lookup_code);
665: hr_utility.trace('l_description : ' ||l_description);
666:
667: BEGIN
668: select 'Y'
669: into l_update_flag

Line 688: hr_utility.trace('Entry not made because Lookup Code or Description is null. Please check file');

684: end if;
685:
686: end if;
687: else
688: hr_utility.trace('Entry not made because Lookup Code or Description is null. Please check file');
689: end if;
690: END LOOP;
691: EXCEPTION
692: WHEN NO_DATA_FOUND THEN

Line 694: hr_utility.trace('Closing file');

690: END LOOP;
691: EXCEPTION
692: WHEN NO_DATA_FOUND THEN
693: UTL_FILE.FCLOSE(l_file_handler);
694: hr_utility.trace('Closing file');
695: -- hr_utility.trace_off();
696: END enter_lookup_values;
697:
698: -- procedure to populate the fnd_lookup_values with Locality and County

Line 695: -- hr_utility.trace_off();

691: EXCEPTION
692: WHEN NO_DATA_FOUND THEN
693: UTL_FILE.FCLOSE(l_file_handler);
694: hr_utility.trace('Closing file');
695: -- hr_utility.trace_off();
696: END enter_lookup_values;
697:
698: -- procedure to populate the fnd_lookup_values with Locality and County
699:

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

763: and purf3.business_group_id = p_business_group_id));
764:
765: begin
766: l_proc:= 'populate_locality_county_lov';
767: hr_utility.set_location('Entering : '||l_proc,5);
768:
769: BEGIN
770: select security_group_id
771: into l_security_group_id

Line 809: hr_utility.set_location('Either Table or column does not exist',10);

805: AND put.user_table_id = puc.user_table_id
806: AND puc.user_column_name = 'POSTAL CODE';
807:
808: exception when others then
809: hr_utility.set_location('Either Table or column does not exist',10);
810: RAISE;
811: end;
812:
813: -- block to select the maximum lookup code

Line 818: hr_utility.set_location('l_code_postfix '||l_code_postfix,12);

814: begin
815: select NVL(MAX(TO_NUMBER(SUBSTR(LOOKUP_CODE,4))),0) into l_code_postfix
816: FROM fnd_lookup_values
817: WHERE LOOKUP_TYPE = 'PER_RO_LOCALITY';
818: hr_utility.set_location('l_code_postfix '||l_code_postfix,12);
819: Exception
820: when NO_DATA_FOUND then
821: l_code_postfix := 0;
822: END;

Line 849: hr_utility.set_location(l_locality(i)||' - '|| l_postalcode(i)||' - '||l_county(i) ||' Locality,Postal Code and County combination already exist' ,i);

845: when NO_DATA_FOUND then
846: null;
847: END;
848: if l_exist_flag='Y' then
849: hr_utility.set_location(l_locality(i)||' - '|| l_postalcode(i)||' - '||l_county(i) ||' Locality,Postal Code and County combination already exist' ,i);
850: else
851: l_code_postfix := l_code_postfix + 1;
852: l_code := 'LOC' ||lpad(to_char(l_code_postfix),6,'0');
853: hr_utility.set_location(l_code||','|| l_meaning||','||l_description,i);

Line 853: hr_utility.set_location(l_code||','|| l_meaning||','||l_description,i);

849: hr_utility.set_location(l_locality(i)||' - '|| l_postalcode(i)||' - '||l_county(i) ||' Locality,Postal Code and County combination already exist' ,i);
850: else
851: l_code_postfix := l_code_postfix + 1;
852: l_code := 'LOC' ||lpad(to_char(l_code_postfix),6,'0');
853: hr_utility.set_location(l_code||','|| l_meaning||','||l_description,i);
854: lookup_insert_row(l_code,l_meaning,l_description,l_security_group_id,l_eff_date,'PER_RO_LOCALITY');
855: end if;
856: end loop;
857: hr_utility.set_location('Leaving : '||l_proc,20);

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

853: hr_utility.set_location(l_code||','|| l_meaning||','||l_description,i);
854: lookup_insert_row(l_code,l_meaning,l_description,l_security_group_id,l_eff_date,'PER_RO_LOCALITY');
855: end if;
856: end loop;
857: hr_utility.set_location('Leaving : '||l_proc,20);
858: exception when others then
859: hr_utility.set_location(l_proc||','||sqlcode||','||sqlerrm,15);
860: RAISE;
861: end populate_locality_county_lov;

Line 859: hr_utility.set_location(l_proc||','||sqlcode||','||sqlerrm,15);

855: end if;
856: end loop;
857: hr_utility.set_location('Leaving : '||l_proc,20);
858: exception when others then
859: hr_utility.set_location(l_proc||','||sqlcode||','||sqlerrm,15);
860: RAISE;
861: end populate_locality_county_lov;
862:
863: -- procedure to get parameters from concurrent program

Line 884: --hr_utility.trace_on(null,'Jhonny');

880: )
881: IS
882:
883: BEGIN
884: --hr_utility.trace_on(null,'Jhonny');
885: hr_utility.trace(p_type);
886: hr_utility.trace(p_directory);
887: hr_utility.trace(p_filename);
888: hr_utility.trace(p_mode);

Line 885: hr_utility.trace(p_type);

881: IS
882:
883: BEGIN
884: --hr_utility.trace_on(null,'Jhonny');
885: hr_utility.trace(p_type);
886: hr_utility.trace(p_directory);
887: hr_utility.trace(p_filename);
888: hr_utility.trace(p_mode);
889: hr_utility.trace(p_effective_date);

Line 886: hr_utility.trace(p_directory);

882:
883: BEGIN
884: --hr_utility.trace_on(null,'Jhonny');
885: hr_utility.trace(p_type);
886: hr_utility.trace(p_directory);
887: hr_utility.trace(p_filename);
888: hr_utility.trace(p_mode);
889: hr_utility.trace(p_effective_date);
890: hr_utility.trace(p_business_group_id);

Line 887: hr_utility.trace(p_filename);

883: BEGIN
884: --hr_utility.trace_on(null,'Jhonny');
885: hr_utility.trace(p_type);
886: hr_utility.trace(p_directory);
887: hr_utility.trace(p_filename);
888: hr_utility.trace(p_mode);
889: hr_utility.trace(p_effective_date);
890: hr_utility.trace(p_business_group_id);
891:

Line 888: hr_utility.trace(p_mode);

884: --hr_utility.trace_on(null,'Jhonny');
885: hr_utility.trace(p_type);
886: hr_utility.trace(p_directory);
887: hr_utility.trace(p_filename);
888: hr_utility.trace(p_mode);
889: hr_utility.trace(p_effective_date);
890: hr_utility.trace(p_business_group_id);
891:
892: if p_type = 'SIRUTA' then

Line 889: hr_utility.trace(p_effective_date);

885: hr_utility.trace(p_type);
886: hr_utility.trace(p_directory);
887: hr_utility.trace(p_filename);
888: hr_utility.trace(p_mode);
889: hr_utility.trace(p_effective_date);
890: hr_utility.trace(p_business_group_id);
891:
892: if p_type = 'SIRUTA' then
893: enter_user_table_values(

Line 890: hr_utility.trace(p_business_group_id);

886: hr_utility.trace(p_directory);
887: hr_utility.trace(p_filename);
888: hr_utility.trace(p_mode);
889: hr_utility.trace(p_effective_date);
890: hr_utility.trace(p_business_group_id);
891:
892: if p_type = 'SIRUTA' then
893: enter_user_table_values(
894: p_directory => p_directory,

Line 909: --hr_utility.trace_off();

905: p_effective_date => p_effective_date,
906: p_business_group_id => p_business_group_id
907: );
908: end if;
909: --hr_utility.trace_off();
910:
911: END get_cp_parameters;
912:
913: end per_upload_user_table ;