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 191: wf_engine.CreateProcess(itemtype => l_itemtype,

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

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

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

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

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

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

204: aname => 'FPA_LAST_PC_ID',
205: avalue => p_last_pc_id);
206:
207: -- Sets the Due Date
208: wf_engine.SetItemAttrDate(itemtype => l_itemtype,
209: itemkey => l_itemkey,
210: aname => 'FPA_DUE_DATE',
211: avalue => p_due_date);
212:

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

220: x_msg_data => l_msg_data);
221:
222:
223: -- Sets the attributes
224: wf_engine.SetItemAttrText(itemtype => l_itemtype,
225: itemkey => l_itemkey,
226: aname => 'FPA_PORTFOLIO_NAME',
227: avalue => l_pc_attributes_rec.portfolio_name);
228:

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

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

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

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

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

235: itemkey => l_itemkey,
236: aname => 'FPA_PRTF_CLASS_CODE',
237: avalue => l_pc_attributes_rec.portfolio_type);
238:
239: wf_engine.SetItemAttrText(itemtype => l_itemtype,
240: itemkey => l_itemkey,
241: aname => 'FPA_INV_CLASS_CATEGORY',
242: avalue => l_pc_attributes_rec.inv_class_category);
243:

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

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

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

245: itemkey => l_itemkey,
246: aname => 'FPA_PRTF_SELECTION_CATEGORY',
247: avalue => fnd_profile.value('PJP_PORTFOLIO_CLASS_CATEGORY'));
248:
249: wf_engine.SetItemAttrText(itemtype => l_itemtype,
250: itemkey => l_itemkey,
251: aname => 'FPA_COST_FIN_PLAN_TYPE',
252: avalue => l_pc_attributes_rec.cost_fin_plan);
253:

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

250: itemkey => l_itemkey,
251: aname => 'FPA_COST_FIN_PLAN_TYPE',
252: avalue => l_pc_attributes_rec.cost_fin_plan);
253:
254: wf_engine.SetItemAttrText(itemtype => l_itemtype,
255: itemkey => l_itemkey,
256: aname => 'FPA_BENEFIT_FIN_PLAN_TYPE',
257: avalue => l_pc_attributes_rec.benefit_fin_plan);
258:

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

257: avalue => l_pc_attributes_rec.benefit_fin_plan);
258:
259:
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,

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

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:
322: -- Cancels the main process
323: wf_engine.AbortProcess(itemtype => l_itemtype,

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

319: 'Cancelling the master WF process; Call wf_engine.AbortProcess');
320: END IF;
321:
322: -- Cancels the main process
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

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

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:
333: -- Reassign a new item key to the new process
334: l_itemkey := 'FPAF' || p_pc_id;

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

346: END IF;
347:
348:
349: -- Creates the workflow process
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

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

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:
360: -- Sets the Planning Cycle ID
361: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

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

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

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

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:
373: -- Sets the Due Date
374: wf_engine.SetItemAttrDate(itemtype => l_itemtype,

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

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

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

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:
385: -- Starts the workflow process
386: wf_engine.StartProcess(itemtype => l_itemtype,

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

382: 'executed wf_engine.SetItemAttrDate API');
383: END IF;
384:
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,

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

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:
395:
396: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

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

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

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

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

455: l_due_date := wf_engine.GetItemAttrDate(itemtype => p_itemtype,
456: itemkey => p_itemkey,
457: aname => 'FPA_DUE_DATE');
458:
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

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

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

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

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

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

477: aname => 'FPA_PC_ID',
478: avalue => l_pc_id);
479:
480: -- Sets the Scenario ID
481: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
482: itemkey => l_itemkey,
483: aname => 'FPA_SCENARIO_ID',
484: avalue => l_scenario_id);
485:

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

483: aname => 'FPA_SCENARIO_ID',
484: avalue => l_scenario_id);
485:
486: -- Sets the Due Date
487: wf_engine.SetItemAttrDate(itemtype => l_itemtype,
488: itemkey => l_itemkey,
489: aname => 'FPA_DUE_DATE',
490: avalue => l_due_date);
491:

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

499:
500:
501: -- Set the attributes
502:
503: wf_engine.SetItemAttrText(itemtype => l_itemtype,
504: itemkey => l_itemkey,
505: aname => 'FPA_PORTFOLIO_NAME',
506: avalue => l_pc_attributes_rec.portfolio_name);
507:

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

504: itemkey => l_itemkey,
505: aname => 'FPA_PORTFOLIO_NAME',
506: avalue => l_pc_attributes_rec.portfolio_name);
507:
508: wf_engine.SetItemAttrText(itemtype => l_itemtype,
509: itemkey => l_itemkey,
510: aname => 'FPA_PC_NAME',
511: avalue => l_pc_attributes_rec.pc_name);
512:

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

511: avalue => l_pc_attributes_rec.pc_name);
512:
513:
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,

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

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

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

917: 'Entering fpa_main_process_pvt.create_role');
918: END IF;
919:
920: -- Get the planning cycle ID
921: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type,
922: itemkey => p_item_key,
923: aname => 'FPA_PC_ID');
924:
925: IF p_calledfrom = g_get_port_users THEN

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

971: wf_directory.RemoveUsersFromAdhocRole(role_name => l_notify_role);
972: END IF;
973:
974: -- Need to notify Project Managers
975: wf_engine.SetItemAttrText(itemtype => p_item_type,
976: itemkey => p_item_key,
977: aname => 'FPA_PROJ_MANAGERS',
978: avalue => l_notify_role);
979:

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

1025: 'Entering fpa_main_process_pvt.get_dlist');
1026: END IF;
1027:
1028: -- Do not perform anything in CANCEL or TIMEOUT mode
1029: IF (p_funcmode <> wf_engine.eng_run) THEN
1030: x_resultout := wf_engine.eng_null;
1031: RETURN;
1032: END IF;
1033:

Line 1030: x_resultout := wf_engine.eng_null;

1026: END IF;
1027:
1028: -- Do not perform anything in CANCEL or TIMEOUT mode
1029: IF (p_funcmode <> wf_engine.eng_run) THEN
1030: x_resultout := wf_engine.eng_null;
1031: RETURN;
1032: END IF;
1033:
1034: CREATE_ROLE ( p_item_type => p_itemtype,

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

1036: p_calledfrom => g_get_pc_dlist,
1037: p_user_exists => l_user_exists);
1038:
1039: IF l_user_exists = 'Y' then
1040: x_resultout := wf_engine.eng_completed||':'||'T';
1041: ELSE
1042: x_resultout := wf_engine.eng_completed||':'||'F';
1043: END IF;
1044:

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

1038:
1039: IF l_user_exists = 'Y' then
1040: x_resultout := wf_engine.eng_completed||':'||'T';
1041: ELSE
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

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

1081: 'Entering fpa_main_process_pvt.get_alist');
1082: END IF;
1083:
1084: -- Do not perform anything in CANCEL or TIMEOUT mode
1085: IF (p_funcmode <> wf_engine.eng_run) THEN
1086: x_resultout := wf_engine.eng_null;
1087: RETURN;
1088: END IF;
1089:

Line 1086: x_resultout := wf_engine.eng_null;

1082: END IF;
1083:
1084: -- Do not perform anything in CANCEL or TIMEOUT mode
1085: IF (p_funcmode <> wf_engine.eng_run) THEN
1086: x_resultout := wf_engine.eng_null;
1087: RETURN;
1088: END IF;
1089:
1090: CREATE_ROLE ( p_item_type => p_itemtype,

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

1092: p_calledfrom => g_get_port_users,
1093: p_user_exists => l_user_exists);
1094:
1095: IF l_user_exists = 'Y' then
1096: x_resultout := wf_engine.eng_completed||':'||'T';
1097: ELSE
1098: x_resultout := wf_engine.eng_completed||':'||'F';
1099: END IF;
1100:

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

1094:
1095: IF l_user_exists = 'Y' then
1096: x_resultout := wf_engine.eng_completed||':'||'T';
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,

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

1134: 'Entering fpa_main_process_pvt.get_approver');
1135: END IF;
1136:
1137: -- Do not perform anything in CANCEL or TIMEOUT mode
1138: IF (p_funcmode <> wf_engine.eng_run) THEN
1139: x_resultout := wf_engine.eng_null;
1140: RETURN;
1141: END IF;
1142:

Line 1139: x_resultout := wf_engine.eng_null;

1135: END IF;
1136:
1137: -- Do not perform anything in CANCEL or TIMEOUT mode
1138: IF (p_funcmode <> wf_engine.eng_run) THEN
1139: x_resultout := wf_engine.eng_null;
1140: RETURN;
1141: END IF;
1142:
1143: CREATE_ROLE ( p_item_type => p_itemtype,

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

1145: p_calledfrom => g_get_port_apprv,
1146: p_user_exists => l_user_exists);
1147:
1148: IF l_user_exists = 'Y' then
1149: x_resultout := wf_engine.eng_completed||':'||'T';
1150: ELSE
1151: x_resultout := wf_engine.eng_completed||':'||'F';
1152: END IF;
1153:

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

1147:
1148: IF l_user_exists = 'Y' then
1149: x_resultout := wf_engine.eng_completed||':'||'T';
1150: ELSE
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

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

1189: 'Entering fpa_main_process_pvt.get_analyst');
1190: END IF;
1191:
1192: -- Do not perform anything in CANCEL or TIMEOUT mode
1193: IF (p_funcmode <> wf_engine.eng_run) THEN
1194: x_resultout := wf_engine.eng_null;
1195: RETURN;
1196: END IF;
1197:

Line 1194: x_resultout := wf_engine.eng_null;

1190: END IF;
1191:
1192: -- Do not perform anything in CANCEL or TIMEOUT mode
1193: IF (p_funcmode <> wf_engine.eng_run) THEN
1194: x_resultout := wf_engine.eng_null;
1195: RETURN;
1196: END IF;
1197:
1198: CREATE_ROLE ( p_item_type => p_itemtype,

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

1200: p_calledfrom => g_get_port_analyst,
1201: p_user_exists => l_user_exists);
1202:
1203: IF l_user_exists = 'Y' then
1204: x_resultout := wf_engine.eng_completed||':'||'T';
1205: ELSE
1206: x_resultout := wf_engine.eng_completed||':'||'F';
1207: END IF;
1208:

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

1202:
1203: IF l_user_exists = 'Y' then
1204: x_resultout := wf_engine.eng_completed||':'||'T';
1205: ELSE
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

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

1247: 'Entering fpa_main_process_pvt.get_pc_managers');
1248: END IF;
1249:
1250: -- Do not perform anything in CANCEL or TIMEOUT mode
1251: IF (p_funcmode <> wf_engine.eng_run) THEN
1252: x_resultout := wf_engine.eng_null;
1253: RETURN;
1254: END IF;
1255:

Line 1252: x_resultout := wf_engine.eng_null;

1248: END IF;
1249:
1250: -- Do not perform anything in CANCEL or TIMEOUT mode
1251: IF (p_funcmode <> wf_engine.eng_run) THEN
1252: x_resultout := wf_engine.eng_null;
1253: RETURN;
1254: END IF;
1255:
1256: CREATE_ROLE ( p_item_type => p_itemtype,

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

1258: p_calledfrom => g_get_pc_manager,
1259: p_user_exists => l_user_exists);
1260:
1261: IF l_user_exists = 'Y' then
1262: x_resultout := wf_engine.eng_completed||':'||'T';
1263: ELSE
1264: x_resultout := wf_engine.eng_completed||':'||'F';
1265: END IF;
1266:

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

1260:
1261: IF l_user_exists = 'Y' then
1262: x_resultout := wf_engine.eng_completed||':'||'T';
1263: ELSE
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

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

1347: END IF;
1348:
1349:
1350: -- Get the Planning Cycle ID
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

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

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:
1530: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
1531: itemkey => p_itemkey,

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

1526: 'fpa.sql.fpa_main_process_pvt.call_create_initial_scenario.begin',
1527: 'Calling wf_engine.SetItemAttrNumber.');
1528: END IF;
1529:
1530: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
1531: itemkey => p_itemkey,
1532: aname => 'FPA_SCENARIO_ID',
1533: avalue => l_scenario_id);
1534:

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

1574:
1575: BEGIN
1576:
1577: -- Get the Planning Cycle ID
1578: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1579: itemkey => p_itemkey,
1580: aname => 'FPA_PC_ID');
1581:
1582: l_pc_status := 'CREATED';

Line 1592: x_resultout := wf_engine.eng_null;

1588: x_return_status => l_return_status,
1589: x_msg_count => l_msg_count,
1590: x_msg_data => l_msg_data);
1591:
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

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

1626: 'Entering fpa_main_process_pvt.call_project_sets');
1627: END IF;
1628:
1629: -- Gets the Scenario ID
1630: l_scen_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1631: itemkey => p_itemkey,
1632: aname => 'FPA_SCENARIO_ID');
1633:
1634:

Line 1649: x_resultout := wf_engine.eng_null;

1645: 'fpa.sql.fpa_main_process_pvt.call_project_sets.end',
1646: 'Exiting fpa_main_process_pvt.call_project_sets');
1647: END IF;
1648:
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

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

1681: l_is_approved VARCHAR2(1) := 'N';
1682:
1683: BEGIN
1684:
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

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

1727:
1728: BEGIN
1729:
1730: -- Get the Planning Cycle ID
1731: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1732: itemkey => p_itemkey,
1733: aname => 'FPA_PC_ID');
1734:
1735: l_pc_status := 'ANALYSIS';

Line 1746: x_resultout := wf_engine.eng_null;

1742: x_return_status => l_return_status,
1743: x_msg_count => l_msg_count,
1744: x_msg_data => l_msg_data);
1745:
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

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

1780: 'Entering fpa_main_process_pvt.set_status_approved p_itemkey'||p_itemkey);
1781: END IF;
1782:
1783: -- Get the Planning Cycle ID
1784: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1785: itemkey => p_itemkey,
1786: aname => 'FPA_PC_ID');
1787:
1788: l_pc_approve := wf_engine.GetItemAttrText(itemtype => p_itemtype,

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

1784: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1785: itemkey => p_itemkey,
1786: aname => 'FPA_PC_ID');
1787:
1788: l_pc_approve := wf_engine.GetItemAttrText(itemtype => p_itemtype,
1789: itemkey => p_itemkey,
1790: aname => 'FPA_APPROVE_PC');
1791:
1792: IF l_pc_approve = 'Y' THEN

Line 1814: x_resultout := wf_engine.eng_null;

1810: x_return_status => l_return_status,
1811: x_msg_count => l_msg_count,
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',

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

1855: );
1856: END IF;
1857:
1858: -- Get the Planning Cycle ID
1859: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1860: itemkey => p_itemkey,
1861: aname => 'FPA_PC_ID');
1862:
1863: l_pc_status := 'CLOSED';

Line 1890: x_resultout := wf_engine.eng_null;

1886: x_msg_data => l_msg_data,
1887: x_msg_count => l_msg_count
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,

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

1927:
1928: BEGIN
1929:
1930: -- Get the Planning Cycle ID
1931: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1932: itemkey => p_itemkey,
1933: aname => 'FPA_PC_ID');
1934:
1935: l_pc_status := 'COLLECTING';

Line 1945: x_resultout := wf_engine.eng_null;

1941: x_return_status => l_return_status,
1942: x_msg_count => l_msg_count,
1943: x_msg_data => l_msg_data);
1944:
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

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

1977:
1978: BEGIN
1979:
1980: -- Get the Planning Cycle ID
1981: l_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
1982: itemkey => p_itemkey,
1983: aname => 'FPA_PC_ID');
1984:
1985: l_pc_status := 'SUBMITTED';

Line 1996: x_resultout := wf_engine.eng_null;

1992: x_return_status => l_return_status,
1993: x_msg_count => l_msg_count,
1994: x_msg_data => l_msg_data);
1995:
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

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

2154:
2155: l_eventkey := 'FPAL' ||p_itemkey;
2156:
2157: IF p_event_name = 'FPA_APPROVE_PLAN' THEN
2158: wf_engine.SetItemAttrText(itemtype => 'FPAPJP',
2159: itemkey => l_eventkey ,
2160: aname => 'FPA_APPROVE_PC',
2161: avalue => 'Y');
2162: ELSIF p_event_name = 'FPA_REJECT_PLAN' or p_event_name = 'FPA_WITHDRAW_PLAN' THEN

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

2159: itemkey => l_eventkey ,
2160: aname => 'FPA_APPROVE_PC',
2161: avalue => 'Y');
2162: ELSIF p_event_name = 'FPA_REJECT_PLAN' or p_event_name = 'FPA_WITHDRAW_PLAN' THEN
2163: wf_engine.SetItemAttrText(itemtype => 'FPAPJP',
2164: itemkey => l_eventkey ,
2165: aname => 'FPA_APPROVE_PC',
2166: avalue => 'N');
2167: END IF;

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

2381: END IF;
2382:
2383: -- Get the Planning Cycle ID
2384: l_last_pc_id := NULL;
2385: l_last_pc_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
2386: itemkey => p_itemkey,
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

Line 2437: x_resultout := wf_engine.eng_null;

2433: END LOOP;
2434:
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',

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

2486:
2487: l_wf_aw_attached := 'Y' ;
2488:
2489: -- Sets the Planning Cycle ID
2490: wf_engine.SetItemAttrtext(itemtype => p_itemtype,
2491: itemkey => p_itemkey,
2492: aname => 'FPA_WF_AW_ATTACHED',
2493: avalue => l_wf_aw_attached);
2494:

Line 2495: x_resultout := wf_engine.eng_null;

2491: itemkey => p_itemkey,
2492: aname => 'FPA_WF_AW_ATTACHED',
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',

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

2533: END IF;
2534:
2535: -- Sets the Planning Cycle ID
2536: l_wf_aw_attached := 'N';
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

Line 2562: x_resultout := wf_engine.eng_null;

2558: x_msg_data => l_msg_data
2559: );
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',