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

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

28: l_proc varchar2(72) := g_package||'delete_entire_qua';
29:
30: BEGIN
31:
32: hr_utility.set_location('Entering:'||l_proc, 5);
33: savepoint delete_entire_qua;
34:
35: --
36: -- delete all subjects

Line 40: hr_utility.set_location('Opening and Fetching subjects_for_qua :'||l_proc,10);

36: -- delete all subjects
37: --
38:
39: --Bug#3236273
40: hr_utility.set_location('Opening and Fetching subjects_for_qua :'||l_proc,10);
41: open subjects_for_qua(p_qualification_id => p_qualification_id);
42: fetch subjects_for_qua into l_cursor_record;
43: hr_utility.set_location('Entering while loop:'||l_proc,15);
44: WHILE subjects_for_qua%FOUND LOOP

Line 43: hr_utility.set_location('Entering while loop:'||l_proc,15);

39: --Bug#3236273
40: hr_utility.set_location('Opening and Fetching subjects_for_qua :'||l_proc,10);
41: open subjects_for_qua(p_qualification_id => p_qualification_id);
42: fetch subjects_for_qua into l_cursor_record;
43: hr_utility.set_location('Entering while loop:'||l_proc,15);
44: WHILE subjects_for_qua%FOUND LOOP
45:
46: --FOR i IN 1..NVL(p_qua_subjects.count,0) LOOP
47: IF l_cursor_record.subjects_taken_id IS NOT null THEN

Line 58: hr_utility.set_location('Exiting For Loop:'||l_proc,20);

54: ,p_object_version_number => l_cursor_record.object_version_number);
55: END IF;
56: fetch subjects_for_qua into l_cursor_record;
57: END LOOP;
58: hr_utility.set_location('Exiting For Loop:'||l_proc,20);
59: close subjects_for_qua;
60:
61: --
62: -- delete qualification

Line 75: hr_utility.set_location('p_attendance_id IS NOT null:'||l_proc,30);

71: -- delete attendance
72: --
73: BEGIN
74: IF p_attendance_id IS NOT null THEN
75: hr_utility.set_location('p_attendance_id IS NOT null:'||l_proc,30);
76: per_esa_del.del
77: (p_validate => p_validate
78: ,p_attendance_id => p_attendance_id
79: ,p_object_version_number => p_pea_object_version_number);

Line 84: hr_utility.set_location('Exception:Others'||l_proc,555);

80: END IF;
81:
82: EXCEPTION
83: WHEN OTHERS THEN
84: hr_utility.set_location('Exception:Others'||l_proc,555);
85: null;
86: END;
87:
88: IF p_validate = TRUE THEN

Line 89: hr_utility.set_location('p_validate = TRUE:'||l_proc,35);

85: null;
86: END;
87:
88: IF p_validate = TRUE THEN
89: hr_utility.set_location('p_validate = TRUE:'||l_proc,35);
90: rollback to delete_entire_qua;
91: END IF;
92:
93: hr_utility.set_location('Exiting:'||l_proc,25);

Line 93: hr_utility.set_location('Exiting:'||l_proc,25);

89: hr_utility.set_location('p_validate = TRUE:'||l_proc,35);
90: rollback to delete_entire_qua;
91: END IF;
92:
93: hr_utility.set_location('Exiting:'||l_proc,25);
94:
95: EXCEPTION
96: WHEN OTHERS THEN
97: hr_utility.set_location('Exception:Others'||l_proc,555);

Line 97: hr_utility.set_location('Exception:Others'||l_proc,555);

93: hr_utility.set_location('Exiting:'||l_proc,25);
94:
95: EXCEPTION
96: WHEN OTHERS THEN
97: hr_utility.set_location('Exception:Others'||l_proc,555);
98: rollback to delete_entire_qua;
99: raise;
100:
101: END delete_entire_qua;

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

123: -- get user date format
124: --
125: --get entire qualification data from transaction table
126: --
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: get_entire_qua
129: (p_transaction_step_id => p_transaction_step_id
130: ,p_mode => l_mode
131: ,p_qualifications => l_qualifications

Line 141: hr_utility.set_location('l_qualifications(1).delete_flag = Y:'||l_proc,10);

137: (p_transaction_step_id => p_transaction_step_id
138: ,p_name => 'P_SELECTED_PERSON_ID'));
139:
140: IF l_qualifications(1).delete_flag = 'Y' THEN
141: hr_utility.set_location('l_qualifications(1).delete_flag = Y:'||l_proc,10);
142: delete_entire_qua
143: (p_validate => p_validate
144: ,p_qualification_id => l_qualifications(1).qualification_id
145: ,p_pq_object_version_number =>

Line 152: hr_utility.set_location('l_qualifications(1).delete_flag != Y:'||l_proc,15);

148: ,p_pea_object_version_number =>
149: l_qua_attendance(1).object_version_number
150: ,p_qua_subjects => l_qua_subjects);
151: ELSE
152: hr_utility.set_location('l_qualifications(1).delete_flag != Y:'||l_proc,15);
153: validate_api
154: (p_validate => p_validate
155: ,p_mode => l_mode
156: ,p_selected_person_id => l_selected_person_id

Line 162: hr_utility.set_location('Exiting:'||l_proc, 20);

158: ,p_qua_subjects => l_qua_subjects
159: ,p_qua_attendance => l_qua_attendance);
160: END IF;
161:
162: hr_utility.set_location('Exiting:'||l_proc, 20);
163: end process_api;
164: -- ---------------------------------------------------------------------------
165: -- field_changed
166: -- ---------------------------------------------------------------------------

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

169: ,p_field2 in varchar2)
170: RETURN BOOLEAN IS
171: l_proc varchar2(72) := g_package||'field_changed';
172: BEGIN
173: hr_utility.set_location('Entering:'||l_proc, 5);
174: IF p_field1 IS null AND p_field2 IS null
175: OR
176: p_field1 IS NOT null AND p_field2 IS NOT null AND
177: p_field1 = p_field2 THEN

Line 178: hr_utility.set_location('Return FALSE:'||l_proc, 10);

174: IF p_field1 IS null AND p_field2 IS null
175: OR
176: p_field1 IS NOT null AND p_field2 IS NOT null AND
177: p_field1 = p_field2 THEN
178: hr_utility.set_location('Return FALSE:'||l_proc, 10);
179: RETURN FALSE;
180: ELSE
181: --fnd_message.set_name('PER',p_field1||'-'||p_field2);
182: --hr_utility.raise_error;

Line 182: --hr_utility.raise_error;

178: hr_utility.set_location('Return FALSE:'||l_proc, 10);
179: RETURN FALSE;
180: ELSE
181: --fnd_message.set_name('PER',p_field1||'-'||p_field2);
182: --hr_utility.raise_error;
183: hr_utility.set_location('Return TRUE:'||l_proc, 10);
184: RETURN TRUE;
185: END IF;
186:

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

179: RETURN FALSE;
180: ELSE
181: --fnd_message.set_name('PER',p_field1||'-'||p_field2);
182: --hr_utility.raise_error;
183: hr_utility.set_location('Return TRUE:'||l_proc, 10);
184: RETURN TRUE;
185: END IF;
186:
187: END field_changed;

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

231: BEGIN
232: --
233: --new qualification
234: --
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: IF p_qualifications(1).qualification_id IS null THEN
237: hr_utility.set_location('qualification_id =null, RETURN TRUE:'||l_proc,10);
238: RETURN TRUE;
239: END IF;

Line 237: hr_utility.set_location('qualification_id =null, RETURN TRUE:'||l_proc,10);

233: --new qualification
234: --
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: IF p_qualifications(1).qualification_id IS null THEN
237: hr_utility.set_location('qualification_id =null, RETURN TRUE:'||l_proc,10);
238: RETURN TRUE;
239: END IF;
240:
241: --

Line 252: hr_utility.set_location(' establishment change '||l_proc,10);

248: CLOSE csr_qualification;
249:
250: IF (v_qualification.attendance_id is null and p_qua_attendance(1).establishment_id is not null)
251: THEN
252: hr_utility.set_location(' establishment change '||l_proc,10);
253: RETURN TRUE;
254: END IF;
255:
256: --IF field_changed(v_qualification.party_id

Line 263: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,10);

259: --END IF;
260:
261: IF field_changed(v_qualification.title
262: ,p_qualifications(1).title) THEN
263: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,10);
264: RETURN TRUE;
265: END IF;
266:
267: IF field_changed(to_char(v_qualification.start_date,FORMAT_RRRR_MM_DD)

Line 269: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,15);

265: END IF;
266:
267: IF field_changed(to_char(v_qualification.start_date,FORMAT_RRRR_MM_DD)
268: ,to_char(p_qualifications(1).start_date,FORMAT_RRRR_MM_DD)) THEN
269: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,15);
270: RETURN TRUE;
271: END IF;
272:
273: IF field_changed(to_char(v_qualification.end_date,FORMAT_RRRR_MM_DD)

Line 275: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,20);

271: END IF;
272:
273: IF field_changed(to_char(v_qualification.end_date,FORMAT_RRRR_MM_DD)
274: ,to_char(p_qualifications(1).end_date,FORMAT_RRRR_MM_DD)) THEN
275: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,20);
276: RETURN TRUE;
277: END IF;
278:
279: IF field_changed(v_qualification.status

Line 281: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,25);

277: END IF;
278:
279: IF field_changed(v_qualification.status
280: ,p_qualifications(1).status) THEN
281: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,25);
282: RETURN TRUE;
283: END IF;
284:
285: IF field_changed(v_qualification.attendance_id

Line 287: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,30);

283: END IF;
284:
285: IF field_changed(v_qualification.attendance_id
286: ,p_qualifications(1).attendance_id) THEN
287: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,30);
288: RETURN TRUE;
289: END IF;
290:
291: IF p_qualifications(1).attendance_id is not null THEN

Line 296: hr_utility.set_location('csr_attendance%NOTFOUND, RETURN TRUE:'||l_proc,35);

292: OPEN csr_attendance(p_qualifications(1).attendance_id);
293: FETCH csr_attendance INTO v_attendance;
294: IF csr_attendance%NOTFOUND THEN
295: CLOSE csr_attendance;
296: hr_utility.set_location('csr_attendance%NOTFOUND, RETURN TRUE:'||l_proc,35);
297: RETURN TRUE;
298: END IF;
299: CLOSE csr_attendance;
300: END IF;

Line 307: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,40);

303: IF p_qualifications(1).attendance_id is not null THEN
304:
305: IF field_changed(v_attendance.establishment_id
306: ,p_qua_attendance(1).establishment_id) THEN
307: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,40);
308: RETURN TRUE;
309: END IF;
310: IF v_attendance.establishment_id IS NOT NULL THEN
311: OPEN csr_establishment(v_attendance.establishment_id);

Line 316: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,45);

312: FETCH csr_establishment INTO v_establishment;
313: CLOSE csr_establishment;
314: IF field_changed(v_establishment.name
315: ,p_qua_attendance(1).establishment) THEN
316: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,45);
317: RETURN TRUE;
318: END IF;
319: ELSE
320: IF field_changed(v_attendance.establishment

Line 322: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,50);

318: END IF;
319: ELSE
320: IF field_changed(v_attendance.establishment
321: ,p_qua_attendance(1).establishment) THEN
322: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,50);
323: RETURN TRUE;
324: END IF;
325: END IF;
326: IF field_changed(to_char(v_attendance.attended_start_date,

Line 330: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,55);

326: IF field_changed(to_char(v_attendance.attended_start_date,
327: FORMAT_RRRR_MM_DD)
328: ,to_char(p_qua_attendance(1).attended_start_date,
329: FORMAT_RRRR_MM_DD)) THEN
330: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,55);
331: RETURN TRUE;
332: END IF;
333: IF field_changed(to_char(v_attendance.attended_end_date,
334: FORMAT_RRRR_MM_DD)

Line 337: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,60);

333: IF field_changed(to_char(v_attendance.attended_end_date,
334: FORMAT_RRRR_MM_DD)
335: ,to_char(p_qua_attendance(1).attended_end_date,
336: FORMAT_RRRR_MM_DD)) THEN
337: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,60);
338: RETURN TRUE;
339: END IF;
340: IF field_changed(NVL(v_attendance.full_time,'N')
341: ,NVL(p_qua_attendance(1).full_time,'N')) THEN

Line 342: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,65);

338: RETURN TRUE;
339: END IF;
340: IF field_changed(NVL(v_attendance.full_time,'N')
341: ,NVL(p_qua_attendance(1).full_time,'N')) THEN
342: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,65);
343: RETURN TRUE;
344: END IF;
345: IF field_changed(v_attendance.attribute_category
346: ,p_qua_attendance(1).attribute_category) THEN

Line 347: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,70);

343: RETURN TRUE;
344: END IF;
345: IF field_changed(v_attendance.attribute_category
346: ,p_qua_attendance(1).attribute_category) THEN
347: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,70);
348: RETURN TRUE;
349: END IF;
350: IF field_changed(v_attendance.attribute1
351: ,p_qua_attendance(1).attribute1) THEN

Line 352: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,75);

348: RETURN TRUE;
349: END IF;
350: IF field_changed(v_attendance.attribute1
351: ,p_qua_attendance(1).attribute1) THEN
352: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,75);
353: RETURN TRUE;
354: END IF;
355: IF field_changed(v_attendance.attribute2
356: ,p_qua_attendance(1).attribute2) THEN

Line 357: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,85);

353: RETURN TRUE;
354: END IF;
355: IF field_changed(v_attendance.attribute2
356: ,p_qua_attendance(1).attribute2) THEN
357: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,85);
358: RETURN TRUE;
359: END IF;
360: IF field_changed(v_attendance.attribute3
361: ,p_qua_attendance(1).attribute3) THEN

Line 710: hr_utility.set_location('Entering For Loop:'||l_proc,100);

706:
707:
708: l_subject_count := p_qua_subjects.count;
709:
710: hr_utility.set_location('Entering For Loop:'||l_proc,100);
711: FOR i IN 1..l_subject_count LOOP
712: IF p_qua_subjects(i).subjects_taken_id IS null AND
713: p_qua_subjects(i).delete_flag = 'N' THEN
714: --a new subject is added

Line 927: hr_utility.set_location('Exiting For Loop:'||l_proc,105);

923: RETURN TRUE;
924: END IF;
925: END IF;
926: END LOOP;
927: hr_utility.set_location('Exiting For Loop:'||l_proc,105);
928: hr_utility.set_location('Exiting:'||l_proc, 110);
929:
930: RETURN FALSE;
931:

Line 928: hr_utility.set_location('Exiting:'||l_proc, 110);

924: END IF;
925: END IF;
926: END LOOP;
927: hr_utility.set_location('Exiting For Loop:'||l_proc,105);
928: hr_utility.set_location('Exiting:'||l_proc, 110);
929:
930: RETURN FALSE;
931:
932: END is_entire_qua_changed;

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

946: l_proc varchar2(72) := g_package||'delete_transaction_step';
947:
948: begin
949:
950: hr_utility.set_location('Entering:'||l_proc, 5);
951: l_transaction_id := hr_transaction_ss.get_transaction_id
952: (p_item_type => p_item_type
953: ,p_item_key => p_item_key);
954: if l_transaction_id is not null then

Line 955: hr_utility.set_location('l_transaction_id is not null:'||l_proc,10);

951: l_transaction_id := hr_transaction_ss.get_transaction_id
952: (p_item_type => p_item_type
953: ,p_item_key => p_item_key);
954: if l_transaction_id is not null then
955: hr_utility.set_location('l_transaction_id is not null:'||l_proc,10);
956: open c_get_transaction_step_id(l_transaction_id);
957: fetch c_get_transaction_step_id into l_transaction_step_id;
958: close c_get_transaction_step_id;
959: if l_transaction_step_id is not null then

Line 960: hr_utility.set_location('if l_transaction_step_id is not null:'||l_proc,15);

956: open c_get_transaction_step_id(l_transaction_id);
957: fetch c_get_transaction_step_id into l_transaction_step_id;
958: close c_get_transaction_step_id;
959: if l_transaction_step_id is not null then
960: hr_utility.set_location('if l_transaction_step_id is not null:'||l_proc,15);
961: hr_transaction_ss.delete_transaction_step
962: (l_transaction_step_id,null,p_creator_person_id);
963: end if;
964: end if;

Line 966: hr_utility.set_location('Exiting:'||l_proc, 20);

962: (l_transaction_step_id,null,p_creator_person_id);
963: end if;
964: end if;
965:
966: hr_utility.set_location('Exiting:'||l_proc, 20);
967: end delete_transaction_step;
968:
969:
970: -- start of function decode_value

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

974: p_false in varchar2)
975: return varchar2 is
976: l_proc varchar2(72) := g_package||'decode_value';
977: Begin
978: hr_utility.set_location('Entering:'||l_proc, 5);
979: if p_expression then
980: hr_utility.set_location('if p_expression= true:'||l_proc,10);
981: return p_true;
982: else

Line 980: hr_utility.set_location('if p_expression= true:'||l_proc,10);

976: l_proc varchar2(72) := g_package||'decode_value';
977: Begin
978: hr_utility.set_location('Entering:'||l_proc, 5);
979: if p_expression then
980: hr_utility.set_location('if p_expression= true:'||l_proc,10);
981: return p_true;
982: else
983: hr_utility.set_location('if p_expression=false:'||l_proc,15);
984: return p_false;

Line 983: hr_utility.set_location('if p_expression=false:'||l_proc,15);

979: if p_expression then
980: hr_utility.set_location('if p_expression= true:'||l_proc,10);
981: return p_true;
982: else
983: hr_utility.set_location('if p_expression=false:'||l_proc,15);
984: return p_false;
985: end if;
986: Exception
987: when others then

Line 988: hr_utility.set_location('Exception:Others'||l_proc,555);

984: return p_false;
985: end if;
986: Exception
987: when others then
988: hr_utility.set_location('Exception:Others'||l_proc,555);
989: rollback;
990: raise;
991: end decode_value;
992:

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

1012: l_proc varchar2(72) := g_package||'get_qualification_type';
1013:
1014: BEGIN
1015:
1016: hr_utility.set_location('Entering:'||l_proc, 5);
1017: OPEN csr_qua_type;
1018: FETCH csr_qua_type INTO l_name;
1019: CLOSE csr_qua_type;
1020:

Line 1021: hr_utility.set_location('Exiting:'||l_proc, 10);

1017: OPEN csr_qua_type;
1018: FETCH csr_qua_type INTO l_name;
1019: CLOSE csr_qua_type;
1020:
1021: hr_utility.set_location('Exiting:'||l_proc, 10);
1022: RETURN l_name;
1023:
1024: Exception
1025: when others then

Line 1026: hr_utility.set_location('Exception:Others'||l_proc,555);

1022: RETURN l_name;
1023:
1024: Exception
1025: when others then
1026: hr_utility.set_location('Exception:Others'||l_proc,555);
1027: rollback;
1028: raise;
1029: END get_qualification_type;
1030:

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

1061: l_proc varchar2(72) := g_package||'get_pending_transaction_ids';
1062:
1063: BEGIN
1064:
1065: hr_utility.set_location('Entering:'||l_proc, 5);
1066: hr_qua_awards_util_ss.get_pending_transaction_steps
1067: (p_item_type => p_item_type
1068: ,p_selected_person_id => p_selected_person_id
1069: ,p_mode => p_mode

Line 1080: hr_utility.set_location('Entering For Loop:'||l_proc,10);

1076: p_qualifications := SSHR_QUA_TAB_TYP();
1077: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();
1078: p_transaction_steps := SSHR_TRN_TAB_TYP();
1079:
1080: hr_utility.set_location('Entering For Loop:'||l_proc,10);
1081: FOR i IN 1..l_total_rec_count LOOP
1082: if l_transaction_step_id(i) is not null then
1083: --
1084: --get entire qualification data from transaction table

Line 1105: hr_utility.set_location('Exiting For Loop:'||l_proc,15);

1101:
1102: end if;
1103:
1104: END LOOP;
1105: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1106: hr_utility.set_location('Exiting:'||l_proc, 20);
1107: Exception
1108:
1109: when others then

Line 1106: hr_utility.set_location('Exiting:'||l_proc, 20);

1102: end if;
1103:
1104: END LOOP;
1105: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1106: hr_utility.set_location('Exiting:'||l_proc, 20);
1107: Exception
1108:
1109: when others then
1110: hr_utility.set_location('Exception:Others'||l_proc,555);

Line 1110: hr_utility.set_location('Exception:Others'||l_proc,555);

1106: hr_utility.set_location('Exiting:'||l_proc, 20);
1107: Exception
1108:
1109: when others then
1110: hr_utility.set_location('Exception:Others'||l_proc,555);
1111: rollback;
1112: raise;
1113: END get_pending_transaction_ids;
1114:

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

1140: l_proc varchar2(72) := g_package||'is_qualification_in_pending';
1141:
1142: Begin
1143:
1144: hr_utility.set_location('Entering:'||l_proc, 5);
1145: get_pending_transaction_steps
1146: (p_item_type => p_item_type
1147: ,p_selected_person_id => p_selected_person_id
1148: ,p_mode => p_mode

Line 1155: hr_utility.set_location('Entering For Loop:'||l_proc,10);

1151: ,p_transaction_step_id => l_transaction_step_id);
1152:
1153: l_pending_found := 'N';
1154:
1155: hr_utility.set_location('Entering For Loop:'||l_proc,10);
1156: FOR i IN 1..NVL(l_transaction_step_id.count,0) LOOP
1157: l_qualification_id :=
1158: hr_transaction_api.get_varchar2_value
1159: (p_transaction_step_id => l_transaction_step_id(i)

Line 1166: hr_utility.set_location('Exiting For Loop:'||l_proc,15);

1162: l_pending_found := 'Y';
1163: EXIT;
1164: END IF;
1165: END LOOP;
1166: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1167:
1168: hr_utility.set_location('Exiting:'||l_proc, 15);
1169: RETURN l_pending_found;
1170:

Line 1168: hr_utility.set_location('Exiting:'||l_proc, 15);

1164: END IF;
1165: END LOOP;
1166: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1167:
1168: hr_utility.set_location('Exiting:'||l_proc, 15);
1169: RETURN l_pending_found;
1170:
1171: Exception
1172: when others then

Line 1173: hr_utility.set_location('Exception:Others'||l_proc,555);

1169: RETURN l_pending_found;
1170:
1171: Exception
1172: when others then
1173: hr_utility.set_location('Exception:Others'||l_proc,555);
1174: raise;
1175: end is_qualification_in_pending;
1176:
1177: -- end of function is_qualification_in_pending

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

1208: -- start of begin for validate_qualification
1209:
1210: Begin
1211:
1212: hr_utility.set_location('Entering:'||l_proc, 5);
1213: if p_validate = 'Y' then
1214: hr_utility.set_location('p_validate = N:'||l_proc,10);
1215: l_validate := true;
1216: else

Line 1214: hr_utility.set_location('p_validate = N:'||l_proc,10);

1210: Begin
1211:
1212: hr_utility.set_location('Entering:'||l_proc, 5);
1213: if p_validate = 'Y' then
1214: hr_utility.set_location('p_validate = N:'||l_proc,10);
1215: l_validate := true;
1216: else
1217: l_validate := false;
1218: end if;

Line 1223: hr_utility.set_location('delete_flag = N:'||l_proc,15);

1219:
1220: --check if there are any changes
1221: if p_qualifications(1).delete_flag is null or
1222: p_qualifications(1).delete_flag = 'N' then
1223: hr_utility.set_location('delete_flag = N:'||l_proc,15);
1224: l_changed := is_entire_qua_changed
1225: (p_qualifications => p_qualifications
1226: ,p_qua_subjects => p_qua_subjects
1227: ,p_qua_attendance => p_qua_attendance);

Line 1229: hr_utility.set_location('l_changed = FALSE THEN:'||l_proc,25);

1225: (p_qualifications => p_qualifications
1226: ,p_qua_subjects => p_qua_subjects
1227: ,p_qua_attendance => p_qua_attendance);
1228: IF l_changed = FALSE THEN
1229: hr_utility.set_location('l_changed = FALSE THEN:'||l_proc,25);
1230: delete_transaction_step
1231: (p_item_type => p_item_type
1232: ,p_item_key => p_item_key
1233: ,p_creator_person_id => p_creator_person_id);

Line 1238: hr_utility.set_location('l_changed = TRUE THEN:'||l_proc,30);

1234: END IF;
1235: end if;
1236:
1237: if l_changed = TRUE THEN
1238: hr_utility.set_location('l_changed = TRUE THEN:'||l_proc,30);
1239: if (p_qualifications(1).delete_flag is null or
1240: p_qualifications(1).delete_flag = 'N')
1241: and p_save_mode <> 'SAVE_FOR_LATER'
1242: then

Line 1243: hr_utility.set_location('Delete flag = N and not SFL'||l_proc,35);

1239: if (p_qualifications(1).delete_flag is null or
1240: p_qualifications(1).delete_flag = 'N')
1241: and p_save_mode <> 'SAVE_FOR_LATER'
1242: then
1243: hr_utility.set_location('Delete flag = N and not SFL'||l_proc,35);
1244: hr_qua_awards_util_ss.check_errors
1245: (p_ignore_sub_date_boundaries => 'N'
1246: ,p_mode => p_mode
1247: ,p_qualifications => p_qualifications

Line 1255: hr_utility.set_location('Exception:l_app_exception'||l_proc,555);

1251: ,p_subjects_error_message => p_subjects_error_message);
1252:
1253: if nvl(length(p_error_message),0) > 0 or
1254: nvl(length(p_subjects_error_message),0) > 0 then
1255: hr_utility.set_location('Exception:l_app_exception'||l_proc,555);
1256: raise l_app_exception;
1257: end if;
1258: end if;
1259:

Line 1264: hr_utility.set_location('Delete flag = N and not SFL'||l_proc,40);

1260: --should not do validation if user wants to delete the current qualification.
1261: if (p_qualifications(1).delete_flag is null or
1262: p_qualifications(1).delete_flag = 'N') and
1263: p_save_mode <> 'SAVE_FOR_LATER' then
1264: hr_utility.set_location('Delete flag = N and not SFL'||l_proc,40);
1265: hr_qua_awards_util_ss.validate_api
1266: (p_validate => l_validate
1267: ,p_mode => p_mode
1268: ,p_selected_person_id => p_selected_person_id

Line 1278: hr_utility.set_location('Delete flag = Y or changed=True'||l_proc,40);

1274: end if; --l_changed
1275:
1276: if l_changed = TRUE or p_qualifications(1).delete_flag = 'Y' THEN
1277:
1278: hr_utility.set_location('Delete flag = Y or changed=True'||l_proc,40);
1279: hr_qua_awards_util_ss.save_transaction_step
1280: (p_item_type => p_item_type
1281: ,p_item_key => p_item_key
1282: ,p_actid => to_number(p_act_id)

Line 1295: hr_utility.set_location('Exception:l_app_exception'||l_proc,555);

1291: end if;
1292:
1293: Exception
1294: when l_app_exception then
1295: hr_utility.set_location('Exception:l_app_exception'||l_proc,555);
1296: rollback;
1297: -- Fix bug 2899882.
1298: -- should directly raise error. Otherwise the tokens in the messages are
1299: -- lost.

Line 1300: --when hr_utility.hr_error then

1296: rollback;
1297: -- Fix bug 2899882.
1298: -- should directly raise error. Otherwise the tokens in the messages are
1299: -- lost.
1300: --when hr_utility.hr_error then
1301: -- hr_message.provide_error;
1302: -- p_error_message := nvl(p_error_message,'')||'!'||'|'||'PAGE'||'|'||
1303: -- hr_message.last_message_app||'|'||hr_message.last_message_name||
1304: -- '|'||'!';

Line 1307: hr_utility.set_location('Exception:Others'||l_proc,555);

1303: -- hr_message.last_message_app||'|'||hr_message.last_message_name||
1304: -- '|'||'!';
1305: -- rollback;
1306: when others then
1307: hr_utility.set_location('Exception:Others'||l_proc,555);
1308: rollback;
1309: -- Bug Fix 3103716
1310: l_error_message := hr_utility.get_message;
1311: IF l_error_message is null THEN

Line 1310: l_error_message := hr_utility.get_message;

1306: when others then
1307: hr_utility.set_location('Exception:Others'||l_proc,555);
1308: rollback;
1309: -- Bug Fix 3103716
1310: l_error_message := hr_utility.get_message;
1311: IF l_error_message is null THEN
1312: raise;
1313: ELSE
1314: p_error_message := nvl(p_error_message,'')||'!'||'|'||'PAGE'||'|'||'PER'||'|'|| l_error_message ||'|_ValidateAPIError|'||'!';

Line 1316: hr_utility.set_location('Exiting:'||l_proc, 45);

1312: raise;
1313: ELSE
1314: p_error_message := nvl(p_error_message,'')||'!'||'|'||'PAGE'||'|'||'PER'||'|'|| l_error_message ||'|_ValidateAPIError|'||'!';
1315: END IF;
1316: hr_utility.set_location('Exiting:'||l_proc, 45);
1317: End; -- end of validate_qualification
1318:
1319: -- end of procedure validate_qualification
1320:

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

1341:
1342: BEGIN
1343:
1344:
1345: hr_utility.set_location('Entering:'||l_proc, 5);
1346: hr_qua_awards_util_ss.start_transaction
1347: (itemtype => p_item_type
1348: ,itemkey => p_item_key
1349: ,actid => p_actid

Line 1960: hr_utility.set_location('Entering For Loop:'||l_proc,10);

1956: ,p_person_id => p_creator_person_id
1957: ,p_name => 'P_SUBJECT_COUNT'
1958: ,p_value => l_subject_count);
1959:
1960: hr_utility.set_location('Entering For Loop:'||l_proc,10);
1961: FOR i IN 1..l_subject_count LOOP
1962:
1963: hr_transaction_api.set_varchar2_value
1964: (p_transaction_step_id => p_transaction_step_id

Line 2231: hr_utility.set_location('Exiting For Loop:'||l_proc,15);

2227: ,p_name => 'P_SUB_INFORMATION20_PST'||i
2228: ,p_value => p_qua_subjects(i).sub_information20);
2229:
2230: END LOOP;
2231: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
2232:
2233: hr_transaction_api.set_varchar2_value
2234: (p_transaction_step_id => p_transaction_step_id
2235: ,p_person_id => p_creator_person_id

Line 2245: hr_utility.set_location('Exiting:'||l_proc, 20);

2241: ,p_person_id => p_creator_person_id
2242: ,p_name => 'P_REVIEW_ACTID'
2243: ,p_value => p_actid);
2244:
2245: hr_utility.set_location('Exiting:'||l_proc, 20);
2246: Exception
2247: when others then
2248: hr_utility.set_location('Exception:Others'||l_proc,555);
2249: rollback;

Line 2248: hr_utility.set_location('Exception:Others'||l_proc,555);

2244:
2245: hr_utility.set_location('Exiting:'||l_proc, 20);
2246: Exception
2247: when others then
2248: hr_utility.set_location('Exception:Others'||l_proc,555);
2249: rollback;
2250: raise;
2251: END save_transaction_step;
2252:

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

2361: l_proc varchar2(72) := g_package||'validate_api';
2362:
2363: BEGIN
2364:
2365: hr_utility.set_location('Entering:'||l_proc, 5);
2366: savepoint validate_qua;
2367:
2368: l_old_attendance_id := p_qualifications(1).attendance_id;
2369:

Line 2375: hr_utility.set_location('p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN:'||l_proc,10);

2371:
2372: --check if attendance already exists
2373: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
2374:
2375: hr_utility.set_location('p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN:'||l_proc,10);
2376: l_establishment_id := p_qua_attendance(1).establishment_id;
2377:
2378: --if the school is entered (not picked from the LOV),
2379: if l_establishment_id is null then

Line 2380: hr_utility.set_location('l_establishment_id is null then:'||l_proc,20);

2376: l_establishment_id := p_qua_attendance(1).establishment_id;
2377:
2378: --if the school is entered (not picked from the LOV),
2379: if l_establishment_id is null then
2380: hr_utility.set_location('l_establishment_id is null then:'||l_proc,20);
2381: OPEN csr_get_establishment_id(p_qua_attendance(1).establishment);
2382: FETCH csr_get_establishment_id into l_school_name_id;
2383: IF csr_get_establishment_id%FOUND THEN
2384: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,25);

Line 2384: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,25);

2380: hr_utility.set_location('l_establishment_id is null then:'||l_proc,20);
2381: OPEN csr_get_establishment_id(p_qua_attendance(1).establishment);
2382: FETCH csr_get_establishment_id into l_school_name_id;
2383: IF csr_get_establishment_id%FOUND THEN
2384: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,25);
2385: l_establishment_id := l_school_name_id;
2386: FETCH csr_get_establishment_id into l_school_name_id;
2387: IF csr_get_establishment_id%FOUND THEN
2388: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,30);

Line 2388: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,30);

2384: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,25);
2385: l_establishment_id := l_school_name_id;
2386: FETCH csr_get_establishment_id into l_school_name_id;
2387: IF csr_get_establishment_id%FOUND THEN
2388: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,30);
2389: CLOSE csr_get_establishment_id;
2390: fnd_message.set_name('PER','HR_SCHOOL_NAME_NOT_UNIQUE');
2391: hr_utility.raise_error;
2392: END IF;

Line 2391: hr_utility.raise_error;

2387: IF csr_get_establishment_id%FOUND THEN
2388: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,30);
2389: CLOSE csr_get_establishment_id;
2390: fnd_message.set_name('PER','HR_SCHOOL_NAME_NOT_UNIQUE');
2391: hr_utility.raise_error;
2392: END IF;
2393: ELSE
2394: l_new_school_allowed := fnd_profile.value('HR_SSHR_NEW_SCHOOL');
2395: if l_new_school_allowed = 'N' THEN

Line 2396: hr_utility.set_location('l_new_school_allowed=N:'||l_proc,35);

2392: END IF;
2393: ELSE
2394: l_new_school_allowed := fnd_profile.value('HR_SSHR_NEW_SCHOOL');
2395: if l_new_school_allowed = 'N' THEN
2396: hr_utility.set_location('l_new_school_allowed=N:'||l_proc,35);
2397: CLOSE csr_get_establishment_id;
2398: fnd_message.set_name('PER','HR_SCHOOL_NAME_NOT_EXIST');
2399: hr_utility.raise_error;
2400: END IF;

Line 2399: hr_utility.raise_error;

2395: if l_new_school_allowed = 'N' THEN
2396: hr_utility.set_location('l_new_school_allowed=N:'||l_proc,35);
2397: CLOSE csr_get_establishment_id;
2398: fnd_message.set_name('PER','HR_SCHOOL_NAME_NOT_EXIST');
2399: hr_utility.raise_error;
2400: END IF;
2401: END IF;
2402: CLOSE csr_get_establishment_id;
2403: end if;

Line 2418: hr_utility.raise_error;

2414: FETCH c1 into l_dummy;
2415: if c1%found then
2416: close c1;
2417: fnd_message.set_name('PAY','HR_51847_QUA_REC_EXISTS');
2418: hr_utility.raise_error;
2419: end if;
2420: CLOSE c1;
2421:
2422: OPEN csr_attendance

Line 2449: hr_utility.set_location('qualification id is null,mode is EDUCATION,attendance id is null:'||l_proc,45);

2445: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
2446:
2447: if l_attendance_id IS null THEN
2448:
2449: hr_utility.set_location('qualification id is null,mode is EDUCATION,attendance id is null:'||l_proc,45);
2450: --attendance is not exist, then insert a new one
2451: --hr_qua_awards_util_ss.ins
2452: per_esa_ins.ins
2453: (p_validate => FALSE

Line 2574: hr_utility.set_location('Entering For Loop:'||l_proc,55);

2570: ,p_qua_information20 => p_qualifications(1).qua_information20
2571: );
2572:
2573: --insert subject for both qua and award
2574: hr_utility.set_location('Entering For Loop:'||l_proc,55);
2575: for i in 1..NVL(p_qua_subjects.count, 0) loop
2576: if p_qua_subjects(i).delete_flag = 'N' then
2577: per_sub_ins.ins
2578: (p_validate => FALSE

Line 2640: hr_utility.set_location('Exiting For Loop:'||l_proc,60);

2636: ,p_grade_attained => p_qua_subjects(i).grade_attained
2637: );
2638: end if;
2639: end loop;
2640: hr_utility.set_location('Exiting For Loop:'||l_proc,60);
2641: else --update an existing qua or award
2642:
2643: l_pq_object_version_number := p_qualifications(1).object_version_number;
2644: l_pea_object_version_number := p_qua_attendance(1).object_version_number;

Line 2819: hr_utility.set_location('Entering For Loop:'||l_proc,65);

2815: ,p_qua_information20 => p_qualifications(1).qua_information20
2816: );
2817:
2818: -- update subject record for both qua and award
2819: hr_utility.set_location('Entering For Loop:'||l_proc,65);
2820: FOR i IN 1..NVL(p_qua_subjects.count, 0) LOOP
2821: l_subjects_taken_id := p_qua_subjects(i).subjects_taken_id;
2822: l_pst_object_version_number :=
2823: p_qua_subjects(i).object_version_number;

Line 2962: hr_utility.set_location('Exiting For Loop:'||l_proc,70);

2958: ,p_object_version_number => l_pst_object_version_number);
2959: END IF;
2960: END IF;
2961: END LOOP;
2962: hr_utility.set_location('Exiting For Loop:'||l_proc,70);
2963: END IF;
2964:
2965: IF p_validate = TRUE THEN
2966: rollback to validate_qua;

Line 2968: hr_utility.set_location('Exiting:'||l_proc, 15);

2964:
2965: IF p_validate = TRUE THEN
2966: rollback to validate_qua;
2967: END IF;
2968: hr_utility.set_location('Exiting:'||l_proc, 15);
2969: EXCEPTION
2970: WHEN OTHERS THEN
2971: hr_utility.set_location('Exception:Others'||l_proc,555);
2972: rollback to validate_qua;

Line 2971: hr_utility.set_location('Exception:Others'||l_proc,555);

2967: END IF;
2968: hr_utility.set_location('Exiting:'||l_proc, 15);
2969: EXCEPTION
2970: WHEN OTHERS THEN
2971: hr_utility.set_location('Exception:Others'||l_proc,555);
2972: rollback to validate_qua;
2973: raise;
2974: END validate_api;
2975:

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

3003: transaction_id = l_transaction_id;
3004:
3005: Begin
3006:
3007: hr_utility.set_location('Entering:'||l_proc, 5);
3008: if funmode = 'RUN' then
3009: hr_utility.set_location('funmode=RUN:'||l_proc,10);
3010: savepoint start_transaction;
3011:

Line 3009: hr_utility.set_location('funmode=RUN:'||l_proc,10);

3005: Begin
3006:
3007: hr_utility.set_location('Entering:'||l_proc, 5);
3008: if funmode = 'RUN' then
3009: hr_utility.set_location('funmode=RUN:'||l_proc,10);
3010: savepoint start_transaction;
3011:
3012: -- check to see if the TRANSACTION_ID attribute has been created
3013: if hr_workflow_utility.item_attribute_exists

Line 3027: hr_utility.set_location('If itemtype and itemKey is not null:'||l_proc,15);

3023: ,p_item_key => itemkey) is not null then
3024:
3025: -- a current transaction is in progress we cannot overwrite it
3026: -- get the Transaction Step Id
3027: hr_utility.set_location('If itemtype and itemKey is not null:'||l_proc,15);
3028: l_transaction_id := hr_transaction_ss.get_transaction_id
3029: (p_item_type => itemtype
3030: ,p_item_key => itemkey);
3031: open c_get_transaction_step_id;

Line 3054: hr_utility.set_location('Exiting:'||l_proc, 20);

3050: elsif funmode = 'CANCEL' then
3051: null;
3052: end if;
3053:
3054: hr_utility.set_location('Exiting:'||l_proc, 20);
3055: Exception
3056: when others then
3057: hr_utility.set_location('Exception:Others'||l_proc,555);
3058: rollback to start_transaction;

Line 3057: hr_utility.set_location('Exception:Others'||l_proc,555);

3053:
3054: hr_utility.set_location('Exiting:'||l_proc, 20);
3055: Exception
3056: when others then
3057: hr_utility.set_location('Exception:Others'||l_proc,555);
3058: rollback to start_transaction;
3059: raise;
3060: End start_transaction;
3061:

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

3087: l_count integer;
3088: l_active_wf_items_list hr_workflow_service.active_wf_trans_items_list;
3089: l_proc varchar2(72) := g_package||'get_pending_items';
3090: Begin
3091: hr_utility.set_location('Entering:'||l_proc, 5);
3092: l_count := 0;
3093: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3094: For I in csr_pending_items Loop
3095: l_count := l_count + 1;

Line 3093: hr_utility.set_location('Entering For Loop:'||l_proc,10);

3089: l_proc varchar2(72) := g_package||'get_pending_items';
3090: Begin
3091: hr_utility.set_location('Entering:'||l_proc, 5);
3092: l_count := 0;
3093: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3094: For I in csr_pending_items Loop
3095: l_count := l_count + 1;
3096: l_active_wf_items_list(l_count).active_item_key := I.item_key;
3097: l_active_wf_items_list(l_count).activity_id := I.activity_id;

Line 3100: hr_utility.set_location('Exiting For Loop:'||l_proc,15);

3096: l_active_wf_items_list(l_count).active_item_key := I.item_key;
3097: l_active_wf_items_list(l_count).activity_id := I.activity_id;
3098: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;
3099: End Loop;
3100: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3101: hr_utility.set_location('Exiting:'||l_proc, 20);
3102: return l_active_wf_items_list;
3103: End get_pending_items;
3104:

Line 3101: hr_utility.set_location('Exiting:'||l_proc, 20);

3097: l_active_wf_items_list(l_count).activity_id := I.activity_id;
3098: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;
3099: End Loop;
3100: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3101: hr_utility.set_location('Exiting:'||l_proc, 20);
3102: return l_active_wf_items_list;
3103: End get_pending_items;
3104:
3105: -- Start of Procedure get_pending_transaction_steps

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

3121: l_result_code varchar2(30);
3122: l_proc varchar2(72) := g_package||'get_pending_transaction_steps';
3123:
3124: BEGIN
3125: hr_utility.set_location('Entering:'||l_proc, 5);
3126:
3127: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3128: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);
3129: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;

Line 3128: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);

3124: BEGIN
3125: hr_utility.set_location('Entering:'||l_proc, 5);
3126:
3127: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3128: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);
3129: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;
3130: ELSE
3131: hr_utility.set_location('mode!=Education:'||l_proc,15);
3132: l_result_code := HR_QUA_AWARDS_UTIL_SS.AWARD_CHANGED;

Line 3131: hr_utility.set_location('mode!=Education:'||l_proc,15);

3127: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3128: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);
3129: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;
3130: ELSE
3131: hr_utility.set_location('mode!=Education:'||l_proc,15);
3132: l_result_code := HR_QUA_AWARDS_UTIL_SS.AWARD_CHANGED;
3133: END IF;
3134:
3135: l_active_item_keys :=

Line 3145: hr_utility.set_location('Entering For Loop:'||l_proc,20);

3141: );
3142:
3143: l_pending_count := NVL(l_active_item_keys.count,0);
3144:
3145: hr_utility.set_location('Entering For Loop:'||l_proc,20);
3146: FOR i IN 1..l_pending_count LOOP
3147: p_transaction_step_id(j) := l_active_item_keys(i).trans_step_id;
3148: j := j +1;
3149: END LOOP;

Line 3150: hr_utility.set_location('Exiting For Loop:'||l_proc,25);

3146: FOR i IN 1..l_pending_count LOOP
3147: p_transaction_step_id(j) := l_active_item_keys(i).trans_step_id;
3148: j := j +1;
3149: END LOOP;
3150: hr_utility.set_location('Exiting For Loop:'||l_proc,25);
3151:
3152: hr_utility.set_location('Exiting:'||l_proc, 30);
3153: END get_pending_transaction_steps;
3154:

Line 3152: hr_utility.set_location('Exiting:'||l_proc, 30);

3148: j := j +1;
3149: END LOOP;
3150: hr_utility.set_location('Exiting For Loop:'||l_proc,25);
3151:
3152: hr_utility.set_location('Exiting:'||l_proc, 30);
3153: END get_pending_transaction_steps;
3154:
3155:
3156: -- End of Procedure get_pending_transaction_steps

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

3207:
3208:
3209: BEGIN
3210:
3211: hr_utility.set_location('Entering:'||l_proc, 5);
3212: BEGIN
3213: l_length := length(p_qualifications(1).comments);
3214: IF l_length > 2000 THEN
3215: --fnd_message.set_name('PER','HR_COMMENT_EXCEED_MAX_LENGTH');

Line 3216: --hr_utility.raise_error;

3212: BEGIN
3213: l_length := length(p_qualifications(1).comments);
3214: IF l_length > 2000 THEN
3215: --fnd_message.set_name('PER','HR_COMMENT_EXCEED_MAX_LENGTH');
3216: --hr_utility.raise_error;
3217: hr_utility.set_location('length>2000:'||l_proc,10);
3218: p_error_message := nvl(p_error_message,'')||'!'||'|'||'Comments'||'|'||'PER'||'|'||'HR_COMMENT_EXCEED_MAX_LENGTH'||'|'||'!';
3219: END IF;
3220: EXCEPTION

Line 3217: hr_utility.set_location('length>2000:'||l_proc,10);

3213: l_length := length(p_qualifications(1).comments);
3214: IF l_length > 2000 THEN
3215: --fnd_message.set_name('PER','HR_COMMENT_EXCEED_MAX_LENGTH');
3216: --hr_utility.raise_error;
3217: hr_utility.set_location('length>2000:'||l_proc,10);
3218: p_error_message := nvl(p_error_message,'')||'!'||'|'||'Comments'||'|'||'PER'||'|'||'HR_COMMENT_EXCEED_MAX_LENGTH'||'|'||'!';
3219: END IF;
3220: EXCEPTION
3221: WHEN OTHERS THEN

Line 3222: hr_utility.set_location('Exception:Others'||l_proc,555);

3218: p_error_message := nvl(p_error_message,'')||'!'||'|'||'Comments'||'|'||'PER'||'|'||'HR_COMMENT_EXCEED_MAX_LENGTH'||'|'||'!';
3219: END IF;
3220: EXCEPTION
3221: WHEN OTHERS THEN
3222: hr_utility.set_location('Exception:Others'||l_proc,555);
3223: raise;
3224: END;
3225:
3226: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

Line 3234: hr_utility.set_location('mode is Education:'||l_proc,20);

3230: -- CHK_ATT_OVERLAP
3231: -- CHK_ATTENDED_START_DATE
3232: -- CHK_ATTENDED_END_DATE
3233: -- CHK_ATT_TO_DATE
3234: hr_utility.set_location('mode is Education:'||l_proc,20);
3235: l_pea_date_error := FALSE;
3236:
3237: BEGIN
3238: IF p_qua_attendance(1).attended_start_date is not null and

Line 3243: --hr_utility.raise_error;

3239: p_qua_attendance(1).attended_end_date is not null and
3240: p_qua_attendance(1).attended_start_date >
3241: p_qua_attendance(1).attended_end_date THEN
3242: --fnd_message.set_name('PER','HR_51496_ESA_ATT_END_DATE');
3243: --hr_utility.raise_error;
3244: hr_utility.set_location('Startdate>EndDate:'||l_proc,25);
3245: p_error_message := nvl(p_error_message,'')||'!'||'|'||'AttendedStartDate'||'|'||'PER'||'|'||'HR_51496_ESA_ATT_END_DATE'||'|'||'!';
3246: END IF;
3247: EXCEPTION

Line 3244: hr_utility.set_location('Startdate>EndDate:'||l_proc,25);

3240: p_qua_attendance(1).attended_start_date >
3241: p_qua_attendance(1).attended_end_date THEN
3242: --fnd_message.set_name('PER','HR_51496_ESA_ATT_END_DATE');
3243: --hr_utility.raise_error;
3244: hr_utility.set_location('Startdate>EndDate:'||l_proc,25);
3245: p_error_message := nvl(p_error_message,'')||'!'||'|'||'AttendedStartDate'||'|'||'PER'||'|'||'HR_51496_ESA_ATT_END_DATE'||'|'||'!';
3246: END IF;
3247: EXCEPTION
3248: WHEN OTHERS THEN

Line 3249: hr_utility.set_location('Exception:Others'||l_proc,555);

3245: p_error_message := nvl(p_error_message,'')||'!'||'|'||'AttendedStartDate'||'|'||'PER'||'|'||'HR_51496_ESA_ATT_END_DATE'||'|'||'!';
3246: END IF;
3247: EXCEPTION
3248: WHEN OTHERS THEN
3249: hr_utility.set_location('Exception:Others'||l_proc,555);
3250: l_pea_date_error := TRUE;
3251: raise;
3252: END;
3253:

Line 3271: --hr_utility.raise_error;

3267: p_qualifications(1).end_date is not null and
3268: p_qualifications(1).start_date > p_qualifications(1).end_date
3269: THEN
3270: --fnd_message.set_name('PAY','HR_51853_QUA_DATE_INV');
3271: --hr_utility.raise_error;
3272: hr_utility.set_location('StartDate>endDate:'||l_proc,30);
3273: p_error_message := nvl(p_error_message,'')||'!'||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51853_QUA_DATE_INV'||'|'||'!';
3274: END IF;
3275: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

Line 3272: hr_utility.set_location('StartDate>endDate:'||l_proc,30);

3268: p_qualifications(1).start_date > p_qualifications(1).end_date
3269: THEN
3270: --fnd_message.set_name('PAY','HR_51853_QUA_DATE_INV');
3271: --hr_utility.raise_error;
3272: hr_utility.set_location('StartDate>endDate:'||l_proc,30);
3273: p_error_message := nvl(p_error_message,'')||'!'||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51853_QUA_DATE_INV'||'|'||'!';
3274: END IF;
3275: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3276: IF p_qualifications(1).start_date is not null and

Line 3281: --hr_utility.raise_error;

3277: p_qua_attendance(1).attended_start_date is not null and
3278: p_qualifications(1).start_date < p_qua_attendance(1).attended_start_date
3279: THEN
3280: --fnd_message.set_name('PAY','HR_51841_QUA_DATES_OUT_ESA');
3281: --hr_utility.raise_error;
3282: hr_utility.set_location('startdate 3283: p_error_message := nvl(p_error_message,'')||'!'||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51841_QUA_DATES_OUT_ESA'||'|'||'!';
3284: END IF;
3285: IF p_qualifications(1).end_date is not null

Line 3282: hr_utility.set_location('startdate

3278: p_qualifications(1).start_date < p_qua_attendance(1).attended_start_date
3279: THEN
3280: --fnd_message.set_name('PAY','HR_51841_QUA_DATES_OUT_ESA');
3281: --hr_utility.raise_error;
3282: hr_utility.set_location('startdate 3283: p_error_message := nvl(p_error_message,'')||'!'||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51841_QUA_DATES_OUT_ESA'||'|'||'!';
3284: END IF;
3285: IF p_qualifications(1).end_date is not null
3286: and p_qua_attendance(1).attended_end_date is not null

Line 3290: --hr_utility.raise_error;

3286: and p_qua_attendance(1).attended_end_date is not null
3287: and p_qualifications(1).end_date > p_qua_attendance(1).attended_end_date
3288: THEN
3289: --fnd_message.set_name('PAY','HR_51841_QUA_DATES_OUT_ESA');
3290: --hr_utility.raise_error;
3291: hr_utility.set_location('end_date>attended_end_date:'||l_proc,40);
3292: p_error_message := nvl(p_error_message,'')||'!'||'|'||'EndDate'||'|'||'PAY'||'|'||'HR_51841_QUA_DATES_OUT_ESA'||'|'||'!';
3293: END IF;
3294: END IF;

Line 3291: hr_utility.set_location('end_date>attended_end_date:'||l_proc,40);

3287: and p_qualifications(1).end_date > p_qua_attendance(1).attended_end_date
3288: THEN
3289: --fnd_message.set_name('PAY','HR_51841_QUA_DATES_OUT_ESA');
3290: --hr_utility.raise_error;
3291: hr_utility.set_location('end_date>attended_end_date:'||l_proc,40);
3292: p_error_message := nvl(p_error_message,'')||'!'||'|'||'EndDate'||'|'||'PAY'||'|'||'HR_51841_QUA_DATES_OUT_ESA'||'|'||'!';
3293: END IF;
3294: END IF;
3295: END IF;

Line 3303: hr_utility.set_location('date_error=FALSE:'||l_proc,45);

3299: --
3300: -- Business Rule Mapping
3301: -- =====================
3302: -- CHK_QUAL_OVERLAP
3303: hr_utility.set_location('date_error=FALSE:'||l_proc,45);
3304: OPEN c1(p_qualifications(1).start_date,
3305: p_qualifications(1).end_date,
3306: p_qualifications(1).person_id,
3307: p_qualifications(1).business_group_id,

Line 3314: hr_utility.set_location('c1%found:'||l_proc,50);

3310: p_qualifications(1).title,
3311: p_qualifications(1).qualification_id);
3312: FETCH c1 into l_dummy;
3313: if c1%found then
3314: hr_utility.set_location('c1%found:'||l_proc,50);
3315: close c1;
3316: fnd_message.set_name('PAY','HR_51847_QUA_REC_EXISTS');
3317: hr_utility.raise_error;
3318: end if;

Line 3317: hr_utility.raise_error;

3313: if c1%found then
3314: hr_utility.set_location('c1%found:'||l_proc,50);
3315: close c1;
3316: fnd_message.set_name('PAY','HR_51847_QUA_REC_EXISTS');
3317: hr_utility.raise_error;
3318: end if;
3319: CLOSE c1;
3320: EXCEPTION
3321: WHEN OTHERS THEN

Line 3322: hr_utility.set_location('Exception:Others'||l_proc,555);

3318: end if;
3319: CLOSE c1;
3320: EXCEPTION
3321: WHEN OTHERS THEN
3322: hr_utility.set_location('Exception:Others'||l_proc,555);
3323: raise;
3324: END;
3325: END IF;
3326: --

Line 3340: hr_utility.set_location('Exception:Others'||l_proc,555);

3336: p_fee_currency => p_qualifications(1).fee_currency,
3337: p_object_version_number => p_qualifications(1).object_version_number);
3338: EXCEPTION
3339: WHEN OTHERS THEN
3340: hr_utility.set_location('Exception:Others'||l_proc,555);
3341: raise;
3342: END;
3343: END IF;
3344:

Line 3359: hr_utility.set_location('Exception:Others'||l_proc,555);

3355: p_start_date => p_qualifications(1).start_date,
3356: p_object_version_number => p_qualifications(1).object_version_number);
3357: EXCEPTION
3358: WHEN OTHERS THEN
3359: hr_utility.set_location('Exception:Others'||l_proc,555);
3360: raise;
3361: END;
3362: END IF;
3363:

Line 3369: hr_utility.set_location('Entering For Loop:'||l_proc,55);

3365: -- Business Rule Mapping
3366: -- =====================
3367: -- CHK_START_DATE
3368: -- CHK_END_DATE
3369: hr_utility.set_location('Entering For Loop:'||l_proc,55);
3370: FOR i IN 1..NVL(p_qua_subjects.count,0) LOOP
3371: IF p_qua_subjects(i).delete_flag = 'N' THEN
3372: l_error := FALSE;
3373: IF l_error = FALSE AND l_pq_date_error = FALSE THEN

Line 3384: --hr_utility.raise_error;

3380: p_qua_subjects(i).end_date is not null and
3381: p_qua_subjects(i).start_date > p_qua_subjects(i).end_date
3382: THEN
3383: --fnd_message.set_name('PAY','HR_51816_SUB_START_DATE_INV');
3384: --hr_utility.raise_error;
3385: p_subjects_error_message := nvl(p_subjects_error_message,'')||'!'||'|'||to_char(i-1)||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51816_SUB_START_DATE_INV'||'|'||'!';
3386: END IF;
3387: IF p_ignore_sub_date_boundaries = 'N' THEN
3388: IF p_qua_subjects(i).start_date

Line 3391: --hr_utility.raise_error;

3387: IF p_ignore_sub_date_boundaries = 'N' THEN
3388: IF p_qua_subjects(i).start_date
3389: < p_qualifications(1).start_date THEN
3390: --fnd_message.set_name('PAY','HR_51817_SUB_START_DATE_QUAL');
3391: --hr_utility.raise_error;
3392: p_subjects_error_message := nvl(p_subjects_error_message,'')||'!'||'|'||to_char(i-1)||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51817_SUB_START_DATE_QUAL'||'|'||'!';
3393: END IF;
3394: END IF;
3395: EXCEPTION

Line 3397: hr_utility.set_location('Exception:Others'||l_proc,555);

3393: END IF;
3394: END IF;
3395: EXCEPTION
3396: WHEN OTHERS THEN
3397: hr_utility.set_location('Exception:Others'||l_proc,555);
3398: raise;
3399: END;
3400: END IF;
3401: END IF;

Line 3403: hr_utility.set_location('Exiting For Loop:'||l_proc,60);

3399: END;
3400: END IF;
3401: END IF;
3402: END LOOP;
3403: hr_utility.set_location('Exiting For Loop:'||l_proc,60);
3404: hr_utility.set_location('Exiting:'||l_proc, 65);
3405: Exception
3406: when others then
3407: hr_utility.set_location('Exception:Others'||l_proc,555);

Line 3404: hr_utility.set_location('Exiting:'||l_proc, 65);

3400: END IF;
3401: END IF;
3402: END LOOP;
3403: hr_utility.set_location('Exiting For Loop:'||l_proc,60);
3404: hr_utility.set_location('Exiting:'||l_proc, 65);
3405: Exception
3406: when others then
3407: hr_utility.set_location('Exception:Others'||l_proc,555);
3408: raise;

Line 3407: hr_utility.set_location('Exception:Others'||l_proc,555);

3403: hr_utility.set_location('Exiting For Loop:'||l_proc,60);
3404: hr_utility.set_location('Exiting:'||l_proc, 65);
3405: Exception
3406: when others then
3407: hr_utility.set_location('Exception:Others'||l_proc,555);
3408: raise;
3409: END check_errors;
3410:
3411: -- end of procedures check_errors

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

3430: l_proc varchar2(72) := g_package||'get_entire_qua';
3431:
3432: BEGIN
3433:
3434: hr_utility.set_location('Entering:'||l_proc, 5);
3435: p_mode :=
3436: hr_transaction_api.get_varchar2_value
3437: (p_transaction_step_id => p_transaction_step_id
3438: ,p_name => 'P_MODE');

Line 3447: hr_utility.set_location('Entering For Loop:'||l_proc,10);

3443: ,p_name => 'P_SUBJECT_COUNT'));
3444:
3445: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();
3446:
3447: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3448: FOR i IN 1..NVL(l_attendance_count,0) LOOP
3449: p_qua_attendance.extend;
3450: p_qua_attendance(i) := SSHR_QUA_ATTENDANCE_OBJ_TYP(
3451: to_number(hr_transaction_api.get_varchar2_value

Line 3546: hr_utility.set_location('Exiting For Loop:'||l_proc,15);

3542: (p_transaction_step_id => p_transaction_step_id
3543: ,p_name => 'P_PARTY_ID'))
3544: );
3545: END LOOP;
3546: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3547:
3548: p_qualifications := SSHR_QUA_TAB_TYP();
3549:
3550: hr_utility.set_location('Entering For Loop:'||l_proc,20);

Line 3550: hr_utility.set_location('Entering For Loop:'||l_proc,20);

3546: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3547:
3548: p_qualifications := SSHR_QUA_TAB_TYP();
3549:
3550: hr_utility.set_location('Entering For Loop:'||l_proc,20);
3551: FOR i IN 1..NVL(l_qua_count,0) LOOP
3552: p_qualifications.extend;
3553: p_qualifications(i) := SSHR_QUA_OBJ_TYP(
3554: to_number(hr_transaction_api.get_varchar2_value

Line 3777: hr_utility.set_location('Exiting For Loop:'||l_proc,25);

3773: (p_transaction_step_id => p_transaction_step_id
3774: ,p_name => 'P_PARTY_ID')
3775: );
3776: END LOOP;
3777: hr_utility.set_location('Exiting For Loop:'||l_proc,25);
3778:
3779:
3780: -- now get the subject details
3781: p_qua_subjects := SSHR_QUA_SUBJECT_TAB_TYP();

Line 3783: hr_utility.set_location('Entering For Loop:'||l_proc,30);

3779:
3780: -- now get the subject details
3781: p_qua_subjects := SSHR_QUA_SUBJECT_TAB_TYP();
3782:
3783: hr_utility.set_location('Entering For Loop:'||l_proc,30);
3784: FOR i IN 1..NVL(l_subject_count,0) LOOP
3785: p_qua_subjects.extend;
3786: p_qua_subjects(i) := SSHR_QUA_SUBJECT_OBJ_TYP(
3787:

Line 3997: hr_utility.set_location('Exiting For Loop:'||l_proc,35);

3993: ,p_name => 'P_SUB_INFORMATION20_PST'||i)
3994: );
3995:
3996: END LOOP;
3997: hr_utility.set_location('Exiting For Loop:'||l_proc,35);
3998:
3999: EXCEPTION
4000: WHEN OTHERS THEN
4001: hr_utility.set_location('Exception:Others'||l_proc,555);

Line 4001: hr_utility.set_location('Exception:Others'||l_proc,555);

3997: hr_utility.set_location('Exiting For Loop:'||l_proc,35);
3998:
3999: EXCEPTION
4000: WHEN OTHERS THEN
4001: hr_utility.set_location('Exception:Others'||l_proc,555);
4002: RAISE;
4003: END get_entire_qua;
4004:
4005:

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

4011: ) is
4012: l_proc varchar2(72) := g_package||'rollback_transaction_step';
4013:
4014: Begin
4015: hr_utility.set_location('Entering:'||l_proc, 5);
4016: delete from hr_api_transaction_values where transaction_step_id = p_transaction_step_id;
4017: delete from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id;
4018: hr_utility.set_location('Exiting:'||l_proc, 15);
4019:

Line 4018: hr_utility.set_location('Exiting:'||l_proc, 15);

4014: Begin
4015: hr_utility.set_location('Entering:'||l_proc, 5);
4016: delete from hr_api_transaction_values where transaction_step_id = p_transaction_step_id;
4017: delete from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id;
4018: hr_utility.set_location('Exiting:'||l_proc, 15);
4019:
4020: Exception
4021: when others then
4022: hr_utility.set_location('Exception:Others'||l_proc,555);

Line 4022: hr_utility.set_location('Exception:Others'||l_proc,555);

4018: hr_utility.set_location('Exiting:'||l_proc, 15);
4019:
4020: Exception
4021: when others then
4022: hr_utility.set_location('Exception:Others'||l_proc,555);
4023: raise;
4024: End rollback_transaction_step;
4025:
4026: /*

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

4033: l_qualification_id number := 0;
4034: l_proc varchar2(72) := g_package||'get_qualification_id';
4035: Begin
4036:
4037: hr_utility.set_location('Entering:'||l_proc, 5);
4038: l_qualification_id :=
4039: hr_transaction_api.get_varchar2_value
4040: (p_transaction_step_id => p_transaction_step_id
4041: ,p_name => 'p_qualification_id');

Line 4043: hr_utility.set_location('Exiting:'||l_proc, 15);

4039: hr_transaction_api.get_varchar2_value
4040: (p_transaction_step_id => p_transaction_step_id
4041: ,p_name => 'p_qualification_id');
4042:
4043: hr_utility.set_location('Exiting:'||l_proc, 15);
4044: return nvl(l_qualification_id,0);
4045: Exception
4046: when others then
4047: hr_utility.set_location('Exception:Others'||l_proc,555);

Line 4047: hr_utility.set_location('Exception:Others'||l_proc,555);

4043: hr_utility.set_location('Exiting:'||l_proc, 15);
4044: return nvl(l_qualification_id,0);
4045: Exception
4046: when others then
4047: hr_utility.set_location('Exception:Others'||l_proc,555);
4048: raise;
4049: End;
4050:
4051: /*

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

4057:
4058: Begin
4059:
4060: -- delete the old transaction values
4061: hr_utility.set_location('Entering:'||l_proc, 5);
4062: hr_transaction_ss.delete_transaction_step(p_transaction_step_id,null,p_creator_person_id);
4063: hr_utility.set_location('Exiting:'||l_proc, 15);
4064: Exception
4065: when others then

Line 4063: hr_utility.set_location('Exiting:'||l_proc, 15);

4059:
4060: -- delete the old transaction values
4061: hr_utility.set_location('Entering:'||l_proc, 5);
4062: hr_transaction_ss.delete_transaction_step(p_transaction_step_id,null,p_creator_person_id);
4063: hr_utility.set_location('Exiting:'||l_proc, 15);
4064: Exception
4065: when others then
4066: hr_utility.set_location('Exception:Others'||l_proc,555);
4067: raise;

Line 4066: hr_utility.set_location('Exception:Others'||l_proc,555);

4062: hr_transaction_ss.delete_transaction_step(p_transaction_step_id,null,p_creator_person_id);
4063: hr_utility.set_location('Exiting:'||l_proc, 15);
4064: Exception
4065: when others then
4066: hr_utility.set_location('Exception:Others'||l_proc,555);
4067: raise;
4068: End;
4069:
4070: