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.FPA_MAIN_PROCESS_PVT dependencies on FND_LOG

Line 67: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

63: PCTL.LANGUAGE = USERENV('LANG');
64:
65: BEGIN
66:
67: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
68: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
69: 'fpa.sql.fpa_main_process_pvt.get_wf_attributes.begin',
70: 'Entering fpa_main_process_pvt.get_wf_attributes');
71: END IF;

Line 68: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

64:
65: BEGIN
66:
67: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
68: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
69: 'fpa.sql.fpa_main_process_pvt.get_wf_attributes.begin',
70: 'Entering fpa_main_process_pvt.get_wf_attributes');
71: END IF;
72:

Line 100: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

96: x_pc_attributes_rec := l_pc_attributes_rec;
97:
98: EXCEPTION
99: WHEN OTHERS THEN
100: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
101: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
102: 'fpa.sql.fpa_main_process_pvt.get_wf_attributes.end',
103: SQLERRM);
104: END IF;

Line 101: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

97:
98: EXCEPTION
99: WHEN OTHERS THEN
100: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
101: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
102: 'fpa.sql.fpa_main_process_pvt.get_wf_attributes.end',
103: SQLERRM);
104: END IF;
105: wf_core.context('FPA_MAIN_PROCESS_PVT', 'GET_WF_ATTRIBUTES', null);

Line 172: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

168: l_pc_attributes_rec PC_ATTRIBUTES_REC_TYPE;
169:
170: BEGIN
171:
172: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
173: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
174: 'fpa.sql.fpa_main_process_pvt.initiate_workflow.begin',
175: 'Entering fpa_main_process_pvt.initiate_workflow');
176: END IF;

Line 173: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

169:
170: BEGIN
171:
172: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
173: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
174: 'fpa.sql.fpa_main_process_pvt.initiate_workflow.begin',
175: 'Entering fpa_main_process_pvt.initiate_workflow');
176: END IF;
177:

Line 182: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

178: l_itemtype := 'FPAPJP';
179:
180: l_itemkey := p_pc_id;
181:
182: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
183: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
184: 'fpa.sql.fpa_main_process_pvt.initiate_workflow',
185: 'Starting the master workflow process');
186: END IF;

Line 183: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

179:
180: l_itemkey := p_pc_id;
181:
182: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
183: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
184: 'fpa.sql.fpa_main_process_pvt.initiate_workflow',
185: 'Starting the master workflow process');
186: END IF;
187:

Line 264: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

260: -- Starts the workflow process
261: wf_engine.StartProcess(itemtype => l_itemtype,
262: itemkey => l_itemkey);
263:
264: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
265: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
266: 'fpa.sql.fpa_main_process_pvt.initiate_workflow.end',
267: 'Exiting fpa_main_process_pvt.initiate_workflow');
268: END IF;

Line 265: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

261: wf_engine.StartProcess(itemtype => l_itemtype,
262: itemkey => l_itemkey);
263:
264: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
265: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
266: 'fpa.sql.fpa_main_process_pvt.initiate_workflow.end',
267: 'Exiting fpa_main_process_pvt.initiate_workflow');
268: END IF;
269:

Line 272: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

268: END IF;
269:
270: EXCEPTION
271: WHEN OTHERS THEN
272: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
273: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
274: 'fpa.sql.fpa_main_process_pvt.initiate_workflow.end',
275: SQLERRM);
276: END IF;

Line 273: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

269:
270: EXCEPTION
271: WHEN OTHERS THEN
272: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
273: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
274: 'fpa.sql.fpa_main_process_pvt.initiate_workflow.end',
275: SQLERRM);
276: END IF;
277: wf_core.context('FPA_MAIN_PROCESS_PVT', 'INITIATE_WORKFLOW', null);

Line 310: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

306: l_nextval NUMBER := null;
307:
308: BEGIN
309:
310: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
311: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
312: 'fpa.sql.fpa_main_process_pvt.cancel_workflow.begin',
313: 'Entering fpa_main_process_pvt.cancel_workflow');
314: END IF;

Line 311: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

307:
308: BEGIN
309:
310: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
311: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
312: 'fpa.sql.fpa_main_process_pvt.cancel_workflow.begin',
313: 'Entering fpa_main_process_pvt.cancel_workflow');
314: END IF;
315:

Line 316: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

312: 'fpa.sql.fpa_main_process_pvt.cancel_workflow.begin',
313: 'Entering fpa_main_process_pvt.cancel_workflow');
314: END IF;
315:
316: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
317: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
318: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
319: 'Cancelling the master WF process; Call wf_engine.AbortProcess');
320: END IF;

Line 317: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

313: 'Entering fpa_main_process_pvt.cancel_workflow');
314: END IF;
315:
316: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
317: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
318: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
319: 'Cancelling the master WF process; Call wf_engine.AbortProcess');
320: END IF;
321:

Line 327: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

323: wf_engine.AbortProcess(itemtype => l_itemtype,
324: itemkey => l_itemkey,
325: process => l_WFProcess);
326:
327: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
328: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
329: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
330: 'Canceled the master WF process; wf_engine.AbortProcess executed');
331: END IF;

Line 328: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

324: itemkey => l_itemkey,
325: process => l_WFProcess);
326:
327: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
328: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
329: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
330: 'Canceled the master WF process; wf_engine.AbortProcess executed');
331: END IF;
332:

Line 336: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

332:
333: -- Reassign a new item key to the new process
334: l_itemkey := 'FPAF' || p_pc_id;
335:
336: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
337: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
338: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
339: 'l_item_key = '||l_itemkey||'; l_itemtype = '||l_itemtype);
340: END IF;

Line 337: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

333: -- Reassign a new item key to the new process
334: l_itemkey := 'FPAF' || p_pc_id;
335:
336: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
337: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
338: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
339: 'l_item_key = '||l_itemkey||'; l_itemtype = '||l_itemtype);
340: END IF;
341:

Line 342: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

338: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
339: 'l_item_key = '||l_itemkey||'; l_itemtype = '||l_itemtype);
340: END IF;
341:
342: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
343: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
344: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
345: 'l_process = '||l_process||'; p_pc_id = '||p_pc_id);
346: END IF;

Line 343: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

339: 'l_item_key = '||l_itemkey||'; l_itemtype = '||l_itemtype);
340: END IF;
341:
342: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
343: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
344: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
345: 'l_process = '||l_process||'; p_pc_id = '||p_pc_id);
346: END IF;
347:

Line 354: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

350: wf_engine.CreateProcess(itemtype => l_itemtype,
351: itemkey => l_itemkey,
352: process => l_process);
353:
354: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
356: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
357: 'executed wf_engine.createProcess API');
358: END IF;

Line 355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

351: itemkey => l_itemkey,
352: process => l_process);
353:
354: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
356: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
357: 'executed wf_engine.createProcess API');
358: END IF;
359:

Line 367: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

363: aname => 'FPA_PC_ID',
364: avalue => p_pc_id);
365:
366:
367: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
368: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
369: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
370: 'executed wf_engine.SetItemAttrNumber API');
371: END IF;

Line 368: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

364: avalue => p_pc_id);
365:
366:
367: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
368: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
369: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
370: 'executed wf_engine.SetItemAttrNumber API');
371: END IF;
372:

Line 379: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

375: itemkey => l_itemkey,
376: aname => 'FPA_DUE_DATE',
377: avalue => p_due_date);
378:
379: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
380: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
381: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
382: 'executed wf_engine.SetItemAttrDate API');
383: END IF;

Line 380: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

376: aname => 'FPA_DUE_DATE',
377: avalue => p_due_date);
378:
379: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
380: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
381: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
382: 'executed wf_engine.SetItemAttrDate API');
383: END IF;
384:

Line 389: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

385: -- Starts the workflow process
386: wf_engine.StartProcess(itemtype => l_itemtype,
387: itemkey => l_itemkey);
388:
389: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
391: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
392: 'executed wf_engine.StartProcess API');
393: END IF;

Line 390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

386: wf_engine.StartProcess(itemtype => l_itemtype,
387: itemkey => l_itemkey);
388:
389: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
390: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
391: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
392: 'executed wf_engine.StartProcess API');
393: END IF;
394:

Line 396: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

392: 'executed wf_engine.StartProcess API');
393: END IF;
394:
395:
396: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
398: 'fpa.sql.fpa_main_process_pvt.cancel_workflow.end',
399: 'Exiting fpa_main_process_pvt.cancel_workflow');
400: END IF;

Line 397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

393: END IF;
394:
395:
396: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
398: 'fpa.sql.fpa_main_process_pvt.cancel_workflow.end',
399: 'Exiting fpa_main_process_pvt.cancel_workflow');
400: END IF;
401:

Line 404: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

400: END IF;
401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
405: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
406: 'fpa.sql.fpa_main_process_pvt.cancel_workflow.end',
407: SQLERRM);
408: END IF;

Line 405: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
405: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
406: 'fpa.sql.fpa_main_process_pvt.cancel_workflow.end',
407: SQLERRM);
408: END IF;
409: wf_core.context('FPA_MAIN_PROCESS_PVT', 'CANCEL_WORKFLOW', null);

Line 443: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

439: l_pc_attributes_rec PC_ATTRIBUTES_REC_TYPE;
440:
441: BEGIN
442:
443: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
445: 'fpa.sql.fpa_main_process_pvt.launch_process.begin',
446: 'Entering fpa_main_process_pvt.launch_process');
447: END IF;

Line 444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

440:
441: BEGIN
442:
443: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
444: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
445: 'fpa.sql.fpa_main_process_pvt.launch_process.begin',
446: 'Entering fpa_main_process_pvt.launch_process');
447: END IF;
448:

Line 463: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

459: l_scenario_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
460: itemkey => p_itemkey,
461: aname => 'FPA_SCENARIO_ID');
462:
463: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
464: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
465: 'fpa.sql.fpa_main_process_pvt.launch_process',
466: 'Starting the main workflow process');
467: END IF;

Line 464: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

460: itemkey => p_itemkey,
461: aname => 'FPA_SCENARIO_ID');
462:
463: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
464: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
465: 'fpa.sql.fpa_main_process_pvt.launch_process',
466: 'Starting the main workflow process');
467: END IF;
468:

Line 518: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

514: -- Starts the workflow process
515: wf_engine.StartProcess(itemtype => l_itemtype,
516: itemkey => l_itemkey);
517:
518: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
519: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
520: 'fpa.sql.fpa_main_process_pvt.launch_process.end',
521: 'Exiting fpa_main_process_pvt.launch_process');
522: END IF;

Line 519: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

515: wf_engine.StartProcess(itemtype => l_itemtype,
516: itemkey => l_itemkey);
517:
518: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
519: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
520: 'fpa.sql.fpa_main_process_pvt.launch_process.end',
521: 'Exiting fpa_main_process_pvt.launch_process');
522: END IF;
523:

Line 526: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

522: END IF;
523:
524: EXCEPTION
525: WHEN OTHERS THEN
526: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
528: 'fpa.sql.fpa_main_process_pvt.launch_process.end',
529: SQLERRM);
530: END IF;

Line 527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

523:
524: EXCEPTION
525: WHEN OTHERS THEN
526: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
527: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
528: 'fpa.sql.fpa_main_process_pvt.launch_process.end',
529: SQLERRM);
530: END IF;
531: wf_core.context('FPA_MAIN_PROCESS_PVT', 'LAUNCH_PROCESS', null);

Line 553: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

549: AND end_date IS NULL;
550:
551: BEGIN
552:
553: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
554: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
555: 'fpa.sql.fpa_main_process_pvt.raise_closepc_event.begin',
556: 'Entering fpa_main_process_pvt.raise_closepc_event for p_pc_id'||p_pc_id);
557: END IF;

Line 554: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

550:
551: BEGIN
552:
553: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
554: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
555: 'fpa.sql.fpa_main_process_pvt.raise_closepc_event.begin',
556: 'Entering fpa_main_process_pvt.raise_closepc_event for p_pc_id'||p_pc_id);
557: END IF;
558:

Line 561: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

557: END IF;
558:
559: FOR c_rec IN C_abort_activepcwf LOOP
560:
561: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
562: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
563: 'fpa.sql.fpa_main_process_pvt.raise_closepc_event',
564: 'Aborting workflow process '||c_rec.item_key);
565: END IF;

Line 562: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

558:
559: FOR c_rec IN C_abort_activepcwf LOOP
560:
561: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
562: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
563: 'fpa.sql.fpa_main_process_pvt.raise_closepc_event',
564: 'Aborting workflow process '||c_rec.item_key);
565: END IF;
566:

Line 577: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

573:
574: -- Code to start new workflow process for Closing Planning cycle
575: l_itemkey := 'FPAC'||p_pc_id;
576:
577: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
578: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
579: 'fpa.sql.fpa_main_process_pvt.raise_closepc_event',
580: 'Calling wf_event.AddParameterToList ');
581: END IF;

Line 578: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

574: -- Code to start new workflow process for Closing Planning cycle
575: l_itemkey := 'FPAC'||p_pc_id;
576:
577: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
578: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
579: 'fpa.sql.fpa_main_process_pvt.raise_closepc_event',
580: 'Calling wf_event.AddParameterToList ');
581: END IF;
582:

Line 585: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

581: END IF;
582:
583: wf_event.AddParameterToList('FPA_PC_ID',p_pc_id,l_parameter_list);
584:
585: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
586: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
587: 'fpa.sql.fpa_main_process_pvt.raise_closepc_event',
588: 'Raising event oracle.apps.fpa.event.planningcycle.closed');
589: END IF;

Line 586: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

582:
583: wf_event.AddParameterToList('FPA_PC_ID',p_pc_id,l_parameter_list);
584:
585: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
586: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
587: 'fpa.sql.fpa_main_process_pvt.raise_closepc_event',
588: 'Raising event oracle.apps.fpa.event.planningcycle.closed');
589: END IF;
590:

Line 598: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

594: p_parameters => l_parameter_list);
595:
596: l_parameter_list.DELETE;
597:
598: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
599: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
600: 'fpa.sql.fpa_main_process_pvt.raise_closepc_event.end',
601: 'Entering fpa_main_process_pvt.raise_closepc_event');
602: END IF;

Line 599: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

595:
596: l_parameter_list.DELETE;
597:
598: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
599: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
600: 'fpa.sql.fpa_main_process_pvt.raise_closepc_event.end',
601: 'Entering fpa_main_process_pvt.raise_closepc_event');
602: END IF;
603:

Line 606: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

602: END IF;
603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
608: 'fpa.sql.fpa_main_process_pvt.raise_closepc_event.exception',
609: SQLERRM);
610: END IF;

Line 607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
607: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
608: 'fpa.sql.fpa_main_process_pvt.raise_closepc_event.exception',
609: SQLERRM);
610: END IF;
611: RAISE;

Line 731: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

727:
728: BEGIN
729:
730: -- Get the list of users to be notified
731: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
732: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
733: 'fpa.sql.fpa_main_process_pvt.GET_USERS.begin',
734: 'Entering fpa_main_process_pvt.GET_USERS for p_pcid '||p_pcid);
735: END IF;

Line 732: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

728: BEGIN
729:
730: -- Get the list of users to be notified
731: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
732: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
733: 'fpa.sql.fpa_main_process_pvt.GET_USERS.begin',
734: 'Entering fpa_main_process_pvt.GET_USERS for p_pcid '||p_pcid);
735: END IF;
736:

Line 756: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

752: and pcp.planning_cycle = p_pcid;
753:
754: IF p_approver = 'Y' OR p_analyst = 'Y' THEN
755:
756: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
757: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
758: 'fpa.sql.fpa_main_process_pvt.GET_USERS.begin',
759: 'Fetching users associated with portfolio access list');
760: END IF;

Line 757: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

753:
754: IF p_approver = 'Y' OR p_analyst = 'Y' THEN
755:
756: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
757: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
758: 'fpa.sql.fpa_main_process_pvt.GET_USERS.begin',
759: 'Fetching users associated with portfolio access list');
760: END IF;
761:

Line 799: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

795: END IF;
796:
797: IF p_pcdlist = 'Y' THEN
798:
799: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
800: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
801: 'fpa.sql.fpa_main_process_pvt.GET_USERS.begin',
802: 'Fetching users associated with planning cycle distribution list');
803: END IF;

Line 800: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

796:
797: IF p_pcdlist = 'Y' THEN
798:
799: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
800: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
801: 'fpa.sql.fpa_main_process_pvt.GET_USERS.begin',
802: 'Fetching users associated with planning cycle distribution list');
803: END IF;
804:

Line 840: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

836: END IF;
837:
838: IF p_projmg = 'Y' THEN
839:
840: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
841: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
842: 'fpa.sql.fpa_main_process_pvt.GET_USERS.begin',
843: 'Fetching users associated with project managers');
844: END IF;

Line 841: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

837:
838: IF p_projmg = 'Y' THEN
839:
840: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
841: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
842: 'fpa.sql.fpa_main_process_pvt.GET_USERS.begin',
843: 'Fetching users associated with project managers');
844: END IF;
845:

Line 864: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

860: CLOSE c_get_projmg_users ;
861:
862: END IF;
863:
864: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
865: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
866: 'fpa.sql.fpa_main_process_pvt.GET_USERS.end',
867: 'Exiting fpa_main_process_pvt.GET_USERS l_user_exists value '||l_user_exists);
868: END IF;

Line 865: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

861:
862: END IF;
863:
864: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
865: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
866: 'fpa.sql.fpa_main_process_pvt.GET_USERS.end',
867: 'Exiting fpa_main_process_pvt.GET_USERS l_user_exists value '||l_user_exists);
868: END IF;
869:

Line 874: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

870: p_user_exists := l_user_exists;
871:
872: EXCEPTION
873: WHEN OTHERS THEN
874: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
875: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
876: 'fpa.sql.fpa_main_process_pvt.GET_USERS.end',
877: SQLERRM);
878: END IF;

Line 875: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

871:
872: EXCEPTION
873: WHEN OTHERS THEN
874: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
875: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
876: 'fpa.sql.fpa_main_process_pvt.GET_USERS.end',
877: SQLERRM);
878: END IF;
879:

Line 914: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

910: pragma exception_init(WF_API_EXCEPTION, -20002);
911:
912: BEGIN
913:
914: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
915: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
916: 'fpa.sql.fpa_main_process_pvt.create_role.begin',
917: 'Entering fpa_main_process_pvt.create_role');
918: END IF;

Line 915: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

911:
912: BEGIN
913:
914: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
915: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
916: 'fpa.sql.fpa_main_process_pvt.create_role.begin',
917: 'Entering fpa_main_process_pvt.create_role');
918: END IF;
919:

Line 945: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

941: l_analyst := 'Y';
942: l_projmg := 'Y';
943: END IF;
944:
945: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
946: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
947: 'fpa.sql.fpa_main_process_pvt.create_role.begin',
948: 'value of l_notify_role='||l_notify_role||'l_approver='||l_approver||'l_analyst='||l_analyst||'l_pcdlist='||l_pcdlist||'l_projmg='||l_projmg);
949: END IF;

Line 946: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

942: l_projmg := 'Y';
943: END IF;
944:
945: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
946: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
947: 'fpa.sql.fpa_main_process_pvt.create_role.begin',
948: 'value of l_notify_role='||l_notify_role||'l_approver='||l_approver||'l_analyst='||l_analyst||'l_pcdlist='||l_pcdlist||'l_projmg='||l_projmg);
949: END IF;
950:

Line 962: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

958: role_users => null,
959: email_address => null);
960: EXCEPTION
961: WHEN WF_API_EXCEPTION THEN
962: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
963: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
964: 'fpa.sql.fpa_main_process_pvt.CREATE_ROLE.exception',
965: SQLERRM);
966: END IF;

Line 963: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

959: email_address => null);
960: EXCEPTION
961: WHEN WF_API_EXCEPTION THEN
962: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
963: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
964: 'fpa.sql.fpa_main_process_pvt.CREATE_ROLE.exception',
965: SQLERRM);
966: END IF;
967:

Line 990: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

986: p_user_exists => l_user_exists ) ;
987:
988: p_user_exists := l_user_exists;
989:
990: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
991: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
992: 'fpa.sql.fpa_main_process_pvt.create_role.end',
993: 'Entering fpa_main_process_pvt.create_role,value of p_user_exists'||p_user_exists);
994: END IF;

Line 991: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

987:
988: p_user_exists := l_user_exists;
989:
990: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
991: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
992: 'fpa.sql.fpa_main_process_pvt.create_role.end',
993: 'Entering fpa_main_process_pvt.create_role,value of p_user_exists'||p_user_exists);
994: END IF;
995:

Line 998: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

994: END IF;
995:
996: EXCEPTION
997: WHEN OTHERS THEN
998: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
999: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1000: 'fpa.sql.fpa_main_process_pvt.CREATE_ROLE.end',
1001: SQLERRM);
1002: END IF;

Line 999: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

995:
996: EXCEPTION
997: WHEN OTHERS THEN
998: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
999: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1000: 'fpa.sql.fpa_main_process_pvt.CREATE_ROLE.end',
1001: SQLERRM);
1002: END IF;
1003: wf_core.context('FPA_MAIN_PROCESS_PVT', 'CREATE_ROLE', SQLERRM);

Line 1022: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1018:
1019: BEGIN
1020:
1021: /* Get the list of users having project manager role */
1022: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1023: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1024: 'fpa.sql.fpa_main_process_pvt.get_dlist.begin',
1025: 'Entering fpa_main_process_pvt.get_dlist');
1026: END IF;

Line 1023: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1019: BEGIN
1020:
1021: /* Get the list of users having project manager role */
1022: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1023: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1024: 'fpa.sql.fpa_main_process_pvt.get_dlist.begin',
1025: 'Entering fpa_main_process_pvt.get_dlist');
1026: END IF;
1027:

Line 1046: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1042: x_resultout := wf_engine.eng_completed||':'||'F';
1043: END IF;
1044:
1045:
1046: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1047: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1048: 'fpa.sql.fpa_main_process_pvt.get_dlist.end',
1049: 'Exiting fpa_main_process_pvt.get_dlist');
1050: END IF;

Line 1047: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1043: END IF;
1044:
1045:
1046: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1047: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1048: 'fpa.sql.fpa_main_process_pvt.get_dlist.end',
1049: 'Exiting fpa_main_process_pvt.get_dlist');
1050: END IF;
1051:

Line 1054: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1050: END IF;
1051:
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1055: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1056: 'fpa.sql.fpa_main_process_pvt.get_dlist.end',
1057: SQLERRM);
1058: END IF;

Line 1055: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1051:
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1055: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1056: 'fpa.sql.fpa_main_process_pvt.get_dlist.end',
1057: SQLERRM);
1058: END IF;
1059: wf_core.context('FPA_MAIN_PROCESS_PVT', g_get_pc_dlist, SQLERRM);

Line 1078: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1074:
1075: BEGIN
1076:
1077: -- Get the list of users to be notified
1078: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1079: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1080: 'fpa.sql.fpa_main_process_pvt.get_alist.begin',
1081: 'Entering fpa_main_process_pvt.get_alist');
1082: END IF;

Line 1079: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1075: BEGIN
1076:
1077: -- Get the list of users to be notified
1078: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1079: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1080: 'fpa.sql.fpa_main_process_pvt.get_alist.begin',
1081: 'Entering fpa_main_process_pvt.get_alist');
1082: END IF;
1083:

Line 1101: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1097: ELSE
1098: x_resultout := wf_engine.eng_completed||':'||'F';
1099: END IF;
1100:
1101: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1102: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1103: 'fpa.sql.fpa_main_process_pvt.get_alist.end',
1104: 'Exiting fpa_main_process_pvt.get_alist');
1105: END IF;

Line 1102: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1098: x_resultout := wf_engine.eng_completed||':'||'F';
1099: END IF;
1100:
1101: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1102: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1103: 'fpa.sql.fpa_main_process_pvt.get_alist.end',
1104: 'Exiting fpa_main_process_pvt.get_alist');
1105: END IF;
1106: EXCEPTION

Line 1108: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1104: 'Exiting fpa_main_process_pvt.get_alist');
1105: END IF;
1106: EXCEPTION
1107: WHEN OTHERS THEN
1108: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1109: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1110: 'fpa.sql.fpa_main_process_pvt.get_alist.end',
1111: SQLERRM);
1112: END IF;

Line 1109: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1105: END IF;
1106: EXCEPTION
1107: WHEN OTHERS THEN
1108: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1109: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1110: 'fpa.sql.fpa_main_process_pvt.get_alist.end',
1111: SQLERRM);
1112: END IF;
1113: wf_core.context('FPA_MAIN_PROCESS_PVT', g_get_port_users, SQLERRM);

Line 1131: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1127:
1128: BEGIN
1129:
1130: /* Get the list of users having project manager role */
1131: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1132: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1133: 'fpa.sql.fpa_main_process_pvt.get_approver.begin',
1134: 'Entering fpa_main_process_pvt.get_approver');
1135: END IF;

Line 1132: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1128: BEGIN
1129:
1130: /* Get the list of users having project manager role */
1131: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1132: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1133: 'fpa.sql.fpa_main_process_pvt.get_approver.begin',
1134: 'Entering fpa_main_process_pvt.get_approver');
1135: END IF;
1136:

Line 1155: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1151: x_resultout := wf_engine.eng_completed||':'||'F';
1152: END IF;
1153:
1154:
1155: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1156: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1157: 'fpa.sql.fpa_main_process_pvt.get_approver.end',
1158: 'Exiting fpa_main_process_pvt.get_approver');
1159: END IF;

Line 1156: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1152: END IF;
1153:
1154:
1155: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1156: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1157: 'fpa.sql.fpa_main_process_pvt.get_approver.end',
1158: 'Exiting fpa_main_process_pvt.get_approver');
1159: END IF;
1160:

Line 1163: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1159: END IF;
1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1164: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1165: 'fpa.sql.fpa_main_process_pvt.get_approver.end',
1166: SQLERRM);
1167: END IF;

Line 1164: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1164: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1165: 'fpa.sql.fpa_main_process_pvt.get_approver.end',
1166: SQLERRM);
1167: END IF;
1168: wf_core.context('FPA_MAIN_PROCESS_PVT', 'GET_DLIST', SQLERRM);

Line 1186: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1182:
1183: BEGIN
1184:
1185: /* Get the list of users having project manager role */
1186: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1187: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1188: 'fpa.sql.fpa_main_process_pvt.get_analyst.begin',
1189: 'Entering fpa_main_process_pvt.get_analyst');
1190: END IF;

Line 1187: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1183: BEGIN
1184:
1185: /* Get the list of users having project manager role */
1186: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1187: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1188: 'fpa.sql.fpa_main_process_pvt.get_analyst.begin',
1189: 'Entering fpa_main_process_pvt.get_analyst');
1190: END IF;
1191:

Line 1210: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1206: x_resultout := wf_engine.eng_completed||':'||'F';
1207: END IF;
1208:
1209:
1210: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1211: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1212: 'fpa.sql.fpa_main_process_pvt.get_analyst.end',
1213: 'Exiting fpa_main_process_pvt.get_analyst');
1214: END IF;

Line 1211: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1207: END IF;
1208:
1209:
1210: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1211: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1212: 'fpa.sql.fpa_main_process_pvt.get_analyst.end',
1213: 'Exiting fpa_main_process_pvt.get_analyst');
1214: END IF;
1215:

Line 1218: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1214: END IF;
1215:
1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1219: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1220: 'fpa.sql.fpa_main_process_pvt.get_analyst.end',
1221: SQLERRM);
1222: END IF;

Line 1219: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1215:
1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1219: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1220: 'fpa.sql.fpa_main_process_pvt.get_analyst.end',
1221: SQLERRM);
1222: END IF;
1223: wf_core.context('FPA_MAIN_PROCESS_PVT', g_get_port_analyst, SQLERRM);

Line 1244: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1240:
1241: BEGIN
1242:
1243: /* Get the list of users having project manager role */
1244: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1245: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1246: 'fpa.sql.fpa_main_process_pvt.get_pc_managers.begin',
1247: 'Entering fpa_main_process_pvt.get_pc_managers');
1248: END IF;

Line 1245: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1241: BEGIN
1242:
1243: /* Get the list of users having project manager role */
1244: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1245: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1246: 'fpa.sql.fpa_main_process_pvt.get_pc_managers.begin',
1247: 'Entering fpa_main_process_pvt.get_pc_managers');
1248: END IF;
1249:

Line 1268: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1264: x_resultout := wf_engine.eng_completed||':'||'F';
1265: END IF;
1266:
1267:
1268: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1269: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1270: 'fpa.sql.fpa_main_process_pvt.get_pc_managers.end',
1271: 'Exiting fpa_main_process_pvt.get_pc_managers');
1272: END IF;

Line 1269: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1265: END IF;
1266:
1267:
1268: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1269: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1270: 'fpa.sql.fpa_main_process_pvt.get_pc_managers.end',
1271: 'Exiting fpa_main_process_pvt.get_pc_managers');
1272: END IF;
1273:

Line 1276: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1272: END IF;
1273:
1274: EXCEPTION
1275: WHEN OTHERS THEN
1276: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1277: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1278: 'fpa.sql.fpa_main_process_pvt.get_pc_managers.end',
1279: SQLERRM);
1280: END IF;

Line 1277: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1273:
1274: EXCEPTION
1275: WHEN OTHERS THEN
1276: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1277: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1278: 'fpa.sql.fpa_main_process_pvt.get_pc_managers.end',
1279: SQLERRM);
1280: END IF;
1281: wf_core.context('FPA_MAIN_PROCESS_PVT', g_get_pc_manager, SQLERRM);

Line 1305: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1301: x_resultout := null;
1302:
1303: EXCEPTION
1304: WHEN OTHERS THEN
1305: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1306: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1307: 'fpa.sql.fpa_main_process_pvt.call_proj_load.end',
1308: SQLERRM);
1309: END IF;

Line 1306: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1302:
1303: EXCEPTION
1304: WHEN OTHERS THEN
1305: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1306: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1307: 'fpa.sql.fpa_main_process_pvt.call_proj_load.end',
1308: SQLERRM);
1309: END IF;
1310: wf_core.context('FPA_MAIN_PROCESS_PVT', 'CALL_PROJ_LOAD', SQLERRM);

Line 1337: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1333: l_scenario_desc fpa_lookups_v.meaning%TYPE := null;
1334:
1335: BEGIN
1336:
1337: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1338: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1339: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1340: 'Entering fpa_main_process_pvt.call_create_initial_scenario');
1341: END IF;

Line 1338: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1334:
1335: BEGIN
1336:
1337: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1338: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1339: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1340: 'Entering fpa_main_process_pvt.call_create_initial_scenario');
1341: END IF;
1342:

Line 1343: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1339: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1340: 'Entering fpa_main_process_pvt.call_create_initial_scenario');
1341: END IF;
1342:
1343: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1344: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1345: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1346: 'Getting Planning Cycle ID.');
1347: END IF;

Line 1344: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1340: 'Entering fpa_main_process_pvt.call_create_initial_scenario');
1341: END IF;
1342:
1343: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1344: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1345: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1346: 'Getting Planning Cycle ID.');
1347: END IF;
1348:

Line 1355: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1351: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1352: itemkey => p_itemkey,
1353: aname => 'FPA_PC_ID');
1354:
1355: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1356: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1357: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1358: 'Getting Initial scenario name.');
1359: END IF;

Line 1356: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1352: itemkey => p_itemkey,
1353: aname => 'FPA_PC_ID');
1354:
1355: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1356: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1357: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1358: 'Getting Initial scenario name.');
1359: END IF;
1360:

Line 1372: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1368: WHEN OTHERS THEN
1369: null;
1370: END;
1371:
1372: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1373: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1374: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1375: 'Getting discount rate and funds available.');
1376: END IF;

Line 1373: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1369: null;
1370: END;
1371:
1372: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1373: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1374: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1375: 'Getting discount rate and funds available.');
1376: END IF;
1377:

Line 1396: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1392:
1393: -- Initial Scenario description is the same as name
1394: l_scenario_desc := l_scenario_name;
1395:
1396: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1398: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1399: 'Calling fpa_scenario_pvt.create_scenario.');
1400: END IF;

Line 1397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1393: -- Initial Scenario description is the same as name
1394: l_scenario_desc := l_scenario_name;
1395:
1396: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1397: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1398: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1399: 'Calling fpa_scenario_pvt.create_scenario.');
1400: END IF;
1401:

Line 1413: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1409: x_return_status => l_return_status,
1410: x_msg_count => l_msg_count,
1411: x_msg_data => l_msg_data);
1412:
1413: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1414: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1415: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1416: 'Calling fpa_scenario_pvt.update_scenario_disc_rate.');
1417: END IF;

Line 1414: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1410: x_msg_count => l_msg_count,
1411: x_msg_data => l_msg_data);
1412:
1413: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1414: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1415: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1416: 'Calling fpa_scenario_pvt.update_scenario_disc_rate.');
1417: END IF;
1418:

Line 1428: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1424: x_return_status => l_return_status,
1425: x_msg_count => l_msg_count,
1426: x_msg_data => l_msg_data);
1427:
1428: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1429: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1430: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.',
1431: 'Calling fpa_scenario_pvt.update_scenario_funds_avail.');
1432: END IF;

Line 1429: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1425: x_msg_count => l_msg_count,
1426: x_msg_data => l_msg_data);
1427:
1428: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1429: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1430: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.',
1431: 'Calling fpa_scenario_pvt.update_scenario_funds_avail.');
1432: END IF;
1433:

Line 1444: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1440: x_msg_count => l_msg_count,
1441: x_msg_data => l_msg_data);
1442:
1443:
1444: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1446: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.',
1447: 'Calling fpa_scenario_pvt.update_scenario_initial_flag.');
1448: END IF;

Line 1445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1441: x_msg_data => l_msg_data);
1442:
1443:
1444: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1445: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1446: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.',
1447: 'Calling fpa_scenario_pvt.update_scenario_initial_flag.');
1448: END IF;
1449:

Line 1458: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1454: x_return_status => l_return_status,
1455: x_msg_count => l_msg_count,
1456: x_msg_data => l_msg_data);
1457:
1458: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1459: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1460: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.',
1461: 'Calling fpa_scenario_pvt.update_scenario_working_flag.');
1462: END IF;

Line 1459: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1455: x_msg_count => l_msg_count,
1456: x_msg_data => l_msg_data);
1457:
1458: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1459: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1460: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.',
1461: 'Calling fpa_scenario_pvt.update_scenario_working_flag.');
1462: END IF;
1463:

Line 1472: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1468: x_return_status => l_return_status,
1469: x_msg_count => l_msg_count,
1470: x_msg_data => l_msg_data);
1471:
1472: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1474: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.',
1475: 'Calling Fpa_Project_Pvt.Load_Project_Details_Aw.');
1476: END IF;

Line 1473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1469: x_msg_count => l_msg_count,
1470: x_msg_data => l_msg_data);
1471:
1472: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1474: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.',
1475: 'Calling Fpa_Project_Pvt.Load_Project_Details_Aw.');
1476: END IF;
1477:

Line 1489: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1485: x_msg_count => l_msg_count,
1486: x_msg_data => l_msg_data
1487: );
1488:
1489: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1491: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.',
1492: 'Calling fpa_scenario_pvt.calc_scenario_data.');
1493: END IF;

Line 1490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1486: x_msg_data => l_msg_data
1487: );
1488:
1489: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1490: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1491: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.',
1492: 'Calling fpa_scenario_pvt.calc_scenario_data.');
1493: END IF;
1494:

Line 1507: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1503: x_msg_count => l_msg_count,
1504: x_msg_data => l_msg_data
1505: );
1506:
1507: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1508: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1509: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.',
1510: 'Calling fpa_scorecard_pvt.calc_scenario_data.');
1511: END IF;

Line 1508: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1504: x_msg_data => l_msg_data
1505: );
1506:
1507: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1508: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1509: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.',
1510: 'Calling fpa_scorecard_pvt.calc_scenario_data.');
1511: END IF;
1512:

Line 1524: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1520: x_msg_data => l_msg_data
1521: );
1522:
1523:
1524: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1526: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1527: 'Calling wf_engine.SetItemAttrNumber.');
1528: END IF;

Line 1525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1521: );
1522:
1523:
1524: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1525: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1526: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1527: 'Calling wf_engine.SetItemAttrNumber.');
1528: END IF;
1529:

Line 1539: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1535: x_resultout := null;
1536:
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1540: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1541: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.end',
1542: SQLERRM);
1543: END IF;

Line 1540: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1536:
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1540: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1541: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.end',
1542: SQLERRM);
1543: END IF;
1544:

Line 1596: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1592: x_resultout := wf_engine.eng_null;
1593:
1594: EXCEPTION
1595: WHEN OTHERS THEN
1596: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1597: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1598: 'fpa.sql.fpa_main_process_pvt.call_set_status.end',
1599: SQLERRM);
1600: END IF;

Line 1597: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1593:
1594: EXCEPTION
1595: WHEN OTHERS THEN
1596: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1597: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1598: 'fpa.sql.fpa_main_process_pvt.call_set_status.end',
1599: SQLERRM);
1600: END IF;
1601: wf_core.context('FPA_MAIN_PROCESS_PVT', 'CALL_SET_STATUS', SQLERRM);

Line 1623: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1619: l_scen_id NUMBER := null;
1620:
1621: BEGIN
1622:
1623: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1624: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1625: 'fpa.sql.fpa_main_process_pvt.call_project_sets.begin',
1626: 'Entering fpa_main_process_pvt.call_project_sets');
1627: END IF;

Line 1624: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1620:
1621: BEGIN
1622:
1623: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1624: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1625: 'fpa.sql.fpa_main_process_pvt.call_project_sets.begin',
1626: 'Entering fpa_main_process_pvt.call_project_sets');
1627: END IF;
1628:

Line 1643: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1639: x_return_status => l_return_status,
1640: x_msg_data => l_msg_data,
1641: x_msg_count => l_msg_count);
1642:
1643: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1644: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1645: 'fpa.sql.fpa_main_process_pvt.call_project_sets.end',
1646: 'Exiting fpa_main_process_pvt.call_project_sets');
1647: END IF;

Line 1644: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1640: x_msg_data => l_msg_data,
1641: x_msg_count => l_msg_count);
1642:
1643: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1644: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1645: 'fpa.sql.fpa_main_process_pvt.call_project_sets.end',
1646: 'Exiting fpa_main_process_pvt.call_project_sets');
1647: END IF;
1648:

Line 1653: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1649: x_resultout := wf_engine.eng_null;
1650:
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1654: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1655: 'fpa.sql.fpa_main_process_pvt.call_project_sets.end',
1656: SQLERRM);
1657: END IF;

Line 1654: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1650:
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1654: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1655: 'fpa.sql.fpa_main_process_pvt.call_project_sets.end',
1656: SQLERRM);
1657: END IF;
1658: wf_core.context('FPA_MAIN_PROCESS_PVT', 'CALL_PROJECT_SETS', SQLERRM);

Line 1689: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1685: l_is_approved := wf_engine.GetItemAttrText(itemtype => p_itemtype,
1686: itemkey => p_itemkey,
1687: aname => 'FPA_APPROVE_PC');
1688:
1689: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1690: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1691: 'fpa.sql.fpa_main_process_pvt.is_plan_approved.begin',
1692: 'value of l_is_approved'|| l_is_approved||'p_itemkey '||p_itemkey||'p_funcmode '||p_funcmode);
1693: END IF;

Line 1690: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1686: itemkey => p_itemkey,
1687: aname => 'FPA_APPROVE_PC');
1688:
1689: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1690: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1691: 'fpa.sql.fpa_main_process_pvt.is_plan_approved.begin',
1692: 'value of l_is_approved'|| l_is_approved||'p_itemkey '||p_itemkey||'p_funcmode '||p_funcmode);
1693: END IF;
1694:

Line 1703: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1699: END IF;
1700:
1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1704: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1705: 'fpa.sql.fpa_main_process_pvt.is_plan_approved.end',
1706: SQLERRM);
1707: END IF;

Line 1704: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1700:
1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1704: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1705: 'fpa.sql.fpa_main_process_pvt.is_plan_approved.end',
1706: SQLERRM);
1707: END IF;
1708: wf_core.context('FPA_MAIN_PROCESS_PVT', 'IS_PLAN_APPROVED', SQLERRM);

Line 1750: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1746: x_resultout := wf_engine.eng_null;
1747:
1748: EXCEPTION
1749: WHEN OTHERS THEN
1750: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1751: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1752: 'fpa.sql.fpa_main_process_pvt.set_status_analysis.end',
1753: SQLERRM);
1754: END IF;

Line 1751: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1747:
1748: EXCEPTION
1749: WHEN OTHERS THEN
1750: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1751: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1752: 'fpa.sql.fpa_main_process_pvt.set_status_analysis.end',
1753: SQLERRM);
1754: END IF;
1755: wf_core.context('FPA_MAIN_PROCESS_PVT', 'SET_STATUS_ANALYSIS', SQLERRM);

Line 1777: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1773: l_pc_approve VARCHAR2(1) := null;
1774:
1775: BEGIN
1776:
1777: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1778: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1779: 'fpa.sql.fpa_main_process_pvt.set_status_approved.begin',
1780: 'Entering fpa_main_process_pvt.set_status_approved p_itemkey'||p_itemkey);
1781: END IF;

Line 1778: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1774:
1775: BEGIN
1776:
1777: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1778: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1779: 'fpa.sql.fpa_main_process_pvt.set_status_approved.begin',
1780: 'Entering fpa_main_process_pvt.set_status_approved p_itemkey'||p_itemkey);
1781: END IF;
1782:

Line 1799: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1795: l_pc_status := 'ANALYSIS';
1796: END IF;
1797:
1798:
1799: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1800: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1801: 'fpa.sql.fpa_main_process_pvt.set_status_approved',
1802: 'Value of l_pc_id ='||l_pc_id||' Value of l_pc_status='||l_pc_status||' Value of l_pc_approve ='||l_pc_approve);
1803: END IF;

Line 1800: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1796: END IF;
1797:
1798:
1799: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1800: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1801: 'fpa.sql.fpa_main_process_pvt.set_status_approved',
1802: 'Value of l_pc_id ='||l_pc_id||' Value of l_pc_status='||l_pc_status||' Value of l_pc_approve ='||l_pc_approve);
1803: END IF;
1804:

Line 1816: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1812: x_msg_data => l_msg_data);
1813:
1814: x_resultout := wf_engine.eng_null;
1815:
1816: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1817: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1818: 'fpa.sql.fpa_main_process_pvt.set_status_approved.end',
1819: 'Exiting fpa_main_process_pvt.set_status_approved');
1820: END IF;

Line 1817: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1813:
1814: x_resultout := wf_engine.eng_null;
1815:
1816: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1817: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1818: 'fpa.sql.fpa_main_process_pvt.set_status_approved.end',
1819: 'Exiting fpa_main_process_pvt.set_status_approved');
1820: END IF;
1821:

Line 1824: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1820: END IF;
1821:
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1825: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1826: 'fpa.sql.fpa_main_process_pvt.set_status_approved.end',
1827: SQLERRM);
1828: END IF;

Line 1825: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1821:
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1825: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1826: 'fpa.sql.fpa_main_process_pvt.set_status_approved.end',
1827: SQLERRM);
1828: END IF;
1829: wf_core.context('FPA_MAIN_PROCESS_PVT', 'SET_STATUS_APPROVED', SQLERRM);

Line 1850: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1846: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;
1847:
1848: BEGIN
1849:
1850: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1851: FND_LOG.String
1852: ( FND_LOG.LEVEL_PROCEDURE,
1853: 'fpa.sql.FPA_main_process_pvt.set_status_closed.begin',
1854: 'Calling FPA_PlanningCycle_Pvt.set_pc_status'

Line 1851: FND_LOG.String

1847:
1848: BEGIN
1849:
1850: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1851: FND_LOG.String
1852: ( FND_LOG.LEVEL_PROCEDURE,
1853: 'fpa.sql.FPA_main_process_pvt.set_status_closed.begin',
1854: 'Calling FPA_PlanningCycle_Pvt.set_pc_status'
1855: );

Line 1852: ( FND_LOG.LEVEL_PROCEDURE,

1848: BEGIN
1849:
1850: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1851: FND_LOG.String
1852: ( FND_LOG.LEVEL_PROCEDURE,
1853: 'fpa.sql.FPA_main_process_pvt.set_status_closed.begin',
1854: 'Calling FPA_PlanningCycle_Pvt.set_pc_status'
1855: );
1856: END IF;

Line 1873: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1869: x_return_status => l_return_status,
1870: x_msg_count => l_msg_count,
1871: x_msg_data => l_msg_data);
1872:
1873: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1874: FND_LOG.String
1875: ( FND_LOG.LEVEL_PROCEDURE,
1876: 'FPA_main_process_pvt.set_status_closed',
1877: 'Calling FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag.'

Line 1874: FND_LOG.String

1870: x_msg_count => l_msg_count,
1871: x_msg_data => l_msg_data);
1872:
1873: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1874: FND_LOG.String
1875: ( FND_LOG.LEVEL_PROCEDURE,
1876: 'FPA_main_process_pvt.set_status_closed',
1877: 'Calling FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag.'
1878: );

Line 1875: ( FND_LOG.LEVEL_PROCEDURE,

1871: x_msg_data => l_msg_data);
1872:
1873: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1874: FND_LOG.String
1875: ( FND_LOG.LEVEL_PROCEDURE,
1876: 'FPA_main_process_pvt.set_status_closed',
1877: 'Calling FPA_PlanningCycle_Pvt.Set_Pc_Approved_Flag.'
1878: );
1879: END IF;

Line 1892: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1888: );
1889:
1890: x_resultout := wf_engine.eng_null;
1891:
1892: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1893: FND_LOG.String
1894: ( FND_LOG.LEVEL_PROCEDURE,
1895: 'fpa.sql.FPA_main_process_pvt.set_status_closed.end',
1896: 'FPA_main_process_pvt.set_status_closed.end'

Line 1893: FND_LOG.String

1889:
1890: x_resultout := wf_engine.eng_null;
1891:
1892: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1893: FND_LOG.String
1894: ( FND_LOG.LEVEL_PROCEDURE,
1895: 'fpa.sql.FPA_main_process_pvt.set_status_closed.end',
1896: 'FPA_main_process_pvt.set_status_closed.end'
1897: );

Line 1894: ( FND_LOG.LEVEL_PROCEDURE,

1890: x_resultout := wf_engine.eng_null;
1891:
1892: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1893: FND_LOG.String
1894: ( FND_LOG.LEVEL_PROCEDURE,
1895: 'fpa.sql.FPA_main_process_pvt.set_status_closed.end',
1896: 'FPA_main_process_pvt.set_status_closed.end'
1897: );
1898: END IF;

Line 1902: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1898: END IF;
1899:
1900: EXCEPTION
1901: WHEN OTHERS THEN
1902: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1903: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1904: 'fpa.sql.fpa_main_process_pvt.set_status_closed.end',
1905: SQLERRM);
1906: END IF;

Line 1903: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1899:
1900: EXCEPTION
1901: WHEN OTHERS THEN
1902: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1903: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1904: 'fpa.sql.fpa_main_process_pvt.set_status_closed.end',
1905: SQLERRM);
1906: END IF;
1907: wf_core.context('FPA_MAIN_PROCESS_PVT', 'SET_STATUS_CLOSED', SQLERRM);

Line 1949: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1945: x_resultout := wf_engine.eng_null;
1946:
1947: EXCEPTION
1948: WHEN OTHERS THEN
1949: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1950: fnd_log.string(
1951: FND_LOG.LEVEL_PROCEDURE,
1952: 'fpa.sql.fpa_main_process_pvt.set_status_collecting.end',
1953: SQLERRM);

Line 1950: fnd_log.string(

1946:
1947: EXCEPTION
1948: WHEN OTHERS THEN
1949: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1950: fnd_log.string(
1951: FND_LOG.LEVEL_PROCEDURE,
1952: 'fpa.sql.fpa_main_process_pvt.set_status_collecting.end',
1953: SQLERRM);
1954: END IF;

Line 1951: FND_LOG.LEVEL_PROCEDURE,

1947: EXCEPTION
1948: WHEN OTHERS THEN
1949: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1950: fnd_log.string(
1951: FND_LOG.LEVEL_PROCEDURE,
1952: 'fpa.sql.fpa_main_process_pvt.set_status_collecting.end',
1953: SQLERRM);
1954: END IF;
1955: wf_core.context('FPA_MAIN_PROCESS_PVT',

Line 2000: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1996: x_resultout := wf_engine.eng_null;
1997:
1998: EXCEPTION
1999: WHEN OTHERS THEN
2000: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2001: fnd_log.string(
2002: FND_LOG.LEVEL_PROCEDURE,
2003: 'fpa.sql.fpa_main_process_pvt.set_status_submitted.end',
2004: SQLERRM);

Line 2001: fnd_log.string(

1997:
1998: EXCEPTION
1999: WHEN OTHERS THEN
2000: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2001: fnd_log.string(
2002: FND_LOG.LEVEL_PROCEDURE,
2003: 'fpa.sql.fpa_main_process_pvt.set_status_submitted.end',
2004: SQLERRM);
2005: END IF;

Line 2002: FND_LOG.LEVEL_PROCEDURE,

1998: EXCEPTION
1999: WHEN OTHERS THEN
2000: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2001: fnd_log.string(
2002: FND_LOG.LEVEL_PROCEDURE,
2003: 'fpa.sql.fpa_main_process_pvt.set_status_submitted.end',
2004: SQLERRM);
2005: END IF;
2006: wf_core.context('FPA_MAIN_PROCESS_PVT', 'SET_STATUS_SUBMITTED', SQLERRM);

Line 2030: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2026: x_msg_data OUT NOCOPY VARCHAR2)
2027: IS
2028: BEGIN
2029:
2030: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2031: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2032: 'fpa.sql.fpa_main_process_pvt.force_user_action.begin',
2033: 'Entering fpa_main_process_pvt.force_user_action');
2034: END IF;

Line 2031: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2027: IS
2028: BEGIN
2029:
2030: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2031: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2032: 'fpa.sql.fpa_main_process_pvt.force_user_action.begin',
2033: 'Entering fpa_main_process_pvt.force_user_action');
2034: END IF;
2035:

Line 2039: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2035:
2036: -- Raise the user forced event
2037: wf_event.raise(p_event_name, p_itemkey, null, null);
2038:
2039: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2040: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2041: 'fpa.sql.fpa_main_process_pvt.force_user_action.end',
2042: 'Exiting fpa_main_process_pvt.force_user_action');
2043: END IF;

Line 2040: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2036: -- Raise the user forced event
2037: wf_event.raise(p_event_name, p_itemkey, null, null);
2038:
2039: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2040: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2041: 'fpa.sql.fpa_main_process_pvt.force_user_action.end',
2042: 'Exiting fpa_main_process_pvt.force_user_action');
2043: END IF;
2044:

Line 2047: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2043: END IF;
2044:
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2048: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2049: 'fpa.sql.fpa_main_process_pvt.force_user_action.end',
2050: SQLERRM);
2051: END IF;

Line 2048: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2044:
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2048: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2049: 'fpa.sql.fpa_main_process_pvt.force_user_action.end',
2050: SQLERRM);
2051: END IF;
2052: wf_core.context('FPA_MAIN_PROCESS_PVT', 'FORCE_USER_ACTION', SQLERRM);

Line 2079: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2075: l_msg_data VARCHAR2(2000);
2076:
2077: BEGIN
2078:
2079: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2080: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2081: 'fpa.sql.fpa_main_process_pvt.submit_plan.begin',
2082: 'Entering fpa_main_process_pvt.submit_plan value of p_itemkey'||p_itemkey);
2083: END IF;

Line 2080: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2076:
2077: BEGIN
2078:
2079: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2080: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2081: 'fpa.sql.fpa_main_process_pvt.submit_plan.begin',
2082: 'Entering fpa_main_process_pvt.submit_plan value of p_itemkey'||p_itemkey);
2083: END IF;
2084:

Line 2110: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2106: x_msg_data => l_msg_data);
2107:
2108: -- COMMIT;
2109:
2110: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2111: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2112: 'fpa.sql.fpa_main_process_pvt.submit_plan.end',
2113: 'Exiting fpa_main_process_pvt.submit_plan');
2114: END IF;

Line 2111: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2107:
2108: -- COMMIT;
2109:
2110: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2111: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2112: 'fpa.sql.fpa_main_process_pvt.submit_plan.end',
2113: 'Exiting fpa_main_process_pvt.submit_plan');
2114: END IF;
2115:

Line 2118: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2114: END IF;
2115:
2116: EXCEPTION
2117: WHEN OTHERS THEN
2118: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2119: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2120: 'fpa.sql.fpa_main_process_pvt.submit_plan.end',
2121: SQLERRM);
2122: END IF;

Line 2119: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2115:
2116: EXCEPTION
2117: WHEN OTHERS THEN
2118: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2119: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2120: 'fpa.sql.fpa_main_process_pvt.submit_plan.end',
2121: SQLERRM);
2122: END IF;
2123: wf_core.context('FPA_MAIN_PROCESS_PVT', 'SUBMIT_PLAN', SQLERRM);

Line 2149: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2145: l_sce_id number;
2146:
2147: BEGIN
2148:
2149: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2150: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2151: 'fpa.sql.fpa_main_process_pvt.approve_reject_plan.begin',
2152: 'Entering fpa_main_process_pvt.approve_reject_plan ACTION : '||p_event_name);
2153: END IF;

Line 2150: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2146:
2147: BEGIN
2148:
2149: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2150: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2151: 'fpa.sql.fpa_main_process_pvt.approve_reject_plan.begin',
2152: 'Entering fpa_main_process_pvt.approve_reject_plan ACTION : '||p_event_name);
2153: END IF;
2154:

Line 2169: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2165: aname => 'FPA_APPROVE_PC',
2166: avalue => 'N');
2167: END IF;
2168:
2169: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2170: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2171: 'fpa.sql.fpa_main_process_pvt.approve_reject_plan.',
2172: 'Calling fpa_utilities_pvt.attach_AW');
2173: END IF;

Line 2170: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2166: avalue => 'N');
2167: END IF;
2168:
2169: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2170: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2171: 'fpa.sql.fpa_main_process_pvt.approve_reject_plan.',
2172: 'Calling fpa_utilities_pvt.attach_AW');
2173: END IF;
2174:

Line 2183: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2179: x_msg_count => l_msg_count,
2180: x_msg_data => l_msg_data);
2181:
2182:
2183: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2184: FND_LOG.String
2185: ( FND_LOG.LEVEL_PROCEDURE,
2186: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2187: 'Obtaining Approved Scenario Id for current Planning Cycle.'

Line 2184: FND_LOG.String

2180: x_msg_data => l_msg_data);
2181:
2182:
2183: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2184: FND_LOG.String
2185: ( FND_LOG.LEVEL_PROCEDURE,
2186: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2187: 'Obtaining Approved Scenario Id for current Planning Cycle.'
2188: );

Line 2185: ( FND_LOG.LEVEL_PROCEDURE,

2181:
2182:
2183: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2184: FND_LOG.String
2185: ( FND_LOG.LEVEL_PROCEDURE,
2186: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2187: 'Obtaining Approved Scenario Id for current Planning Cycle.'
2188: );
2189: END IF;

Line 2198: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2194: from fpa_aw_sce_info_v
2195: where approved_flag = 1
2196: and planning_cycle = p_itemkey;
2197:
2198: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2199: FND_LOG.String
2200: ( FND_LOG.LEVEL_PROCEDURE,
2201: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2202: 'Approved Scenario Id '||l_sce_id

Line 2199: FND_LOG.String

2195: where approved_flag = 1
2196: and planning_cycle = p_itemkey;
2197:
2198: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2199: FND_LOG.String
2200: ( FND_LOG.LEVEL_PROCEDURE,
2201: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2202: 'Approved Scenario Id '||l_sce_id
2203: );

Line 2200: ( FND_LOG.LEVEL_PROCEDURE,

2196: and planning_cycle = p_itemkey;
2197:
2198: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2199: FND_LOG.String
2200: ( FND_LOG.LEVEL_PROCEDURE,
2201: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2202: 'Approved Scenario Id '||l_sce_id
2203: );
2204: END IF;

Line 2211: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2207: IF p_event_name = 'FPA_APPROVE_PLAN' THEN
2208: -- Call API to update approved Scores
2209: if l_sce_id is not null then
2210:
2211: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2212: FND_LOG.String
2213: ( FND_LOG.LEVEL_PROCEDURE,
2214: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2215: 'Calling FPA_SCORECARDS_PVT.Update_Scenario_App_Scores.'

Line 2212: FND_LOG.String

2208: -- Call API to update approved Scores
2209: if l_sce_id is not null then
2210:
2211: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2212: FND_LOG.String
2213: ( FND_LOG.LEVEL_PROCEDURE,
2214: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2215: 'Calling FPA_SCORECARDS_PVT.Update_Scenario_App_Scores.'
2216: );

Line 2213: ( FND_LOG.LEVEL_PROCEDURE,

2209: if l_sce_id is not null then
2210:
2211: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2212: FND_LOG.String
2213: ( FND_LOG.LEVEL_PROCEDURE,
2214: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2215: 'Calling FPA_SCORECARDS_PVT.Update_Scenario_App_Scores.'
2216: );
2217: END IF;

Line 2228: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2224: x_msg_count => l_msg_count,
2225: x_msg_data => l_msg_data
2226: );
2227:
2228: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2229: FND_LOG.String
2230: ( FND_LOG.LEVEL_PROCEDURE,
2231: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2232: 'Calling FPA_Project_PVT.UPDATE_PROJ_FUNDING_STATUS.'

Line 2229: FND_LOG.String

2225: x_msg_data => l_msg_data
2226: );
2227:
2228: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2229: FND_LOG.String
2230: ( FND_LOG.LEVEL_PROCEDURE,
2231: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2232: 'Calling FPA_Project_PVT.UPDATE_PROJ_FUNDING_STATUS.'
2233: );

Line 2230: ( FND_LOG.LEVEL_PROCEDURE,

2226: );
2227:
2228: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2229: FND_LOG.String
2230: ( FND_LOG.LEVEL_PROCEDURE,
2231: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2232: 'Calling FPA_Project_PVT.UPDATE_PROJ_FUNDING_STATUS.'
2233: );
2234: END IF;

Line 2246: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2242: x_return_status => l_return_status,
2243: x_msg_count => l_msg_count,
2244: x_msg_data => l_msg_data);
2245:
2246: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2247: FND_LOG.String
2248: ( FND_LOG.LEVEL_PROCEDURE,
2249: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2250: 'Calling FPA_Portfolio_Project_sets_Pvt.add_project_set_lines'

Line 2247: FND_LOG.String

2243: x_msg_count => l_msg_count,
2244: x_msg_data => l_msg_data);
2245:
2246: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2247: FND_LOG.String
2248: ( FND_LOG.LEVEL_PROCEDURE,
2249: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2250: 'Calling FPA_Portfolio_Project_sets_Pvt.add_project_set_lines'
2251: );

Line 2248: ( FND_LOG.LEVEL_PROCEDURE,

2244: x_msg_data => l_msg_data);
2245:
2246: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2247: FND_LOG.String
2248: ( FND_LOG.LEVEL_PROCEDURE,
2249: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2250: 'Calling FPA_Portfolio_Project_sets_Pvt.add_project_set_lines'
2251: );
2252: END IF;

Line 2270: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2266: -- As a quick fix, we are executing OLAP dml commands to reset the flags.
2267: -- fpa_scenario_pvt will be updated with new procedures
2268: -- that may be required to reset the recomm/appr flags for all scenarios
2269:
2270: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2271: FND_LOG.String
2272: ( FND_LOG.LEVEL_PROCEDURE,
2273: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2274: 'Reject Plan: Approved Scenario Id '||l_sce_id

Line 2271: FND_LOG.String

2267: -- fpa_scenario_pvt will be updated with new procedures
2268: -- that may be required to reset the recomm/appr flags for all scenarios
2269:
2270: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2271: FND_LOG.String
2272: ( FND_LOG.LEVEL_PROCEDURE,
2273: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2274: 'Reject Plan: Approved Scenario Id '||l_sce_id
2275: );

Line 2272: ( FND_LOG.LEVEL_PROCEDURE,

2268: -- that may be required to reset the recomm/appr flags for all scenarios
2269:
2270: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2271: FND_LOG.String
2272: ( FND_LOG.LEVEL_PROCEDURE,
2273: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2274: 'Reject Plan: Approved Scenario Id '||l_sce_id
2275: );
2276: END IF;

Line 2292: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2288:
2289:
2290: -- dbms_aw.execute('ALLSTAT');
2291:
2292: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2293: FND_LOG.String
2294: ( FND_LOG.LEVEL_PROCEDURE,
2295: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2296: 'Approve/ Reject Plan procedure calls ');

Line 2293: FND_LOG.String

2289:
2290: -- dbms_aw.execute('ALLSTAT');
2291:
2292: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2293: FND_LOG.String
2294: ( FND_LOG.LEVEL_PROCEDURE,
2295: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2296: 'Approve/ Reject Plan procedure calls ');
2297: END IF;

Line 2294: ( FND_LOG.LEVEL_PROCEDURE,

2290: -- dbms_aw.execute('ALLSTAT');
2291:
2292: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2293: FND_LOG.String
2294: ( FND_LOG.LEVEL_PROCEDURE,
2295: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2296: 'Approve/ Reject Plan procedure calls ');
2297: END IF;
2298:

Line 2299: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2295: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2296: 'Approve/ Reject Plan procedure calls ');
2297: END IF;
2298:
2299: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2300: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2301: 'fpa.sql.fpa_main_process_pvt.approve_reject_plan.',
2302: 'Calling wf_event.raise');
2303: END IF;

Line 2300: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2296: 'Approve/ Reject Plan procedure calls ');
2297: END IF;
2298:
2299: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2300: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2301: 'fpa.sql.fpa_main_process_pvt.approve_reject_plan.',
2302: 'Calling wf_event.raise');
2303: END IF;
2304:

Line 2314: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2310: dbms_aw.execute('UPDATE');
2311: COMMIT;
2312:
2313:
2314: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2315: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2316: 'fpa.sql.fpa_main_process_pvt.approve_reject_plan.',
2317: 'Calling fpa_utilities_pvt.detach_AW');
2318: END IF;

Line 2315: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2311: COMMIT;
2312:
2313:
2314: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2315: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2316: 'fpa.sql.fpa_main_process_pvt.approve_reject_plan.',
2317: 'Calling fpa_utilities_pvt.detach_AW');
2318: END IF;
2319:

Line 2328: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2324: x_msg_data => l_msg_data);
2325:
2326:
2327:
2328: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2329: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2330: 'fpa.sql.fpa_main_process_pvt.approve_reject_plan.end',
2331: 'Exiting fpa_main_process_pvt.approve_reject_plan');
2332: END IF;

Line 2329: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2325:
2326:
2327:
2328: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2329: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2330: 'fpa.sql.fpa_main_process_pvt.approve_reject_plan.end',
2331: 'Exiting fpa_main_process_pvt.approve_reject_plan');
2332: END IF;
2333:

Line 2336: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2332: END IF;
2333:
2334: EXCEPTION
2335: WHEN OTHERS THEN
2336: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2337: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2338: 'fpa.sql.fpa_main_process_pvt.approve_reject_plan.end',
2339: SQLERRM);
2340: END IF;

Line 2337: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2333:
2334: EXCEPTION
2335: WHEN OTHERS THEN
2336: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2337: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2338: 'fpa.sql.fpa_main_process_pvt.approve_reject_plan.end',
2339: SQLERRM);
2340: END IF;
2341: -- Bug 4331948 If Exception raised during Approve/Reject Plan, A/w should be detached

Line 2377: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2373: l_project_id_tbl SYSTEM.pa_num_tbl_type;
2374:
2375: BEGIN
2376:
2377: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2378: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2379: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.begin',
2380: 'Entering fpa_main_process_pvt.copy_proj_from_prev_pc ');
2381: END IF;

Line 2378: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2374:
2375: BEGIN
2376:
2377: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2378: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2379: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.begin',
2380: 'Entering fpa_main_process_pvt.copy_proj_from_prev_pc ');
2381: END IF;
2382:

Line 2391: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2387: aname => 'FPA_LAST_PC_ID');
2388:
2389: IF NVL(l_last_pc_id,-1) <> -1 THEN --Bug 4237493 : Introduced for scenario where there is no last PC
2390:
2391: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2392: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2393: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.begin',
2394: 'Setting Last Planning cycle ID to the planning_cycle_d');
2395: END IF;

Line 2392: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2388:
2389: IF NVL(l_last_pc_id,-1) <> -1 THEN --Bug 4237493 : Introduced for scenario where there is no last PC
2390:
2391: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2392: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2393: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.begin',
2394: 'Setting Last Planning cycle ID to the planning_cycle_d');
2395: END IF;
2396:

Line 2410: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2406:
2407: l_count :=0;
2408: l_count := l_project_id_tbl.COUNT;
2409:
2410: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2411: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2412: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.begin',
2413: 'NUmber of projects fetched from last PC '||l_count);
2414: END IF;

Line 2411: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2407: l_count :=0;
2408: l_count := l_project_id_tbl.COUNT;
2409:
2410: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2411: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2412: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.begin',
2413: 'NUmber of projects fetched from last PC '||l_count);
2414: END IF;
2415:

Line 2419: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2415:
2416: FOR i in 1 .. l_count
2417: LOOP
2418:
2419: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2420: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2421: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.begin',
2422: 'Looping for l_project_id_tbl(i) = '||l_project_id_tbl(i));
2423: END IF;

Line 2420: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2416: FOR i in 1 .. l_count
2417: LOOP
2418:
2419: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2420: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2421: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.begin',
2422: 'Looping for l_project_id_tbl(i) = '||l_project_id_tbl(i));
2423: END IF;
2424:

Line 2439: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2435: END IF; --Bug 4237493
2436:
2437: x_resultout := wf_engine.eng_null;
2438:
2439: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2441: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.end',
2442: 'Exiting fpa_main_process_pvt.copy_proj_from_prev_pc');
2443: END IF;

Line 2440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2436:
2437: x_resultout := wf_engine.eng_null;
2438:
2439: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2440: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2441: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.end',
2442: 'Exiting fpa_main_process_pvt.copy_proj_from_prev_pc');
2443: END IF;
2444:

Line 2448: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2444:
2445:
2446: EXCEPTION
2447: WHEN OTHERS THEN
2448: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2450: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.end',
2451: SQLERRM);
2452: END IF;

Line 2449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2445:
2446: EXCEPTION
2447: WHEN OTHERS THEN
2448: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2449: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2450: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.end',
2451: SQLERRM);
2452: END IF;
2453: wf_core.context('FPA_MAIN_PROCESS_PVT', 'COPY_PROJ_FROM_PREV_PC', SQLERRM);

Line 2472: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2468: l_wf_aw_attached VARCHAR2(1);
2469:
2470: BEGIN
2471:
2472: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2474: 'fpa.sql.fpa_main_process_pvt.wf_attach_aw.begin',
2475: 'Entering fpa_main_process_pvt.wf_attach_aw ');
2476: END IF;

Line 2473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2469:
2470: BEGIN
2471:
2472: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2473: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2474: 'fpa.sql.fpa_main_process_pvt.wf_attach_aw.begin',
2475: 'Entering fpa_main_process_pvt.wf_attach_aw ');
2476: END IF;
2477:

Line 2497: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2493: avalue => l_wf_aw_attached);
2494:
2495: x_resultout := wf_engine.eng_null;
2496:
2497: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2499: 'fpa.sql.fpa_main_process_pvt.wf_attach_aw.end',
2500: 'Entering fpa_main_process_pvt.wf_attach_aw');
2501: END IF;

Line 2498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2494:
2495: x_resultout := wf_engine.eng_null;
2496:
2497: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2498: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2499: 'fpa.sql.fpa_main_process_pvt.wf_attach_aw.end',
2500: 'Entering fpa_main_process_pvt.wf_attach_aw');
2501: END IF;
2502:

Line 2505: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2501: END IF;
2502:
2503: EXCEPTION
2504: WHEN OTHERS THEN
2505: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2506: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2507: 'fpa.sql.fpa_main_process_pvt.wf_attach_aw.end',
2508: SQLERRM);
2509: END IF;

Line 2506: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2502:
2503: EXCEPTION
2504: WHEN OTHERS THEN
2505: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2506: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2507: 'fpa.sql.fpa_main_process_pvt.wf_attach_aw.end',
2508: SQLERRM);
2509: END IF;
2510: wf_core.context('FPA_MAIN_PROCESS_PVT', ' WF_ATTACH_AW', SQLERRM);

Line 2529: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2525: l_msg_data VARCHAR2(2000);
2526: l_wf_aw_attached VARCHAR2(1);
2527: BEGIN
2528:
2529: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2530: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2531: 'fpa.sql.fpa_main_process_pvt.wf_detach_aw.begin',
2532: 'Entering fpa_main_process_pvt.wf_detach_aw ');
2533: END IF;

Line 2530: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2526: l_wf_aw_attached VARCHAR2(1);
2527: BEGIN
2528:
2529: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2530: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2531: 'fpa.sql.fpa_main_process_pvt.wf_detach_aw.begin',
2532: 'Entering fpa_main_process_pvt.wf_detach_aw ');
2533: END IF;
2534:

Line 2541: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2537: l_wf_aw_attached := wf_engine.getItemAttrtext(itemtype => p_itemtype,
2538: itemkey => p_itemkey,
2539: aname => 'FPA_WF_AW_ATTACHED');
2540:
2541: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2542: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2543: 'fpa.sql.fpa_main_process_pvt.wf_detach_aw.begin',
2544: 'Value of l_wf_aw_attached '||l_wf_aw_attached);
2545: END IF;

Line 2542: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2538: itemkey => p_itemkey,
2539: aname => 'FPA_WF_AW_ATTACHED');
2540:
2541: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2542: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2543: 'fpa.sql.fpa_main_process_pvt.wf_detach_aw.begin',
2544: 'Value of l_wf_aw_attached '||l_wf_aw_attached);
2545: END IF;
2546:

Line 2564: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2560: END IF;
2561:
2562: x_resultout := wf_engine.eng_null;
2563:
2564: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2565: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2566: 'fpa.sql.fpa_main_process_pvt.wf_detach_aw.end',
2567: 'Entering fpa_main_process_pvt.wf_detach_aw');
2568: END IF;

Line 2565: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2561:
2562: x_resultout := wf_engine.eng_null;
2563:
2564: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2565: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2566: 'fpa.sql.fpa_main_process_pvt.wf_detach_aw.end',
2567: 'Entering fpa_main_process_pvt.wf_detach_aw');
2568: END IF;
2569:

Line 2572: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2568: END IF;
2569:
2570: EXCEPTION
2571: WHEN OTHERS THEN
2572: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2573: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2574: 'fpa.sql.fpa_main_process_pvt.wf_detach_aw.end',
2575: SQLERRM);
2576: END IF;

Line 2573: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2569:
2570: EXCEPTION
2571: WHEN OTHERS THEN
2572: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2573: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2574: 'fpa.sql.fpa_main_process_pvt.wf_detach_aw.end',
2575: SQLERRM);
2576: END IF;
2577: wf_core.context('FPA_MAIN_PROCESS_PVT', ' WF_DETACH_AW', SQLERRM);