eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_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: -- Bug 11883653 start.

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

232: aname => 'PROJECT_RESOURCE_ADMINISTRATOR',
233: avalue => 'PASYSADMIN');
234: -- Bug 11883653 start.
235: IF p_calling_mode is not null THEN
236: wf_engine.SetItemAttrText ( itemtype => itemtype,
237: itemkey => itemkey,
238: aname => 'CALLING_MODE',
239: avalue => p_calling_mode);
240: END IF;

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

239: avalue => p_calling_mode);
240: END IF;
241:
242: IF p_org_struct_element_id is not null THEN
243: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
244: itemkey => itemkey,
245: aname => 'ORG_STRUCTURE_ELEMENT_ID',
246: avalue => p_org_struct_element_id);
247: END IF;

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

246: avalue => p_org_struct_element_id);
247: END IF;
248:
249: IF p_organization_id_parent is not null THEN
250: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
251: itemkey => itemkey,
252: aname => 'ORGANIZATION_ID_PARENT',
253: avalue => p_organization_id_parent);
254: END IF;

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

253: avalue => p_organization_id_parent);
254: END IF;
255:
256: IF p_organization_id_child is not null THEN
257: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
258: itemkey => itemkey,
259: aname => 'ORGANIZATION_ID_CHILD',
260: avalue => p_organization_id_child);
261: END IF;

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

260: avalue => p_organization_id_child);
261: END IF;
262:
263: IF p_org_structure_version_id is not null THEN
264: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
265: itemkey => itemkey,
266: aname => 'ORG_STRUCTURE_VERSION_ID',
267: avalue => p_org_structure_version_id);
268: END IF;

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

267: avalue => p_org_structure_version_id);
268: END IF;
269:
270: IF p_person_id is not null THEN
271: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
272: itemkey => itemkey,
273: aname => 'PERSON_ID',
274: avalue => p_person_id);
275: END IF;

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

274: avalue => p_person_id);
275: END IF;
276:
277: IF p_start_date_old is not null THEN
278: wf_engine.SetItemAttrDate ( itemtype => itemtype,
279: itemkey => itemkey,
280: aname => 'START_DATE_OLD',
281: avalue => p_start_date_old);
282: END IF;

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

281: avalue => p_start_date_old);
282: END IF;
283:
284: IF p_start_date_new is not null THEN
285: wf_engine.SetItemAttrDate ( itemtype => itemtype,
286: itemkey => itemkey,
287: aname => 'START_DATE_NEW',
288: avalue => p_start_date_new);
289: END IF;

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

288: avalue => p_start_date_new);
289: END IF;
290:
291: IF p_end_date_old is not null THEN
292: wf_engine.SetItemAttrDate ( itemtype => itemtype,
293: itemkey => itemkey,
294: aname => 'END_DATE_OLD',
295: avalue => p_end_date_old);
296: END IF;

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

295: avalue => p_end_date_old);
296: END IF;
297:
298: IF p_end_date_new is not null THEN
299: wf_engine.SetItemAttrDate ( itemtype => itemtype,
300: itemkey => itemkey,
301: aname => 'END_DATE_NEW',
302: avalue => p_end_date_new);
303: END IF;

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

302: avalue => p_end_date_new);
303: END IF;
304:
305: IF p_org_id_old is not null THEN
306: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
307: itemkey => itemkey,
308: aname => 'ORG_ID_OLD',
309: avalue => p_org_id_old);
310: END IF;

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

309: avalue => p_org_id_old);
310: END IF;
311:
312: IF p_org_id_new is not null THEN
313: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
314: itemkey => itemkey,
315: aname => 'ORG_ID_NEW',
316: avalue => p_org_id_new);
317: END IF;

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

320: -- SEQUENCE_OLD since those attributes are not used and have been
321: -- removed from the workflow.
322:
323: IF p_job_id_old is not null THEN
324: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
325: itemkey => itemkey,
326: aname => 'JOB_ID_OLD',
327: avalue => p_job_id_old);
328: END IF;

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

327: avalue => p_job_id_old);
328: END IF;
329:
330: IF p_job_id_new is not null THEN
331: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
332: itemkey => itemkey,
333: aname => 'JOB_ID_NEW',
334: avalue => p_job_id_new);
335: END IF;

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

334: avalue => p_job_id_new);
335: END IF;
336:
337: IF p_from_job_group_id is not null THEN
338: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
339: itemkey => itemkey,
340: aname => 'FROM_JOB_GROUP_ID',
341: avalue => p_from_job_group_id);
342: END IF;

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

341: avalue => p_from_job_group_id);
342: END IF;
343:
344: IF p_to_job_group_id is not null THEN
345: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'TO_JOB_GROUP_ID',
348: avalue => p_to_job_group_id);
349: END IF;

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

348: avalue => p_to_job_group_id);
349: END IF;
350:
351: IF p_supervisor_old is not null THEN
352: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
353: itemkey => itemkey,
354: aname => 'SUPERVISOR_OLD',
355: avalue => p_supervisor_old);
356: END IF;

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

355: avalue => p_supervisor_old);
356: END IF;
357:
358: IF p_supervisor_new is not null THEN
359: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
360: itemkey => itemkey,
361: aname => 'SUPERVISOR_NEW',
362: avalue => p_supervisor_new);
363: END IF;

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

362: avalue => p_supervisor_new);
363: END IF;
364:
365: IF p_primary_flag_old is not null THEN
366: wf_engine.SetItemAttrText ( itemtype => itemtype,
367: itemkey => itemkey,
368: aname => 'PRIMARY_FLAG_OLD',
369: avalue => p_primary_flag_old);
370: END IF;

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

369: avalue => p_primary_flag_old);
370: END IF;
371:
372: IF p_primary_flag_new is not null THEN
373: wf_engine.SetItemAttrText ( itemtype => itemtype,
374: itemkey => itemkey,
375: aname => 'PRIMARY_FLAG_NEW',
376: avalue => p_primary_flag_new);
377: END IF;

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

376: avalue => p_primary_flag_new);
377: END IF;
378:
379: IF p_org_info1_old is not null THEN
380: wf_engine.SetItemAttrText ( itemtype => itemtype,
381: itemkey => itemkey,
382: aname => 'ORG_INFO1_OLD',
383: avalue => p_org_info1_old);
384: END IF;

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

383: avalue => p_org_info1_old);
384: END IF;
385:
386: IF p_org_info1_new is not null THEN
387: wf_engine.SetItemAttrText ( itemtype => itemtype,
388: itemkey => itemkey,
389: aname => 'ORG_INFO1_NEW',
390: avalue => p_org_info1_new);
391:

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

392: END IF ;
393:
394:
395: IF p_jei_information2_old is not null THEN
396: wf_engine.SetItemAttrText ( itemtype => itemtype,
397: itemkey => itemkey,
398: aname => 'JEI_INFORMATION2_OLD',
399: avalue => p_jei_information2_old);
400: END IF;

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

399: avalue => p_jei_information2_old);
400: END IF;
401:
402: IF p_jei_information2_new is not null THEN
403: wf_engine.SetItemAttrText ( itemtype => itemtype,
404: itemkey => itemkey,
405: aname => 'JEI_INFORMATION2_NEW',
406: avalue => p_jei_information2_new);
407: END IF;

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

406: avalue => p_jei_information2_new);
407: END IF;
408:
409: IF p_jei_information3_old is not null THEN
410: wf_engine.SetItemAttrText ( itemtype => itemtype,
411: itemkey => itemkey,
412: aname => 'JEI_INFORMATION3_OLD',
413: avalue => p_jei_information3_old);
414: END IF;

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

413: avalue => p_jei_information3_old);
414: END IF;
415:
416: IF p_jei_information3_new is not null THEN
417: wf_engine.SetItemAttrText ( itemtype => itemtype,
418: itemkey => itemkey,
419: aname => 'JEI_INFORMATION3_NEW',
420: avalue => p_jei_information3_new);
421: END IF;

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

420: avalue => p_jei_information3_new);
421: END IF;
422:
423: IF p_jei_information4_old is not null THEN
424: wf_engine.SetItemAttrText ( itemtype => itemtype,
425: itemkey => itemkey,
426: aname => 'JEI_INFORMATION4_OLD',
427: avalue => p_jei_information4_old);
428: END IF;

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

427: avalue => p_jei_information4_old);
428: END IF;
429:
430: IF p_jei_information4_new is not null THEN
431: wf_engine.SetItemAttrText ( itemtype => itemtype,
432: itemkey => itemkey,
433: aname => 'JEI_INFORMATION4_NEW',
434: avalue => p_jei_information4_new);
435: END IF;

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

434: avalue => p_jei_information4_new);
435: END IF;
436:
437: IF p_jei_information6_old is not null THEN
438: wf_engine.SetItemAttrText ( itemtype => itemtype,
439: itemkey => itemkey,
440: aname => 'JEI_INFORMATION6_OLD',
441: avalue => p_jei_information6_old);
442: END IF;

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

441: avalue => p_jei_information6_old);
442: END IF;
443:
444: IF p_jei_information6_new is not null THEN
445: wf_engine.SetItemAttrText ( itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'JEI_INFORMATION6_NEW',
448: avalue => p_jei_information6_new);
449: END IF;

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

448: avalue => p_jei_information6_new);
449: END IF;
450:
451: IF p_full_name_old is not null THEN
452: wf_engine.SetItemAttrText ( itemtype => itemtype,
453: itemkey => itemkey,
454: aname => 'FULL_NAME_OLD',
455: avalue => p_full_name_old);
456: END IF;

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

455: avalue => p_full_name_old);
456: END IF;
457:
458: IF p_full_name_new is not null THEN
459: wf_engine.SetItemAttrText ( itemtype => itemtype,
460: itemkey => itemkey,
461: aname => 'FULL_NAME_NEW',
462: avalue => p_full_name_new);
463: END IF;

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

466: -- GRADE_ID_NEW since those attributes are not used and have been
467: -- removed from the workflow.
468:
469: IF p_country_old is not null THEN
470: wf_engine.SetItemAttrText ( itemtype => itemtype,
471: itemkey => itemkey,
472: aname => 'COUNTRY_OLD',
473: avalue => p_country_old);
474: END IF;

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

473: avalue => p_country_old);
474: END IF;
475:
476: IF p_country_new is not null THEN
477: wf_engine.SetItemAttrText ( itemtype => itemtype,
478: itemkey => itemkey,
479: aname => 'COUNTRY_NEW',
480: avalue => p_country_new);
481: END IF;

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

480: avalue => p_country_new);
481: END IF;
482:
483: IF p_city_old is not null THEN
484: wf_engine.SetItemAttrText ( itemtype => itemtype,
485: itemkey => itemkey,
486: aname => 'CITY_OLD',
487: avalue => p_city_old);
488: END IF;

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

487: avalue => p_city_old);
488: END IF;
489:
490: IF p_city_new is not null THEN
491: wf_engine.SetItemAttrText ( itemtype => itemtype,
492: itemkey => itemkey,
493: aname => 'CITY_NEW',
494: avalue => p_city_new);
495: END IF;

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

494: avalue => p_city_new);
495: END IF;
496:
497: IF p_region2_old is not null THEN
498: wf_engine.SetItemAttrText ( itemtype => itemtype,
499: itemkey => itemkey,
500: aname => 'REGION2_OLD',
501: avalue => p_region2_old);
502: END IF;

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

501: avalue => p_region2_old);
502: END IF;
503:
504: IF p_region2_new is not null THEN
505: wf_engine.SetItemAttrText ( itemtype => itemtype,
506: itemkey => itemkey,
507: aname => 'REGION2_NEW',
508: avalue => p_region2_new);
509: END IF;

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

508: avalue => p_region2_new);
509: END IF;
510:
511: IF p_inactive_date_old is not null THEN
512: wf_engine.SetItemAttrDate ( itemtype => itemtype,
513: itemkey => itemkey,
514: aname => 'INACTIVE_DATE_OLD',
515: avalue => p_inactive_date_old);
516: END IF;

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

515: avalue => p_inactive_date_old);
516: END IF;
517:
518: IF p_inactive_date_new is not null THEN
519: wf_engine.SetItemAttrDate ( itemtype => itemtype,
520: itemkey => itemkey,
521: aname => 'INACTIVE_DATE_NEW',
522: avalue => p_inactive_date_new);
523: END IF;

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

522: avalue => p_inactive_date_new);
523: END IF;
524:
525: IF p_from_job_id_old is not null THEN
526: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
527: itemkey => itemkey,
528: aname => 'FROM_JOB_ID_OLD',
529: avalue => p_from_job_id_old);
530: END IF;

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

529: avalue => p_from_job_id_old);
530: END IF;
531:
532: IF p_from_job_id_new is not null THEN
533: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
534: itemkey => itemkey,
535: aname => 'FROM_JOB_ID_NEW',
536: avalue => p_from_job_id_new);
537: END IF;

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

536: avalue => p_from_job_id_new);
537: END IF;
538:
539: IF p_to_job_id_old is not null THEN
540: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
541: itemkey => itemkey,
542: aname => 'TO_JOB_ID_OLD',
543: avalue => p_to_job_id_old);
544: END IF;

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

543: avalue => p_to_job_id_old);
544: END IF;
545:
546: IF p_to_job_id_new is not null THEN
547: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
548: itemkey => itemkey,
549: aname => 'TO_JOB_ID_NEW',
550: avalue => p_to_job_id_new);
551: END IF;

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

550: avalue => p_to_job_id_new);
551: END IF;
552:
553: IF p_org_info_context is not null THEN
554: wf_engine.SetItemAttrText ( itemtype => itemtype,
555: itemkey => itemkey,
556: aname => 'ORG_INFO_CONTEXT',
557: avalue => p_org_info_context);
558: END IF;

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

556: aname => 'ORG_INFO_CONTEXT',
557: avalue => p_org_info_context);
558: END IF;
559: -- Bug 11883653 end.
560: wf_engine.StartProcess( itemtype => itemtype,
561: itemkey => itemkey );
562:
563:
564: -- Insert to PA tables wf process information.

Line 587: wf_engine.threshold := l_save_thresh ;

583: null;
584: END;
585:
586: --
587: wf_engine.threshold := l_save_thresh ;
588: exception
589: when others then
590: null;
591:

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

626: --
627: -- Get the workflow attribute values
628: --
629:
630: l_org_struct_element_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
631: itemkey => itemkey,
632: aname => 'ORG_STRUCTURE_ELEMENT_ID' );
633:
634: l_organization_id_parent := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

630: l_org_struct_element_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
631: itemkey => itemkey,
632: aname => 'ORG_STRUCTURE_ELEMENT_ID' );
633:
634: l_organization_id_parent := wf_engine.GetItemAttrNumber( itemtype => itemtype,
635: itemkey => itemkey,
636: aname => 'ORGANIZATION_ID_PARENT' );
637:
638: l_organization_id_child := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

634: l_organization_id_parent := wf_engine.GetItemAttrNumber( itemtype => itemtype,
635: itemkey => itemkey,
636: aname => 'ORGANIZATION_ID_PARENT' );
637:
638: l_organization_id_child := wf_engine.GetItemAttrNumber(itemtype => itemtype,
639: itemkey => itemkey,
640: aname => 'ORGANIZATION_ID_CHILD' );
641:
642: l_org_structure_version_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

638: l_organization_id_child := wf_engine.GetItemAttrNumber(itemtype => itemtype,
639: itemkey => itemkey,
640: aname => 'ORGANIZATION_ID_CHILD' );
641:
642: l_org_structure_version_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
643: itemkey => itemkey,
644: aname => 'ORG_STRUCTURE_VERSION_ID' );
645:
646: wf_engine.SetItemAttrText ( itemtype => itemtype,

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

642: l_org_structure_version_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
643: itemkey => itemkey,
644: aname => 'ORG_STRUCTURE_VERSION_ID' );
645:
646: wf_engine.SetItemAttrText ( itemtype => itemtype,
647: itemkey => itemkey,
648: aname => 'ORGANIZATION_NAME',
649: avalue => pa_hr_update_api.get_org_name(l_organization_id_child));
650:

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

647: itemkey => itemkey,
648: aname => 'ORGANIZATION_NAME',
649: avalue => pa_hr_update_api.get_org_name(l_organization_id_child));
650:
651: wf_engine.SetItemAttrText ( itemtype => itemtype,
652: itemkey => itemkey,
653: aname => 'CHILD_ORGANIZATION_NAME',
654: avalue => pa_hr_update_api.get_org_name(l_organization_id_parent));
655:

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

666: x_err_stack => v_err_stack);
667:
668: IF nvl(v_err_code, 0) = 0 THEN
669:
670: resultout := wf_engine.eng_completed||':'||'S';
671: ELSE
672:
673: --
674: -- Set any error messages

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

678: set_nf_error_msg_attr(p_item_type => itemtype,
679: p_item_key => itemkey,
680: p_msg_count => l_msg_count,
681: p_msg_data => l_msg_data);
682: resultout := wf_engine.eng_completed||':'||'F';
683:
684: END IF;
685:
686: --

Line 726: wf_engine.SetItemAttrText

722: rollback to l_org_struct_element_change ;
723: End if;
724: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
725:
726: wf_engine.SetItemAttrText
727: ( itemtype => itemtype
728: , itemkey => itemkey
729: , aname => 'ERROR_MSG1'
730: , avalue => SQLCODE||SQLERRM

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

771: begin
772: --
773: -- Get the workflow attribute values
774: --
775: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
776: itemkey => itemkey,
777: aname => 'CALLING_MODE' );
778: l_job_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
779: itemkey => itemkey,

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

774: --
775: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
776: itemkey => itemkey,
777: aname => 'CALLING_MODE' );
778: l_job_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
779: itemkey => itemkey,
780: aname => 'JOB_ID_NEW' );
781: l_jei_information2_old := wf_engine.GetItemAttrText( itemtype => itemtype,
782: itemkey => itemkey,

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

777: aname => 'CALLING_MODE' );
778: l_job_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
779: itemkey => itemkey,
780: aname => 'JOB_ID_NEW' );
781: l_jei_information2_old := wf_engine.GetItemAttrText( itemtype => itemtype,
782: itemkey => itemkey,
783: aname => 'JEI_INFORMATION2_OLD' );
784: l_jei_information2_new := wf_engine.GetItemAttrText( itemtype => itemtype,
785: itemkey => itemkey,

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

780: aname => 'JOB_ID_NEW' );
781: l_jei_information2_old := wf_engine.GetItemAttrText( itemtype => itemtype,
782: itemkey => itemkey,
783: aname => 'JEI_INFORMATION2_OLD' );
784: l_jei_information2_new := wf_engine.GetItemAttrText( itemtype => itemtype,
785: itemkey => itemkey,
786: aname => 'JEI_INFORMATION2_NEW' );
787: l_jei_information3_old := wf_engine.GetItemAttrText( itemtype => itemtype,
788: itemkey => itemkey,

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

783: aname => 'JEI_INFORMATION2_OLD' );
784: l_jei_information2_new := wf_engine.GetItemAttrText( itemtype => itemtype,
785: itemkey => itemkey,
786: aname => 'JEI_INFORMATION2_NEW' );
787: l_jei_information3_old := wf_engine.GetItemAttrText( itemtype => itemtype,
788: itemkey => itemkey,
789: aname => 'JEI_INFORMATION3_OLD' );
790: l_jei_information3_new := wf_engine.GetItemAttrText(itemtype => itemtype,
791: itemkey => itemkey,

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

786: aname => 'JEI_INFORMATION2_NEW' );
787: l_jei_information3_old := wf_engine.GetItemAttrText( itemtype => itemtype,
788: itemkey => itemkey,
789: aname => 'JEI_INFORMATION3_OLD' );
790: l_jei_information3_new := wf_engine.GetItemAttrText(itemtype => itemtype,
791: itemkey => itemkey,
792: aname => 'JEI_INFORMATION3_NEW' );
793: l_jei_information4_old := wf_engine.GetItemAttrText( itemtype => itemtype,
794: itemkey => itemkey,

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

789: aname => 'JEI_INFORMATION3_OLD' );
790: l_jei_information3_new := wf_engine.GetItemAttrText(itemtype => itemtype,
791: itemkey => itemkey,
792: aname => 'JEI_INFORMATION3_NEW' );
793: l_jei_information4_old := wf_engine.GetItemAttrText( itemtype => itemtype,
794: itemkey => itemkey,
795: aname => 'JEI_INFORMATION4_OLD' );
796: l_jei_information4_new := wf_engine.GetItemAttrText(itemtype => itemtype,
797: itemkey => itemkey,

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

792: aname => 'JEI_INFORMATION3_NEW' );
793: l_jei_information4_old := wf_engine.GetItemAttrText( itemtype => itemtype,
794: itemkey => itemkey,
795: aname => 'JEI_INFORMATION4_OLD' );
796: l_jei_information4_new := wf_engine.GetItemAttrText(itemtype => itemtype,
797: itemkey => itemkey,
798: aname => 'JEI_INFORMATION4_NEW' );
799: l_jei_information6_old := wf_engine.GetItemAttrText( itemtype => itemtype,
800: itemkey => itemkey,

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

795: aname => 'JEI_INFORMATION4_OLD' );
796: l_jei_information4_new := wf_engine.GetItemAttrText(itemtype => itemtype,
797: itemkey => itemkey,
798: aname => 'JEI_INFORMATION4_NEW' );
799: l_jei_information6_old := wf_engine.GetItemAttrText( itemtype => itemtype,
800: itemkey => itemkey,
801: aname => 'JEI_INFORMATION6_OLD' );
802: l_jei_information6_new := wf_engine.GetItemAttrText(itemtype => itemtype,
803: itemkey => itemkey,

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

798: aname => 'JEI_INFORMATION4_NEW' );
799: l_jei_information6_old := wf_engine.GetItemAttrText( itemtype => itemtype,
800: itemkey => itemkey,
801: aname => 'JEI_INFORMATION6_OLD' );
802: l_jei_information6_new := wf_engine.GetItemAttrText(itemtype => itemtype,
803: itemkey => itemkey,
804: aname => 'JEI_INFORMATION6_NEW' );
805:
806: wf_engine.SetItemAttrText ( itemtype => itemtype,

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

802: l_jei_information6_new := wf_engine.GetItemAttrText(itemtype => itemtype,
803: itemkey => itemkey,
804: aname => 'JEI_INFORMATION6_NEW' );
805:
806: wf_engine.SetItemAttrText ( itemtype => itemtype,
807: itemkey => itemkey,
808: aname => 'JOB_NAME',
809: avalue => pa_hr_update_api.get_job_name(l_job_id));
810:

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

832: log_message('after calling per_job_extra_billability, l_return_status: '
833: ||l_return_status);
834: IF l_return_status = 'S' THEN
835:
836: resultout := wf_engine.eng_completed||':'||'S';
837: ELSIF l_return_status = 'E' THEN
838: --
839: -- Set any error messages
840: --

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

843: set_nf_error_msg_attr(p_item_type => itemtype,
844: p_item_key => itemkey,
845: p_msg_count => l_msg_count,
846: p_msg_data => l_msg_data);
847: resultout := wf_engine.eng_completed||':'||'F';
848:
849: ELSE
850: --
851: -- Set any error messages

Line 860: wf_engine.SetItemAttrText

856: p_item_key => itemkey,
857: p_msg_count => fnd_msg_pub.count_msg,
858: p_msg_data => l_msg_data);
859:
860: wf_engine.SetItemAttrText
861: ( itemtype => itemtype
862: , itemkey => itemkey
863: , aname => 'ERROR_MSG1'
864: , avalue => l_msg_data

Line 899: wf_engine.SetItemAttrText

895: funcmode);
896: If (l_savepoint) then
897: rollback to l_job_billability_change ;
898: End if;
899: wf_engine.SetItemAttrText
900: ( itemtype => itemtype
901: , itemkey => itemkey
902: , aname => 'ERROR_MSG1'
903: , avalue => SQLCODE||SQLERRM

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

902: , aname => 'ERROR_MSG1'
903: , avalue => SQLCODE||SQLERRM
904: );
905:
906: resultout := wf_engine.eng_completed||':'||'F';
907: */
908: WHEN OTHERS THEN
909: log_message('Execption OTHERS, '||SQLERRM ||', '|| SQLCODE);
910: wf_core.context('pa_forecast_test',

Line 923: wf_engine.SetItemAttrText

919: log_message('after rollback to l_job_billability_change');
920: End if;
921: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
922: log_message('l_msg_data is NULL');
923: wf_engine.SetItemAttrText
924: ( itemtype => itemtype
925: , itemkey => itemkey
926: , aname => 'ERROR_MSG1'
927: , avalue => SQLCODE||SQLERRM

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

934: p_msg_data => l_msg_data);
935:
936: End if;
937:
938: resultout := wf_engine.eng_completed||':'||'F';
939: log_message('resultout: '||resultout);
940: --RAISE;
941:
942: END Job_Bill_Change;

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

975: --
976: -- Get the workflow attribute values
977: --
978:
979: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
980: itemkey => itemkey,
981: aname => 'CALLING_MODE' );
982:
983: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

979: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
980: itemkey => itemkey,
981: aname => 'CALLING_MODE' );
982:
983: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
984: itemkey => itemkey,
985: aname => 'PERSON_ID' );
986:
987: l_full_name_old := wf_engine.GetItemAttrText(itemtype => itemtype,

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

983: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
984: itemkey => itemkey,
985: aname => 'PERSON_ID' );
986:
987: l_full_name_old := wf_engine.GetItemAttrText(itemtype => itemtype,
988: itemkey => itemkey,
989: aname => 'FULL_NAME_OLD');
990:
991: l_full_name_new := wf_engine.GetItemAttrText(itemtype => itemtype,

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

987: l_full_name_old := wf_engine.GetItemAttrText(itemtype => itemtype,
988: itemkey => itemkey,
989: aname => 'FULL_NAME_OLD');
990:
991: l_full_name_new := wf_engine.GetItemAttrText(itemtype => itemtype,
992: itemkey => itemkey,
993: aname => 'FULL_NAME_NEW');
994:
995: -- Removing the setting of the FULL_NAME_NEW attribute - no need

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

1008: ,x_msg_data => l_msg_data);
1009:
1010: IF l_return_status = 'S' THEN
1011:
1012: resultout := wf_engine.eng_completed||':'||'S';
1013: ELSIF l_return_status = 'E' THEN
1014: --
1015: -- Set any error messages
1016: --

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

1019: set_nf_error_msg_attr(p_item_type => itemtype,
1020: p_item_key => itemkey,
1021: p_msg_count => l_msg_count,
1022: p_msg_data => l_msg_data);
1023: resultout := wf_engine.eng_completed||':'||'F';
1024:
1025: ELSE
1026: l_savepoint := false;
1027: rollback to l_full_name_change ;

Line 1033: wf_engine.SetItemAttrText

1029: p_item_key => itemkey,
1030: p_msg_count => fnd_msg_pub.count_msg,
1031: p_msg_data => l_msg_data);
1032:
1033: wf_engine.SetItemAttrText
1034: ( itemtype => itemtype
1035: , itemkey => itemkey
1036: , aname => 'ERROR_MSG1'
1037: , avalue => l_msg_data

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

1056: set_nf_error_msg_attr(p_item_type => itemtype,
1057: p_item_key => itemkey,
1058: p_msg_count => l_msg_count,
1059: p_msg_data => l_msg_data);
1060: resultout := wf_engine.eng_completed||':'||'F';
1061:
1062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1063: THEN
1064: wf_core.context('pa_hr_update_pa_entities',

Line 1073: wf_engine.SetItemAttrText

1069: funcmode);
1070: If (l_savepoint) then
1071: rollback to l_full_name_change ;
1072: End if;
1073: wf_engine.SetItemAttrText
1074: ( itemtype => itemtype
1075: , itemkey => itemkey
1076: , aname => 'ERROR_MSG1'
1077: , avalue => SQLERRM

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

1076: , aname => 'ERROR_MSG1'
1077: , avalue => SQLERRM
1078: );
1079:
1080: resultout := wf_engine.eng_completed||':'||'F';
1081: */
1082: WHEN OTHERS THEN
1083: wf_core.context('pa_hr_update_pa_entities',
1084: 'Full_Name_Change',

Line 1094: wf_engine.SetItemAttrText

1090: rollback to l_full_name_change ;
1091: End if;
1092: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
1093:
1094: wf_engine.SetItemAttrText
1095: ( itemtype => itemtype
1096: , itemkey => itemkey
1097: , aname => 'ERROR_MSG1'
1098: , avalue => SQLCODE||SQLERRM

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

1104: p_msg_data => l_msg_data);
1105:
1106: End if;
1107:
1108: resultout := wf_engine.eng_completed||':'||'F';
1109:
1110: END Full_Name_Change;
1111:
1112: PROCEDURE Default_OU_Change

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

1146: --
1147: -- Initialize workflow item attributes
1148: --
1149:
1150: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1151: itemkey => itemkey,
1152: aname => 'CALLING_MODE' );
1153:
1154: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

1150: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1151: itemkey => itemkey,
1152: aname => 'CALLING_MODE' );
1153:
1154: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1155: itemkey => itemkey,
1156: aname => 'ORG_ID_NEW' );
1157:
1158: l_org_info1_old := wf_engine.GetItemAttrText( itemtype => itemtype,

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

1154: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1155: itemkey => itemkey,
1156: aname => 'ORG_ID_NEW' );
1157:
1158: l_org_info1_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1159: itemkey => itemkey,
1160: aname => 'ORG_INFO1_OLD' );
1161:
1162: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,

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

1158: l_org_info1_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1159: itemkey => itemkey,
1160: aname => 'ORG_INFO1_OLD' );
1161:
1162: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1163: itemkey => itemkey,
1164: aname => 'ORG_INFO1_NEW' );
1165:
1166: l_org_info_context := wf_engine.GetItemAttrText(itemtype => itemtype,

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

1162: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1163: itemkey => itemkey,
1164: aname => 'ORG_INFO1_NEW' );
1165:
1166: l_org_info_context := wf_engine.GetItemAttrText(itemtype => itemtype,
1167: itemkey => itemkey,
1168: aname => 'ORG_INFO_CONTEXT' );
1169:
1170: wf_engine.SetItemAttrText ( itemtype => itemtype,

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

1166: l_org_info_context := wf_engine.GetItemAttrText(itemtype => itemtype,
1167: itemkey => itemkey,
1168: aname => 'ORG_INFO_CONTEXT' );
1169:
1170: wf_engine.SetItemAttrText ( itemtype => itemtype,
1171: itemkey => itemkey,
1172: aname => 'ORGANIZATION_NAME',
1173: avalue => pa_hr_update_api.get_org_name(l_org_id));
1174:

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

1202: END IF;
1203:
1204: IF l_return_status = 'S' THEN
1205:
1206: resultout := wf_engine.eng_completed||':'||'S';
1207: ELSIF l_return_status = 'E' THEN
1208: l_savepoint := false;
1209: rollback to l_ou_change ;
1210: set_nf_error_msg_attr(p_item_type => itemtype,

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

1210: set_nf_error_msg_attr(p_item_type => itemtype,
1211: p_item_key => itemkey,
1212: p_msg_count => l_msg_count,
1213: p_msg_data => l_msg_data);
1214: resultout := wf_engine.eng_completed||':'||'F';
1215:
1216: ELSE
1217: l_savepoint := false;
1218: rollback to l_ou_change ;

Line 1224: wf_engine.SetItemAttrText

1220: p_item_key => itemkey,
1221: p_msg_count => fnd_msg_pub.count_msg,
1222: p_msg_data => l_msg_data);
1223:
1224: wf_engine.SetItemAttrText
1225: ( itemtype => itemtype
1226: , itemkey => itemkey
1227: , aname => 'ERROR_MSG1'
1228: , avalue => l_msg_data

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

1247: p_item_key => itemkey,
1248: p_msg_count => l_msg_count,
1249: p_msg_data => l_msg_data);
1250:
1251: resultout := wf_engine.eng_completed||':'||'F';
1252: -- RAISE;
1253:
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1255: THEN

Line 1267: wf_engine.SetItemAttrText

1263: -- itemkey,
1264: -- to_char(actid),
1265: -- funcmode);
1266:
1267: wf_engine.SetItemAttrText
1268: ( itemtype => itemtype
1269: , itemkey => itemkey
1270: , aname => 'ERROR_MSG1'
1271: , avalue => SQLCODE||SQLERRM

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

1272: );
1273:
1274:
1275:
1276: resultout := wf_engine.eng_completed||':'||'F';
1277: --RAISE ;
1278: */
1279: WHEN OTHERS THEN
1280: If (l_savepoint) then

Line 1291: wf_engine.SetItemAttrText

1287: -- to_char(actid),
1288: -- funcmode);
1289: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
1290:
1291: wf_engine.SetItemAttrText
1292: ( itemtype => itemtype
1293: , itemkey => itemkey
1294: , aname => 'ERROR_MSG1'
1295: , avalue => SQLCODE||SQLERRM

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

1301: p_msg_data => l_msg_data);
1302:
1303: End if;
1304:
1305: resultout := wf_engine.eng_completed||':'||'F';
1306: -- RAISE ;
1307:
1308: END Default_OU_Change;
1309:

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

1356: --
1357: -- Initialize workflow item attributes
1358: --
1359:
1360: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1361: itemkey => itemkey,
1362: aname => 'CALLING_MODE' );
1363:
1364: /*

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

1361: itemkey => itemkey,
1362: aname => 'CALLING_MODE' );
1363:
1364: /*
1365: l_grade_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1366: itemkey => itemkey,
1367: aname => 'GRADE_ID_OLD' );
1368:
1369: l_grade_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

1365: l_grade_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1366: itemkey => itemkey,
1367: aname => 'GRADE_ID_OLD' );
1368:
1369: l_grade_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1370: itemkey => itemkey,
1371: aname => 'GRADE_ID_NEW' );
1372:
1373: */

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

1370: itemkey => itemkey,
1371: aname => 'GRADE_ID_NEW' );
1372:
1373: */
1374: l_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1375: itemkey => itemkey,
1376: aname => 'JOB_ID_OLD' );
1377:
1378: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

1374: l_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1375: itemkey => itemkey,
1376: aname => 'JOB_ID_OLD' );
1377:
1378: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1379: itemkey => itemkey,
1380: aname => 'JOB_ID_NEW' );
1381:
1382: wf_engine.SetItemAttrText ( itemtype => itemtype,

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

1378: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1379: itemkey => itemkey,
1380: aname => 'JOB_ID_NEW' );
1381:
1382: wf_engine.SetItemAttrText ( itemtype => itemtype,
1383: itemkey => itemkey,
1384: aname => 'JOB_NAME',
1385: avalue => pa_hr_update_api.get_job_name(l_job_id_new));
1386:

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

1384: aname => 'JOB_NAME',
1385: avalue => pa_hr_update_api.get_job_name(l_job_id_new));
1386:
1387: /*
1388: wf_engine.SetItemAttrText ( itemtype => itemtype,
1389: itemkey => itemkey,
1390: aname => 'GRADE_NAME',
1391: avalue => pa_hr_update_api.get_grade_name(l_grade_id_new));
1392: */

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

1403:
1404:
1405: IF l_return_status = 'S' THEN
1406:
1407: resultout := wf_engine.eng_completed||':'||'S';
1408: ELSIF l_return_status = 'E' THEN
1409: l_savepoint := false;
1410: rollback to l_valid_grade_change ;
1411: set_nf_error_msg_attr(p_item_type => itemtype,

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

1411: set_nf_error_msg_attr(p_item_type => itemtype,
1412: p_item_key => itemkey,
1413: p_msg_count => l_msg_count,
1414: p_msg_data => l_msg_data);
1415: resultout := wf_engine.eng_completed||':'||'F';
1416:
1417: ELSE
1418: l_savepoint := false;
1419: rollback to l_valid_grade_change ;

Line 1425: wf_engine.SetItemAttrText

1421: p_item_key => itemkey,
1422: p_msg_count => fnd_msg_pub.count_msg,
1423: p_msg_data => l_msg_data);
1424:
1425: wf_engine.SetItemAttrText
1426: ( itemtype => itemtype
1427: , itemkey => itemkey
1428: , aname => 'ERROR_MSG1'
1429: , avalue => l_msg_data

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

1448: set_nf_error_msg_attr(p_item_type => itemtype,
1449: p_item_key => itemkey,
1450: p_msg_count => l_msg_count,
1451: p_msg_data => l_msg_data);
1452: resultout := wf_engine.eng_completed||':'||'F';
1453:
1454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1455: THEN
1456: If (l_savepoint) then

Line 1465: wf_engine.SetItemAttrText

1461: itemtype,
1462: itemkey,
1463: to_char(actid),
1464: funcmode);
1465: wf_engine.SetItemAttrText
1466: ( itemtype => itemtype
1467: , itemkey => itemkey
1468: , aname => 'ERROR_MSG1'
1469: , avalue => SQLERRM

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

1467: , itemkey => itemkey
1468: , aname => 'ERROR_MSG1'
1469: , avalue => SQLERRM
1470: );
1471: resultout := wf_engine.eng_completed||':'||'F';
1472: */
1473: WHEN OTHERS THEN
1474: If (l_savepoint) then
1475: rollback to l_valid_grade_change ;

Line 1485: wf_engine.SetItemAttrText

1481: to_char(actid),
1482: funcmode);
1483: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
1484:
1485: wf_engine.SetItemAttrText
1486: ( itemtype => itemtype
1487: , itemkey => itemkey
1488: , aname => 'ERROR_MSG1'
1489: , avalue => SQLCODE||SQLERRM

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

1495: p_msg_data => l_msg_data);
1496:
1497: End if;
1498:
1499: resultout := wf_engine.eng_completed||':'||'F';
1500:
1501: END Valid_Grade_Change;
1502:
1503: -- This procedure will not get called anymore because the triggers

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

1539: --
1540: -- Initialize workflow item attributes
1541: --
1542:
1543: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1544: itemkey => itemkey,
1545: aname => 'CALLING_MODE' );
1546:
1547: /*

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

1544: itemkey => itemkey,
1545: aname => 'CALLING_MODE' );
1546:
1547: /*
1548: l_grade_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1549: itemkey => itemkey,
1550: aname => 'GRADE_ID_NEW' );
1551:
1552: l_job_level_old := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

1548: l_grade_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1549: itemkey => itemkey,
1550: aname => 'GRADE_ID_NEW' );
1551:
1552: l_job_level_old := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1553: itemkey => itemkey,
1554: aname => 'SEQUENCE_OLD' );
1555:
1556: l_job_level_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

1552: l_job_level_old := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1553: itemkey => itemkey,
1554: aname => 'SEQUENCE_OLD' );
1555:
1556: l_job_level_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1557: itemkey => itemkey,
1558: aname => 'SEQUENCE_NEW' );
1559:
1560: wf_engine.SetItemAttrText ( itemtype => itemtype,

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

1556: l_job_level_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1557: itemkey => itemkey,
1558: aname => 'SEQUENCE_NEW' );
1559:
1560: wf_engine.SetItemAttrText ( itemtype => itemtype,
1561: itemkey => itemkey,
1562: aname => 'GRADE_NAME',
1563: avalue => pa_hr_update_api.get_grade_name(l_grade_id));
1564: */

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

1574: ,x_msg_data => l_msg_data);
1575:
1576: IF l_return_status = 'S' THEN
1577:
1578: resultout := wf_engine.eng_completed||':'||'S';
1579: ELSIF l_return_status = 'E' THEN
1580: l_savepoint := false;
1581: rollback to l_job_level_change ;
1582: set_nf_error_msg_attr(p_item_type => itemtype,

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

1582: set_nf_error_msg_attr(p_item_type => itemtype,
1583: p_item_key => itemkey,
1584: p_msg_count => l_msg_count,
1585: p_msg_data => l_msg_data);
1586: resultout := wf_engine.eng_completed||':'||'F';
1587:
1588: ELSE
1589: l_savepoint := false;
1590: rollback to l_job_level_change ;

Line 1596: wf_engine.SetItemAttrText

1592: p_item_key => itemkey,
1593: p_msg_count => fnd_msg_pub.count_msg,
1594: p_msg_data => l_msg_data);
1595:
1596: wf_engine.SetItemAttrText
1597: ( itemtype => itemtype
1598: , itemkey => itemkey
1599: , aname => 'ERROR_MSG1'
1600: , avalue => l_msg_data

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

1620: p_item_key => itemkey,
1621: p_msg_count => l_msg_count,
1622: p_msg_data => l_msg_data);
1623:
1624: resultout := wf_engine.eng_completed||':'||'F';
1625:
1626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1627: THEN
1628: If (l_savepoint) then

Line 1638: wf_engine.SetItemAttrText

1634: itemkey,
1635: to_char(actid),
1636: funcmode);
1637:
1638: wf_engine.SetItemAttrText
1639: ( itemtype => itemtype
1640: , itemkey => itemkey
1641: , aname => 'ERROR_MSG1'
1642: , avalue => SQLERRM

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

1641: , aname => 'ERROR_MSG1'
1642: , avalue => SQLERRM
1643: );
1644:
1645: resultout := wf_engine.eng_completed||':'||'F';
1646: */
1647: WHEN OTHERS THEN
1648: If (l_savepoint) then
1649: rollback to l_job_level_change ;

Line 1660: wf_engine.SetItemAttrText

1656: funcmode);
1657:
1658: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
1659:
1660: wf_engine.SetItemAttrText
1661: ( itemtype => itemtype
1662: , itemkey => itemkey
1663: , aname => 'ERROR_MSG1'
1664: , avalue => SQLCODE||SQLERRM

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

1670: p_msg_data => l_msg_data);
1671:
1672: End if;
1673:
1674: resultout := wf_engine.eng_completed||':'||'F';
1675:
1676: END Job_Level_Change;
1677:
1678: PROCEDURE Address_Change

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

1721: --
1722: -- Initialize workflow item attributes
1723: --
1724:
1725: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1726: itemkey => itemkey,
1727: aname => 'CALLING_MODE' );
1728:
1729: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

1725: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1726: itemkey => itemkey,
1727: aname => 'CALLING_MODE' );
1728:
1729: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1730: itemkey => itemkey,
1731: aname => 'PERSON_ID' );
1732:
1733: l_country_old := wf_engine.GetItemAttrText( itemtype => itemtype,

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

1729: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1730: itemkey => itemkey,
1731: aname => 'PERSON_ID' );
1732:
1733: l_country_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1734: itemkey => itemkey,
1735: aname => 'COUNTRY_OLD' );
1736:
1737: l_country_new := wf_engine.GetItemAttrText(itemtype => itemtype,

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

1733: l_country_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1734: itemkey => itemkey,
1735: aname => 'COUNTRY_OLD' );
1736:
1737: l_country_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1738: itemkey => itemkey,
1739: aname => 'COUNTRY_NEW' );
1740:
1741: l_city_old := wf_engine.GetItemAttrText( itemtype => itemtype,

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

1737: l_country_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1738: itemkey => itemkey,
1739: aname => 'COUNTRY_NEW' );
1740:
1741: l_city_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1742: itemkey => itemkey,
1743: aname => 'CITY_OLD' );
1744:
1745: l_city_new := wf_engine.GetItemAttrText(itemtype => itemtype,

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

1741: l_city_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1742: itemkey => itemkey,
1743: aname => 'CITY_OLD' );
1744:
1745: l_city_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1746: itemkey => itemkey,
1747: aname => 'CITY_NEW' );
1748:
1749: l_region2_old := wf_engine.GetItemAttrText( itemtype => itemtype,

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

1745: l_city_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1746: itemkey => itemkey,
1747: aname => 'CITY_NEW' );
1748:
1749: l_region2_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1750: itemkey => itemkey,
1751: aname => 'REGION2_OLD' );
1752:
1753: l_region2_new := wf_engine.GetItemAttrText(itemtype => itemtype,

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

1749: l_region2_old := wf_engine.GetItemAttrText( itemtype => itemtype,
1750: itemkey => itemkey,
1751: aname => 'REGION2_OLD' );
1752:
1753: l_region2_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1754: itemkey => itemkey,
1755: aname => 'REGION2_NEW' );
1756:
1757: l_date_from_old := wf_engine.GetItemAttrDate(itemtype => itemtype,

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

1753: l_region2_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1754: itemkey => itemkey,
1755: aname => 'REGION2_NEW' );
1756:
1757: l_date_from_old := wf_engine.GetItemAttrDate(itemtype => itemtype,
1758: itemkey => itemkey,
1759: aname => 'START_DATE_OLD');
1760:
1761: l_date_from_new := wf_engine.GetItemAttrDate(itemtype => itemtype,

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

1757: l_date_from_old := wf_engine.GetItemAttrDate(itemtype => itemtype,
1758: itemkey => itemkey,
1759: aname => 'START_DATE_OLD');
1760:
1761: l_date_from_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
1762: itemkey => itemkey,
1763: aname => 'START_DATE_NEW');
1764:
1765: l_date_to_old := wf_engine.GetItemAttrDate(itemtype => itemtype,

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

1761: l_date_from_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
1762: itemkey => itemkey,
1763: aname => 'START_DATE_NEW');
1764:
1765: l_date_to_old := wf_engine.GetItemAttrDate(itemtype => itemtype,
1766: itemkey => itemkey,
1767: aname => 'END_DATE_OLD');
1768:
1769: l_date_to_new := wf_engine.GetItemAttrDate(itemtype => itemtype,

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

1765: l_date_to_old := wf_engine.GetItemAttrDate(itemtype => itemtype,
1766: itemkey => itemkey,
1767: aname => 'END_DATE_OLD');
1768:
1769: l_date_to_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
1770: itemkey => itemkey,
1771: aname => 'END_DATE_NEW');
1772:
1773: l_addr_prim_flag_old := wf_engine.GetItemAttrText(itemtype => itemtype,

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

1769: l_date_to_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
1770: itemkey => itemkey,
1771: aname => 'END_DATE_NEW');
1772:
1773: l_addr_prim_flag_old := wf_engine.GetItemAttrText(itemtype => itemtype,
1774: itemkey => itemkey,
1775: aname => 'PRIMARY_FLAG_OLD');
1776:
1777: l_addr_prim_flag_new := wf_engine.GetItemAttrText(itemtype => itemtype,

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

1773: l_addr_prim_flag_old := wf_engine.GetItemAttrText(itemtype => itemtype,
1774: itemkey => itemkey,
1775: aname => 'PRIMARY_FLAG_OLD');
1776:
1777: l_addr_prim_flag_new := wf_engine.GetItemAttrText(itemtype => itemtype,
1778: itemkey => itemkey,
1779: aname => 'PRIMARY_FLAG_NEW');
1780:
1781: -- Changed for bug 4354854 - performance improvement

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

1786: IF l_return_status = 'E' THEN
1787: --
1788: l_savepoint := false;
1789: rollback to l_address_change ;
1790: resultout := wf_engine.eng_completed||':'||'F';
1791: END IF;
1792:
1793: wf_engine.SetItemAttrText(itemtype => itemtype,
1794: itemkey => itemkey,

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

1789: rollback to l_address_change ;
1790: resultout := wf_engine.eng_completed||':'||'F';
1791: END IF;
1792:
1793: wf_engine.SetItemAttrText(itemtype => itemtype,
1794: itemkey => itemkey,
1795: aname => 'FULL_NAME_NEW',
1796: avalue => l_person_name);
1797:

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

1821: IF l_return_status = 'S' THEN
1822:
1823: --dbms_output.put_line('Address Update Success');
1824:
1825: resultout := wf_engine.eng_completed||':'||'S';
1826: ELSIF l_return_status = 'E' THEN
1827: l_savepoint := false;
1828: rollback to l_address_change ;
1829: set_nf_error_msg_attr(p_item_type => itemtype,

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

1829: set_nf_error_msg_attr(p_item_type => itemtype,
1830: p_item_key => itemkey,
1831: p_msg_count => l_msg_count,
1832: p_msg_data => l_msg_data);
1833: resultout := wf_engine.eng_completed||':'||'F';
1834:
1835: ELSE
1836: l_savepoint := false;
1837: rollback to l_address_change ;

Line 1843: wf_engine.SetItemAttrText

1839: p_item_key => itemkey,
1840: p_msg_count => fnd_msg_pub.count_msg,
1841: p_msg_data => l_msg_data);
1842:
1843: wf_engine.SetItemAttrText
1844: ( itemtype => itemtype
1845: , itemkey => itemkey
1846: , aname => 'ERROR_MSG1'
1847: , avalue => l_msg_data

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

1869: p_item_key => itemkey,
1870: p_msg_count => l_msg_count,
1871: p_msg_data => l_msg_data);
1872:
1873: resultout := wf_engine.eng_completed||':'||'F';
1874:
1875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1876: THEN
1877: If (l_savepoint) then

Line 1887: wf_engine.SetItemAttrText

1883: itemkey,
1884: to_char(actid),
1885: funcmode);
1886:
1887: wf_engine.SetItemAttrText
1888: ( itemtype => itemtype
1889: , itemkey => itemkey
1890: , aname => 'ERROR_MSG1'
1891: , avalue => SQLCODE||SQLERRM

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

1890: , aname => 'ERROR_MSG1'
1891: , avalue => SQLCODE||SQLERRM
1892: );
1893:
1894: resultout := wf_engine.eng_completed||':'||'F';
1895: */
1896: WHEN OTHERS THEN
1897: If (l_savepoint) then
1898: rollback to l_address_change ;

Line 1910: wf_engine.SetItemAttrText

1906: funcmode);
1907:
1908: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
1909:
1910: wf_engine.SetItemAttrText
1911: ( itemtype => itemtype
1912: , itemkey => itemkey
1913: , aname => 'ERROR_MSG1'
1914: , avalue => SQLCODE||SQLERRM

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

1920: p_msg_data => l_msg_data);
1921:
1922: End if;
1923:
1924: resultout := wf_engine.eng_completed||':'||'F';
1925:
1926: END Address_Change;
1927:
1928: PROCEDURE Project_Organization_Change

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

1986: --
1987: -- Initialize workflow item attributes
1988: --
1989:
1990: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
1991: itemkey => itemkey,
1992: aname => 'CALLING_MODE' );
1993:
1994:

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

1992: aname => 'CALLING_MODE' );
1993:
1994:
1995:
1996: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1997: itemkey => itemkey,
1998: aname => 'ORG_ID_NEW' );
1999:
2000: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,

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

1996: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1997: itemkey => itemkey,
1998: aname => 'ORG_ID_NEW' );
1999:
2000: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,
2001: itemkey => itemkey,
2002: aname => 'ORG_INFO1_NEW' );
2003:
2004: l_inactive_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,

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

2000: l_org_info1_new := wf_engine.GetItemAttrText(itemtype => itemtype,
2001: itemkey => itemkey,
2002: aname => 'ORG_INFO1_NEW' );
2003:
2004: l_inactive_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2005: itemkey => itemkey,
2006: aname => 'INACTIVE_DATE_OLD' );
2007:
2008: l_inactive_date_new := wf_engine.GetItemAttrDate( itemtype => itemtype,

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

2004: l_inactive_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2005: itemkey => itemkey,
2006: aname => 'INACTIVE_DATE_OLD' );
2007:
2008: l_inactive_date_new := wf_engine.GetItemAttrDate( itemtype => itemtype,
2009: itemkey => itemkey,
2010: aname => 'INACTIVE_DATE_NEW' );
2011:
2012: wf_engine.SetItemAttrText ( itemtype => itemtype,

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

2008: l_inactive_date_new := wf_engine.GetItemAttrDate( itemtype => itemtype,
2009: itemkey => itemkey,
2010: aname => 'INACTIVE_DATE_NEW' );
2011:
2012: wf_engine.SetItemAttrText ( itemtype => itemtype,
2013: itemkey => itemkey,
2014: aname => 'ORGANIZATION_NAME',
2015: avalue => pa_hr_update_api.get_org_name(l_org_id));
2016:

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

2076:
2077:
2078: IF l_return_status = 'S' THEN
2079:
2080: resultout := wf_engine.eng_completed||':'||'S';
2081: ELSIF l_return_status = 'E' THEN
2082: l_savepoint := false;
2083: rollback to l_project_org_change ;
2084: set_nf_error_msg_attr(p_item_type => itemtype,

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

2084: set_nf_error_msg_attr(p_item_type => itemtype,
2085: p_item_key => itemkey,
2086: p_msg_count => l_msg_count,
2087: p_msg_data => l_msg_data);
2088: resultout := wf_engine.eng_completed||':'||'F';
2089:
2090: ELSE
2091: l_savepoint := false;
2092: rollback to l_project_org_change ;

Line 2098: wf_engine.SetItemAttrText

2094: p_item_key => itemkey,
2095: p_msg_count => fnd_msg_pub.count_msg,
2096: p_msg_data => l_msg_data);
2097:
2098: wf_engine.SetItemAttrText
2099: ( itemtype => itemtype
2100: , itemkey => itemkey
2101: , aname => 'ERROR_MSG1'
2102: , avalue => l_msg_data

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

2122: p_item_key => itemkey,
2123: p_msg_count => l_msg_count,
2124: p_msg_data => l_msg_data);
2125:
2126: resultout := wf_engine.eng_completed||':'||'F';
2127: --RAISE;
2128:
2129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2130: THEN

Line 2141: wf_engine.SetItemAttrText

2137: itemkey,
2138: to_char(actid),
2139: funcmode);
2140:
2141: wf_engine.SetItemAttrText
2142: ( itemtype => itemtype
2143: , itemkey => itemkey
2144: , aname => 'ERROR_MSG1'
2145: , avalue => SQLERRM

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

2144: , aname => 'ERROR_MSG1'
2145: , avalue => SQLERRM
2146: );
2147:
2148: resultout := wf_engine.eng_completed||':'||'F';
2149: --RAISE;
2150: */
2151: WHEN OTHERS THEN
2152:

Line 2166: wf_engine.SetItemAttrText

2162: funcmode);
2163:
2164: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
2165:
2166: wf_engine.SetItemAttrText
2167: ( itemtype => itemtype
2168: , itemkey => itemkey
2169: , aname => 'ERROR_MSG1'
2170: , avalue => SQLCODE||SQLERRM

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

2176: p_msg_data => l_msg_data);
2177:
2178: End if;
2179:
2180: resultout := wf_engine.eng_completed||':'||'F';
2181: --RAISE;
2182:
2183: END Project_Organization_Change;
2184:

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

2221: --
2222: -- Initialize workflow item attributes
2223: --
2224:
2225: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
2226: itemkey => itemkey,
2227: aname => 'CALLING_MODE' );
2228:
2229: l_from_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

2225: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
2226: itemkey => itemkey,
2227: aname => 'CALLING_MODE' );
2228:
2229: l_from_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2230: itemkey => itemkey,
2231: aname => 'FROM_JOB_ID_OLD' );
2232:
2233: l_from_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

2229: l_from_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2230: itemkey => itemkey,
2231: aname => 'FROM_JOB_ID_OLD' );
2232:
2233: l_from_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2234: itemkey => itemkey,
2235: aname => 'FROM_JOB_ID_NEW' );
2236:
2237: l_to_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

2233: l_from_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2234: itemkey => itemkey,
2235: aname => 'FROM_JOB_ID_NEW' );
2236:
2237: l_to_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2238: itemkey => itemkey,
2239: aname => 'TO_JOB_ID_OLD' );
2240:
2241: l_to_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

2237: l_to_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2238: itemkey => itemkey,
2239: aname => 'TO_JOB_ID_OLD' );
2240:
2241: l_to_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2242: itemkey => itemkey,
2243: aname => 'TO_JOB_ID_NEW' );
2244:
2245: l_from_job_group_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

2241: l_to_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2242: itemkey => itemkey,
2243: aname => 'TO_JOB_ID_NEW' );
2244:
2245: l_from_job_group_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2246: itemkey => itemkey,
2247: aname => 'FROM_JOB_GROUP_ID' );
2248:
2249: l_to_job_group_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

2245: l_from_job_group_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2246: itemkey => itemkey,
2247: aname => 'FROM_JOB_GROUP_ID' );
2248:
2249: l_to_job_group_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2250: itemkey => itemkey,
2251: aname => 'TO_JOB_GROUP_ID' );
2252:
2253:

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

2250: itemkey => itemkey,
2251: aname => 'TO_JOB_GROUP_ID' );
2252:
2253:
2254: wf_engine.SetItemAttrText ( itemtype => itemtype,
2255: itemkey => itemkey,
2256: aname => 'JOB_NAME',
2257: avalue => pa_hr_update_api.get_job_name(l_from_job_id_new));
2258:

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

2255: itemkey => itemkey,
2256: aname => 'JOB_NAME',
2257: avalue => pa_hr_update_api.get_job_name(l_from_job_id_new));
2258:
2259: wf_engine.SetItemAttrText ( itemtype => itemtype,
2260: itemkey => itemkey,
2261: aname => 'TO_JOB_NAME',
2262: avalue => pa_hr_update_api.get_job_name(l_to_job_id_new));
2263:

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

2276:
2277:
2278: IF l_return_status = 'S' THEN
2279:
2280: resultout := wf_engine.eng_completed||':'||'S';
2281: ELSIF l_return_status = 'E' THEN
2282: l_savepoint := false;
2283: rollback to l_job_rel_change ;
2284: set_nf_error_msg_attr(p_item_type => itemtype,

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

2284: set_nf_error_msg_attr(p_item_type => itemtype,
2285: p_item_key => itemkey,
2286: p_msg_count => l_msg_count,
2287: p_msg_data => l_msg_data);
2288: resultout := wf_engine.eng_completed||':'||'F';
2289:
2290: ELSE
2291: l_savepoint := false;
2292: rollback to l_job_rel_change ;

Line 2298: wf_engine.SetItemAttrText

2294: p_item_key => itemkey,
2295: p_msg_count => fnd_msg_pub.count_msg,
2296: p_msg_data => l_msg_data);
2297:
2298: wf_engine.SetItemAttrText
2299: ( itemtype => itemtype
2300: , itemkey => itemkey
2301: , aname => 'ERROR_MSG1'
2302: , avalue => l_msg_data

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

2322: p_item_key => itemkey,
2323: p_msg_count => l_msg_count,
2324: p_msg_data => l_msg_data);
2325:
2326: resultout := wf_engine.eng_completed||':'||'F';
2327:
2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2329: THEN
2330: If (l_savepoint) then

Line 2340: wf_engine.SetItemAttrText

2336: itemkey,
2337: to_char(actid),
2338: funcmode);
2339:
2340: wf_engine.SetItemAttrText
2341: ( itemtype => itemtype
2342: , itemkey => itemkey
2343: , aname => 'ERROR_MSG1'
2344: , avalue => SQLCODE||SQLERRM

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

2343: , aname => 'ERROR_MSG1'
2344: , avalue => SQLCODE||SQLERRM
2345: );
2346:
2347: resultout := wf_engine.eng_completed||':'||'F';
2348: */
2349: WHEN OTHERS THEN
2350: If (l_savepoint) then
2351: rollback to l_job_rel_change ;

Line 2363: wf_engine.SetItemAttrText

2359: funcmode);
2360:
2361: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
2362:
2363: wf_engine.SetItemAttrText
2364: ( itemtype => itemtype
2365: , itemkey => itemkey
2366: , aname => 'ERROR_MSG1'
2367: , avalue => SQLCODE||SQLERRM

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

2373: p_msg_data => l_msg_data);
2374:
2375: End if;
2376:
2377: resultout := wf_engine.eng_completed||':'||'F';
2378:
2379: END Job_Rel_Change;
2380:
2381: PROCEDURE assignment_change

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

2449: --
2450:
2451: l_final_return_status := FND_API.G_RET_STS_SUCCESS ;
2452:
2453: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
2454: itemkey => itemkey,
2455: aname => 'CALLING_MODE' );
2456:
2457: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

2453: l_calling_mode := wf_engine.GetItemAttrText( itemtype => itemtype,
2454: itemkey => itemkey,
2455: aname => 'CALLING_MODE' );
2456:
2457: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2458: itemkey => itemkey,
2459: aname => 'PERSON_ID' );
2460: l_start_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2461: itemkey => itemkey,

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

2456:
2457: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2458: itemkey => itemkey,
2459: aname => 'PERSON_ID' );
2460: l_start_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2461: itemkey => itemkey,
2462: aname => 'START_DATE_OLD' );
2463: l_start_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
2464: itemkey => itemkey,

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

2459: aname => 'PERSON_ID' );
2460: l_start_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2461: itemkey => itemkey,
2462: aname => 'START_DATE_OLD' );
2463: l_start_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
2464: itemkey => itemkey,
2465: aname => 'START_DATE_NEW' );
2466: l_end_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2467: itemkey => itemkey,

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

2462: aname => 'START_DATE_OLD' );
2463: l_start_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
2464: itemkey => itemkey,
2465: aname => 'START_DATE_NEW' );
2466: l_end_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2467: itemkey => itemkey,
2468: aname => 'END_DATE_OLD' );
2469: l_end_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
2470: itemkey => itemkey,

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

2465: aname => 'START_DATE_NEW' );
2466: l_end_date_old := wf_engine.GetItemAttrDate( itemtype => itemtype,
2467: itemkey => itemkey,
2468: aname => 'END_DATE_OLD' );
2469: l_end_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
2470: itemkey => itemkey,
2471: aname => 'END_DATE_NEW' );
2472: l_org_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2473: itemkey => itemkey,

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

2468: aname => 'END_DATE_OLD' );
2469: l_end_date_new := wf_engine.GetItemAttrDate(itemtype => itemtype,
2470: itemkey => itemkey,
2471: aname => 'END_DATE_NEW' );
2472: l_org_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2473: itemkey => itemkey,
2474: aname => 'ORG_ID_OLD' );
2475: l_org_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2476: itemkey => itemkey,

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

2471: aname => 'END_DATE_NEW' );
2472: l_org_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2473: itemkey => itemkey,
2474: aname => 'ORG_ID_OLD' );
2475: l_org_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2476: itemkey => itemkey,
2477: aname => 'ORG_ID_NEW' );
2478: l_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2479: itemkey => itemkey,

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

2474: aname => 'ORG_ID_OLD' );
2475: l_org_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2476: itemkey => itemkey,
2477: aname => 'ORG_ID_NEW' );
2478: l_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2479: itemkey => itemkey,
2480: aname => 'JOB_ID_OLD' );
2481: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2482: itemkey => itemkey,

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

2477: aname => 'ORG_ID_NEW' );
2478: l_job_id_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2479: itemkey => itemkey,
2480: aname => 'JOB_ID_OLD' );
2481: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2482: itemkey => itemkey,
2483: aname => 'JOB_ID_NEW' );
2484: l_supervisor_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2485: itemkey => itemkey,

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

2480: aname => 'JOB_ID_OLD' );
2481: l_job_id_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2482: itemkey => itemkey,
2483: aname => 'JOB_ID_NEW' );
2484: l_supervisor_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2485: itemkey => itemkey,
2486: aname => 'SUPERVISOR_OLD' );
2487: l_supervisor_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2488: itemkey => itemkey,

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

2483: aname => 'JOB_ID_NEW' );
2484: l_supervisor_old := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2485: itemkey => itemkey,
2486: aname => 'SUPERVISOR_OLD' );
2487: l_supervisor_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2488: itemkey => itemkey,
2489: aname => 'SUPERVISOR_NEW' );
2490: l_primary_flag_old := wf_engine.GetItemAttrText( itemtype => itemtype,
2491: itemkey => itemkey,

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

2486: aname => 'SUPERVISOR_OLD' );
2487: l_supervisor_new := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2488: itemkey => itemkey,
2489: aname => 'SUPERVISOR_NEW' );
2490: l_primary_flag_old := wf_engine.GetItemAttrText( itemtype => itemtype,
2491: itemkey => itemkey,
2492: aname => 'PRIMARY_FLAG_OLD' );
2493: l_primary_flag_new := wf_engine.GetItemAttrText(itemtype => itemtype,
2494: itemkey => itemkey,

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

2489: aname => 'SUPERVISOR_NEW' );
2490: l_primary_flag_old := wf_engine.GetItemAttrText( itemtype => itemtype,
2491: itemkey => itemkey,
2492: aname => 'PRIMARY_FLAG_OLD' );
2493: l_primary_flag_new := wf_engine.GetItemAttrText(itemtype => itemtype,
2494: itemkey => itemkey,
2495: aname => 'PRIMARY_FLAG_NEW' );
2496:
2497:

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

2503: IF l_return_status = 'E' THEN
2504: --
2505: l_savepoint := false;
2506: rollback to l_address_change ;
2507: resultout := wf_engine.eng_completed||':'||'F';
2508: END IF;
2509:
2510: wf_engine.SetItemAttrText (itemtype => itemtype,
2511: itemkey => itemkey,

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

2506: rollback to l_address_change ;
2507: resultout := wf_engine.eng_completed||':'||'F';
2508: END IF;
2509:
2510: wf_engine.SetItemAttrText (itemtype => itemtype,
2511: itemkey => itemkey,
2512: aname => 'FULL_NAME_NEW',
2513: avalue => l_person_name);
2514:

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

2965:
2966:
2967: IF l_final_return_status = 'S' THEN
2968:
2969: resultout := wf_engine.eng_completed||':'||'S';
2970: ELSIF l_return_status = 'E' THEN
2971: l_savepoint := false;
2972: rollback to l_assignment_change ;
2973: set_nf_error_msg_attr(p_item_type => itemtype,

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

2973: set_nf_error_msg_attr(p_item_type => itemtype,
2974: p_item_key => itemkey,
2975: p_msg_count => l_msg_count,
2976: p_msg_data => l_msg_data);
2977: resultout := wf_engine.eng_completed||':'||'F';
2978:
2979: ELSE
2980: l_savepoint := false;
2981: rollback to l_assignment_change ;

Line 2987: wf_engine.SetItemAttrText

2983: p_item_key => itemkey,
2984: p_msg_count => fnd_msg_pub.count_msg,
2985: p_msg_data => l_msg_data);
2986:
2987: wf_engine.SetItemAttrText
2988: ( itemtype => itemtype
2989: , itemkey => itemkey
2990: , aname => 'ERROR_MSG1'
2991: , avalue => l_msg_data

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

2990: , aname => 'ERROR_MSG1'
2991: , avalue => l_msg_data
2992: );
2993:
2994: resultout := wf_engine.eng_completed||':'||'F';
2995: END IF;
2996:
2997: EXCEPTION
2998: WHEN FND_API.G_EXC_ERROR THEN

Line 3012: wf_engine.SetItemAttrText

3008: funcmode);
3009:
3010: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
3011:
3012: wf_engine.SetItemAttrText
3013: ( itemtype => itemtype
3014: , itemkey => itemkey
3015: , aname => 'ERROR_MSG1'
3016: , avalue => SQLCODE||SQLERRM

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

3022: p_msg_data => l_msg_data);
3023:
3024: End if;
3025:
3026: resultout := wf_engine.eng_completed||':'||'F';
3027: --RAISE;
3028:
3029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3030: If (l_savepoint) then

Line 3042: wf_engine.SetItemAttrText

3038: to_char(actid),
3039: funcmode);
3040: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
3041:
3042: wf_engine.SetItemAttrText
3043: ( itemtype => itemtype
3044: , itemkey => itemkey
3045: , aname => 'ERROR_MSG1'
3046: , avalue => SQLCODE||SQLERRM

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

3052: p_msg_data => l_msg_data);
3053:
3054: End if;
3055:
3056: resultout := wf_engine.eng_completed||':'||'U';
3057: --RAISE;
3058:
3059: WHEN OTHERS THEN
3060: If (l_savepoint) then

Line 3072: wf_engine.SetItemAttrText

3068: funcmode);
3069: */
3070: If l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
3071:
3072: wf_engine.SetItemAttrText
3073: ( itemtype => itemtype
3074: , itemkey => itemkey
3075: , aname => 'ERROR_MSG1'
3076: , avalue => SQLCODE||SQLERRM

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

3082: p_msg_data => l_msg_data);
3083:
3084: End if;
3085:
3086: resultout := wf_engine.eng_completed||':'||'U';
3087: --RAISE;
3088:
3089: END assignment_change;
3090:

Line 3105: wf_engine.SetItemAttrText

3101: IF nvl(p_msg_count,0) = 0 and p_msg_data is NULL THEN
3102: RETURN;
3103: Elsif nvl(p_msg_count,0) = 0 and p_msg_data is NOT NULL then
3104: l_data := FND_MESSAGE.get_string('PA',p_msg_data);
3105: wf_engine.SetItemAttrText
3106: ( itemtype => p_item_type
3107: , itemkey => p_item_key
3108: , aname => 'ERROR_MSG1'
3109: , avalue => l_data

Line 3134: wf_engine.SetItemAttrText

3130: l_data := p_msg_data;
3131: END IF;
3132: End if;
3133:
3134: wf_engine.SetItemAttrText
3135: ( itemtype => p_item_type
3136: , itemkey => p_item_key
3137: , aname => 'ERROR_MSG1'
3138: , avalue => l_data

Line 3165: wf_engine.SetItemAttrText

3161: l_data := FND_MESSAGE.get_string('PA',p_msg_data);
3162: end if;
3163:
3164: l_item_attr_name := 'ERROR_MSG'||i;
3165: wf_engine.SetItemAttrText
3166: ( itemtype => p_item_type
3167: , itemkey => p_item_key
3168: , aname => l_item_attr_name
3169: , avalue => l_data

Line 3224: l_save_thresh := wf_engine.threshold ;

3220: -- Since this workflow needs to be executed in Non deferred mode,
3221: -- we need to change the threshold. So we save the current threshold which
3222: -- will be used later on to change it back to the current threshold.
3223: --
3224: l_save_thresh := wf_engine.threshold ;
3225:
3226: --
3227: -- Set the threshold to 50 so that the process will not be deferred
3228: --

Line 3229: wf_engine.threshold := 50 ;

3225:
3226: --
3227: -- Set the threshold to 50 so that the process will not be deferred
3228: --
3229: wf_engine.threshold := 50 ;
3230:
3231:
3232: -- Create the appropriate process
3233: --

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

3230:
3231:
3232: -- Create the appropriate process
3233: --
3234: wf_engine.CreateProcess( ItemType => l_item_type,
3235: ItemKey => l_item_key,
3236: process => 'TIMEOUT_TERMINATION_PROCESS' );
3237:
3238:

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

3238:
3239:
3240: -- Initialize workflow item attributes with the parameter values
3241: --
3242: wf_engine.SetItemAttrText(itemtype => l_item_type,
3243: itemkey => l_item_key,
3244: aname => 'PROJECT_RESOURCE_ADMINISTRATOR',
3245: avalue => 'PASYSADMIN');
3246:

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

3243: itemkey => l_item_key,
3244: aname => 'PROJECT_RESOURCE_ADMINISTRATOR',
3245: avalue => 'PASYSADMIN');
3246:
3247: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
3248: itemkey => l_item_key,
3249: aname => 'PERSON_ID',
3250: avalue => p_person_id);
3251:

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

3248: itemkey => l_item_key,
3249: aname => 'PERSON_ID',
3250: avalue => p_person_id);
3251:
3252: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
3253: itemkey => l_item_key,
3254: aname => 'WAIT_DAYS',
3255: avalue => p_wait_days);
3256:

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

3261:
3262:
3263: IF l_return_status = 'S' THEN
3264: --Set the wf name attribute for display of name , if any error occurs
3265: wf_engine.SetItemAttrText (itemtype => l_item_type,
3266: itemkey => l_item_key,
3267: aname => 'FULL_NAME_NEW',
3268: avalue => l_person_name);
3269:

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

3272:
3273:
3274: -- Starting the work flow process and calling work flow api internaly
3275: --
3276: WF_ENGINE.StartProcess( itemtype => l_item_type,
3277: itemkey => l_item_key);
3278:
3279: -- Insert to PA tables wf process information.
3280: -- This is required for displaying notifications on PA pages.

Line 3304: wf_engine.threshold := l_save_thresh;

3300:
3301:
3302:
3303: --Setting the original value
3304: wf_engine.threshold := l_save_thresh;
3305:
3306:
3307: EXCEPTION
3308: WHEN OTHERS THEN

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

3362: BEGIN
3363:
3364: -- Get the workflow attribute values
3365: --
3366: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
3367: itemkey => itemkey,
3368: aname => 'PERSON_ID' );
3369:
3370:

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

3414: END IF ;
3415:
3416:
3417: IF l_return_status = 'S' THEN
3418: resultout := wf_engine.eng_completed||':'||'S';
3419: ELSIF l_return_status = 'E' THEN
3420:
3421: -- Set any error messages
3422: --

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

3425: set_nf_error_msg_attr(p_item_type => itemtype,
3426: p_item_key => itemkey,
3427: p_msg_count => l_msg_count,
3428: p_msg_data => l_msg_data);
3429: resultout := wf_engine.eng_completed||':'||'E';
3430:
3431: ELSE
3432: --
3433: -- Set any error messages

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

3438: p_item_key => itemkey,
3439: p_msg_count => fnd_msg_pub.count_msg,
3440: p_msg_data => l_msg_data);
3441:
3442: resultout := wf_engine.eng_completed||':'||'E';
3443:
3444: END IF;
3445:
3446: EXCEPTION

Line 3463: wf_engine.SetItemAttrText( itemtype => itemtype

3459: END IF;
3460:
3461: IF l_msg_data is NULL and nvl(l_msg_count,0) = 0 then
3462: log_message('l_msg_data is NULL');
3463: wf_engine.SetItemAttrText( itemtype => itemtype
3464: , itemkey => itemkey
3465: , aname => 'ERROR_MSG1'
3466: , avalue => SQLCODE||SQLERRM
3467: );

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

3472: p_msg_data => l_msg_data);
3473:
3474: END IF ;
3475:
3476: resultout := wf_engine.eng_completed||':'||'U';
3477: log_message('resultout: '||resultout);
3478: --RAISE;
3479:
3480: END start_fte_sync_wf;