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_FP_REFRESH_ELEMENTS_PUB dependencies on PA_FP_REFRESH_ELEMENTS_PUB

Line 1: PACKAGE BODY pa_fp_refresh_elements_pub AS

1: PACKAGE BODY pa_fp_refresh_elements_pub AS
2: /* $Header: PAFPPERB.pls 120.3 2005/08/19 16:27:59 mwasowic noship $ */
3: p_pa_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: PROCEDURE fp_write_log_ss_or_conc(

Line 133: l_module VARCHAR2(255):='pa_fp_refresh_elements_pub.refresh_planning_elements';

129: l_task_level_tab PA_PLSQL_DATATYPES.Char1TabTyp;
130: l_fp_opt_tbl PA_PLSQL_DATATYPES.IdTabTyp;
131: l_tname_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
132: l_dummy NUMBER;
133: l_module VARCHAR2(255):='pa_fp_refresh_elements_pub.refresh_planning_elements';
134: l_calling_context VARCHAR2(10);
135: l_msg VARCHAR2(300);
136: l_ret_status VARCHAR2(100);
137: x_return_status_in VARCHAR2(100);

Line 157: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(

153: END IF;
154:
155: IF p_pa_debug_mode = 'Y' THEN
156: l_msg := 'Project Id:'||to_char(p_project_id) ||' Req Id :'||to_char(p_request_id);
157: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
158: p_calling_context => l_calling_context,
159: p_msg => l_msg,
160: p_log_level => 3,
161: p_module => l_module );

Line 235: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(

231:
232: IF l_fp_opt_tbl.COUNT = 0 THEN
233: IF p_pa_debug_mode = 'Y' THEN
234: l_msg := 'l_fp_opt_tbl count is zero. Returning ';
235: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
236: p_calling_context => l_calling_context,
237: p_msg => l_msg,
238: p_log_level => 3,
239: p_module => l_module );

Line 262: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(

258:
259: IF l_task_id_tab.COUNT = 0 THEN
260: IF p_pa_debug_mode = 'Y' THEN
261: l_msg := 'task tbl count is zero. Returning ';
262: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
263: p_calling_context => l_calling_context,
264: p_msg => l_msg,
265: p_log_level => 3,
266: p_module => l_module );

Line 280: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(

276: END LOOP;
277:
278: IF p_pa_debug_mode = 'Y' THEN
279: l_msg := 'before calling PA_FP_ELEMENTS_PUB.make_new_tasks_plannable';
280: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
281: p_calling_context => l_calling_context,
282: p_msg => l_msg,
283: p_log_level => 3,
284: p_module => l_module );

Line 302: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(

298:
299: IF p_pa_debug_mode = 'Y' THEN
300: l_msg := 'after calling PA_FP_ELEMENTS_PUB.make_new_tasks_plannable'
301: || 'ret status:'||x_return_status;
302: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
303: p_calling_context => l_calling_context,
304: p_msg => l_msg,
305: p_log_level => 3,
306: p_module => l_module );

Line 313: l_msg := 'calling pa_fp_refresh_elements_pub.update_process_status';

309: IF p_request_id IS NULL OR
310: ( p_request_id IS NOT NULL AND
311: x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
312: IF p_pa_debug_mode = 'Y' THEN
313: l_msg := 'calling pa_fp_refresh_elements_pub.update_process_status';
314: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
315: p_calling_context => l_calling_context,
316: p_msg => l_msg,
317: p_log_level => 3,

Line 314: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(

310: ( p_request_id IS NOT NULL AND
311: x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
312: IF p_pa_debug_mode = 'Y' THEN
313: l_msg := 'calling pa_fp_refresh_elements_pub.update_process_status';
314: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
315: p_calling_context => l_calling_context,
316: p_msg => l_msg,
317: p_log_level => 3,
318: p_module => l_module );

Line 321: pa_fp_refresh_elements_pub.update_process_status(

317: p_log_level => 3,
318: p_module => l_module );
319: END IF;
320: x_return_status_in := x_return_status;
321: pa_fp_refresh_elements_pub.update_process_status(
322: p_fp_opt_tab => l_fp_opt_tbl,
323: p_return_status => x_return_status_in,
324: p_project_id => p_project_id,
325: p_request_id => p_request_id,

Line 332: l_msg := 'calling pa_fp_refresh_elements_pub.update_process_status_auto';

328: x_msg_data => x_msg_data );
329: ELSIF p_request_id IS NOT NULL AND
330: x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
331: IF p_pa_debug_mode = 'Y' THEN
332: l_msg := 'calling pa_fp_refresh_elements_pub.update_process_status_auto';
333: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
334: p_calling_context => l_calling_context,
335: p_msg => l_msg,
336: p_log_level => 3,

Line 333: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(

329: ELSIF p_request_id IS NOT NULL AND
330: x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
331: IF p_pa_debug_mode = 'Y' THEN
332: l_msg := 'calling pa_fp_refresh_elements_pub.update_process_status_auto';
333: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
334: p_calling_context => l_calling_context,
335: p_msg => l_msg,
336: p_log_level => 3,
337: p_module => l_module );

Line 340: pa_fp_refresh_elements_pub.update_process_status_auto(

336: p_log_level => 3,
337: p_module => l_module );
338: END IF;
339: x_return_status_in := x_return_status;
340: pa_fp_refresh_elements_pub.update_process_status_auto(
341: p_fp_opt_tab => l_fp_opt_tbl,
342: p_return_status => x_return_status_in,
343: p_project_id => p_project_id,
344: p_request_id => p_request_id,

Line 362: pa_fp_refresh_elements_pub.update_process_status_auto(

358: PA_DEBUG.Reset_Err_stack;
359: END IF;
360: IF p_request_id IS NOT NULL THEN
361: x_return_status_in := x_return_status;
362: pa_fp_refresh_elements_pub.update_process_status_auto(
363: p_fp_opt_tab => l_fp_opt_tbl,
364: p_return_status => x_return_status_in,
365: p_project_id => p_project_id,
366: p_request_id => p_request_id,

Line 372: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_fp_refresh_elements_pub',

368: x_msg_count => x_msg_count,
369: x_msg_data => x_msg_data );
370: END IF;
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
372: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_fp_refresh_elements_pub',
373: p_procedure_name => 'refresh_planning_elements',
374: p_error_text => SUBSTRB(SQLERRM,1,240));
375:
376: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 383: END pa_fp_refresh_elements_pub;

379: END refresh_planning_elements;
380:
381:
382:
383: END pa_fp_refresh_elements_pub;