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.PA_RP_UTIL dependencies on PJI_UTILS

Line 16: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Assign_Job: beginning', TRUE , g_proc);

12: , x_msg_count IN OUT NOCOPY NUMBER
13: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
14: BEGIN
15: IF g_debug_mode = 'Y' THEN
16: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Assign_Job: beginning', TRUE , g_proc);
17: END IF;
18:
19: IF x_return_status IS NULL THEN
20: x_msg_count := 0;

Line 49: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Assign_Job: finishing', TRUE , g_proc);

45:
46: COMMIT;
47:
48: IF g_debug_mode = 'Y' THEN
49: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Assign_Job: finishing', TRUE , g_proc);
50: END IF;
51:
52: EXCEPTION
53: WHEN OTHERS THEN

Line 67: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Is_DT_Trimmed: beginning', TRUE , g_proc);

63: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
64: l_count NUMBER;
65: BEGIN
66: IF g_debug_mode = 'Y' THEN
67: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Is_DT_Trimmed: beginning', TRUE , g_proc);
68: END IF;
69:
70: IF x_return_status IS NULL THEN
71: x_msg_count := 0;

Line 108: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Is_DT_Trimmed: finishing', TRUE , g_proc);

104: END IF;
105: END IF;
106:
107: IF g_debug_mode = 'Y' THEN
108: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Is_DT_Trimmed: finishing', TRUE , g_proc);
109: END IF;
110:
111: EXCEPTION
112: WHEN OTHERS THEN

Line 125: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Is_DT_Trimmed: beginning', TRUE , g_proc);

121: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
122:
123: BEGIN
124: IF g_debug_mode = 'Y' THEN
125: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Is_DT_Trimmed: beginning', TRUE , g_proc);
126: END IF;
127:
128: IF x_return_status IS NULL THEN
129: x_msg_count := 0;

Line 155: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Is_DT_Trimmed: finishing', TRUE , g_proc);

151: WHERE rp_id = p_rp_id
152: FOR UPDATE;
153: */
154: IF g_debug_mode = 'Y' THEN
155: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Is_DT_Trimmed: finishing', TRUE , g_proc);
156: END IF;
157:
158: EXCEPTION
159: WHEN OTHERS THEN

Line 221: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Start_Workers: beginning', TRUE , g_proc);

217: l_worker_number NUMBER;
218: l_i NUMBER;
219: BEGIN
220: IF g_debug_mode = 'Y' THEN
221: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Start_Workers: beginning', TRUE , g_proc);
222: END IF;
223:
224: IF x_return_status IS NULL THEN
225: x_msg_count := 0;

Line 244: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Start_Workers: finishing', TRUE , g_proc);

240: END LOOP;
241:
242:
243: IF g_debug_mode = 'Y' THEN
244: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Start_Workers: finishing', TRUE , g_proc);
245: END IF;
246:
247: EXCEPTION
248: WHEN OTHERS THEN

Line 271: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Check_Workers: beginning', TRUE , g_proc);

267: l_request_check BOOLEAN;
268: l_request_id NUMBER;
269: BEGIN
270: IF g_debug_mode = 'Y' THEN
271: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Check_Workers: beginning', TRUE , g_proc);
272: END IF;
273:
274: IF x_return_status IS NULL THEN
275: x_msg_count := 0;

Line 347: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Check_Workers: finishing', TRUE , g_proc);

343: DELETE FROM pa_rp_job_assignments
344: WHERE main_request_id = p_main_request_id;
345:
346: IF g_debug_mode = 'Y' THEN
347: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Check_Workers: finishing', TRUE , g_proc);
348: END IF;
349:
350: EXCEPTION
351: WHEN OTHERS THEN

Line 464: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Save_Params: beginning', TRUE , g_proc);

460: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
461: l_i NUMBER;
462: BEGIN
463: IF g_debug_mode = 'Y' THEN
464: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Save_Params: beginning', TRUE , g_proc);
465: END IF;
466:
467: IF x_return_status IS NULL THEN
468: x_msg_count := 0;

Line 495: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Save_Params: finishing', TRUE , g_proc);

491:
492:
493:
494: IF g_debug_mode = 'Y' THEN
495: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Save_Params: finishing', TRUE , g_proc);
496: END IF;
497:
498: EXCEPTION
499: WHEN OTHERS THEN

Line 532: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Get_Email_Addresses: beginning', TRUE , g_proc);

528: AND (TRUNC(SYSDATE) BETWEEN TRUNC(p.start_date_active) AND NVL(TRUNC(p.end_date_active),SYSDATE));
529:
530: BEGIN
531: IF g_debug_mode = 'Y' THEN
532: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Get_Email_Addresses: beginning', TRUE , g_proc);
533: END IF;
534:
535: IF x_return_status IS NULL THEN
536: x_msg_count := 0;

Line 549: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Get_Email_Addresses: finishing', TRUE , g_proc);

545: END LOOP;
546:
547: x_email_addresses := l_email_list;
548: IF g_debug_mode = 'Y' THEN
549: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Get_Email_Addresses: finishing', TRUE , g_proc);
550: END IF;
551:
552: EXCEPTION
553: WHEN OTHERS THEN

Line 604: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Derive_Proj_Params: beginning', TRUE , g_proc);

600: l_i NUMBER;
601: l_plan_version_ids SYSTEM.PA_NUM_TBL_TYPE;
602: BEGIN
603: IF g_debug_mode = 'Y' THEN
604: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Derive_Proj_Params: beginning', TRUE , g_proc);
605: END IF;
606:
607: IF x_return_status IS NULL THEN
608: x_msg_count := 0;

Line 773: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Derive_Proj_Params: finishing', TRUE , g_proc);

769: , x_msg_data
770: );
771:
772: IF g_debug_mode = 'Y' THEN
773: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Derive_Proj_Params: finishing', TRUE , g_proc);
774: END IF;
775:
776: EXCEPTION
777: WHEN OTHERS THEN

Line 796: Pji_Utils.WRITE2LOG( 'derive_currency_info: beginning', TRUE , g_proc);

792: l_projfunc_currency VARCHAR2(20);
793: BEGIN
794:
795: IF g_debug_mode = 'Y' THEN
796: Pji_Utils.WRITE2LOG( 'derive_currency_info: beginning', TRUE , g_proc);
797: END IF;
798:
799: IF x_return_status IS NULL THEN
800: x_msg_count := 0;

Line 819: Pji_Utils.WRITE2LOG( 'derive_currency_info: finishing', TRUE , g_proc);

815: END IF;
816:
817:
818: IF g_debug_mode = 'Y' THEN
819: Pji_Utils.WRITE2LOG( 'derive_currency_info: finishing', TRUE , g_proc);
820: END IF;
821:
822: EXCEPTION
823: WHEN OTHERS THEN

Line 857: Pji_Utils.WRITE2LOG( 'Derive_Report_Period: begining', TRUE , g_proc);

853: l_application_id NUMBER;
854: BEGIN
855: Pa_Debug.init_err_stack('PA_RP_UTIL.Derive_Report_Period');
856: IF g_debug_mode = 'Y' THEN
857: Pji_Utils.WRITE2LOG( 'Derive_Report_Period: begining', TRUE , g_proc);
858: END IF;
859:
860: IF p_calendar_type = 'E' THEN
861: x_calendar_id := -1;

Line 981: Pji_Utils.WRITE2LOG( 'Derive_Report_Period: finishing', TRUE , g_proc);

977: x_start_date := TO_CHAR(l_start_date,'j');
978: x_end_date := TO_CHAR(l_end_date, 'j');
979:
980: IF g_debug_mode = 'Y' THEN
981: Pji_Utils.WRITE2LOG( 'Derive_Report_Period: finishing', TRUE , g_proc);
982: END IF;
983:
984:
985: EXCEPTION