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_ROLE_HIERARCHY dependencies on FND_LOG

Line 33: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

29:
30: l_params WF_PARAMETER_LIST_T;
31:
32: begin
33: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
34: -- Log only
35: -- BINDVAR_SCAN_IGNORE[5]
36: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
37: g_modulePkg||'.RaiseEvent',

Line 60: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

56:
57: WF_EVENT.Raise(P_EVENT_NAME=>p_eventName,
58: P_EVENT_KEY=>p_relationshipID, P_PARAMETERS=>l_params);
59:
60: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
61: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
62: g_modulePkg||'.RaiseEvent',
63: 'End RaiseEvent('||p_eventName||', '||
64: p_relationshipID||', '||p_superName||', '||

Line 69: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

65: p_subName||')');
66: end if;
67: exception
68: when OTHERS then
69: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
70: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
71: g_modulePkg||'.RaiseEvent',
72: 'Exception: '||sqlerrm);
73: end if;

Line 101: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

97: l_partitionName varchar2(30);
98: l_hierarchyEnabled BOOLEAN;
99:
100: begin
101: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
102: -- Log only
103: -- BINDVAR_SCAN_IGNORE[3]
104: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
105: g_modulePkg||'.HierarchyEnabled',

Line 128: if wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level then

124:
125: exception
126: when NO_DATA_FOUND then
127: l_hierarchyEnabled := TRUE;
128: if wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level then
129: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
130: g_modulePkg||'.HierarchyEnabled',
131: p_origSystem||' is hierarchy enabled.');
132: end if;

Line 153: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

149: when NO_DATA_FOUND then
150: l_hierarchyEnabled := FALSE;
151: end;
152: end if;
153: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
154: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
155: g_modulePkg||'.HierarchyEnabled',
156: 'End HierarchyEnabled('||p_origSystem||')');
157: end if;

Line 162: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

158: return l_HierarchyEnabled;
159:
160: exception
161: when OTHERS then
162: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
163: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
164: g_modulePkg||'.HierarchyEnabled',
165: 'Exception: '||sqlerrm);
166: end if;

Line 209: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

205: is
206:
207: begin
208:
209: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
210: -- Log only
211: -- BINDVAR_SCAN_IGNORE[9]
212: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
213: g_modulePkg||'.Calculate_Effective_Dates',

Line 243: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

239: nvl(p_roleEndDate, p_effEndDate),
240: nvl(p_assignRoleEnd, p_effEndDate));
241:
242:
243: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
244: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
245: g_modulePkg||'.Calculate_Effective_Dates',
246: 'End Calculate_Effective_Dates');
247: end if;

Line 250: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

246: 'End Calculate_Effective_Dates');
247: end if;
248: exception
249: when OTHERS then
250: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
251: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
252: g_modulePkg||'.Calculate_Effective_Dates',
253: 'Exception: '||sqlerrm);
254: end if;

Line 294: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

290: l_assignmentType VARCHAR2(1) := 'X';
291: arIND NUMBER;
292:
293: begin
294: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
295: -- Log only
296: -- BINDVAR_SCAN_IGNORE[4]
297: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
298: g_modulePkg||'.AssignmentType',

Line 350: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

346: end if;
347: end if;
348: end loop assignmentTypes;
349:
350: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
351: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
352: g_modulePkg||'.AssignmentType',
353: 'End AssignmentType('||p_UserName||', '||
354: p_RoleName||') returning ['||l_assignmentType||']');

Line 421: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

417: OverWrite BOOLEAN;
418: UpdateWho BOOLEAN := TRUE;
419:
420: begin
421: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
422: -- Log only
423: -- BINDVAR_SCAN_IGNORE[4]
424: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
425: g_modulePkg||'.Cascade_RF',

Line 430: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

426: 'Begin Cascade_RF('||rawtohex(p_sub_guid)||', '||
427: p_event.getEventName||')');
428: end if;
429: --Retrieve the parameters from the event and cast to appropiate data types.
430: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
431: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
432: g_modulePkg||'.Cascade_RF',
433: 'Retrieving parameters from the event.');
434: end if;

Line 476: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

472:
473: --If this is not a direct assignment, we don't need to cascade
474: --the user/role creation, but we do need to validate the assignment type..
475: if (p_event.getValueForParameter('ASSIGNMENT_TYPE') <> 'D') then
476: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
477: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
478: g_modulePkg||'.Cascade_RF',
479: 'This is not a direct assignment, so nothing to '||
480: 'cascade. But we need to check of existing direct '||

Line 484: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

480: 'cascade. But we need to check of existing direct '||
481: 'assignments that would cause the denormalized '||
482: 'assignment_type to be set to B from D');
483: end if;
484: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
485: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
486: g_modulePkg||'.Cascade_RF',
487: 'End Cascade_RF('||rawtohex(p_sub_guid)||', '||
488: p_event.getEventName||')');

Line 498: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

494: UPDATE WF_LOCAL_USER_ROLES
495: SET ASSIGNMENT_TYPE = l_assignmentType
496: WHERE ROWID = l_rowid;
497:
498: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
499: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
500: g_modulePkg||'.Cascade_RF',
501: 'End Cascade_RF('||rawtohex(p_sub_guid)||', '||
502: p_event.getEventName||') returning [SUCCESS]');

Line 624: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

620: where rowid = l_rowIDTAB(tabIndex);
621:
622: end if;
623:
624: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
625: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
626: g_modulePkg||'.Cascade_RF',
627: 'Assignments for assigning role: '||
628: l_RoleName||' exist for user '||l_UserName||

Line 631: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

627: 'Assignments for assigning role: '||
628: l_RoleName||' exist for user '||l_UserName||
629: '. Updated existing assignments.');
630: end if;
631: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
632: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
633: g_modulePkg||'.Cascade_RF',
634: 'End Cascade_RF('||rawtohex(p_sub_guid)||', '||
635: p_event.getEventName||')');

Line 750: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

746: p_direction=>'SUPERIORS');
747:
748: if (l_superiors.COUNT <= 0) then
749: --There is nothing to do.
750: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
751: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
752: g_modulePkg||'.Cascade_RF',
753: 'There are no superiors, updates are limited to this '||
754: 'user/role relationship.');

Line 756: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

752: g_modulePkg||'.Cascade_RF',
753: 'There are no superiors, updates are limited to this '||
754: 'user/role relationship.');
755: end if;
756: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
757: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
758: g_modulePkg||'.Cascade_RF',
759: 'End Cascade_RF('||rawtohex(p_sub_guid)||', '||
760: p_event.getEventName||')');

Line 771: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

767: --If we made it here, there is hierarchy processing to do. First we need
768: --to attempt to create a user/role for l_UserName to l_Superiors(i)
769: --then we need to create a user/role assignment for l_RoleName as the
770: --assigning role.
771: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
772: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
773: g_modulePkg||'.Cascade_RF',
774: 'Beginning user/role inheritance for '||l_UserName||
775: ' to the superior roles of '||l_RoleName);

Line 778: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

774: 'Beginning user/role inheritance for '||l_UserName||
775: ' to the superior roles of '||l_RoleName);
776: end if;
777: for l_count in l_superiors.FIRST..l_superiors.LAST loop
778: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
779: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
780: g_modulePkg||'.Cascade_RF',
781: 'Beginning user/role inheritance for '||l_UserName||
782: ' to '||l_superiors(l_count).SUPER_NAME);

Line 981: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

977: end if;
978: end;
979:
980: end loop;
981: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
982: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
983: g_modulePkg||'.Cascade_RF',
984: 'End Cascade_RF('||rawtohex(p_sub_guid)||', '||
985: p_event.getEventName||')');

Line 1009: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1005: l_rel VARCHAR2(10);
1006: l_cp_ID NUMBER;
1007:
1008: begin
1009: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1010: -- Log only
1011: -- BINDVAR_SCAN_IGNORE[4]
1012: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1013: g_modulePkg||'.Propagate_RF',

Line 1045: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1041: return 'ERROR';
1042: end if;
1043: end if;
1044: end if;
1045: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1046: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
1047: g_modulePkg||'.Propagate_RF',
1048: 'Concurrent request '||l_cp_id||
1049: ' Submitted for '||l_rel);

Line 1052: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1048: 'Concurrent request '||l_cp_id||
1049: ' Submitted for '||l_rel);
1050: end if;
1051: end;
1052: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1053: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1054: g_modulePkg||'.Propagate_RF',
1055: 'End Propagate_RF('||rawtohex(p_sub_guid)||', '||
1056: p_event.getEventName||')');

Line 1535: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1531: relIND number;
1532: l_propagateDate date;
1533:
1534: begin
1535: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1536: -- Log only
1537: -- BINDVAR_SCAN_IGNORE[3]
1538: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1539: g_modulePkg||'.Propagate_CP',

Line 1564: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1560: end if;
1561:
1562: retcode := '0';
1563: commit;
1564: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1565: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1566: g_modulePkg||'.Propagate_CP',
1567: 'End Propagate_CP('||p_relationship_id||')');
1568: end if;

Line 1571: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

1567: 'End Propagate_CP('||p_relationship_id||')');
1568: end if;
1569: exception
1570: when OTHERS then
1571: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1572: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
1573: g_modulePkg||'.Propagate_CP', 'Exception: '||
1574: sqlerrm);
1575: end if;

Line 1663: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1659: where ROLE_NAME = c_roleName
1660: or ASSIGNING_ROLE = c_roleName;
1661:
1662: begin
1663: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1664: -- Log only
1665: -- BINDVAR_SCAN_IGNORE[3]
1666: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1667: g_modulePkg||'.Denormalize_UR_Assignments',

Line 1829: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1825: elsif (l_roleName is NOT NULL) then
1826: close c_UserRoleAssignments_r;
1827: end if;
1828:
1829: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1830: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1831: g_modulePkg||'.Denormalize_UR_Assignments',
1832: 'End Denormalize_UR_Assignments');
1833: end if;

Line 1845: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

1841: elsif c_UserRoleAssignments_r%ISOPEN then
1842: close c_UserRoleAssignments_r;
1843: end if;
1844:
1845: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1846: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
1847: g_modulePkg||'.Denormalize_UR_Assignments',
1848: 'Exception: '||sqlerrm);
1849: end if;

Line 1993: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1989: order by ura.ROLE_NAME, ura.USER_NAME;
1990: --
1991:
1992: begin
1993: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1994: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1995: g_modulePkg||'.Aggregate_User_Roles_RF',
1996: 'Begin Aggregate_User_Roles_RF('||rawtohex(p_sub_guid)||', '||
1997: p_event.getEventName||')');

Line 2317: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

2313: AND USER_NAME = l_userDestTAB(tabIndex);
2314: end if;
2315: end if;
2316:
2317: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2318: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2319: g_modulePkg||'.Aggregate_User_Roles_RF',
2320: 'End Aggregate_User_Roles_RF('||rawtohex(p_sub_guid)||', '||
2321: p_event.getEventName||')');

Line 2366: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

2362: p_direction in VARCHAR2 )
2363: is
2364:
2365: begin
2366: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2367: -- Log only
2368: -- BINDVAR_SCAN_IGNORE[4]
2369: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2370: g_modulePkg||'.GetRelationships',

Line 2377: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

2373: end if;
2374: begin
2375:
2376: if (p_direction in ('SUPERIORS', 'BOTH')) then
2377: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2378: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2379: g_modulePkg||'.GetRelationships',
2380: 'Retrieving the superior relationships.');
2381: end if;

Line 2393: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

2389:
2390: end if;
2391:
2392: if (p_direction in ('SUBORDINATES', 'BOTH')) then
2393: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2394: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2395: g_modulePkg||'.GetRelationships',
2396: 'Retrieving the subordinate relationships.');
2397: end if;

Line 2407: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

2403: CONNECT BY PRIOR SUB_NAME = SUPER_NAME
2404: START WITH SUPER_NAME = upper(p_name);
2405: end if;
2406: end;
2407: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2408: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2409: g_modulePkg||'.GetRelationships',
2410: 'End GetRelationships('||
2411: p_name||')');

Line 2415: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

2411: p_name||')');
2412: end if;
2413: exception
2414: when OTHERS then
2415: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
2416: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2417: g_modulePkg||'.GetRelationships', 'Exception: '||
2418: sqlerrm);
2419: end if;

Line 2451: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

2447: enabledTab enabled_Tab;
2448: --
2449:
2450: begin
2451: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2452: -- Log only
2453: -- BINDVAR_SCAN_IGNORE[4]
2454: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2455: g_modulePkg||'.GetAllRelationships',

Line 2479: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

2475: end if;
2476: end if;
2477:
2478: if (p_direction in ('SUBORDINATES', 'BOTH')) then
2479: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2480: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2481: g_modulePkg||'.GetAllRelationships',
2482: 'Retrieving the subordinate relationships.');
2483: end if;

Line 2504: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

2500: --
2501: /*--<9i Support>
2502: begin
2503: if (p_direction in ('SUPERIORS', 'BOTH')) then
2504: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2505: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2506: g_modulePkg||'.GetAllRelationships',
2507: 'Retrieving the superior relationships.');
2508: end if;

Line 2518: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

2514: START WITH SUB_NAME = upper(p_name);
2515: end if;
2516:
2517: if (p_direction in ('SUBORDINATES', 'BOTH')) then
2518: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2519: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2520: g_modulePkg||'.GetAllRelationships',
2521: 'Retrieving the subordinate relationships.');
2522: end if;

Line 2532: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

2528: START WITH SUPER_NAME = upper(p_name);
2529: end if;
2530: end;
2531: */
2532: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2533: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2534: g_modulePkg||'.GetAllRelationships',
2535: 'End GetAllRelationships('||
2536: p_name||')');

Line 2540: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

2536: p_name||')');
2537: end if;
2538: exception
2539: when OTHERS then
2540: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
2541: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2542: g_modulePkg||'.GetAllRelationships', 'Exception: '||
2543: sqlerrm);
2544: end if;

Line 2589: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

2585: l_enabled varchar2(1) := 'Y';
2586: l_enabled_flag varchar2(1);
2587:
2588: begin
2589: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2590: -- Log only
2591: -- BINDVAR_SCAN_IGNORE[4]
2592: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2593: g_modulePkg||'.AddRelationship',

Line 2630: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

2626: into l_RelationshipID
2627: from dual;
2628:
2629: -- Perform the insert
2630: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2631: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2632: g_modulePkg||'.AddRelationship.Insert',
2633: 'Inserting record');
2634: end if;

Line 2636: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

2632: g_modulePkg||'.AddRelationship.Insert',
2633: 'Inserting record');
2634: end if;
2635: begin
2636: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2637: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2638: g_modulePkg||'.AddRelationship',
2639: 'Setting savepoint loopCheck');
2640: end if;

Line 2644: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then

2640: end if;
2641: savepoint loopCheck;
2642: exception
2643: when trig_SavePoint then
2644: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
2645: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
2646: g_modulePkg||'.AddRelationship',
2647: 'Call stack initiated from trigger, unable to set '||
2648: 'savepoint. Any exception will result in complete '||

Line 2691: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then

2687: exception
2688: when DUP_VAL_ON_INDEX then
2689: -- The row already exists, if it is expired, we can update with
2690: -- with the new information, if it is active, we will raise an error.
2691: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
2692: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
2693: g_modulePkg||
2694: '.AddRelationship.Insert.DUP_VAL_ON_INDEX',
2695: 'Updating existing relationship');

Line 2704: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then

2700: SUPER_NAME = p_super_name;
2701: if (l_enabled_flag='Y' and l_enabled='Y') then
2702: --We already encountered a dup_val_on_index and the relationship is
2703: -- being activated despite of being active. We raise an error:
2704: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
2705: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION, g_modulePkg||
2706: '.AddRelationship.Insert.DUP_VAL_ON_INDEX.NoUpdate',
2707: 'Active relationship exists, raising WFDS_DUP_HIERARCHY');
2708: end if;

Line 2750: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

2746: p_relationshipID=>l_RelationshipID,
2747: p_superName=>p_super_name,
2748: p_subName=>p_sub_name,
2749: p_defer=>p_deferMode);
2750: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2751: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, g_modulePkg||
2752: '.AddRelationship',
2753: 'End AddRelationship('|| p_sub_name||', '||
2754: p_super_name||')');

Line 2760: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then

2756: return l_RelationshipID;
2757:
2758: exception
2759: when HierarchyLoop then
2760: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
2761: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
2762: g_modulePkg||'.AddRelationship',
2763: 'Circular reference detected in hierarchy.');
2764: end if;

Line 2766: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

2762: g_modulePkg||'.AddRelationship',
2763: 'Circular reference detected in hierarchy.');
2764: end if;
2765: if (called_from_trigger) then
2766: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2767: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2768: g_modulePkg||'.AddRelationship',
2769: 'Initiation from trigger prevents rollback to '||
2770: 'savepoint executing complete rollback.');

Line 2776: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

2772: rollback;
2773: else
2774: rollback to loopCheck;
2775: end if;
2776: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
2777: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2778: g_modulePkg||'.AddRelationship', 'Exception: '||
2779: sqlerrm);
2780: end if;

Line 2786: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

2782: p_super_name);
2783: WF_CORE.Raise('WFDS_HIERARCHY_LOOP');
2784:
2785: when OTHERS then
2786: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
2787: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2788: g_modulePkg||'.AddRelationship', 'Exception: '||
2789: sqlerrm);
2790: end if;

Line 2814: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

2810:
2811: l_relationshipID NUMBER;
2812:
2813: begin
2814: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2815: -- Log only
2816: -- BINDVAR_SCAN_IGNORE[4]
2817: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2818: g_modulePkg||'.ExpireRelationship',

Line 2823: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

2819: 'Begin ExpireRelationship('||
2820: p_sub_name||', '||p_super_name||')');
2821: end if;
2822: begin
2823: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2824: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2825: g_modulePkg||'.ExpireRelationship.Update',
2826: 'Updating record');
2827: end if;

Line 2840: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then

2836: returning RELATIONSHIP_ID into l_relationshipID;
2837:
2838: if (sql%ROWCOUNT = 0) then
2839: -- There is no active role hierarchy relationship to expire
2840: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
2841: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION, g_modulePkg||
2842: '.ExpireRelationship.Update.NoActiveRelationship',
2843: 'No Active relationship exists, '||
2844: 'raising WFDS_NO_HIERARCHY');

Line 2861: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

2857: p_superName=>p_super_name,
2858: p_subName=>p_sub_name,
2859: p_defer=>p_defer_mode);
2860:
2861: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2862: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, g_modulePkg||
2863: '.ExpireRelationship',
2864: 'End ExpireRelationship('|| p_sub_name||', '||
2865: p_super_name||')');

Line 2872: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

2868: return l_RelationshipID;
2869:
2870: exception
2871: when OTHERS then
2872: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
2873: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2874: g_modulePkg||'.ExpireRelationship', 'Exception: '||
2875: sqlerrm);
2876: end if;