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 727: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

723: p_direction=>'SUPERIORS');
724:
725: if (l_superiors.COUNT <= 0) then
726: --There is nothing to do.
727: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
728: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
729: g_modulePkg||'.Cascade_RF',
730: 'There are no superiors, updates are limited to this '||
731: 'user/role relationship.');

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

729: g_modulePkg||'.Cascade_RF',
730: 'There are no superiors, updates are limited to this '||
731: 'user/role relationship.');
732: end if;
733: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
734: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
735: g_modulePkg||'.Cascade_RF',
736: 'End Cascade_RF('||rawtohex(p_sub_guid)||', '||
737: p_event.getEventName||')');

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

744: --If we made it here, there is hierarchy processing to do. First we need
745: --to attempt to create a user/role for l_UserName to l_Superiors(i)
746: --then we need to create a user/role assignment for l_RoleName as the
747: --assigning role.
748: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
749: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
750: g_modulePkg||'.Cascade_RF',
751: 'Beginning user/role inheritance for '||l_UserName||
752: ' to the superior roles of '||l_RoleName);

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

751: 'Beginning user/role inheritance for '||l_UserName||
752: ' to the superior roles of '||l_RoleName);
753: end if;
754: for l_count in l_superiors.FIRST..l_superiors.LAST loop
755: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
756: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
757: g_modulePkg||'.Cascade_RF',
758: 'Beginning user/role inheritance for '||l_UserName||
759: ' to '||l_superiors(l_count).SUPER_NAME);

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

954: end if;
955: end;
956:
957: end loop;
958: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
959: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
960: g_modulePkg||'.Cascade_RF',
961: 'End Cascade_RF('||rawtohex(p_sub_guid)||', '||
962: p_event.getEventName||')');

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

982: l_rel VARCHAR2(10);
983: l_cp_ID NUMBER;
984:
985: begin
986: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
987: -- Log only
988: -- BINDVAR_SCAN_IGNORE[4]
989: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
990: g_modulePkg||'.Propagate_RF',

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

1019: return 'ERROR';
1020:
1021: end if;
1022: end if;
1023: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1024: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
1025: g_modulePkg||'.Propagate_RF',
1026: 'Concurrent request '||l_cp_id||
1027: ' Submitted for '||l_rel);

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

1026: 'Concurrent request '||l_cp_id||
1027: ' Submitted for '||l_rel);
1028: end if;
1029: end;
1030: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1031: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1032: g_modulePkg||'.Propagate_RF',
1033: 'End Propagate_RF('||rawtohex(p_sub_guid)||', '||
1034: p_event.getEventName||')');

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

1503: relIND number;
1504: l_propagateDate date;
1505:
1506: begin
1507: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1508: -- Log only
1509: -- BINDVAR_SCAN_IGNORE[3]
1510: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1511: g_modulePkg||'.Propagate_CP',

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

1532: end if;
1533:
1534: retcode := '0';
1535: commit;
1536: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1537: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1538: g_modulePkg||'.Propagate_CP',
1539: 'End Propagate_CP('||p_relationship_id||')');
1540: end if;

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

1539: 'End Propagate_CP('||p_relationship_id||')');
1540: end if;
1541: exception
1542: when OTHERS then
1543: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1544: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
1545: g_modulePkg||'.Propagate_CP', 'Exception: '||
1546: sqlerrm);
1547: end if;

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

1631: where ROLE_NAME = c_roleName
1632: or ASSIGNING_ROLE = c_roleName;
1633:
1634: begin
1635: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1636: -- Log only
1637: -- BINDVAR_SCAN_IGNORE[3]
1638: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1639: g_modulePkg||'.Denormalize_UR_Assignments',

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

1797: elsif (l_roleName is NOT NULL) then
1798: close c_UserRoleAssignments_r;
1799: end if;
1800:
1801: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1802: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1803: g_modulePkg||'.Denormalize_UR_Assignments',
1804: 'End Denormalize_UR_Assignments');
1805: end if;

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

1813: elsif c_UserRoleAssignments_r%ISOPEN then
1814: close c_UserRoleAssignments_r;
1815: end if;
1816:
1817: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1818: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
1819: g_modulePkg||'.Denormalize_UR_Assignments',
1820: 'Exception: '||sqlerrm);
1821: end if;

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

1961: order by ura.ROLE_NAME, ura.USER_NAME;
1962: --
1963:
1964: begin
1965: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1966: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1967: g_modulePkg||'.Aggregate_User_Roles_RF',
1968: 'Begin Aggregate_User_Roles_RF('||rawtohex(p_sub_guid)||', '||
1969: p_event.getEventName||')');

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

2285: AND USER_NAME = l_userDestTAB(tabIndex);
2286: end if;
2287: end if;
2288:
2289: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2290: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2291: g_modulePkg||'.Aggregate_User_Roles_RF',
2292: 'End Aggregate_User_Roles_RF('||rawtohex(p_sub_guid)||', '||
2293: p_event.getEventName||')');

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

2345: enabledTab enabled_Tab;
2346: --
2347:
2348: begin
2349: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2350: -- Log only
2351: -- BINDVAR_SCAN_IGNORE[4]
2352: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2353: g_modulePkg||'.GetRelationships',

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

2358:
2359: /*
2360: -- <9i Support>
2361: if (p_direction in ('SUPERIORS', 'BOTH')) then
2362: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2363: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2364: g_modulePkg||'.GetRelationships',
2365: 'Retrieving the superior relationships.');
2366: end if;

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

2375:
2376: end if;
2377:
2378: if (p_direction in ('SUBORDINATES', 'BOTH')) then
2379: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2380: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2381: g_modulePkg||'.GetRelationships',
2382: 'Retrieving the subordinate relationships.');
2383: end if;

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

2393: */
2394:
2395: --<8i Support>
2396: if (p_direction in ('SUPERIORS', 'BOTH')) then
2397: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2398: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2399: g_modulePkg||'.GetRelationships',
2400: 'Retrieving the superior relationships.');
2401: end if;

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

2418: end if;
2419: end if;
2420:
2421: if (p_direction in ('SUBORDINATES', 'BOTH')) then
2422: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2423: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2424: g_modulePkg||'.GetRelationships',
2425: 'Retrieving the subordinate relationships.');
2426: end if;

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

2445:
2446: --
2447:
2448: end;
2449: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2450: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2451: g_modulePkg||'.GetRelationships',
2452: 'End GetRelationships('||
2453: p_name||')');

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

2453: p_name||')');
2454: end if;
2455: exception
2456: when OTHERS then
2457: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
2458: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2459: g_modulePkg||'.GetRelationships', 'Exception: '||
2460: sqlerrm);
2461: end if;

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

2489: enabledTab enabled_Tab;
2490: --
2491:
2492: begin
2493: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2494: -- Log only
2495: -- BINDVAR_SCAN_IGNORE[4]
2496: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2497: g_modulePkg||'.GetAllRelationships',

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

2517: end if;
2518: end if;
2519:
2520: if (p_direction in ('SUBORDINATES', 'BOTH')) then
2521: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2522: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2523: g_modulePkg||'.GetAllRelationships',
2524: 'Retrieving the subordinate relationships.');
2525: end if;

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

2542: --
2543: /*--<9i Support>
2544: begin
2545: if (p_direction in ('SUPERIORS', 'BOTH')) then
2546: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2547: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2548: g_modulePkg||'.GetAllRelationships',
2549: 'Retrieving the superior relationships.');
2550: end if;

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

2556: START WITH SUB_NAME = upper(p_name);
2557: end if;
2558:
2559: if (p_direction in ('SUBORDINATES', 'BOTH')) then
2560: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2561: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2562: g_modulePkg||'.GetAllRelationships',
2563: 'Retrieving the subordinate relationships.');
2564: end if;

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

2570: START WITH SUPER_NAME = upper(p_name);
2571: end if;
2572: end;
2573: */
2574: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2575: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2576: g_modulePkg||'.GetAllRelationships',
2577: 'End GetAllRelationships('||
2578: p_name||')');

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

2578: p_name||')');
2579: end if;
2580: exception
2581: when OTHERS then
2582: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
2583: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2584: g_modulePkg||'.GetAllRelationships', 'Exception: '||
2585: sqlerrm);
2586: end if;

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

2626: --set the enabled_flag default to 'Y'
2627: l_enabled varchar2(1) := 'Y';
2628:
2629: begin
2630: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2631: -- Log only
2632: -- BINDVAR_SCAN_IGNORE[4]
2633: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2634: g_modulePkg||'.AddRelationship',

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

2667: into l_RelationshipID
2668: from dual;
2669:
2670: -- Perform the insert
2671: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2672: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2673: g_modulePkg||'.AddRelationship.Insert',
2674: 'Inserting record');
2675: end if;

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

2673: g_modulePkg||'.AddRelationship.Insert',
2674: 'Inserting record');
2675: end if;
2676: begin
2677: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2678: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2679: g_modulePkg||'.AddRelationship',
2680: 'Setting savepoint loopCheck');
2681: end if;

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

2681: end if;
2682: savepoint loopCheck;
2683: exception
2684: when trig_SavePoint then
2685: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
2686: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
2687: g_modulePkg||'.AddRelationship',
2688: 'Call stack initiated from trigger, unable to set '||
2689: 'savepoint. Any exception will result in complete '||

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

2728: exception
2729: when DUP_VAL_ON_INDEX then
2730: -- The row already exists, if it is expired, we can update with
2731: -- with the new information, if it is active, we will raise an error.
2732: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
2733: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
2734: g_modulePkg||
2735: '.AddRelationship.Insert.DUP_VAL_ON_INDEX',
2736: 'Updating expired relationship');

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

2749: if (sql%ROWCOUNT = 0) then
2750: --We already encountered a dup_val_on_index with sub/super name
2751: --so by default for the above update to not work the enabled_flag
2752: --would have to be 'Y' which is a true duplicate.
2753: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
2754: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
2755: g_modulePkg||
2756: '.AddRelationship.Insert.DUP_VAL_ON_INDEX.NoUpdate',
2757: 'Active relationship exists, raising WFDS_DUP_HIERARCHY');

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

2786: p_relationshipID=>l_RelationshipID,
2787: p_superName=>p_super_name,
2788: p_subName=>p_sub_name,
2789: p_defer=>p_deferMode);
2790: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2791: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, g_modulePkg||
2792: '.AddRelationship',
2793: 'End AddRelationship('|| p_sub_name||', '||
2794: p_super_name||')');

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

2796: return l_RelationshipID;
2797:
2798: exception
2799: when HierarchyLoop then
2800: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
2801: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
2802: g_modulePkg||'.AddRelationship',
2803: 'Circular reference detected in hierarchy.');
2804: end if;

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

2802: g_modulePkg||'.AddRelationship',
2803: 'Circular reference detected in hierarchy.');
2804: end if;
2805: if (called_from_trigger) then
2806: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2807: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2808: g_modulePkg||'.AddRelationship',
2809: 'Initiation from trigger prevents rollback to '||
2810: 'savepoint executing complete rollback.');

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

2812: rollback;
2813: else
2814: rollback to loopCheck;
2815: end if;
2816: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
2817: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2818: g_modulePkg||'.AddRelationship', 'Exception: '||
2819: sqlerrm);
2820: end if;

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

2822: p_super_name);
2823: WF_CORE.Raise('WFDS_HIERARCHY_LOOP');
2824:
2825: when OTHERS then
2826: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
2827: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2828: g_modulePkg||'.AddRelationship', 'Exception: '||
2829: sqlerrm);
2830: end if;

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

2850:
2851: l_relationshipID NUMBER;
2852:
2853: begin
2854: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2855: -- Log only
2856: -- BINDVAR_SCAN_IGNORE[4]
2857: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
2858: g_modulePkg||'.ExpireRelationship',

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

2859: 'Begin ExpireRelationship('||
2860: p_sub_name||', '||p_super_name||')');
2861: end if;
2862: begin
2863: if(wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
2864: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2865: g_modulePkg||'.ExpireRelationship.Update',
2866: 'Updating record');
2867: end if;

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

2876: returning RELATIONSHIP_ID into l_relationshipID;
2877:
2878: if (sql%ROWCOUNT = 0) then
2879: -- There is no active role hierarchy relationship to expire
2880: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
2881: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION, g_modulePkg||
2882: '.ExpireRelationship.Update.NoActiveRelationship',
2883: 'No Active relationship exists, '||
2884: 'raising WFDS_NO_HIERARCHY');

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

2897: p_superName=>p_super_name,
2898: p_subName=>p_sub_name,
2899: p_defer=>p_defer_mode);
2900:
2901: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2902: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, g_modulePkg||
2903: '.ExpireRelationship',
2904: 'End ExpireRelationship('|| p_sub_name||', '||
2905: p_super_name||')');

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

2908: return l_RelationshipID;
2909:
2910: exception
2911: when OTHERS then
2912: if(wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
2913: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2914: g_modulePkg||'.ExpireRelationship', 'Exception: '||
2915: sqlerrm);
2916: end if;