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.FND_OID_SUBSCRIPTIONS dependencies on FND_LOG

Line 52: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

48:
49:
50: begin
51: l_module_source := G_MODULE_SOURCE || 'fnd_create_update: ';
52: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
53: then
54: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
55: end if;
56: if (p_event_type = wf_oid.IDENTITY_MODIFY) then

Line 54: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

50: begin
51: l_module_source := G_MODULE_SOURCE || 'fnd_create_update: ';
52: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
53: then
54: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
55: end if;
56: if (p_event_type = wf_oid.IDENTITY_MODIFY) then
57: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
58: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'IDENTITY_MODIFY '

Line 57: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

53: then
54: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
55: end if;
56: if (p_event_type = wf_oid.IDENTITY_MODIFY) then
57: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
58: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'IDENTITY_MODIFY '
59: || 'event is handled by fnd_user_pkg.user_change().');
60: end if;
61: return;

Line 58: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'IDENTITY_MODIFY '

54: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
55: end if;
56: if (p_event_type = wf_oid.IDENTITY_MODIFY) then
57: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
58: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'IDENTITY_MODIFY '
59: || 'event is handled by fnd_user_pkg.user_change().');
60: end if;
61: return;
62: end if;

Line 72: if(fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

68: update fnd_user set end_date= sysdate
69: where user_name = l_apps_userguid_key.user_name;
70: end if;
71: if (l_apps_userguid_key.user_id is not null) then
72: if(fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
73: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,
74: 'GUID ' || p_user_guid || ' is already linked'
75: || ' to user_name ' || l_apps_userguid_key.user_name);
76: end if;

Line 73: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,

69: where user_name = l_apps_userguid_key.user_name;
70: end if;
71: if (l_apps_userguid_key.user_id is not null) then
72: if(fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
73: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,
74: 'GUID ' || p_user_guid || ' is already linked'
75: || ' to user_name ' || l_apps_userguid_key.user_name);
76: end if;
77: return;

Line 85: if(fnd_log.LEVEL_UNEXPECTED >=

81: l_apps_username_key := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);
82: if (l_apps_username_key.user_id is not null) then
83: -- Is this user linked to someone else? Raise alert because it's a security threat.
84: if (l_apps_username_key.user_guid is not null and l_apps_username_key.user_guid <> p_user_guid) then
85: if(fnd_log.LEVEL_UNEXPECTED >=
86: fnd_log.G_CURRENT_RUNTIME_LEVEL) then
87: fnd_message.SET_NAME('FND', 'FND_SSO_UNABLE_TO_LINK');
88: fnd_message.SET_TOKEN('USER_NAME', p_user_name);
89: fnd_message.SET_TOKEN('ORCLGUID', l_apps_username_key.user_guid);

Line 86: fnd_log.G_CURRENT_RUNTIME_LEVEL) then

82: if (l_apps_username_key.user_id is not null) then
83: -- Is this user linked to someone else? Raise alert because it's a security threat.
84: if (l_apps_username_key.user_guid is not null and l_apps_username_key.user_guid <> p_user_guid) then
85: if(fnd_log.LEVEL_UNEXPECTED >=
86: fnd_log.G_CURRENT_RUNTIME_LEVEL) then
87: fnd_message.SET_NAME('FND', 'FND_SSO_UNABLE_TO_LINK');
88: fnd_message.SET_TOKEN('USER_NAME', p_user_name);
89: fnd_message.SET_TOKEN('ORCLGUID', l_apps_username_key.user_guid);
90: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED, l_module_source, TRUE);

Line 90: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED, l_module_source, TRUE);

86: fnd_log.G_CURRENT_RUNTIME_LEVEL) then
87: fnd_message.SET_NAME('FND', 'FND_SSO_UNABLE_TO_LINK');
88: fnd_message.SET_TOKEN('USER_NAME', p_user_name);
89: fnd_message.SET_TOKEN('ORCLGUID', l_apps_username_key.user_guid);
90: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED, l_module_source, TRUE);
91: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,
92: 'User_name ' || p_user_name || '
93: already exists in E-Business and is linked to an OID account with GUID '
94: || l_apps_username_key.user_guid);

Line 91: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,

87: fnd_message.SET_NAME('FND', 'FND_SSO_UNABLE_TO_LINK');
88: fnd_message.SET_TOKEN('USER_NAME', p_user_name);
89: fnd_message.SET_TOKEN('ORCLGUID', l_apps_username_key.user_guid);
90: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED, l_module_source, TRUE);
91: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,
92: 'User_name ' || p_user_name || '
93: already exists in E-Business and is linked to an OID account with GUID '
94: || l_apps_username_key.user_guid);
95: end if;

Line 99: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

95: end if;
96: end if;
97: return;
98: end if;
99: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
100: then
101: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Enabled flag is: ' || p_isenabled);
102: end if;
103: -- Don't create user if disabled in OID

Line 101: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Enabled flag is: ' || p_isenabled);

97: return;
98: end if;
99: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
100: then
101: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Enabled flag is: ' || p_isenabled);
102: end if;
103: -- Don't create user if disabled in OID
104: if (p_isenabled = 'INACTIVE' or p_isenabled = 'DISABLED') then
105: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

Line 105: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

101: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Enabled flag is: ' || p_isenabled);
102: end if;
103: -- Don't create user if disabled in OID
104: if (p_isenabled = 'INACTIVE' or p_isenabled = 'DISABLED') then
105: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
106: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
107: 'User ' || p_user_name || ' will not be created in FND_USER, because ' ||
108: 'it''s Disabled in OID.');
109: end if;

Line 106: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,

102: end if;
103: -- Don't create user if disabled in OID
104: if (p_isenabled = 'INACTIVE' or p_isenabled = 'DISABLED') then
105: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
106: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
107: 'User ' || p_user_name || ' will not be created in FND_USER, because ' ||
108: 'it''s Disabled in OID.');
109: end if;
110: return;

Line 114: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

110: return;
111: end if;
112:
113: --This means neither user name nor guid exist in fnd_user
114: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
115: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
116: 'User does not exist in FND_USER. About to create a new user...');
117: end if;
118: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 115: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,

111: end if;
112:
113: --This means neither user name nor guid exist in fnd_user
114: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
115: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
116: 'User does not exist in FND_USER. About to create a new user...');
117: end if;
118: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
119: then

Line 118: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

114: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
115: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
116: 'User does not exist in FND_USER. About to create a new user...');
117: end if;
118: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
119: then
120: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Start_date input: ' || p_start_date);
121: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End_date input: ' || p_end_date);
122: end if;

Line 120: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Start_date input: ' || p_start_date);

116: 'User does not exist in FND_USER. About to create a new user...');
117: end if;
118: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
119: then
120: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Start_date input: ' || p_start_date);
121: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End_date input: ' || p_end_date);
122: end if;
123: -- WF_ENTITY_MGR returns '*UNKNOWN*' string if the value was not found in attr_cache table
124: -- we should not populate the fnd_user table with this, for fax and description.

Line 121: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End_date input: ' || p_end_date);

117: end if;
118: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
119: then
120: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Start_date input: ' || p_start_date);
121: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End_date input: ' || p_end_date);
122: end if;
123: -- WF_ENTITY_MGR returns '*UNKNOWN*' string if the value was not found in attr_cache table
124: -- we should not populate the fnd_user table with this, for fax and description.
125:

Line 151: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

147: else
148: l_start_date := to_date(substr(p_start_date, 1, 14), fnd_oid_util.G_YYYYMMDDHH24MISS);
149: end if;
150:
151: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
152: then
153: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Start_date output: ' || l_start_date);
154: end if;
155:

Line 153: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Start_date output: ' || l_start_date);

149: end if;
150:
151: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
152: then
153: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Start_date output: ' || l_start_date);
154: end if;
155:
156: if (p_end_date is null or p_end_date = '*UNKNOWN*') then
157: l_end_date := null;

Line 162: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

158: else
159: l_end_date := to_date(substr(p_end_date, 1, 14), fnd_oid_util.G_YYYYMMDDHH24MISS);
160: end if;
161:
162: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
163: then
164: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End_date output: ' || l_end_date);
165: end if;
166:

Line 164: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End_date output: ' || l_end_date);

160: end if;
161:
162: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
163: then
164: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End_date output: ' || l_end_date);
165: end if;
166:
167: x_user_id := fnd_user_pkg.CreateUserId(
168: x_user_name => p_user_name

Line 186: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

182: , x_value => 'SSO'
183: , x_level_name => 'USER'
184: , x_level_value => x_user_id);
185: if not l_found then
186: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
187: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
188: 'Unable to set APPS_SSO_LOCAL_LOGIN profile value to SSO for user ' || p_user_name);
189: end if;
190: end if;

Line 187: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,

183: , x_level_name => 'USER'
184: , x_level_value => x_user_id);
185: if not l_found then
186: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
187: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
188: 'Unable to set APPS_SSO_LOCAL_LOGIN profile value to SSO for user ' || p_user_name);
189: end if;
190: end if;
191:

Line 192: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

188: 'Unable to set APPS_SSO_LOCAL_LOGIN profile value to SSO for user ' || p_user_name);
189: end if;
190: end if;
191:
192: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
193: then
194: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
195: end if;
196:

Line 194: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

190: end if;
191:
192: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
193: then
194: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
195: end if;
196:
197: exception
198: when others then

Line 199: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

195: end if;
196:
197: exception
198: when others then
199: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
200: then
201: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
202: end if;
203: end fnd_create_update;

Line 201: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

197: exception
198: when others then
199: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
200: then
201: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
202: end if;
203: end fnd_create_update;
204:
205: procedure fnd_create_update(

Line 225: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

221:
222: begin
223: l_module_source := G_MODULE_SOURCE || 'fnd_create_update: ';
224:
225: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
226: then
227: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
228: end if;
229:

Line 227: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

223: l_module_source := G_MODULE_SOURCE || 'fnd_create_update: ';
224:
225: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
226: then
227: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
228: end if;
229:
230: -- Read the values from wf_attribute_cache
231: l_description := wf_entity_mgr.get_attribute_value(p_event_type,

Line 248: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

244: l_isenabled := wf_entity_mgr.get_attribute_value('USER',
245: p_user_name, 'ORCLISENABLED');
246: end if;
247:
248: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
249: then
250: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
251: 'l_description = ' || l_description ||
252: 'l_email_address = ' || l_email_address ||

Line 250: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,

246: end if;
247:
248: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
249: then
250: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
251: 'l_description = ' || l_description ||
252: 'l_email_address = ' || l_email_address ||
253: 'l_fax = ' || l_fax
254: );

Line 273: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

269: , x_user_id => l_user_id);
270:
271: x_user_id := l_user_id;
272:
273: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
274: then
275: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
276: end if;
277: exception

Line 275: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

271: x_user_id := l_user_id;
272:
273: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
274: then
275: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
276: end if;
277: exception
278: when others then
279: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 279: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

275: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
276: end if;
277: exception
278: when others then
279: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
280: then
281: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
282: end if;
283: end fnd_create_update;

Line 281: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

277: exception
278: when others then
279: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
280: then
281: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
282: end if;
283: end fnd_create_update;
284: --
285:

Line 319: if (fnd_log.LEVEL_EVENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

315:
316: begin
317: l_module_source := G_MODULE_SOURCE || 'identity_add: ';
318:
319: if (fnd_log.LEVEL_EVENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
320: then
321: fnd_log.string(fnd_log.LEVEL_EVENT, l_module_source,
322: 'EBIZ is NOW capable of understanding IDENTITY_ADD');
323: end if;

Line 321: fnd_log.string(fnd_log.LEVEL_EVENT, l_module_source,

317: l_module_source := G_MODULE_SOURCE || 'identity_add: ';
318:
319: if (fnd_log.LEVEL_EVENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
320: then
321: fnd_log.string(fnd_log.LEVEL_EVENT, l_module_source,
322: 'EBIZ is NOW capable of understanding IDENTITY_ADD');
323: end if;
324: --RDESPOTO, Add IDENTITY_ADD, 11/09/2004
325: l_event_key := p_event.GetEventKey;

Line 331: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

327:
328: l_change_source := p_event.GetValueForParameter(
329: fnd_oid_util.G_CHANGE_SOURCE);
330:
331: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
332: then
333: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
334: , 'l_event_key = ' || l_event_key ||
335: ', l_event_name = ' || l_event_name ||

Line 333: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

329: fnd_oid_util.G_CHANGE_SOURCE);
330:
331: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
332: then
333: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
334: , 'l_event_key = ' || l_event_key ||
335: ', l_event_name = ' || l_event_name ||
336: ', l_change_source = ' || l_change_source);
337: end if;

Line 342: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

338: --Change_source has to be OID
339: if (l_change_source = fnd_oid_util.G_OID) then
340: l_orcl_guid := p_event.GetValueForParameter(
341: fnd_oid_util.G_ORCLGUID);
342: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
343: then
344: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'User_guid is:'
345: || l_orcl_guid || ', user_name is ' || l_event_key);
346: end if;

Line 344: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'User_guid is:'

340: l_orcl_guid := p_event.GetValueForParameter(
341: fnd_oid_util.G_ORCLGUID);
342: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
343: then
344: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'User_guid is:'
345: || l_orcl_guid || ', user_name is ' || l_event_key);
346: end if;
347: -- Maintain IDENTITY_ADD event type to pick up email and fax correctly
348: fnd_create_update(

Line 359: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

355: end if;
356: return(wf_rule.default_rule(p_subscription_guid, p_event));
357: exception
358: when others then
359: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
360: then
361: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
362: end if;
363: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 361: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

357: exception
358: when others then
359: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
360: then
361: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
362: end if;
363: return(wf_rule.error_rule(p_subscription_guid, p_event));
364:
365: end identity_add;

Line 380: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

376:
377: begin
378: l_module_source := G_MODULE_SOURCE || 'identity_modify: ';
379:
380: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
381: then
382: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
383: end if;
384: --THIS SUBSCRIPTION IS NOT USED! fnd_user_pkg.user_change SUBSCRIPTION IS USED INSTEAD.

Line 382: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

378: l_module_source := G_MODULE_SOURCE || 'identity_modify: ';
379:
380: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
381: then
382: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
383: end if;
384: --THIS SUBSCRIPTION IS NOT USED! fnd_user_pkg.user_change SUBSCRIPTION IS USED INSTEAD.
385: --Rada, 01/31/2005
386: l_orcl_guid := p_event.GetValueForParameter(

Line 396: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

392: , p_user_guid => l_orcl_guid
393: , x_user_id => l_user_id
394: );
395:
396: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
397: then
398: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
399: end if;
400:

Line 398: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

394: );
395:
396: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
397: then
398: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
399: end if;
400:
401: return(wf_rule.default_rule(p_subscription_guid, p_event));
402:

Line 405: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

401: return(wf_rule.default_rule(p_subscription_guid, p_event));
402:
403: exception
404: when others then
405: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
406: then
407: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
408: end if;
409: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 407: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

403: exception
404: when others then
405: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
406: then
407: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
408: end if;
409: return(wf_rule.error_rule(p_subscription_guid, p_event));
410:
411: end identity_modify;

Line 424: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

420:
421: begin
422: l_module_source := G_MODULE_SOURCE || 'identity_delete: ';
423:
424: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
425: then
426: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
427: end if;
428:

Line 426: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

422: l_module_source := G_MODULE_SOURCE || 'identity_delete: ';
423:
424: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
425: then
426: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
427: end if;
428:
429: -- Do something
430:

Line 431: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

427: end if;
428:
429: -- Do something
430:
431: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
432: then
433: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
434: end if;
435:

Line 433: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

429: -- Do something
430:
431: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
432: then
433: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
434: end if;
435:
436: return(wf_rule.default_rule(p_subscription_guid, p_event));
437:

Line 440: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

436: return(wf_rule.default_rule(p_subscription_guid, p_event));
437:
438: exception
439: when others then
440: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
441: then
442: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
443: end if;
444: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 442: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

438: exception
439: when others then
440: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
441: then
442: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
443: end if;
444: return(wf_rule.error_rule(p_subscription_guid, p_event));
445:
446: end identity_delete;

Line 476: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

472:
473: begin
474: l_module_source := G_MODULE_SOURCE || 'subscription_add: ';
475:
476: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
477: then
478: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
479: end if;
480: l_event_key := p_event.GetEventKey;

Line 478: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

474: l_module_source := G_MODULE_SOURCE || 'subscription_add: ';
475:
476: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
477: then
478: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
479: end if;
480: l_event_key := p_event.GetEventKey;
481: l_event_name := WF_OID.SUBSCRIPTION_ADD;
482:

Line 486: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

482:
483: l_change_source := p_event.GetValueForParameter(
484: fnd_oid_util.G_CHANGE_SOURCE);
485:
486: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
487: then
488: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
489: , 'l_event_key = ' || l_event_key ||
490: ', l_event_name = ' || l_event_name ||

Line 488: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

484: fnd_oid_util.G_CHANGE_SOURCE);
485:
486: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
487: then
488: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
489: , 'l_event_key = ' || l_event_key ||
490: ', l_event_name = ' || l_event_name ||
491: ', l_change_source = ' || l_change_source);
492: end if;

Line 497: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

493:
494: if (l_change_source = fnd_oid_util.G_OID) then
495: l_orcl_guid := p_event.GetValueForParameter(
496: fnd_oid_util.G_ORCLGUID);
497: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
498: then
499: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'User_guid is:'
500: || l_orcl_guid || ', user_name is ' || l_event_key);
501: end if;

Line 499: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'User_guid is:'

495: l_orcl_guid := p_event.GetValueForParameter(
496: fnd_oid_util.G_ORCLGUID);
497: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
498: then
499: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'User_guid is:'
500: || l_orcl_guid || ', user_name is ' || l_event_key);
501: end if;
502: fnd_create_update(
503: p_wf_event => p_event

Line 511: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

507: , x_user_id => l_user_id
508: );
509: end if;
510:
511: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
512: then
513: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
514: end if;
515:

Line 513: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

509: end if;
510:
511: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
512: then
513: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
514: end if;
515:
516: return(wf_rule.default_rule(p_subscription_guid, p_event));
517:

Line 520: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

516: return(wf_rule.default_rule(p_subscription_guid, p_event));
517:
518: exception
519: when others then
520: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
521: then
522: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
523: end if;
524: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 522: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

518: exception
519: when others then
520: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
521: then
522: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
523: end if;
524: return(wf_rule.error_rule(p_subscription_guid, p_event));
525:
526: end subscription_add;

Line 557: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

553:
554: begin
555: l_module_source := G_MODULE_SOURCE || 'subscription_delete: ';
556:
557: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
558: then
559: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
560: end if;
561:

Line 559: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

555: l_module_source := G_MODULE_SOURCE || 'subscription_delete: ';
556:
557: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
558: then
559: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
560: end if;
561:
562: l_event_key := p_event.GetEventKey;
563: l_event_name := WF_OID.SUBSCRIPTION_DELETE;

Line 567: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

563: l_event_name := WF_OID.SUBSCRIPTION_DELETE;
564: l_change_source := p_event.GetValueForParameter(
565: fnd_oid_util.G_CHANGE_SOURCE);
566:
567: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
568: then
569: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
570: , 'l_event_key = ' || l_event_key ||
571: ', l_event_name = ' || l_event_name ||

Line 569: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

565: fnd_oid_util.G_CHANGE_SOURCE);
566:
567: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
568: then
569: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
570: , 'l_event_key = ' || l_event_key ||
571: ', l_event_name = ' || l_event_name ||
572: ', l_change_source = ' || l_change_source);
573: end if;

Line 609: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

605: , x_user_id => l_user_id
606: );
607: end if;
608:
609: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
610: then
611: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
612: end if;
613:

Line 611: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

607: end if;
608:
609: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
610: then
611: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
612: end if;
613:
614: return(wf_rule.default_rule(p_subscription_guid, p_event));
615:

Line 618: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

614: return(wf_rule.default_rule(p_subscription_guid, p_event));
615:
616: exception
617: when others then
618: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
619: then
620: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
621: end if;
622: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 620: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

616: exception
617: when others then
618: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
619: then
620: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
621: end if;
622: return(wf_rule.error_rule(p_subscription_guid, p_event));
623: end subscription_delete;
624: -------------------------------------------------------------------------------

Line 655: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

651: l_profile_defined boolean;
652: begin
653: l_module_source := G_MODULE_SOURCE || ' synch_oid_to_tca: ';
654:
655: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
656: then
657: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
658: end if;
659:

Line 657: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

653: l_module_source := G_MODULE_SOURCE || ' synch_oid_to_tca: ';
654:
655: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
656: then
657: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
658: end if;
659:
660: -- Ignore TCA's own changes
661: -- bug 4411121

Line 666: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

662: -- If the change source is HZ_PARTY. Further processing is stopped
663: -- This has to be addressed later. If this was HZ change we have to push it to OID.
664: if (p_event.GetValueForParameter('CHANGE_SOURCE') = 'HZ_PARTY') then
665:
666: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
667: then
668: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'changeSrc is TCA no processing required');
669: end if;
670:

Line 668: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'changeSrc is TCA no processing required');

664: if (p_event.GetValueForParameter('CHANGE_SOURCE') = 'HZ_PARTY') then
665:
666: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
667: then
668: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'changeSrc is TCA no processing required');
669: end if;
670:
671: return 'SUCCESS';
672: end if;

Line 680: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

676: l_person_party_id_changed := false;
677:
678: l_user_name := p_event.getEventKey();
679:
680: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
681: then
682: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
683: 'USER_NAME: '||l_user_name);
684: end if;

Line 682: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

678: l_user_name := p_event.getEventKey();
679:
680: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
681: then
682: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
683: 'USER_NAME: '||l_user_name);
684: end if;
685:
686: for l_rec in cur_attribute_cache(l_user_name)

Line 708: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

704: end if;
705: end if;
706: end loop;
707:
708: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
709: then
710: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
711: ' OLD_PERSON_PARTY_ID:: '||l_old_person_party_id||'::'||
712: ' PERSON_PARTY_ID:: '||l_person_party_id||'::'||

Line 710: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

706: end loop;
707:
708: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
709: then
710: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
711: ' OLD_PERSON_PARTY_ID:: '||l_old_person_party_id||'::'||
712: ' PERSON_PARTY_ID:: '||l_person_party_id||'::'||
713: ' OLD_ORCLGUID::'||l_old_user_guid||'::'||
714: ' ORCLGUID::'||l_user_guid||'::');

Line 722: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

718:
719: if(l_old_person_party_id IS NULL and l_person_party_id IS NOT NULL) or
720: (l_old_person_party_id <> l_person_party_id)
721: then
722: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
723: then
724: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
725: 'person party id changed');
726: end if;

Line 724: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

720: (l_old_person_party_id <> l_person_party_id)
721: then
722: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
723: then
724: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
725: 'person party id changed');
726: end if;
727: l_person_party_id_changed := true;
728: end if;

Line 732: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

728: end if;
729:
730: if(l_old_user_guid IS NULL and l_user_guid IS NOT NULL) or (l_old_user_guid <> l_user_guid)
731: then
732: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
733: then
734: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
735: 'GUID changed');
736: end if;

Line 734: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

730: if(l_old_user_guid IS NULL and l_user_guid IS NOT NULL) or (l_old_user_guid <> l_user_guid)
731: then
732: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
733: then
734: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
735: 'GUID changed');
736: end if;
737: l_user_guid_changed := true;
738: end if;

Line 743: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

739:
740:
741: if(l_person_party_id_changed or l_user_guid_changed)
742: then
743: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
744: then
745: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
746: ' Either GUID or person party id has changed:');
747: end if;

Line 745: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

741: if(l_person_party_id_changed or l_user_guid_changed)
742: then
743: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
744: then
745: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
746: ' Either GUID or person party id has changed:');
747: end if;
748:
749: fnd_profile.get_specific(

Line 757: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

753:
754:
755: if(l_apps_sso_link_truth_src is NULL or l_apps_sso_link_truth_src = fnd_oid_util.G_OID)
756: then
757: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
758: then
759: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
760: ' OID is source of Truth during linking ');
761: end if;

Line 759: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

755: if(l_apps_sso_link_truth_src is NULL or l_apps_sso_link_truth_src = fnd_oid_util.G_OID)
756: then
757: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
758: then
759: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
760: ' OID is source of Truth during linking ');
761: end if;
762: fnd_oid_util.synch_user_from_LDAP_NO_AUTO(p_user_name => l_user_name,
763: p_result => l_result);

Line 765: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

761: end if;
762: fnd_oid_util.synch_user_from_LDAP_NO_AUTO(p_user_name => l_user_name,
763: p_result => l_result);
764:
765: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
766: then
767: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
768: ' After synch l_result: '||l_result);
769: end if;

Line 767: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

763: p_result => l_result);
764:
765: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
766: then
767: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
768: ' After synch l_result: '||l_result);
769: end if;
770: else
771: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 771: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

767: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
768: ' After synch l_result: '||l_result);
769: end if;
770: else
771: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
772: then
773: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
774: ' Apps is source of Truth during linking ');
775: end if;

Line 773: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

769: end if;
770: else
771: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
772: then
773: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
774: ' Apps is source of Truth during linking ');
775: end if;
776: ---Fix me as and when available add code here to fetch attributes from TCA/HR and send to OID. !!scheruku
777: end if;

Line 781: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

777: end if;
778: end if;
779:
780:
781: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
782: then
783: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
784: end if;
785:

Line 783: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

779:
780:
781: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
782: then
783: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
784: end if;
785:
786: return(wf_rule.default_rule(p_subscription_guid, p_event));
787: exception

Line 789: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

785:
786: return(wf_rule.default_rule(p_subscription_guid, p_event));
787: exception
788: when others then
789: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
790: then
791: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
792: end if;
793: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 791: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

787: exception
788: when others then
789: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
790: then
791: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
792: end if;
793: return(wf_rule.error_rule(p_subscription_guid, p_event));
794: end synch_oid_to_tca;
795:

Line 811: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

807:
808: begin
809: l_module_source := G_MODULE_SOURCE || ' on_demand_user_create: ';
810:
811: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
812: then
813: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
814: end if;
815: l_user_name:= p_event.GetValueForParameter('USER_NAME');

Line 813: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');

809: l_module_source := G_MODULE_SOURCE || ' on_demand_user_create: ';
810:
811: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
812: then
813: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
814: end if;
815: l_user_name:= p_event.GetValueForParameter('USER_NAME');
816: l_user_guid:= p_event.GetValueForParameter('ORCLGUID');
817:

Line 818: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

814: end if;
815: l_user_name:= p_event.GetValueForParameter('USER_NAME');
816: l_user_guid:= p_event.GetValueForParameter('ORCLGUID');
817:
818: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
819: then
820: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
821: 'username: '||l_user_name||' user_guid: '||l_user_guid);
822: end if;

Line 820: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

816: l_user_guid:= p_event.GetValueForParameter('ORCLGUID');
817:
818: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
819: then
820: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
821: 'username: '||l_user_name||' user_guid: '||l_user_guid);
822: end if;
823:
824: -- Replaced by subscribing assign_def_resp to "oracle.apps.fnd.ondemand.create" event

Line 831: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

827: -- );
828:
829: fnd_oid_util.synch_user_from_LDAP_NO_AUTO(p_user_name => l_user_name,
830: p_result => l_result);
831: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
832: then
833: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
834: ' After synch l_result: '||l_result);
835: end if;

Line 833: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

829: fnd_oid_util.synch_user_from_LDAP_NO_AUTO(p_user_name => l_user_name,
830: p_result => l_result);
831: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
832: then
833: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
834: ' After synch l_result: '||l_result);
835: end if;
836:
837: return(wf_rule.default_rule(p_subscription_guid, p_event));

Line 841: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

837: return(wf_rule.default_rule(p_subscription_guid, p_event));
838:
839: exception
840: when others then
841: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
842: then
843: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
844: end if;
845: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 843: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

839: exception
840: when others then
841: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
842: then
843: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
844: end if;
845: return(wf_rule.error_rule(p_subscription_guid, p_event));
846:
847: end on_demand_user_create;

Line 863: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

859:
860: begin
861: l_module_source := G_MODULE_SOURCE || 'event_error: ';
862:
863: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
864: then
865: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
866: end if;
867: --RDESPOTO, 09/07/2004

Line 865: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');

861: l_module_source := G_MODULE_SOURCE || 'event_error: ';
862:
863: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
864: then
865: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
866: end if;
867: --RDESPOTO, 09/07/2004
868: --need constants for these in FND_OID_UTIL
869: l_event_id := p_event.GetValueForParameter('ENTITY_ID');

Line 874: if(fnd_log.LEVEL_UNEXPECTED >=

870: l_user_name:= p_event.GetValueForParameter('USER_NAME');
871: l_user_guid:= p_event.GetValueForParameter('ORCLGUID');
872:
873:
874: if(fnd_log.LEVEL_UNEXPECTED >=
875: fnd_log.G_CURRENT_RUNTIME_LEVEL) then
876:
877: fnd_message.SET_NAME('FND', 'FND_SSO_EVENT_ERROR');
878: fnd_message.SET_TOKEN('USER_NAME', l_user_name);

Line 875: fnd_log.G_CURRENT_RUNTIME_LEVEL) then

871: l_user_guid:= p_event.GetValueForParameter('ORCLGUID');
872:
873:
874: if(fnd_log.LEVEL_UNEXPECTED >=
875: fnd_log.G_CURRENT_RUNTIME_LEVEL) then
876:
877: fnd_message.SET_NAME('FND', 'FND_SSO_EVENT_ERROR');
878: fnd_message.SET_TOKEN('USER_NAME', l_user_name);
879: fnd_message.SET_TOKEN('ENTITY_ID', l_event_id);

Line 881: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED,

877: fnd_message.SET_NAME('FND', 'FND_SSO_EVENT_ERROR');
878: fnd_message.SET_TOKEN('USER_NAME', l_user_name);
879: fnd_message.SET_TOKEN('ENTITY_ID', l_event_id);
880: fnd_message.SET_TOKEN('ORCLGUID', l_user_guid);
881: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED,
882: l_module_source, TRUE);
883: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,
884: 'Synchronization of user definiton between E-Business Suite'||
885: ' and Oracle Internet Directory has failed for user:' || l_user_name ||

Line 883: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,

879: fnd_message.SET_TOKEN('ENTITY_ID', l_event_id);
880: fnd_message.SET_TOKEN('ORCLGUID', l_user_guid);
881: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED,
882: l_module_source, TRUE);
883: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,
884: 'Synchronization of user definiton between E-Business Suite'||
885: ' and Oracle Internet Directory has failed for user:' || l_user_name ||
886: ', event id:' || l_event_id || ', guid:' || l_user_guid);
887: end if;

Line 889: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

885: ' and Oracle Internet Directory has failed for user:' || l_user_name ||
886: ', event id:' || l_event_id || ', guid:' || l_user_guid);
887: end if;
888:
889: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
890: then
891: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
892: end if;
893:

Line 891: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

887: end if;
888:
889: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
890: then
891: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
892: end if;
893:
894: return(wf_rule.default_rule(p_subscription_guid, p_event));
895:

Line 898: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

894: return(wf_rule.default_rule(p_subscription_guid, p_event));
895:
896: exception
897: when others then
898: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
899: then
900: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
901: end if;
902: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 900: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

896: exception
897: when others then
898: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
899: then
900: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
901: end if;
902: return(wf_rule.error_rule(p_subscription_guid, p_event));
903: end event_error;
904: --

Line 919: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

915:
916: begin
917: l_module_source := G_MODULE_SOURCE || 'event_resend: ';
918:
919: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
920: then
921: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
922: end if;
923: --RDESPOTO, 09/07/2004

Line 921: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');

917: l_module_source := G_MODULE_SOURCE || 'event_resend: ';
918:
919: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
920: then
921: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
922: end if;
923: --RDESPOTO, 09/07/2004
924: --need constants for these in FND_OID_UTIL
925: l_event_id := p_event.GetValueForParameter('ENTITY_ID');

Line 930: if(fnd_log.LEVEL_UNEXPECTED >=

926: l_user_name:= p_event.GetValueForParameter('USER_NAME');
927: l_user_guid:= p_event.GetValueForParameter('ORCLGUID');
928:
929:
930: if(fnd_log.LEVEL_UNEXPECTED >=
931: fnd_log.G_CURRENT_RUNTIME_LEVEL) then
932:
933: fnd_message.SET_NAME('FND', 'FND_SSO_EVENT_RESEND');
934: fnd_message.SET_TOKEN('USER_NAME', l_user_name);

Line 931: fnd_log.G_CURRENT_RUNTIME_LEVEL) then

927: l_user_guid:= p_event.GetValueForParameter('ORCLGUID');
928:
929:
930: if(fnd_log.LEVEL_UNEXPECTED >=
931: fnd_log.G_CURRENT_RUNTIME_LEVEL) then
932:
933: fnd_message.SET_NAME('FND', 'FND_SSO_EVENT_RESEND');
934: fnd_message.SET_TOKEN('USER_NAME', l_user_name);
935: fnd_message.SET_TOKEN('ENTITY_ID', l_event_id);

Line 937: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED,

933: fnd_message.SET_NAME('FND', 'FND_SSO_EVENT_RESEND');
934: fnd_message.SET_TOKEN('USER_NAME', l_user_name);
935: fnd_message.SET_TOKEN('ENTITY_ID', l_event_id);
936: fnd_message.SET_TOKEN('ORCLGUID', l_user_guid);
937: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED,
938: l_module_source, TRUE);
939: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,
940: 'Synchronization event between E-Business Suite'
941: || ' and Oracle Internet Directory has to be resent for user '

Line 939: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,

935: fnd_message.SET_TOKEN('ENTITY_ID', l_event_id);
936: fnd_message.SET_TOKEN('ORCLGUID', l_user_guid);
937: fnd_log.MESSAGE(fnd_log.LEVEL_UNEXPECTED,
938: l_module_source, TRUE);
939: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,
940: 'Synchronization event between E-Business Suite'
941: || ' and Oracle Internet Directory has to be resent for user '
942: || l_user_name || ', event id:' || l_event_id || ', guid:' || l_user_guid);
943: end if;

Line 945: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

941: || ' and Oracle Internet Directory has to be resent for user '
942: || l_user_name || ', event id:' || l_event_id || ', guid:' || l_user_guid);
943: end if;
944:
945: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
946: then
947: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
948: end if;
949:

Line 947: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');

943: end if;
944:
945: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
946: then
947: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End');
948: end if;
949:
950: return(wf_rule.default_rule(p_subscription_guid, p_event));
951:

Line 954: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

950: return(wf_rule.default_rule(p_subscription_guid, p_event));
951:
952: exception
953: when others then
954: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
955: then
956: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
957: end if;
958: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 956: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

952: exception
953: when others then
954: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
955: then
956: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
957: end if;
958: return(wf_rule.error_rule(p_subscription_guid, p_event));
959: end event_resend;
960: --

Line 974: if (fnd_log.LEVEL_EVENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

970:
971: begin
972: l_module_source := G_MODULE_SOURCE || 'hz_identity_add: ';
973:
974: if (fnd_log.LEVEL_EVENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
975: then
976: fnd_log.string(fnd_log.LEVEL_EVENT, l_module_source,
977: 'EBIZ is NOW capable of understanding IDENTITY_ADD.');
978: end if;

Line 976: fnd_log.string(fnd_log.LEVEL_EVENT, l_module_source,

972: l_module_source := G_MODULE_SOURCE || 'hz_identity_add: ';
973:
974: if (fnd_log.LEVEL_EVENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
975: then
976: fnd_log.string(fnd_log.LEVEL_EVENT, l_module_source,
977: 'EBIZ is NOW capable of understanding IDENTITY_ADD.');
978: end if;
979: --RDESPOTO, Add IDENTITY_ADD, 11/09/2004
980: l_change_source := p_event.GetValueForParameter(

Line 995: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

991: return(wf_rule.default_rule(p_subscription_guid, p_event));
992:
993: exception
994: when others then
995: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
996: then
997: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
998: end if;
999: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 997: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

993: exception
994: when others then
995: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
996: then
997: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
998: end if;
999: return(wf_rule.error_rule(p_subscription_guid, p_event));
1000: end hz_identity_add;
1001: --

Line 1016: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1012:
1013: begin
1014: l_module_source := G_MODULE_SOURCE || 'hz_identity_modify: ';
1015:
1016: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1017: then
1018: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1019: end if;
1020:

Line 1018: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

1014: l_module_source := G_MODULE_SOURCE || 'hz_identity_modify: ';
1015:
1016: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1017: then
1018: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1019: end if;
1020:
1021: hz_create_update(
1022: p_wf_event => p_event

Line 1031: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1027: then
1028: raise hz_failed_exp;
1029: end if;
1030:
1031: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1032: then
1033: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1034: end if;
1035:

Line 1033: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

1029: end if;
1030:
1031: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1032: then
1033: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1034: end if;
1035:
1036: return(wf_rule.default_rule(p_subscription_guid, p_event));
1037:

Line 1040: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1036: return(wf_rule.default_rule(p_subscription_guid, p_event));
1037:
1038: exception
1039: when hz_failed_exp then
1040: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1041: then
1042: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,
1043: 'hz_failed_exp: l_return_status = ' ||
1044: l_return_status);

Line 1042: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,

1038: exception
1039: when hz_failed_exp then
1040: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1041: then
1042: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,
1043: 'hz_failed_exp: l_return_status = ' ||
1044: l_return_status);
1045: end if;
1046: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 1049: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1045: end if;
1046: return(wf_rule.error_rule(p_subscription_guid, p_event));
1047:
1048: when others then
1049: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1050: then
1051: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1052: end if;
1053: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 1051: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

1047:
1048: when others then
1049: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1050: then
1051: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1052: end if;
1053: return(wf_rule.error_rule(p_subscription_guid, p_event));
1054: end hz_identity_modify;
1055: --

Line 1067: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1063:
1064: begin
1065: l_module_source := G_MODULE_SOURCE || 'hz_identity_delete: ';
1066:
1067: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1068: then
1069: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,
1070: 'This is a no-op for now. This subscription should be disabled. ' ||
1071: ' Please contact your System administrator to disable subscription');

Line 1069: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,

1065: l_module_source := G_MODULE_SOURCE || 'hz_identity_delete: ';
1066:
1067: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1068: then
1069: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,
1070: 'This is a no-op for now. This subscription should be disabled. ' ||
1071: ' Please contact your System administrator to disable subscription');
1072: end if;
1073:

Line 1078: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1074: return(wf_rule.default_rule(p_subscription_guid, p_event));
1075:
1076: exception
1077: when others then
1078: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1079: then
1080: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1081: end if;
1082: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 1080: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

1076: exception
1077: when others then
1078: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1079: then
1080: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1081: end if;
1082: return(wf_rule.error_rule(p_subscription_guid, p_event));
1083: end hz_identity_delete;
1084: --

Line 1099: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1095:
1096: begin
1097: l_module_source := G_MODULE_SOURCE || 'hz_subscription_add: ';
1098:
1099: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1100: then
1101: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1102: end if;
1103:

Line 1101: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

1097: l_module_source := G_MODULE_SOURCE || 'hz_subscription_add: ';
1098:
1099: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1100: then
1101: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1102: end if;
1103:
1104: hz_create_update(
1105: p_wf_event => p_event

Line 1114: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1110: then
1111: raise hz_failed_exp;
1112: end if;
1113:
1114: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1115: then
1116: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1117: end if;
1118:

Line 1116: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

1112: end if;
1113:
1114: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1115: then
1116: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1117: end if;
1118:
1119: return(wf_rule.default_rule(p_subscription_guid, p_event));
1120:

Line 1123: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1119: return(wf_rule.default_rule(p_subscription_guid, p_event));
1120:
1121: exception
1122: when hz_failed_exp then
1123: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1124: then
1125: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,
1126: 'hz_failed_exp: l_return_status = ' ||
1127: l_return_status);

Line 1125: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,

1121: exception
1122: when hz_failed_exp then
1123: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1124: then
1125: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,
1126: 'hz_failed_exp: l_return_status = ' ||
1127: l_return_status);
1128: end if;
1129: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 1132: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1128: end if;
1129: return(wf_rule.error_rule(p_subscription_guid, p_event));
1130:
1131: when others then
1132: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1133: then
1134: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1135: end if;
1136: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 1134: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

1130:
1131: when others then
1132: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1133: then
1134: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1135: end if;
1136: return(wf_rule.error_rule(p_subscription_guid, p_event));
1137: end hz_subscription_add;
1138: --

Line 1150: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1146:
1147: begin
1148: l_module_source := G_MODULE_SOURCE || 'hz_subscription_delete: ';
1149:
1150: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1151: then
1152: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,
1153: 'This is a no-op for now. This subscription should be disabled. ' ||
1154: ' Please contact your System administrator to disable subscription');

Line 1152: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,

1148: l_module_source := G_MODULE_SOURCE || 'hz_subscription_delete: ';
1149:
1150: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1151: then
1152: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source,
1153: 'This is a no-op for now. This subscription should be disabled. ' ||
1154: ' Please contact your System administrator to disable subscription');
1155: end if;
1156:

Line 1161: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1157: return(wf_rule.default_rule(p_subscription_guid, p_event));
1158:
1159: exception
1160: when others then
1161: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1162: then
1163: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1164: end if;
1165: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 1163: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

1159: exception
1160: when others then
1161: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1162: then
1163: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1164: end if;
1165: return(wf_rule.error_rule(p_subscription_guid, p_event));
1166: end hz_subscription_delete;
1167: --

Line 1184: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1180:
1181: begin
1182: l_module_source := G_MODULE_SOURCE || 'hz_create_update: ';
1183:
1184: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1185: then
1186: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1187: end if;
1188:

Line 1186: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

1182: l_module_source := G_MODULE_SOURCE || 'hz_create_update: ';
1183:
1184: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1185: then
1186: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1187: end if;
1188:
1189: fnd_ldap_mapper.map_ldap_message(p_wf_event, p_event_type, l_ldap_message);
1190:

Line 1193: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1189: fnd_ldap_mapper.map_ldap_message(p_wf_event, p_event_type, l_ldap_message);
1190:
1191: if (fnd_oid_util.person_party_exists(p_wf_event.GetEventKey))
1192: then
1193: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1194: then
1195: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1196: 'Person Party exists in FND_USER');
1197: end if;

Line 1195: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,

1191: if (fnd_oid_util.person_party_exists(p_wf_event.GetEventKey))
1192: then
1193: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1194: then
1195: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1196: 'Person Party exists in FND_USER');
1197: end if;
1198: fnd_oid_users.hz_update(
1199: p_ldap_message => l_ldap_message

Line 1209: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1205: where user_name = l_event_key
1206: and user_guid is not null;
1207:
1208: if (l_count > 0) then
1209: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1210: then
1211: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1212: 'Person Party does NOT exist in FND_USER, creating a new TCA entry');
1213: end if;

Line 1211: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,

1207:
1208: if (l_count > 0) then
1209: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1210: then
1211: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1212: 'Person Party does NOT exist in FND_USER, creating a new TCA entry');
1213: end if;
1214: fnd_oid_users.hz_create(
1215: p_ldap_message => l_ldap_message

Line 1218: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1214: fnd_oid_users.hz_create(
1215: p_ldap_message => l_ldap_message
1216: , x_return_status => p_return_status);
1217: else
1218: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1219: then
1220: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1221: 'FND User is not linked to OID user, therefore not creating TCA party');
1222: end if;

Line 1220: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,

1216: , x_return_status => p_return_status);
1217: else
1218: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1219: then
1220: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1221: 'FND User is not linked to OID user, therefore not creating TCA party');
1222: end if;
1223: end if;
1224:

Line 1227: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1223: end if;
1224:
1225: end if;
1226:
1227: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1228: then
1229: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1230: end if;
1231:

Line 1229: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

1225: end if;
1226:
1227: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1228: then
1229: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1230: end if;
1231:
1232: exception
1233: when others then

Line 1234: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1230: end if;
1231:
1232: exception
1233: when others then
1234: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1235: then
1236: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1237: end if;
1238: end hz_create_update;

Line 1236: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

1232: exception
1233: when others then
1234: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1235: then
1236: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1237: end if;
1238: end hz_create_update;
1239: --
1240: -------------------------------------------------------------------------------

Line 1257: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1253: where RESPONSIBILITY_KEY = p_resp_key;
1254: begin
1255: l_module_source := G_MODULE_SOURCE || 'get_resp_app_id ';
1256:
1257: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1258: then
1259: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1260: end if;
1261:

Line 1259: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

1255: l_module_source := G_MODULE_SOURCE || 'get_resp_app_id ';
1256:
1257: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1258: then
1259: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1260: end if;
1261:
1262: open cur_fnd_responsibility;
1263: fetch cur_fnd_responsibility into l_responsibility_id, l_application_id;

Line 1276: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1272:
1273: x_responsibility_id := l_responsibility_id;
1274: x_application_id := l_application_id;
1275:
1276: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1277: then
1278: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1279: end if;
1280:

Line 1278: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

1274: x_application_id := l_application_id;
1275:
1276: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1277: then
1278: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1279: end if;
1280:
1281: exception
1282: when others then

Line 1283: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1279: end if;
1280:
1281: exception
1282: when others then
1283: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1284: then
1285: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1286: end if;
1287: raise;

Line 1285: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

1281: exception
1282: when others then
1283: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1284: then
1285: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1286: end if;
1287: raise;
1288: end get_resp_app_id;
1289: --

Line 1304: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1300:
1301: begin
1302: l_module_source := G_MODULE_SOURCE || 'assign_default_resp: ';
1303:
1304: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1305: then
1306: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1307: end if;
1308:

Line 1306: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

1302: l_module_source := G_MODULE_SOURCE || 'assign_default_resp: ';
1303:
1304: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1305: then
1306: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1307: end if;
1308:
1309: l_apps_user_key := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);
1310:

Line 1336: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1332: , description => 'Default Assignment for OID User'
1333: );
1334: end if;
1335:
1336: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1337: then
1338: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1339: end if;
1340:

Line 1338: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

1334: end if;
1335:
1336: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1337: then
1338: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1339: end if;
1340:
1341: exception
1342: when others then

Line 1343: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1339: end if;
1340:
1341: exception
1342: when others then
1343: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1344: then
1345: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1346: end if;
1347: end assign_default_resp;

Line 1345: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

1341: exception
1342: when others then
1343: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1344: then
1345: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1346: end if;
1347: end assign_default_resp;
1348: --
1349: -------------------------------------------------------------------------------

Line 1372: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1368:
1369: begin
1370: l_module_source := G_MODULE_SOURCE || 'assign_def_resp: ';
1371:
1372: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1373: then
1374: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1375: end if;
1376:

Line 1374: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

1370: l_module_source := G_MODULE_SOURCE || 'assign_def_resp: ';
1371:
1372: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1373: then
1374: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1375: end if;
1376:
1377: l_event_key := p_event.GetEventKey;
1378: l_event_name := WF_OID.SUBSCRIPTION_ADD;

Line 1382: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1378: l_event_name := WF_OID.SUBSCRIPTION_ADD;
1379: l_change_source := p_event.GetValueForParameter(
1380: fnd_oid_util.G_CHANGE_SOURCE);
1381:
1382: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1383: then
1384: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1385: , 'l_event_key = ' || l_event_key ||
1386: ', l_event_name = ' || l_event_name ||

Line 1384: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

1380: fnd_oid_util.G_CHANGE_SOURCE);
1381:
1382: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1383: then
1384: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1385: , 'l_event_key = ' || l_event_key ||
1386: ', l_event_name = ' || l_event_name ||
1387: ', l_change_source = ' || l_change_source);
1388: end if;

Line 1424: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1420: );
1421: end if;
1422:
1423:
1424: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1425: then
1426: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1427: end if;
1428:

Line 1426: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

1422:
1423:
1424: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1425: then
1426: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1427: end if;
1428:
1429: return(wf_rule.default_rule(p_subscription_guid, p_event));
1430:

Line 1433: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1429: return(wf_rule.default_rule(p_subscription_guid, p_event));
1430:
1431: exception
1432: when others then
1433: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1434: then
1435: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1436: end if;
1437: return(wf_rule.error_rule(p_subscription_guid, p_event));

Line 1435: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);

1431: exception
1432: when others then
1433: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1434: then
1435: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1436: end if;
1437: return(wf_rule.error_rule(p_subscription_guid, p_event));
1438:
1439: end assign_def_resp;