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.BEN_CWB_WF_NTF dependencies on HR_UTILITY

Line 268: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc,

264: SELECT user_name
265: FROM fnd_user
266: WHERE employee_id = p_person_id;
267: BEGIN
268: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc,
269: 3000
270: );
271: hr_utility.TRACE ('p_person_id : ' || p_person_id);
272:

Line 271: hr_utility.TRACE ('p_person_id : ' || p_person_id);

267: BEGIN
268: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc,
269: 3000
270: );
271: hr_utility.TRACE ('p_person_id : ' || p_person_id);
272:
273: OPEN c2;
274:
275: FETCH c2

Line 284: hr_utility.TRACE ('fnd person does not exist ' || p_person_id);

280: --10649674
281: if(p_person_id = -99) then
282: l_fnd_user_name := 'SYSADMIN';
283: else
284: hr_utility.TRACE ('fnd person does not exist ' || p_person_id);
285: wf_core.RAISE ('fnd person does not exist ' || p_person_id);
286: end if;
287: END IF;
288:

Line 291: hr_utility.TRACE ('l_fnd_user_name : ' || l_fnd_user_name);

287: END IF;
288:
289: CLOSE c2;
290:
291: hr_utility.TRACE ('l_fnd_user_name : ' || l_fnd_user_name);
292: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc,
293: 3000
294: );
295: RETURN l_fnd_user_name;

Line 292: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc,

288:
289: CLOSE c2;
290:
291: hr_utility.TRACE ('l_fnd_user_name : ' || l_fnd_user_name);
292: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc,
293: 3000
294: );
295: RETURN l_fnd_user_name;
296: EXCEPTION

Line 334: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc, 2000);

330: WHERE item_key = p_item_key
331: AND item_type = g_itemtype
332: AND assigned_user = p_fnd_user_name;
333: BEGIN
334: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc, 2000);
335: hr_utility.TRACE ('p_item_key : ' || p_item_key);
336: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
337:
338: IF p_fnd_user_name IS NULL THEN

Line 335: hr_utility.TRACE ('p_item_key : ' || p_item_key);

331: AND item_type = g_itemtype
332: AND assigned_user = p_fnd_user_name;
333: BEGIN
334: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc, 2000);
335: hr_utility.TRACE ('p_item_key : ' || p_item_key);
336: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
337:
338: IF p_fnd_user_name IS NULL THEN
339: hr_utility.TRACE ('p_fnd_user_name is null');

Line 336: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);

332: AND assigned_user = p_fnd_user_name;
333: BEGIN
334: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc, 2000);
335: hr_utility.TRACE ('p_item_key : ' || p_item_key);
336: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
337:
338: IF p_fnd_user_name IS NULL THEN
339: hr_utility.TRACE ('p_fnd_user_name is null');
340: wf_core.RAISE ('p_fnd_user_name is null');

Line 339: hr_utility.TRACE ('p_fnd_user_name is null');

335: hr_utility.TRACE ('p_item_key : ' || p_item_key);
336: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
337:
338: IF p_fnd_user_name IS NULL THEN
339: hr_utility.TRACE ('p_fnd_user_name is null');
340: wf_core.RAISE ('p_fnd_user_name is null');
341: END IF;
342:
343: OPEN c1;

Line 347: hr_utility.TRACE ( 'Notification id not present for the user '

343: OPEN c1;
344: FETCH c1 INTO l_notification_id;
345:
346: IF c1%NOTFOUND THEN
347: hr_utility.TRACE ( 'Notification id not present for the user '
348: || p_fnd_user_name
349: || 'for the item key'
350: || p_item_key);
351: wf_core.RAISE ( 'Notification id is not present for the user '

Line 358: hr_utility.TRACE ('l_notification_id : ' || l_notification_id);

354: || p_item_key);
355: END IF;
356:
357: CLOSE c1;
358: hr_utility.TRACE ('l_notification_id : ' || l_notification_id);
359: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc, 2000);
360: RETURN l_notification_id;
361: EXCEPTION
362: WHEN OTHERS THEN

Line 359: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc, 2000);

355: END IF;
356:
357: CLOSE c1;
358: hr_utility.TRACE ('l_notification_id : ' || l_notification_id);
359: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc, 2000);
360: RETURN l_notification_id;
361: EXCEPTION
362: WHEN OTHERS THEN
363: wf_core.CONTEXT (g_package

Line 445: hr_utility.set_location ('Entering ' || g_package || ':' || l_proc,

441: l_err_stack VARCHAR2 (32000);
442: l_for_period VARCHAR2(30);
443: l_proc VARCHAR2 (100) := 'set_common_item_attributes';
444: BEGIN
445: hr_utility.set_location ('Entering ' || g_package || ':' || l_proc,
446: 100);
447: l_rcvr_fnd_user_name := get_fnd_user_name (p_rcvr_person_id);
448: hr_utility.TRACE ('l_rcvr_fnd_user_name ' || l_rcvr_fnd_user_name);
449:

Line 448: hr_utility.TRACE ('l_rcvr_fnd_user_name ' || l_rcvr_fnd_user_name);

444: BEGIN
445: hr_utility.set_location ('Entering ' || g_package || ':' || l_proc,
446: 100);
447: l_rcvr_fnd_user_name := get_fnd_user_name (p_rcvr_person_id);
448: hr_utility.TRACE ('l_rcvr_fnd_user_name ' || l_rcvr_fnd_user_name);
449:
450: l_for_period := get_for_period (p_group_per_in_ler_id);
451: hr_utility.TRACE ('l_for_period ' || l_for_period);
452:

Line 451: hr_utility.TRACE ('l_for_period ' || l_for_period);

447: l_rcvr_fnd_user_name := get_fnd_user_name (p_rcvr_person_id);
448: hr_utility.TRACE ('l_rcvr_fnd_user_name ' || l_rcvr_fnd_user_name);
449:
450: l_for_period := get_for_period (p_group_per_in_ler_id);
451: hr_utility.TRACE ('l_for_period ' || l_for_period);
452:
453: l_from_fnd_user_name := get_fnd_user_name (p_from_person_id);
454: hr_utility.TRACE ('l_from_fnd_user_name ' || l_from_fnd_user_name);
455:

Line 454: hr_utility.TRACE ('l_from_fnd_user_name ' || l_from_fnd_user_name);

450: l_for_period := get_for_period (p_group_per_in_ler_id);
451: hr_utility.TRACE ('l_for_period ' || l_for_period);
452:
453: l_from_fnd_user_name := get_fnd_user_name (p_from_person_id);
454: hr_utility.TRACE ('l_from_fnd_user_name ' || l_from_fnd_user_name);
455:
456: wf_engine.setitemattrtext (itemtype => g_itemtype,
457: itemkey => p_item_key,
458: aname => 'MESSAGE_TYPE',

Line 461: hr_utility.TRACE ( ' item attribute MESSAGE_TYPE is set to '

457: itemkey => p_item_key,
458: aname => 'MESSAGE_TYPE',
459: avalue => p_message_type
460: );
461: hr_utility.TRACE ( ' item attribute MESSAGE_TYPE is set to '
462: || p_message_type
463: );
464: wf_engine.setitemattrtext (itemtype => g_itemtype,
465: itemkey => p_item_key,

Line 469: hr_utility.TRACE ( ' item attribute RCVR_USER_NAME is set to '

465: itemkey => p_item_key,
466: aname => 'RCVR_USER_NAME',
467: avalue => l_rcvr_fnd_user_name
468: );
469: hr_utility.TRACE ( ' item attribute RCVR_USER_NAME is set to '
470: || l_rcvr_fnd_user_name
471: );
472: wf_engine.setitemattrtext (itemtype => g_itemtype,
473: itemkey => p_item_key,

Line 478: hr_utility.TRACE ( ' item attribute RCVR_PERSON_NAME is set to '

474: aname => 'RCVR_PERSON_NAME',
475: avalue => get_person_name
476: (p_group_per_in_ler_id)
477: );
478: hr_utility.TRACE ( ' item attribute RCVR_PERSON_NAME is set to '
479: || l_rcvr_fnd_user_name
480: );
481: wf_engine.setitemattrtext
482: (itemtype => 'BENCWBFY',

Line 501: hr_utility.TRACE ( ' item attribute l_for_period is set to '

497: aname => 'FOR_PERIOD',
498: avalue => l_for_period
499: );
500:
501: hr_utility.TRACE ( ' item attribute l_for_period is set to '
502: || l_for_period
503: );
504:
505: hr_utility.TRACE (' item attribute PLAN_NAME is set ');

Line 505: hr_utility.TRACE (' item attribute PLAN_NAME is set ');

501: hr_utility.TRACE ( ' item attribute l_for_period is set to '
502: || l_for_period
503: );
504:
505: hr_utility.TRACE (' item attribute PLAN_NAME is set ');
506: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',
507: itemkey => p_item_key,
508: aname => 'GROUP_PER_IN_LER_ID',
509: avalue => p_group_per_in_ler_id

Line 511: hr_utility.TRACE ( ' item attribute GROUP_PER_IN_LER_ID is set to '

507: itemkey => p_item_key,
508: aname => 'GROUP_PER_IN_LER_ID',
509: avalue => p_group_per_in_ler_id
510: );
511: hr_utility.TRACE ( ' item attribute GROUP_PER_IN_LER_ID is set to '
512: || p_group_per_in_ler_id
513: );
514: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',
515: itemkey => p_item_key,

Line 519: hr_utility.TRACE ( ' item attribute TRANSACTION_ID is set to '

515: itemkey => p_item_key,
516: aname => 'TRANSACTION_ID',
517: avalue => p_transaction_id
518: );
519: hr_utility.TRACE ( ' item attribute TRANSACTION_ID is set to '
520: || p_transaction_id
521: );
522: wf_engine.setitemattrtext (itemtype => g_itemtype,
523: itemkey => p_item_key,

Line 527: hr_utility.TRACE ( ' item attribute FROM_ROLE is set to '

523: itemkey => p_item_key,
524: aname => 'FROM_ROLE',
525: avalue => l_from_fnd_user_name
526: );
527: hr_utility.TRACE ( ' item attribute FROM_ROLE is set to '
528: || l_from_fnd_user_name
529: );
530: hr_utility.set_location ('Exiting ' || g_package || ':' || l_proc, 100);
531: END;

Line 530: hr_utility.set_location ('Exiting ' || g_package || ':' || l_proc, 100);

526: );
527: hr_utility.TRACE ( ' item attribute FROM_ROLE is set to '
528: || l_from_fnd_user_name
529: );
530: hr_utility.set_location ('Exiting ' || g_package || ':' || l_proc, 100);
531: END;
532:
533: PROCEDURE set_access_due_item_attributes (p_item_key IN NUMBER)
534: IS

Line 536: hr_utility.TRACE ('p_item_key ' || p_item_key);

532:
533: PROCEDURE set_access_due_item_attributes (p_item_key IN NUMBER)
534: IS
535: BEGIN
536: hr_utility.TRACE ('p_item_key ' || p_item_key);
537:
538: wf_engine.setitemattrtext (itemtype => g_itemtype,
539: itemkey => p_item_key,
540: aname => 'FYI_COMMENTS',

Line 548: hr_utility.TRACE ('p_item_key ' || p_item_key);

544:
545: PROCEDURE set_appr_ntf_item_attribute (p_item_key IN NUMBER)
546: IS
547: BEGIN
548: hr_utility.TRACE ('p_item_key ' || p_item_key);
549:
550: wf_engine.setitemattrtext (itemtype => g_itemtype,
551: itemkey => p_item_key,
552: aname => 'FYI_COMMENTS',

Line 560: hr_utility.TRACE ('p_item_key ' || p_item_key);

556:
557: PROCEDURE set_iss_budgt_item_attributes (p_item_key IN NUMBER)
558: IS
559: BEGIN
560: hr_utility.TRACE ('p_item_key ' || p_item_key);
561:
562: wf_engine.setitemattrtext (itemtype => g_itemtype,
563: itemkey => p_item_key,
564: aname => 'FYI_COMMENTS',

Line 585: hr_utility.set_location ('Entering ' || g_package || ':' || l_proc, 10);

581: l_err_msg VARCHAR2 (2000);
582: l_err_stack VARCHAR2 (32000);
583: BEGIN
584:
585: hr_utility.set_location ('Entering ' || g_package || ':' || l_proc, 10);
586:
587: --
588: -- A unique itemkey is generated for every workflow transaction
589: --

Line 594: hr_utility.TRACE ('l_itemkey : ' || l_itemkey);

590: SELECT ben_cwb_wf_ntf_s.NEXTVAL
591: INTO l_itemkey
592: FROM DUAL;
593:
594: hr_utility.TRACE ('l_itemkey : ' || l_itemkey);
595:
596: IF l_itemkey IS NULL
597: THEN
598: hr_utility.TRACE ('l_itemkey is null');

Line 598: hr_utility.TRACE ('l_itemkey is null');

594: hr_utility.TRACE ('l_itemkey : ' || l_itemkey);
595:
596: IF l_itemkey IS NULL
597: THEN
598: hr_utility.TRACE ('l_itemkey is null');
599: fnd_message.set_name ('BEN', 'BEN_93399_CWB_NTF_ITEM_KEY_ERR');
600: fnd_message.raise_error;
601: END IF;
602:

Line 605: hr_utility.TRACE ('p_rcvr_person_id is null');

601: END IF;
602:
603: IF p_rcvr_person_id IS NULL
604: THEN
605: hr_utility.TRACE ('p_rcvr_person_id is null');
606: fnd_message.set_name ('BEN', 'BEN_93400_CWB_NTF_NO_PERSON_ID');
607: fnd_message.raise_error;
608: END IF;
609:

Line 610: hr_utility.TRACE ('p_rcvr_person_id : ' || p_rcvr_person_id);

606: fnd_message.set_name ('BEN', 'BEN_93400_CWB_NTF_NO_PERSON_ID');
607: fnd_message.raise_error;
608: END IF;
609:
610: hr_utility.TRACE ('p_rcvr_person_id : ' || p_rcvr_person_id);
611:
612: BEGIN
613: wf_engine.createprocess (itemtype => g_itemtype,
614: itemkey => l_itemkey,

Line 617: hr_utility.TRACE ( 'Workflow process '

613: wf_engine.createprocess (itemtype => g_itemtype,
614: itemkey => l_itemkey,
615: process => g_wfprocess
616: );
617: hr_utility.TRACE ( 'Workflow process '
618: || g_wfprocess
619: || ' for itemtype '
620: || g_itemtype
621: || ' itemkey '

Line 632: hr_utility.TRACE ( 'Following Workflow error has occured'

628: wf_core.get_error (l_err_name, l_err_msg, l_err_stack);
629:
630: IF (l_err_name IS NOT NULL)
631: THEN
632: hr_utility.TRACE ( 'Following Workflow error has occured'
633: || l_err_msg
634: || 'Error stack for this is '
635: || l_err_stack
636: );

Line 646: hr_utility.TRACE

642: );
643: wf_core.CLEAR;
644: fnd_message.raise_error;
645: ELSE
646: hr_utility.TRACE
647: ( 'A general error has occured while creating the workflow process '
648: || 'and it is not a worflow error'
649: );
650: fnd_message.set_name ('BEN', 'BEN_93402_CWB_NTF_CRE_PROC_ERR');

Line 666: hr_utility.TRACE ('common item attributes are set');

662: p_from_person_id => p_from_person_id,
663: p_group_per_in_ler_id => p_group_per_in_ler_id,
664: p_transaction_id => p_transaction_id
665: );
666: hr_utility.TRACE ('common item attributes are set');
667:
668: --
669: -- setting issued budget item attributes.
670: --

Line 676: hr_utility.TRACE

672: OR p_message_type = 'BUDGET_ISSUED_LLM'
673: )
674: THEN
675: set_iss_budgt_item_attributes (p_item_key => l_itemkey);
676: hr_utility.TRACE
677: ('issued budget item attributes are set successfully');
678: END IF;
679:
680: --

Line 686: hr_utility.TRACE ('approval item attributes are set successfully');

682: --
683: IF (p_message_type = 'WS_REJECTED')
684: THEN
685: set_appr_ntf_item_attribute (p_item_key => l_itemkey);
686: hr_utility.TRACE ('approval item attributes are set successfully');
687: END IF;
688:
689: --
690:

Line 695: hr_utility.TRACE ('RECALLED item attributes are set successfully');

691: --
692: IF (p_message_type = 'WS_RECALLED')
693: THEN
694: set_appr_ntf_item_attribute (p_item_key => l_itemkey);
695: hr_utility.TRACE ('RECALLED item attributes are set successfully');
696: END IF;
697:
698: --
699: -- setting access and due dates item attributes.

Line 704: hr_utility.TRACE

700: --
701: IF (p_message_type = 'ACCESS')
702: THEN
703: set_access_due_item_attributes (p_item_key => l_itemkey);
704: hr_utility.TRACE
705: ('access and due dates item attributes are set successfully');
706: END IF;
707:
708: IF (p_message_type = 'WS_SUBMITTED')

Line 711: hr_utility.TRACE

707:
708: IF (p_message_type = 'WS_SUBMITTED')
709: THEN
710: set_appr_ntf_item_attribute (p_item_key => l_itemkey);
711: hr_utility.TRACE
712: ('ws submitted item attributes are set successfully');
713: END IF;
714:
715: BEGIN

Line 718: hr_utility.TRACE ( 'Workflow process '

714:
715: BEGIN
716: wf_engine.startprocess (itemtype => g_itemtype,
717: itemkey => l_itemkey);
718: hr_utility.TRACE ( 'Workflow process '
719: || g_wfprocess
720: || ' for itemtype '
721: || g_itemtype
722: || ' itemkey '

Line 733: hr_utility.TRACE ( 'Following Workflow error has occured'

729: wf_core.get_error (l_err_name, l_err_msg, l_err_stack);
730:
731: IF (l_err_name IS NOT NULL)
732: THEN
733: hr_utility.TRACE ( 'Following Workflow error has occured'
734: || l_err_msg
735: || 'Follwing is the error stack '
736: || l_err_stack
737: );

Line 747: hr_utility.TRACE

743: );
744: wf_core.CLEAR;
745: fnd_message.raise_error;
746: ELSE
747: hr_utility.TRACE
748: ( 'A general error has occured while starting the workflow process '
749: || 'and it is not a worflow error'
750: );
751: fnd_message.set_name ('BEN', 'BEN_93404_CWB_NTF_STRT_PRC_ERR');

Line 757: hr_utility.set_location ('Exiting ' || g_package || ':' || l_proc, 10);

753: fnd_message.raise_error;
754: END IF;
755: END;
756:
757: hr_utility.set_location ('Exiting ' || g_package || ':' || l_proc, 10);
758: EXCEPTION
759: WHEN OTHERS
760: THEN
761: RAISE;

Line 801: hr_utility.set_location (l_proc || ' Entering ', 10);

797:
798: l_proc VARCHAR2 (61) := g_package || ':' || 'plan_comp_ntf';
799: l_itemkey NUMBER;
800: BEGIN
801: hr_utility.set_location (l_proc || ' Entering ', 10);
802:
803: FOR i IN c1
804: LOOP
805: hr_utility.set_location ('checking people for role ' || i.role_name,

Line 805: hr_utility.set_location ('checking people for role ' || i.role_name,

801: hr_utility.set_location (l_proc || ' Entering ', 10);
802:
803: FOR i IN c1
804: LOOP
805: hr_utility.set_location ('checking people for role ' || i.role_name,
806: 20
807: );
808:
809: FOR j IN c2 (i.role_id)

Line 811: hr_utility.set_location ( 'person '

807: );
808:
809: FOR j IN c2 (i.role_id)
810: LOOP
811: hr_utility.set_location ( 'person '
812: || j.person_name
813: || ' has this role ',
814: 20
815: );

Line 816: hr_utility.set_location ('user ' || j.user_name

812: || j.person_name
813: || ' has this role ',
814: 20
815: );
816: hr_utility.set_location ('user ' || j.user_name
817: || ' has this role ',
818: 20
819: );
820: cwb_fyi_ntf_api (p_transaction_id => p_transaction_id,

Line 829: hr_utility.set_location (l_proc || ' Exiting ', 100);

825: );
826: END LOOP;
827: END LOOP;
828:
829: hr_utility.set_location (l_proc || ' Exiting ', 100);
830: END;
831:
832: PROCEDURE which_message (
833: itemtype IN VARCHAR2,

Line 843: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc,

839: IS
840: l_message_type VARCHAR2 (60);
841: l_proc VARCHAR2 (100) := 'which_message';
842: BEGIN
843: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc,
844: 10000
845: );
846: hr_utility.TRACE ('itemtype : ' || itemtype);
847: hr_utility.TRACE ('itemkey : ' || itemkey);

Line 846: hr_utility.TRACE ('itemtype : ' || itemtype);

842: BEGIN
843: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc,
844: 10000
845: );
846: hr_utility.TRACE ('itemtype : ' || itemtype);
847: hr_utility.TRACE ('itemkey : ' || itemkey);
848: hr_utility.TRACE ('actid : ' || actid);
849: hr_utility.TRACE ('funcmode : ' || funcmode);
850:

Line 847: hr_utility.TRACE ('itemkey : ' || itemkey);

843: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc,
844: 10000
845: );
846: hr_utility.TRACE ('itemtype : ' || itemtype);
847: hr_utility.TRACE ('itemkey : ' || itemkey);
848: hr_utility.TRACE ('actid : ' || actid);
849: hr_utility.TRACE ('funcmode : ' || funcmode);
850:
851: IF (funcmode = 'RUN')

Line 848: hr_utility.TRACE ('actid : ' || actid);

844: 10000
845: );
846: hr_utility.TRACE ('itemtype : ' || itemtype);
847: hr_utility.TRACE ('itemkey : ' || itemkey);
848: hr_utility.TRACE ('actid : ' || actid);
849: hr_utility.TRACE ('funcmode : ' || funcmode);
850:
851: IF (funcmode = 'RUN')
852: THEN

Line 849: hr_utility.TRACE ('funcmode : ' || funcmode);

845: );
846: hr_utility.TRACE ('itemtype : ' || itemtype);
847: hr_utility.TRACE ('itemkey : ' || itemkey);
848: hr_utility.TRACE ('actid : ' || actid);
849: hr_utility.TRACE ('funcmode : ' || funcmode);
850:
851: IF (funcmode = 'RUN')
852: THEN
853: l_message_type :=

Line 877: hr_utility.TRACE ('l_message_type : ' || l_message_type);

873: RESULT := 'COMPLETE';
874: RETURN;
875: END IF;
876:
877: hr_utility.TRACE ('l_message_type : ' || l_message_type);
878: RESULT := '';
879: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc,
880: 10000
881: );

Line 879: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc,

875: END IF;
876:
877: hr_utility.TRACE ('l_message_type : ' || l_message_type);
878: RESULT := '';
879: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc,
880: 10000
881: );
882: RETURN;
883: EXCEPTION