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 WF_ENGINE

Line 187: wf_engine.CreateProcess(itemtype => l_itemtype,

183:
184: -- wf_purge.items(l_itemtype,l_itemkey,sysdate,false,true);
185:
186: -- Creates the workflow process
187: wf_engine.CreateProcess(itemtype => l_itemtype,
188: itemkey => l_itemkey,
189: process => l_WFProcess);
190:
191: -- Sets the Planning Cycle ID

Line 192: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

188: itemkey => l_itemkey,
189: process => l_WFProcess);
190:
191: -- Sets the Planning Cycle ID
192: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
193: itemkey => l_itemkey,
194: aname => 'FPA_PC_ID',
195: avalue => p_pc_id);
196:

Line 198: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

194: aname => 'FPA_PC_ID',
195: avalue => p_pc_id);
196:
197: -- Sets the Last Planning Cycle ID
198: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
199: itemkey => l_itemkey,
200: aname => 'FPA_LAST_PC_ID',
201: avalue => p_last_pc_id);
202:

Line 204: wf_engine.SetItemAttrDate(itemtype => l_itemtype,

200: aname => 'FPA_LAST_PC_ID',
201: avalue => p_last_pc_id);
202:
203: -- Sets the Due Date
204: wf_engine.SetItemAttrDate(itemtype => l_itemtype,
205: itemkey => l_itemkey,
206: aname => 'FPA_DUE_DATE',
207: avalue => p_due_date);
208:

Line 220: wf_engine.SetItemAttrText(itemtype => l_itemtype,

216: x_msg_data => l_msg_data);
217:
218:
219: -- Sets the attributes
220: wf_engine.SetItemAttrText(itemtype => l_itemtype,
221: itemkey => l_itemkey,
222: aname => 'FPA_PORTFOLIO_NAME',
223: avalue => l_pc_attributes_rec.portfolio_name);
224:

Line 225: wf_engine.SetItemAttrText(itemtype => l_itemtype,

221: itemkey => l_itemkey,
222: aname => 'FPA_PORTFOLIO_NAME',
223: avalue => l_pc_attributes_rec.portfolio_name);
224:
225: wf_engine.SetItemAttrText(itemtype => l_itemtype,
226: itemkey => l_itemkey,
227: aname => 'FPA_PC_NAME',
228: avalue => l_pc_attributes_rec.pc_name);
229:

Line 230: wf_engine.SetItemAttrText(itemtype => l_itemtype,

226: itemkey => l_itemkey,
227: aname => 'FPA_PC_NAME',
228: avalue => l_pc_attributes_rec.pc_name);
229:
230: wf_engine.SetItemAttrText(itemtype => l_itemtype,
231: itemkey => l_itemkey,
232: aname => 'FPA_PRTF_CLASS_CODE',
233: avalue => l_pc_attributes_rec.portfolio_type);
234:

Line 235: wf_engine.SetItemAttrText(itemtype => l_itemtype,

231: itemkey => l_itemkey,
232: aname => 'FPA_PRTF_CLASS_CODE',
233: avalue => l_pc_attributes_rec.portfolio_type);
234:
235: wf_engine.SetItemAttrText(itemtype => l_itemtype,
236: itemkey => l_itemkey,
237: aname => 'FPA_INV_CLASS_CATEGORY',
238: avalue => l_pc_attributes_rec.inv_class_category);
239:

Line 240: wf_engine.SetItemAttrText(itemtype => l_itemtype,

236: itemkey => l_itemkey,
237: aname => 'FPA_INV_CLASS_CATEGORY',
238: avalue => l_pc_attributes_rec.inv_class_category);
239:
240: wf_engine.SetItemAttrText(itemtype => l_itemtype,
241: itemkey => l_itemkey,
242: aname => 'FPA_PRTF_SELECTION_CATEGORY',
243: avalue => fnd_profile.value('PJP_PORTFOLIO_CLASS_CATEGORY'));
244:

Line 245: wf_engine.SetItemAttrText(itemtype => l_itemtype,

241: itemkey => l_itemkey,
242: aname => 'FPA_PRTF_SELECTION_CATEGORY',
243: avalue => fnd_profile.value('PJP_PORTFOLIO_CLASS_CATEGORY'));
244:
245: wf_engine.SetItemAttrText(itemtype => l_itemtype,
246: itemkey => l_itemkey,
247: aname => 'FPA_COST_FIN_PLAN_TYPE',
248: avalue => l_pc_attributes_rec.cost_fin_plan);
249:

Line 250: wf_engine.SetItemAttrText(itemtype => l_itemtype,

246: itemkey => l_itemkey,
247: aname => 'FPA_COST_FIN_PLAN_TYPE',
248: avalue => l_pc_attributes_rec.cost_fin_plan);
249:
250: wf_engine.SetItemAttrText(itemtype => l_itemtype,
251: itemkey => l_itemkey,
252: aname => 'FPA_BENEFIT_FIN_PLAN_TYPE',
253: avalue => l_pc_attributes_rec.benefit_fin_plan);
254:

Line 257: wf_engine.StartProcess(itemtype => l_itemtype,

253: avalue => l_pc_attributes_rec.benefit_fin_plan);
254:
255:
256: -- Starts the workflow process
257: wf_engine.StartProcess(itemtype => l_itemtype,
258: itemkey => l_itemkey);
259:
260: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
261: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

Line 315: 'Cancelling the master WF process; Call wf_engine.AbortProcess');

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

Line 319: wf_engine.AbortProcess(itemtype => l_itemtype,

315: 'Cancelling the master WF process; Call wf_engine.AbortProcess');
316: END IF;
317:
318: -- Cancels the main process
319: wf_engine.AbortProcess(itemtype => l_itemtype,
320: itemkey => l_itemkey,
321: process => l_WFProcess);
322:
323: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 326: 'Canceled the master WF process; wf_engine.AbortProcess executed');

322:
323: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
324: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
325: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
326: 'Canceled the master WF process; wf_engine.AbortProcess executed');
327: END IF;
328:
329: -- Reassign a new item key to the new process
330: l_itemkey := 'FPAF' || p_pc_id;

Line 346: wf_engine.CreateProcess(itemtype => l_itemtype,

342: END IF;
343:
344:
345: -- Creates the workflow process
346: wf_engine.CreateProcess(itemtype => l_itemtype,
347: itemkey => l_itemkey,
348: process => l_process);
349:
350: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 353: 'executed wf_engine.createProcess API');

349:
350: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
351: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
352: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
353: 'executed wf_engine.createProcess API');
354: END IF;
355:
356: -- Sets the Planning Cycle ID
357: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

Line 357: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

353: 'executed wf_engine.createProcess API');
354: END IF;
355:
356: -- Sets the Planning Cycle ID
357: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
358: itemkey => l_itemkey,
359: aname => 'FPA_PC_ID',
360: avalue => p_pc_id);
361:

Line 366: 'executed wf_engine.SetItemAttrNumber API');

362:
363: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
364: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
365: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
366: 'executed wf_engine.SetItemAttrNumber API');
367: END IF;
368:
369: -- Sets the Due Date
370: wf_engine.SetItemAttrDate(itemtype => l_itemtype,

Line 370: wf_engine.SetItemAttrDate(itemtype => l_itemtype,

366: 'executed wf_engine.SetItemAttrNumber API');
367: END IF;
368:
369: -- Sets the Due Date
370: wf_engine.SetItemAttrDate(itemtype => l_itemtype,
371: itemkey => l_itemkey,
372: aname => 'FPA_DUE_DATE',
373: avalue => p_due_date);
374:

Line 378: 'executed wf_engine.SetItemAttrDate API');

374:
375: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
377: 'fpa.sql.fpa_main_process_pvt.cancel_workflow',
378: 'executed wf_engine.SetItemAttrDate API');
379: END IF;
380:
381: -- Starts the workflow process
382: wf_engine.StartProcess(itemtype => l_itemtype,

Line 382: wf_engine.StartProcess(itemtype => l_itemtype,

378: 'executed wf_engine.SetItemAttrDate API');
379: END IF;
380:
381: -- Starts the workflow process
382: wf_engine.StartProcess(itemtype => l_itemtype,
383: itemkey => l_itemkey);
384:
385: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
386: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

Line 388: 'executed wf_engine.StartProcess API');

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

Line 445: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

441: 'fpa.sql.fpa_main_process_pvt.launch_process.begin',
442: 'Entering fpa_main_process_pvt.launch_process');
443: END IF;
444:
445: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
446: itemkey => p_itemkey,
447: aname => 'FPA_PC_ID');
448: l_itemtype := 'FPAPJP';
449: l_itemkey := 'FPAL' ||l_pc_id;

Line 451: l_due_date := wf_engine.GetItemAttrDate(itemtype => p_itemtype,

447: aname => 'FPA_PC_ID');
448: l_itemtype := 'FPAPJP';
449: l_itemkey := 'FPAL' ||l_pc_id;
450:
451: l_due_date := wf_engine.GetItemAttrDate(itemtype => p_itemtype,
452: itemkey => p_itemkey,
453: aname => 'FPA_DUE_DATE');
454:
455: l_scenario_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

Line 455: l_scenario_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

451: l_due_date := wf_engine.GetItemAttrDate(itemtype => p_itemtype,
452: itemkey => p_itemkey,
453: aname => 'FPA_DUE_DATE');
454:
455: l_scenario_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
456: itemkey => p_itemkey,
457: aname => 'FPA_SCENARIO_ID');
458:
459: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 466: wf_engine.CreateProcess(itemtype => l_itemtype,

462: 'Starting the main workflow process');
463: END IF;
464:
465: -- Creates the workflow process
466: wf_engine.CreateProcess(itemtype => l_itemtype,
467: itemkey => l_itemkey,
468: process => l_process);
469:
470: -- Sets the Planning Cycle ID

Line 471: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

467: itemkey => l_itemkey,
468: process => l_process);
469:
470: -- Sets the Planning Cycle ID
471: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
472: itemkey => l_itemkey,
473: aname => 'FPA_PC_ID',
474: avalue => l_pc_id);
475:

Line 477: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

473: aname => 'FPA_PC_ID',
474: avalue => l_pc_id);
475:
476: -- Sets the Scenario ID
477: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
478: itemkey => l_itemkey,
479: aname => 'FPA_SCENARIO_ID',
480: avalue => l_scenario_id);
481:

Line 483: wf_engine.SetItemAttrDate(itemtype => l_itemtype,

479: aname => 'FPA_SCENARIO_ID',
480: avalue => l_scenario_id);
481:
482: -- Sets the Due Date
483: wf_engine.SetItemAttrDate(itemtype => l_itemtype,
484: itemkey => l_itemkey,
485: aname => 'FPA_DUE_DATE',
486: avalue => l_due_date);
487:

Line 499: wf_engine.SetItemAttrText(itemtype => l_itemtype,

495:
496:
497: -- Set the attributes
498:
499: wf_engine.SetItemAttrText(itemtype => l_itemtype,
500: itemkey => l_itemkey,
501: aname => 'FPA_PORTFOLIO_NAME',
502: avalue => l_pc_attributes_rec.portfolio_name);
503:

Line 504: wf_engine.SetItemAttrText(itemtype => l_itemtype,

500: itemkey => l_itemkey,
501: aname => 'FPA_PORTFOLIO_NAME',
502: avalue => l_pc_attributes_rec.portfolio_name);
503:
504: wf_engine.SetItemAttrText(itemtype => l_itemtype,
505: itemkey => l_itemkey,
506: aname => 'FPA_PC_NAME',
507: avalue => l_pc_attributes_rec.pc_name);
508:

Line 511: wf_engine.StartProcess(itemtype => l_itemtype,

507: avalue => l_pc_attributes_rec.pc_name);
508:
509:
510: -- Starts the workflow process
511: wf_engine.StartProcess(itemtype => l_itemtype,
512: itemkey => l_itemkey);
513:
514: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
515: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

Line 564: wf_engine.AbortProcess(itemtype => c_rec.item_type,

560: 'Aborting workflow process '||c_rec.item_key);
561: END IF;
562:
563: -- Cancels all the workflow process associated with this Planning cycle
564: wf_engine.AbortProcess(itemtype => c_rec.item_type,
565: itemkey => c_rec.item_key,
566: process => c_rec.root_activity);
567:
568: END LOOP;

Line 903: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type,

899: 'Entering fpa_main_process_pvt.create_role');
900: END IF;
901:
902: -- Get the planning cycle ID
903: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type,
904: itemkey => p_item_key,
905: aname => 'FPA_PC_ID');
906:
907: IF p_calledfrom = g_get_port_users THEN

Line 954: wf_engine.SetItemAttrText(itemtype => p_item_type,

950: -- Delete the users if already existing from the above role :
951: wf_directory.RemoveUsersFromAdhocRole(role_name => l_notify_role);
952:
953: -- Need to notify Project Managers
954: wf_engine.SetItemAttrText(itemtype => p_item_type,
955: itemkey => p_item_key,
956: aname => 'FPA_PROJ_MANAGERS',
957: avalue => l_notify_role);
958:

Line 1008: IF (p_funcmode <> wf_engine.eng_run) THEN

1004: 'Entering fpa_main_process_pvt.get_dlist');
1005: END IF;
1006:
1007: -- Do not perform anything in CANCEL or TIMEOUT mode
1008: IF (p_funcmode <> wf_engine.eng_run) THEN
1009: x_resultout := wf_engine.eng_null;
1010: RETURN;
1011: END IF;
1012:

Line 1009: x_resultout := wf_engine.eng_null;

1005: END IF;
1006:
1007: -- Do not perform anything in CANCEL or TIMEOUT mode
1008: IF (p_funcmode <> wf_engine.eng_run) THEN
1009: x_resultout := wf_engine.eng_null;
1010: RETURN;
1011: END IF;
1012:
1013: CREATE_ROLE ( p_item_type => p_itemtype,

Line 1019: x_resultout := wf_engine.eng_completed||':'||'T';

1015: p_calledfrom => g_get_pc_dlist,
1016: p_user_exists => l_user_exists);
1017:
1018: IF l_user_exists = 'Y' then
1019: x_resultout := wf_engine.eng_completed||':'||'T';
1020: ELSE
1021: x_resultout := wf_engine.eng_completed||':'||'F';
1022: END IF;
1023:

Line 1021: x_resultout := wf_engine.eng_completed||':'||'F';

1017:
1018: IF l_user_exists = 'Y' then
1019: x_resultout := wf_engine.eng_completed||':'||'T';
1020: ELSE
1021: x_resultout := wf_engine.eng_completed||':'||'F';
1022: END IF;
1023:
1024:
1025: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1064: IF (p_funcmode <> wf_engine.eng_run) THEN

1060: 'Entering fpa_main_process_pvt.get_alist');
1061: END IF;
1062:
1063: -- Do not perform anything in CANCEL or TIMEOUT mode
1064: IF (p_funcmode <> wf_engine.eng_run) THEN
1065: x_resultout := wf_engine.eng_null;
1066: RETURN;
1067: END IF;
1068:

Line 1065: x_resultout := wf_engine.eng_null;

1061: END IF;
1062:
1063: -- Do not perform anything in CANCEL or TIMEOUT mode
1064: IF (p_funcmode <> wf_engine.eng_run) THEN
1065: x_resultout := wf_engine.eng_null;
1066: RETURN;
1067: END IF;
1068:
1069: CREATE_ROLE ( p_item_type => p_itemtype,

Line 1075: x_resultout := wf_engine.eng_completed||':'||'T';

1071: p_calledfrom => g_get_port_users,
1072: p_user_exists => l_user_exists);
1073:
1074: IF l_user_exists = 'Y' then
1075: x_resultout := wf_engine.eng_completed||':'||'T';
1076: ELSE
1077: x_resultout := wf_engine.eng_completed||':'||'F';
1078: END IF;
1079:

Line 1077: x_resultout := wf_engine.eng_completed||':'||'F';

1073:
1074: IF l_user_exists = 'Y' then
1075: x_resultout := wf_engine.eng_completed||':'||'T';
1076: ELSE
1077: x_resultout := wf_engine.eng_completed||':'||'F';
1078: END IF;
1079:
1080: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1081: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

Line 1117: IF (p_funcmode <> wf_engine.eng_run) THEN

1113: 'Entering fpa_main_process_pvt.get_approver');
1114: END IF;
1115:
1116: -- Do not perform anything in CANCEL or TIMEOUT mode
1117: IF (p_funcmode <> wf_engine.eng_run) THEN
1118: x_resultout := wf_engine.eng_null;
1119: RETURN;
1120: END IF;
1121:

Line 1118: x_resultout := wf_engine.eng_null;

1114: END IF;
1115:
1116: -- Do not perform anything in CANCEL or TIMEOUT mode
1117: IF (p_funcmode <> wf_engine.eng_run) THEN
1118: x_resultout := wf_engine.eng_null;
1119: RETURN;
1120: END IF;
1121:
1122: CREATE_ROLE ( p_item_type => p_itemtype,

Line 1128: x_resultout := wf_engine.eng_completed||':'||'T';

1124: p_calledfrom => g_get_port_apprv,
1125: p_user_exists => l_user_exists);
1126:
1127: IF l_user_exists = 'Y' then
1128: x_resultout := wf_engine.eng_completed||':'||'T';
1129: ELSE
1130: x_resultout := wf_engine.eng_completed||':'||'F';
1131: END IF;
1132:

Line 1130: x_resultout := wf_engine.eng_completed||':'||'F';

1126:
1127: IF l_user_exists = 'Y' then
1128: x_resultout := wf_engine.eng_completed||':'||'T';
1129: ELSE
1130: x_resultout := wf_engine.eng_completed||':'||'F';
1131: END IF;
1132:
1133:
1134: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1172: IF (p_funcmode <> wf_engine.eng_run) THEN

1168: 'Entering fpa_main_process_pvt.get_analyst');
1169: END IF;
1170:
1171: -- Do not perform anything in CANCEL or TIMEOUT mode
1172: IF (p_funcmode <> wf_engine.eng_run) THEN
1173: x_resultout := wf_engine.eng_null;
1174: RETURN;
1175: END IF;
1176:

Line 1173: x_resultout := wf_engine.eng_null;

1169: END IF;
1170:
1171: -- Do not perform anything in CANCEL or TIMEOUT mode
1172: IF (p_funcmode <> wf_engine.eng_run) THEN
1173: x_resultout := wf_engine.eng_null;
1174: RETURN;
1175: END IF;
1176:
1177: CREATE_ROLE ( p_item_type => p_itemtype,

Line 1183: x_resultout := wf_engine.eng_completed||':'||'T';

1179: p_calledfrom => g_get_port_analyst,
1180: p_user_exists => l_user_exists);
1181:
1182: IF l_user_exists = 'Y' then
1183: x_resultout := wf_engine.eng_completed||':'||'T';
1184: ELSE
1185: x_resultout := wf_engine.eng_completed||':'||'F';
1186: END IF;
1187:

Line 1185: x_resultout := wf_engine.eng_completed||':'||'F';

1181:
1182: IF l_user_exists = 'Y' then
1183: x_resultout := wf_engine.eng_completed||':'||'T';
1184: ELSE
1185: x_resultout := wf_engine.eng_completed||':'||'F';
1186: END IF;
1187:
1188:
1189: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1230: IF (p_funcmode <> wf_engine.eng_run) THEN

1226: 'Entering fpa_main_process_pvt.get_pc_managers');
1227: END IF;
1228:
1229: -- Do not perform anything in CANCEL or TIMEOUT mode
1230: IF (p_funcmode <> wf_engine.eng_run) THEN
1231: x_resultout := wf_engine.eng_null;
1232: RETURN;
1233: END IF;
1234:

Line 1231: x_resultout := wf_engine.eng_null;

1227: END IF;
1228:
1229: -- Do not perform anything in CANCEL or TIMEOUT mode
1230: IF (p_funcmode <> wf_engine.eng_run) THEN
1231: x_resultout := wf_engine.eng_null;
1232: RETURN;
1233: END IF;
1234:
1235: CREATE_ROLE ( p_item_type => p_itemtype,

Line 1241: x_resultout := wf_engine.eng_completed||':'||'T';

1237: p_calledfrom => g_get_pc_manager,
1238: p_user_exists => l_user_exists);
1239:
1240: IF l_user_exists = 'Y' then
1241: x_resultout := wf_engine.eng_completed||':'||'T';
1242: ELSE
1243: x_resultout := wf_engine.eng_completed||':'||'F';
1244: END IF;
1245:

Line 1243: x_resultout := wf_engine.eng_completed||':'||'F';

1239:
1240: IF l_user_exists = 'Y' then
1241: x_resultout := wf_engine.eng_completed||':'||'T';
1242: ELSE
1243: x_resultout := wf_engine.eng_completed||':'||'F';
1244: END IF;
1245:
1246:
1247: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1330: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

1326: END IF;
1327:
1328:
1329: -- Get the Planning Cycle ID
1330: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1331: itemkey => p_itemkey,
1332: aname => 'FPA_PC_ID');
1333:
1334: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1506: 'Calling wf_engine.SetItemAttrNumber.');

1502:
1503: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1504: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1505: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1506: 'Calling wf_engine.SetItemAttrNumber.');
1507: END IF;
1508:
1509: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
1510: itemkey => p_itemkey,

Line 1509: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

1505: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1506: 'Calling wf_engine.SetItemAttrNumber.');
1507: END IF;
1508:
1509: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
1510: itemkey => p_itemkey,
1511: aname => 'FPA_SCENARIO_ID',
1512: avalue => l_scenario_id);
1513:

Line 1557: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

1553:
1554: BEGIN
1555:
1556: -- Get the Planning Cycle ID
1557: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1558: itemkey => p_itemkey,
1559: aname => 'FPA_PC_ID');
1560:
1561: l_pc_status := 'CREATED';

Line 1571: x_resultout := wf_engine.eng_null;

1567: x_return_status => l_return_status,
1568: x_msg_count => l_msg_count,
1569: x_msg_data => l_msg_data);
1570:
1571: x_resultout := wf_engine.eng_null;
1572:
1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1609: l_scen_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

1605: 'Entering fpa_main_process_pvt.call_project_sets');
1606: END IF;
1607:
1608: -- Gets the Scenario ID
1609: l_scen_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1610: itemkey => p_itemkey,
1611: aname => 'FPA_SCENARIO_ID');
1612:
1613:

Line 1628: x_resultout := wf_engine.eng_null;

1624: 'fpa.sql.fpa_main_process_pvt.call_project_sets.end',
1625: 'Exiting fpa_main_process_pvt.call_project_sets');
1626: END IF;
1627:
1628: x_resultout := wf_engine.eng_null;
1629:
1630: EXCEPTION
1631: WHEN OTHERS THEN
1632: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1664: l_is_approved := wf_engine.GetItemAttrText(itemtype => p_itemtype,

1660: l_is_approved VARCHAR2(1) := 'N';
1661:
1662: BEGIN
1663:
1664: l_is_approved := wf_engine.GetItemAttrText(itemtype => p_itemtype,
1665: itemkey => p_itemkey,
1666: aname => 'FPA_APPROVE_PC');
1667:
1668: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1710: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

1706:
1707: BEGIN
1708:
1709: -- Get the Planning Cycle ID
1710: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1711: itemkey => p_itemkey,
1712: aname => 'FPA_PC_ID');
1713:
1714: l_pc_status := 'ANALYSIS';

Line 1725: x_resultout := wf_engine.eng_null;

1721: x_return_status => l_return_status,
1722: x_msg_count => l_msg_count,
1723: x_msg_data => l_msg_data);
1724:
1725: x_resultout := wf_engine.eng_null;
1726:
1727: EXCEPTION
1728: WHEN OTHERS THEN
1729: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1763: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

1759: 'Entering fpa_main_process_pvt.set_status_approved p_itemkey'||p_itemkey);
1760: END IF;
1761:
1762: -- Get the Planning Cycle ID
1763: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1764: itemkey => p_itemkey,
1765: aname => 'FPA_PC_ID');
1766:
1767: l_pc_approve := wf_engine.GetItemAttrText(itemtype => p_itemtype,

Line 1767: l_pc_approve := wf_engine.GetItemAttrText(itemtype => p_itemtype,

1763: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1764: itemkey => p_itemkey,
1765: aname => 'FPA_PC_ID');
1766:
1767: l_pc_approve := wf_engine.GetItemAttrText(itemtype => p_itemtype,
1768: itemkey => p_itemkey,
1769: aname => 'FPA_APPROVE_PC');
1770:
1771: IF l_pc_approve = 'Y' THEN

Line 1793: x_resultout := wf_engine.eng_null;

1789: x_return_status => l_return_status,
1790: x_msg_count => l_msg_count,
1791: x_msg_data => l_msg_data);
1792:
1793: x_resultout := wf_engine.eng_null;
1794:
1795: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1796: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1797: 'fpa.sql.fpa_main_process_pvt.set_status_approved.end',

Line 1838: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

1834: );
1835: END IF;
1836:
1837: -- Get the Planning Cycle ID
1838: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1839: itemkey => p_itemkey,
1840: aname => 'FPA_PC_ID');
1841:
1842: l_pc_status := 'CLOSED';

Line 1869: x_resultout := wf_engine.eng_null;

1865: x_msg_data => l_msg_data,
1866: x_msg_count => l_msg_count
1867: );
1868:
1869: x_resultout := wf_engine.eng_null;
1870:
1871: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1872: FND_LOG.String
1873: ( FND_LOG.LEVEL_PROCEDURE,

Line 1910: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

1906:
1907: BEGIN
1908:
1909: -- Get the Planning Cycle ID
1910: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1911: itemkey => p_itemkey,
1912: aname => 'FPA_PC_ID');
1913:
1914: l_pc_status := 'COLLECTING';

Line 1924: x_resultout := wf_engine.eng_null;

1920: x_return_status => l_return_status,
1921: x_msg_count => l_msg_count,
1922: x_msg_data => l_msg_data);
1923:
1924: x_resultout := wf_engine.eng_null;
1925:
1926: EXCEPTION
1927: WHEN OTHERS THEN
1928: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1960: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

1956:
1957: BEGIN
1958:
1959: -- Get the Planning Cycle ID
1960: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1961: itemkey => p_itemkey,
1962: aname => 'FPA_PC_ID');
1963:
1964: l_pc_status := 'SUBMITTED';

Line 1975: x_resultout := wf_engine.eng_null;

1971: x_return_status => l_return_status,
1972: x_msg_count => l_msg_count,
1973: x_msg_data => l_msg_data);
1974:
1975: x_resultout := wf_engine.eng_null;
1976:
1977: EXCEPTION
1978: WHEN OTHERS THEN
1979: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2137: wf_engine.SetItemAttrText(itemtype => 'FPAPJP',

2133:
2134: l_eventkey := 'FPAL' ||p_itemkey;
2135:
2136: IF p_event_name = 'FPA_APPROVE_PLAN' THEN
2137: wf_engine.SetItemAttrText(itemtype => 'FPAPJP',
2138: itemkey => l_eventkey ,
2139: aname => 'FPA_APPROVE_PC',
2140: avalue => 'Y');
2141: ELSIF p_event_name = 'FPA_REJECT_PLAN' or p_event_name = 'FPA_WITHDRAW_PLAN' THEN

Line 2142: wf_engine.SetItemAttrText(itemtype => 'FPAPJP',

2138: itemkey => l_eventkey ,
2139: aname => 'FPA_APPROVE_PC',
2140: avalue => 'Y');
2141: ELSIF p_event_name = 'FPA_REJECT_PLAN' or p_event_name = 'FPA_WITHDRAW_PLAN' THEN
2142: wf_engine.SetItemAttrText(itemtype => 'FPAPJP',
2143: itemkey => l_eventkey ,
2144: aname => 'FPA_APPROVE_PC',
2145: avalue => 'N');
2146: END IF;

Line 2364: l_last_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

2360: END IF;
2361:
2362: -- Get the Planning Cycle ID
2363: l_last_pc_id := NULL;
2364: l_last_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
2365: itemkey => p_itemkey,
2366: aname => 'FPA_LAST_PC_ID');
2367:
2368: IF NVL(l_last_pc_id,-1) <> -1 THEN --Bug 4237493 : Introduced for scenario where there is no last PC

Line 2416: x_resultout := wf_engine.eng_null;

2412: END LOOP;
2413:
2414: END IF; --Bug 4237493
2415:
2416: x_resultout := wf_engine.eng_null;
2417:
2418: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2419: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2420: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.end',

Line 2469: wf_engine.SetItemAttrtext(itemtype => p_itemtype,

2465:
2466: l_wf_aw_attached := 'Y' ;
2467:
2468: -- Sets the Planning Cycle ID
2469: wf_engine.SetItemAttrtext(itemtype => p_itemtype,
2470: itemkey => p_itemkey,
2471: aname => 'FPA_WF_AW_ATTACHED',
2472: avalue => l_wf_aw_attached);
2473:

Line 2474: x_resultout := wf_engine.eng_null;

2470: itemkey => p_itemkey,
2471: aname => 'FPA_WF_AW_ATTACHED',
2472: avalue => l_wf_aw_attached);
2473:
2474: x_resultout := wf_engine.eng_null;
2475:
2476: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2478: 'fpa.sql.fpa_main_process_pvt.wf_attach_aw.end',

Line 2516: l_wf_aw_attached := wf_engine.getItemAttrtext(itemtype => p_itemtype,

2512: END IF;
2513:
2514: -- Sets the Planning Cycle ID
2515: l_wf_aw_attached := 'N';
2516: l_wf_aw_attached := wf_engine.getItemAttrtext(itemtype => p_itemtype,
2517: itemkey => p_itemkey,
2518: aname => 'FPA_WF_AW_ATTACHED');
2519:
2520: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2541: x_resultout := wf_engine.eng_null;

2537: x_msg_data => l_msg_data
2538: );
2539: END IF;
2540:
2541: x_resultout := wf_engine.eng_null;
2542:
2543: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2544: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2545: 'fpa.sql.fpa_main_process_pvt.wf_detach_aw.end',