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_TASK_PROG_ACTSET dependencies on PA_DEBUG

Line 20: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');

16: l_return_status VARCHAR2(1):= 'S';
17: l_loop_cnt NUMBER;
18:
19: BEGIN
20: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');
21: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.process_action_set.begin'
22: ,x_Msg => 'in PA_TASK_PROG_ACTSET.process_action_set'
23: ,x_Log_Level => 6);
24:

Line 21: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.process_action_set.begin'

17: l_loop_cnt NUMBER;
18:
19: BEGIN
20: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');
21: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.process_action_set.begin'
22: ,x_Msg => 'in PA_TASK_PROG_ACTSET.process_action_set'
23: ,x_Log_Level => 6);
24:
25: --initialize return status

Line 74: PA_DEBUG.RESET_ERR_STACK;

70: -- ,x_return_status => l_return_status
71: -- );
72: -- END IF;
73:
74: PA_DEBUG.RESET_ERR_STACK;
75: return;
76:
77: -- Put any message text from message stack into the Message ARRAY
78: EXCEPTION

Line 82: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

78: EXCEPTION
79: WHEN OTHERS THEN
80: -- Set the excetption Message and the stack
81: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.process_action_set'
82: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
84: RAISE;
85:
86: END process_action_set;

Line 113: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');

109: l_msg_count NUMBER := 0;
110: l_msg_data VARCHAR2(2000);
111:
112: BEGIN
113: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');
114: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.perform_action_set_line.begin'
115: ,x_Msg => 'in PA_TASK_PROG_ACTSET.perform_action_set_line'
116: ,x_Log_Level => 6);
117:

Line 114: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.perform_action_set_line.begin'

110: l_msg_data VARCHAR2(2000);
111:
112: BEGIN
113: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.process_action_set');
114: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.perform_action_set_line.begin'
115: ,x_Msg => 'in PA_TASK_PROG_ACTSET.perform_action_set_line'
116: ,x_Log_Level => 6);
117:
118: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED ;

Line 124: PA_DEBUG.RESET_ERR_STACK;

120: if validate_action_type_code(p_action_set_type_code) = FALSE then
121: PA_ACTION_SET_UTILS.Add_Message(
122: p_app_short_name => 'PA'
123: ,p_msg_name => 'PA_AS_INVALID_ACTION_TYPE');
124: PA_DEBUG.RESET_ERR_STACK;
125: return;
126: end if;
127: l_project_id := p_action_set_details_rec.object_id; --2643
128: --get_project_id(p_action_set_type_code,p_action_set_line_rec);

Line 133: PA_DEBUG.RESET_ERR_STACK;

129: if (l_project_id is null or l_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
130: PA_ACTION_SET_UTILS.Add_Message(
131: p_app_short_name => 'PA'
132: ,p_msg_name => 'PA_NO_PROJECT_ID');
133: PA_DEBUG.RESET_ERR_STACK;
134: return;
135: end if ;
136:
137: OPEN c_proj_info(l_project_id);

Line 144: PA_DEBUG.RESET_ERR_STACK;

140: close c_proj_info;
141: PA_ACTION_SET_UTILS.Add_Message(
142: p_app_short_name => 'PA'
143: ,p_msg_name => 'PA_NO_PROJECT_ID');
144: PA_DEBUG.RESET_ERR_STACK;
145: return;
146: end if ;
147: l_project_status := cp_proj_info.proj_status_code;
148: l_proj_start_date := cp_proj_info.proj_start_date;

Line 152: PA_DEBUG.RESET_ERR_STACK;

148: l_proj_start_date := cp_proj_info.proj_start_date;
149:
150:
151: if (action_allowed_for_status(l_project_id,l_project_status) = FALSE) then
152: PA_DEBUG.RESET_ERR_STACK;
153: return;
154: end if;
155:
156: --When task prog reminder date is in the past, bring it up to date

Line 187: PA_DEBUG.RESET_ERR_STACK;

183: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_COMPLETE;
184: end if;
185: end if;
186: end if;
187: PA_DEBUG.RESET_ERR_STACK;
188: return;
189: EXCEPTION
190: WHEN OTHERS THEN
191: -- Set the excetption Message and the stack

Line 193: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

189: EXCEPTION
190: WHEN OTHERS THEN
191: -- Set the excetption Message and the stack
192: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.peform_action_set_line'
193: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
194: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED;
195: RAISE;
196:
197: END perform_action_set_line;

Line 227: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.action_allowed_for_status');

223: IS
224: --l_project_status VARCHAR2(30);--mwxx REMOVE!!!
225: BEGIN
226:
227: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.action_allowed_for_status');
228: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.action_allowed_for_status.begin'
229: ,x_Msg => 'in PA_TASK_PROG_ACTSET.action_allowed_for_status'
230: ,x_Log_Level => 6);
231:

Line 228: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.action_allowed_for_status.begin'

224: --l_project_status VARCHAR2(30);--mwxx REMOVE!!!
225: BEGIN
226:
227: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.action_allowed_for_status');
228: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.action_allowed_for_status.begin'
229: ,x_Msg => 'in PA_TASK_PROG_ACTSET.action_allowed_for_status'
230: ,x_Log_Level => 6);
231:
232: --l_project_status := 'APPROVED'; --mwxx REMOVE!!!

Line 235: PA_DEBUG.RESET_ERR_STACK;

231:
232: --l_project_status := 'APPROVED'; --mwxx REMOVE!!!
233: if PA_PROJECT_UTILS.check_prj_stus_action_allowed
234: (p_project_status,'PA_TASK_PROGRESS') <> 'Y' then
235: PA_DEBUG.RESET_ERR_STACK;
236: return FALSE;
237: --return TRUE; --mwx REMOVE!!
238:
239: end if;

Line 240: PA_DEBUG.RESET_ERR_STACK;

236: return FALSE;
237: --return TRUE; --mwx REMOVE!!
238:
239: end if;
240: PA_DEBUG.RESET_ERR_STACK;
241: return TRUE ;
242: EXCEPTION
243: WHEN OTHERS THEN
244: RAISE;

Line 247: -- ,p_procedure_name => PA_DEBUG.G_Err_Stack );

243: WHEN OTHERS THEN
244: RAISE;
245:
246: -- FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.action_allowed_for_status'
247: -- ,p_procedure_name => PA_DEBUG.G_Err_Stack );
248:
249: END action_allowed_for_status;
250: /*----------------------------------------------------------------------------------*/
251: FUNCTION ok_to_perform_action (

Line 269: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.ok_to_perform_action');

265:
266: cp_proj_date c_proj_date%ROWTYPE;
267: BEGIN
268:
269: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.ok_to_perform_action');
270: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.ok_to_perform_action.begin'
271: ,x_Msg => 'in PA_TASK_PROG_ACTSET.ok_to_perform_action'
272: ,x_Log_Level => 6);
273:

Line 270: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.ok_to_perform_action.begin'

266: cp_proj_date c_proj_date%ROWTYPE;
267: BEGIN
268:
269: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.ok_to_perform_action');
270: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.ok_to_perform_action.begin'
271: ,x_Msg => 'in PA_TASK_PROG_ACTSET.ok_to_perform_action'
272: ,x_Log_Level => 6);
273:
274:

Line 283: PA_DEBUG.RESET_ERR_STACK;

279: OPEN c_proj_date(p_project_id);
280: FETCH c_proj_date INTO cp_proj_date;
281: if c_proj_date%NOTFOUND then
282: close c_proj_date;
283: PA_DEBUG.RESET_ERR_STACK;
284: return FALSE;
285: else
286: PA_DEBUG.RESET_ERR_STACK;
287: return TRUE ;

Line 286: PA_DEBUG.RESET_ERR_STACK;

282: close c_proj_date;
283: PA_DEBUG.RESET_ERR_STACK;
284: return FALSE;
285: else
286: PA_DEBUG.RESET_ERR_STACK;
287: return TRUE ;
288: end if ;
289:
290: EXCEPTION

Line 296: -- ,p_procedure_name => PA_DEBUG.G_Err_Stack );

292: RAISE;
293:
294: -- Set the excetption Message and the stack
295: --FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.ok_to_perform_action'
296: -- ,p_procedure_name => PA_DEBUG.G_Err_Stack );
297:
298: END ok_to_perform_action;
299: /*-----------------------------------------------------------------------------*/
300: FUNCTION is_action_repeating(

Line 340: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.copy_action_sets');

336:
337: BEGIN
338: x_return_status := fnd_api.g_ret_sts_success;
339:
340: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.copy_action_sets');
341: savepoint copy_task_action_sets;
342:
343:
344: OPEN task_reminder_action_set;

Line 349: PA_DEBUG.Reset_Err_Stack;

345: FETCH task_reminder_action_set INTO l_action_set_id;
346:
347: if task_reminder_action_set%NOTFOUND then
348: CLOSE task_reminder_action_set;
349: PA_DEBUG.Reset_Err_Stack;
350: return ;
351: end if ;
352:
353: pa_action_sets_pub.apply_action_set

Line 367: PA_DEBUG.Reset_Err_Stack;

363: if x_return_status <> fnd_api.g_ret_sts_success then
364: ROLLBACK TO copy_task_action_sets;
365: end if;
366:
367: PA_DEBUG.Reset_Err_Stack;
368:
369:
370: EXCEPTION
371: WHEN TOO_MANY_ROWS THEN

Line 375: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

371: WHEN TOO_MANY_ROWS THEN
372: ROLLBACK TO copy_task_action_sets;
373: -- Set the exception Message and the stack
374: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_task_prog_actset.copy_action_sets'
375: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
377: RAISE;
378:
379: WHEN OTHERS THEN

Line 383: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

379: WHEN OTHERS THEN
380: ROLLBACK TO copy_task_action_sets;
381: -- Set the exception Message and the stack
382: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_task_prog_actset.copy_action_sets'
383: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: RAISE;
386:
387: END copy_action_sets;

Line 411: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.delete_action_set');

407: l_msg_data VARCHAR2(2000);
408: l_record_version_number NUMBER;
409:
410: BEGIN
411: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.delete_action_set');
412: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.delete_action_set.begin'
413: ,x_Msg => 'in PA_TASK_PROG_ACTSET.delete_action_set'
414: ,x_Log_Level => 6);
415:

Line 412: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.delete_action_set.begin'

408: l_record_version_number NUMBER;
409:
410: BEGIN
411: PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.delete_action_set');
412: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.delete_action_set.begin'
413: ,x_Msg => 'in PA_TASK_PROG_ACTSET.delete_action_set'
414: ,x_Log_Level => 6);
415:
416: l_record_version_number := p_record_version_number;

Line 442: PA_DEBUG.RESET_ERR_STACK;

438: --x_msg_count =: l_msg_count;
439: --x_msg_data =: l_msg_data;
440:
441:
442: PA_DEBUG.RESET_ERR_STACK;
443:
444:
445: EXCEPTION
446:

Line 449: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

445: EXCEPTION
446:
447: WHEN OTHERS THEN
448: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.delete_action_set'
449: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
450:
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
452: RAISE;
453:

Line 494: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.update_action_set');

490: l_new_action_set_id NUMBER := NULL;
491:
492:
493: BEGIN
494: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.update_action_set');
495: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.update_action_set.begin'
496: ,x_Msg => 'in PA_TASK_PROG_ACTSET.update_action_set'
497: ,x_Log_Level => 6);
498:

Line 495: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.update_action_set.begin'

491:
492:
493: BEGIN
494: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.update_action_set');
495: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.update_action_set.begin'
496: ,x_Msg => 'in PA_TASK_PROG_ACTSET.update_action_set'
497: ,x_Log_Level => 6);
498:
499: x_return_status := 'S';

Line 513: PA_DEBUG.RESET_ERR_STACK;

509: CLOSE c_action_set_info;
510: PA_UTILS.Add_Message( p_app_short_name => 'PA'
511: ,p_msg_name => 'PA_CI_XX_DUPLICATE_NUMBER');
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: PA_DEBUG.RESET_ERR_STACK;
514: return;
515: end if;
516: l_record_version_number := cp_action_set_info.record_version_number;
517: CLOSE c_action_set_info;

Line 591: PA_DEBUG.RESET_ERR_STACK;

587: END IF;
588:
589:
590:
591: PA_DEBUG.RESET_ERR_STACK;
592:
593:
594: EXCEPTION
595:

Line 598: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

594: EXCEPTION
595:
596: WHEN OTHERS THEN
597: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.update_action_set'
598: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
599:
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
601: RAISE;
602: