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 PA_RP_UTIL

Line 1: PACKAGE BODY Pa_Rp_Util AS

1: PACKAGE BODY Pa_Rp_Util AS
2: /* $Header: PARPUTILB.pls 120.7 2007/02/26 16:44:31 pschandr noship $ */
3: g_debug_mode VARCHAR2(1) := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4: g_proc NUMBER :=5;
5:

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 54: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Assign_Job');

50: END IF;
51:
52: EXCEPTION
53: WHEN OTHERS THEN
54: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Assign_Job');
55: RAISE;
56: END Assign_Job;
57:
58: PROCEDURE Is_DT_Trimmed (p_rp_id NUMBER

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 113: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Assign_Job');

109: END IF;
110:
111: EXCEPTION
112: WHEN OTHERS THEN
113: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Assign_Job');
114: RAISE;
115: END Is_DT_Trimmed;
116:
117: PROCEDURE Save_Trimmed_DT (p_rp_id NUMBER

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 160: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Assign_Job');

156: END IF;
157:
158: EXCEPTION
159: WHEN OTHERS THEN
160: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Assign_Job');
161: ROLLBACK;
162: RAISE;
163: END Save_Trimmed_DT;
164:

Line 207: Fnd_Message.set_token('PROC_NAME','PA_RP_UTILS.Add_Message');

203: Fnd_Msg_Pub.add_detail(p_message_type=>p_msg_type);
204: EXCEPTION
205: WHEN OTHERS THEN
206: Fnd_Message.set_name('PA','PA_RP_GENERIC_MSG');
207: Fnd_Message.set_token('PROC_NAME','PA_RP_UTILS.Add_Message');
208: END Add_Message;
209:
210:
211: PROCEDURE Start_Workers (p_request_id NUMBER

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 249: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Start_Workers');

245: END IF;
246:
247: EXCEPTION
248: WHEN OTHERS THEN
249: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Start_Workers');
250: RAISE;
251: END Start_Workers;
252:
253:

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 352: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Check_Workers');

348: END IF;
349:
350: EXCEPTION
351: WHEN OTHERS THEN
352: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Check_Workers');
353: RAISE;
354: END Check_Workers;
355:
356:

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 500: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Save_Params');

496: END IF;
497:
498: EXCEPTION
499: WHEN OTHERS THEN
500: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Save_Params');
501: RAISE;
502: END Save_Params;
503:
504:

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 554: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Get_Email_Addresses');

550: END IF;
551:
552: EXCEPTION
553: WHEN OTHERS THEN
554: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Get_Email_Addresses');
555: RAISE;
556: END Get_Email_Addresses;
557:
558: PROCEDURE Derive_Proj_Params (p_project_id NUMBER

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 778: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Derive_Proj_Params');

774: END IF;
775:
776: EXCEPTION
777: WHEN OTHERS THEN
778: Add_Message(p_app_short_name=> 'PA',p_msg_name=> 'PA_RP_GENERIC_MSG',p_msg_type=>Pa_Rp_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PA_RP_UTIL.Derive_Proj_Params');
779: RAISE;
780: END Derive_Proj_Params;
781:
782:

Line 855: Pa_Debug.init_err_stack('PA_RP_UTIL.Derive_Report_Period');

851: l_gl_calendar_id NUMBER;
852: l_pa_calendar_id NUMBER;
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:

Line 1052: END Pa_Rp_Util;

1048:
1049: RETURN l_number;
1050: END;
1051:
1052: END Pa_Rp_Util;