eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_PROCESS_EMP_REVIEW dependencies on HR_UTILITY

Line 171: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.get_emp_review_details',5);

167:
168:
169: BEGIN
170:
171: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.get_emp_review_details',5);
172: --
173: l_transaction_step_id := to_number(x_transaction_step_id);
174: --
175:

Line 238: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_review_details',10);

234: p_name => 'P_PERSON_ID' );
235:
236: */
237:
238: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_review_details',10);
239: EXCEPTION
240: WHEN hr_utility.hr_error THEN
241: hr_utility.raise_error;
242: WHEN OTHERS THEN

Line 240: WHEN hr_utility.hr_error THEN

236: */
237:
238: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_review_details',10);
239: EXCEPTION
240: WHEN hr_utility.hr_error THEN
241: hr_utility.raise_error;
242: WHEN OTHERS THEN
243: x_Event_Id := null;
244: x_Assignment_Id := null;

Line 241: hr_utility.raise_error;

237:
238: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_review_details',10);
239: EXCEPTION
240: WHEN hr_utility.hr_error THEN
241: hr_utility.raise_error;
242: WHEN OTHERS THEN
243: x_Event_Id := null;
244: x_Assignment_Id := null;
245: x_Type := null;

Line 325: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.get_emp_reviewers_details',5);

321: l_transaction_step_id number;
322: l_api_name hr_api_transaction_steps.api_name%TYPE;
323:
324: BEGIN
325: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.get_emp_reviewers_details',5);
326: --
327: l_transaction_step_id := to_number(x_transaction_step_id);
328: --
329:

Line 368: hr_utility.set_location('x_person_id'||x_person_id,10);

364: (p_transaction_step_id => l_transaction_step_id,
365: p_name => 'P_PERSON_ID'||x_row_number );
366:
367:
368: hr_utility.set_location('x_person_id'||x_person_id,10);
369: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_reviewers_details',10);
370: EXCEPTION
371: WHEN hr_utility.hr_error THEN
372: hr_utility.raise_error;

Line 369: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_reviewers_details',10);

365: p_name => 'P_PERSON_ID'||x_row_number );
366:
367:
368: hr_utility.set_location('x_person_id'||x_person_id,10);
369: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_reviewers_details',10);
370: EXCEPTION
371: WHEN hr_utility.hr_error THEN
372: hr_utility.raise_error;
373: WHEN OTHERS THEN

Line 371: WHEN hr_utility.hr_error THEN

367:
368: hr_utility.set_location('x_person_id'||x_person_id,10);
369: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_reviewers_details',10);
370: EXCEPTION
371: WHEN hr_utility.hr_error THEN
372: hr_utility.raise_error;
373: WHEN OTHERS THEN
374: x_Event_Id := null;
375: x_Booking_Id := null;

Line 372: hr_utility.raise_error;

368: hr_utility.set_location('x_person_id'||x_person_id,10);
369: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.get_emp_reviewers_details',10);
370: EXCEPTION
371: WHEN hr_utility.hr_error THEN
372: hr_utility.raise_error;
373: WHEN OTHERS THEN
374: x_Event_Id := null;
375: x_Booking_Id := null;
376: x_Employee_no := null;

Line 418: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.set_emp_review_details',5);

414: l_review_proc_call VARCHAR2(30);
415: l_effective_date DATE ;
416:
417: BEGIN
418: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.set_emp_review_details',5);
419: l_review_proc_call := 'PqhEmployeeReview';
420: l_effective_date := SYSDATE;
421: --
422:

Line 488: hr_utility.set_location('Entering: Location_ID:'||x_Location_Id,5);

484: l_trans_tbl(l_count).param_name := 'P_LOCATION_ID';
485: l_trans_tbl(l_count).param_value := x_Location_Id ;
486: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
487:
488: hr_utility.set_location('Entering: Location_ID:'||x_Location_Id,5);
489: --
490: l_count:=l_count+1;
491: l_trans_tbl(l_count).param_name := 'P_COMMENTS';
492: l_trans_tbl(l_count).param_value := x_Comments;

Line 494: hr_utility.set_location('Entering: Comments:'||x_Comments,5);

490: l_count:=l_count+1;
491: l_trans_tbl(l_count).param_name := 'P_COMMENTS';
492: l_trans_tbl(l_count).param_value := x_Comments;
493: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
494: hr_utility.set_location('Entering: Comments:'||x_Comments,5);
495: --
496: l_count:=l_count+1;
497: l_trans_tbl(l_count).param_name := 'P_BUSINESS_GROUP_ID';
498: l_trans_tbl(l_count).param_value := x_Business_Group_Id;

Line 510: hr_utility.set_location('Entering: Business Group Id:'||x_Business_Group_Id,5);

506: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
507: --
508:
509:
510: hr_utility.set_location('Entering: Business Group Id:'||x_Business_Group_Id,5);
511:
512: hr_transaction_ss.save_transaction_step
513: (p_item_type => x_item_type
514: ,p_item_key => x_item_key

Line 520: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.set_emp_review_details',10);

516: ,p_login_person_id => x_login_person_id
517: ,p_transaction_step_id => l_transaction_step_id
518: ,p_api_name => l_api_name
519: ,p_transaction_data => l_trans_tbl );
520: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.set_emp_review_details',10);
521:
522: commit;
523: --- Saving the Transaction Step Id ,
524: --- With the same step-id Reviewers details also being saved.

Line 530: WHEN hr_utility.hr_error THEN

526: -- x_trans_step_id := l_transaction_step_id;
527: --
528: --
529: EXCEPTION
530: WHEN hr_utility.hr_error THEN
531: hr_utility.raise_error;
532: WHEN OTHERS THEN
533: RAISE; -- Raise error here relevant to the new tech stack.
534: END set_emp_review_details;

Line 531: hr_utility.raise_error;

527: --
528: --
529: EXCEPTION
530: WHEN hr_utility.hr_error THEN
531: hr_utility.raise_error;
532: WHEN OTHERS THEN
533: RAISE; -- Raise error here relevant to the new tech stack.
534: END set_emp_review_details;
535: --

Line 564: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.set_emp_reviewer_details',5);

560: l_review_proc_call VARCHAR2(30);
561: l_effective_date DATE ;
562:
563: BEGIN
564: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.set_emp_reviewer_details',5);
565: --
566: l_review_proc_call := 'PqhEmployeeReview';
567: l_effective_date := SYSDATE;
568:

Line 633: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.set_emp_review_details',10);

629: ,p_login_person_id => x_login_person_id
630: ,p_transaction_step_id => l_transaction_step_id
631: ,p_api_name => l_api_name
632: ,p_transaction_data => l_trans_tbl );
633: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.set_emp_review_details',10);
634:
635: commit;
636:
637: EXCEPTION

Line 638: WHEN hr_utility.hr_error THEN

634:
635: commit;
636:
637: EXCEPTION
638: WHEN hr_utility.hr_error THEN
639: hr_utility.raise_error;
640: WHEN OTHERS THEN
641: RAISE; -- Raise error here relevant to the new tech stack.
642: END set_emp_reviewer_details;

Line 639: hr_utility.raise_error;

635: commit;
636:
637: EXCEPTION
638: WHEN hr_utility.hr_error THEN
639: hr_utility.raise_error;
640: WHEN OTHERS THEN
641: RAISE; -- Raise error here relevant to the new tech stack.
642: END set_emp_reviewer_details;
643:

Line 766: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_api',5);

762: l_attach_status varchar2(80);
763:
764: BEGIN
765:
766: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_api',5);
767: --
768: savepoint process_emp_review_details;
769: --
770: empReviewCsr := get_employee_review(p_transaction_step_id);

Line 953: hr_utility.set_location('merge_attachments Start : l_person_id = ' || l_person_id || ' ' || 'PQH_PROCESS_EMP_REVIEW.PROCESS_API', 7);

949: --
950: --
951: close reviewer_csr ;
952:
953: hr_utility.set_location('merge_attachments Start : l_person_id = ' || l_person_id || ' ' || 'PQH_PROCESS_EMP_REVIEW.PROCESS_API', 7);
954:
955: HR_UTIL_MISC_SS.merge_attachments( p_dest_entity_name => 'PER_PEOPLE_F'
956: ,p_dest_pk1_value => l_person_id
957: ,p_return_status => l_attach_status);

Line 959: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' || 'PQH_PROCESS_EMP_REVIEW.PROCESS_API',9);

955: HR_UTIL_MISC_SS.merge_attachments( p_dest_entity_name => 'PER_PEOPLE_F'
956: ,p_dest_pk1_value => l_person_id
957: ,p_return_status => l_attach_status);
958:
959: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' || 'PQH_PROCESS_EMP_REVIEW.PROCESS_API',9);
960:
961: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',10);
962: EXCEPTION
963: WHEN hr_utility.hr_error THEN

Line 961: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',10);

957: ,p_return_status => l_attach_status);
958:
959: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' || 'PQH_PROCESS_EMP_REVIEW.PROCESS_API',9);
960:
961: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',10);
962: EXCEPTION
963: WHEN hr_utility.hr_error THEN
964: ROLLBACK TO process_emp_review_details;
965: RAISE;

Line 963: WHEN hr_utility.hr_error THEN

959: hr_utility.set_location('merge_attachments End: l_attach_status = ' || l_attach_status || ' ' || 'PQH_PROCESS_EMP_REVIEW.PROCESS_API',9);
960:
961: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',10);
962: EXCEPTION
963: WHEN hr_utility.hr_error THEN
964: ROLLBACK TO process_emp_review_details;
965: RAISE;
966: WHEN OTHERS THEN
967: ROLLBACK TO process_emp_review_details;

Line 1008: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',5);

1004: where person_id = x_Person_Id and event_Id = x_Event_Id;
1005:
1006: Begin
1007: --
1008: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',5);
1009: --
1010: savepoint process_emp_reviewers_details;
1011: --
1012: hr_utility.set_location('p_personId '||p_personId||'Delete Place'||p_status,10);

Line 1012: hr_utility.set_location('p_personId '||p_personId||'Delete Place'||p_status,10);

1008: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',5);
1009: --
1010: savepoint process_emp_reviewers_details;
1011: --
1012: hr_utility.set_location('p_personId '||p_personId||'Delete Place'||p_status,10);
1013: --
1014: If p_status = 'D' Then
1015: --
1016: open getBookingRowid(p_Booking_Id);

Line 1020: hr_utility.set_location('Row Id in Delete '||l_rowId,10);

1016: open getBookingRowid(p_Booking_Id);
1017: fetch getBookingRowid into l_rowId;
1018: close getBookingRowid;
1019: --
1020: hr_utility.set_location('Row Id in Delete '||l_rowId,10);
1021: per_bookings_pkg.Delete_Row(X_Rowid => l_rowId);
1022: hr_utility.set_location(' After Row Id in Delete '||l_rowId,10);
1023: --
1024: end if;

Line 1022: hr_utility.set_location(' After Row Id in Delete '||l_rowId,10);

1018: close getBookingRowid;
1019: --
1020: hr_utility.set_location('Row Id in Delete '||l_rowId,10);
1021: per_bookings_pkg.Delete_Row(X_Rowid => l_rowId);
1022: hr_utility.set_location(' After Row Id in Delete '||l_rowId,10);
1023: --
1024: end if;
1025: --
1026: IF p_Booking_id IS NOT NULL or p_Booking_id <> '0' THEN

Line 1032: hr_utility.set_location('Row Id '||l_rowId,10);

1028: open getBookingRowidForBooking(p_personId,p_event_id);
1029: fetch getBookingRowidForBooking into l_rowId;
1030: close getBookingRowidForBooking;
1031: --
1032: hr_utility.set_location('Row Id '||l_rowId,10);
1033: hr_utility.set_location('Booking Id '||p_Booking_Id||'business Group Id '||p_Business_Group_Id||'event Id '||p_event_id,10);
1034: --
1035: PER_BOOKINGS_PKG.Update_Row(X_Rowid => l_rowId,
1036: X_Booking_Id => p_Booking_Id ,

Line 1033: hr_utility.set_location('Booking Id '||p_Booking_Id||'business Group Id '||p_Business_Group_Id||'event Id '||p_event_id,10);

1029: fetch getBookingRowidForBooking into l_rowId;
1030: close getBookingRowidForBooking;
1031: --
1032: hr_utility.set_location('Row Id '||l_rowId,10);
1033: hr_utility.set_location('Booking Id '||p_Booking_Id||'business Group Id '||p_Business_Group_Id||'event Id '||p_event_id,10);
1034: --
1035: PER_BOOKINGS_PKG.Update_Row(X_Rowid => l_rowId,
1036: X_Booking_Id => p_Booking_Id ,
1037: X_Business_Group_Id => p_Business_Group_Id,

Line 1113: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_reviewers_api',10);

1109: -- resurrecting the transaction (via update action link), it is then
1110: -- attempted to rollback which would fail if committed here.
1111: -- commit;
1112:
1113: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_reviewers_api',10);
1114: EXCEPTION
1115: WHEN hr_utility.hr_error THEN
1116: ROLLBACK TO process_emp_reviewers_details;
1117: RAISE;

Line 1115: WHEN hr_utility.hr_error THEN

1111: -- commit;
1112:
1113: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_reviewers_api',10);
1114: EXCEPTION
1115: WHEN hr_utility.hr_error THEN
1116: ROLLBACK TO process_emp_reviewers_details;
1117: RAISE;
1118: WHEN OTHERS THEN
1119: ROLLBACK TO process_emp_reviewers_details;