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

128: -- get user date format
129: --
130: --get entire qualification data from transaction table
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: get_entire_qua
134: (p_transaction_step_id => p_transaction_step_id
135: ,p_mode => l_mode
136: ,p_qualifications => l_qualifications

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

142: (p_transaction_step_id => p_transaction_step_id
143: ,p_name => 'P_SELECTED_PERSON_ID'));
144:
145: IF l_qualifications(1).delete_flag = 'Y' THEN
146: hr_utility.set_location('l_qualifications(1).delete_flag = Y:'||l_proc,10);
147: delete_entire_qua
148: (p_validate => p_validate
149: ,p_qualification_id => l_qualifications(1).qualification_id
150: ,p_pq_object_version_number =>

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

153: ,p_pea_object_version_number =>
154: l_qua_attendance(1).object_version_number
155: ,p_qua_subjects => l_qua_subjects);
156: ELSE
157: hr_utility.set_location('l_qualifications(1).delete_flag != Y:'||l_proc,15);
158: validate_api
159: (p_validate => p_validate
160: ,p_mode => l_mode
161: ,p_selected_person_id => l_selected_person_id

Line 168: hr_utility.set_location('merge_attachments Start : l_selected_person_id = ' || l_selected_person_id || ' ' ||l_proc, 20);

164: ,p_qua_attendance => l_qua_attendance);
165: END IF;
166:
167:
168: hr_utility.set_location('merge_attachments Start : l_selected_person_id = ' || l_selected_person_id || ' ' ||l_proc, 20);
169:
170: HR_UTIL_MISC_SS.merge_attachments( p_dest_entity_name => 'PER_PEOPLE_F'
171: ,p_dest_pk1_value => l_selected_person_id
172: ,p_return_status => l_attach_status);

Line 174: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' ||l_proc, 25);

170: HR_UTIL_MISC_SS.merge_attachments( p_dest_entity_name => 'PER_PEOPLE_F'
171: ,p_dest_pk1_value => l_selected_person_id
172: ,p_return_status => l_attach_status);
173:
174: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' ||l_proc, 25);
175:
176: hr_utility.set_location('Exiting:'||l_proc, 30);
177:
178: end process_api;

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

172: ,p_return_status => l_attach_status);
173:
174: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' ||l_proc, 25);
175:
176: hr_utility.set_location('Exiting:'||l_proc, 30);
177:
178: end process_api;
179: -- ---------------------------------------------------------------------------
180: -- field_changed

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

184: ,p_field2 in varchar2)
185: RETURN BOOLEAN IS
186: l_proc varchar2(72) := g_package||'field_changed';
187: BEGIN
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: IF p_field1 IS null AND p_field2 IS null
190: OR
191: p_field1 IS NOT null AND p_field2 IS NOT null AND
192: p_field1 = p_field2 THEN

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

189: IF p_field1 IS null AND p_field2 IS null
190: OR
191: p_field1 IS NOT null AND p_field2 IS NOT null AND
192: p_field1 = p_field2 THEN
193: hr_utility.set_location('Return FALSE:'||l_proc, 10);
194: RETURN FALSE;
195: ELSE
196: --fnd_message.set_name('PER',p_field1||'-'||p_field2);
197: --hr_utility.raise_error;

Line 197: --hr_utility.raise_error;

193: hr_utility.set_location('Return FALSE:'||l_proc, 10);
194: RETURN FALSE;
195: ELSE
196: --fnd_message.set_name('PER',p_field1||'-'||p_field2);
197: --hr_utility.raise_error;
198: hr_utility.set_location('Return TRUE:'||l_proc, 10);
199: RETURN TRUE;
200: END IF;
201:

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

194: RETURN FALSE;
195: ELSE
196: --fnd_message.set_name('PER',p_field1||'-'||p_field2);
197: --hr_utility.raise_error;
198: hr_utility.set_location('Return TRUE:'||l_proc, 10);
199: RETURN TRUE;
200: END IF;
201:
202: END field_changed;

Line 234: hr_utility.set_location('p_qualifications(1).attendance_id ' ||p_qualifications(1).attendance_id , 1);

230: l_proc varchar2(72) := g_package||'is_establishment_changed';
231:
232: BEGIN
233:
234: hr_utility.set_location('p_qualifications(1).attendance_id ' ||p_qualifications(1).attendance_id , 1);
235:
236: IF p_qualifications(1).attendance_id is not null THEN
237:
238: OPEN csr_attendance(p_qualifications(1).attendance_id);

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

238: OPEN csr_attendance(p_qualifications(1).attendance_id);
239: FETCH csr_attendance INTO v_attendance;
240: IF csr_attendance%NOTFOUND THEN
241: CLOSE csr_attendance;
242: hr_utility.set_location('csr_attendance%NOTFOUND, RETURN TRUE:'||l_proc,35);
243: RETURN TRUE;
244: END IF;
245: CLOSE csr_attendance;
246:

Line 247: hr_utility.set_location('establishment_id',40);

243: RETURN TRUE;
244: END IF;
245: CLOSE csr_attendance;
246:
247: hr_utility.set_location('establishment_id',40);
248:
249: IF field_changed(v_attendance.establishment_id
250: ,p_qua_attendance(1).establishment_id) THEN
251: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,40);

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

247: hr_utility.set_location('establishment_id',40);
248:
249: IF field_changed(v_attendance.establishment_id
250: ,p_qua_attendance(1).establishment_id) THEN
251: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,40);
252: RETURN TRUE;
253: END IF;
254: IF v_attendance.establishment_id IS NOT NULL THEN
255: OPEN csr_establishment(v_attendance.establishment_id);

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

256: FETCH csr_establishment INTO v_establishment;
257: CLOSE csr_establishment;
258: IF field_changed(v_establishment.name
259: ,p_qua_attendance(1).establishment) THEN
260: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,45);
261: RETURN TRUE;
262: END IF;
263: ELSE
264: IF field_changed(v_attendance.establishment

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

262: END IF;
263: ELSE
264: IF field_changed(v_attendance.establishment
265: ,p_qua_attendance(1).establishment) THEN
266: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,50);
267: RETURN TRUE;
268: END IF;
269: END IF;
270: IF field_changed(to_char(v_attendance.attended_start_date,

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

270: IF field_changed(to_char(v_attendance.attended_start_date,
271: FORMAT_RRRR_MM_DD)
272: ,to_char(p_qua_attendance(1).attended_start_date,
273: FORMAT_RRRR_MM_DD)) THEN
274: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,55);
275: RETURN TRUE;
276: END IF;
277: IF field_changed(to_char(v_attendance.attended_end_date,
278: FORMAT_RRRR_MM_DD)

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

277: IF field_changed(to_char(v_attendance.attended_end_date,
278: FORMAT_RRRR_MM_DD)
279: ,to_char(p_qua_attendance(1).attended_end_date,
280: FORMAT_RRRR_MM_DD)) THEN
281: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,60);
282: RETURN TRUE;
283: END IF;
284: IF field_changed(NVL(v_attendance.full_time,'N')
285: ,NVL(p_qua_attendance(1).full_time,'N')) THEN

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

282: RETURN TRUE;
283: END IF;
284: IF field_changed(NVL(v_attendance.full_time,'N')
285: ,NVL(p_qua_attendance(1).full_time,'N')) THEN
286: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,65);
287: RETURN TRUE;
288: END IF;
289: IF field_changed(v_attendance.attribute_category
290: ,p_qua_attendance(1).attribute_category) THEN

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

287: RETURN TRUE;
288: END IF;
289: IF field_changed(v_attendance.attribute_category
290: ,p_qua_attendance(1).attribute_category) THEN
291: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,70);
292: RETURN TRUE;
293: END IF;
294: IF field_changed(v_attendance.attribute1
295: ,p_qua_attendance(1).attribute1) THEN

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

292: RETURN TRUE;
293: END IF;
294: IF field_changed(v_attendance.attribute1
295: ,p_qua_attendance(1).attribute1) THEN
296: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,75);
297: RETURN TRUE;
298: END IF;
299: IF field_changed(v_attendance.attribute2
300: ,p_qua_attendance(1).attribute2) THEN

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

297: RETURN TRUE;
298: END IF;
299: IF field_changed(v_attendance.attribute2
300: ,p_qua_attendance(1).attribute2) THEN
301: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,85);
302: RETURN TRUE;
303: END IF;
304: IF field_changed(v_attendance.attribute3
305: ,p_qua_attendance(1).attribute3) THEN

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

429: BEGIN
430: --
431: --new qualification
432: --
433: hr_utility.set_location('Entering:'||l_proc, 5);
434: IF p_qualifications(1).qualification_id IS null THEN
435: hr_utility.set_location('qualification_id =null, RETURN TRUE:'||l_proc,10);
436: RETURN TRUE;
437: END IF;

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

431: --new qualification
432: --
433: hr_utility.set_location('Entering:'||l_proc, 5);
434: IF p_qualifications(1).qualification_id IS null THEN
435: hr_utility.set_location('qualification_id =null, RETURN TRUE:'||l_proc,10);
436: RETURN TRUE;
437: END IF;
438:
439: --

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

446: CLOSE csr_qualification;
447:
448: IF (v_qualification.attendance_id is null and p_qua_attendance(1).establishment_id is not null)
449: THEN
450: hr_utility.set_location(' establishment change '||l_proc,10);
451: RETURN TRUE;
452: END IF;
453:
454: --IF field_changed(v_qualification.party_id

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

457: --END IF;
458:
459: IF field_changed(v_qualification.title
460: ,p_qualifications(1).title) THEN
461: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,10);
462: RETURN TRUE;
463: END IF;
464:
465: IF field_changed(to_char(v_qualification.start_date,FORMAT_RRRR_MM_DD)

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

463: END IF;
464:
465: IF field_changed(to_char(v_qualification.start_date,FORMAT_RRRR_MM_DD)
466: ,to_char(p_qualifications(1).start_date,FORMAT_RRRR_MM_DD)) THEN
467: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,15);
468: RETURN TRUE;
469: END IF;
470:
471: IF field_changed(to_char(v_qualification.end_date,FORMAT_RRRR_MM_DD)

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

469: END IF;
470:
471: IF field_changed(to_char(v_qualification.end_date,FORMAT_RRRR_MM_DD)
472: ,to_char(p_qualifications(1).end_date,FORMAT_RRRR_MM_DD)) THEN
473: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,20);
474: RETURN TRUE;
475: END IF;
476:
477: IF field_changed(v_qualification.status

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

475: END IF;
476:
477: IF field_changed(v_qualification.status
478: ,p_qualifications(1).status) THEN
479: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,25);
480: RETURN TRUE;
481: END IF;
482:
483: IF field_changed(v_qualification.attendance_id

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

481: END IF;
482:
483: IF field_changed(v_qualification.attendance_id
484: ,p_qualifications(1).attendance_id) THEN
485: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,30);
486: RETURN TRUE;
487: END IF;
488:
489: IF p_qualifications(1).attendance_id is not null THEN

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

490: OPEN csr_attendance(p_qualifications(1).attendance_id);
491: FETCH csr_attendance INTO v_attendance;
492: IF csr_attendance%NOTFOUND THEN
493: CLOSE csr_attendance;
494: hr_utility.set_location('csr_attendance%NOTFOUND, RETURN TRUE:'||l_proc,35);
495: RETURN TRUE;
496: END IF;
497: CLOSE csr_attendance;
498: END IF;

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

501: IF p_qualifications(1).attendance_id is not null THEN
502:
503: IF field_changed(v_attendance.establishment_id
504: ,p_qua_attendance(1).establishment_id) THEN
505: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,40);
506: RETURN TRUE;
507: END IF;
508: IF v_attendance.establishment_id IS NOT NULL THEN
509: OPEN csr_establishment(v_attendance.establishment_id);

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

510: FETCH csr_establishment INTO v_establishment;
511: CLOSE csr_establishment;
512: IF field_changed(v_establishment.name
513: ,p_qua_attendance(1).establishment) THEN
514: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,45);
515: RETURN TRUE;
516: END IF;
517: ELSE
518: IF field_changed(v_attendance.establishment

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

516: END IF;
517: ELSE
518: IF field_changed(v_attendance.establishment
519: ,p_qua_attendance(1).establishment) THEN
520: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,50);
521: RETURN TRUE;
522: END IF;
523: END IF;
524: IF field_changed(to_char(v_attendance.attended_start_date,

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

524: IF field_changed(to_char(v_attendance.attended_start_date,
525: FORMAT_RRRR_MM_DD)
526: ,to_char(p_qua_attendance(1).attended_start_date,
527: FORMAT_RRRR_MM_DD)) THEN
528: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,55);
529: RETURN TRUE;
530: END IF;
531: IF field_changed(to_char(v_attendance.attended_end_date,
532: FORMAT_RRRR_MM_DD)

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

531: IF field_changed(to_char(v_attendance.attended_end_date,
532: FORMAT_RRRR_MM_DD)
533: ,to_char(p_qua_attendance(1).attended_end_date,
534: FORMAT_RRRR_MM_DD)) THEN
535: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,60);
536: RETURN TRUE;
537: END IF;
538: IF field_changed(NVL(v_attendance.full_time,'N')
539: ,NVL(p_qua_attendance(1).full_time,'N')) THEN

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

536: RETURN TRUE;
537: END IF;
538: IF field_changed(NVL(v_attendance.full_time,'N')
539: ,NVL(p_qua_attendance(1).full_time,'N')) THEN
540: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,65);
541: RETURN TRUE;
542: END IF;
543: IF field_changed(v_attendance.attribute_category
544: ,p_qua_attendance(1).attribute_category) THEN

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

541: RETURN TRUE;
542: END IF;
543: IF field_changed(v_attendance.attribute_category
544: ,p_qua_attendance(1).attribute_category) THEN
545: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,70);
546: RETURN TRUE;
547: END IF;
548: IF field_changed(v_attendance.attribute1
549: ,p_qua_attendance(1).attribute1) THEN

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

546: RETURN TRUE;
547: END IF;
548: IF field_changed(v_attendance.attribute1
549: ,p_qua_attendance(1).attribute1) THEN
550: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,75);
551: RETURN TRUE;
552: END IF;
553: IF field_changed(v_attendance.attribute2
554: ,p_qua_attendance(1).attribute2) THEN

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

551: RETURN TRUE;
552: END IF;
553: IF field_changed(v_attendance.attribute2
554: ,p_qua_attendance(1).attribute2) THEN
555: hr_utility.set_location('if field_changed(..,..), RETURN TRUE:'||l_proc,85);
556: RETURN TRUE;
557: END IF;
558: IF field_changed(v_attendance.attribute3
559: ,p_qua_attendance(1).attribute3) THEN

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

904:
905:
906: l_subject_count := p_qua_subjects.count;
907:
908: hr_utility.set_location('Entering For Loop:'||l_proc,100);
909: FOR i IN 1..l_subject_count LOOP
910: IF p_qua_subjects(i).subjects_taken_id IS null AND
911: p_qua_subjects(i).delete_flag = 'N' THEN
912: --a new subject is added

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

1121: RETURN TRUE;
1122: END IF;
1123: END IF;
1124: END LOOP;
1125: hr_utility.set_location('Exiting For Loop:'||l_proc,105);
1126: hr_utility.set_location('Exiting:'||l_proc, 110);
1127:
1128: RETURN FALSE;
1129:

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

1122: END IF;
1123: END IF;
1124: END LOOP;
1125: hr_utility.set_location('Exiting For Loop:'||l_proc,105);
1126: hr_utility.set_location('Exiting:'||l_proc, 110);
1127:
1128: RETURN FALSE;
1129:
1130: END is_entire_qua_changed;

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

1144: l_proc varchar2(72) := g_package||'delete_transaction_step';
1145:
1146: begin
1147:
1148: hr_utility.set_location('Entering:'||l_proc, 5);
1149: l_transaction_id := hr_transaction_ss.get_transaction_id
1150: (p_item_type => p_item_type
1151: ,p_item_key => p_item_key);
1152: if l_transaction_id is not null then

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

1149: l_transaction_id := hr_transaction_ss.get_transaction_id
1150: (p_item_type => p_item_type
1151: ,p_item_key => p_item_key);
1152: if l_transaction_id is not null then
1153: hr_utility.set_location('l_transaction_id is not null:'||l_proc,10);
1154: open c_get_transaction_step_id(l_transaction_id);
1155: fetch c_get_transaction_step_id into l_transaction_step_id;
1156: close c_get_transaction_step_id;
1157: if l_transaction_step_id is not null then

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

1154: open c_get_transaction_step_id(l_transaction_id);
1155: fetch c_get_transaction_step_id into l_transaction_step_id;
1156: close c_get_transaction_step_id;
1157: if l_transaction_step_id is not null then
1158: hr_utility.set_location('if l_transaction_step_id is not null:'||l_proc,15);
1159: hr_transaction_ss.delete_transaction_step
1160: (l_transaction_step_id,null,p_creator_person_id);
1161: end if;
1162: end if;

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

1160: (l_transaction_step_id,null,p_creator_person_id);
1161: end if;
1162: end if;
1163:
1164: hr_utility.set_location('Exiting:'||l_proc, 20);
1165: end delete_transaction_step;
1166:
1167:
1168: -- start of function decode_value

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

1172: p_false in varchar2)
1173: return varchar2 is
1174: l_proc varchar2(72) := g_package||'decode_value';
1175: Begin
1176: hr_utility.set_location('Entering:'||l_proc, 5);
1177: if p_expression then
1178: hr_utility.set_location('if p_expression= true:'||l_proc,10);
1179: return p_true;
1180: else

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

1174: l_proc varchar2(72) := g_package||'decode_value';
1175: Begin
1176: hr_utility.set_location('Entering:'||l_proc, 5);
1177: if p_expression then
1178: hr_utility.set_location('if p_expression= true:'||l_proc,10);
1179: return p_true;
1180: else
1181: hr_utility.set_location('if p_expression=false:'||l_proc,15);
1182: return p_false;

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

1177: if p_expression then
1178: hr_utility.set_location('if p_expression= true:'||l_proc,10);
1179: return p_true;
1180: else
1181: hr_utility.set_location('if p_expression=false:'||l_proc,15);
1182: return p_false;
1183: end if;
1184: Exception
1185: when others then

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

1182: return p_false;
1183: end if;
1184: Exception
1185: when others then
1186: hr_utility.set_location('Exception:Others'||l_proc,555);
1187: rollback;
1188: raise;
1189: end decode_value;
1190:

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

1210: l_proc varchar2(72) := g_package||'get_qualification_type';
1211:
1212: BEGIN
1213:
1214: hr_utility.set_location('Entering:'||l_proc, 5);
1215: OPEN csr_qua_type;
1216: FETCH csr_qua_type INTO l_name;
1217: CLOSE csr_qua_type;
1218:

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

1215: OPEN csr_qua_type;
1216: FETCH csr_qua_type INTO l_name;
1217: CLOSE csr_qua_type;
1218:
1219: hr_utility.set_location('Exiting:'||l_proc, 10);
1220: RETURN l_name;
1221:
1222: Exception
1223: when others then

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

1220: RETURN l_name;
1221:
1222: Exception
1223: when others then
1224: hr_utility.set_location('Exception:Others'||l_proc,555);
1225: rollback;
1226: raise;
1227: END get_qualification_type;
1228:

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

1259: l_proc varchar2(72) := g_package||'get_pending_transaction_ids';
1260:
1261: BEGIN
1262:
1263: hr_utility.set_location('Entering:'||l_proc, 5);
1264: hr_qua_awards_util_ss.get_pending_transaction_steps
1265: (p_item_type => p_item_type
1266: ,p_selected_person_id => p_selected_person_id
1267: ,p_mode => p_mode

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

1274: p_qualifications := SSHR_QUA_TAB_TYP();
1275: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();
1276: p_transaction_steps := SSHR_TRN_TAB_TYP();
1277:
1278: hr_utility.set_location('Entering For Loop:'||l_proc,10);
1279: FOR i IN 1..l_total_rec_count LOOP
1280: if l_transaction_step_id(i) is not null then
1281: --
1282: --get entire qualification data from transaction table

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

1299:
1300: end if;
1301:
1302: END LOOP;
1303: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1304: hr_utility.set_location('Exiting:'||l_proc, 20);
1305: Exception
1306:
1307: when others then

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

1300: end if;
1301:
1302: END LOOP;
1303: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1304: hr_utility.set_location('Exiting:'||l_proc, 20);
1305: Exception
1306:
1307: when others then
1308: hr_utility.set_location('Exception:Others'||l_proc,555);

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

1304: hr_utility.set_location('Exiting:'||l_proc, 20);
1305: Exception
1306:
1307: when others then
1308: hr_utility.set_location('Exception:Others'||l_proc,555);
1309: rollback;
1310: raise;
1311: END get_pending_transaction_ids;
1312:

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

1338: l_proc varchar2(72) := g_package||'is_qualification_in_pending';
1339:
1340: Begin
1341:
1342: hr_utility.set_location('Entering:'||l_proc, 5);
1343: get_pending_transaction_steps
1344: (p_item_type => p_item_type
1345: ,p_selected_person_id => p_selected_person_id
1346: ,p_mode => p_mode

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

1349: ,p_transaction_step_id => l_transaction_step_id);
1350:
1351: l_pending_found := 'N';
1352:
1353: hr_utility.set_location('Entering For Loop:'||l_proc,10);
1354: FOR i IN 1..NVL(l_transaction_step_id.count,0) LOOP
1355: l_qualification_id :=
1356: hr_transaction_api.get_varchar2_value
1357: (p_transaction_step_id => l_transaction_step_id(i)

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

1360: l_pending_found := 'Y';
1361: EXIT;
1362: END IF;
1363: END LOOP;
1364: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1365:
1366: hr_utility.set_location('Exiting:'||l_proc, 15);
1367: RETURN l_pending_found;
1368:

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

1362: END IF;
1363: END LOOP;
1364: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
1365:
1366: hr_utility.set_location('Exiting:'||l_proc, 15);
1367: RETURN l_pending_found;
1368:
1369: Exception
1370: when others then

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

1367: RETURN l_pending_found;
1368:
1369: Exception
1370: when others then
1371: hr_utility.set_location('Exception:Others'||l_proc,555);
1372: raise;
1373: end is_qualification_in_pending;
1374:
1375: -- end of function is_qualification_in_pending

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

1406: -- start of begin for validate_qualification
1407:
1408: Begin
1409:
1410: hr_utility.set_location('Entering:'||l_proc, 5);
1411: if p_validate = 'Y' then
1412: hr_utility.set_location('p_validate = N:'||l_proc,10);
1413: l_validate := true;
1414: else

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

1408: Begin
1409:
1410: hr_utility.set_location('Entering:'||l_proc, 5);
1411: if p_validate = 'Y' then
1412: hr_utility.set_location('p_validate = N:'||l_proc,10);
1413: l_validate := true;
1414: else
1415: l_validate := false;
1416: end if;

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

1417:
1418: --check if there are any changes
1419: if p_qualifications(1).delete_flag is null or
1420: p_qualifications(1).delete_flag = 'N' then
1421: hr_utility.set_location('delete_flag = N:'||l_proc,15);
1422: l_changed := is_entire_qua_changed
1423: (p_qualifications => p_qualifications
1424: ,p_qua_subjects => p_qua_subjects
1425: ,p_qua_attendance => p_qua_attendance);

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

1423: (p_qualifications => p_qualifications
1424: ,p_qua_subjects => p_qua_subjects
1425: ,p_qua_attendance => p_qua_attendance);
1426: IF l_changed = FALSE THEN
1427: hr_utility.set_location('l_changed = FALSE THEN:'||l_proc,25);
1428: delete_transaction_step
1429: (p_item_type => p_item_type
1430: ,p_item_key => p_item_key
1431: ,p_creator_person_id => p_creator_person_id);

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

1432: END IF;
1433: end if;
1434:
1435: if l_changed = TRUE THEN
1436: hr_utility.set_location('l_changed = TRUE THEN:'||l_proc,30);
1437: if (p_qualifications(1).delete_flag is null or
1438: p_qualifications(1).delete_flag = 'N')
1439: and p_save_mode <> 'SAVE_FOR_LATER'
1440: then

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

1437: if (p_qualifications(1).delete_flag is null or
1438: p_qualifications(1).delete_flag = 'N')
1439: and p_save_mode <> 'SAVE_FOR_LATER'
1440: then
1441: hr_utility.set_location('Delete flag = N and not SFL'||l_proc,35);
1442: hr_qua_awards_util_ss.check_errors
1443: (p_ignore_sub_date_boundaries => 'N'
1444: ,p_mode => p_mode
1445: ,p_qualifications => p_qualifications

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

1449: ,p_subjects_error_message => p_subjects_error_message);
1450:
1451: if nvl(length(p_error_message),0) > 0 or
1452: nvl(length(p_subjects_error_message),0) > 0 then
1453: hr_utility.set_location('Exception:l_app_exception'||l_proc,555);
1454: raise l_app_exception;
1455: end if;
1456: end if;
1457:

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

1458: --should not do validation if user wants to delete the current qualification.
1459: if (p_qualifications(1).delete_flag is null or
1460: p_qualifications(1).delete_flag = 'N') and
1461: p_save_mode <> 'SAVE_FOR_LATER' then
1462: hr_utility.set_location('Delete flag = N and not SFL'||l_proc,40);
1463: hr_qua_awards_util_ss.validate_api
1464: (p_validate => l_validate
1465: ,p_mode => p_mode
1466: ,p_selected_person_id => p_selected_person_id

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

1472: end if; --l_changed
1473:
1474: if l_changed = TRUE or p_qualifications(1).delete_flag = 'Y' THEN
1475:
1476: hr_utility.set_location('Delete flag = Y or changed=True'||l_proc,40);
1477: hr_qua_awards_util_ss.save_transaction_step
1478: (p_item_type => p_item_type
1479: ,p_item_key => p_item_key
1480: ,p_actid => to_number(p_act_id)

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

1489: end if;
1490:
1491: Exception
1492: when l_app_exception then
1493: hr_utility.set_location('Exception:l_app_exception'||l_proc,555);
1494: rollback;
1495: -- Fix bug 2899882.
1496: -- should directly raise error. Otherwise the tokens in the messages are
1497: -- lost.

Line 1498: --when hr_utility.hr_error then

1494: rollback;
1495: -- Fix bug 2899882.
1496: -- should directly raise error. Otherwise the tokens in the messages are
1497: -- lost.
1498: --when hr_utility.hr_error then
1499: -- hr_message.provide_error;
1500: -- p_error_message := nvl(p_error_message,'')||'!'||'|'||'PAGE'||'|'||
1501: -- hr_message.last_message_app||'|'||hr_message.last_message_name||
1502: -- '|'||'!';

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

1501: -- hr_message.last_message_app||'|'||hr_message.last_message_name||
1502: -- '|'||'!';
1503: -- rollback;
1504: when others then
1505: hr_utility.set_location('Exception:Others'||l_proc,555);
1506: rollback;
1507: -- Bug Fix 3103716
1508: l_error_message := hr_utility.get_message;
1509: IF l_error_message is null THEN

Line 1508: l_error_message := hr_utility.get_message;

1504: when others then
1505: hr_utility.set_location('Exception:Others'||l_proc,555);
1506: rollback;
1507: -- Bug Fix 3103716
1508: l_error_message := hr_utility.get_message;
1509: IF l_error_message is null THEN
1510: raise;
1511: ELSE
1512: p_error_message := nvl(p_error_message,'')||'!'||'|'||'PAGE'||'|'||'PER'||'|'|| l_error_message ||'|_ValidateAPIError|'||'!';

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

1510: raise;
1511: ELSE
1512: p_error_message := nvl(p_error_message,'')||'!'||'|'||'PAGE'||'|'||'PER'||'|'|| l_error_message ||'|_ValidateAPIError|'||'!';
1513: END IF;
1514: hr_utility.set_location('Exiting:'||l_proc, 45);
1515: End; -- end of validate_qualification
1516:
1517: -- end of procedure validate_qualification
1518:

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

1539:
1540: BEGIN
1541:
1542:
1543: hr_utility.set_location('Entering:'||l_proc, 5);
1544: hr_qua_awards_util_ss.start_transaction
1545: (itemtype => p_item_type
1546: ,itemkey => p_item_key
1547: ,actid => p_actid

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

2154: ,p_person_id => p_creator_person_id
2155: ,p_name => 'P_SUBJECT_COUNT'
2156: ,p_value => l_subject_count);
2157:
2158: hr_utility.set_location('Entering For Loop:'||l_proc,10);
2159: FOR i IN 1..l_subject_count LOOP
2160:
2161: hr_transaction_api.set_varchar2_value
2162: (p_transaction_step_id => p_transaction_step_id

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

2425: ,p_name => 'P_SUB_INFORMATION20_PST'||i
2426: ,p_value => p_qua_subjects(i).sub_information20);
2427:
2428: END LOOP;
2429: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
2430:
2431: hr_transaction_api.set_varchar2_value
2432: (p_transaction_step_id => p_transaction_step_id
2433: ,p_person_id => p_creator_person_id

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

2439: ,p_person_id => p_creator_person_id
2440: ,p_name => 'P_REVIEW_ACTID'
2441: ,p_value => p_actid);
2442:
2443: hr_utility.set_location('Exiting:'||l_proc, 20);
2444: Exception
2445: when others then
2446: hr_utility.set_location('Exception:Others'||l_proc,555);
2447: rollback;

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

2442:
2443: hr_utility.set_location('Exiting:'||l_proc, 20);
2444: Exception
2445: when others then
2446: hr_utility.set_location('Exception:Others'||l_proc,555);
2447: rollback;
2448: raise;
2449: END save_transaction_step;
2450:

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

2567: l_changed boolean;
2568:
2569: BEGIN
2570:
2571: hr_utility.set_location('Entering:'||l_proc, 5);
2572: savepoint validate_qua;
2573:
2574: l_old_attendance_id := p_qualifications(1).attendance_id;
2575:

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

2577:
2578: --check if attendance already exists
2579: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
2580:
2581: hr_utility.set_location('p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN:'||l_proc,10);
2582: l_establishment_id := p_qua_attendance(1).establishment_id;
2583:
2584: --if the school is entered (not picked from the LOV),
2585: if l_establishment_id is null then

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

2582: l_establishment_id := p_qua_attendance(1).establishment_id;
2583:
2584: --if the school is entered (not picked from the LOV),
2585: if l_establishment_id is null then
2586: hr_utility.set_location('l_establishment_id is null then:'||l_proc,20);
2587: OPEN csr_get_establishment_id(p_qua_attendance(1).establishment);
2588: FETCH csr_get_establishment_id into l_school_name_id;
2589: IF csr_get_establishment_id%FOUND THEN
2590: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,25);

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

2586: hr_utility.set_location('l_establishment_id is null then:'||l_proc,20);
2587: OPEN csr_get_establishment_id(p_qua_attendance(1).establishment);
2588: FETCH csr_get_establishment_id into l_school_name_id;
2589: IF csr_get_establishment_id%FOUND THEN
2590: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,25);
2591: l_establishment_id := l_school_name_id;
2592: FETCH csr_get_establishment_id into l_school_name_id;
2593: IF csr_get_establishment_id%FOUND THEN
2594: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,30);

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

2590: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,25);
2591: l_establishment_id := l_school_name_id;
2592: FETCH csr_get_establishment_id into l_school_name_id;
2593: IF csr_get_establishment_id%FOUND THEN
2594: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,30);
2595: CLOSE csr_get_establishment_id;
2596: fnd_message.set_name('PER','HR_SCHOOL_NAME_NOT_UNIQUE');
2597: hr_utility.raise_error;
2598: END IF;

Line 2597: hr_utility.raise_error;

2593: IF csr_get_establishment_id%FOUND THEN
2594: hr_utility.set_location('csr_get_establishment_id%FOUND:'||l_proc,30);
2595: CLOSE csr_get_establishment_id;
2596: fnd_message.set_name('PER','HR_SCHOOL_NAME_NOT_UNIQUE');
2597: hr_utility.raise_error;
2598: END IF;
2599: ELSE
2600: l_new_school_allowed := fnd_profile.value('HR_SSHR_NEW_SCHOOL');
2601: if l_new_school_allowed = 'N' THEN

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

2598: END IF;
2599: ELSE
2600: l_new_school_allowed := fnd_profile.value('HR_SSHR_NEW_SCHOOL');
2601: if l_new_school_allowed = 'N' THEN
2602: hr_utility.set_location('l_new_school_allowed=N:'||l_proc,35);
2603: CLOSE csr_get_establishment_id;
2604: fnd_message.set_name('PER','HR_SCHOOL_NAME_NOT_EXIST');
2605: hr_utility.raise_error;
2606: END IF;

Line 2605: hr_utility.raise_error;

2601: if l_new_school_allowed = 'N' THEN
2602: hr_utility.set_location('l_new_school_allowed=N:'||l_proc,35);
2603: CLOSE csr_get_establishment_id;
2604: fnd_message.set_name('PER','HR_SCHOOL_NAME_NOT_EXIST');
2605: hr_utility.raise_error;
2606: END IF;
2607: END IF;
2608: CLOSE csr_get_establishment_id;
2609: end if;

Line 2624: hr_utility.raise_error;

2620: FETCH c1 into l_dummy;
2621: if c1%found then
2622: close c1;
2623: fnd_message.set_name('PAY','HR_51847_QUA_REC_EXISTS');
2624: hr_utility.raise_error;
2625: end if;
2626: CLOSE c1;
2627:
2628: OPEN csr_attendance

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

2651: if p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
2652:
2653: if l_attendance_id IS null THEN
2654:
2655: hr_utility.set_location('qualification id is null,mode is EDUCATION,attendance id is null:'||l_proc,45);
2656: --attendance is not exist, then insert a new one
2657: --hr_qua_awards_util_ss.ins
2658: per_esa_ins.ins
2659: (p_validate => FALSE

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

2776: ,p_qua_information20 => p_qualifications(1).qua_information20
2777: );
2778:
2779: --insert subject for both qua and award
2780: hr_utility.set_location('Entering For Loop:'||l_proc,55);
2781: for i in 1..NVL(p_qua_subjects.count, 0) loop
2782: if p_qua_subjects(i).delete_flag = 'N' then
2783: per_sub_ins.ins
2784: (p_validate => FALSE

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

2842: ,p_grade_attained => p_qua_subjects(i).grade_attained
2843: );
2844: end if;
2845: end loop;
2846: hr_utility.set_location('Exiting For Loop:'||l_proc,60);
2847: else --update an existing qua or award
2848:
2849: l_pq_object_version_number := p_qualifications(1).object_version_number;
2850: l_pea_object_version_number := p_qua_attendance(1).object_version_number;

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

3028: ,p_qua_information20 => p_qualifications(1).qua_information20
3029: );
3030:
3031: -- update subject record for both qua and award
3032: hr_utility.set_location('Entering For Loop:'||l_proc,65);
3033: FOR i IN 1..NVL(p_qua_subjects.count, 0) LOOP
3034: l_subjects_taken_id := p_qua_subjects(i).subjects_taken_id;
3035: l_pst_object_version_number :=
3036: p_qua_subjects(i).object_version_number;

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

3171: ,p_object_version_number => l_pst_object_version_number);
3172: END IF;
3173: END IF;
3174: END LOOP;
3175: hr_utility.set_location('Exiting For Loop:'||l_proc,70);
3176: END IF;
3177:
3178: IF p_validate = TRUE THEN
3179: rollback to validate_qua;

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

3177:
3178: IF p_validate = TRUE THEN
3179: rollback to validate_qua;
3180: END IF;
3181: hr_utility.set_location('Exiting:'||l_proc, 15);
3182: EXCEPTION
3183: WHEN OTHERS THEN
3184: hr_utility.set_location('Exception:Others'||l_proc,555);
3185: rollback to validate_qua;

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

3180: END IF;
3181: hr_utility.set_location('Exiting:'||l_proc, 15);
3182: EXCEPTION
3183: WHEN OTHERS THEN
3184: hr_utility.set_location('Exception:Others'||l_proc,555);
3185: rollback to validate_qua;
3186: raise;
3187: END validate_api;
3188:

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

3216: transaction_id = l_transaction_id;
3217:
3218: Begin
3219:
3220: hr_utility.set_location('Entering:'||l_proc, 5);
3221: if funmode = 'RUN' then
3222: hr_utility.set_location('funmode=RUN:'||l_proc,10);
3223: savepoint start_transaction;
3224:

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

3218: Begin
3219:
3220: hr_utility.set_location('Entering:'||l_proc, 5);
3221: if funmode = 'RUN' then
3222: hr_utility.set_location('funmode=RUN:'||l_proc,10);
3223: savepoint start_transaction;
3224:
3225: -- check to see if the TRANSACTION_ID attribute has been created
3226: if hr_workflow_utility.item_attribute_exists

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

3236: ,p_item_key => itemkey) is not null then
3237:
3238: -- a current transaction is in progress we cannot overwrite it
3239: -- get the Transaction Step Id
3240: hr_utility.set_location('If itemtype and itemKey is not null:'||l_proc,15);
3241: l_transaction_id := hr_transaction_ss.get_transaction_id
3242: (p_item_type => itemtype
3243: ,p_item_key => itemkey);
3244: open c_get_transaction_step_id;

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

3263: elsif funmode = 'CANCEL' then
3264: null;
3265: end if;
3266:
3267: hr_utility.set_location('Exiting:'||l_proc, 20);
3268: Exception
3269: when others then
3270: hr_utility.set_location('Exception:Others'||l_proc,555);
3271: rollback to start_transaction;

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

3266:
3267: hr_utility.set_location('Exiting:'||l_proc, 20);
3268: Exception
3269: when others then
3270: hr_utility.set_location('Exception:Others'||l_proc,555);
3271: rollback to start_transaction;
3272: raise;
3273: End start_transaction;
3274:

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

3300: l_count integer;
3301: l_active_wf_items_list hr_workflow_service.active_wf_trans_items_list;
3302: l_proc varchar2(72) := g_package||'get_pending_items';
3303: Begin
3304: hr_utility.set_location('Entering:'||l_proc, 5);
3305: l_count := 0;
3306: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3307: For I in csr_pending_items Loop
3308: l_count := l_count + 1;

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

3302: l_proc varchar2(72) := g_package||'get_pending_items';
3303: Begin
3304: hr_utility.set_location('Entering:'||l_proc, 5);
3305: l_count := 0;
3306: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3307: For I in csr_pending_items Loop
3308: l_count := l_count + 1;
3309: l_active_wf_items_list(l_count).active_item_key := I.item_key;
3310: l_active_wf_items_list(l_count).activity_id := I.activity_id;

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

3309: l_active_wf_items_list(l_count).active_item_key := I.item_key;
3310: l_active_wf_items_list(l_count).activity_id := I.activity_id;
3311: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;
3312: End Loop;
3313: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3314: hr_utility.set_location('Exiting:'||l_proc, 20);
3315: return l_active_wf_items_list;
3316: End get_pending_items;
3317:

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

3310: l_active_wf_items_list(l_count).activity_id := I.activity_id;
3311: l_active_wf_items_list(l_count).trans_step_id := I.transaction_step_id;
3312: End Loop;
3313: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3314: hr_utility.set_location('Exiting:'||l_proc, 20);
3315: return l_active_wf_items_list;
3316: End get_pending_items;
3317:
3318: -- Start of Procedure get_pending_transaction_steps

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

3334: l_result_code varchar2(30);
3335: l_proc varchar2(72) := g_package||'get_pending_transaction_steps';
3336:
3337: BEGIN
3338: hr_utility.set_location('Entering:'||l_proc, 5);
3339:
3340: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3341: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);
3342: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;

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

3337: BEGIN
3338: hr_utility.set_location('Entering:'||l_proc, 5);
3339:
3340: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3341: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);
3342: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;
3343: ELSE
3344: hr_utility.set_location('mode!=Education:'||l_proc,15);
3345: l_result_code := HR_QUA_AWARDS_UTIL_SS.AWARD_CHANGED;

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

3340: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3341: hr_utility.set_location('mode=EDUCATION :'||l_proc,10);
3342: l_result_code := HR_QUA_AWARDS_UTIL_SS.EDUCATION_CHANGED;
3343: ELSE
3344: hr_utility.set_location('mode!=Education:'||l_proc,15);
3345: l_result_code := HR_QUA_AWARDS_UTIL_SS.AWARD_CHANGED;
3346: END IF;
3347:
3348: l_active_item_keys :=

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

3354: );
3355:
3356: l_pending_count := NVL(l_active_item_keys.count,0);
3357:
3358: hr_utility.set_location('Entering For Loop:'||l_proc,20);
3359: FOR i IN 1..l_pending_count LOOP
3360: p_transaction_step_id(j) := l_active_item_keys(i).trans_step_id;
3361: j := j +1;
3362: END LOOP;

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

3359: FOR i IN 1..l_pending_count LOOP
3360: p_transaction_step_id(j) := l_active_item_keys(i).trans_step_id;
3361: j := j +1;
3362: END LOOP;
3363: hr_utility.set_location('Exiting For Loop:'||l_proc,25);
3364:
3365: hr_utility.set_location('Exiting:'||l_proc, 30);
3366: END get_pending_transaction_steps;
3367:

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

3361: j := j +1;
3362: END LOOP;
3363: hr_utility.set_location('Exiting For Loop:'||l_proc,25);
3364:
3365: hr_utility.set_location('Exiting:'||l_proc, 30);
3366: END get_pending_transaction_steps;
3367:
3368:
3369: -- End of Procedure get_pending_transaction_steps

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

3420:
3421:
3422: BEGIN
3423:
3424: hr_utility.set_location('Entering:'||l_proc, 5);
3425: BEGIN
3426: l_length := length(p_qualifications(1).comments);
3427: IF l_length > 2000 THEN
3428: --fnd_message.set_name('PER','HR_COMMENT_EXCEED_MAX_LENGTH');

Line 3429: --hr_utility.raise_error;

3425: BEGIN
3426: l_length := length(p_qualifications(1).comments);
3427: IF l_length > 2000 THEN
3428: --fnd_message.set_name('PER','HR_COMMENT_EXCEED_MAX_LENGTH');
3429: --hr_utility.raise_error;
3430: hr_utility.set_location('length>2000:'||l_proc,10);
3431: p_error_message := nvl(p_error_message,'')||'!'||'|'||'Comments'||'|'||'PER'||'|'||'HR_COMMENT_EXCEED_MAX_LENGTH'||'|'||'!';
3432: END IF;
3433: EXCEPTION

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

3426: l_length := length(p_qualifications(1).comments);
3427: IF l_length > 2000 THEN
3428: --fnd_message.set_name('PER','HR_COMMENT_EXCEED_MAX_LENGTH');
3429: --hr_utility.raise_error;
3430: hr_utility.set_location('length>2000:'||l_proc,10);
3431: p_error_message := nvl(p_error_message,'')||'!'||'|'||'Comments'||'|'||'PER'||'|'||'HR_COMMENT_EXCEED_MAX_LENGTH'||'|'||'!';
3432: END IF;
3433: EXCEPTION
3434: WHEN OTHERS THEN

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

3431: p_error_message := nvl(p_error_message,'')||'!'||'|'||'Comments'||'|'||'PER'||'|'||'HR_COMMENT_EXCEED_MAX_LENGTH'||'|'||'!';
3432: END IF;
3433: EXCEPTION
3434: WHEN OTHERS THEN
3435: hr_utility.set_location('Exception:Others'||l_proc,555);
3436: raise;
3437: END;
3438:
3439: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

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

3443: -- CHK_ATT_OVERLAP
3444: -- CHK_ATTENDED_START_DATE
3445: -- CHK_ATTENDED_END_DATE
3446: -- CHK_ATT_TO_DATE
3447: hr_utility.set_location('mode is Education:'||l_proc,20);
3448: l_pea_date_error := FALSE;
3449:
3450: BEGIN
3451: IF p_qua_attendance(1).attended_start_date is not null and

Line 3456: --hr_utility.raise_error;

3452: p_qua_attendance(1).attended_end_date is not null and
3453: p_qua_attendance(1).attended_start_date >
3454: p_qua_attendance(1).attended_end_date THEN
3455: --fnd_message.set_name('PER','HR_51496_ESA_ATT_END_DATE');
3456: --hr_utility.raise_error;
3457: hr_utility.set_location('Startdate>EndDate:'||l_proc,25);
3458: p_error_message := nvl(p_error_message,'')||'!'||'|'||'AttendedStartDate'||'|'||'PER'||'|'||'HR_51496_ESA_ATT_END_DATE'||'|'||'!';
3459: END IF;
3460: EXCEPTION

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

3453: p_qua_attendance(1).attended_start_date >
3454: p_qua_attendance(1).attended_end_date THEN
3455: --fnd_message.set_name('PER','HR_51496_ESA_ATT_END_DATE');
3456: --hr_utility.raise_error;
3457: hr_utility.set_location('Startdate>EndDate:'||l_proc,25);
3458: p_error_message := nvl(p_error_message,'')||'!'||'|'||'AttendedStartDate'||'|'||'PER'||'|'||'HR_51496_ESA_ATT_END_DATE'||'|'||'!';
3459: END IF;
3460: EXCEPTION
3461: WHEN OTHERS THEN

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

3458: p_error_message := nvl(p_error_message,'')||'!'||'|'||'AttendedStartDate'||'|'||'PER'||'|'||'HR_51496_ESA_ATT_END_DATE'||'|'||'!';
3459: END IF;
3460: EXCEPTION
3461: WHEN OTHERS THEN
3462: hr_utility.set_location('Exception:Others'||l_proc,555);
3463: l_pea_date_error := TRUE;
3464: raise;
3465: END;
3466:

Line 3484: --hr_utility.raise_error;

3480: p_qualifications(1).end_date is not null and
3481: p_qualifications(1).start_date > p_qualifications(1).end_date
3482: THEN
3483: --fnd_message.set_name('PAY','HR_51853_QUA_DATE_INV');
3484: --hr_utility.raise_error;
3485: hr_utility.set_location('StartDate>endDate:'||l_proc,30);
3486: p_error_message := nvl(p_error_message,'')||'!'||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51853_QUA_DATE_INV'||'|'||'!';
3487: END IF;
3488: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN

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

3481: p_qualifications(1).start_date > p_qualifications(1).end_date
3482: THEN
3483: --fnd_message.set_name('PAY','HR_51853_QUA_DATE_INV');
3484: --hr_utility.raise_error;
3485: hr_utility.set_location('StartDate>endDate:'||l_proc,30);
3486: p_error_message := nvl(p_error_message,'')||'!'||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51853_QUA_DATE_INV'||'|'||'!';
3487: END IF;
3488: IF p_mode = HR_QUA_AWARDS_UTIL_SS.EDUCATION THEN
3489: IF p_qualifications(1).start_date is not null and

Line 3494: --hr_utility.raise_error;

3490: p_qua_attendance(1).attended_start_date is not null and
3491: p_qualifications(1).start_date < p_qua_attendance(1).attended_start_date
3492: THEN
3493: --fnd_message.set_name('PAY','HR_51841_QUA_DATES_OUT_ESA');
3494: --hr_utility.raise_error;
3495: hr_utility.set_location('startdate 3496: p_error_message := nvl(p_error_message,'')||'!'||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51841_QUA_DATES_OUT_ESA'||'|'||'!';
3497: END IF;
3498: IF p_qualifications(1).end_date is not null

Line 3495: hr_utility.set_location('startdate

3491: p_qualifications(1).start_date < p_qua_attendance(1).attended_start_date
3492: THEN
3493: --fnd_message.set_name('PAY','HR_51841_QUA_DATES_OUT_ESA');
3494: --hr_utility.raise_error;
3495: hr_utility.set_location('startdate 3496: p_error_message := nvl(p_error_message,'')||'!'||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51841_QUA_DATES_OUT_ESA'||'|'||'!';
3497: END IF;
3498: IF p_qualifications(1).end_date is not null
3499: and p_qua_attendance(1).attended_end_date is not null

Line 3503: --hr_utility.raise_error;

3499: and p_qua_attendance(1).attended_end_date is not null
3500: and p_qualifications(1).end_date > p_qua_attendance(1).attended_end_date
3501: THEN
3502: --fnd_message.set_name('PAY','HR_51841_QUA_DATES_OUT_ESA');
3503: --hr_utility.raise_error;
3504: hr_utility.set_location('end_date>attended_end_date:'||l_proc,40);
3505: p_error_message := nvl(p_error_message,'')||'!'||'|'||'EndDate'||'|'||'PAY'||'|'||'HR_51841_QUA_DATES_OUT_ESA'||'|'||'!';
3506: END IF;
3507: END IF;

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

3500: and p_qualifications(1).end_date > p_qua_attendance(1).attended_end_date
3501: THEN
3502: --fnd_message.set_name('PAY','HR_51841_QUA_DATES_OUT_ESA');
3503: --hr_utility.raise_error;
3504: hr_utility.set_location('end_date>attended_end_date:'||l_proc,40);
3505: p_error_message := nvl(p_error_message,'')||'!'||'|'||'EndDate'||'|'||'PAY'||'|'||'HR_51841_QUA_DATES_OUT_ESA'||'|'||'!';
3506: END IF;
3507: END IF;
3508: END IF;

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

3512: --
3513: -- Business Rule Mapping
3514: -- =====================
3515: -- CHK_QUAL_OVERLAP
3516: hr_utility.set_location('date_error=FALSE:'||l_proc,45);
3517: OPEN c1(p_qualifications(1).start_date,
3518: p_qualifications(1).end_date,
3519: p_qualifications(1).person_id,
3520: p_qualifications(1).business_group_id,

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

3523: p_qualifications(1).title,
3524: p_qualifications(1).qualification_id);
3525: FETCH c1 into l_dummy;
3526: if c1%found then
3527: hr_utility.set_location('c1%found:'||l_proc,50);
3528: close c1;
3529: fnd_message.set_name('PAY','HR_51847_QUA_REC_EXISTS');
3530: hr_utility.raise_error;
3531: end if;

Line 3530: hr_utility.raise_error;

3526: if c1%found then
3527: hr_utility.set_location('c1%found:'||l_proc,50);
3528: close c1;
3529: fnd_message.set_name('PAY','HR_51847_QUA_REC_EXISTS');
3530: hr_utility.raise_error;
3531: end if;
3532: CLOSE c1;
3533: EXCEPTION
3534: WHEN OTHERS THEN

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

3531: end if;
3532: CLOSE c1;
3533: EXCEPTION
3534: WHEN OTHERS THEN
3535: hr_utility.set_location('Exception:Others'||l_proc,555);
3536: raise;
3537: END;
3538: END IF;
3539: --

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

3549: p_fee_currency => p_qualifications(1).fee_currency,
3550: p_object_version_number => p_qualifications(1).object_version_number);
3551: EXCEPTION
3552: WHEN OTHERS THEN
3553: hr_utility.set_location('Exception:Others'||l_proc,555);
3554: raise;
3555: END;
3556: END IF;
3557:

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

3568: p_start_date => p_qualifications(1).start_date,
3569: p_object_version_number => p_qualifications(1).object_version_number);
3570: EXCEPTION
3571: WHEN OTHERS THEN
3572: hr_utility.set_location('Exception:Others'||l_proc,555);
3573: raise;
3574: END;
3575: END IF;
3576:

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

3578: -- Business Rule Mapping
3579: -- =====================
3580: -- CHK_START_DATE
3581: -- CHK_END_DATE
3582: hr_utility.set_location('Entering For Loop:'||l_proc,55);
3583: FOR i IN 1..NVL(p_qua_subjects.count,0) LOOP
3584: IF p_qua_subjects(i).delete_flag = 'N' THEN
3585: l_error := FALSE;
3586: IF l_error = FALSE AND l_pq_date_error = FALSE THEN

Line 3597: --hr_utility.raise_error;

3593: p_qua_subjects(i).end_date is not null and
3594: p_qua_subjects(i).start_date > p_qua_subjects(i).end_date
3595: THEN
3596: --fnd_message.set_name('PAY','HR_51816_SUB_START_DATE_INV');
3597: --hr_utility.raise_error;
3598: p_subjects_error_message := nvl(p_subjects_error_message,'')||'!'||'|'||to_char(i-1)||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51816_SUB_START_DATE_INV'||'|'||'!';
3599: END IF;
3600: IF p_ignore_sub_date_boundaries = 'N' THEN
3601: IF p_qua_subjects(i).start_date

Line 3604: --hr_utility.raise_error;

3600: IF p_ignore_sub_date_boundaries = 'N' THEN
3601: IF p_qua_subjects(i).start_date
3602: < p_qualifications(1).start_date THEN
3603: --fnd_message.set_name('PAY','HR_51817_SUB_START_DATE_QUAL');
3604: --hr_utility.raise_error;
3605: p_subjects_error_message := nvl(p_subjects_error_message,'')||'!'||'|'||to_char(i-1)||'|'||'StartDate'||'|'||'PAY'||'|'||'HR_51817_SUB_START_DATE_QUAL'||'|'||'!';
3606: END IF;
3607: END IF;
3608: EXCEPTION

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

3606: END IF;
3607: END IF;
3608: EXCEPTION
3609: WHEN OTHERS THEN
3610: hr_utility.set_location('Exception:Others'||l_proc,555);
3611: raise;
3612: END;
3613: END IF;
3614: END IF;

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

3612: END;
3613: END IF;
3614: END IF;
3615: END LOOP;
3616: hr_utility.set_location('Exiting For Loop:'||l_proc,60);
3617: hr_utility.set_location('Exiting:'||l_proc, 65);
3618: Exception
3619: when others then
3620: hr_utility.set_location('Exception:Others'||l_proc,555);

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

3613: END IF;
3614: END IF;
3615: END LOOP;
3616: hr_utility.set_location('Exiting For Loop:'||l_proc,60);
3617: hr_utility.set_location('Exiting:'||l_proc, 65);
3618: Exception
3619: when others then
3620: hr_utility.set_location('Exception:Others'||l_proc,555);
3621: raise;

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

3616: hr_utility.set_location('Exiting For Loop:'||l_proc,60);
3617: hr_utility.set_location('Exiting:'||l_proc, 65);
3618: Exception
3619: when others then
3620: hr_utility.set_location('Exception:Others'||l_proc,555);
3621: raise;
3622: END check_errors;
3623:
3624: -- end of procedures check_errors

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

3643: l_proc varchar2(72) := g_package||'get_entire_qua';
3644:
3645: BEGIN
3646:
3647: hr_utility.set_location('Entering:'||l_proc, 5);
3648: p_mode :=
3649: hr_transaction_api.get_varchar2_value
3650: (p_transaction_step_id => p_transaction_step_id
3651: ,p_name => 'P_MODE');

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

3656: ,p_name => 'P_SUBJECT_COUNT'));
3657:
3658: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();
3659:
3660: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3661: FOR i IN 1..NVL(l_attendance_count,0) LOOP
3662: p_qua_attendance.extend;
3663: p_qua_attendance(i) := SSHR_QUA_ATTENDANCE_OBJ_TYP(
3664: to_number(hr_transaction_api.get_varchar2_value

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

3755: (p_transaction_step_id => p_transaction_step_id
3756: ,p_name => 'P_PARTY_ID'))
3757: );
3758: END LOOP;
3759: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3760:
3761: p_qualifications := SSHR_QUA_TAB_TYP();
3762:
3763: hr_utility.set_location('Entering For Loop:'||l_proc,20);

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

3759: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
3760:
3761: p_qualifications := SSHR_QUA_TAB_TYP();
3762:
3763: hr_utility.set_location('Entering For Loop:'||l_proc,20);
3764: FOR i IN 1..NVL(l_qua_count,0) LOOP
3765: p_qualifications.extend;
3766: p_qualifications(i) := SSHR_QUA_OBJ_TYP(
3767: to_number(hr_transaction_api.get_varchar2_value

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

3986: (p_transaction_step_id => p_transaction_step_id
3987: ,p_name => 'P_PARTY_ID')
3988: );
3989: END LOOP;
3990: hr_utility.set_location('Exiting For Loop:'||l_proc,25);
3991:
3992:
3993: -- now get the subject details
3994: p_qua_subjects := SSHR_QUA_SUBJECT_TAB_TYP();

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

3992:
3993: -- now get the subject details
3994: p_qua_subjects := SSHR_QUA_SUBJECT_TAB_TYP();
3995:
3996: hr_utility.set_location('Entering For Loop:'||l_proc,30);
3997: FOR i IN 1..NVL(l_subject_count,0) LOOP
3998: p_qua_subjects.extend;
3999: p_qua_subjects(i) := SSHR_QUA_SUBJECT_OBJ_TYP(
4000:

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

4206: ,p_name => 'P_SUB_INFORMATION20_PST'||i)
4207: );
4208:
4209: END LOOP;
4210: hr_utility.set_location('Exiting For Loop:'||l_proc,35);
4211:
4212: EXCEPTION
4213: WHEN OTHERS THEN
4214: hr_utility.set_location('Exception:Others'||l_proc,555);

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

4210: hr_utility.set_location('Exiting For Loop:'||l_proc,35);
4211:
4212: EXCEPTION
4213: WHEN OTHERS THEN
4214: hr_utility.set_location('Exception:Others'||l_proc,555);
4215: RAISE;
4216: END get_entire_qua;
4217:
4218:

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

4224: ) is
4225: l_proc varchar2(72) := g_package||'rollback_transaction_step';
4226:
4227: Begin
4228: hr_utility.set_location('Entering:'||l_proc, 5);
4229: delete from hr_api_transaction_values where transaction_step_id = p_transaction_step_id;
4230: delete from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id;
4231: hr_utility.set_location('Exiting:'||l_proc, 15);
4232:

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

4227: Begin
4228: hr_utility.set_location('Entering:'||l_proc, 5);
4229: delete from hr_api_transaction_values where transaction_step_id = p_transaction_step_id;
4230: delete from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id;
4231: hr_utility.set_location('Exiting:'||l_proc, 15);
4232:
4233: Exception
4234: when others then
4235: hr_utility.set_location('Exception:Others'||l_proc,555);

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

4231: hr_utility.set_location('Exiting:'||l_proc, 15);
4232:
4233: Exception
4234: when others then
4235: hr_utility.set_location('Exception:Others'||l_proc,555);
4236: raise;
4237: End rollback_transaction_step;
4238:
4239: /*

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

4246: l_qualification_id number := 0;
4247: l_proc varchar2(72) := g_package||'get_qualification_id';
4248: Begin
4249:
4250: hr_utility.set_location('Entering:'||l_proc, 5);
4251: l_qualification_id :=
4252: hr_transaction_api.get_varchar2_value
4253: (p_transaction_step_id => p_transaction_step_id
4254: ,p_name => 'p_qualification_id');

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

4252: hr_transaction_api.get_varchar2_value
4253: (p_transaction_step_id => p_transaction_step_id
4254: ,p_name => 'p_qualification_id');
4255:
4256: hr_utility.set_location('Exiting:'||l_proc, 15);
4257: return nvl(l_qualification_id,0);
4258: Exception
4259: when others then
4260: hr_utility.set_location('Exception:Others'||l_proc,555);

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

4256: hr_utility.set_location('Exiting:'||l_proc, 15);
4257: return nvl(l_qualification_id,0);
4258: Exception
4259: when others then
4260: hr_utility.set_location('Exception:Others'||l_proc,555);
4261: raise;
4262: End;
4263:
4264: /*

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

4270:
4271: Begin
4272:
4273: -- delete the old transaction values
4274: hr_utility.set_location('Entering:'||l_proc, 5);
4275: hr_transaction_ss.delete_transaction_step(p_transaction_step_id,null,p_creator_person_id);
4276: hr_utility.set_location('Exiting:'||l_proc, 15);
4277: Exception
4278: when others then

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

4272:
4273: -- delete the old transaction values
4274: hr_utility.set_location('Entering:'||l_proc, 5);
4275: hr_transaction_ss.delete_transaction_step(p_transaction_step_id,null,p_creator_person_id);
4276: hr_utility.set_location('Exiting:'||l_proc, 15);
4277: Exception
4278: when others then
4279: hr_utility.set_location('Exception:Others'||l_proc,555);
4280: raise;

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

4275: hr_transaction_ss.delete_transaction_step(p_transaction_step_id,null,p_creator_person_id);
4276: hr_utility.set_location('Exiting:'||l_proc, 15);
4277: Exception
4278: when others then
4279: hr_utility.set_location('Exception:Others'||l_proc,555);
4280: raise;
4281: End;
4282:
4283: