APPS.UMX_USER_SEARCH_PVT dependencies on FND_LOG

Line 15: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

11: l_encrypted_user_password FND_USER.ENCRYPTED_USER_PASSWORD%TYPE;
12:
13: BEGIN
14:
15: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
16: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
17: 'fnd.plsql.UMXUSRSB.getStatusCode.begin',
18: 'userId: ' || p_user_id ||
19: ' | startDate: ' || p_start_date ||

Line 16: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

12:
13: BEGIN
14:
15: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
16: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
17: 'fnd.plsql.UMXUSRSB.getStatusCode.begin',
18: 'userId: ' || p_user_id ||
19: ' | startDate: ' || p_start_date ||
20: ' | endDate: ' || p_end_date);

Line 41: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

37: else
38: l_lookup_code := 'INACTIVE';
39: end if;
40:
41: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
42: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
43: 'fnd.plsql.UMXUSRSB.getStatusCode.end',
44: 'lookupCode: ' || l_lookup_code);
45: end if;

Line 42: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

38: l_lookup_code := 'INACTIVE';
39: end if;
40:
41: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
42: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
43: 'fnd.plsql.UMXUSRSB.getStatusCode.end',
44: 'lookupCode: ' || l_lookup_code);
45: end if;
46:

Line 58: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

54: obj_pk_val varchar2 ) RETURN varchar2 IS
55: "Return Value" BOOLEAN;
56: l_return_value_str varchar2 (5);
57: BEGIN
58: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
59: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
60: 'fnd.plsql.UMXUSRSB.canResetPassword.begin',
61: 'userName: ' || userName ||
62: ' | funcName: ' || funcName ||

Line 59: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

55: "Return Value" BOOLEAN;
56: l_return_value_str varchar2 (5);
57: BEGIN
58: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
59: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
60: 'fnd.plsql.UMXUSRSB.canResetPassword.begin',
61: 'userName: ' || userName ||
62: ' | funcName: ' || funcName ||
63: ' | objectName: ' || object_name ||

Line 82: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

78: else
79: l_return_value_str := 'FALSE';
80: end if;
81:
82: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
83: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
84: 'fnd.plsql.UMXUSRSB.canResetPassword.end',
85: 'returnValue: ' || l_return_value_str);
86: end if;

Line 83: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

79: l_return_value_str := 'FALSE';
80: end if;
81:
82: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
83: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
84: 'fnd.plsql.UMXUSRSB.canResetPassword.end',
85: 'returnValue: ' || l_return_value_str);
86: end if;
87:

Line 106: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

102: and lookup_code = l_lookup_code;
103:
104: BEGIN
105:
106: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
107: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
108: 'fnd.plsql.UMXUSRSB.getAccountStatus.begin',
109: 'userId: ' || p_user_id ||
110: ' | startDate: ' || p_start_date ||

Line 107: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

103:
104: BEGIN
105:
106: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
107: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
108: 'fnd.plsql.UMXUSRSB.getAccountStatus.begin',
109: 'userId: ' || p_user_id ||
110: ' | startDate: ' || p_start_date ||
111: ' | endDate: ' || p_end_date);

Line 122: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

118: open get_lookup_meaning (l_lookup_code);
119: fetch get_lookup_meaning into l_status;
120: close get_lookup_meaning;
121:
122: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
123: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
124: 'fnd.plsql.UMXUSRSB.getAccountStatus.end',
125: 'status: ' || l_status);
126: end if;

Line 123: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

119: fetch get_lookup_meaning into l_status;
120: close get_lookup_meaning;
121:
122: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
123: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
124: 'fnd.plsql.UMXUSRSB.getAccountStatus.end',
125: 'status: ' || l_status);
126: end if;
127:

Line 138: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

134: p_start_date IN date,
135: p_end_date IN date ) RETURN varchar2 IS
136:
137: begin
138: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
139: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
140: 'fnd.plsql.UMXUSRSB.getAccountStatusCode.begin',
141: 'userId: ' || p_user_id ||
142: ' | startDate: ' || p_start_date ||

Line 139: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

135: p_end_date IN date ) RETURN varchar2 IS
136:
137: begin
138: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
139: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
140: 'fnd.plsql.UMXUSRSB.getAccountStatusCode.begin',
141: 'userId: ' || p_user_id ||
142: ' | startDate: ' || p_start_date ||
143: ' | endDate: ' || p_end_date);

Line 146: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

142: ' | startDate: ' || p_start_date ||
143: ' | endDate: ' || p_end_date);
144: end if;
145:
146: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
147: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
148: 'fnd.plsql.UMXUSRSB.getAccountStatusCode.end', '');
149: end if;
150:

Line 147: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

143: ' | endDate: ' || p_end_date);
144: end if;
145:
146: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
147: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
148: 'fnd.plsql.UMXUSRSB.getAccountStatusCode.end', '');
149: end if;
150:
151: return getStatusCode(p_user_id => p_user_id,