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.WF_DIRECTORY dependencies on WF_CORE

Line 25: wf_directory.g_system_status:= wf_core.translate('WF_SYSTEM_STATUS');

21: return varchar2
22: is
23: begin
24: if wf_directory.g_system_status is null then
25: wf_directory.g_system_status:= wf_core.translate('WF_SYSTEM_STATUS');
26: end if;
27: return wf_directory.g_system_status;
28: end;
29: --

Line 167: wf_core.context('Wf_Directory','CompositeName',p_CompositeName);

163: when invalidNumConv then
164: return FALSE;
165:
166: when others then
167: wf_core.context('Wf_Directory','CompositeName',p_CompositeName);
168: raise;
169: end;
170:
171: --

Line 226: wf_core.context('Wf_Directory','GetRoleUsers',Role);

222: close c;
223: elsif corig%ISOPEN then
224: close corig;
225: end if;
226: wf_core.context('Wf_Directory','GetRoleUsers',Role);
227: raise;
228: end GetRoleUsers;
229:
230: --

Line 253: wf_core.context('Wf_Directory','GetUserRelation',base_user,relation);

249: begin
250: null;
251: exception
252: when others then
253: wf_core.context('Wf_Directory','GetUserRelation',base_user,relation);
254: raise;
255: end GetUserRelation;
256:
257: --

Line 305: wf_core.context('Wf_Directory','GetUserRoles',User);

301: elsif (corig%ISOPEN) then
302: close corig;
303: end if;
304:
305: wf_core.context('Wf_Directory','GetUserRoles',User);
306: raise;
307: end GetUserRoles;
308:
309: --

Line 341: wf_core.context('Wf_Directory','GetRoleInfo',Role);

337: territory := role_info_tbl(1).territory;
338:
339: exception
340: when others then
341: wf_core.context('Wf_Directory','GetRoleInfo',Role);
342: raise;
343: end GetRoleInfo;
344:
345: --

Line 424: wf_core.nls_date_format, -- <7578908> new NLS parameters

420: substrb(R.DESCRIPTION,1,1000),
421: R.NOTIFICATION_PREFERENCE,
422: R.LANGUAGE,
423: R.TERRITORY,
424: wf_core.nls_date_format, -- <7578908> new NLS parameters
425: R.LANGUAGE, -- default nls_date_language
426: wf_core.nls_calendar ,
427: wf_core.nls_numeric_characters,
428: wf_core.nls_sort,

Line 426: wf_core.nls_calendar ,

422: R.LANGUAGE,
423: R.TERRITORY,
424: wf_core.nls_date_format, -- <7578908> new NLS parameters
425: R.LANGUAGE, -- default nls_date_language
426: wf_core.nls_calendar ,
427: wf_core.nls_numeric_characters,
428: wf_core.nls_sort,
429: wf_core.nls_currency, --
430: substrb(R.EMAIL_ADDRESS,1,320),

Line 427: wf_core.nls_numeric_characters,

423: R.TERRITORY,
424: wf_core.nls_date_format, -- <7578908> new NLS parameters
425: R.LANGUAGE, -- default nls_date_language
426: wf_core.nls_calendar ,
427: wf_core.nls_numeric_characters,
428: wf_core.nls_sort,
429: wf_core.nls_currency, --
430: substrb(R.EMAIL_ADDRESS,1,320),
431: R.FAX,

Line 428: wf_core.nls_sort,

424: wf_core.nls_date_format, -- <7578908> new NLS parameters
425: R.LANGUAGE, -- default nls_date_language
426: wf_core.nls_calendar ,
427: wf_core.nls_numeric_characters,
428: wf_core.nls_sort,
429: wf_core.nls_currency, --
430: substrb(R.EMAIL_ADDRESS,1,320),
431: R.FAX,
432: R.STATUS,

Line 429: wf_core.nls_currency, --

425: R.LANGUAGE, -- default nls_date_language
426: wf_core.nls_calendar ,
427: wf_core.nls_numeric_characters,
428: wf_core.nls_sort,
429: wf_core.nls_currency, --
430: substrb(R.EMAIL_ADDRESS,1,320),
431: R.FAX,
432: R.STATUS,
433: R.EXPIRATION_DATE,

Line 462: wf_core.nls_date_format, -- <7578908> new NLS parameters

458: substrb(R.DESCRIPTION,1,1000),
459: R.NOTIFICATION_PREFERENCE,
460: R.LANGUAGE,
461: R.TERRITORY,
462: wf_core.nls_date_format, -- <7578908> new NLS parameters
463: R.LANGUAGE, -- default nls_date_language
464: wf_core.nls_calendar ,
465: wf_core.nls_numeric_characters,
466: wf_core.nls_sort,

Line 464: wf_core.nls_calendar ,

460: R.LANGUAGE,
461: R.TERRITORY,
462: wf_core.nls_date_format, -- <7578908> new NLS parameters
463: R.LANGUAGE, -- default nls_date_language
464: wf_core.nls_calendar ,
465: wf_core.nls_numeric_characters,
466: wf_core.nls_sort,
467: wf_core.nls_currency, --
468: substrb(R.EMAIL_ADDRESS,1,320),

Line 465: wf_core.nls_numeric_characters,

461: R.TERRITORY,
462: wf_core.nls_date_format, -- <7578908> new NLS parameters
463: R.LANGUAGE, -- default nls_date_language
464: wf_core.nls_calendar ,
465: wf_core.nls_numeric_characters,
466: wf_core.nls_sort,
467: wf_core.nls_currency, --
468: substrb(R.EMAIL_ADDRESS,1,320),
469: R.FAX,

Line 466: wf_core.nls_sort,

462: wf_core.nls_date_format, -- <7578908> new NLS parameters
463: R.LANGUAGE, -- default nls_date_language
464: wf_core.nls_calendar ,
465: wf_core.nls_numeric_characters,
466: wf_core.nls_sort,
467: wf_core.nls_currency, --
468: substrb(R.EMAIL_ADDRESS,1,320),
469: R.FAX,
470: R.STATUS,

Line 467: wf_core.nls_currency, --

463: R.LANGUAGE, -- default nls_date_language
464: wf_core.nls_calendar ,
465: wf_core.nls_numeric_characters,
466: wf_core.nls_sort,
467: wf_core.nls_currency, --
468: substrb(R.EMAIL_ADDRESS,1,320),
469: R.FAX,
470: R.STATUS,
471: R.EXPIRATION_DATE,

Line 516: wf_core.nls_date_format, -- <7578908> new NLS parameters

512: substrb(R.DESCRIPTION,1,1000),
513: R.NOTIFICATION_PREFERENCE,
514: R.LANGUAGE,
515: R.TERRITORY,
516: wf_core.nls_date_format, -- <7578908> new NLS parameters
517: R.LANGUAGE, -- default nls_date_language
518: wf_core.nls_calendar ,
519: wf_core.nls_numeric_characters,
520: wf_core.nls_sort,

Line 518: wf_core.nls_calendar ,

514: R.LANGUAGE,
515: R.TERRITORY,
516: wf_core.nls_date_format, -- <7578908> new NLS parameters
517: R.LANGUAGE, -- default nls_date_language
518: wf_core.nls_calendar ,
519: wf_core.nls_numeric_characters,
520: wf_core.nls_sort,
521: wf_core.nls_currency, --
522: substrb(R.EMAIL_ADDRESS,1,320),

Line 519: wf_core.nls_numeric_characters,

515: R.TERRITORY,
516: wf_core.nls_date_format, -- <7578908> new NLS parameters
517: R.LANGUAGE, -- default nls_date_language
518: wf_core.nls_calendar ,
519: wf_core.nls_numeric_characters,
520: wf_core.nls_sort,
521: wf_core.nls_currency, --
522: substrb(R.EMAIL_ADDRESS,1,320),
523: R.FAX,

Line 520: wf_core.nls_sort,

516: wf_core.nls_date_format, -- <7578908> new NLS parameters
517: R.LANGUAGE, -- default nls_date_language
518: wf_core.nls_calendar ,
519: wf_core.nls_numeric_characters,
520: wf_core.nls_sort,
521: wf_core.nls_currency, --
522: substrb(R.EMAIL_ADDRESS,1,320),
523: R.FAX,
524: R.STATUS,

Line 521: wf_core.nls_currency, --

517: R.LANGUAGE, -- default nls_date_language
518: wf_core.nls_calendar ,
519: wf_core.nls_numeric_characters,
520: wf_core.nls_sort,
521: wf_core.nls_currency, --
522: substrb(R.EMAIL_ADDRESS,1,320),
523: R.FAX,
524: R.STATUS,
525: R.EXPIRATION_DATE,

Line 552: wf_core.nls_date_format, -- <7578908> new NLS parameters

548: substrb(R.DESCRIPTION,1,1000),
549: R.NOTIFICATION_PREFERENCE,
550: R.LANGUAGE,
551: R.TERRITORY,
552: wf_core.nls_date_format, -- <7578908> new NLS parameters
553: R.LANGUAGE, -- default nls_date_language
554: wf_core.nls_calendar ,
555: wf_core.nls_numeric_characters,
556: wf_core.nls_sort,

Line 554: wf_core.nls_calendar ,

550: R.LANGUAGE,
551: R.TERRITORY,
552: wf_core.nls_date_format, -- <7578908> new NLS parameters
553: R.LANGUAGE, -- default nls_date_language
554: wf_core.nls_calendar ,
555: wf_core.nls_numeric_characters,
556: wf_core.nls_sort,
557: wf_core.nls_currency, --
558: substrb(R.EMAIL_ADDRESS,1,320),

Line 555: wf_core.nls_numeric_characters,

551: R.TERRITORY,
552: wf_core.nls_date_format, -- <7578908> new NLS parameters
553: R.LANGUAGE, -- default nls_date_language
554: wf_core.nls_calendar ,
555: wf_core.nls_numeric_characters,
556: wf_core.nls_sort,
557: wf_core.nls_currency, --
558: substrb(R.EMAIL_ADDRESS,1,320),
559: R.FAX,

Line 556: wf_core.nls_sort,

552: wf_core.nls_date_format, -- <7578908> new NLS parameters
553: R.LANGUAGE, -- default nls_date_language
554: wf_core.nls_calendar ,
555: wf_core.nls_numeric_characters,
556: wf_core.nls_sort,
557: wf_core.nls_currency, --
558: substrb(R.EMAIL_ADDRESS,1,320),
559: R.FAX,
560: R.STATUS,

Line 557: wf_core.nls_currency, --

553: R.LANGUAGE, -- default nls_date_language
554: wf_core.nls_calendar ,
555: wf_core.nls_numeric_characters,
556: wf_core.nls_sort,
557: wf_core.nls_currency, --
558: substrb(R.EMAIL_ADDRESS,1,320),
559: R.FAX,
560: R.STATUS,
561: R.EXPIRATION_DATE,

Line 620: wf_core.context('Wf_Directory','GetRoleInfo2',Role);

616: end if;
617: end;
618:
619: when others then
620: wf_core.context('Wf_Directory','GetRoleInfo2',Role);
621: raise;
622: end GetRoleInfo2;
623:
624: --

Line 676: wf_core.context('Wf_Directory','GetRoleInfoMail',Role);

672: end;
673:
674: exception
675: when others then
676: wf_core.context('Wf_Directory','GetRoleInfoMail',Role);
677: raise;
678: end GetRoleInfoMail;
679:
680: procedure GetRoleInfoMail2( p_role in varchar2,

Line 736: wf_core.context('Wf_Directory','GetRoleInfoMail2', p_role);

732: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
733: end if;
734: exception
735: when others then
736: wf_core.context('Wf_Directory','GetRoleInfoMail2', p_role);
737: raise;
738: end GetRoleInfoMail2;
739:
740: --

Line 761: wf_core.context('Wf_Directory','GetRoleNotePref',Role);

757:
758: return notification_preference;
759: exception
760: when others then
761: wf_core.context('Wf_Directory','GetRoleNotePref',Role);
762: raise;
763: end GetRoleNtfPref;
764:
765: --

Line 789: wf_core.context('Wf_Directory','GetRoleOrigSysInfo',Role);

785: orig_system_id := role_info_tbl(1).orig_system_id;
786:
787: exception
788: when others then
789: wf_core.context('Wf_Directory','GetRoleOrigSysInfo',Role);
790: raise;
791: end GetRoleOrigSysInfo;
792:
793: --

Line 877: wf_core.context('Wf_Directory','GetRolePartitionInfo',role);

873: partition_id := -1;
874: orig_system := null;
875: display_name := null;
876: when others then
877: wf_core.context('Wf_Directory','GetRolePartitionInfo',role);
878: raise;
879: end;
880: when others then
881: wf_core.context('Wf_Directory','GetRolePartitionInfo',role);

Line 881: wf_core.context('Wf_Directory','GetRolePartitionInfo',role);

877: wf_core.context('Wf_Directory','GetRolePartitionInfo',role);
878: raise;
879: end;
880: when others then
881: wf_core.context('Wf_Directory','GetRolePartitionInfo',role);
882: raise;
883: end GetRolePartitionInfo;
884:
885: --

Line 970: wf_core.context('Wf_Directory','IsPerformer',User,Role);

966: exception
967: when no_data_found then
968: return FALSE;
969: when others then
970: wf_core.context('Wf_Directory','IsPerformer',User,Role);
971: raise;
972: end IsPerformer;
973:
974: --

Line 986: wf_core.context('Wf_Directory','CurrentUser');

982: begin
983: return NULL;
984: exception
985: when others then
986: wf_core.context('Wf_Directory','CurrentUser');
987: raise;
988: end CurrentUser;
989:
990: --

Line 1035: wf_core.context('Wf_Directory','UserActive',Username);

1031: exception
1032: when no_data_found then
1033: return FALSE;
1034: when others then
1035: wf_core.context('Wf_Directory','UserActive',Username);
1036: raise;
1037: end UserActive;
1038:
1039: --

Line 1085: wf_core.context('Wf_Directory','RoleActive',p_rolename);

1081: exception
1082: when no_data_found then
1083: return FALSE;
1084: when others then
1085: wf_core.context('Wf_Directory','RoleActive',p_rolename);
1086: raise;
1087: end RoleActive;
1088:
1089: --

Line 1119: wf_core.context('Wf_Directory','GetUserName', p_orig_system,

1115: fetch c_user into p_name, p_display_name;
1116: close c_user;
1117: exception
1118: when others then
1119: wf_core.context('Wf_Directory','GetUserName', p_orig_system,
1120: p_orig_system_id);
1121: raise;
1122: end GetuserName;
1123:

Line 1153: wf_core.context('Wf_Directory','GetRoleName',p_orig_system,p_orig_system);

1149: fetch c_role into p_name,p_display_name;
1150: close c_role;
1151: exception
1152: when others then
1153: wf_core.context('Wf_Directory','GetRoleName',p_orig_system,p_orig_system);
1154: raise;
1155: end GetRoleName;
1156:
1157: --

Line 1315: wf_core.context('Wf_Directory', 'SetAdHocUserStatus', user_name, status);

1311: status=>SetAdHocUserStatus.status);
1312:
1313: exception
1314: when others then
1315: wf_core.context('Wf_Directory', 'SetAdHocUserStatus', user_name, status);
1316: raise;
1317: end SetAdHocUserStatus;
1318:
1319: --

Line 1348: wf_core.context('Wf_Directory', 'SetAdHocRoleStatus', role_name, status);

1344: status=>SetAdHocRoleStatus.status);
1345:
1346: exception
1347: when others then
1348: wf_core.context('Wf_Directory', 'SetAdHocRoleStatus', role_name, status);
1349: raise;
1350: end SetAdHocRoleStatus;
1351:
1352:

Line 1424: WF_CORE.Token('NAME', name);

1420: -- If concat name is passed, check to make sure it is valid.
1421: --
1422: if ( instr(name, ':') > 0 ) then
1423: if ( (orig_system||':'||orig_system_id ) <> name) then
1424: WF_CORE.Token('NAME', name);
1425: WF_CORE.Token('ORIG_SYSTEM', orig_system);
1426: WF_CORE.Token('ORIG_SYS_ID', orig_system_id);
1427: WF_CORE.Raise('WF_INVAL_CONCAT_NAME');
1428:

Line 1425: WF_CORE.Token('ORIG_SYSTEM', orig_system);

1421: --
1422: if ( instr(name, ':') > 0 ) then
1423: if ( (orig_system||':'||orig_system_id ) <> name) then
1424: WF_CORE.Token('NAME', name);
1425: WF_CORE.Token('ORIG_SYSTEM', orig_system);
1426: WF_CORE.Token('ORIG_SYS_ID', orig_system_id);
1427: WF_CORE.Raise('WF_INVAL_CONCAT_NAME');
1428:
1429: end if;

Line 1426: WF_CORE.Token('ORIG_SYS_ID', orig_system_id);

1422: if ( instr(name, ':') > 0 ) then
1423: if ( (orig_system||':'||orig_system_id ) <> name) then
1424: WF_CORE.Token('NAME', name);
1425: WF_CORE.Token('ORIG_SYSTEM', orig_system);
1426: WF_CORE.Token('ORIG_SYS_ID', orig_system_id);
1427: WF_CORE.Raise('WF_INVAL_CONCAT_NAME');
1428:
1429: end if;
1430:

Line 1427: WF_CORE.Raise('WF_INVAL_CONCAT_NAME');

1423: if ( (orig_system||':'||orig_system_id ) <> name) then
1424: WF_CORE.Token('NAME', name);
1425: WF_CORE.Token('ORIG_SYSTEM', orig_system);
1426: WF_CORE.Token('ORIG_SYS_ID', orig_system_id);
1427: WF_CORE.Raise('WF_INVAL_CONCAT_NAME');
1428:
1429: end if;
1430:
1431: end if;

Line 1438: WF_CORE.Token('ROLENAME', name);

1434: -- Make sure no '#' or '/' exist in name.
1435: --
1436: /* Bug 2779747
1437: if ( (instr(name, '/') > 0) or (instr(name, '#') > 0) ) then
1438: WF_CORE.Token('ROLENAME', name);
1439: WF_CORE.Raise('WF_INVALID_ROLE');
1440: */
1441:
1442: --

Line 1439: WF_CORE.Raise('WF_INVALID_ROLE');

1435: --
1436: /* Bug 2779747
1437: if ( (instr(name, '/') > 0) or (instr(name, '#') > 0) ) then
1438: WF_CORE.Token('ROLENAME', name);
1439: WF_CORE.Raise('WF_INVALID_ROLE');
1440: */
1441:
1442: --
1443: -- Make sure the length of the name is <= 320

Line 1446: WF_CORE.Token('NAME', name);

1442: --
1443: -- Make sure the length of the name is <= 320
1444: --
1445: if ( lengthb(name) > 320 ) then
1446: WF_CORE.Token('NAME', name);
1447: WF_CORE.Token('LENGTH', 320);
1448: WF_CORE.Raise('WF_ROLENAME_TOO_LONG');
1449:
1450: end if;

Line 1447: WF_CORE.Token('LENGTH', 320);

1443: -- Make sure the length of the name is <= 320
1444: --
1445: if ( lengthb(name) > 320 ) then
1446: WF_CORE.Token('NAME', name);
1447: WF_CORE.Token('LENGTH', 320);
1448: WF_CORE.Raise('WF_ROLENAME_TOO_LONG');
1449:
1450: end if;
1451:

Line 1448: WF_CORE.Raise('WF_ROLENAME_TOO_LONG');

1444: --
1445: if ( lengthb(name) > 320 ) then
1446: WF_CORE.Token('NAME', name);
1447: WF_CORE.Token('LENGTH', 320);
1448: WF_CORE.Raise('WF_ROLENAME_TOO_LONG');
1449:
1450: end if;
1451:
1452: --

Line 1458: WF_CORE.Token('STATUS', CreateUser.status);

1454: --
1455: if ( CreateUser.status not in ('ACTIVE', 'TMPLEAVE', 'EXTLEAVE',
1456: 'INACTIVE') ) then
1457:
1458: WF_CORE.Token('STATUS', CreateUser.status);
1459: WF_CORE.Raise('WF_INVALID_ROLE_STATUS');
1460:
1461: end if;
1462:

Line 1459: WF_CORE.Raise('WF_INVALID_ROLE_STATUS');

1455: if ( CreateUser.status not in ('ACTIVE', 'TMPLEAVE', 'EXTLEAVE',
1456: 'INACTIVE') ) then
1457:
1458: WF_CORE.Token('STATUS', CreateUser.status);
1459: WF_CORE.Raise('WF_INVALID_ROLE_STATUS');
1460:
1461: end if;
1462:
1463: --

Line 1475: WF_CORE.Token('NTF_PREF', CreateUser.notification_preference);

1471: l_ntfPref := 'MAILHTML';
1472: end if;
1473: elsif (CreateUser.notification_preference not in ('MAILHTML','MAILHTM2',
1474: 'MAILATTH', 'SUMMARY', 'SUMHTML', 'QUERY', 'MAILTEXT','DISABLED')) then
1475: WF_CORE.Token('NTF_PREF', CreateUser.notification_preference);
1476: WF_CORE.Raise('WF_INVALID_NTF_PREF');
1477: else
1478: l_ntfPref := CreateUser.notification_preference;
1479: end if;

Line 1476: WF_CORE.Raise('WF_INVALID_NTF_PREF');

1472: end if;
1473: elsif (CreateUser.notification_preference not in ('MAILHTML','MAILHTM2',
1474: 'MAILATTH', 'SUMMARY', 'SUMHTML', 'QUERY', 'MAILTEXT','DISABLED')) then
1475: WF_CORE.Token('NTF_PREF', CreateUser.notification_preference);
1476: WF_CORE.Raise('WF_INVALID_NTF_PREF');
1477: else
1478: l_ntfPref := CreateUser.notification_preference;
1479: end if;
1480:

Line 1491: wf_core.raise('WF_NO_LANG_TERR');

1487: from WF_LANGUAGES
1488: where code = userenv('LANG');
1489: exception
1490: when NO_DATA_FOUND then
1491: wf_core.raise('WF_NO_LANG_TERR');
1492: end;
1493:
1494: end if;
1495:

Line 1517: WF_CORE.Token('NAME', CreateUser.name);

1513: and ORIG_SYSTEM_ID <> CreateUser.orig_system_id;
1514: end if;
1515:
1516: if (l_count > 0) then
1517: WF_CORE.Token('NAME', CreateUser.name);
1518: WF_CORE.Token('ORIG_SYSTEM', l_origSys);
1519: WF_CORE.Raise('WFDS_DUPLICATE_NAME');
1520: end if;
1521: --

Line 1518: WF_CORE.Token('ORIG_SYSTEM', l_origSys);

1514: end if;
1515:
1516: if (l_count > 0) then
1517: WF_CORE.Token('NAME', CreateUser.name);
1518: WF_CORE.Token('ORIG_SYSTEM', l_origSys);
1519: WF_CORE.Raise('WFDS_DUPLICATE_NAME');
1520: end if;
1521: --
1522: -- Evaluating the WHO columns in case they are not passed

Line 1519: WF_CORE.Raise('WFDS_DUPLICATE_NAME');

1515:
1516: if (l_count > 0) then
1517: WF_CORE.Token('NAME', CreateUser.name);
1518: WF_CORE.Token('ORIG_SYSTEM', l_origSys);
1519: WF_CORE.Raise('WFDS_DUPLICATE_NAME');
1520: end if;
1521: --
1522: -- Evaluating the WHO columns in case they are not passed
1523:

Line 1645: if (WF_CORE.error_name = 'WF_DUP_USER_ROLE') then

1641: last_update_login=>CreateUser.last_update_login);
1642:
1643: exception
1644: when OTHERS then
1645: if (WF_CORE.error_name = 'WF_DUP_USER_ROLE') then
1646: SetUserRoleAttr(user_name=>CreateUser.name,
1647: role_name=>CreateUser.name,
1648: user_orig_system=>l_origSys,
1649: user_orig_system_id=>CreateUser.orig_system_id,

Line 1672: WF_CORE.Token('DISPNAME', CreateUser.display_name);

1668: end if;
1669: end;
1670: exception
1671: when DUP_VAL_ON_INDEX then
1672: WF_CORE.Token('DISPNAME', CreateUser.display_name);
1673: WF_CORE.Token('USERNAME', nvl(CreateUser.name,
1674: l_origSys || ':' ||
1675: CreateUser.orig_system_id));
1676: WF_CORE.Raise('WF_DUP_USER');

Line 1673: WF_CORE.Token('USERNAME', nvl(CreateUser.name,

1669: end;
1670: exception
1671: when DUP_VAL_ON_INDEX then
1672: WF_CORE.Token('DISPNAME', CreateUser.display_name);
1673: WF_CORE.Token('USERNAME', nvl(CreateUser.name,
1674: l_origSys || ':' ||
1675: CreateUser.orig_system_id));
1676: WF_CORE.Raise('WF_DUP_USER');
1677:

Line 1676: WF_CORE.Raise('WF_DUP_USER');

1672: WF_CORE.Token('DISPNAME', CreateUser.display_name);
1673: WF_CORE.Token('USERNAME', nvl(CreateUser.name,
1674: l_origSys || ':' ||
1675: CreateUser.orig_system_id));
1676: WF_CORE.Raise('WF_DUP_USER');
1677:
1678: when others then
1679: wf_core.context('Wf_Directory', 'CreateUser', CreateUser.Name,
1680: l_origSys, CreateUser.orig_system_id );

Line 1679: wf_core.context('Wf_Directory', 'CreateUser', CreateUser.Name,

1675: CreateUser.orig_system_id));
1676: WF_CORE.Raise('WF_DUP_USER');
1677:
1678: when others then
1679: wf_core.context('Wf_Directory', 'CreateUser', CreateUser.Name,
1680: l_origSys, CreateUser.orig_system_id );
1681: raise;
1682: end CreateUser;
1683:

Line 1730: wf_core.token('USERNAME', CreateAdHocUser.name);

1726: from wf_users u
1727: where u.name = CreateAdHocUser.name
1728: or u.display_name = CreateAdHocUser.display_name;
1729: if (d1 > 0) then
1730: wf_core.token('USERNAME', CreateAdHocUser.name);
1731: wf_core.token('DISPNAME', CreateAdHocUser.display_name);
1732: wf_core.raise('WF_DUP_USER');
1733: end if;
1734:

Line 1731: wf_core.token('DISPNAME', CreateAdHocUser.display_name);

1727: where u.name = CreateAdHocUser.name
1728: or u.display_name = CreateAdHocUser.display_name;
1729: if (d1 > 0) then
1730: wf_core.token('USERNAME', CreateAdHocUser.name);
1731: wf_core.token('DISPNAME', CreateAdHocUser.display_name);
1732: wf_core.raise('WF_DUP_USER');
1733: end if;
1734:
1735: */

Line 1732: wf_core.raise('WF_DUP_USER');

1728: or u.display_name = CreateAdHocUser.display_name;
1729: if (d1 > 0) then
1730: wf_core.token('USERNAME', CreateAdHocUser.name);
1731: wf_core.token('DISPNAME', CreateAdHocUser.display_name);
1732: wf_core.raise('WF_DUP_USER');
1733: end if;
1734:
1735: */
1736:

Line 1772: wf_core.context('Wf_Directory', 'CreateAdHocUser');

1768:
1769:
1770: exception
1771: when others then
1772: wf_core.context('Wf_Directory', 'CreateAdHocUser');
1773: raise;
1774: end CreateAdHocUser;
1775:
1776:

Line 1845: WF_CORE.Token('NAME', role_name);

1841: -- If concat role_name is passed, check to make sure it is valid.
1842: --
1843: if ( instr(role_name, ':') > 0 ) then
1844: if ( (orig_system||':'||orig_system_id ) <> role_name) then
1845: WF_CORE.Token('NAME', role_name);
1846: WF_CORE.Token('ORIG_SYSTEM', orig_system);
1847: WF_CORE.Token('ORIG_SYS_ID', orig_system_id);
1848: WF_CORE.Raise('WF_INVAL_CONCAT_NAME');
1849:

Line 1846: WF_CORE.Token('ORIG_SYSTEM', orig_system);

1842: --
1843: if ( instr(role_name, ':') > 0 ) then
1844: if ( (orig_system||':'||orig_system_id ) <> role_name) then
1845: WF_CORE.Token('NAME', role_name);
1846: WF_CORE.Token('ORIG_SYSTEM', orig_system);
1847: WF_CORE.Token('ORIG_SYS_ID', orig_system_id);
1848: WF_CORE.Raise('WF_INVAL_CONCAT_NAME');
1849:
1850: end if;

Line 1847: WF_CORE.Token('ORIG_SYS_ID', orig_system_id);

1843: if ( instr(role_name, ':') > 0 ) then
1844: if ( (orig_system||':'||orig_system_id ) <> role_name) then
1845: WF_CORE.Token('NAME', role_name);
1846: WF_CORE.Token('ORIG_SYSTEM', orig_system);
1847: WF_CORE.Token('ORIG_SYS_ID', orig_system_id);
1848: WF_CORE.Raise('WF_INVAL_CONCAT_NAME');
1849:
1850: end if;
1851:

Line 1848: WF_CORE.Raise('WF_INVAL_CONCAT_NAME');

1844: if ( (orig_system||':'||orig_system_id ) <> role_name) then
1845: WF_CORE.Token('NAME', role_name);
1846: WF_CORE.Token('ORIG_SYSTEM', orig_system);
1847: WF_CORE.Token('ORIG_SYS_ID', orig_system_id);
1848: WF_CORE.Raise('WF_INVAL_CONCAT_NAME');
1849:
1850: end if;
1851:
1852: end if;

Line 1859: WF_CORE.Token('ROLENAME', role_name);

1855: -- Make sure no '#' or '/' exist in role_name.
1856: --
1857: /* Bug 2779747
1858: if ( (instr(role_name, '/') > 0) or (instr(role_name, '#') > 0) ) then
1859: WF_CORE.Token('ROLENAME', role_name);
1860: WF_CORE.Raise('WF_INVALID_ROLE');
1861: */
1862:
1863: --

Line 1860: WF_CORE.Raise('WF_INVALID_ROLE');

1856: --
1857: /* Bug 2779747
1858: if ( (instr(role_name, '/') > 0) or (instr(role_name, '#') > 0) ) then
1859: WF_CORE.Token('ROLENAME', role_name);
1860: WF_CORE.Raise('WF_INVALID_ROLE');
1861: */
1862:
1863: --
1864: -- Make sure the length of the role_name is <= 320

Line 1867: WF_CORE.Token('NAME', role_name);

1863: --
1864: -- Make sure the length of the role_name is <= 320
1865: --
1866: if ( lengthb(role_name) > 320 ) then
1867: WF_CORE.Token('NAME', role_name);
1868: WF_CORE.Token('LENGTH', 320);
1869: WF_CORE.Raise('WF_ROLENAME_TOO_LONG');
1870:
1871: end if;

Line 1868: WF_CORE.Token('LENGTH', 320);

1864: -- Make sure the length of the role_name is <= 320
1865: --
1866: if ( lengthb(role_name) > 320 ) then
1867: WF_CORE.Token('NAME', role_name);
1868: WF_CORE.Token('LENGTH', 320);
1869: WF_CORE.Raise('WF_ROLENAME_TOO_LONG');
1870:
1871: end if;
1872:

Line 1869: WF_CORE.Raise('WF_ROLENAME_TOO_LONG');

1865: --
1866: if ( lengthb(role_name) > 320 ) then
1867: WF_CORE.Token('NAME', role_name);
1868: WF_CORE.Token('LENGTH', 320);
1869: WF_CORE.Raise('WF_ROLENAME_TOO_LONG');
1870:
1871: end if;
1872:
1873: --

Line 1879: WF_CORE.Token('STATUS', CreateRole.status);

1875: --
1876: if ( CreateRole.status not in ('ACTIVE', 'TMPLEAVE', 'EXTLEAVE',
1877: 'INACTIVE') ) then
1878:
1879: WF_CORE.Token('STATUS', CreateRole.status);
1880: WF_CORE.Raise('WF_INVALID_ROLE_STATUS');
1881:
1882: end if;
1883:

Line 1880: WF_CORE.Raise('WF_INVALID_ROLE_STATUS');

1876: if ( CreateRole.status not in ('ACTIVE', 'TMPLEAVE', 'EXTLEAVE',
1877: 'INACTIVE') ) then
1878:
1879: WF_CORE.Token('STATUS', CreateRole.status);
1880: WF_CORE.Raise('WF_INVALID_ROLE_STATUS');
1881:
1882: end if;
1883:
1884: --

Line 1896: WF_CORE.Token('NTF_PREF', CreateRole.notification_preference);

1892: l_ntfPref := 'MAILHTML';
1893: end if;
1894: elsif (CreateRole.notification_preference not in ('MAILHTML','MAILHTM2',
1895: 'MAILATTH', 'SUMMARY', 'SUMHTML', 'QUERY', 'MAILTEXT','DISABLED')) then
1896: WF_CORE.Token('NTF_PREF', CreateRole.notification_preference);
1897: WF_CORE.Raise('WF_INVALID_NTF_PREF');
1898: else
1899: l_ntfPref := CreateRole.notification_preference;
1900: end if;

Line 1897: WF_CORE.Raise('WF_INVALID_NTF_PREF');

1893: end if;
1894: elsif (CreateRole.notification_preference not in ('MAILHTML','MAILHTM2',
1895: 'MAILATTH', 'SUMMARY', 'SUMHTML', 'QUERY', 'MAILTEXT','DISABLED')) then
1896: WF_CORE.Token('NTF_PREF', CreateRole.notification_preference);
1897: WF_CORE.Raise('WF_INVALID_NTF_PREF');
1898: else
1899: l_ntfPref := CreateRole.notification_preference;
1900: end if;
1901:

Line 1913: wf_core.raise('WF_NO_LANG_TERR');

1909: where code = userenv('LANG');
1910:
1911: exception
1912: when NO_DATA_FOUND then
1913: wf_core.raise('WF_NO_LANG_TERR');
1914: end;
1915:
1916: else
1917: nlang := CreateRole.language;

Line 1959: WF_CORE.Token('NAME', CreateRole.role_name);

1955: l_lastupdlog:= nvl(CreateRole.last_update_login, WFA_SEC.LOGIN_ID);
1956:
1957: if (l_origSysIDTAB.COUNT > 0) then
1958: if (l_partitionID <> 2) then
1959: WF_CORE.Token('NAME', CreateRole.role_name);
1960: WF_CORE.Token('ORIG_SYSTEM', l_origSys);
1961: WF_CORE.Raise('WFDS_DUPLICATE_NAME');
1962: else
1963: --This is an FND_RESP which could be coming in from the loader using

Line 1960: WF_CORE.Token('ORIG_SYSTEM', l_origSys);

1956:
1957: if (l_origSysIDTAB.COUNT > 0) then
1958: if (l_partitionID <> 2) then
1959: WF_CORE.Token('NAME', CreateRole.role_name);
1960: WF_CORE.Token('ORIG_SYSTEM', l_origSys);
1961: WF_CORE.Raise('WFDS_DUPLICATE_NAME');
1962: else
1963: --This is an FND_RESP which could be coming in from the loader using
1964: --afrole.lct, so we will go ahead and call the SetUserAttr() api

Line 1961: WF_CORE.Raise('WFDS_DUPLICATE_NAME');

1957: if (l_origSysIDTAB.COUNT > 0) then
1958: if (l_partitionID <> 2) then
1959: WF_CORE.Token('NAME', CreateRole.role_name);
1960: WF_CORE.Token('ORIG_SYSTEM', l_origSys);
1961: WF_CORE.Raise('WFDS_DUPLICATE_NAME');
1962: else
1963: --This is an FND_RESP which could be coming in from the loader using
1964: --afrole.lct, so we will go ahead and call the SetUserAttr() api
1965: --for the other orig_system_id.

Line 2079: WF_CORE.Token('DISPNAME', CreateRole.role_display_name);

2075: end if;
2076: end if;
2077: exception
2078: when DUP_VAL_ON_INDEX then
2079: WF_CORE.Token('DISPNAME', CreateRole.role_display_name);
2080: WF_CORE.Token('ROLENAME', nvl(CreateRole.role_name,
2081: l_origSys || ':' ||
2082: CreateRole.orig_system_id));
2083: WF_CORE.Raise('WF_DUP_ROLE');

Line 2080: WF_CORE.Token('ROLENAME', nvl(CreateRole.role_name,

2076: end if;
2077: exception
2078: when DUP_VAL_ON_INDEX then
2079: WF_CORE.Token('DISPNAME', CreateRole.role_display_name);
2080: WF_CORE.Token('ROLENAME', nvl(CreateRole.role_name,
2081: l_origSys || ':' ||
2082: CreateRole.orig_system_id));
2083: WF_CORE.Raise('WF_DUP_ROLE');
2084:

Line 2083: WF_CORE.Raise('WF_DUP_ROLE');

2079: WF_CORE.Token('DISPNAME', CreateRole.role_display_name);
2080: WF_CORE.Token('ROLENAME', nvl(CreateRole.role_name,
2081: l_origSys || ':' ||
2082: CreateRole.orig_system_id));
2083: WF_CORE.Raise('WF_DUP_ROLE');
2084:
2085: when others then
2086: wf_core.context('Wf_Directory', 'CreateRole', CreateRole.role_Name,
2087: l_origSys, CreateRole.orig_system_id);

Line 2086: wf_core.context('Wf_Directory', 'CreateRole', CreateRole.role_Name,

2082: CreateRole.orig_system_id));
2083: WF_CORE.Raise('WF_DUP_ROLE');
2084:
2085: when others then
2086: wf_core.context('Wf_Directory', 'CreateRole', CreateRole.role_Name,
2087: l_origSys, CreateRole.orig_system_id);
2088: raise;
2089: end CreateRole;
2090:

Line 2149: wf_core.context('Wf_Directory', 'CreateAdHocRole');

2145: parent_orig_system_id=>CreateAdhocRole.parent_orig_system_id,
2146: owner_tag=>CreateAdhocRole.owner_tag);
2147: exception
2148: when others then
2149: wf_core.context('Wf_Directory', 'CreateAdHocRole');
2150: raise;
2151: end CreateAdHocRole;
2152:
2153: --

Line 2201: wf_core.token('ROLENAME', CreateAdHocRole.role_name);

2197: from wf_roles
2198: where name = CreateAdHocRole.role_name
2199: or display_name = CreateAdHocRole.role_display_name;
2200: if (d1 > 0) then
2201: wf_core.token('ROLENAME', CreateAdHocRole.role_name);
2202: wf_core.token('DISPNAME', CreateAdHocRole.role_display_name);
2203: wf_core.raise('WF_DUP_ROLE');
2204: end if;
2205:

Line 2202: wf_core.token('DISPNAME', CreateAdHocRole.role_display_name);

2198: where name = CreateAdHocRole.role_name
2199: or display_name = CreateAdHocRole.role_display_name;
2200: if (d1 > 0) then
2201: wf_core.token('ROLENAME', CreateAdHocRole.role_name);
2202: wf_core.token('DISPNAME', CreateAdHocRole.role_display_name);
2203: wf_core.raise('WF_DUP_ROLE');
2204: end if;
2205:
2206: */

Line 2203: wf_core.raise('WF_DUP_ROLE');

2199: or display_name = CreateAdHocRole.role_display_name;
2200: if (d1 > 0) then
2201: wf_core.token('ROLENAME', CreateAdHocRole.role_name);
2202: wf_core.token('DISPNAME', CreateAdHocRole.role_display_name);
2203: wf_core.raise('WF_DUP_ROLE');
2204: end if;
2205:
2206: */
2207:

Line 2257: wf_core.context('Wf_Directory', 'CreateAdHocRole2');

2253:
2254:
2255: exception
2256: when others then
2257: wf_core.context('Wf_Directory', 'CreateAdHocRole2');
2258: raise;
2259: end CreateAdHocRole2;
2260:
2261: --

Line 2353: WF_CORE.Token('NAME', CreateUserRole.user_name);

2349: WHERE NAME = CreateUserRole.USER_NAME
2350: AND ROWNUM < 2;
2351: exception
2352: when NO_DATA_FOUND then
2353: WF_CORE.Token('NAME', CreateUserRole.user_name);
2354: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2355: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2356: WF_CORE.Raise('WF_NO_USER');
2357: end;

Line 2354: WF_CORE.Token('ORIG_SYSTEM', 'NULL');

2350: AND ROWNUM < 2;
2351: exception
2352: when NO_DATA_FOUND then
2353: WF_CORE.Token('NAME', CreateUserRole.user_name);
2354: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2355: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2356: WF_CORE.Raise('WF_NO_USER');
2357: end;
2358:

Line 2355: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');

2351: exception
2352: when NO_DATA_FOUND then
2353: WF_CORE.Token('NAME', CreateUserRole.user_name);
2354: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2355: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2356: WF_CORE.Raise('WF_NO_USER');
2357: end;
2358:
2359: --Checking the Role.

Line 2356: WF_CORE.Raise('WF_NO_USER');

2352: when NO_DATA_FOUND then
2353: WF_CORE.Token('NAME', CreateUserRole.user_name);
2354: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2355: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2356: WF_CORE.Raise('WF_NO_USER');
2357: end;
2358:
2359: --Checking the Role.
2360: begin

Line 2370: WF_CORE.Token('NAME', CreateUserRole.role_name);

2366: WHERE NAME = CreateUserRole.ROLE_NAME
2367: AND ROWNUM < 2;
2368: exception
2369: when NO_DATA_FOUND then
2370: WF_CORE.Token('NAME', CreateUserRole.role_name);
2371: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2372: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2373: WF_CORE.Raise('WF_NO_ROLE');
2374: end;

Line 2371: WF_CORE.Token('ORIG_SYSTEM', 'NULL');

2367: AND ROWNUM < 2;
2368: exception
2369: when NO_DATA_FOUND then
2370: WF_CORE.Token('NAME', CreateUserRole.role_name);
2371: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2372: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2373: WF_CORE.Raise('WF_NO_ROLE');
2374: end;
2375: else

Line 2372: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');

2368: exception
2369: when NO_DATA_FOUND then
2370: WF_CORE.Token('NAME', CreateUserRole.role_name);
2371: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2372: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2373: WF_CORE.Raise('WF_NO_ROLE');
2374: end;
2375: else
2376: l_validateUserRole := validateUserRole;

Line 2373: WF_CORE.Raise('WF_NO_ROLE');

2369: when NO_DATA_FOUND then
2370: WF_CORE.Token('NAME', CreateUserRole.role_name);
2371: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2372: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2373: WF_CORE.Raise('WF_NO_ROLE');
2374: end;
2375: else
2376: l_validateUserRole := validateUserRole;
2377: l_uorigSys := UPPER(CreateUserRole.user_orig_system);

Line 2405: WF_CORE.Token('NAME', CreateUserRole.user_name);

2401: AND ORIG_SYSTEM_ID = l_uorigSysID
2402: AND PARTITION_ID = l_upartID;
2403: exception
2404: when NO_DATA_FOUND then
2405: WF_CORE.Token('NAME', CreateUserRole.user_name);
2406: WF_CORE.Token('ORIG_SYSTEM', l_uorigSys);
2407: WF_CORE.Token('ORIG_SYSTEM_ID', l_uorigSysID);
2408: WF_CORE.Raise('WF_NO_USER');
2409: end;

Line 2406: WF_CORE.Token('ORIG_SYSTEM', l_uorigSys);

2402: AND PARTITION_ID = l_upartID;
2403: exception
2404: when NO_DATA_FOUND then
2405: WF_CORE.Token('NAME', CreateUserRole.user_name);
2406: WF_CORE.Token('ORIG_SYSTEM', l_uorigSys);
2407: WF_CORE.Token('ORIG_SYSTEM_ID', l_uorigSysID);
2408: WF_CORE.Raise('WF_NO_USER');
2409: end;
2410:

Line 2407: WF_CORE.Token('ORIG_SYSTEM_ID', l_uorigSysID);

2403: exception
2404: when NO_DATA_FOUND then
2405: WF_CORE.Token('NAME', CreateUserRole.user_name);
2406: WF_CORE.Token('ORIG_SYSTEM', l_uorigSys);
2407: WF_CORE.Token('ORIG_SYSTEM_ID', l_uorigSysID);
2408: WF_CORE.Raise('WF_NO_USER');
2409: end;
2410:
2411: begin

Line 2408: WF_CORE.Raise('WF_NO_USER');

2404: when NO_DATA_FOUND then
2405: WF_CORE.Token('NAME', CreateUserRole.user_name);
2406: WF_CORE.Token('ORIG_SYSTEM', l_uorigSys);
2407: WF_CORE.Token('ORIG_SYSTEM_ID', l_uorigSysID);
2408: WF_CORE.Raise('WF_NO_USER');
2409: end;
2410:
2411: begin
2412: if (l_rpartID is null) then

Line 2425: WF_CORE.Token('NAME', CreateUserRole.role_name);

2421: AND ORIG_SYSTEM_ID = l_rorigSysID
2422: AND PARTITION_ID = l_rpartID;
2423: exception
2424: when NO_DATA_FOUND then
2425: WF_CORE.Token('NAME', CreateUserRole.role_name);
2426: WF_CORE.Token('ORIG_SYSTEM', l_rorigSys);
2427: WF_CORE.Token('ORIG_SYSTEM_ID', l_rorigSysID);
2428: WF_CORE.Raise('WF_NO_ROLE');
2429: end;

Line 2426: WF_CORE.Token('ORIG_SYSTEM', l_rorigSys);

2422: AND PARTITION_ID = l_rpartID;
2423: exception
2424: when NO_DATA_FOUND then
2425: WF_CORE.Token('NAME', CreateUserRole.role_name);
2426: WF_CORE.Token('ORIG_SYSTEM', l_rorigSys);
2427: WF_CORE.Token('ORIG_SYSTEM_ID', l_rorigSysID);
2428: WF_CORE.Raise('WF_NO_ROLE');
2429: end;
2430: elsif (CreateUserRole.user_name = CreateUserRole.role_name) then

Line 2427: WF_CORE.Token('ORIG_SYSTEM_ID', l_rorigSysID);

2423: exception
2424: when NO_DATA_FOUND then
2425: WF_CORE.Token('NAME', CreateUserRole.role_name);
2426: WF_CORE.Token('ORIG_SYSTEM', l_rorigSys);
2427: WF_CORE.Token('ORIG_SYSTEM_ID', l_rorigSysID);
2428: WF_CORE.Raise('WF_NO_ROLE');
2429: end;
2430: elsif (CreateUserRole.user_name = CreateUserRole.role_name) then
2431: --If this is a self reference we can set the user and role date values to

Line 2428: WF_CORE.Raise('WF_NO_ROLE');

2424: when NO_DATA_FOUND then
2425: WF_CORE.Token('NAME', CreateUserRole.role_name);
2426: WF_CORE.Token('ORIG_SYSTEM', l_rorigSys);
2427: WF_CORE.Token('ORIG_SYSTEM_ID', l_rorigSysID);
2428: WF_CORE.Raise('WF_NO_ROLE');
2429: end;
2430: elsif (CreateUserRole.user_name = CreateUserRole.role_name) then
2431: --If this is a self reference we can set the user and role date values to
2432: --the same as the start/end of the user/role relationship as they are the

Line 2540: WF_CORE.Canonical_Date_Mask),

2536: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2537: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', l_rorigSysID, l_params);
2538: WF_EVENT.AddParameterToList('START_DATE',
2539: to_char(trunc(CreateUserRole.start_date),
2540: WF_CORE.Canonical_Date_Mask),
2541: l_params);
2542: WF_EVENT.AddParameterToList('END_DATE',
2543: to_char(trunc(CreateUserRole.end_date),
2544: WF_CORE.Canonical_Date_Mask),

Line 2544: WF_CORE.Canonical_Date_Mask),

2540: WF_CORE.Canonical_Date_Mask),
2541: l_params);
2542: WF_EVENT.AddParameterToList('END_DATE',
2543: to_char(trunc(CreateUserRole.end_date),
2544: WF_CORE.Canonical_Date_Mask),
2545: l_params);
2546:
2547: WF_EVENT.AddParameterToList('CREATED_BY',
2548: to_char(CreateUserRole.created_by,

Line 2549: WF_CORE.canonical_number_mask), l_params);

2545: l_params);
2546:
2547: WF_EVENT.AddParameterToList('CREATED_BY',
2548: to_char(CreateUserRole.created_by,
2549: WF_CORE.canonical_number_mask), l_params);
2550:
2551: WF_EVENT.AddParameterToList('CREATION_DATE',
2552: to_char(CreateUserRole.creation_date,
2553: WF_CORE.canonical_date_mask), l_params);

Line 2553: WF_CORE.canonical_date_mask), l_params);

2549: WF_CORE.canonical_number_mask), l_params);
2550:
2551: WF_EVENT.AddParameterToList('CREATION_DATE',
2552: to_char(CreateUserRole.creation_date,
2553: WF_CORE.canonical_date_mask), l_params);
2554:
2555: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
2556: to_char(CreateUserRole.last_updated_by,
2557: WF_CORE.canonical_number_mask), l_params);

Line 2557: WF_CORE.canonical_number_mask), l_params);

2553: WF_CORE.canonical_date_mask), l_params);
2554:
2555: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
2556: to_char(CreateUserRole.last_updated_by,
2557: WF_CORE.canonical_number_mask), l_params);
2558: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2559: to_char(CreateUserRole.last_update_date,
2560: WF_CORE.canonical_date_mask), l_params);
2561: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',

Line 2560: WF_CORE.canonical_date_mask), l_params);

2556: to_char(CreateUserRole.last_updated_by,
2557: WF_CORE.canonical_number_mask), l_params);
2558: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2559: to_char(CreateUserRole.last_update_date,
2560: WF_CORE.canonical_date_mask), l_params);
2561: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2562: to_char(CreateUserRole.last_update_login,
2563: WF_CORE.canonical_number_mask), l_params);
2564: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',

Line 2563: WF_CORE.canonical_number_mask), l_params);

2559: to_char(CreateUserRole.last_update_date,
2560: WF_CORE.canonical_date_mask), l_params);
2561: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2562: to_char(CreateUserRole.last_update_login,
2563: WF_CORE.canonical_number_mask), l_params);
2564: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2565: CreateUserRole.assignment_type, l_params);
2566: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
2567: CreateUserRole.parent_orig_system, l_params);

Line 2570: WF_CORE.canonical_number_mask), l_params);

2566: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
2567: CreateUserRole.parent_orig_system, l_params);
2568: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
2569: to_char(CreateUserRole.parent_orig_system_id,
2570: WF_CORE.canonical_number_mask), l_params);
2571: WF_EVENT.AddParameterToList('PARTITION_ID', to_char(l_partitionID,
2572: WF_CORE.canonical_number_mask),l_params);
2573: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2574: CreateUserRole.assignment_reason, l_params);

Line 2572: WF_CORE.canonical_number_mask),l_params);

2568: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
2569: to_char(CreateUserRole.parent_orig_system_id,
2570: WF_CORE.canonical_number_mask), l_params);
2571: WF_EVENT.AddParameterToList('PARTITION_ID', to_char(l_partitionID,
2572: WF_CORE.canonical_number_mask),l_params);
2573: WF_EVENT.AddParameterToList('ASSIGNMENT_REASON',
2574: CreateUserRole.assignment_reason, l_params);
2575: if (eventParams is not null and eventParams.count>0) then
2576: for i in eventParams.first..eventParams.last loop

Line 2611: WF_CORE.Token('UNAME', CreateUserRole.user_name);

2607: end if;
2608:
2609: exception
2610: when DUP_VAL_ON_INDEX then
2611: WF_CORE.Token('UNAME', CreateUserRole.user_name);
2612: WF_CORE.Token('RNAME', CreateUserRole.role_name);
2613: WF_CORE.Raise('WF_DUP_USER_ROLE');
2614:
2615: when OTHERS then

Line 2612: WF_CORE.Token('RNAME', CreateUserRole.role_name);

2608:
2609: exception
2610: when DUP_VAL_ON_INDEX then
2611: WF_CORE.Token('UNAME', CreateUserRole.user_name);
2612: WF_CORE.Token('RNAME', CreateUserRole.role_name);
2613: WF_CORE.Raise('WF_DUP_USER_ROLE');
2614:
2615: when OTHERS then
2616: raise;

Line 2613: WF_CORE.Raise('WF_DUP_USER_ROLE');

2609: exception
2610: when DUP_VAL_ON_INDEX then
2611: WF_CORE.Token('UNAME', CreateUserRole.user_name);
2612: WF_CORE.Token('RNAME', CreateUserRole.role_name);
2613: WF_CORE.Raise('WF_DUP_USER_ROLE');
2614:
2615: when OTHERS then
2616: raise;
2617:

Line 2624: wf_core.context('Wf_Directory', 'CreateUserRole',

2620:
2621:
2622: exception
2623: when others then
2624: wf_core.context('Wf_Directory', 'CreateUserRole',
2625: user_name, role_name, l_uorigSys,
2626: to_char(nvl(user_orig_system_id, l_uorigSysID)),
2627: l_rorigSys, to_char(nvl(role_orig_system_id, l_rorigSysID)));
2628:

Line 2719: WF_CORE.Token('NAME', SetUserRoleAttr.user_name);

2715: and rownum < 2;
2716:
2717: exception
2718: when NO_DATA_FOUND then
2719: WF_CORE.Token('NAME', SetUserRoleAttr.user_name);
2720: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2721: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2722: WF_CORE.Raise('WF_NO_USER');
2723: end;

Line 2720: WF_CORE.Token('ORIG_SYSTEM', 'NULL');

2716:
2717: exception
2718: when NO_DATA_FOUND then
2719: WF_CORE.Token('NAME', SetUserRoleAttr.user_name);
2720: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2721: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2722: WF_CORE.Raise('WF_NO_USER');
2723: end;
2724: end if;

Line 2721: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');

2717: exception
2718: when NO_DATA_FOUND then
2719: WF_CORE.Token('NAME', SetUserRoleAttr.user_name);
2720: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2721: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2722: WF_CORE.Raise('WF_NO_USER');
2723: end;
2724: end if;
2725:

Line 2722: WF_CORE.Raise('WF_NO_USER');

2718: when NO_DATA_FOUND then
2719: WF_CORE.Token('NAME', SetUserRoleAttr.user_name);
2720: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2721: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2722: WF_CORE.Raise('WF_NO_USER');
2723: end;
2724: end if;
2725:
2726:

Line 2744: WF_CORE.Token('NAME', SetUserRoleAttr.role_name);

2740: end if;
2741:
2742: exception
2743: when NO_DATA_FOUND then
2744: WF_CORE.Token('NAME', SetUserRoleAttr.role_name);
2745: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2746: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2747: WF_CORE.Raise('WF_NO_ROLE');
2748: end;

Line 2745: WF_CORE.Token('ORIG_SYSTEM', 'NULL');

2741:
2742: exception
2743: when NO_DATA_FOUND then
2744: WF_CORE.Token('NAME', SetUserRoleAttr.role_name);
2745: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2746: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2747: WF_CORE.Raise('WF_NO_ROLE');
2748: end;
2749: end if;

Line 2746: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');

2742: exception
2743: when NO_DATA_FOUND then
2744: WF_CORE.Token('NAME', SetUserRoleAttr.role_name);
2745: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2746: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2747: WF_CORE.Raise('WF_NO_ROLE');
2748: end;
2749: end if;
2750: if (l_partitionID is null) then

Line 2747: WF_CORE.Raise('WF_NO_ROLE');

2743: when NO_DATA_FOUND then
2744: WF_CORE.Token('NAME', SetUserRoleAttr.role_name);
2745: WF_CORE.Token('ORIG_SYSTEM', 'NULL');
2746: WF_CORE.Token('ORIG_SYSTEM_ID', 'NULL');
2747: WF_CORE.Raise('WF_NO_ROLE');
2748: end;
2749: end if;
2750: if (l_partitionID is null) then
2751: AssignPartition(l_rorigSys,l_partitionID,l_partitionName);

Line 2775: WF_CORE.Raise('WF_INVAL_USER_ROLE');

2771: -- direct assignment will go first and then the older indirect assignments
2772:
2773: exception
2774: when NO_DATA_FOUND then
2775: WF_CORE.Raise('WF_INVAL_USER_ROLE');
2776: end;
2777:
2778: -- Evaluating the WHO columns in case they are not passed
2779: l_lastupdby := nvl(setuserroleattr.last_updated_by, WFA_SEC.USER_ID);

Line 2874: WF_CORE.Raise('WF_INVAL_USER_ROLE');

2870:
2871: end if;
2872:
2873: if (sql%ROWCOUNT = 0) then
2874: WF_CORE.Raise('WF_INVAL_USER_ROLE');
2875:
2876: end if;
2877: --We were able to update an existing record, so we will raise the
2878: --updated event

Line 2888: WF_CORE.canonical_number_mask), l_params);

2884: WF_EVENT.AddParameterToList('ROLE_NAME', SetUserRoleAttr.role_name,
2885: l_params);
2886: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM', l_uorigSys, l_params);
2887: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,
2888: WF_CORE.canonical_number_mask), l_params);
2889: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2890: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2891: WF_CORE.canonical_number_mask), l_params);
2892: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);

Line 2891: WF_CORE.canonical_number_mask), l_params);

2887: WF_EVENT.AddParameterToList('USER_ORIG_SYSTEM_ID', to_char(l_uorigSysID,
2888: WF_CORE.canonical_number_mask), l_params);
2889: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM', l_rorigSys, l_params);
2890: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2891: WF_CORE.canonical_number_mask), l_params);
2892: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);
2893: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,
2894: WF_CORE.canonical_number_mask), l_params);
2895: WF_EVENT.AddParameterToList('START_DATE',

Line 2894: WF_CORE.canonical_number_mask), l_params);

2890: WF_EVENT.AddParameterToList('ROLE_ORIG_SYSTEM_ID', to_char(l_rorigSysID,
2891: WF_CORE.canonical_number_mask), l_params);
2892: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM', l_porigSys, l_params);
2893: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,
2894: WF_CORE.canonical_number_mask), l_params);
2895: WF_EVENT.AddParameterToList('START_DATE',
2896: to_char(trunc(SetUserRoleAttr.start_date),
2897: WF_CORE.canonical_date_mask),
2898: l_params);

Line 2897: WF_CORE.canonical_date_mask),

2893: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID', to_char(l_porigSysID,
2894: WF_CORE.canonical_number_mask), l_params);
2895: WF_EVENT.AddParameterToList('START_DATE',
2896: to_char(trunc(SetUserRoleAttr.start_date),
2897: WF_CORE.canonical_date_mask),
2898: l_params);
2899: WF_EVENT.AddParameterToList('END_DATE',
2900: to_char(trunc(SetUserRoleAttr.end_date),
2901: WF_CORE.canonical_date_mask),

Line 2901: WF_CORE.canonical_date_mask),

2897: WF_CORE.canonical_date_mask),
2898: l_params);
2899: WF_EVENT.AddParameterToList('END_DATE',
2900: to_char(trunc(SetUserRoleAttr.end_date),
2901: WF_CORE.canonical_date_mask),
2902: l_params);
2903:
2904: if ((((l_oldStartDate is NOT NULL) and
2905: (SetUserRoleAttr.start_date is NOT NULL)) and

Line 2912: WF_CORE.Canonical_Date_Mask),

2908: (SetUserRoleAttr.start_date is NULL and l_oldStartDate is NOT NULL))) then
2909:
2910: WF_EVENT.AddParameterToList('OLD_START_DATE',
2911: to_char(trunc(l_oldStartDate),
2912: WF_CORE.Canonical_Date_Mask),
2913: l_params);
2914: else
2915: WF_EVENT.AddParameterToList('OLD_START_DATE', '*UNDEFINED*',
2916: l_params);

Line 2928: WF_CORE.Canonical_Date_Mask),

2924: and l_oldEndDate is NOT NULL))) then
2925:
2926: WF_EVENT.AddParameterToList('OLD_END_DATE',
2927: to_char(trunc(l_oldEndDate),
2928: WF_CORE.Canonical_Date_Mask),
2929: l_params);
2930: else
2931: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
2932: l_params);

Line 2938: WF_CORE.canonical_number_mask), l_params);

2934:
2935:
2936: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
2937: to_char(SetUserRoleAttr.last_updated_by,
2938: WF_CORE.canonical_number_mask), l_params);
2939:
2940: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2941: to_char(SetUserRoleAttr.last_update_date,
2942: WF_CORE.canonical_date_mask), l_params);

Line 2942: WF_CORE.canonical_date_mask), l_params);

2938: WF_CORE.canonical_number_mask), l_params);
2939:
2940: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
2941: to_char(SetUserRoleAttr.last_update_date,
2942: WF_CORE.canonical_date_mask), l_params);
2943: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2944: to_char(SetUserRoleAttr.last_update_login,
2945: WF_CORE.canonical_number_mask), l_params);
2946:

Line 2945: WF_CORE.canonical_number_mask), l_params);

2941: to_char(SetUserRoleAttr.last_update_date,
2942: WF_CORE.canonical_date_mask), l_params);
2943: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
2944: to_char(SetUserRoleAttr.last_update_login,
2945: WF_CORE.canonical_number_mask), l_params);
2946:
2947: WF_EVENT.AddParameterToList('CREATED_BY',
2948: to_char(SetUserRoleAttr.created_by,
2949: WF_CORE.canonical_number_mask), l_params);

Line 2949: WF_CORE.canonical_number_mask), l_params);

2945: WF_CORE.canonical_number_mask), l_params);
2946:
2947: WF_EVENT.AddParameterToList('CREATED_BY',
2948: to_char(SetUserRoleAttr.created_by,
2949: WF_CORE.canonical_number_mask), l_params);
2950:
2951: WF_EVENT.AddParameterToList('CREATION_DATE',
2952: to_char(SetUserRoleAttr.creation_date,
2953: WF_CORE.canonical_date_mask), l_params);

Line 2953: WF_CORE.canonical_date_mask), l_params);

2949: WF_CORE.canonical_number_mask), l_params);
2950:
2951: WF_EVENT.AddParameterToList('CREATION_DATE',
2952: to_char(SetUserRoleAttr.creation_date,
2953: WF_CORE.canonical_date_mask), l_params);
2954:
2955: WF_EVENT.AddParameterToList('ASSIGNMENT_TYPE',
2956: SetUserRoleAttr.assignment_type, l_params);
2957:

Line 3111: wf_core.context('Wf_Directory', 'RemoveUserRole',

3107: -- user.
3108:
3109: exception
3110: when others then
3111: wf_core.context('Wf_Directory', 'RemoveUserRole',
3112: user_name, role_name, user_orig_system, to_char(user_orig_system_id),
3113: role_orig_system, to_char(role_orig_system_id));
3114:
3115: raise;

Line 3144: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole',

3140: end if;
3141:
3142: exception
3143: when others then
3144: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole',
3145: role_name, '"'||role_users||'"');
3146: raise;
3147: end AddUsersToAdHocRole;
3148:

Line 3170: wf_core.token('ROLENAME', AddUsersToAdHocRole2.role_name);

3166:
3167: begin
3168: -- Validate Role
3169: if (wfa_sec.DS_Count_Local_Role(AddUsersToAdHocRole2.role_name) <= 0) then
3170: wf_core.token('ROLENAME', AddUsersToAdHocRole2.role_name);
3171: wf_core.raise('WF_INVALID_ROLE');
3172: end if;
3173:
3174: if (role_users.COUNT > 0) then

Line 3171: wf_core.raise('WF_INVALID_ROLE');

3167: begin
3168: -- Validate Role
3169: if (wfa_sec.DS_Count_Local_Role(AddUsersToAdHocRole2.role_name) <= 0) then
3170: wf_core.token('ROLENAME', AddUsersToAdHocRole2.role_name);
3171: wf_core.raise('WF_INVALID_ROLE');
3172: end if;
3173:
3174: if (role_users.COUNT > 0) then
3175: for userIND in role_users.FIRST..role_users.LAST loop

Line 3209: wf_core.token('USERNAME', role_users(userIND));

3205: AND rownum < 2;
3206: end if;
3207: exception
3208: when NO_DATA_FOUND then
3209: wf_core.token('USERNAME', role_users(userIND));
3210: wf_core.raise('WF_INVALID_USER');
3211:
3212: when others then
3213: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole2', role_name);

Line 3210: wf_core.raise('WF_INVALID_USER');

3206: end if;
3207: exception
3208: when NO_DATA_FOUND then
3209: wf_core.token('USERNAME', role_users(userIND));
3210: wf_core.raise('WF_INVALID_USER');
3211:
3212: when others then
3213: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole2', role_name);
3214: raise;

Line 3213: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole2', role_name);

3209: wf_core.token('USERNAME', role_users(userIND));
3210: wf_core.raise('WF_INVALID_USER');
3211:
3212: when others then
3213: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole2', role_name);
3214: raise;
3215: end;
3216:
3217: -- Check Duplicate

Line 3234: -- wf_core.token('USERNAME', role_users(userIND));

3230: -- and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
3231: -- and ROLE_ORIG_SYSTEM_ID = 0;
3232:
3233: -- if (d1 > 0) then
3234: -- wf_core.token('USERNAME', role_users(userIND));
3235: -- wf_core.token('DISPNAME', '');
3236: -- wf_core.raise('WF_DUP_USER');
3237: -- end if;
3238:

Line 3235: -- wf_core.token('DISPNAME', '');

3231: -- and ROLE_ORIG_SYSTEM_ID = 0;
3232:
3233: -- if (d1 > 0) then
3234: -- wf_core.token('USERNAME', role_users(userIND));
3235: -- wf_core.token('DISPNAME', '');
3236: -- wf_core.raise('WF_DUP_USER');
3237: -- end if;
3238:
3239: CreateUserRole(user_name=>role_users(userIND),

Line 3236: -- wf_core.raise('WF_DUP_USER');

3232:
3233: -- if (d1 > 0) then
3234: -- wf_core.token('USERNAME', role_users(userIND));
3235: -- wf_core.token('DISPNAME', '');
3236: -- wf_core.raise('WF_DUP_USER');
3237: -- end if;
3238:
3239: CreateUserRole(user_name=>role_users(userIND),
3240: role_name=>AddUsersToAdHocRole2.role_name,

Line 3260: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole2',

3256: end if;
3257:
3258: exception
3259: when others then
3260: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole2',
3261: role_name);
3262: raise;
3263: end AddUsersToAdHocRole2;
3264:

Line 3343: wf_core.token('USERNAME', user_name);

3339: AND ORIG_SYSTEM_ID = SetUserAttr.orig_system_id
3340: AND PARTITION_ID = l_partitionID;
3341: exception
3342: when NO_DATA_FOUND then
3343: wf_core.token('USERNAME', user_name);
3344: wf_core.raise('WF_INVALID_USER');
3345: end;
3346:
3347: --

Line 3344: wf_core.raise('WF_INVALID_USER');

3340: AND PARTITION_ID = l_partitionID;
3341: exception
3342: when NO_DATA_FOUND then
3343: wf_core.token('USERNAME', user_name);
3344: wf_core.raise('WF_INVALID_USER');
3345: end;
3346:
3347: --
3348: -- Evaluate the WHO columns, and set default values if they are not passed

Line 3598: wf_core.token('USERNAME', user_name);

3594:
3595: end if;
3596: end if;
3597: if (sql%rowcount = 0) then
3598: wf_core.token('USERNAME', user_name);
3599: wf_core.raise('WF_INVALID_USER');
3600: end if;
3601:
3602: --We were able to update the record, so we will raise the updated event

Line 3599: wf_core.raise('WF_INVALID_USER');

3595: end if;
3596: end if;
3597: if (sql%rowcount = 0) then
3598: wf_core.token('USERNAME', user_name);
3599: wf_core.raise('WF_INVALID_USER');
3600: end if;
3601:
3602: --We were able to update the record, so we will raise the updated event
3603: --Build parameter list.

Line 3622: WF_CORE.Canonical_Date_Mask),

3618: l_params);
3619: WF_EVENT.AddParameterToList('FAX', SetUserAttr.fax, l_params);
3620: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
3621: to_char(trunc(SetUserAttr.expiration_date),
3622: WF_CORE.Canonical_Date_Mask),
3623: l_params);
3624: WF_EVENT.AddParameterToList('STATUS', SetUserAttr.status, l_params);
3625: WF_EVENT.AddParameterToList('START_DATE',
3626: to_char(trunc(SetUserAttr.start_date),

Line 3627: WF_CORE.Canonical_Date_Mask),

3623: l_params);
3624: WF_EVENT.AddParameterToList('STATUS', SetUserAttr.status, l_params);
3625: WF_EVENT.AddParameterToList('START_DATE',
3626: to_char(trunc(SetUserAttr.start_date),
3627: WF_CORE.Canonical_Date_Mask),
3628: l_params);
3629: if ((((l_oldStartDate is NOT NULL) and
3630: (SetUserAttr.start_date is NOT NULL)) and
3631: (trunc(l_oldStartDate) <> trunc(SetUserAttr.start_date))) or

Line 3637: WF_CORE.Canonical_Date_Mask),

3633: (SetUserAttr.start_date is NULL and l_oldStartDate is NOT NULL))) then
3634:
3635: WF_EVENT.AddParameterToList('OLD_START_DATE',
3636: to_char(trunc(l_oldStartDate),
3637: WF_CORE.Canonical_Date_Mask),
3638: l_params);
3639: else
3640: WF_EVENT.AddParameterToList('OLD_START_DATE', '*UNDEFINED*',
3641: l_params);

Line 3653: WF_CORE.Canonical_Date_Mask),

3649: and l_oldEndDate is NOT NULL))) then
3650:
3651: WF_EVENT.AddParameterToList('OLD_END_DATE',
3652: to_char(trunc(l_oldEndDate),
3653: WF_CORE.Canonical_Date_Mask),
3654: l_params);
3655: else
3656: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
3657: l_params);

Line 3664: WF_CORE.canonical_number_mask), l_params);

3660: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
3661: SetUserAttr.parent_orig_system, l_params);
3662: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
3663: to_char(SetUserAttr.parent_orig_system_id ,
3664: WF_CORE.canonical_number_mask), l_params);
3665: WF_EVENT.AddParameterToList('OWNER_TAG', SetUserAttr.owner_tag, l_params);
3666: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
3667: to_char(SetUserAttr.last_updated_by,
3668: WF_CORE.canonical_number_mask), l_params);

Line 3668: WF_CORE.canonical_number_mask), l_params);

3664: WF_CORE.canonical_number_mask), l_params);
3665: WF_EVENT.AddParameterToList('OWNER_TAG', SetUserAttr.owner_tag, l_params);
3666: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
3667: to_char(SetUserAttr.last_updated_by,
3668: WF_CORE.canonical_number_mask), l_params);
3669: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
3670: to_char(SetUserAttr.last_update_date,
3671: WF_CORE.canonical_date_mask), l_params);
3672: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',

Line 3671: WF_CORE.canonical_date_mask), l_params);

3667: to_char(SetUserAttr.last_updated_by,
3668: WF_CORE.canonical_number_mask), l_params);
3669: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
3670: to_char(SetUserAttr.last_update_date,
3671: WF_CORE.canonical_date_mask), l_params);
3672: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
3673: to_char(SetUserAttr.last_update_login ,
3674: WF_CORE.canonical_number_mask), l_params);
3675: WF_EVENT.AddParameterToList('CREATED_BY', to_char(SetUserAttr.created_by ,

Line 3674: WF_CORE.canonical_number_mask), l_params);

3670: to_char(SetUserAttr.last_update_date,
3671: WF_CORE.canonical_date_mask), l_params);
3672: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
3673: to_char(SetUserAttr.last_update_login ,
3674: WF_CORE.canonical_number_mask), l_params);
3675: WF_EVENT.AddParameterToList('CREATED_BY', to_char(SetUserAttr.created_by ,
3676: WF_CORE.canonical_number_mask), l_params);
3677: WF_EVENT.AddParameterToList('CREATION_DATE',
3678: to_char(SetUserAttr.creation_date,

Line 3676: WF_CORE.canonical_number_mask), l_params);

3672: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
3673: to_char(SetUserAttr.last_update_login ,
3674: WF_CORE.canonical_number_mask), l_params);
3675: WF_EVENT.AddParameterToList('CREATED_BY', to_char(SetUserAttr.created_by ,
3676: WF_CORE.canonical_number_mask), l_params);
3677: WF_EVENT.AddParameterToList('CREATION_DATE',
3678: to_char(SetUserAttr.creation_date,
3679: WF_CORE.canonical_date_mask), l_params);
3680: if (eventParams is not null and eventParams.count>0) then

Line 3679: WF_CORE.canonical_date_mask), l_params);

3675: WF_EVENT.AddParameterToList('CREATED_BY', to_char(SetUserAttr.created_by ,
3676: WF_CORE.canonical_number_mask), l_params);
3677: WF_EVENT.AddParameterToList('CREATION_DATE',
3678: to_char(SetUserAttr.creation_date,
3679: WF_CORE.canonical_date_mask), l_params);
3680: if (eventParams is not null and eventParams.count>0) then
3681: for i in eventParams.first..eventParams.last loop
3682: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),
3683: eventParams(i).getValue(),l_params);

Line 3692: wf_core.context('Wf_Directory', 'SetUserAttr', user_name, display_name);

3688: p_event_key=>user_name, p_parameters=>l_params);
3689:
3690: exception
3691: when others then
3692: wf_core.context('Wf_Directory', 'SetUserAttr', user_name, display_name);
3693: raise;
3694: end SetUserAttr;
3695:
3696: --

Line 3766: WF_CORE.Token('ROLENAME', role_name);

3762: AND ORIG_SYSTEM_ID = SetRoleAttr.orig_system_id
3763: AND PARTITION_ID = l_partitionID;
3764: exception
3765: when NO_DATA_FOUND then
3766: WF_CORE.Token('ROLENAME', role_name);
3767: WF_CORE.Raise('WF_INVALID_ROLE');
3768: end;
3769: --
3770:

Line 3767: WF_CORE.Raise('WF_INVALID_ROLE');

3763: AND PARTITION_ID = l_partitionID;
3764: exception
3765: when NO_DATA_FOUND then
3766: WF_CORE.Token('ROLENAME', role_name);
3767: WF_CORE.Raise('WF_INVALID_ROLE');
3768: end;
3769: --
3770:
3771:

Line 3824: WF_CORE.Token('ROLENAME', role_name);

3820: --lets keep the code here rather than end for better understanding
3821: --If the role information was not updated, we need to raise an
3822: --invalid role error so the caller can call the CreateRole api.
3823: if (sql%rowcount = 0) then
3824: WF_CORE.Token('ROLENAME', role_name);
3825: WF_CORE.Raise('WF_INVALID_ROLE');
3826: end if;
3827:
3828: else

Line 3825: WF_CORE.Raise('WF_INVALID_ROLE');

3821: --If the role information was not updated, we need to raise an
3822: --invalid role error so the caller can call the CreateRole api.
3823: if (sql%rowcount = 0) then
3824: WF_CORE.Token('ROLENAME', role_name);
3825: WF_CORE.Raise('WF_INVALID_ROLE');
3826: end if;
3827:
3828: else
3829: update WF_LOCAL_ROLES

Line 3860: WF_CORE.Token('ROLENAME', role_name);

3856:
3857: --If the base role information was not updated, we need to raise an
3858: --invalid role error so the caller can call the CreateRole api.
3859: if (sql%rowcount = 0) then
3860: WF_CORE.Token('ROLENAME', role_name);
3861: WF_CORE.Raise('WF_INVALID_ROLE');
3862: end if;
3863:
3864: --Update the _TL table for the display_name and

Line 3861: WF_CORE.Raise('WF_INVALID_ROLE');

3857: --If the base role information was not updated, we need to raise an
3858: --invalid role error so the caller can call the CreateRole api.
3859: if (sql%rowcount = 0) then
3860: WF_CORE.Token('ROLENAME', role_name);
3861: WF_CORE.Raise('WF_INVALID_ROLE');
3862: end if;
3863:
3864: --Update the _TL table for the display_name and
3865: --description

Line 3972: WF_CORE.Token('ROLENAME', role_name);

3968: --lets keep the code here rather than end for better understanding
3969: --If the role information was not updated, we need to raise an
3970: --invalid role error so the caller can call the CreateRole api.
3971: if (sql%rowcount = 0) then
3972: WF_CORE.Token('ROLENAME', role_name);
3973: WF_CORE.Raise('WF_INVALID_ROLE');
3974: end if;
3975:
3976: else

Line 3973: WF_CORE.Raise('WF_INVALID_ROLE');

3969: --If the role information was not updated, we need to raise an
3970: --invalid role error so the caller can call the CreateRole api.
3971: if (sql%rowcount = 0) then
3972: WF_CORE.Token('ROLENAME', role_name);
3973: WF_CORE.Raise('WF_INVALID_ROLE');
3974: end if;
3975:
3976: else
3977: update WF_LOCAL_ROLES

Line 4010: WF_CORE.Token('ROLENAME', role_name);

4006:
4007: --If the base role information was not updated, we need to raise an
4008: --invalid role error so the caller can call the CreateRole api.
4009: if (sql%rowcount = 0) then
4010: WF_CORE.Token('ROLENAME', role_name);
4011: WF_CORE.Raise('WF_INVALID_ROLE');
4012: end if;
4013:
4014: --Update the _TL table for the display_name and

Line 4011: WF_CORE.Raise('WF_INVALID_ROLE');

4007: --If the base role information was not updated, we need to raise an
4008: --invalid role error so the caller can call the CreateRole api.
4009: if (sql%rowcount = 0) then
4010: WF_CORE.Token('ROLENAME', role_name);
4011: WF_CORE.Raise('WF_INVALID_ROLE');
4012: end if;
4013:
4014: --Update the _TL table for the display_name and
4015: --description

Line 4101: WF_CORE.Canonical_Date_Mask),

4097: l_params);
4098: WF_EVENT.AddParameterToList('FAX', SetRoleAttr.fax, l_params);
4099: WF_EVENT.AddParameterToList('EXPIRATION_DATE',
4100: to_char(trunc(SetRoleAttr.expiration_date),
4101: WF_CORE.Canonical_Date_Mask),
4102: l_params);
4103: WF_EVENT.AddParameterToList('STATUS', SetRoleAttr.status, l_params);
4104: WF_EVENT.AddParameterToList('START_DATE',
4105: to_char(trunc(SetRoleAttr.start_date),

Line 4106: WF_CORE.Canonical_Date_Mask),

4102: l_params);
4103: WF_EVENT.AddParameterToList('STATUS', SetRoleAttr.status, l_params);
4104: WF_EVENT.AddParameterToList('START_DATE',
4105: to_char(trunc(SetRoleAttr.start_date),
4106: WF_CORE.Canonical_Date_Mask),
4107: l_params);
4108: if ((((l_oldStartDate is NOT NULL) and
4109: (SetRoleAttr.start_date is NOT NULL)) and
4110: (trunc(l_oldStartDate) <> trunc(SetRoleAttr.start_date))) or

Line 4116: WF_CORE.Canonical_Date_Mask),

4112: (SetRoleAttr.start_date is NULL and l_oldStartDate is NOT NULL))) then
4113:
4114: WF_EVENT.AddParameterToList('OLD_START_DATE',
4115: to_char(trunc(l_oldStartDate),
4116: WF_CORE.Canonical_Date_Mask),
4117: l_params);
4118: else
4119: WF_EVENT.AddParameterToList('OLD_START_DATE', '*UNDEFINED*',
4120: l_params);

Line 4132: WF_CORE.Canonical_Date_Mask),

4128: and l_oldEndDate is NOT NULL))) then
4129:
4130: WF_EVENT.AddParameterToList('OLD_END_DATE',
4131: to_char(trunc(l_oldEndDate),
4132: WF_CORE.Canonical_Date_Mask),
4133: l_params);
4134: else
4135: WF_EVENT.AddParameterToList('OLD_END_DATE', '*UNDEFINED*',
4136: l_params);

Line 4143: WF_CORE.canonical_number_mask),l_params);

4139: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM',
4140: SetRoleAttr.parent_orig_system, l_params);
4141: WF_EVENT.AddParameterToList('PARENT_ORIG_SYSTEM_ID',
4142: to_char(SetRoleAttr.parent_orig_system_id ,
4143: WF_CORE.canonical_number_mask),l_params);
4144:
4145: WF_EVENT.AddParameterToList('OWNER_TAG', SetRoleAttr.owner_tag, l_params);
4146: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
4147: to_char(SetRoleAttr.last_updated_by ,

Line 4148: WF_CORE.canonical_number_mask), l_params);

4144:
4145: WF_EVENT.AddParameterToList('OWNER_TAG', SetRoleAttr.owner_tag, l_params);
4146: WF_EVENT.AddParameterToList('LAST_UPDATED_BY',
4147: to_char(SetRoleAttr.last_updated_by ,
4148: WF_CORE.canonical_number_mask), l_params);
4149: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
4150: to_char(SetRoleAttr.last_update_date,
4151: WF_CORE.canonical_date_mask), l_params);
4152: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',

Line 4151: WF_CORE.canonical_date_mask), l_params);

4147: to_char(SetRoleAttr.last_updated_by ,
4148: WF_CORE.canonical_number_mask), l_params);
4149: WF_EVENT.AddParameterToList('LAST_UPDATE_DATE',
4150: to_char(SetRoleAttr.last_update_date,
4151: WF_CORE.canonical_date_mask), l_params);
4152: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
4153: to_char(SetRoleAttr.last_update_login ,
4154: WF_CORE.canonical_number_mask), l_params);
4155: if (eventParams is not null and eventParams.count>0) then

Line 4154: WF_CORE.canonical_number_mask), l_params);

4150: to_char(SetRoleAttr.last_update_date,
4151: WF_CORE.canonical_date_mask), l_params);
4152: WF_EVENT.AddParameterToList('LAST_UPDATE_LOGIN',
4153: to_char(SetRoleAttr.last_update_login ,
4154: WF_CORE.canonical_number_mask), l_params);
4155: if (eventParams is not null and eventParams.count>0) then
4156: for i in eventParams.first..eventParams.last loop
4157: WF_EVENT.AddParameterToList(upper(eventParams(i).getName()),
4158: eventParams(i).getValue(),l_params);

Line 4166: wf_core.context('Wf_Directory', 'SetRoleAttr', SetRoleAttr.role_name,

4162: p_event_key=>role_name, p_parameters=>l_params);
4163:
4164: exception
4165: when others then
4166: wf_core.context('Wf_Directory', 'SetRoleAttr', SetRoleAttr.role_name,
4167: SetRoleAttr.display_name);
4168: raise;
4169: end SetRoleAttr;
4170:

Line 4200: wf_core.context('Wf_Directory', 'SetAdHocUserExpiration', user_name, expiration_date);

4196: status=>NULL);
4197:
4198: exception
4199: when others then
4200: wf_core.context('Wf_Directory', 'SetAdHocUserExpiration', user_name, expiration_date);
4201: raise;
4202: end SetAdHocUserExpiration;
4203:
4204: --

Line 4233: wf_core.context('Wf_Directory', 'SetAdHocRoleExpiration', role_name,

4229: status=>NULL);
4230:
4231: exception
4232: when others then
4233: wf_core.context('Wf_Directory', 'SetAdHocRoleExpiration', role_name,
4234: expiration_date);
4235: raise;
4236: end SetAdHocRoleExpiration;
4237:

Line 4283: wf_core.context('Wf_Directory', 'SetAdHocUserAttr', user_name,

4279: owner_tag=>SetAdhocUserAttr.owner_tag);
4280:
4281: exception
4282: when others then
4283: wf_core.context('Wf_Directory', 'SetAdHocUserAttr', user_name,
4284: display_name);
4285: raise;
4286: end SetAdHocUserAttr;
4287:

Line 4333: wf_core.context('Wf_Directory', 'SetAdHocRoleAttr', role_name,

4329: owner_tag=>SetAdHocRoleAttr.owner_tag);
4330:
4331: exception
4332: when others then
4333: wf_core.context('Wf_Directory', 'SetAdHocRoleAttr', role_name,
4334: display_name);
4335: raise;
4336: end SetAdHocRoleAttr;
4337:

Line 4395: wf_core.token('USERNAME', user);

4391: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4392: and UR.ROLE_ORIG_SYSTEM_ID = 0
4393: and UR.PARTITION_ID = 0;
4394: if (sql%rowcount = 0) then
4395: wf_core.token('USERNAME', user);
4396: wf_core.raise('WF_INVALID_USER');
4397: end if;
4398:
4399: -- Delete from wf_user_role_Assignments as well

Line 4396: wf_core.raise('WF_INVALID_USER');

4392: and UR.ROLE_ORIG_SYSTEM_ID = 0
4393: and UR.PARTITION_ID = 0;
4394: if (sql%rowcount = 0) then
4395: wf_core.token('USERNAME', user);
4396: wf_core.raise('WF_INVALID_USER');
4397: end if;
4398:
4399: -- Delete from wf_user_role_Assignments as well
4400: delete from WF_USER_ROLE_ASSIGNMENTS URA

Line 4414: wf_core.context('Wf_Directory', 'RemoveUsersFromAdHocRole',

4410: end if;
4411:
4412: exception
4413: when others then
4414: wf_core.context('Wf_Directory', 'RemoveUsersFromAdHocRole',
4415: role_name, '"'||role_users||'"');
4416: raise;
4417: end RemoveUsersFromAdHocRole;
4418:

Line 4464: WF_CORE.Context('WF_DIRECTORY', 'ChangeLocalUserName', OldName, NewName);

4460: end if;
4461:
4462: exception
4463: when others then
4464: WF_CORE.Context('WF_DIRECTORY', 'ChangeLocalUserName', OldName, NewName);
4465: raise;
4466:
4467: end ChangeLocalUserName;
4468:

Line 4673: WF_CORE.Context('WF_DIRECTORY', 'AssignPartition', p_orig_system);

4669: p_partitionName := g_partitionName;
4670:
4671: exception
4672: when OTHERS then
4673: WF_CORE.Context('WF_DIRECTORY', 'AssignPartition', p_orig_system);
4674: raise;
4675: end;
4676:
4677: -- Bug 3090738

Line 4982: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);

4978: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
4979: 'WF_DIRECTORY.deleteRole',
4980: 'Role is still active. Make sure it is end dated ');
4981: end if;
4982: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);
4983: WF_CORE.Token('ROLE',p_name);
4984: WF_CORE.Raise('WFDS_ROLE_ACTIVE');
4985: exception
4986: when no_data_found then

Line 4983: WF_CORE.Token('ROLE',p_name);

4979: 'WF_DIRECTORY.deleteRole',
4980: 'Role is still active. Make sure it is end dated ');
4981: end if;
4982: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);
4983: WF_CORE.Token('ROLE',p_name);
4984: WF_CORE.Raise('WFDS_ROLE_ACTIVE');
4985: exception
4986: when no_data_found then
4987:

Line 4984: WF_CORE.Raise('WFDS_ROLE_ACTIVE');

4980: 'Role is still active. Make sure it is end dated ');
4981: end if;
4982: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);
4983: WF_CORE.Token('ROLE',p_name);
4984: WF_CORE.Raise('WFDS_ROLE_ACTIVE');
4985: exception
4986: when no_data_found then
4987:
4988: delete from wf_local_roles

Line 5030: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);

5026:
5027:
5028: exception
5029: when others then
5030: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);
5031: raise;
5032: end;
5033:
5034:

Line 5073: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);

5069: or(p_rolename is not null and (p_roleOrigSystem is null
5070: or p_roleOrigSystemID is null))) then
5071:
5072: --raise error
5073: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
5074: WF_CORE.Raise('WFSQL_ARGS');
5075:
5076: elsif p_username is null then -- role has been passed
5077: begin

Line 5074: WF_CORE.Raise('WFSQL_ARGS');

5070: or p_roleOrigSystemID is null))) then
5071:
5072: --raise error
5073: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
5074: WF_CORE.Raise('WFSQL_ARGS');
5075:
5076: elsif p_username is null then -- role has been passed
5077: begin
5078:

Line 5110: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_rolename);

5106: 'WF_DIRECTORY.DeleteUserRole',
5107: 'User/Role assignment is still active. Make sure it is end dated ' ||
5108: 'and removed from any hierarchies');
5109: end if;
5110: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_rolename);
5111: WF_CORE.Token('ROLE',p_rolename);
5112: WF_CORE.Raise('WFDS_USER_ROLE_ACTIVE');
5113: exception
5114: when no_data_found then

Line 5111: WF_CORE.Token('ROLE',p_rolename);

5107: 'User/Role assignment is still active. Make sure it is end dated ' ||
5108: 'and removed from any hierarchies');
5109: end if;
5110: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_rolename);
5111: WF_CORE.Token('ROLE',p_rolename);
5112: WF_CORE.Raise('WFDS_USER_ROLE_ACTIVE');
5113: exception
5114: when no_data_found then
5115: -- assignment is truly end dated

Line 5112: WF_CORE.Raise('WFDS_USER_ROLE_ACTIVE');

5108: 'and removed from any hierarchies');
5109: end if;
5110: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_rolename);
5111: WF_CORE.Token('ROLE',p_rolename);
5112: WF_CORE.Raise('WFDS_USER_ROLE_ACTIVE');
5113: exception
5114: when no_data_found then
5115: -- assignment is truly end dated
5116:

Line 5153: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username);

5149: 'WF_DIRECTORY.DeleteUserRole',
5150: 'User/Role assignment is still active. Make sure it is end dated ' ||
5151: 'and removed from any hierarchies');
5152: end if;
5153: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username);
5154: WF_CORE.Token('ROLE',p_username);
5155: WF_CORE.Raise('WFDS_USER_ROLE_ACTIVE');
5156: exception
5157: when no_data_found then

Line 5154: WF_CORE.Token('ROLE',p_username);

5150: 'User/Role assignment is still active. Make sure it is end dated ' ||
5151: 'and removed from any hierarchies');
5152: end if;
5153: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username);
5154: WF_CORE.Token('ROLE',p_username);
5155: WF_CORE.Raise('WFDS_USER_ROLE_ACTIVE');
5156: exception
5157: when no_data_found then
5158: -- assignment is truly end dated

Line 5155: WF_CORE.Raise('WFDS_USER_ROLE_ACTIVE');

5151: 'and removed from any hierarchies');
5152: end if;
5153: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username);
5154: WF_CORE.Token('ROLE',p_username);
5155: WF_CORE.Raise('WFDS_USER_ROLE_ACTIVE');
5156: exception
5157: when no_data_found then
5158: -- assignment is truly end dated
5159:

Line 5204: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);

5200: 'WF_DIRECTORY.DeleteUserRole',
5201: 'User/Role assignment is still active. Make sure it is end dated ' ||
5202: 'and removed from any hierarchies');
5203: end if;
5204: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
5205: WF_CORE.Token('ROLE',p_rolename);
5206: WF_CORE.Token('USER',p_username);
5207: WF_CORE.Raise('WFDS_ASSIGNMENT_ACTIVE');
5208: exception

Line 5205: WF_CORE.Token('ROLE',p_rolename);

5201: 'User/Role assignment is still active. Make sure it is end dated ' ||
5202: 'and removed from any hierarchies');
5203: end if;
5204: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
5205: WF_CORE.Token('ROLE',p_rolename);
5206: WF_CORE.Token('USER',p_username);
5207: WF_CORE.Raise('WFDS_ASSIGNMENT_ACTIVE');
5208: exception
5209: when no_data_found then

Line 5206: WF_CORE.Token('USER',p_username);

5202: 'and removed from any hierarchies');
5203: end if;
5204: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
5205: WF_CORE.Token('ROLE',p_rolename);
5206: WF_CORE.Token('USER',p_username);
5207: WF_CORE.Raise('WFDS_ASSIGNMENT_ACTIVE');
5208: exception
5209: when no_data_found then
5210: -- assignment is truly end dated

Line 5207: WF_CORE.Raise('WFDS_ASSIGNMENT_ACTIVE');

5203: end if;
5204: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
5205: WF_CORE.Token('ROLE',p_rolename);
5206: WF_CORE.Token('USER',p_username);
5207: WF_CORE.Raise('WFDS_ASSIGNMENT_ACTIVE');
5208: exception
5209: when no_data_found then
5210: -- assignment is truly end dated
5211:

Line 5228: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);

5224: end;
5225: end if;
5226: exception
5227: when others then
5228: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
5229: raise;
5230: end;
5231:
5232: