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 751: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_api',5);

747: l_typeMeaning varchar2(240);
748:
749: BEGIN
750:
751: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_api',5);
752: --
753: savepoint process_emp_review_details;
754: --
755: empReviewCsr := get_employee_review(p_transaction_step_id);

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

933: end loop;
934: --
935: --
936: close reviewer_csr ;
937: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',10);
938: EXCEPTION
939: WHEN hr_utility.hr_error THEN
940: ROLLBACK TO process_emp_review_details;
941: RAISE;

Line 939: WHEN hr_utility.hr_error THEN

935: --
936: close reviewer_csr ;
937: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',10);
938: EXCEPTION
939: WHEN hr_utility.hr_error THEN
940: ROLLBACK TO process_emp_review_details;
941: RAISE;
942: WHEN OTHERS THEN
943: ROLLBACK TO process_emp_review_details;

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

980: where person_id = x_Person_Id and event_Id = x_Event_Id;
981:
982: Begin
983: --
984: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',5);
985: --
986: savepoint process_emp_reviewers_details;
987: --
988: hr_utility.set_location('p_personId '||p_personId||'Delete Place'||p_status,10);

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

984: hr_utility.set_location('Entering: PQH_PROCESS_EMP_REVIEW.process_emp_review_api',5);
985: --
986: savepoint process_emp_reviewers_details;
987: --
988: hr_utility.set_location('p_personId '||p_personId||'Delete Place'||p_status,10);
989: --
990: If p_status = 'D' Then
991: --
992: open getBookingRowid(p_Booking_Id);

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

992: open getBookingRowid(p_Booking_Id);
993: fetch getBookingRowid into l_rowId;
994: close getBookingRowid;
995: --
996: hr_utility.set_location('Row Id in Delete '||l_rowId,10);
997: per_bookings_pkg.Delete_Row(X_Rowid => l_rowId);
998: hr_utility.set_location(' After Row Id in Delete '||l_rowId,10);
999: --
1000: end if;

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

994: close getBookingRowid;
995: --
996: hr_utility.set_location('Row Id in Delete '||l_rowId,10);
997: per_bookings_pkg.Delete_Row(X_Rowid => l_rowId);
998: hr_utility.set_location(' After Row Id in Delete '||l_rowId,10);
999: --
1000: end if;
1001: --
1002: IF p_Booking_id IS NOT NULL or p_Booking_id <> '0' THEN

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

1004: open getBookingRowidForBooking(p_personId,p_event_id);
1005: fetch getBookingRowidForBooking into l_rowId;
1006: close getBookingRowidForBooking;
1007: --
1008: hr_utility.set_location('Row Id '||l_rowId,10);
1009: hr_utility.set_location('Booking Id '||p_Booking_Id||'business Group Id '||p_Business_Group_Id||'event Id '||p_event_id,10);
1010: --
1011: PER_BOOKINGS_PKG.Update_Row(X_Rowid => l_rowId,
1012: X_Booking_Id => p_Booking_Id ,

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

1005: fetch getBookingRowidForBooking into l_rowId;
1006: close getBookingRowidForBooking;
1007: --
1008: hr_utility.set_location('Row Id '||l_rowId,10);
1009: hr_utility.set_location('Booking Id '||p_Booking_Id||'business Group Id '||p_Business_Group_Id||'event Id '||p_event_id,10);
1010: --
1011: PER_BOOKINGS_PKG.Update_Row(X_Rowid => l_rowId,
1012: X_Booking_Id => p_Booking_Id ,
1013: X_Business_Group_Id => p_Business_Group_Id,

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

1085: -- resurrecting the transaction (via update action link), it is then
1086: -- attempted to rollback which would fail if committed here.
1087: -- commit;
1088:
1089: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_reviewers_api',10);
1090: EXCEPTION
1091: WHEN hr_utility.hr_error THEN
1092: ROLLBACK TO process_emp_reviewers_details;
1093: RAISE;

Line 1091: WHEN hr_utility.hr_error THEN

1087: -- commit;
1088:
1089: hr_utility.set_location('Leaving: PQH_PROCESS_EMP_REVIEW.process_emp_reviewers_api',10);
1090: EXCEPTION
1091: WHEN hr_utility.hr_error THEN
1092: ROLLBACK TO process_emp_reviewers_details;
1093: RAISE;
1094: WHEN OTHERS THEN
1095: ROLLBACK TO process_emp_reviewers_details;