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

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

23: l_module_source := G_MODULE_SOURCE || 'hz_create';
24:
25: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
26:
27: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
28: then
29: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
30: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
31: 'p_ldap_message.sn = ' || p_ldap_message.sn

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

25: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
26:
27: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
28: then
29: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
30: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
31: 'p_ldap_message.sn = ' || p_ldap_message.sn
32: || ', p_ldap_message.givenName = ' || p_ldap_message.givenName
33: || ', p_ldap_message.telephoneNumber = ' || p_ldap_message.telephoneNumber

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

26:
27: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
28: then
29: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
30: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
31: 'p_ldap_message.sn = ' || p_ldap_message.sn
32: || ', p_ldap_message.givenName = ' || p_ldap_message.givenName
33: || ', p_ldap_message.telephoneNumber = ' || p_ldap_message.telephoneNumber
34: || ', p_ldap_message.homePhone = ' || p_ldap_message.homePhone

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

44: x_return_status => x_return_status);
45: end if;
46:
47: if (x_return_status = Fnd_Api.G_RET_STS_SUCCESS) then
48: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
49: then
50: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Party ' ||
51: p_ldap_message.givenName || ', ' || p_ldap_message.sn || ' created successfully');
52: end if;

Line 50: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Party ' ||

46:
47: if (x_return_status = Fnd_Api.G_RET_STS_SUCCESS) then
48: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
49: then
50: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Party ' ||
51: p_ldap_message.givenName || ', ' || p_ldap_message.sn || ' created successfully');
52: end if;
53:
54: if (p_ldap_message.telephoneNumber is not null)

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

80: p_ldap_message => p_ldap_message,
81: x_return_status => x_return_status);
82: end if;
83: else
84: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
85: then
86: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Party creation ' ||
87: p_ldap_message.givenName || ', ' || p_ldap_message.sn || ' failed.');
88: end if;

Line 86: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Party creation ' ||

82: end if;
83: else
84: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
85: then
86: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Party creation ' ||
87: p_ldap_message.givenName || ', ' || p_ldap_message.sn || ' failed.');
88: end if;
89: end if;
90: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

86: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Party creation ' ||
87: p_ldap_message.givenName || ', ' || p_ldap_message.sn || ' failed.');
88: end if;
89: end if;
90: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
91: then
92: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
93: end if;
94:

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

88: end if;
89: end if;
90: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
91: then
92: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
93: end if;
94:
95: exception
96: when others then

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

93: end if;
94:
95: exception
96: when others then
97: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
98: then
99: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
100: end if;
101: end hz_create;

Line 99: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

95: exception
96: when others then
97: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
98: then
99: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
100: end if;
101: end hz_create;
102: --
103: -------------------------------------------------------------------------------

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

120:
121: begin
122: l_module_source := G_MODULE_SOURCE || 'create_party';
123:
124: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
125: then
126: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
127: end if;
128:

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

122: l_module_source := G_MODULE_SOURCE || 'create_party';
123:
124: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
125: then
126: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
127: end if;
128:
129: fnd_oid_users.get_person_rec(p_ldap_message => p_ldap_message,
130: p_action_type => G_CREATE,

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

174: set person_party_id = x_party_id, customer_id = x_customer_id,
175: employee_id = x_employee_id
176: where user_name = p_ldap_message.object_name;
177:
178: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
179: then
180: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Linked user '
181: || p_ldap_message.object_name || ' to party number ' || x_party_id);
182: end if;

Line 180: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Linked user '

176: where user_name = p_ldap_message.object_name;
177:
178: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
179: then
180: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Linked user '
181: || p_ldap_message.object_name || ' to party number ' || x_party_id);
182: end if;
183:
184: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

180: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Linked user '
181: || p_ldap_message.object_name || ' to party number ' || x_party_id);
182: end if;
183:
184: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
185: then
186: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
187: end if;
188:

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

182: end if;
183:
184: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
185: then
186: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
187: end if;
188:
189: exception
190: when l_tca_error then

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

187: end if;
188:
189: exception
190: when l_tca_error then
191: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
192: then
193: if (x_msg_count > 0)
194: then
195: for i in 1..x_msg_count

Line 197: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);

193: if (x_msg_count > 0)
194: then
195: for i in 1..x_msg_count
196: loop
197: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
198: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
199: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
200: end loop;
201: else

Line 198: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'

194: then
195: for i in 1..x_msg_count
196: loop
197: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
198: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
199: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
200: end loop;
201: else
202: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

198: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
199: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
200: end loop;
201: else
202: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
203: , 'x_return_status = ' || x_return_status);
204: end if;
205: end if;
206: when others then

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

203: , 'x_return_status = ' || x_return_status);
204: end if;
205: end if;
206: when others then
207: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
208: then
209: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
210: end if;
211:

Line 209: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

205: end if;
206: when others then
207: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
208: then
209: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
210: end if;
211:
212: end create_party;
213: --

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

228:
229: begin
230: l_module_source := G_MODULE_SOURCE || 'create_phone_contact_point';
231:
232: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
233: then
234: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
235: end if;
236:

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

230: l_module_source := G_MODULE_SOURCE || 'create_phone_contact_point';
231:
232: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
233: then
234: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
235: end if;
236:
237: fnd_oid_users.get_contact_point_rec(
238: p_ldap_message => p_ldap_message,

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

283: then
284: raise l_tca_error;
285: end if;
286:
287: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
288: then
289: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
290: end if;
291:

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

285: end if;
286:
287: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
288: then
289: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
290: end if;
291:
292: exception
293: when l_tca_error then

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

290: end if;
291:
292: exception
293: when l_tca_error then
294: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
295: then
296: if (x_msg_count > 0)
297: then
298: for i in 1..x_msg_count

Line 300: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);

296: if (x_msg_count > 0)
297: then
298: for i in 1..x_msg_count
299: loop
300: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
301: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
302: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
303: end loop;
304: else

Line 301: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'

297: then
298: for i in 1..x_msg_count
299: loop
300: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
301: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
302: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
303: end loop;
304: else
305: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

301: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
302: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
303: end loop;
304: else
305: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
306: , 'x_return_status = ' || x_return_status);
307: end if;
308: end if;
309: when others then

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

306: , 'x_return_status = ' || x_return_status);
307: end if;
308: end if;
309: when others then
310: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
311: then
312: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
313: end if;
314: end create_phone_contact_point;

Line 312: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

308: end if;
309: when others then
310: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
311: then
312: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
313: end if;
314: end create_phone_contact_point;
315: --
316: -------------------------------------------------------------------------------

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

330:
331: begin
332: l_module_source := G_MODULE_SOURCE || 'create_email_contact_point';
333:
334: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
335: then
336: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
337: end if;
338:

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

332: l_module_source := G_MODULE_SOURCE || 'create_email_contact_point';
333:
334: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
335: then
336: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
337: end if;
338:
339: fnd_oid_users.get_contact_point_rec(
340: p_ldap_message => p_ldap_message,

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

377: then
378: raise l_tca_error;
379: end if;
380:
381: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
382: then
383: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
384: end if;
385:

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

379: end if;
380:
381: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
382: then
383: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
384: end if;
385:
386: exception
387: when l_tca_error then

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

384: end if;
385:
386: exception
387: when l_tca_error then
388: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
389: then
390: if (x_msg_count > 0)
391: then
392: for i in 1..x_msg_count

Line 394: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);

390: if (x_msg_count > 0)
391: then
392: for i in 1..x_msg_count
393: loop
394: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
395: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
396: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
397: end loop;
398: else

Line 395: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'

391: then
392: for i in 1..x_msg_count
393: loop
394: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
395: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
396: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
397: end loop;
398: else
399: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

395: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
396: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
397: end loop;
398: else
399: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
400: , 'x_return_status = ' || x_return_status);
401: end if;
402: end if;
403: when others then

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

400: , 'x_return_status = ' || x_return_status);
401: end if;
402: end if;
403: when others then
404: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
405: then
406: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
407: end if;
408: end create_email_contact_point;

Line 406: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

402: end if;
403: when others then
404: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
405: then
406: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
407: end if;
408: end create_email_contact_point;
409: --
410: -------------------------------------------------------------------------------

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

425: l_module_source := G_MODULE_SOURCE || 'create_location';
426:
427: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
428:
429: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
430: then
431: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
432: end if;
433:

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

427: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
428:
429: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
430: then
431: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
432: end if;
433:
434: fnd_oid_users.get_location_rec(p_ldap_message => p_ldap_message,
435: x_location_rec => x_location_rec);

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

434: fnd_oid_users.get_location_rec(p_ldap_message => p_ldap_message,
435: x_location_rec => x_location_rec);
436: --Verify whether country is null since get_location_rec may nullify country
437: if (x_location_rec.country is not null) then
438: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
439: then
440: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Country is not null' || x_location_rec.country);
441: end if;
442: hz_location_v2pub.create_location(p_init_msg_list => fnd_api.G_TRUE,

Line 440: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Country is not null' || x_location_rec.country);

436: --Verify whether country is null since get_location_rec may nullify country
437: if (x_location_rec.country is not null) then
438: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
439: then
440: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Country is not null' || x_location_rec.country);
441: end if;
442: hz_location_v2pub.create_location(p_init_msg_list => fnd_api.G_TRUE,
443: p_location_rec => x_location_rec,
444: x_location_id => x_location_id,

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

461: raise l_tca_error;
462: end if;
463: end if;
464:
465: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
466: then
467: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
468: end if;
469:

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

463: end if;
464:
465: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
466: then
467: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
468: end if;
469:
470: exception
471: when l_tca_error then

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

468: end if;
469:
470: exception
471: when l_tca_error then
472: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
473: then
474: if (x_msg_count > 0)
475: then
476: for i in 1..x_msg_count

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

474: if (x_msg_count > 0)
475: then
476: for i in 1..x_msg_count
477: loop
478: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
479: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
480: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
481: end loop;
482: else

Line 479: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'

475: then
476: for i in 1..x_msg_count
477: loop
478: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
479: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
480: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
481: end loop;
482: else
483: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

479: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
480: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
481: end loop;
482: else
483: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
484: , 'x_return_status = ' || x_return_status);
485: end if;
486: end if;
487: when others then

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

484: , 'x_return_status = ' || x_return_status);
485: end if;
486: end if;
487: when others then
488: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
489: then
490: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
491: end if;
492: end create_location;

Line 490: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

486: end if;
487: when others then
488: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
489: then
490: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
491: end if;
492: end create_location;
493: --
494: -------------------------------------------------------------------------------

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

509:
510: begin
511: l_module_source := G_MODULE_SOURCE || 'create_party_site';
512:
513: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
514: then
515: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
516: end if;
517:

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

511: l_module_source := G_MODULE_SOURCE || 'create_party_site';
512:
513: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
514: then
515: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
516: end if;
517:
518: fnd_oid_users.get_party_site_rec(
519: p_ldap_message => p_ldap_message,

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

553: then
554: raise l_tca_error;
555: end if;
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, 'End');
560: end if;
561:

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

555: end if;
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, 'End');
560: end if;
561:
562: exception
563: when l_tca_error then

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

560: end if;
561:
562: exception
563: when l_tca_error then
564: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
565: then
566: if (x_msg_count > 0)
567: then
568: for i in 1..x_msg_count

Line 570: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);

566: if (x_msg_count > 0)
567: then
568: for i in 1..x_msg_count
569: loop
570: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
571: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
572: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
573: end loop;
574: else

Line 571: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'

567: then
568: for i in 1..x_msg_count
569: loop
570: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
571: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
572: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
573: end loop;
574: else
575: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

571: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
572: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
573: end loop;
574: else
575: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
576: , 'x_return_status = ' || x_return_status);
577: end if;
578: end if;
579: when others then

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

576: , 'x_return_status = ' || x_return_status);
577: end if;
578: end if;
579: when others then
580: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
581: then
582: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
583: end if;
584: end create_party_site;

Line 582: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

578: end if;
579: when others then
580: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
581: then
582: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
583: end if;
584: end create_party_site;
585: --
586: -------------------------------------------------------------------------------

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

594:
595: begin
596: l_module_source := G_MODULE_SOURCE || 'hz_update';
597:
598: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
599: then
600: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
601: end if;
602:

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

596: l_module_source := G_MODULE_SOURCE || 'hz_update';
597:
598: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
599: then
600: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
601: end if;
602:
603: if ((p_ldap_message.sn is not null and p_ldap_message.sn <> G_UNKNOWN)
604: or (p_ldap_message.givenName is not null and p_ldap_message.givenName <> G_UNKNOWN))

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

641: then
642: fnd_oid_users.update_party_site(p_ldap_message => p_ldap_message,
643: x_return_status => x_return_status);
644:
645: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
646: then
647: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Update party site status: ' || x_return_status);
648: end if;
649:

Line 647: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Update party site status: ' || x_return_status);

643: x_return_status => x_return_status);
644:
645: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
646: then
647: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Update party site status: ' || x_return_status);
648: end if;
649:
650: end if;
651:

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

648: end if;
649:
650: end if;
651:
652: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
653: then
654: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
655: end if;
656:

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

650: end if;
651:
652: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
653: then
654: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
655: end if;
656:
657: exception
658: when others then

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

655: end if;
656:
657: exception
658: when others then
659: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
660: then
661: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
662: end if;
663:

Line 661: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

657: exception
658: when others then
659: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
660: then
661: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
662: end if;
663:
664: end hz_update;
665: --

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

681:
682: begin
683: l_module_source := G_MODULE_SOURCE || 'update_party';
684:
685: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
686: then
687: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
688: end if;
689:

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

683: l_module_source := G_MODULE_SOURCE || 'update_party';
684:
685: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
686: then
687: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
688: end if;
689:
690: fnd_oid_users.get_person_rec(p_ldap_message => p_ldap_message,
691: p_action_type => G_UPDATE,

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

714: then
715: raise l_tca_error;
716: end if;
717:
718: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
719: then
720: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
721: end if;
722:

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

716: end if;
717:
718: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
719: then
720: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
721: end if;
722:
723: exception
724: when l_tca_error then

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

721: end if;
722:
723: exception
724: when l_tca_error then
725: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
726: then
727: if (x_msg_count > 0)
728: then
729: for i in 1..x_msg_count

Line 731: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);

727: if (x_msg_count > 0)
728: then
729: for i in 1..x_msg_count
730: loop
731: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
732: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
733: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
734: end loop;
735: else

Line 732: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'

728: then
729: for i in 1..x_msg_count
730: loop
731: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
732: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
733: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
734: end loop;
735: else
736: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

732: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
733: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
734: end loop;
735: else
736: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
737: , 'x_return_status = ' || x_return_status);
738: end if;
739: end if;
740: when others then

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

737: , 'x_return_status = ' || x_return_status);
738: end if;
739: end if;
740: when others then
741: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
742: then
743: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
744: end if;
745: end update_party;

Line 743: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

739: end if;
740: when others then
741: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
742: then
743: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
744: end if;
745: end update_party;
746: --
747: -------------------------------------------------------------------------------

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

762:
763: begin
764: l_module_source := G_MODULE_SOURCE || 'update_phone_contact_point';
765:
766: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
767: then
768: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
769: end if;
770:

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

764: l_module_source := G_MODULE_SOURCE || 'update_phone_contact_point';
765:
766: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
767: then
768: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
769: end if;
770:
771: fnd_oid_users.get_contact_point_rec(
772: p_ldap_message => p_ldap_message,

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

826: then
827: raise l_tca_error;
828: end if;
829:
830: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
831: then
832: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
833: end if;
834:

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

828: end if;
829:
830: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
831: then
832: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
833: end if;
834:
835: exception
836: when l_tca_error then

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

833: end if;
834:
835: exception
836: when l_tca_error then
837: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
838: then
839: if (x_msg_count > 0)
840: then
841: for i in 1..x_msg_count

Line 843: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);

839: if (x_msg_count > 0)
840: then
841: for i in 1..x_msg_count
842: loop
843: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
844: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
845: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
846: end loop;
847: else

Line 844: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'

840: then
841: for i in 1..x_msg_count
842: loop
843: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
844: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
845: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
846: end loop;
847: else
848: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

844: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
845: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
846: end loop;
847: else
848: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
849: , 'x_return_status = ' || x_return_status);
850: end if;
851: end if;
852: when others then

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

849: , 'x_return_status = ' || x_return_status);
850: end if;
851: end if;
852: when others then
853: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
854: then
855: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
856: end if;
857: end update_phone_contact_point;

Line 855: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

851: end if;
852: when others then
853: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
854: then
855: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
856: end if;
857: end update_phone_contact_point;
858: --
859: -------------------------------------------------------------------------------

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

873:
874: begin
875: l_module_source := G_MODULE_SOURCE || 'update_email_contact_point';
876:
877: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
878: then
879: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
880: end if;
881:

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

875: l_module_source := G_MODULE_SOURCE || 'update_email_contact_point';
876:
877: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
878: then
879: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
880: end if;
881:
882: fnd_oid_users.get_contact_point_rec(
883: p_ldap_message => p_ldap_message,

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

922: then
923: raise l_tca_error;
924: end if;
925:
926: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
927: then
928: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
929: end if;
930:

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

924: end if;
925:
926: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
927: then
928: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
929: end if;
930:
931: exception
932: when l_tca_error then

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

929: end if;
930:
931: exception
932: when l_tca_error then
933: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
934: then
935: if (x_msg_count > 0)
936: then
937: for i in 1..x_msg_count

Line 939: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);

935: if (x_msg_count > 0)
936: then
937: for i in 1..x_msg_count
938: loop
939: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
940: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
941: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
942: end loop;
943: else

Line 940: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'

936: then
937: for i in 1..x_msg_count
938: loop
939: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
940: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
941: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
942: end loop;
943: else
944: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

940: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
941: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
942: end loop;
943: else
944: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
945: , 'x_return_status = ' || x_return_status);
946: end if;
947: end if;
948: when others then

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

945: , 'x_return_status = ' || x_return_status);
946: end if;
947: end if;
948: when others then
949: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
950: then
951: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
952: end if;
953: end update_email_contact_point;

Line 951: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

947: end if;
948: when others then
949: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
950: then
951: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
952: end if;
953: end update_email_contact_point;
954: --
955: -------------------------------------------------------------------------------

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

971:
972: begin
973: l_module_source := G_MODULE_SOURCE || 'update_party_site';
974:
975: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
976: then
977: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
978: end if;
979:

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

973: l_module_source := G_MODULE_SOURCE || 'update_party_site';
974:
975: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
976: then
977: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
978: end if;
979:
980: fnd_oid_users.get_party_site_rec(
981: p_ldap_message => p_ldap_message,

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

1053: then
1054: raise l_tca_error;
1055: end if;
1056:
1057: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1058: then
1059: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1060: end if;
1061:

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

1055: end if;
1056:
1057: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1058: then
1059: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1060: end if;
1061:
1062: exception
1063: when l_tca_error then

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

1060: end if;
1061:
1062: exception
1063: when l_tca_error then
1064: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1065: then
1066: if (x_msg_count > 0)
1067: then
1068: for i in 1..x_msg_count

Line 1070: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);

1066: if (x_msg_count > 0)
1067: then
1068: for i in 1..x_msg_count
1069: loop
1070: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
1071: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
1072: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
1073: end loop;
1074: else

Line 1071: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'

1067: then
1068: for i in 1..x_msg_count
1069: loop
1070: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
1071: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
1072: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
1073: end loop;
1074: else
1075: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

1071: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
1072: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
1073: end loop;
1074: else
1075: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1076: , 'x_return_status = ' || x_return_status);
1077: end if;
1078: end if;
1079: when others then

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

1076: , 'x_return_status = ' || x_return_status);
1077: end if;
1078: end if;
1079: when others then
1080: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1081: then
1082: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1083: end if;
1084: end update_party_site;

Line 1082: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

1078: end if;
1079: when others then
1080: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1081: then
1082: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1083: end if;
1084: end update_party_site;
1085: --
1086: -------------------------------------------------------------------------------

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

1103:
1104: begin
1105: l_module_source := G_MODULE_SOURCE || 'get_person_rec';
1106:
1107: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1108: then
1109: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1110: end if;
1111:

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

1105: l_module_source := G_MODULE_SOURCE || 'get_person_rec';
1106:
1107: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1108: then
1109: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1110: end if;
1111:
1112: if (p_action_type = G_CREATE)
1113: then

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

1160: end if;
1161:
1162: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1163:
1164: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1165: then
1166: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1167: end if;
1168:

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

1162: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1163:
1164: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1165: then
1166: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1167: end if;
1168:
1169: exception
1170: when l_tca_error then

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

1167: end if;
1168:
1169: exception
1170: when l_tca_error then
1171: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1172: then
1173: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1174: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');
1175: end if;

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

1169: exception
1170: when l_tca_error then
1171: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1172: then
1173: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1174: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');
1175: end if;
1176: when others then
1177: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

1173: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1174: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');
1175: end if;
1176: when others then
1177: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1178: then
1179: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1180: end if;
1181: end get_person_rec;

Line 1179: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

1175: end if;
1176: when others then
1177: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1178: then
1179: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1180: end if;
1181: end get_person_rec;
1182: --
1183: -------------------------------------------------------------------------------

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

1200:
1201: begin
1202: l_module_source := G_MODULE_SOURCE || 'get_contact_point_rec';
1203:
1204: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1205: then
1206: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1207: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1208: , 'p_action_type = ' || p_action_type );

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

1202: l_module_source := G_MODULE_SOURCE || 'get_contact_point_rec';
1203:
1204: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1205: then
1206: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1207: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1208: , 'p_action_type = ' || p_action_type );
1209: end if;
1210:

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

1203:
1204: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1205: then
1206: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1207: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1208: , 'p_action_type = ' || p_action_type );
1209: end if;
1210:
1211: if (p_action_type = G_CREATE)

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

1257: end if;
1258:
1259: x_contact_point_rec.contact_point_id := l_owner_table_id;
1260:
1261: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1262: then
1263: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1264: end if;
1265:

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

1259: x_contact_point_rec.contact_point_id := l_owner_table_id;
1260:
1261: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1262: then
1263: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1264: end if;
1265:
1266: end if;
1267:

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

1266: end if;
1267:
1268: exception
1269: when l_tca_error then
1270: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1271: then
1272: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1273: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');
1274: end if;

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

1268: exception
1269: when l_tca_error then
1270: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1271: then
1272: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1273: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');
1274: end if;
1275: when others then
1276: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

1272: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1273: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');
1274: end if;
1275: when others then
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, sqlerrm);
1279: end if;
1280: end get_contact_point_rec;

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

1274: end if;
1275: when others then
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, sqlerrm);
1279: end if;
1280: end get_contact_point_rec;
1281: --
1282: -------------------------------------------------------------------------------

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

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

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

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

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

1309: if (p_ldap_message.c is not null)
1310: then
1311: --The following logic should removed once OID ensures that they send the correct
1312: --"c" attribute based on the LDAP standard
1313: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1314: then
1315: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1316: 'Country from OID: '||p_ldap_message.c);
1317: end if;

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

1311: --The following logic should removed once OID ensures that they send the correct
1312: --"c" attribute based on the LDAP standard
1313: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1314: then
1315: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1316: 'Country from OID: '||p_ldap_message.c);
1317: end if;
1318:
1319: open cur_fnd_territories;

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

1321: l_found := cur_fnd_territories%found;
1322:
1323: if(l_found)
1324: then
1325: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1326: then
1327: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1328: 'Setting country: '||l_territory_code);
1329: end if;

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

1323: if(l_found)
1324: then
1325: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1326: then
1327: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1328: 'Setting country: '||l_territory_code);
1329: end if;
1330: x_location_rec.country := l_territory_code;
1331: else

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

1328: 'Setting country: '||l_territory_code);
1329: end if;
1330: x_location_rec.country := l_territory_code;
1331: else
1332: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1333: then
1334: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1335: 'Setting country to null');
1336: end if;

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

1330: x_location_rec.country := l_territory_code;
1331: else
1332: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1333: then
1334: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1335: 'Setting country to null');
1336: end if;
1337: x_location_rec.country := null;
1338: end if;

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

1356: end if;
1357:
1358: x_location_rec.created_by_module := G_FND_OID_SYNCH;
1359:
1360: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1361: then
1362: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1363: end if;
1364:

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

1358: x_location_rec.created_by_module := G_FND_OID_SYNCH;
1359:
1360: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1361: then
1362: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1363: end if;
1364:
1365: exception
1366: when others then

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

1368: then
1369: close cur_fnd_territories;
1370: end if;
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, sqlerrm);
1375: end if;
1376: end get_location_rec;

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

1370: end if;
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, sqlerrm);
1375: end if;
1376: end get_location_rec;
1377: --
1378: -------------------------------------------------------------------------------

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

1395:
1396: begin
1397: l_module_source := G_MODULE_SOURCE || 'get_party_site_rec';
1398:
1399: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1400: then
1401: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1402: end if;
1403:

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

1397: l_module_source := G_MODULE_SOURCE || 'get_party_site_rec';
1398:
1399: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1400: then
1401: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1402: end if;
1403:
1404: if (p_action_type = G_CREATE)
1405: then

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

1450: x_party_site_rec.created_by_module := G_FND_OID_SYNCH;
1451:
1452: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1453:
1454: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1455: then
1456: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1457: end if;
1458:

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

1452: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1453:
1454: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1455: then
1456: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1457: end if;
1458:
1459: exception
1460: when l_tca_error then

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

1457: end if;
1458:
1459: exception
1460: when l_tca_error then
1461: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1462: then
1463: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1464: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');
1465: end if;

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

1459: exception
1460: when l_tca_error then
1461: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1462: then
1463: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1464: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');
1465: end if;
1466: when others then
1467: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

1463: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1464: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');
1465: end if;
1466: when others then
1467: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1468: then
1469: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1470: end if;
1471: end get_party_site_rec;

Line 1469: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

1465: end if;
1466: when others then
1467: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1468: then
1469: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1470: end if;
1471: end get_party_site_rec;
1472: --
1473: -------------------------------------------------------------------------------

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

1482:
1483: begin
1484: l_module_source := G_MODULE_SOURCE || 'get_orig_system_ref';
1485:
1486: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1487: then
1488: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1489: end if;
1490:

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

1484: l_module_source := G_MODULE_SOURCE || 'get_orig_system_ref';
1485:
1486: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1487: then
1488: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1489: end if;
1490:
1491: select user_id
1492: into l_user_id

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

1493: from fnd_user where user_name = upper(p_ldap_message.object_name);
1494:
1495: x_reference := p_tag || l_user_id;
1496:
1497: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1498: then
1499: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1500: , 'Orig System Reference = ' || x_reference);
1501: end if;

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

1495: x_reference := p_tag || l_user_id;
1496:
1497: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1498: then
1499: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1500: , 'Orig System Reference = ' || x_reference);
1501: end if;
1502:
1503: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

1499: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1500: , 'Orig System Reference = ' || x_reference);
1501: end if;
1502:
1503: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1504: then
1505: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1506: end if;
1507:

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

1501: end if;
1502:
1503: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1504: then
1505: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1506: end if;
1507:
1508: exception
1509: when others then

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

1506: end if;
1507:
1508: exception
1509: when others then
1510: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1511: then
1512: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1513: end if;
1514: end get_orig_system_ref;

Line 1512: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

1508: exception
1509: when others then
1510: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1511: then
1512: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1513: end if;
1514: end get_orig_system_ref;
1515: --
1516: -------------------------------------------------------------------------------

Line 1538: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1534: x_msg_data varchar2(2000);
1535:
1536: begin
1537: l_module_source := G_MODULE_SOURCE || 'create_orig_sys_reference_rec';
1538: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1539: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
1540:
1541: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1542: then

Line 1539: l_proc_level := FND_LOG.LEVEL_PROCEDURE;

1535:
1536: begin
1537: l_module_source := G_MODULE_SOURCE || 'create_orig_sys_reference_rec';
1538: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1539: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
1540:
1541: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1542: then
1543: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');

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

1537: l_module_source := G_MODULE_SOURCE || 'create_orig_sys_reference_rec';
1538: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1539: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
1540:
1541: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1542: then
1543: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1544: end if;
1545:

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

1539: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
1540:
1541: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1542: then
1543: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1544: end if;
1545:
1546: fnd_oid_users.get_orig_system_ref(
1547: p_ldap_message => p_ldap_message,

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

1599: end if;
1600:
1601: end if;
1602:
1603: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1604: then
1605: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1606: end if;
1607:

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

1601: end if;
1602:
1603: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1604: then
1605: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1606: end if;
1607:
1608: exception
1609: when l_tca_error then

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

1606: end if;
1607:
1608: exception
1609: when l_tca_error then
1610: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1611: then
1612: if (x_msg_count > 0)
1613: then
1614: for i in 1..x_msg_count

Line 1616: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);

1612: if (x_msg_count > 0)
1613: then
1614: for i in 1..x_msg_count
1615: loop
1616: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
1617: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
1618: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
1619: end loop;
1620: else

Line 1617: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'

1613: then
1614: for i in 1..x_msg_count
1615: loop
1616: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
1617: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
1618: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
1619: end loop;
1620: else
1621: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

1617: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
1618: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
1619: end loop;
1620: else
1621: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1622: , 'x_return_status = ' || x_return_status);
1623: end if;
1624: end if;
1625: when others then

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

1622: , 'x_return_status = ' || x_return_status);
1623: end if;
1624: end if;
1625: when others then
1626: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1627: then
1628: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1629: end if;
1630: end create_orig_system_reference;

Line 1628: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

1624: end if;
1625: when others then
1626: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1627: then
1628: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1629: end if;
1630: end create_orig_system_reference;
1631: --
1632: -------------------------------------------------------------------------------

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

1650:
1651: begin
1652: l_module_source := G_MODULE_SOURCE || 'get_orig_sys_reference_rec';
1653:
1654: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1655: then
1656: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1657: end if;
1658:

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

1652: l_module_source := G_MODULE_SOURCE || 'get_orig_sys_reference_rec';
1653:
1654: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1655: then
1656: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1657: end if;
1658:
1659: l_orig_sys_rec.orig_system := G_FND_OID_SYNCH;
1660: fnd_oid_users.get_orig_system_ref(

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

1689: then
1690: raise l_tca_error;
1691: end if;
1692:
1693: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1694: then
1695: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1696: end if;
1697:

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

1691: end if;
1692:
1693: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1694: then
1695: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1696: end if;
1697:
1698: exception
1699: when l_tca_error then

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

1696: end if;
1697:
1698: exception
1699: when l_tca_error then
1700: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1701: then
1702: if (x_msg_count > 0)
1703: then
1704: for i in 1..x_msg_count

Line 1706: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);

1702: if (x_msg_count > 0)
1703: then
1704: for i in 1..x_msg_count
1705: loop
1706: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
1707: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
1708: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
1709: end loop;
1710: else

Line 1707: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'

1703: then
1704: for i in 1..x_msg_count
1705: loop
1706: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, x_msg_data);
1707: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
1708: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
1709: end loop;
1710: else
1711: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

1707: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, i || '.'
1708: || SubStr(fnd_msg_pub.get(p_encoded => fnd_api.g_false), 1, 255));
1709: end loop;
1710: else
1711: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1712: , 'x_return_status = ' || x_return_status);
1713: end if;
1714: end if;
1715: when others then

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

1712: , 'x_return_status = ' || x_return_status);
1713: end if;
1714: end if;
1715: when others then
1716: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1717: then
1718: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1719: end if;
1720: end update_orig_system_reference;

Line 1718: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

1714: end if;
1715: when others then
1716: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1717: then
1718: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1719: end if;
1720: end update_orig_system_reference;
1721: --
1722: -------------------------------------------------------------------------------

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

1728:
1729: begin
1730: l_module_source := G_MODULE_SOURCE || 'test: ';
1731:
1732: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1733: then
1734: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1735: end if;
1736:

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

1730: l_module_source := G_MODULE_SOURCE || 'test: ';
1731:
1732: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1733: then
1734: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1735: end if;
1736:
1737: l_ldap_record.sn := 'FAZIL';
1738: l_ldap_record.object_name := 'FND95.2';

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

1753: fnd_oid_users.hz_update(p_ldap_message => l_ldap_record,
1754: x_return_status => l_return_status);
1755: commit;
1756:
1757: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1758: then
1759: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1760: end if;
1761:

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

1755: commit;
1756:
1757: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1758: then
1759: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');
1760: end if;
1761:
1762: exception
1763: when others then

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

1760: end if;
1761:
1762: exception
1763: when others then
1764: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1765: then
1766: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1767: end if;
1768: end test;

Line 1766: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);

1762: exception
1763: when others then
1764: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1765: then
1766: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, sqlerrm);
1767: end if;
1768: end test;
1769: --
1770: -------------------------------------------------------------------------------