APPS.PA_HR_UPDATE_PA_ENTITIES dependencies on WF_ENGINE

Line 160: l_save_thresh := wf_engine.threshold ;

156: -- to change the threshold. So we save the current threshold which
157: -- will be used later on to change it back to the current threshold.
158: --
159:
160: l_save_thresh := wf_engine.threshold ;
161:
162:
163: IF wf_engine.threshold < 0 THEN
164: wf_engine.threshold := l_save_thresh ;

Line 163: IF wf_engine.threshold < 0 THEN

159:
160: l_save_thresh := wf_engine.threshold ;
161:
162:
163: IF wf_engine.threshold < 0 THEN
164: wf_engine.threshold := l_save_thresh ;
165: END IF;
166:
167:

Line 164: wf_engine.threshold := l_save_thresh ;

160: l_save_thresh := wf_engine.threshold ;
161:
162:
163: IF wf_engine.threshold < 0 THEN
164: wf_engine.threshold := l_save_thresh ;
165: END IF;
166:
167:
168: --

Line 173: wf_engine.threshold := -1 ;

169: -- Set the threshold to bellow 0 so that the process will be created
170: -- in the background
171: --
172:
173: wf_engine.threshold := -1 ;
174:
175:
176: IF p_table_name = 'PER_ALL_ASSIGNMENTS_F' THEN
177: l_process := 'PROCESS_ASSIGNMENT_CHANGES' ;

Line 222: wf_engine.CreateProcess( ItemType => ItemType,

218: --
219: -- Create the appropriate process
220: --
221:
222: wf_engine.CreateProcess( ItemType => ItemType,
223: ItemKey => ItemKey,
224: process => l_process );
225:
226: --

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

226: --
227: -- Initialize workflow item attributes with the parameter values
228: --
229:
230: wf_engine.SetItemAttrText ( itemtype => itemtype,
231: itemkey => itemkey,
232: aname => 'PROJECT_RESOURCE_ADMINISTRATOR',
233: avalue => 'PASYSADMIN');
234:

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

231: itemkey => itemkey,
232: aname => 'PROJECT_RESOURCE_ADMINISTRATOR',
233: avalue => 'PASYSADMIN');
234:
235: wf_engine.SetItemAttrText ( itemtype => itemtype,
236: itemkey => itemkey,
237: aname => 'CALLING_MODE',
238: avalue => p_calling_mode);
239:

Line 240: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

236: itemkey => itemkey,
237: aname => 'CALLING_MODE',
238: avalue => p_calling_mode);
239:
240: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
241: itemkey => itemkey,
242: aname => 'ORG_STRUCTURE_ELEMENT_ID',
243: avalue => p_org_struct_element_id);
244:

Line 245: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

241: itemkey => itemkey,
242: aname => 'ORG_STRUCTURE_ELEMENT_ID',
243: avalue => p_org_struct_element_id);
244:
245: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
246: itemkey => itemkey,
247: aname => 'ORGANIZATION_ID_PARENT',
248: avalue => p_organization_id_parent);
249:

Line 250: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

246: itemkey => itemkey,
247: aname => 'ORGANIZATION_ID_PARENT',
248: avalue => p_organization_id_parent);
249:
250: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
251: itemkey => itemkey,
252: aname => 'ORGANIZATION_ID_CHILD',
253: avalue => p_organization_id_child);
254:

Line 255: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

251: itemkey => itemkey,
252: aname => 'ORGANIZATION_ID_CHILD',
253: avalue => p_organization_id_child);
254:
255: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
256: itemkey => itemkey,
257: aname => 'ORG_STRUCTURE_VERSION_ID',
258: avalue => p_org_structure_version_id);
259:

Line 260: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

256: itemkey => itemkey,
257: aname => 'ORG_STRUCTURE_VERSION_ID',
258: avalue => p_org_structure_version_id);
259:
260: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
261: itemkey => itemkey,
262: aname => 'PERSON_ID',
263: avalue => p_person_id);
264:

Line 265: wf_engine.SetItemAttrDate ( itemtype => itemtype,

261: itemkey => itemkey,
262: aname => 'PERSON_ID',
263: avalue => p_person_id);
264:
265: wf_engine.SetItemAttrDate ( itemtype => itemtype,
266: itemkey => itemkey,
267: aname => 'START_DATE_OLD',
268: avalue => p_start_date_old);
269:

Line 270: wf_engine.SetItemAttrDate ( itemtype => itemtype,

266: itemkey => itemkey,
267: aname => 'START_DATE_OLD',
268: avalue => p_start_date_old);
269:
270: wf_engine.SetItemAttrDate ( itemtype => itemtype,
271: itemkey => itemkey,
272: aname => 'START_DATE_NEW',
273: avalue => p_start_date_new);
274:

Line 275: wf_engine.SetItemAttrDate ( itemtype => itemtype,

271: itemkey => itemkey,
272: aname => 'START_DATE_NEW',
273: avalue => p_start_date_new);
274:
275: wf_engine.SetItemAttrDate ( itemtype => itemtype,
276: itemkey => itemkey,
277: aname => 'END_DATE_OLD',
278: avalue => p_end_date_old);
279:

Line 280: wf_engine.SetItemAttrDate ( itemtype => itemtype,

276: itemkey => itemkey,
277: aname => 'END_DATE_OLD',
278: avalue => p_end_date_old);
279:
280: wf_engine.SetItemAttrDate ( itemtype => itemtype,
281: itemkey => itemkey,
282: aname => 'END_DATE_NEW',
283: avalue => p_end_date_new);
284:

Line 285: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

281: itemkey => itemkey,
282: aname => 'END_DATE_NEW',
283: avalue => p_end_date_new);
284:
285: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
286: itemkey => itemkey,
287: aname => 'ORG_ID_OLD',
288: avalue => p_org_id_old);
289:

Line 290: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

286: itemkey => itemkey,
287: aname => 'ORG_ID_OLD',
288: avalue => p_org_id_old);
289:
290: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
291: itemkey => itemkey,
292: aname => 'ORG_ID_NEW',
293: avalue => p_org_id_new);
294:

Line 299: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

295: -- Bug 4575004 - removed the setting of attribute SEQUENCE_NEW and
296: -- SEQUENCE_OLD since those attributes are not used and have been
297: -- removed from the workflow.
298:
299: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
300: itemkey => itemkey,
301: aname => 'JOB_ID_OLD',
302: avalue => p_job_id_old);
303:

Line 304: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

300: itemkey => itemkey,
301: aname => 'JOB_ID_OLD',
302: avalue => p_job_id_old);
303:
304: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
305: itemkey => itemkey,
306: aname => 'JOB_ID_NEW',
307: avalue => p_job_id_new);
308:

Line 309: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

305: itemkey => itemkey,
306: aname => 'JOB_ID_NEW',
307: avalue => p_job_id_new);
308:
309: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
310: itemkey => itemkey,
311: aname => 'FROM_JOB_GROUP_ID',
312: avalue => p_from_job_group_id);
313:

Line 314: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

310: itemkey => itemkey,
311: aname => 'FROM_JOB_GROUP_ID',
312: avalue => p_from_job_group_id);
313:
314: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
315: itemkey => itemkey,
316: aname => 'TO_JOB_GROUP_ID',
317: avalue => p_to_job_group_id);
318:

Line 319: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

315: itemkey => itemkey,
316: aname => 'TO_JOB_GROUP_ID',
317: avalue => p_to_job_group_id);
318:
319: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
320: itemkey => itemkey,
321: aname => 'SUPERVISOR_OLD',
322: avalue => p_supervisor_old);
323:

Line 324: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

320: itemkey => itemkey,
321: aname => 'SUPERVISOR_OLD',
322: avalue => p_supervisor_old);
323:
324: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
325: itemkey => itemkey,
326: aname => 'SUPERVISOR_NEW',
327: avalue => p_supervisor_new);
328:

Line 329: wf_engine.SetItemAttrText ( itemtype => itemtype,

325: itemkey => itemkey,
326: aname => 'SUPERVISOR_NEW',
327: avalue => p_supervisor_new);
328:
329: wf_engine.SetItemAttrText ( itemtype => itemtype,
330: itemkey => itemkey,
331: aname => 'PRIMARY_FLAG_OLD',
332: avalue => p_primary_flag_old);
333:

Line 334: wf_engine.SetItemAttrText ( itemtype => itemtype,

330: itemkey => itemkey,
331: aname => 'PRIMARY_FLAG_OLD',
332: avalue => p_primary_flag_old);
333:
334: wf_engine.SetItemAttrText ( itemtype => itemtype,
335: itemkey => itemkey,
336: aname => 'PRIMARY_FLAG_NEW',
337: avalue => p_primary_flag_new);
338:

Line 339: wf_engine.SetItemAttrText ( itemtype => itemtype,

335: itemkey => itemkey,
336: aname => 'PRIMARY_FLAG_NEW',
337: avalue => p_primary_flag_new);
338:
339: wf_engine.SetItemAttrText ( itemtype => itemtype,
340: itemkey => itemkey,
341: aname => 'ORG_INFO1_OLD',
342: avalue => p_org_info1_old);
343:

Line 344: wf_engine.SetItemAttrText ( itemtype => itemtype,

340: itemkey => itemkey,
341: aname => 'ORG_INFO1_OLD',
342: avalue => p_org_info1_old);
343:
344: wf_engine.SetItemAttrText ( itemtype => itemtype,
345: itemkey => itemkey,
346: aname => 'ORG_INFO1_NEW',
347: avalue => p_org_info1_new);
348:

Line 349: wf_engine.SetItemAttrText ( itemtype => itemtype,

345: itemkey => itemkey,
346: aname => 'ORG_INFO1_NEW',
347: avalue => p_org_info1_new);
348:
349: wf_engine.SetItemAttrText ( itemtype => itemtype,
350: itemkey => itemkey,
351: aname => 'JEI_INFORMATION2_OLD',
352: avalue => p_jei_information2_old);
353:

Line 354: wf_engine.SetItemAttrText ( itemtype => itemtype,

350: itemkey => itemkey,
351: aname => 'JEI_INFORMATION2_OLD',
352: avalue => p_jei_information2_old);
353:
354: wf_engine.SetItemAttrText ( itemtype => itemtype,
355: itemkey => itemkey,
356: aname => 'JEI_INFORMATION2_NEW',
357: avalue => p_jei_information2_new);
358:

Line 359: wf_engine.SetItemAttrText ( itemtype => itemtype,

355: itemkey => itemkey,
356: aname => 'JEI_INFORMATION2_NEW',
357: avalue => p_jei_information2_new);
358:
359: wf_engine.SetItemAttrText ( itemtype => itemtype,
360: itemkey => itemkey,
361: aname => 'JEI_INFORMATION3_OLD',
362: avalue => p_jei_information3_old);
363:

Line 364: wf_engine.SetItemAttrText ( itemtype => itemtype,

360: itemkey => itemkey,
361: aname => 'JEI_INFORMATION3_OLD',
362: avalue => p_jei_information3_old);
363:
364: wf_engine.SetItemAttrText ( itemtype => itemtype,
365: itemkey => itemkey,
366: aname => 'JEI_INFORMATION3_NEW',
367: avalue => p_jei_information3_new);
368:

Line 369: wf_engine.SetItemAttrText ( itemtype => itemtype,

365: itemkey => itemkey,
366: aname => 'JEI_INFORMATION3_NEW',
367: avalue => p_jei_information3_new);
368:
369: wf_engine.SetItemAttrText ( itemtype => itemtype,
370: itemkey => itemkey,
371: aname => 'JEI_INFORMATION4_OLD',
372: avalue => p_jei_information4_old);
373:

Line 374: wf_engine.SetItemAttrText ( itemtype => itemtype,

370: itemkey => itemkey,
371: aname => 'JEI_INFORMATION4_OLD',
372: avalue => p_jei_information4_old);
373:
374: wf_engine.SetItemAttrText ( itemtype => itemtype,
375: itemkey => itemkey,
376: aname => 'JEI_INFORMATION4_NEW',
377: avalue => p_jei_information4_new);
378: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 378: wf_engine.SetItemAttrText ( itemtype => itemtype,

374: wf_engine.SetItemAttrText ( itemtype => itemtype,
375: itemkey => itemkey,
376: aname => 'JEI_INFORMATION4_NEW',
377: avalue => p_jei_information4_new);
378: wf_engine.SetItemAttrText ( itemtype => itemtype,
379: itemkey => itemkey,
380: aname => 'JEI_INFORMATION6_OLD',
381: avalue => p_jei_information6_old);
382:

Line 383: wf_engine.SetItemAttrText ( itemtype => itemtype,

379: itemkey => itemkey,
380: aname => 'JEI_INFORMATION6_OLD',
381: avalue => p_jei_information6_old);
382:
383: wf_engine.SetItemAttrText ( itemtype => itemtype,
384: itemkey => itemkey,
385: aname => 'JEI_INFORMATION6_NEW',
386: avalue => p_jei_information6_new);
387:

Line 388: wf_engine.SetItemAttrText ( itemtype => itemtype,

384: itemkey => itemkey,
385: aname => 'JEI_INFORMATION6_NEW',
386: avalue => p_jei_information6_new);
387:
388: wf_engine.SetItemAttrText ( itemtype => itemtype,
389: itemkey => itemkey,
390: aname => 'FULL_NAME_OLD',
391: avalue => p_full_name_old);
392:

Line 393: wf_engine.SetItemAttrText ( itemtype => itemtype,

389: itemkey => itemkey,
390: aname => 'FULL_NAME_OLD',
391: avalue => p_full_name_old);
392:
393: wf_engine.SetItemAttrText ( itemtype => itemtype,
394: itemkey => itemkey,
395: aname => 'FULL_NAME_NEW',
396: avalue => p_full_name_new);
397:

Line 402: wf_engine.SetItemAttrText ( itemtype => itemtype,

398: -- Bug 4575004 - removed the setting of attribute GRADE_ID_OLD and
399: -- GRADE_ID_NEW since those attributes are not used and have been
400: -- removed from the workflow.
401:
402: wf_engine.SetItemAttrText ( itemtype => itemtype,
403: itemkey => itemkey,
404: aname => 'COUNTRY_OLD',
405: avalue => p_country_old);
406:

Line 407: wf_engine.SetItemAttrText ( itemtype => itemtype,

403: itemkey => itemkey,
404: aname => 'COUNTRY_OLD',
405: avalue => p_country_old);
406:
407: wf_engine.SetItemAttrText ( itemtype => itemtype,
408: itemkey => itemkey,
409: aname => 'COUNTRY_NEW',
410: avalue => p_country_new);
411:

Line 412: wf_engine.SetItemAttrText ( itemtype => itemtype,

408: itemkey => itemkey,
409: aname => 'COUNTRY_NEW',
410: avalue => p_country_new);
411:
412: wf_engine.SetItemAttrText ( itemtype => itemtype,
413: itemkey => itemkey,
414: aname => 'CITY_OLD',
415: avalue => p_city_old);
416:

Line 417: wf_engine.SetItemAttrText ( itemtype => itemtype,

413: itemkey => itemkey,
414: aname => 'CITY_OLD',
415: avalue => p_city_old);
416:
417: wf_engine.SetItemAttrText ( itemtype => itemtype,
418: itemkey => itemkey,
419: aname => 'CITY_NEW',
420: avalue => p_city_new);
421:

Line 422: wf_engine.SetItemAttrText ( itemtype => itemtype,

418: itemkey => itemkey,
419: aname => 'CITY_NEW',
420: avalue => p_city_new);
421:
422: wf_engine.SetItemAttrText ( itemtype => itemtype,
423: itemkey => itemkey,
424: aname => 'REGION2_OLD',
425: avalue => p_region2_old);
426:

Line 427: wf_engine.SetItemAttrText ( itemtype => itemtype,

423: itemkey => itemkey,
424: aname => 'REGION2_OLD',
425: avalue => p_region2_old);
426:
427: wf_engine.SetItemAttrText ( itemtype => itemtype,
428: itemkey => itemkey,
429: aname => 'REGION2_NEW',
430: avalue => p_region2_new);
431:

Line 432: wf_engine.SetItemAttrDate ( itemtype => itemtype,

428: itemkey => itemkey,
429: aname => 'REGION2_NEW',
430: avalue => p_region2_new);
431:
432: wf_engine.SetItemAttrDate ( itemtype => itemtype,
433: itemkey => itemkey,
434: aname => 'INACTIVE_DATE_OLD',
435: avalue => p_inactive_date_old);
436:

Line 437: wf_engine.SetItemAttrDate ( itemtype => itemtype,

433: itemkey => itemkey,
434: aname => 'INACTIVE_DATE_OLD',
435: avalue => p_inactive_date_old);
436:
437: wf_engine.SetItemAttrDate ( itemtype => itemtype,
438: itemkey => itemkey,
439: aname => 'INACTIVE_DATE_NEW',
440: avalue => p_inactive_date_new);
441:

Line 442: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

438: itemkey => itemkey,
439: aname => 'INACTIVE_DATE_NEW',
440: avalue => p_inactive_date_new);
441:
442: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
443: itemkey => itemkey,
444: aname => 'FROM_JOB_ID_OLD',
445: avalue => p_from_job_id_old);
446:

Line 447: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

443: itemkey => itemkey,
444: aname => 'FROM_JOB_ID_OLD',
445: avalue => p_from_job_id_old);
446:
447: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
448: itemkey => itemkey,
449: aname => 'FROM_JOB_ID_NEW',
450: avalue => p_from_job_id_new);
451:

Line 452: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

448: itemkey => itemkey,
449: aname => 'FROM_JOB_ID_NEW',
450: avalue => p_from_job_id_new);
451:
452: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
453: itemkey => itemkey,
454: aname => 'TO_JOB_ID_OLD',
455: avalue => p_to_job_id_old);
456:

Line 457: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

453: itemkey => itemkey,
454: aname => 'TO_JOB_ID_OLD',
455: avalue => p_to_job_id_old);
456:
457: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
458: itemkey => itemkey,
459: aname => 'TO_JOB_ID_NEW',
460: avalue => p_to_job_id_new);
461:

Line 462: wf_engine.SetItemAttrText ( itemtype => itemtype,

458: itemkey => itemkey,
459: aname => 'TO_JOB_ID_NEW',
460: avalue => p_to_job_id_new);
461:
462: wf_engine.SetItemAttrText ( itemtype => itemtype,
463: itemkey => itemkey,
464: aname => 'ORG_INFO_CONTEXT',
465: avalue => p_org_info_context);
466:

Line 468: wf_engine.StartProcess( itemtype => itemtype,

464: aname => 'ORG_INFO_CONTEXT',
465: avalue => p_org_info_context);
466:
467:
468: wf_engine.StartProcess( itemtype => itemtype,
469: itemkey => itemkey );
470:
471:
472: -- Insert to PA tables wf process information.

Line 495: wf_engine.threshold := l_save_thresh ;

491: null;
492: END;
493:
494: --
495: wf_engine.threshold := l_save_thresh ;
496: exception
497: when others then
498: null;
499:

Line 538: l_org_struct_element_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

534: --
535: -- Get the workflow attribute values
536: --
537:
538: l_org_struct_element_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
539: itemkey => itemkey,
540: aname => 'ORG_STRUCTURE_ELEMENT_ID' );
541:
542: l_organization_id_parent := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 542: l_organization_id_parent := wf_engine.GetItemAttrNumber( itemtype => itemtype,

538: l_org_struct_element_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
539: itemkey => itemkey,
540: aname => 'ORG_STRUCTURE_ELEMENT_ID' );
541:
542: l_organization_id_parent := wf_engine.GetItemAttrNumber( itemtype => itemtype,
543: itemkey => itemkey,
544: aname => 'ORGANIZATION_ID_PARENT' );
545:
546: l_organization_id_child := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 546: l_organization_id_child := wf_engine.GetItemAttrNumber(itemtype => itemtype,

542: l_organization_id_parent := wf_engine.GetItemAttrNumber( itemtype => itemtype,
543: itemkey => itemkey,
544: aname => 'ORGANIZATION_ID_PARENT' );
545:
546: l_organization_id_child := wf_engine.GetItemAttrNumber(itemtype => itemtype,
547: itemkey => itemkey,
548: aname => 'ORGANIZATION_ID_CHILD' );
549:
550: l_org_structure_version_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 550: l_org_structure_version_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

546: l_organization_id_child := wf_engine.GetItemAttrNumber(itemtype => itemtype,
547: itemkey => itemkey,
548: aname => 'ORGANIZATION_ID_CHILD' );
549:
550: l_org_structure_version_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
551: itemkey => itemkey,
552: aname => 'ORG_STRUCTURE_VERSION_ID' );
553:
554: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 554: wf_engine.SetItemAttrText ( itemtype => itemtype,

550: l_org_structure_version_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
551: itemkey => itemkey,
552: aname => 'ORG_STRUCTURE_VERSION_ID' );
553:
554: wf_engine.SetItemAttrText ( itemtype => itemtype,
555: itemkey => itemkey,
556: aname => 'ORGANIZATION_NAME',
557: avalue => pa_hr_update_api.get_org_name(l_organization_id_child));
558:

Line 559: wf_engine.SetItemAttrText ( itemtype => itemtype,

555: itemkey => itemkey,
556: aname => 'ORGANIZATION_NAME',
557: avalue => pa_hr_update_api.get_org_name(l_organization_id_child));
558:
559: wf_engine.SetItemAttrText ( itemtype => itemtype,
560: itemkey => itemkey,
561: aname => 'CHILD_ORGANIZATION_NAME',
562: avalue => pa_hr_update_api.get_org_name(l_organization_id_parent));
563:

Line 578: resultout := wf_engine.eng_completed||':'||'S';

574: x_err_stack => v_err_stack);
575:
576: IF nvl(v_err_code, 0) = 0 THEN
577:
578: resultout := wf_engine.eng_completed||':'||'S';
579: ELSE
580:
581: --
582: -- Set any error messages

Line 590: resultout := wf_engine.eng_completed||':'||'F';

586: set_nf_error_msg_attr(p_item_type => itemtype,
587: p_item_key => itemkey,
588: p_msg_count => l_msg_count,
589: p_msg_data => l_msg_data);
590: resultout := wf_engine.eng_completed||':'||'F';
591:
592: END IF;
593:
594: --

Line 634: wf_engine.SetItemAttrText

630: rollback to l_org_struct_element_change ;
631: End if;
632: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
633:
634: wf_engine.SetItemAttrText
635: ( itemtype => itemtype
636: , itemkey => itemkey
637: , aname => 'ERROR_MSG1'
638: , avalue => SQLCODE||SQLERRM

Line 683: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,

679: begin
680: --
681: -- Get the workflow attribute values
682: --
683: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
684: itemkey => itemkey,
685: aname => 'CALLING_MODE' );
686: l_job_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
687: itemkey => itemkey,

Line 686: l_job_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

682: --
683: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
684: itemkey => itemkey,
685: aname => 'CALLING_MODE' );
686: l_job_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
687: itemkey => itemkey,
688: aname => 'JOB_ID_NEW' );
689: l_jei_information2_old := wf_engine.GetItemAttrText( itemtype => itemtype,
690: itemkey => itemkey,

Line 689: l_jei_information2_old := wf_engine.GetItemAttrText( itemtype => itemtype,

685: aname => 'CALLING_MODE' );
686: l_job_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
687: itemkey => itemkey,
688: aname => 'JOB_ID_NEW' );
689: l_jei_information2_old := wf_engine.GetItemAttrText( itemtype => itemtype,
690: itemkey => itemkey,
691: aname => 'JEI_INFORMATION2_OLD' );
692: l_jei_information2_new := wf_engine.GetItemAttrText( itemtype => itemtype,
693: itemkey => itemkey,

Line 692: l_jei_information2_new := wf_engine.GetItemAttrText( itemtype => itemtype,

688: aname => 'JOB_ID_NEW' );
689: l_jei_information2_old := wf_engine.GetItemAttrText( itemtype => itemtype,
690: itemkey => itemkey,
691: aname => 'JEI_INFORMATION2_OLD' );
692: l_jei_information2_new := wf_engine.GetItemAttrText( itemtype => itemtype,
693: itemkey => itemkey,
694: aname => 'JEI_INFORMATION2_NEW' );
695: l_jei_information3_old := wf_engine.GetItemAttrText( itemtype => itemtype,
696: itemkey => itemkey,

Line 695: l_jei_information3_old := wf_engine.GetItemAttrText( itemtype => itemtype,

691: aname => 'JEI_INFORMATION2_OLD' );
692: l_jei_information2_new := wf_engine.GetItemAttrText( itemtype => itemtype,
693: itemkey => itemkey,
694: aname => 'JEI_INFORMATION2_NEW' );
695: l_jei_information3_old := wf_engine.GetItemAttrText( itemtype => itemtype,
696: itemkey => itemkey,
697: aname => 'JEI_INFORMATION3_OLD' );
698: l_jei_information3_new := wf_engine.GetItemAttrText(itemtype => itemtype,
699: itemkey => itemkey,

Line 698: l_jei_information3_new := wf_engine.GetItemAttrText(itemtype => itemtype,

694: aname => 'JEI_INFORMATION2_NEW' );
695: l_jei_information3_old := wf_engine.GetItemAttrText( itemtype => itemtype,
696: itemkey => itemkey,
697: aname => 'JEI_INFORMATION3_OLD' );
698: l_jei_information3_new := wf_engine.GetItemAttrText(itemtype => itemtype,
699: itemkey => itemkey,
700: aname => 'JEI_INFORMATION3_NEW' );
701: l_jei_information4_old := wf_engine.GetItemAttrText( itemtype => itemtype,
702: itemkey => itemkey,

Line 701: l_jei_information4_old := wf_engine.GetItemAttrText( itemtype => itemtype,

697: aname => 'JEI_INFORMATION3_OLD' );
698: l_jei_information3_new := wf_engine.GetItemAttrText(itemtype => itemtype,
699: itemkey => itemkey,
700: aname => 'JEI_INFORMATION3_NEW' );
701: l_jei_information4_old := wf_engine.GetItemAttrText( itemtype => itemtype,
702: itemkey => itemkey,
703: aname => 'JEI_INFORMATION4_OLD' );
704: l_jei_information4_new := wf_engine.GetItemAttrText(itemtype => itemtype,
705: itemkey => itemkey,

Line 704: l_jei_information4_new := wf_engine.GetItemAttrText(itemtype => itemtype,

700: aname => 'JEI_INFORMATION3_NEW' );
701: l_jei_information4_old := wf_engine.GetItemAttrText( itemtype => itemtype,
702: itemkey => itemkey,
703: aname => 'JEI_INFORMATION4_OLD' );
704: l_jei_information4_new := wf_engine.GetItemAttrText(itemtype => itemtype,
705: itemkey => itemkey,
706: aname => 'JEI_INFORMATION4_NEW' );
707: l_jei_information6_old := wf_engine.GetItemAttrText( itemtype => itemtype,
708: itemkey => itemkey,

Line 707: l_jei_information6_old := wf_engine.GetItemAttrText( itemtype => itemtype,

703: aname => 'JEI_INFORMATION4_OLD' );
704: l_jei_information4_new := wf_engine.GetItemAttrText(itemtype => itemtype,
705: itemkey => itemkey,
706: aname => 'JEI_INFORMATION4_NEW' );
707: l_jei_information6_old := wf_engine.GetItemAttrText( itemtype => itemtype,
708: itemkey => itemkey,
709: aname => 'JEI_INFORMATION6_OLD' );
710: l_jei_information6_new := wf_engine.GetItemAttrText(itemtype => itemtype,
711: itemkey => itemkey,

Line 710: l_jei_information6_new := wf_engine.GetItemAttrText(itemtype => itemtype,

706: aname => 'JEI_INFORMATION4_NEW' );
707: l_jei_information6_old := wf_engine.GetItemAttrText( itemtype => itemtype,
708: itemkey => itemkey,
709: aname => 'JEI_INFORMATION6_OLD' );
710: l_jei_information6_new := wf_engine.GetItemAttrText(itemtype => itemtype,
711: itemkey => itemkey,
712: aname => 'JEI_INFORMATION6_NEW' );
713:
714: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 714: wf_engine.SetItemAttrText ( itemtype => itemtype,

710: l_jei_information6_new := wf_engine.GetItemAttrText(itemtype => itemtype,
711: itemkey => itemkey,
712: aname => 'JEI_INFORMATION6_NEW' );
713:
714: wf_engine.SetItemAttrText ( itemtype => itemtype,
715: itemkey => itemkey,
716: aname => 'JOB_NAME',
717: avalue => pa_hr_update_api.get_job_name(l_job_id));
718:

Line 744: resultout := wf_engine.eng_completed||':'||'S';

740: log_message('after calling per_job_extra_billability, l_return_status: '
741: ||l_return_status);
742: IF l_return_status = 'S' THEN
743:
744: resultout := wf_engine.eng_completed||':'||'S';
745: ELSIF l_return_status = 'E' THEN
746: --
747: -- Set any error messages
748: --

Line 755: resultout := wf_engine.eng_completed||':'||'F';

751: set_nf_error_msg_attr(p_item_type => itemtype,
752: p_item_key => itemkey,
753: p_msg_count => l_msg_count,
754: p_msg_data => l_msg_data);
755: resultout := wf_engine.eng_completed||':'||'F';
756:
757: ELSE
758: --
759: -- Set any error messages

Line 768: wf_engine.SetItemAttrText

764: p_item_key => itemkey,
765: p_msg_count => fnd_msg_pub.count_msg,
766: p_msg_data => l_msg_data);
767:
768: wf_engine.SetItemAttrText
769: ( itemtype => itemtype
770: , itemkey => itemkey
771: , aname => 'ERROR_MSG1'
772: , avalue => l_msg_data

Line 807: wf_engine.SetItemAttrText

803: funcmode);
804: If (l_savepoint) then
805: rollback to l_job_billability_change ;
806: End if;
807: wf_engine.SetItemAttrText
808: ( itemtype => itemtype
809: , itemkey => itemkey
810: , aname => 'ERROR_MSG1'
811: , avalue => SQLCODE||SQLERRM

Line 814: resultout := wf_engine.eng_completed||':'||'F';

810: , aname => 'ERROR_MSG1'
811: , avalue => SQLCODE||SQLERRM
812: );
813:
814: resultout := wf_engine.eng_completed||':'||'F';
815: */
816: WHEN OTHERS THEN
817: log_message('Execption OTHERS, '||SQLERRM ||', '|| SQLCODE);
818: wf_core.context('pa_forecast_test',

Line 831: wf_engine.SetItemAttrText

827: log_message('after rollback to l_job_billability_change');
828: End if;
829: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
830: log_message('l_msg_data is NULL');
831: wf_engine.SetItemAttrText
832: ( itemtype => itemtype
833: , itemkey => itemkey
834: , aname => 'ERROR_MSG1'
835: , avalue => SQLCODE||SQLERRM

Line 846: resultout := wf_engine.eng_completed||':'||'F';

842: p_msg_data => l_msg_data);
843:
844: End if;
845:
846: resultout := wf_engine.eng_completed||':'||'F';
847: log_message('resultout: '||resultout);
848: --RAISE;
849:
850: END Job_Bill_Change;

Line 887: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,

883: --
884: -- Get the workflow attribute values
885: --
886:
887: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
888: itemkey => itemkey,
889: aname => 'CALLING_MODE' );
890:
891: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 891: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

887: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
888: itemkey => itemkey,
889: aname => 'CALLING_MODE' );
890:
891: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
892: itemkey => itemkey,
893: aname => 'PERSON_ID' );
894:
895: l_full_name_old := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 895: l_full_name_old := wf_engine.GetItemAttrText(itemtype => itemtype,

891: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
892: itemkey => itemkey,
893: aname => 'PERSON_ID' );
894:
895: l_full_name_old := wf_engine.GetItemAttrText(itemtype => itemtype,
896: itemkey => itemkey,
897: aname => 'FULL_NAME_OLD');
898:
899: l_full_name_new := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 899: l_full_name_new := wf_engine.GetItemAttrText(itemtype => itemtype,

895: l_full_name_old := wf_engine.GetItemAttrText(itemtype => itemtype,
896: itemkey => itemkey,
897: aname => 'FULL_NAME_OLD');
898:
899: l_full_name_new := wf_engine.GetItemAttrText(itemtype => itemtype,
900: itemkey => itemkey,
901: aname => 'FULL_NAME_NEW');
902:
903: -- Removing the setting of the FULL_NAME_NEW attribute - no need

Line 920: resultout := wf_engine.eng_completed||':'||'S';

916: ,x_msg_data => l_msg_data);
917:
918: IF l_return_status = 'S' THEN
919:
920: resultout := wf_engine.eng_completed||':'||'S';
921: ELSIF l_return_status = 'E' THEN
922: --
923: -- Set any error messages
924: --

Line 931: resultout := wf_engine.eng_completed||':'||'F';

927: set_nf_error_msg_attr(p_item_type => itemtype,
928: p_item_key => itemkey,
929: p_msg_count => l_msg_count,
930: p_msg_data => l_msg_data);
931: resultout := wf_engine.eng_completed||':'||'F';
932:
933: ELSE
934: l_savepoint := false;
935: rollback to l_full_name_change ;

Line 941: wf_engine.SetItemAttrText

937: p_item_key => itemkey,
938: p_msg_count => fnd_msg_pub.count_msg,
939: p_msg_data => l_msg_data);
940:
941: wf_engine.SetItemAttrText
942: ( itemtype => itemtype
943: , itemkey => itemkey
944: , aname => 'ERROR_MSG1'
945: , avalue => l_msg_data

Line 968: resultout := wf_engine.eng_completed||':'||'F';

964: set_nf_error_msg_attr(p_item_type => itemtype,
965: p_item_key => itemkey,
966: p_msg_count => l_msg_count,
967: p_msg_data => l_msg_data);
968: resultout := wf_engine.eng_completed||':'||'F';
969:
970: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
971: THEN
972: wf_core.context('pa_hr_update_pa_entities',

Line 981: wf_engine.SetItemAttrText

977: funcmode);
978: If (l_savepoint) then
979: rollback to l_full_name_change ;
980: End if;
981: wf_engine.SetItemAttrText
982: ( itemtype => itemtype
983: , itemkey => itemkey
984: , aname => 'ERROR_MSG1'
985: , avalue => SQLERRM

Line 988: resultout := wf_engine.eng_completed||':'||'F';

984: , aname => 'ERROR_MSG1'
985: , avalue => SQLERRM
986: );
987:
988: resultout := wf_engine.eng_completed||':'||'F';
989: */
990: WHEN OTHERS THEN
991: wf_core.context('pa_hr_update_pa_entities',
992: 'Full_Name_Change',

Line 1002: wf_engine.SetItemAttrText

998: rollback to l_full_name_change ;
999: End if;
1000: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
1001:
1002: wf_engine.SetItemAttrText
1003: ( itemtype => itemtype
1004: , itemkey => itemkey
1005: , aname => 'ERROR_MSG1'
1006: , avalue => SQLCODE||SQLERRM

Line 1016: resultout := wf_engine.eng_completed||':'||'F';

1012: p_msg_data => l_msg_data);
1013:
1014: End if;
1015:
1016: resultout := wf_engine.eng_completed||':'||'F';
1017:
1018: END Full_Name_Change;
1019:
1020: PROCEDURE Default_OU_Change

Line 1058: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,

1054: --
1055: -- Initialize workflow item attributes
1056: --
1057:
1058: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1059: itemkey => itemkey,
1060: aname => 'CALLING_MODE' );
1061:
1062: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1062: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1058: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1059: itemkey => itemkey,
1060: aname => 'CALLING_MODE' );
1061:
1062: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1063: itemkey => itemkey,
1064: aname => 'ORG_ID_NEW' );
1065:
1066: l_org_info1_old := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 1066: l_org_info1_old := wf_engine.GetItemAttrText( itemtype => itemtype,

1062: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1063: itemkey => itemkey,
1064: aname => 'ORG_ID_NEW' );
1065:
1066: l_org_info1_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1067: itemkey => itemkey,
1068: aname => 'ORG_INFO1_OLD' );
1069:
1070: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1070: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,

1066: l_org_info1_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1067: itemkey => itemkey,
1068: aname => 'ORG_INFO1_OLD' );
1069:
1070: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1071: itemkey => itemkey,
1072: aname => 'ORG_INFO1_NEW' );
1073:
1074: l_org_info_context := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1074: l_org_info_context := wf_engine.GetItemAttrText(itemtype => itemtype,

1070: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1071: itemkey => itemkey,
1072: aname => 'ORG_INFO1_NEW' );
1073:
1074: l_org_info_context := wf_engine.GetItemAttrText(itemtype => itemtype,
1075: itemkey => itemkey,
1076: aname => 'ORG_INFO_CONTEXT' );
1077:
1078: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 1078: wf_engine.SetItemAttrText ( itemtype => itemtype,

1074: l_org_info_context := wf_engine.GetItemAttrText(itemtype => itemtype,
1075: itemkey => itemkey,
1076: aname => 'ORG_INFO_CONTEXT' );
1077:
1078: wf_engine.SetItemAttrText ( itemtype => itemtype,
1079: itemkey => itemkey,
1080: aname => 'ORGANIZATION_NAME',
1081: avalue => pa_hr_update_api.get_org_name(l_org_id));
1082:

Line 1114: resultout := wf_engine.eng_completed||':'||'S';

1110: END IF;
1111:
1112: IF l_return_status = 'S' THEN
1113:
1114: resultout := wf_engine.eng_completed||':'||'S';
1115: ELSIF l_return_status = 'E' THEN
1116: l_savepoint := false;
1117: rollback to l_ou_change ;
1118: set_nf_error_msg_attr(p_item_type => itemtype,

Line 1122: resultout := wf_engine.eng_completed||':'||'F';

1118: set_nf_error_msg_attr(p_item_type => itemtype,
1119: p_item_key => itemkey,
1120: p_msg_count => l_msg_count,
1121: p_msg_data => l_msg_data);
1122: resultout := wf_engine.eng_completed||':'||'F';
1123:
1124: ELSE
1125: l_savepoint := false;
1126: rollback to l_ou_change ;

Line 1132: wf_engine.SetItemAttrText

1128: p_item_key => itemkey,
1129: p_msg_count => fnd_msg_pub.count_msg,
1130: p_msg_data => l_msg_data);
1131:
1132: wf_engine.SetItemAttrText
1133: ( itemtype => itemtype
1134: , itemkey => itemkey
1135: , aname => 'ERROR_MSG1'
1136: , avalue => l_msg_data

Line 1159: resultout := wf_engine.eng_completed||':'||'F';

1155: p_item_key => itemkey,
1156: p_msg_count => l_msg_count,
1157: p_msg_data => l_msg_data);
1158:
1159: resultout := wf_engine.eng_completed||':'||'F';
1160: -- RAISE;
1161:
1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1163: THEN

Line 1175: wf_engine.SetItemAttrText

1171: -- itemkey,
1172: -- to_char(actid),
1173: -- funcmode);
1174:
1175: wf_engine.SetItemAttrText
1176: ( itemtype => itemtype
1177: , itemkey => itemkey
1178: , aname => 'ERROR_MSG1'
1179: , avalue => SQLCODE||SQLERRM

Line 1184: resultout := wf_engine.eng_completed||':'||'F';

1180: );
1181:
1182:
1183:
1184: resultout := wf_engine.eng_completed||':'||'F';
1185: --RAISE ;
1186: */
1187: WHEN OTHERS THEN
1188: If (l_savepoint) then

Line 1199: wf_engine.SetItemAttrText

1195: -- to_char(actid),
1196: -- funcmode);
1197: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
1198:
1199: wf_engine.SetItemAttrText
1200: ( itemtype => itemtype
1201: , itemkey => itemkey
1202: , aname => 'ERROR_MSG1'
1203: , avalue => SQLCODE||SQLERRM

Line 1213: resultout := wf_engine.eng_completed||':'||'F';

1209: p_msg_data => l_msg_data);
1210:
1211: End if;
1212:
1213: resultout := wf_engine.eng_completed||':'||'F';
1214: -- RAISE ;
1215:
1216: END Default_OU_Change;
1217:

Line 1268: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,

1264: --
1265: -- Initialize workflow item attributes
1266: --
1267:
1268: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1269: itemkey => itemkey,
1270: aname => 'CALLING_MODE' );
1271:
1272: /*

Line 1273: l_grade_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1269: itemkey => itemkey,
1270: aname => 'CALLING_MODE' );
1271:
1272: /*
1273: l_grade_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1274: itemkey => itemkey,
1275: aname => 'GRADE_ID_OLD' );
1276:
1277: l_grade_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1277: l_grade_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1273: l_grade_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1274: itemkey => itemkey,
1275: aname => 'GRADE_ID_OLD' );
1276:
1277: l_grade_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1278: itemkey => itemkey,
1279: aname => 'GRADE_ID_NEW' );
1280:
1281: */

Line 1282: l_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1278: itemkey => itemkey,
1279: aname => 'GRADE_ID_NEW' );
1280:
1281: */
1282: l_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => 'JOB_ID_OLD' );
1285:
1286: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1286: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1282: l_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => 'JOB_ID_OLD' );
1285:
1286: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1287: itemkey => itemkey,
1288: aname => 'JOB_ID_NEW' );
1289:
1290: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 1290: wf_engine.SetItemAttrText ( itemtype => itemtype,

1286: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1287: itemkey => itemkey,
1288: aname => 'JOB_ID_NEW' );
1289:
1290: wf_engine.SetItemAttrText ( itemtype => itemtype,
1291: itemkey => itemkey,
1292: aname => 'JOB_NAME',
1293: avalue => pa_hr_update_api.get_job_name(l_job_id_new));
1294:

Line 1296: wf_engine.SetItemAttrText ( itemtype => itemtype,

1292: aname => 'JOB_NAME',
1293: avalue => pa_hr_update_api.get_job_name(l_job_id_new));
1294:
1295: /*
1296: wf_engine.SetItemAttrText ( itemtype => itemtype,
1297: itemkey => itemkey,
1298: aname => 'GRADE_NAME',
1299: avalue => pa_hr_update_api.get_grade_name(l_grade_id_new));
1300: */

Line 1315: resultout := wf_engine.eng_completed||':'||'S';

1311:
1312:
1313: IF l_return_status = 'S' THEN
1314:
1315: resultout := wf_engine.eng_completed||':'||'S';
1316: ELSIF l_return_status = 'E' THEN
1317: l_savepoint := false;
1318: rollback to l_valid_grade_change ;
1319: set_nf_error_msg_attr(p_item_type => itemtype,

Line 1323: resultout := wf_engine.eng_completed||':'||'F';

1319: set_nf_error_msg_attr(p_item_type => itemtype,
1320: p_item_key => itemkey,
1321: p_msg_count => l_msg_count,
1322: p_msg_data => l_msg_data);
1323: resultout := wf_engine.eng_completed||':'||'F';
1324:
1325: ELSE
1326: l_savepoint := false;
1327: rollback to l_valid_grade_change ;

Line 1333: wf_engine.SetItemAttrText

1329: p_item_key => itemkey,
1330: p_msg_count => fnd_msg_pub.count_msg,
1331: p_msg_data => l_msg_data);
1332:
1333: wf_engine.SetItemAttrText
1334: ( itemtype => itemtype
1335: , itemkey => itemkey
1336: , aname => 'ERROR_MSG1'
1337: , avalue => l_msg_data

Line 1360: resultout := wf_engine.eng_completed||':'||'F';

1356: set_nf_error_msg_attr(p_item_type => itemtype,
1357: p_item_key => itemkey,
1358: p_msg_count => l_msg_count,
1359: p_msg_data => l_msg_data);
1360: resultout := wf_engine.eng_completed||':'||'F';
1361:
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1363: THEN
1364: If (l_savepoint) then

Line 1373: wf_engine.SetItemAttrText

1369: itemtype,
1370: itemkey,
1371: to_char(actid),
1372: funcmode);
1373: wf_engine.SetItemAttrText
1374: ( itemtype => itemtype
1375: , itemkey => itemkey
1376: , aname => 'ERROR_MSG1'
1377: , avalue => SQLERRM

Line 1379: resultout := wf_engine.eng_completed||':'||'F';

1375: , itemkey => itemkey
1376: , aname => 'ERROR_MSG1'
1377: , avalue => SQLERRM
1378: );
1379: resultout := wf_engine.eng_completed||':'||'F';
1380: */
1381: WHEN OTHERS THEN
1382: If (l_savepoint) then
1383: rollback to l_valid_grade_change ;

Line 1393: wf_engine.SetItemAttrText

1389: to_char(actid),
1390: funcmode);
1391: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
1392:
1393: wf_engine.SetItemAttrText
1394: ( itemtype => itemtype
1395: , itemkey => itemkey
1396: , aname => 'ERROR_MSG1'
1397: , avalue => SQLCODE||SQLERRM

Line 1407: resultout := wf_engine.eng_completed||':'||'F';

1403: p_msg_data => l_msg_data);
1404:
1405: End if;
1406:
1407: resultout := wf_engine.eng_completed||':'||'F';
1408:
1409: END Valid_Grade_Change;
1410:
1411: -- This procedure will not get called anymore because the triggers

Line 1451: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,

1447: --
1448: -- Initialize workflow item attributes
1449: --
1450:
1451: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1452: itemkey => itemkey,
1453: aname => 'CALLING_MODE' );
1454:
1455: /*

Line 1456: l_grade_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1452: itemkey => itemkey,
1453: aname => 'CALLING_MODE' );
1454:
1455: /*
1456: l_grade_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1457: itemkey => itemkey,
1458: aname => 'GRADE_ID_NEW' );
1459:
1460: l_job_level_old := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1460: l_job_level_old := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1456: l_grade_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1457: itemkey => itemkey,
1458: aname => 'GRADE_ID_NEW' );
1459:
1460: l_job_level_old := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1461: itemkey => itemkey,
1462: aname => 'SEQUENCE_OLD' );
1463:
1464: l_job_level_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1464: l_job_level_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1460: l_job_level_old := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1461: itemkey => itemkey,
1462: aname => 'SEQUENCE_OLD' );
1463:
1464: l_job_level_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1465: itemkey => itemkey,
1466: aname => 'SEQUENCE_NEW' );
1467:
1468: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 1468: wf_engine.SetItemAttrText ( itemtype => itemtype,

1464: l_job_level_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1465: itemkey => itemkey,
1466: aname => 'SEQUENCE_NEW' );
1467:
1468: wf_engine.SetItemAttrText ( itemtype => itemtype,
1469: itemkey => itemkey,
1470: aname => 'GRADE_NAME',
1471: avalue => pa_hr_update_api.get_grade_name(l_grade_id));
1472: */

Line 1486: resultout := wf_engine.eng_completed||':'||'S';

1482: ,x_msg_data => l_msg_data);
1483:
1484: IF l_return_status = 'S' THEN
1485:
1486: resultout := wf_engine.eng_completed||':'||'S';
1487: ELSIF l_return_status = 'E' THEN
1488: l_savepoint := false;
1489: rollback to l_job_level_change ;
1490: set_nf_error_msg_attr(p_item_type => itemtype,

Line 1494: resultout := wf_engine.eng_completed||':'||'F';

1490: set_nf_error_msg_attr(p_item_type => itemtype,
1491: p_item_key => itemkey,
1492: p_msg_count => l_msg_count,
1493: p_msg_data => l_msg_data);
1494: resultout := wf_engine.eng_completed||':'||'F';
1495:
1496: ELSE
1497: l_savepoint := false;
1498: rollback to l_job_level_change ;

Line 1504: wf_engine.SetItemAttrText

1500: p_item_key => itemkey,
1501: p_msg_count => fnd_msg_pub.count_msg,
1502: p_msg_data => l_msg_data);
1503:
1504: wf_engine.SetItemAttrText
1505: ( itemtype => itemtype
1506: , itemkey => itemkey
1507: , aname => 'ERROR_MSG1'
1508: , avalue => l_msg_data

Line 1532: resultout := wf_engine.eng_completed||':'||'F';

1528: p_item_key => itemkey,
1529: p_msg_count => l_msg_count,
1530: p_msg_data => l_msg_data);
1531:
1532: resultout := wf_engine.eng_completed||':'||'F';
1533:
1534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1535: THEN
1536: If (l_savepoint) then

Line 1546: wf_engine.SetItemAttrText

1542: itemkey,
1543: to_char(actid),
1544: funcmode);
1545:
1546: wf_engine.SetItemAttrText
1547: ( itemtype => itemtype
1548: , itemkey => itemkey
1549: , aname => 'ERROR_MSG1'
1550: , avalue => SQLERRM

Line 1553: resultout := wf_engine.eng_completed||':'||'F';

1549: , aname => 'ERROR_MSG1'
1550: , avalue => SQLERRM
1551: );
1552:
1553: resultout := wf_engine.eng_completed||':'||'F';
1554: */
1555: WHEN OTHERS THEN
1556: If (l_savepoint) then
1557: rollback to l_job_level_change ;

Line 1568: wf_engine.SetItemAttrText

1564: funcmode);
1565:
1566: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
1567:
1568: wf_engine.SetItemAttrText
1569: ( itemtype => itemtype
1570: , itemkey => itemkey
1571: , aname => 'ERROR_MSG1'
1572: , avalue => SQLCODE||SQLERRM

Line 1582: resultout := wf_engine.eng_completed||':'||'F';

1578: p_msg_data => l_msg_data);
1579:
1580: End if;
1581:
1582: resultout := wf_engine.eng_completed||':'||'F';
1583:
1584: END Job_Level_Change;
1585:
1586: PROCEDURE Address_Change

Line 1633: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,

1629: --
1630: -- Initialize workflow item attributes
1631: --
1632:
1633: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1634: itemkey => itemkey,
1635: aname => 'CALLING_MODE' );
1636:
1637: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1637: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1633: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1634: itemkey => itemkey,
1635: aname => 'CALLING_MODE' );
1636:
1637: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1638: itemkey => itemkey,
1639: aname => 'PERSON_ID' );
1640:
1641: l_country_old := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 1641: l_country_old := wf_engine.GetItemAttrText( itemtype => itemtype,

1637: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1638: itemkey => itemkey,
1639: aname => 'PERSON_ID' );
1640:
1641: l_country_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1642: itemkey => itemkey,
1643: aname => 'COUNTRY_OLD' );
1644:
1645: l_country_new := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1645: l_country_new := wf_engine.GetItemAttrText(itemtype => itemtype,

1641: l_country_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1642: itemkey => itemkey,
1643: aname => 'COUNTRY_OLD' );
1644:
1645: l_country_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1646: itemkey => itemkey,
1647: aname => 'COUNTRY_NEW' );
1648:
1649: l_city_old := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 1649: l_city_old := wf_engine.GetItemAttrText( itemtype => itemtype,

1645: l_country_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1646: itemkey => itemkey,
1647: aname => 'COUNTRY_NEW' );
1648:
1649: l_city_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1650: itemkey => itemkey,
1651: aname => 'CITY_OLD' );
1652:
1653: l_city_new := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1653: l_city_new := wf_engine.GetItemAttrText(itemtype => itemtype,

1649: l_city_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1650: itemkey => itemkey,
1651: aname => 'CITY_OLD' );
1652:
1653: l_city_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1654: itemkey => itemkey,
1655: aname => 'CITY_NEW' );
1656:
1657: l_region2_old := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 1657: l_region2_old := wf_engine.GetItemAttrText( itemtype => itemtype,

1653: l_city_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1654: itemkey => itemkey,
1655: aname => 'CITY_NEW' );
1656:
1657: l_region2_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1658: itemkey => itemkey,
1659: aname => 'REGION2_OLD' );
1660:
1661: l_region2_new := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1661: l_region2_new := wf_engine.GetItemAttrText(itemtype => itemtype,

1657: l_region2_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1658: itemkey => itemkey,
1659: aname => 'REGION2_OLD' );
1660:
1661: l_region2_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1662: itemkey => itemkey,
1663: aname => 'REGION2_NEW' );
1664:
1665: l_date_from_old := wf_engine.GetItemAttrDate(itemtype => itemtype,

Line 1665: l_date_from_old := wf_engine.GetItemAttrDate(itemtype => itemtype,

1661: l_region2_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1662: itemkey => itemkey,
1663: aname => 'REGION2_NEW' );
1664:
1665: l_date_from_old := wf_engine.GetItemAttrDate(itemtype => itemtype,
1666: itemkey => itemkey,
1667: aname => 'START_DATE_OLD');
1668:
1669: l_date_from_new := wf_engine.GetItemAttrDate(itemtype => itemtype,

Line 1669: l_date_from_new := wf_engine.GetItemAttrDate(itemtype => itemtype,

1665: l_date_from_old := wf_engine.GetItemAttrDate(itemtype => itemtype,
1666: itemkey => itemkey,
1667: aname => 'START_DATE_OLD');
1668:
1669: l_date_from_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
1670: itemkey => itemkey,
1671: aname => 'START_DATE_NEW');
1672:
1673: l_date_to_old := wf_engine.GetItemAttrDate(itemtype => itemtype,

Line 1673: l_date_to_old := wf_engine.GetItemAttrDate(itemtype => itemtype,

1669: l_date_from_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
1670: itemkey => itemkey,
1671: aname => 'START_DATE_NEW');
1672:
1673: l_date_to_old := wf_engine.GetItemAttrDate(itemtype => itemtype,
1674: itemkey => itemkey,
1675: aname => 'END_DATE_OLD');
1676:
1677: l_date_to_new := wf_engine.GetItemAttrDate(itemtype => itemtype,

Line 1677: l_date_to_new := wf_engine.GetItemAttrDate(itemtype => itemtype,

1673: l_date_to_old := wf_engine.GetItemAttrDate(itemtype => itemtype,
1674: itemkey => itemkey,
1675: aname => 'END_DATE_OLD');
1676:
1677: l_date_to_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
1678: itemkey => itemkey,
1679: aname => 'END_DATE_NEW');
1680:
1681: l_addr_prim_flag_old := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1681: l_addr_prim_flag_old := wf_engine.GetItemAttrText(itemtype => itemtype,

1677: l_date_to_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
1678: itemkey => itemkey,
1679: aname => 'END_DATE_NEW');
1680:
1681: l_addr_prim_flag_old := wf_engine.GetItemAttrText(itemtype => itemtype,
1682: itemkey => itemkey,
1683: aname => 'PRIMARY_FLAG_OLD');
1684:
1685: l_addr_prim_flag_new := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1685: l_addr_prim_flag_new := wf_engine.GetItemAttrText(itemtype => itemtype,

1681: l_addr_prim_flag_old := wf_engine.GetItemAttrText(itemtype => itemtype,
1682: itemkey => itemkey,
1683: aname => 'PRIMARY_FLAG_OLD');
1684:
1685: l_addr_prim_flag_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1686: itemkey => itemkey,
1687: aname => 'PRIMARY_FLAG_NEW');
1688:
1689: -- Changed for bug 4354854 - performance improvement

Line 1698: resultout := wf_engine.eng_completed||':'||'F';

1694: IF l_return_status = 'E' THEN
1695: --
1696: l_savepoint := false;
1697: rollback to l_address_change ;
1698: resultout := wf_engine.eng_completed||':'||'F';
1699: END IF;
1700:
1701: wf_engine.SetItemAttrText(itemtype => itemtype,
1702: itemkey => itemkey,

Line 1701: wf_engine.SetItemAttrText(itemtype => itemtype,

1697: rollback to l_address_change ;
1698: resultout := wf_engine.eng_completed||':'||'F';
1699: END IF;
1700:
1701: wf_engine.SetItemAttrText(itemtype => itemtype,
1702: itemkey => itemkey,
1703: aname => 'FULL_NAME_NEW',
1704: avalue => l_person_name);
1705:

Line 1733: resultout := wf_engine.eng_completed||':'||'S';

1729: IF l_return_status = 'S' THEN
1730:
1731: --dbms_output.put_line('Address Update Success');
1732:
1733: resultout := wf_engine.eng_completed||':'||'S';
1734: ELSIF l_return_status = 'E' THEN
1735: l_savepoint := false;
1736: rollback to l_address_change ;
1737: set_nf_error_msg_attr(p_item_type => itemtype,

Line 1741: resultout := wf_engine.eng_completed||':'||'F';

1737: set_nf_error_msg_attr(p_item_type => itemtype,
1738: p_item_key => itemkey,
1739: p_msg_count => l_msg_count,
1740: p_msg_data => l_msg_data);
1741: resultout := wf_engine.eng_completed||':'||'F';
1742:
1743: ELSE
1744: l_savepoint := false;
1745: rollback to l_address_change ;

Line 1751: wf_engine.SetItemAttrText

1747: p_item_key => itemkey,
1748: p_msg_count => fnd_msg_pub.count_msg,
1749: p_msg_data => l_msg_data);
1750:
1751: wf_engine.SetItemAttrText
1752: ( itemtype => itemtype
1753: , itemkey => itemkey
1754: , aname => 'ERROR_MSG1'
1755: , avalue => l_msg_data

Line 1781: resultout := wf_engine.eng_completed||':'||'F';

1777: p_item_key => itemkey,
1778: p_msg_count => l_msg_count,
1779: p_msg_data => l_msg_data);
1780:
1781: resultout := wf_engine.eng_completed||':'||'F';
1782:
1783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1784: THEN
1785: If (l_savepoint) then

Line 1795: wf_engine.SetItemAttrText

1791: itemkey,
1792: to_char(actid),
1793: funcmode);
1794:
1795: wf_engine.SetItemAttrText
1796: ( itemtype => itemtype
1797: , itemkey => itemkey
1798: , aname => 'ERROR_MSG1'
1799: , avalue => SQLCODE||SQLERRM

Line 1802: resultout := wf_engine.eng_completed||':'||'F';

1798: , aname => 'ERROR_MSG1'
1799: , avalue => SQLCODE||SQLERRM
1800: );
1801:
1802: resultout := wf_engine.eng_completed||':'||'F';
1803: */
1804: WHEN OTHERS THEN
1805: If (l_savepoint) then
1806: rollback to l_address_change ;

Line 1818: wf_engine.SetItemAttrText

1814: funcmode);
1815:
1816: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
1817:
1818: wf_engine.SetItemAttrText
1819: ( itemtype => itemtype
1820: , itemkey => itemkey
1821: , aname => 'ERROR_MSG1'
1822: , avalue => SQLCODE||SQLERRM

Line 1832: resultout := wf_engine.eng_completed||':'||'F';

1828: p_msg_data => l_msg_data);
1829:
1830: End if;
1831:
1832: resultout := wf_engine.eng_completed||':'||'F';
1833:
1834: END Address_Change;
1835:
1836: PROCEDURE Project_Organization_Change

Line 1876: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,

1872: --
1873: -- Initialize workflow item attributes
1874: --
1875:
1876: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1877: itemkey => itemkey,
1878: aname => 'CALLING_MODE' );
1879:
1880:

Line 1882: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1878: aname => 'CALLING_MODE' );
1879:
1880:
1881:
1882: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1883: itemkey => itemkey,
1884: aname => 'ORG_ID_NEW' );
1885:
1886: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1886: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,

1882: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1883: itemkey => itemkey,
1884: aname => 'ORG_ID_NEW' );
1885:
1886: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1887: itemkey => itemkey,
1888: aname => 'ORG_INFO1_NEW' );
1889:
1890: l_inactive_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,

Line 1890: l_inactive_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,

1886: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1887: itemkey => itemkey,
1888: aname => 'ORG_INFO1_NEW' );
1889:
1890: l_inactive_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
1891: itemkey => itemkey,
1892: aname => 'INACTIVE_DATE_OLD' );
1893:
1894: l_inactive_date_new := wf_engine.GetItemAttrDate( itemtype => itemtype,

Line 1894: l_inactive_date_new := wf_engine.GetItemAttrDate( itemtype => itemtype,

1890: l_inactive_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
1891: itemkey => itemkey,
1892: aname => 'INACTIVE_DATE_OLD' );
1893:
1894: l_inactive_date_new := wf_engine.GetItemAttrDate( itemtype => itemtype,
1895: itemkey => itemkey,
1896: aname => 'INACTIVE_DATE_NEW' );
1897:
1898: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 1898: wf_engine.SetItemAttrText ( itemtype => itemtype,

1894: l_inactive_date_new := wf_engine.GetItemAttrDate( itemtype => itemtype,
1895: itemkey => itemkey,
1896: aname => 'INACTIVE_DATE_NEW' );
1897:
1898: wf_engine.SetItemAttrText ( itemtype => itemtype,
1899: itemkey => itemkey,
1900: aname => 'ORGANIZATION_NAME',
1901: avalue => pa_hr_update_api.get_org_name(l_org_id));
1902:

Line 1951: resultout := wf_engine.eng_completed||':'||'S';

1947:
1948:
1949: IF l_return_status = 'S' THEN
1950:
1951: resultout := wf_engine.eng_completed||':'||'S';
1952: ELSIF l_return_status = 'E' THEN
1953: l_savepoint := false;
1954: rollback to l_project_org_change ;
1955: set_nf_error_msg_attr(p_item_type => itemtype,

Line 1959: resultout := wf_engine.eng_completed||':'||'F';

1955: set_nf_error_msg_attr(p_item_type => itemtype,
1956: p_item_key => itemkey,
1957: p_msg_count => l_msg_count,
1958: p_msg_data => l_msg_data);
1959: resultout := wf_engine.eng_completed||':'||'F';
1960:
1961: ELSE
1962: l_savepoint := false;
1963: rollback to l_project_org_change ;

Line 1969: wf_engine.SetItemAttrText

1965: p_item_key => itemkey,
1966: p_msg_count => fnd_msg_pub.count_msg,
1967: p_msg_data => l_msg_data);
1968:
1969: wf_engine.SetItemAttrText
1970: ( itemtype => itemtype
1971: , itemkey => itemkey
1972: , aname => 'ERROR_MSG1'
1973: , avalue => l_msg_data

Line 1997: resultout := wf_engine.eng_completed||':'||'F';

1993: p_item_key => itemkey,
1994: p_msg_count => l_msg_count,
1995: p_msg_data => l_msg_data);
1996:
1997: resultout := wf_engine.eng_completed||':'||'F';
1998: --RAISE;
1999:
2000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2001: THEN

Line 2012: wf_engine.SetItemAttrText

2008: itemkey,
2009: to_char(actid),
2010: funcmode);
2011:
2012: wf_engine.SetItemAttrText
2013: ( itemtype => itemtype
2014: , itemkey => itemkey
2015: , aname => 'ERROR_MSG1'
2016: , avalue => SQLERRM

Line 2019: resultout := wf_engine.eng_completed||':'||'F';

2015: , aname => 'ERROR_MSG1'
2016: , avalue => SQLERRM
2017: );
2018:
2019: resultout := wf_engine.eng_completed||':'||'F';
2020: --RAISE;
2021: */
2022: WHEN OTHERS THEN
2023:

Line 2037: wf_engine.SetItemAttrText

2033: funcmode);
2034:
2035: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
2036:
2037: wf_engine.SetItemAttrText
2038: ( itemtype => itemtype
2039: , itemkey => itemkey
2040: , aname => 'ERROR_MSG1'
2041: , avalue => SQLCODE||SQLERRM

Line 2051: resultout := wf_engine.eng_completed||':'||'F';

2047: p_msg_data => l_msg_data);
2048:
2049: End if;
2050:
2051: resultout := wf_engine.eng_completed||':'||'F';
2052: --RAISE;
2053:
2054: END Project_Organization_Change;
2055:

Line 2096: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,

2092: --
2093: -- Initialize workflow item attributes
2094: --
2095:
2096: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
2097: itemkey => itemkey,
2098: aname => 'CALLING_MODE' );
2099:
2100: l_from_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 2100: l_from_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2096: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
2097: itemkey => itemkey,
2098: aname => 'CALLING_MODE' );
2099:
2100: l_from_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2101: itemkey => itemkey,
2102: aname => 'FROM_JOB_ID_OLD' );
2103:
2104: l_from_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 2104: l_from_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2100: l_from_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2101: itemkey => itemkey,
2102: aname => 'FROM_JOB_ID_OLD' );
2103:
2104: l_from_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2105: itemkey => itemkey,
2106: aname => 'FROM_JOB_ID_NEW' );
2107:
2108: l_to_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 2108: l_to_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2104: l_from_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2105: itemkey => itemkey,
2106: aname => 'FROM_JOB_ID_NEW' );
2107:
2108: l_to_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2109: itemkey => itemkey,
2110: aname => 'TO_JOB_ID_OLD' );
2111:
2112: l_to_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 2112: l_to_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2108: l_to_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2109: itemkey => itemkey,
2110: aname => 'TO_JOB_ID_OLD' );
2111:
2112: l_to_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2113: itemkey => itemkey,
2114: aname => 'TO_JOB_ID_NEW' );
2115:
2116: l_from_job_group_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 2116: l_from_job_group_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2112: l_to_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2113: itemkey => itemkey,
2114: aname => 'TO_JOB_ID_NEW' );
2115:
2116: l_from_job_group_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2117: itemkey => itemkey,
2118: aname => 'FROM_JOB_GROUP_ID' );
2119:
2120: l_to_job_group_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 2120: l_to_job_group_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2116: l_from_job_group_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2117: itemkey => itemkey,
2118: aname => 'FROM_JOB_GROUP_ID' );
2119:
2120: l_to_job_group_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2121: itemkey => itemkey,
2122: aname => 'TO_JOB_GROUP_ID' );
2123:
2124:

Line 2125: wf_engine.SetItemAttrText ( itemtype => itemtype,

2121: itemkey => itemkey,
2122: aname => 'TO_JOB_GROUP_ID' );
2123:
2124:
2125: wf_engine.SetItemAttrText ( itemtype => itemtype,
2126: itemkey => itemkey,
2127: aname => 'JOB_NAME',
2128: avalue => pa_hr_update_api.get_job_name(l_from_job_id_new));
2129:

Line 2130: wf_engine.SetItemAttrText ( itemtype => itemtype,

2126: itemkey => itemkey,
2127: aname => 'JOB_NAME',
2128: avalue => pa_hr_update_api.get_job_name(l_from_job_id_new));
2129:
2130: wf_engine.SetItemAttrText ( itemtype => itemtype,
2131: itemkey => itemkey,
2132: aname => 'TO_JOB_NAME',
2133: avalue => pa_hr_update_api.get_job_name(l_to_job_id_new));
2134:

Line 2151: resultout := wf_engine.eng_completed||':'||'S';

2147:
2148:
2149: IF l_return_status = 'S' THEN
2150:
2151: resultout := wf_engine.eng_completed||':'||'S';
2152: ELSIF l_return_status = 'E' THEN
2153: l_savepoint := false;
2154: rollback to l_job_rel_change ;
2155: set_nf_error_msg_attr(p_item_type => itemtype,

Line 2159: resultout := wf_engine.eng_completed||':'||'F';

2155: set_nf_error_msg_attr(p_item_type => itemtype,
2156: p_item_key => itemkey,
2157: p_msg_count => l_msg_count,
2158: p_msg_data => l_msg_data);
2159: resultout := wf_engine.eng_completed||':'||'F';
2160:
2161: ELSE
2162: l_savepoint := false;
2163: rollback to l_job_rel_change ;

Line 2169: wf_engine.SetItemAttrText

2165: p_item_key => itemkey,
2166: p_msg_count => fnd_msg_pub.count_msg,
2167: p_msg_data => l_msg_data);
2168:
2169: wf_engine.SetItemAttrText
2170: ( itemtype => itemtype
2171: , itemkey => itemkey
2172: , aname => 'ERROR_MSG1'
2173: , avalue => l_msg_data

Line 2197: resultout := wf_engine.eng_completed||':'||'F';

2193: p_item_key => itemkey,
2194: p_msg_count => l_msg_count,
2195: p_msg_data => l_msg_data);
2196:
2197: resultout := wf_engine.eng_completed||':'||'F';
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2200: THEN
2201: If (l_savepoint) then

Line 2211: wf_engine.SetItemAttrText

2207: itemkey,
2208: to_char(actid),
2209: funcmode);
2210:
2211: wf_engine.SetItemAttrText
2212: ( itemtype => itemtype
2213: , itemkey => itemkey
2214: , aname => 'ERROR_MSG1'
2215: , avalue => SQLCODE||SQLERRM

Line 2218: resultout := wf_engine.eng_completed||':'||'F';

2214: , aname => 'ERROR_MSG1'
2215: , avalue => SQLCODE||SQLERRM
2216: );
2217:
2218: resultout := wf_engine.eng_completed||':'||'F';
2219: */
2220: WHEN OTHERS THEN
2221: If (l_savepoint) then
2222: rollback to l_job_rel_change ;

Line 2234: wf_engine.SetItemAttrText

2230: funcmode);
2231:
2232: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
2233:
2234: wf_engine.SetItemAttrText
2235: ( itemtype => itemtype
2236: , itemkey => itemkey
2237: , aname => 'ERROR_MSG1'
2238: , avalue => SQLCODE||SQLERRM

Line 2248: resultout := wf_engine.eng_completed||':'||'F';

2244: p_msg_data => l_msg_data);
2245:
2246: End if;
2247:
2248: resultout := wf_engine.eng_completed||':'||'F';
2249:
2250: END Job_Rel_Change;
2251:
2252: PROCEDURE assignment_change

Line 2309: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,

2305: --
2306:
2307: l_final_return_status := FND_API.G_RET_STS_SUCCESS ;
2308:
2309: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
2310: itemkey => itemkey,
2311: aname => 'CALLING_MODE' );
2312:
2313: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 2313: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2309: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
2310: itemkey => itemkey,
2311: aname => 'CALLING_MODE' );
2312:
2313: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2314: itemkey => itemkey,
2315: aname => 'PERSON_ID' );
2316: l_start_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2317: itemkey => itemkey,

Line 2316: l_start_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,

2312:
2313: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2314: itemkey => itemkey,
2315: aname => 'PERSON_ID' );
2316: l_start_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2317: itemkey => itemkey,
2318: aname => 'START_DATE_OLD' );
2319: l_start_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
2320: itemkey => itemkey,

Line 2319: l_start_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,

2315: aname => 'PERSON_ID' );
2316: l_start_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2317: itemkey => itemkey,
2318: aname => 'START_DATE_OLD' );
2319: l_start_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
2320: itemkey => itemkey,
2321: aname => 'START_DATE_NEW' );
2322: l_end_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2323: itemkey => itemkey,

Line 2322: l_end_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,

2318: aname => 'START_DATE_OLD' );
2319: l_start_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
2320: itemkey => itemkey,
2321: aname => 'START_DATE_NEW' );
2322: l_end_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2323: itemkey => itemkey,
2324: aname => 'END_DATE_OLD' );
2325: l_end_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
2326: itemkey => itemkey,

Line 2325: l_end_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,

2321: aname => 'START_DATE_NEW' );
2322: l_end_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2323: itemkey => itemkey,
2324: aname => 'END_DATE_OLD' );
2325: l_end_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
2326: itemkey => itemkey,
2327: aname => 'END_DATE_NEW' );
2328: l_org_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2329: itemkey => itemkey,

Line 2328: l_org_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2324: aname => 'END_DATE_OLD' );
2325: l_end_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
2326: itemkey => itemkey,
2327: aname => 'END_DATE_NEW' );
2328: l_org_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2329: itemkey => itemkey,
2330: aname => 'ORG_ID_OLD' );
2331: l_org_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2332: itemkey => itemkey,

Line 2331: l_org_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2327: aname => 'END_DATE_NEW' );
2328: l_org_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2329: itemkey => itemkey,
2330: aname => 'ORG_ID_OLD' );
2331: l_org_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2332: itemkey => itemkey,
2333: aname => 'ORG_ID_NEW' );
2334: l_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2335: itemkey => itemkey,

Line 2334: l_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2330: aname => 'ORG_ID_OLD' );
2331: l_org_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2332: itemkey => itemkey,
2333: aname => 'ORG_ID_NEW' );
2334: l_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2335: itemkey => itemkey,
2336: aname => 'JOB_ID_OLD' );
2337: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2338: itemkey => itemkey,

Line 2337: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2333: aname => 'ORG_ID_NEW' );
2334: l_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2335: itemkey => itemkey,
2336: aname => 'JOB_ID_OLD' );
2337: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2338: itemkey => itemkey,
2339: aname => 'JOB_ID_NEW' );
2340: l_supervisor_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2341: itemkey => itemkey,

Line 2340: l_supervisor_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2336: aname => 'JOB_ID_OLD' );
2337: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2338: itemkey => itemkey,
2339: aname => 'JOB_ID_NEW' );
2340: l_supervisor_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2341: itemkey => itemkey,
2342: aname => 'SUPERVISOR_OLD' );
2343: l_supervisor_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2344: itemkey => itemkey,

Line 2343: l_supervisor_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2339: aname => 'JOB_ID_NEW' );
2340: l_supervisor_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2341: itemkey => itemkey,
2342: aname => 'SUPERVISOR_OLD' );
2343: l_supervisor_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2344: itemkey => itemkey,
2345: aname => 'SUPERVISOR_NEW' );
2346: l_primary_flag_old := wf_engine.GetItemAttrText( itemtype => itemtype,
2347: itemkey => itemkey,

Line 2346: l_primary_flag_old := wf_engine.GetItemAttrText( itemtype => itemtype,

2342: aname => 'SUPERVISOR_OLD' );
2343: l_supervisor_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2344: itemkey => itemkey,
2345: aname => 'SUPERVISOR_NEW' );
2346: l_primary_flag_old := wf_engine.GetItemAttrText( itemtype => itemtype,
2347: itemkey => itemkey,
2348: aname => 'PRIMARY_FLAG_OLD' );
2349: l_primary_flag_new := wf_engine.GetItemAttrText(itemtype => itemtype,
2350: itemkey => itemkey,

Line 2349: l_primary_flag_new := wf_engine.GetItemAttrText(itemtype => itemtype,

2345: aname => 'SUPERVISOR_NEW' );
2346: l_primary_flag_old := wf_engine.GetItemAttrText( itemtype => itemtype,
2347: itemkey => itemkey,
2348: aname => 'PRIMARY_FLAG_OLD' );
2349: l_primary_flag_new := wf_engine.GetItemAttrText(itemtype => itemtype,
2350: itemkey => itemkey,
2351: aname => 'PRIMARY_FLAG_NEW' );
2352:
2353:

Line 2363: resultout := wf_engine.eng_completed||':'||'F';

2359: IF l_return_status = 'E' THEN
2360: --
2361: l_savepoint := false;
2362: rollback to l_address_change ;
2363: resultout := wf_engine.eng_completed||':'||'F';
2364: END IF;
2365:
2366: wf_engine.SetItemAttrText (itemtype => itemtype,
2367: itemkey => itemkey,

Line 2366: wf_engine.SetItemAttrText (itemtype => itemtype,

2362: rollback to l_address_change ;
2363: resultout := wf_engine.eng_completed||':'||'F';
2364: END IF;
2365:
2366: wf_engine.SetItemAttrText (itemtype => itemtype,
2367: itemkey => itemkey,
2368: aname => 'FULL_NAME_NEW',
2369: avalue => l_person_name);
2370:

Line 2777: resultout := wf_engine.eng_completed||':'||'S';

2773:
2774:
2775: IF l_final_return_status = 'S' THEN
2776:
2777: resultout := wf_engine.eng_completed||':'||'S';
2778: ELSIF l_return_status = 'E' THEN
2779: l_savepoint := false;
2780: rollback to l_assignment_change ;
2781: set_nf_error_msg_attr(p_item_type => itemtype,

Line 2785: resultout := wf_engine.eng_completed||':'||'F';

2781: set_nf_error_msg_attr(p_item_type => itemtype,
2782: p_item_key => itemkey,
2783: p_msg_count => l_msg_count,
2784: p_msg_data => l_msg_data);
2785: resultout := wf_engine.eng_completed||':'||'F';
2786:
2787: ELSE
2788: l_savepoint := false;
2789: rollback to l_assignment_change ;

Line 2795: wf_engine.SetItemAttrText

2791: p_item_key => itemkey,
2792: p_msg_count => fnd_msg_pub.count_msg,
2793: p_msg_data => l_msg_data);
2794:
2795: wf_engine.SetItemAttrText
2796: ( itemtype => itemtype
2797: , itemkey => itemkey
2798: , aname => 'ERROR_MSG1'
2799: , avalue => l_msg_data

Line 2802: resultout := wf_engine.eng_completed||':'||'F';

2798: , aname => 'ERROR_MSG1'
2799: , avalue => l_msg_data
2800: );
2801:
2802: resultout := wf_engine.eng_completed||':'||'F';
2803: END IF;
2804:
2805: EXCEPTION
2806: WHEN FND_API.G_EXC_ERROR THEN

Line 2820: wf_engine.SetItemAttrText

2816: funcmode);
2817:
2818: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
2819:
2820: wf_engine.SetItemAttrText
2821: ( itemtype => itemtype
2822: , itemkey => itemkey
2823: , aname => 'ERROR_MSG1'
2824: , avalue => SQLCODE||SQLERRM

Line 2834: resultout := wf_engine.eng_completed||':'||'F';

2830: p_msg_data => l_msg_data);
2831:
2832: End if;
2833:
2834: resultout := wf_engine.eng_completed||':'||'F';
2835: --RAISE;
2836:
2837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2838: If (l_savepoint) then

Line 2850: wf_engine.SetItemAttrText

2846: to_char(actid),
2847: funcmode);
2848: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
2849:
2850: wf_engine.SetItemAttrText
2851: ( itemtype => itemtype
2852: , itemkey => itemkey
2853: , aname => 'ERROR_MSG1'
2854: , avalue => SQLCODE||SQLERRM

Line 2864: resultout := wf_engine.eng_completed||':'||'U';

2860: p_msg_data => l_msg_data);
2861:
2862: End if;
2863:
2864: resultout := wf_engine.eng_completed||':'||'U';
2865: --RAISE;
2866:
2867: WHEN OTHERS THEN
2868: If (l_savepoint) then

Line 2880: wf_engine.SetItemAttrText

2876: funcmode);
2877: */
2878: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
2879:
2880: wf_engine.SetItemAttrText
2881: ( itemtype => itemtype
2882: , itemkey => itemkey
2883: , aname => 'ERROR_MSG1'
2884: , avalue => SQLCODE||SQLERRM

Line 2894: resultout := wf_engine.eng_completed||':'||'U';

2890: p_msg_data => l_msg_data);
2891:
2892: End if;
2893:
2894: resultout := wf_engine.eng_completed||':'||'U';
2895: --RAISE;
2896:
2897: END assignment_change;
2898:

Line 2913: wf_engine.SetItemAttrText

2909: IF nvl(p_msg_count,0) = 0 and p_msg_data is NULL THEN
2910: RETURN;
2911: Elsif nvl(p_msg_count,0) = 0 and p_msg_data is NOT NULL then
2912: l_data := FND_MESSAGE.get_string('PA',p_msg_data);
2913: wf_engine.SetItemAttrText
2914: ( itemtype => p_item_type
2915: , itemkey => p_item_key
2916: , aname => 'ERROR_MSG1'
2917: , avalue => l_data

Line 2937: wf_engine.SetItemAttrText

2933: If p_msg_count = 1 and p_msg_data is not NULL then
2934: l_data := FND_MESSAGE.get_string('PA',p_msg_data);
2935: End if;
2936:
2937: wf_engine.SetItemAttrText
2938: ( itemtype => p_item_type
2939: , itemkey => p_item_key
2940: , aname => 'ERROR_MSG1'
2941: , avalue => l_data

Line 2968: wf_engine.SetItemAttrText

2964: l_data := FND_MESSAGE.get_string('PA',p_msg_data);
2965: end if;
2966:
2967: l_item_attr_name := 'ERROR_MSG'||i;
2968: wf_engine.SetItemAttrText
2969: ( itemtype => p_item_type
2970: , itemkey => p_item_key
2971: , aname => l_item_attr_name
2972: , avalue => l_data

Line 3027: l_save_thresh := wf_engine.threshold ;

3023: -- Since this workflow needs to be executed in Non deferred mode,
3024: -- we need to change the threshold. So we save the current threshold which
3025: -- will be used later on to change it back to the current threshold.
3026: --
3027: l_save_thresh := wf_engine.threshold ;
3028:
3029: --
3030: -- Set the threshold to 50 so that the process will not be deferred
3031: --

Line 3032: wf_engine.threshold := 50 ;

3028:
3029: --
3030: -- Set the threshold to 50 so that the process will not be deferred
3031: --
3032: wf_engine.threshold := 50 ;
3033:
3034:
3035: -- Create the appropriate process
3036: --

Line 3037: wf_engine.CreateProcess( ItemType => l_item_type,

3033:
3034:
3035: -- Create the appropriate process
3036: --
3037: wf_engine.CreateProcess( ItemType => l_item_type,
3038: ItemKey => l_item_key,
3039: process => 'TIMEOUT_TERMINATION_PROCESS' );
3040:
3041:

Line 3045: wf_engine.SetItemAttrText(itemtype => l_item_type,

3041:
3042:
3043: -- Initialize workflow item attributes with the parameter values
3044: --
3045: wf_engine.SetItemAttrText(itemtype => l_item_type,
3046: itemkey => l_item_key,
3047: aname => 'PROJECT_RESOURCE_ADMINISTRATOR',
3048: avalue => 'PASYSADMIN');
3049:

Line 3050: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

3046: itemkey => l_item_key,
3047: aname => 'PROJECT_RESOURCE_ADMINISTRATOR',
3048: avalue => 'PASYSADMIN');
3049:
3050: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
3051: itemkey => l_item_key,
3052: aname => 'PERSON_ID',
3053: avalue => p_person_id);
3054:

Line 3055: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

3051: itemkey => l_item_key,
3052: aname => 'PERSON_ID',
3053: avalue => p_person_id);
3054:
3055: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
3056: itemkey => l_item_key,
3057: aname => 'WAIT_DAYS',
3058: avalue => p_wait_days);
3059:

Line 3068: wf_engine.SetItemAttrText (itemtype => l_item_type,

3064:
3065:
3066: IF l_return_status = 'S' THEN
3067: --Set the wf name attribute for display of name , if any error occurs
3068: wf_engine.SetItemAttrText (itemtype => l_item_type,
3069: itemkey => l_item_key,
3070: aname => 'FULL_NAME_NEW',
3071: avalue => l_person_name);
3072:

Line 3079: WF_ENGINE.StartProcess( itemtype => l_item_type,

3075:
3076:
3077: -- Starting the work flow process and calling work flow api internaly
3078: --
3079: WF_ENGINE.StartProcess( itemtype => l_item_type,
3080: itemkey => l_item_key);
3081:
3082: -- Insert to PA tables wf process information.
3083: -- This is required for displaying notifications on PA pages.

Line 3107: wf_engine.threshold := l_save_thresh;

3103:
3104:
3105:
3106: --Setting the original value
3107: wf_engine.threshold := l_save_thresh;
3108:
3109:
3110: EXCEPTION
3111: WHEN OTHERS THEN

Line 3169: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

3165: BEGIN
3166:
3167: -- Get the workflow attribute values
3168: --
3169: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
3170: itemkey => itemkey,
3171: aname => 'PERSON_ID' );
3172:
3173:

Line 3221: resultout := wf_engine.eng_completed||':'||'S';

3217: END IF ;
3218:
3219:
3220: IF l_return_status = 'S' THEN
3221: resultout := wf_engine.eng_completed||':'||'S';
3222: ELSIF l_return_status = 'E' THEN
3223:
3224: -- Set any error messages
3225: --

Line 3232: resultout := wf_engine.eng_completed||':'||'E';

3228: set_nf_error_msg_attr(p_item_type => itemtype,
3229: p_item_key => itemkey,
3230: p_msg_count => l_msg_count,
3231: p_msg_data => l_msg_data);
3232: resultout := wf_engine.eng_completed||':'||'E';
3233:
3234: ELSE
3235: --
3236: -- Set any error messages

Line 3245: resultout := wf_engine.eng_completed||':'||'E';

3241: p_item_key => itemkey,
3242: p_msg_count => fnd_msg_pub.count_msg,
3243: p_msg_data => l_msg_data);
3244:
3245: resultout := wf_engine.eng_completed||':'||'E';
3246:
3247: END IF;
3248:
3249: EXCEPTION

Line 3266: wf_engine.SetItemAttrText( itemtype => itemtype

3262: END IF;
3263:
3264: IF l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
3265: log_message('l_msg_data is NULL');
3266: wf_engine.SetItemAttrText( itemtype => itemtype
3267: , itemkey => itemkey
3268: , aname => 'ERROR_MSG1'
3269: , avalue => SQLCODE||SQLERRM
3270: );

Line 3279: resultout := wf_engine.eng_completed||':'||'U';

3275: p_msg_data => l_msg_data);
3276:
3277: END IF ;
3278:
3279: resultout := wf_engine.eng_completed||':'||'U';
3280: log_message('resultout: '||resultout);
3281: --RAISE;
3282:
3283: END start_fte_sync_wf;