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_CAGR_UTILITY_PKG dependencies on HR_UTILITY

Line 38: hr_utility.set_location('Entering '||l_proc||'/'||p_uom,10);

34: l_data_type per_cagr_entitlement_items.column_type%TYPE;
35: --
36: BEGIN
37: --
38: hr_utility.set_location('Entering '||l_proc||'/'||p_uom,10);
39: --
40: IF p_uom = 'C' THEN
41: --
42: hr_utility.set_location(l_proc,20);

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

38: hr_utility.set_location('Entering '||l_proc||'/'||p_uom,10);
39: --
40: IF p_uom = 'C' THEN
41: --
42: hr_utility.set_location(l_proc,20);
43: --
44: l_data_type := 'VAR';
45: --
46: ELSIF p_uom IN ('H_DECIMAL1','H_DECIMAL2','H_DECIMAL3'

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

45: --
46: ELSIF p_uom IN ('H_DECIMAL1','H_DECIMAL2','H_DECIMAL3'
47: ,'H_HH','I','M','N','ND') THEN
48: --
49: hr_utility.set_location(l_proc,30);
50: --
51: l_data_type := 'NUM';
52: --
53: ELSIF p_uom IN ('D','H_HHMM','H_HHMMSS','T') THEN

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

51: l_data_type := 'NUM';
52: --
53: ELSIF p_uom IN ('D','H_HHMM','H_HHMMSS','T') THEN
54: --
55: hr_utility.set_location(l_proc,40);
56: --
57: l_data_type := 'DATE';
58: --
59: ELSE

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

57: l_data_type := 'DATE';
58: --
59: ELSE
60: --
61: hr_utility.set_location(l_proc,50);
62: --
63: l_data_type := 'VAR';
64: --
65: END IF;

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

63: l_data_type := 'VAR';
64: --
65: END IF;
66: --
67: hr_utility.set_location('Leaving '||l_proc,999);
68: --
69: RETURN(l_data_type);
70: --
71: END convert_uom_to_data_type;

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

83: l_name VARCHAR2(2000);
84: --
85: BEGIN
86: --
87: hr_utility.set_location('Entering '||l_proc,10);
88: --
89: EXECUTE IMMEDIATE p_sql_statement INTO l_value_id, l_name;
90: --
91: hr_utility.set_location('Leaving '||l_proc,997);

Line 91: hr_utility.set_location('Leaving '||l_proc,997);

87: hr_utility.set_location('Entering '||l_proc,10);
88: --
89: EXECUTE IMMEDIATE p_sql_statement INTO l_value_id, l_name;
90: --
91: hr_utility.set_location('Leaving '||l_proc,997);
92: --
93: EXCEPTION
94: --
95: WHEN TOO_MANY_ROWS THEN

Line 97: hr_utility.set_location('Leaving '||l_proc,998);

93: EXCEPTION
94: --
95: WHEN TOO_MANY_ROWS THEN
96: --
97: hr_utility.set_location('Leaving '||l_proc,998);
98: --
99: WHEN NO_DATA_FOUND THEN
100: --
101: -- If no data was found then ignore this message

Line 107: hr_utility.set_location(l_proc||substr(sqlerrm,1,50),999);

103: NULL;
104: --
105: WHEN OTHERS THEN
106: --
107: hr_utility.set_location(l_proc||substr(sqlerrm,1,50),999);
108: hr_utility.set_message(800,'HR_289399_INVALID_VALUE_SET');
109: hr_utility.raise_error;
110: --
111: END;

Line 108: hr_utility.set_message(800,'HR_289399_INVALID_VALUE_SET');

104: --
105: WHEN OTHERS THEN
106: --
107: hr_utility.set_location(l_proc||substr(sqlerrm,1,50),999);
108: hr_utility.set_message(800,'HR_289399_INVALID_VALUE_SET');
109: hr_utility.raise_error;
110: --
111: END;
112: --

Line 109: hr_utility.raise_error;

105: WHEN OTHERS THEN
106: --
107: hr_utility.set_location(l_proc||substr(sqlerrm,1,50),999);
108: hr_utility.set_message(800,'HR_289399_INVALID_VALUE_SET');
109: hr_utility.raise_error;
110: --
111: END;
112: --
113: -- ----------------------------------------------------------------------------

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

138: l_name VARCHAR2(200);
139: --
140: BEGIN
141: --
142: hr_utility.set_location('Entering '||l_proc,10);
143: --
144: if p_eligy_prfl_id is not null then
145: open csr_elig;
146: fetch csr_elig into l_name;

Line 154: hr_utility.set_location('Leaving '||l_proc,50);

150: fetch csr_ff into l_name;
151: close csr_ff;
152: end if;
153: --
154: hr_utility.set_location('Leaving '||l_proc,50);
155: RETURN l_name;
156: --
157: END get_elig_source;
158:

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

179: AND p_effective_date BETWEEN p.effective_start_date
180: AND p.effective_end_date;
181: BEGIN
182: --
183: hr_utility.set_location('Entering '||l_proc,10);
184: --
185: OPEN csr_multiple_entries_allowed;
186: FETCH csr_multiple_entries_allowed INTO l_flag;
187: --

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

186: FETCH csr_multiple_entries_allowed INTO l_flag;
187: --
188: IF csr_multiple_entries_allowed%NOTFOUND THEN
189: --
190: hr_utility.set_location(l_proc,20);
191: --
192: CLOSE csr_multiple_entries_allowed;
193: --
194: l_return_value := FALSE;

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

194: l_return_value := FALSE;
195: --
196: ELSIF csr_multiple_entries_allowed%FOUND THEN
197: --
198: hr_utility.set_location(l_proc,30);
199: --
200: CLOSE csr_multiple_entries_allowed;
201: --
202: l_return_value := TRUE;

Line 206: hr_utility.set_location('Leaving '||l_proc,999);

202: l_return_value := TRUE;
203: --
204: END IF;
205: --
206: hr_utility.set_location('Leaving '||l_proc,999);
207: --
208: RETURN(l_return_value);
209: --
210: END multiple_entries_allowed;

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

247:
248: --
249: BEGIN
250: --
251: hr_utility.set_location('Entering:'|| l_proc, 10);
252:
253: --
254: If p_assignment_id is not null and p_effective_date is not null then
255: --

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

259: FETCH csr_requests INTO l_request_id;
260: CLOSE csr_requests;
261: End If;
262: --
263: hr_utility.set_location('Leaving :'|| l_proc, 20);
264: RETURN l_request_id;
265: --
266: END get_cagr_request_id;
267:

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

287: l_return VARCHAR2(20);
288: --
289: BEGIN
290: --
291: hr_utility.set_location('Entering:'|| l_proc, 10);
292: --
293: OPEN csr_nodes;
294: FETCH csr_nodes INTO l_name;
295: CLOSE csr_nodes;

Line 303: hr_utility.set_location('Leaving :'|| l_proc, 999);

299: elsif l_name = 'PERWSCAR_RETAINED' then
300: l_return := 'RETAINED';
301: end if;
302: --
303: hr_utility.set_location('Leaving :'|| l_proc, 999);
304: --
305: RETURN (l_return);
306: --
307: END set_mode_from_node_name;

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

326: l_plan_name ben_pl_f.name%TYPE;
327: --
328: BEGIN
329: --
330: hr_utility.set_location('Entering:'|| l_proc, 10);
331: --
332: OPEN csr_seq_number;
333: FETCH csr_seq_number INTO l_seq_number;
334: --

Line 339: hr_utility.set_location('Leaving :'|| l_proc, 999);

335: CLOSE csr_seq_number;
336: --
337: l_plan_name := 'CAGR_PLAN_'||l_seq_number;
338: --
339: hr_utility.set_location('Leaving :'|| l_proc, 999);
340: --
341: RETURN (l_plan_name);
342: --
343: END plan_name;

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

361: l_option_name ben_opt_f.name%TYPE;
362: --
363: BEGIN
364: --
365: hr_utility.set_location('Entering:'|| l_proc, 10);
366: --
367: OPEN csr_next_sequence;
368: FETCH csr_next_sequence INTO l_seq_number;
369: --

Line 374: hr_utility.set_location('Leaving :'|| l_proc, 999);

370: CLOSE csr_next_sequence;
371: --
372: l_option_name := 'CAGR_OPTION'||l_seq_number;
373: --
374: hr_utility.set_location('Leaving :'|| l_proc, 999);
375: --
376: RETURN(l_option_name);
377: --
378: END option_name;

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

396: l_order_number ben_oipl_f.ordr_num%TYPE;
397: --
398: BEGIN
399: --
400: hr_utility.set_location('Entering:'|| l_proc, 10);
401: --
402: OPEN csr_order_number;
403: FETCH csr_order_number INTO l_order_number;
404: --

Line 417: hr_utility.set_location('Leaving:'|| l_proc, 999);

413: l_order_number := 10;
414: --
415: END IF;
416: --
417: hr_utility.set_location('Leaving:'|| l_proc, 999);
418: --
419: RETURN(l_order_number);
420: --
421: EXCEPTION

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

472: WHERE pce.cagr_entitlement_item_id = p_cagr_entitlement_item_id;
473: --
474: BEGIN
475: --
476: hr_utility.set_location('Entering:'|| l_proc, 10);
477: --
478: OPEN csr_get_uom_details;
479: FETCH csr_get_uom_details INTO l_uom,l_column_type,l_uom_lookup;
480: CLOSE csr_get_uom_details;

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

480: CLOSE csr_get_uom_details;
481: --
482: IF l_uom IS NULL AND l_uom_lookup IS NULL THEN
483: --
484: hr_utility.set_location(l_proc, 20);
485: --
486: l_return_value := l_column_type;
487: --
488: ELSIF l_uom IS NOT NULL AND

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

488: ELSIF l_uom IS NOT NULL AND
489: (l_uom_lookup IS NULL OR
490: l_uom_lookup = 'UNITS') THEN
491: --
492: hr_utility.set_location(l_proc, 30);
493: --
494: l_return_value := l_uom;
495: --
496: ELSE

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

494: l_return_value := l_uom;
495: --
496: ELSE
497: --
498: hr_utility.set_location(l_proc, 40);
499: --
500: l_return_value := l_column_type;
501: --
502: END IF;

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

513: fnd_message.raise_error;
514: --
515: END IF;
516: --
517: hr_utility.set_location(l_proc, 20);
518: --
519: IF l_item_category = 'PAY' THEN
520: --
521: hr_utility.set_location(l_proc, 30);

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

517: hr_utility.set_location(l_proc, 20);
518: --
519: IF l_item_category = 'PAY' THEN
520: --
521: hr_utility.set_location(l_proc, 30);
522: --
523: OPEN c_pay_item_type;
524: FETCH c_pay_item_type INTO l_column_type;
525: CLOSE c_pay_item_type;

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

525: CLOSE c_pay_item_type;
526: --
527: ELSE
528: --
529: hr_utility.set_location(l_proc, 40);
530: --
531: OPEN c_item_type;
532: FETCH c_item_type INTO l_column_type;
533: --

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

532: FETCH c_item_type INTO l_column_type;
533: --
534: IF c_item_type%FOUND THEN
535: --
536: hr_utility.set_location(l_proc, 50);
537: --
538: CLOSE c_item_type;
539: --
540: ELSE

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

538: CLOSE c_item_type;
539: --
540: ELSE
541: --
542: hr_utility.set_location(l_proc, 60);
543: --
544: CLOSE c_item_type;
545: --
546: -- There has been an error in retrieving the

Line 557: hr_utility.set_location('Leaving:'|| l_proc, 99);

553: --
554: END IF;
555: --
556: */
557: hr_utility.set_location('Leaving:'|| l_proc, 99);
558: --
559: RETURN(l_return_value);
560: --
561: END get_column_type;

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

628: l_proc varchar2(90) := g_pkg||'get_name_from_value_set overload';
629: --
630: BEGIN
631: --
632: hr_utility.set_location('Entering:'|| l_proc, 10);
633: --
634: --
635: IF p_flex_value_set_id IS NOT NULL and p_business_group_id is NOT NULL and p_value IS NOT NULL THEN
636: --

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

633: --
634: --
635: IF p_flex_value_set_id IS NOT NULL and p_business_group_id is NOT NULL and p_value IS NOT NULL THEN
636: --
637: hr_utility.set_location(l_proc, 30);
638: --
639: l_sql_statement := get_sql_from_vset_id(p_vset_id => p_flex_value_set_id);
640: --
641: l_sql_statement := REPLACE(l_sql_statement

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

647: (INSTR(UPPER(l_sql_statement),'SELECT')+ 7));
648:
649: l_sql_statement := l_sql_statement||' and '||l_id_column||' = :id';
650: --
651: hr_utility.set_location(l_proc, 40);
652: --
653: BEGIN
654: --
655: EXECUTE IMMEDIATE l_sql_statement INTO l_value_id, l_name USING p_value;

Line 660: hr_utility.set_message(800,'HR_289399_INVALID_VALUE_SET');

656: --
657: EXCEPTION
658: --
659: WHEN OTHERS THEN
660: hr_utility.set_message(800,'HR_289399_INVALID_VALUE_SET');
661: hr_utility.raise_error;
662: --
663: END;
664: hr_utility.set_location(l_proc, 50);

Line 661: hr_utility.raise_error;

657: EXCEPTION
658: --
659: WHEN OTHERS THEN
660: hr_utility.set_message(800,'HR_289399_INVALID_VALUE_SET');
661: hr_utility.raise_error;
662: --
663: END;
664: hr_utility.set_location(l_proc, 50);
665: --

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

660: hr_utility.set_message(800,'HR_289399_INVALID_VALUE_SET');
661: hr_utility.raise_error;
662: --
663: END;
664: hr_utility.set_location(l_proc, 50);
665: --
666: END IF;
667: --
668: hr_utility.set_location('Leaving :'||l_proc, 60);

Line 668: hr_utility.set_location('Leaving :'||l_proc, 60);

664: hr_utility.set_location(l_proc, 50);
665: --
666: END IF;
667: --
668: hr_utility.set_location('Leaving :'||l_proc, 60);
669: --
670: RETURN(l_name);
671: --
672: END get_name_from_value_set;

Line 704: hr_utility.set_location('Entering:'||l_proc||'/'||

700: l_proc varchar2(72) := g_pkg||'get_name_from_value_set';
701: --
702: BEGIN
703: --
704: hr_utility.set_location('Entering:'||l_proc||'/'||
705: p_cagr_entitlement_id||'/'||
706: p_value, 10);
707: --
708: --

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

708: --
709: OPEN csr_entitlement_details;
710: FETCH csr_entitlement_details INTO l_flex_value_set_id, l_business_group_id;
711: --
712: hr_utility.set_location(l_proc, 20);
713: --
714: CLOSE csr_entitlement_details;
715: --
716: IF l_flex_value_set_id IS NOT NULL AND p_value IS NOT NULL THEN

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

714: CLOSE csr_entitlement_details;
715: --
716: IF l_flex_value_set_id IS NOT NULL AND p_value IS NOT NULL THEN
717: --
718: hr_utility.set_location(l_proc, 30);
719: --
720: l_sql_statement := get_sql_from_vset_id(p_vset_id => l_flex_value_set_id);
721: --
722: l_sql_statement := REPLACE(l_sql_statement

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

728: (INSTR(UPPER(l_sql_statement),'SELECT')+ 7));
729: --
730: l_sql_statement := l_sql_statement||' and '||l_id_column||' = :id';
731: --
732: hr_utility.set_location(l_proc, 40);
733: --
734: BEGIN
735: --
736: EXECUTE IMMEDIATE l_sql_statement INTO l_value_id, l_name USING p_value;

Line 741: hr_utility.set_location(l_proc||substr(sqlerrm,1,50),999);

737: --
738: EXCEPTION
739: --
740: WHEN OTHERS THEN
741: hr_utility.set_location(l_proc||substr(sqlerrm,1,50),999);
742: hr_utility.set_message(800,'HR_289399_INVALID_VALUE_SET');
743: hr_utility.raise_error;
744: --
745: END;

Line 742: hr_utility.set_message(800,'HR_289399_INVALID_VALUE_SET');

738: EXCEPTION
739: --
740: WHEN OTHERS THEN
741: hr_utility.set_location(l_proc||substr(sqlerrm,1,50),999);
742: hr_utility.set_message(800,'HR_289399_INVALID_VALUE_SET');
743: hr_utility.raise_error;
744: --
745: END;
746: --

Line 743: hr_utility.raise_error;

739: --
740: WHEN OTHERS THEN
741: hr_utility.set_location(l_proc||substr(sqlerrm,1,50),999);
742: hr_utility.set_message(800,'HR_289399_INVALID_VALUE_SET');
743: hr_utility.raise_error;
744: --
745: END;
746: --
747: hr_utility.set_location(l_proc, 50);

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

743: hr_utility.raise_error;
744: --
745: END;
746: --
747: hr_utility.set_location(l_proc, 50);
748: --
749: END IF;
750: --
751: hr_utility.set_location('Leaving :'||l_proc, 999);

Line 751: hr_utility.set_location('Leaving :'||l_proc, 999);

747: hr_utility.set_location(l_proc, 50);
748: --
749: END IF;
750: --
751: hr_utility.set_location('Leaving :'||l_proc, 999);
752: --
753: RETURN(l_name);
754: --
755: END get_name_from_value_set;

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

872: END write_log;
873:
874: BEGIN -- Write_Log_File
875:
876: hr_utility.set_location('Entering:'||l_proc, 10);
877:
878: -- always populate the cagr log table
879: if g_log_text_table.count > 0 then
880: write_log(p_cagr_request_id);

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

878: -- always populate the cagr log table
879: if g_log_text_table.count > 0 then
880: write_log(p_cagr_request_id);
881:
882: hr_utility.set_location(l_proc, 20);
883:
884: if fnd_global.conc_request_id <> -1 then
885: -- log is additionally written out via FND_FILE,
886: -- for visibility from view SRS window.

Line 898: hr_utility.set_location('Leaving:'||l_proc, 30);

894: -- remove log entries
895: g_log_text_table.delete;
896: g_log_priority_table.delete;
897: end if;
898: hr_utility.set_location('Leaving:'||l_proc, 30);
899:
900: END write_log_file;
901:
902: --

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

964: l_fileh utl_file.file_type;
965:
966: BEGIN
967: --
968: hr_utility.set_location('Entering:'||l_proc, 10);
969: --
970: open csr_filepath;
971: fetch csr_filepath into l_filepath;
972: if csr_filepath%notfound then

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

979: l_name := p_cagr_request_id||'.txt';
980:
981: begin
982:
983: hr_utility.set_location(l_proc, 10);
984: --
985: -- bug 2461389, raise error if filepath is not set
986: -- we have not been able to set a path, so raise an error
987: -- path is either full value or first string before a comma

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

992: --
993: -- check if the file alrteady exists, else
994: -- attempt to open a file for write
995: l_fileh := utl_file.fopen(l_filepath,l_name,'w');
996: hr_utility.set_location(l_proc, 20);
997:
998: -- get log entries restricted to certain levels
999: l_log_detail := fnd_profile.value('PER_CAGR_LOG_DETAIL');
1000: if nvl(l_log_detail,'H') = 'H' then

Line 1033: hr_utility.set_location('Leaving:'||l_proc, 40);

1029: -- pass back the concatenated path and file name
1030: p_filepath := l_filepath||'/'||l_name;
1031:
1032: --
1033: hr_utility.set_location('Leaving:'||l_proc, 40);
1034:
1035: --
1036: END create_formatted_log_file;
1037:

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

1057: l_proc constant varchar2(60) := g_pkg || '.remove_log_entries';
1058: l_dummy varchar2(1);
1059:
1060: BEGIN
1061: hr_utility.set_location('Entering:'||l_proc, 10);
1062:
1063: open csr_more_results;
1064: fetch csr_more_results into l_dummy;
1065: if csr_more_results%notfound then

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

1064: fetch csr_more_results into l_dummy;
1065: if csr_more_results%notfound then
1066: close csr_more_results;
1067: begin
1068: hr_utility.set_location(l_proc, 20);
1069:
1070: DELETE FROM per_cagr_log
1071: WHERE cagr_request_id = p_cagr_request_id;
1072:

Line 1085: hr_utility.set_location('Leaving:'||l_proc, 30);

1081: close csr_more_results;
1082: end if;
1083:
1084:
1085: hr_utility.set_location('Leaving:'||l_proc, 30);
1086:
1087: END remove_log_entries;
1088:
1089:

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

1183: l_grade_spine_id number;
1184:
1185: BEGIN
1186:
1187: hr_utility.set_location('Entering:' || l_proc,10);
1188: /*
1189: --
1190: -- Comment out for BUG3282957
1191: --

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

1192: open csr_get_current_gsp;
1193: fetch csr_get_current_gsp into l_grade,l_grade_ladder,l_step,l_salary
1194: ,l_currency_code,l_currency_name;
1195: if csr_get_current_gsp%NOTFOUND then
1196: hr_utility.set_location(l_proc,20);
1197: close csr_get_current_gsp;
1198: else
1199: hr_utility.set_location(l_proc,30);
1200: close csr_get_current_gsp;

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

1195: if csr_get_current_gsp%NOTFOUND then
1196: hr_utility.set_location(l_proc,20);
1197: close csr_get_current_gsp;
1198: else
1199: hr_utility.set_location(l_proc,30);
1200: close csr_get_current_gsp;
1201: p_grade_name := l_grade;
1202: p_grade_ladder_name := l_grade_ladder;
1203: p_step := l_step;

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

1211: open csr_get_current_asg;
1212: fetch csr_get_current_asg into l_grade_ladder,l_grade,l_step,l_salary
1213: ,l_spinal_point_id,l_grade_spine_id;
1214: if csr_get_current_asg%NOTFOUND then
1215: hr_utility.set_location(l_proc,20);
1216: close csr_get_current_asg;
1217: else
1218: hr_utility.set_location(l_proc,30);
1219: close csr_get_current_asg;

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

1214: if csr_get_current_asg%NOTFOUND then
1215: hr_utility.set_location(l_proc,20);
1216: close csr_get_current_asg;
1217: else
1218: hr_utility.set_location(l_proc,30);
1219: close csr_get_current_asg;
1220: p_grade_name := l_grade;
1221: p_grade_ladder_name := l_grade_ladder;
1222: p_salary := l_salary;

Line 1229: hr_utility.trace('step :' || l_step_name);

1225: p_sess,
1226: l_spinal_point_id,
1227: l_grade_spine_id);
1228:
1229: hr_utility.trace('step :' || l_step_name);
1230:
1231: p_step := l_step_name;
1232: end if;
1233:

Line 1234: hr_utility.trace('grade_name :' || p_grade_name);

1230:
1231: p_step := l_step_name;
1232: end if;
1233:
1234: hr_utility.trace('grade_name :' || p_grade_name);
1235: hr_utility.trace('grade_ladder_name :' || p_grade_ladder_name);
1236: hr_utility.trace('step :' || p_step);
1237: hr_utility.trace('salary :' || p_salary);
1238: hr_utility.trace('currency_code :' || l_currency_code);

Line 1235: hr_utility.trace('grade_ladder_name :' || p_grade_ladder_name);

1231: p_step := l_step_name;
1232: end if;
1233:
1234: hr_utility.trace('grade_name :' || p_grade_name);
1235: hr_utility.trace('grade_ladder_name :' || p_grade_ladder_name);
1236: hr_utility.trace('step :' || p_step);
1237: hr_utility.trace('salary :' || p_salary);
1238: hr_utility.trace('currency_code :' || l_currency_code);
1239: hr_utility.trace('currency_name :' || l_currency_name);

Line 1236: hr_utility.trace('step :' || p_step);

1232: end if;
1233:
1234: hr_utility.trace('grade_name :' || p_grade_name);
1235: hr_utility.trace('grade_ladder_name :' || p_grade_ladder_name);
1236: hr_utility.trace('step :' || p_step);
1237: hr_utility.trace('salary :' || p_salary);
1238: hr_utility.trace('currency_code :' || l_currency_code);
1239: hr_utility.trace('currency_name :' || l_currency_name);
1240:

Line 1237: hr_utility.trace('salary :' || p_salary);

1233:
1234: hr_utility.trace('grade_name :' || p_grade_name);
1235: hr_utility.trace('grade_ladder_name :' || p_grade_ladder_name);
1236: hr_utility.trace('step :' || p_step);
1237: hr_utility.trace('salary :' || p_salary);
1238: hr_utility.trace('currency_code :' || l_currency_code);
1239: hr_utility.trace('currency_name :' || l_currency_name);
1240:
1241: hr_utility.set_location(' Leaving:' || l_proc,40);

Line 1238: hr_utility.trace('currency_code :' || l_currency_code);

1234: hr_utility.trace('grade_name :' || p_grade_name);
1235: hr_utility.trace('grade_ladder_name :' || p_grade_ladder_name);
1236: hr_utility.trace('step :' || p_step);
1237: hr_utility.trace('salary :' || p_salary);
1238: hr_utility.trace('currency_code :' || l_currency_code);
1239: hr_utility.trace('currency_name :' || l_currency_name);
1240:
1241: hr_utility.set_location(' Leaving:' || l_proc,40);
1242: END populate_current_asg;

Line 1239: hr_utility.trace('currency_name :' || l_currency_name);

1235: hr_utility.trace('grade_ladder_name :' || p_grade_ladder_name);
1236: hr_utility.trace('step :' || p_step);
1237: hr_utility.trace('salary :' || p_salary);
1238: hr_utility.trace('currency_code :' || l_currency_code);
1239: hr_utility.trace('currency_name :' || l_currency_name);
1240:
1241: hr_utility.set_location(' Leaving:' || l_proc,40);
1242: END populate_current_asg;
1243:

Line 1241: hr_utility.set_location(' Leaving:' || l_proc,40);

1237: hr_utility.trace('salary :' || p_salary);
1238: hr_utility.trace('currency_code :' || l_currency_code);
1239: hr_utility.trace('currency_name :' || l_currency_name);
1240:
1241: hr_utility.set_location(' Leaving:' || l_proc,40);
1242: END populate_current_asg;
1243:
1244: END per_cagr_utility_pkg;