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.IGS_PE_GEN_002 dependencies on WF_ENGINE

Line 358: l_person_number := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NUMBER' );

354: l_message_string := null;
355: FND_MSG_PUB.initialize;
356:
357: -- Fetch all the parameters from Event
358: l_person_number := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NUMBER' );
359: l_hold_type := wf_engine.GetItemAttrText(itemtype,itemkey,'P_HOLD_TYPE');
360: l_start_dt := wf_engine.GetItemAttrText(itemtype,itemkey,'P_START_DT' );
361: l_expiry_date := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXPIRATION_DATE' );
362: l_external_ref := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXTERNAL_REFERENCE' );

Line 359: l_hold_type := wf_engine.GetItemAttrText(itemtype,itemkey,'P_HOLD_TYPE');

355: FND_MSG_PUB.initialize;
356:
357: -- Fetch all the parameters from Event
358: l_person_number := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NUMBER' );
359: l_hold_type := wf_engine.GetItemAttrText(itemtype,itemkey,'P_HOLD_TYPE');
360: l_start_dt := wf_engine.GetItemAttrText(itemtype,itemkey,'P_START_DT' );
361: l_expiry_date := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXPIRATION_DATE' );
362: l_external_ref := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXTERNAL_REFERENCE' );
363: l_admin := wf_engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN' );

Line 360: l_start_dt := wf_engine.GetItemAttrText(itemtype,itemkey,'P_START_DT' );

356:
357: -- Fetch all the parameters from Event
358: l_person_number := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NUMBER' );
359: l_hold_type := wf_engine.GetItemAttrText(itemtype,itemkey,'P_HOLD_TYPE');
360: l_start_dt := wf_engine.GetItemAttrText(itemtype,itemkey,'P_START_DT' );
361: l_expiry_date := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXPIRATION_DATE' );
362: l_external_ref := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXTERNAL_REFERENCE' );
363: l_admin := wf_engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN' );
364:

Line 361: l_expiry_date := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXPIRATION_DATE' );

357: -- Fetch all the parameters from Event
358: l_person_number := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NUMBER' );
359: l_hold_type := wf_engine.GetItemAttrText(itemtype,itemkey,'P_HOLD_TYPE');
360: l_start_dt := wf_engine.GetItemAttrText(itemtype,itemkey,'P_START_DT' );
361: l_expiry_date := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXPIRATION_DATE' );
362: l_external_ref := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXTERNAL_REFERENCE' );
363: l_admin := wf_engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN' );
364:
365:

Line 362: l_external_ref := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXTERNAL_REFERENCE' );

358: l_person_number := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NUMBER' );
359: l_hold_type := wf_engine.GetItemAttrText(itemtype,itemkey,'P_HOLD_TYPE');
360: l_start_dt := wf_engine.GetItemAttrText(itemtype,itemkey,'P_START_DT' );
361: l_expiry_date := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXPIRATION_DATE' );
362: l_external_ref := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXTERNAL_REFERENCE' );
363: l_admin := wf_engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN' );
364:
365:
366: --Check that l_admin is not null, if it is not null then create the role else return with 'E'

Line 363: l_admin := wf_engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN' );

359: l_hold_type := wf_engine.GetItemAttrText(itemtype,itemkey,'P_HOLD_TYPE');
360: l_start_dt := wf_engine.GetItemAttrText(itemtype,itemkey,'P_START_DT' );
361: l_expiry_date := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXPIRATION_DATE' );
362: l_external_ref := wf_engine.GetItemAttrText(itemtype,itemkey,'P_EXTERNAL_REFERENCE' );
363: l_admin := wf_engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN' );
364:
365:
366: --Check that l_admin is not null, if it is not null then create the role else return with 'E'
367: IF l_admin IS NOT NULL THEN

Line 375: Wf_Engine.SetItemAttrText(

371: -- set error
372: l_error :='IGS_PE_FND_USR_INCOMP';
373: message_get(l_error,l_message_name);
374: IF c_user%NOTFOUND THEN
375: Wf_Engine.SetItemAttrText(
376: ItemType => itemtype,
377: ItemKey => itemkey,
378: aname => 'P_ERROR',
379: avalue => l_message_name

Line 400: Wf_Engine.SetItemAttrText(

396: role_name => l_role_name,
397: role_users => l_admin
398: );
399:
400: Wf_Engine.SetItemAttrText(
401: ItemType => itemtype,
402: ItemKey => itemkey,
403: aname => 'P_ADMIN',
404: avalue => l_role_name

Line 413: Wf_Engine.SetItemAttrText(

409:
410: -- set error
411: l_error :='IGS_FI_PARAMETER_NULL';
412: message_get(l_error,l_message_name);
413: Wf_Engine.SetItemAttrText(
414: ItemType => itemtype,
415: ItemKey => itemkey,
416: aname => 'P_ERROR',
417: avalue => l_message_name

Line 432: Wf_Engine.SetItemAttrText(

428: l_start_dt IS NULL OR l_external_ref IS NULL THEN
429: -- set error
430: l_error :='IGS_FI_PARAMETER_NULL';
431: message_get(l_error,l_message_name);
432: Wf_Engine.SetItemAttrText(
433: ItemType => itemtype,
434: ItemKey => itemkey,
435: aname => 'P_ERROR',
436: avalue => l_message_name

Line 452: Wf_Engine.SetItemAttrText(

448: CLOSE c_student_chk;
449: -- set error
450: l_error :='IGS_GE_INVALID_PERSON_NUMBER';
451: message_get(l_error,l_message_name);
452: Wf_Engine.SetItemAttrText(
453: ItemType => itemtype,
454: ItemKey => itemkey,
455: aname => 'P_ERROR',
456: avalue => l_message_name

Line 462: Wf_Engine.SetItemAttrText(

458: resultout := 'COMPLETE:F';
459: return;
460: ELSE
461: CLOSE c_student_chk;
462: Wf_Engine.SetItemAttrText(
463: ItemType => itemtype,
464: ItemKey => itemkey,
465: aname => 'P_PERSON_NAME',
466: avalue => l_student_rec.full_name

Line 469: l_person_name := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NAME' );

465: aname => 'P_PERSON_NAME',
466: avalue => l_student_rec.full_name
467: );
468:
469: l_person_name := wf_engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_NAME' );
470: END IF;
471:
472:
473: --check if the hold type exists

Line 482: Wf_Engine.SetItemAttrText(

478: CLOSE c_hold_typ_exst;
479:
480: l_error := 'IGS_PE_INVALID_HOLD';
481: message_get(l_error,l_message_name);
482: Wf_Engine.SetItemAttrText(
483: ItemType => itemtype,
484: ItemKey => itemkey,
485: aname => 'P_ERROR',
486: avalue => l_message_name

Line 502: Wf_Engine.SetItemAttrText(

498: IF c_hold_eff%FOUND THEN
499: CLOSE c_hold_eff;
500: l_error := 'IGS_PE_INVALID_HOLD';
501: message_get(l_error,l_message_name);
502: Wf_Engine.SetItemAttrText(
503: ItemType => itemtype,
504: ItemKey => itemkey,
505: aname => 'P_ERROR',
506: avalue => l_message_name

Line 544: Wf_Engine.SetItemAttrText(

540: CLOSE c_dt_format;
541: END IF;
542: l_error := 'IGS_PE_INVLD_DATE_FRMT';
543: message_get(l_error,l_message_name);
544: Wf_Engine.SetItemAttrText(
545: ItemType => itemtype,
546: ItemKey => itemkey,
547: aname => 'P_ERROR',
548: avalue => l_message_name

Line 580: Wf_Engine.SetItemAttrText(

576:
577:
578: l_error :='IGS_EN_ENCMBR_HAS_SPECIFIED';
579: message_get(l_error,l_message_name);
580: Wf_Engine.SetItemAttrText(
581: ItemType => itemtype,
582: ItemKey => itemkey,
583: aname => 'P_ERROR',
584: avalue => l_message_name

Line 625: Wf_Engine.SetItemAttrText(

621:
622: ELSE
623:
624: --Hold was NOT applied successfully
625: Wf_Engine.SetItemAttrText(
626: ItemType => itemtype,
627: ItemKey => itemkey,
628: aname => 'P_ERROR',
629: avalue => l_message_name || ',' || l_message_string

Line 657: Wf_Engine.SetItemAttrText(

653:
654:
655: l_error :='IGS_EN_ENCMBR_HAS_SPECIFIED';
656: message_get(l_error,l_message_name);
657: Wf_Engine.SetItemAttrText(
658: ItemType => itemtype,
659: ItemKey => itemkey,
660: aname => 'P_ERROR',
661: avalue => l_message_name

Line 675: Wf_Engine.SetItemAttrText(

671: IF l_expiry_date IS NOT NULL THEN
672: IF igs_ge_date.igsdate(igs_ge_date.igschar(l_expiry_date)) < TRUNC(SYSDATE) THEN
673: l_error :='IGS_EN_DT_NOT_LT_CURR_DT';
674: message_get(l_error,l_message_name);
675: Wf_Engine.SetItemAttrText(
676: ItemType => itemtype,
677: ItemKey => itemkey,
678: aname => 'P_ERROR',
679: avalue => l_message_name

Line 686: Wf_Engine.SetItemAttrText(

682: return;
683: ELSIF igs_ge_date.igsdate(igs_ge_date.igschar(l_expiry_date)) < igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)) THEN
684: l_error := 'IGS_EN_EXPDT_GE_STDT';
685: message_get(l_error,l_message_name);
686: Wf_Engine.SetItemAttrText(
687: ItemType => itemtype,
688: ItemKey => itemkey,
689: aname => 'P_ERROR',
690: avalue => l_message_name

Line 700: Wf_Engine.SetItemAttrText(

696: -- else trying to make the expiry date of a hold already set to NULL
697: ELSIF l_exist_exp_dt IS NOT NULL THEN
698: l_error :='IGS_PE_EXP_DATE_NT_NULL';
699: message_get(l_error,l_message_name);
700: Wf_Engine.SetItemAttrText(
701: ItemType => itemtype,
702: ItemKey => itemkey,
703: aname => 'P_ERROR',
704: avalue => l_message_name

Line 715: Wf_Engine.SetItemAttrText(

711:
712: ELSIF (( l_exist_exp_dt IS NULL) AND (l_expiry_date IS NULL)) THEN
713: l_error :='IGS_GE_RECORD_ALREADY_EXISTS';
714: message_get(l_error,l_message_name);
715: Wf_Engine.SetItemAttrText(
716: ItemType => itemtype,
717: ItemKey => itemkey,
718: aname => 'P_ERROR',
719: avalue => l_message_name

Line 735: Wf_Engine.SetItemAttrText(

731: -- External reference does not match
732: l_error := 'IGS_PE_EXT_REF_MISMATCH';
733: message_get(l_error,l_message_name);
734: CLOSE c_external_hold_exst;
735: Wf_Engine.SetItemAttrText(
736: ItemType => itemtype,
737: ItemKey => itemkey,
738: aname => 'P_ERROR',
739: avalue => l_message_name

Line 785: Wf_Engine.SetItemAttrText(

781:
782: IF l_message_name IS NOT NULL THEN
783:
784: --Hold was NOT released successfully
785: Wf_Engine.SetItemAttrText(
786: ItemType => itemtype,
787: ItemKey => itemkey,
788: aname => 'P_ERROR',
789: avalue => l_message_name

Line 796: Wf_Engine.SetItemAttrText(

792: return;
793: ELSE
794: l_error := 'IGS_GE_UNHANDLED_EXCEPTION';
795: message_get(l_error,l_message_name);
796: Wf_Engine.SetItemAttrText(
797: ItemType => itemtype,
798: ItemKey => itemkey,
799: aname => 'P_ERROR',
800: avalue => l_message_name