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_OID_USERS

Line 1: package body fnd_oid_users as

1: package body fnd_oid_users as
2: /* $Header: AFSCOURB.pls 120.6 2005/11/03 16:12:34 ssallaka noship $ */
3: --
4: /*****************************************************************************/
5: -- Start of Package Globals

Line 7: G_MODULE_SOURCE constant varchar2(80) := 'fnd.plsql.oid.fnd_oid_users.';

3: --
4: /*****************************************************************************/
5: -- Start of Package Globals
6:
7: G_MODULE_SOURCE constant varchar2(80) := 'fnd.plsql.oid.fnd_oid_users.';
8:
9: -- End of Package Globals
10: --
11: -------------------------------------------------------------------------------

Line 43: fnd_oid_users.create_party(p_ldap_message => p_ldap_message,

39:
40: if ( (p_ldap_message.sn is not null)
41: or (p_ldap_message.givenName is not null) )
42: then
43: fnd_oid_users.create_party(p_ldap_message => p_ldap_message,
44: x_return_status => x_return_status);
45: end if;
46:
47: if (x_return_status = Fnd_Api.G_RET_STS_SUCCESS) then

Line 56: fnd_oid_users.create_phone_contact_point(

52: end if;
53:
54: if (p_ldap_message.telephoneNumber is not null)
55: then
56: fnd_oid_users.create_phone_contact_point(
57: p_ldap_message => p_ldap_message,
58: p_contact_point_purpose => G_BUSINESS,
59: x_return_status => x_return_status);
60: end if;

Line 64: fnd_oid_users.create_phone_contact_point(

60: end if;
61:
62: if (p_ldap_message.homePhone is not null)
63: then
64: fnd_oid_users.create_phone_contact_point(
65: p_ldap_message => p_ldap_message,
66: p_contact_point_purpose => G_PERSONAL,
67: x_return_status => x_return_status);
68: end if;

Line 72: fnd_oid_users.create_email_contact_point(

68: end if;
69:
70: if (p_ldap_message.mail is not null)
71: then
72: fnd_oid_users.create_email_contact_point(
73: p_ldap_message => p_ldap_message,
74: x_return_status => x_return_status);
75: end if;
76:

Line 79: fnd_oid_users.create_location(

75: end if;
76:
77: if ( (p_ldap_message.c is not null) and (p_ldap_message.street is not null) )
78: then
79: fnd_oid_users.create_location(
80: p_ldap_message => p_ldap_message,
81: x_return_status => x_return_status);
82: end if;
83: else

Line 129: fnd_oid_users.get_person_rec(p_ldap_message => p_ldap_message,

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,
131: x_person_rec => x_person_rec,
132: x_return_status => x_return_status);
133:

Line 153: fnd_oid_users.create_orig_system_reference(

149: then
150: raise l_tca_error;
151: end if;
152:
153: fnd_oid_users.create_orig_system_reference(
154: p_ldap_message => p_ldap_message,
155: p_tag => G_PERSON,
156: p_owner_table_name => G_HZ_PARTIES,
157: p_owner_table_id => x_party_id,

Line 237: fnd_oid_users.get_contact_point_rec(

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,
239: p_contact_point_type => G_PHONE,
240: p_contact_point_purpose => p_contact_point_purpose,
241: p_action_type => G_CREATE,

Line 274: fnd_oid_users.create_orig_system_reference(

270: then
271: raise l_tca_error;
272: end if;
273:
274: fnd_oid_users.create_orig_system_reference(
275: p_ldap_message => p_ldap_message,
276: p_tag => p_contact_point_purpose,
277: p_owner_table_name => G_HZ_CONTACT_POINTS,
278: p_owner_table_id => x_contact_point_id,

Line 339: fnd_oid_users.get_contact_point_rec(

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,
341: p_contact_point_type => G_EMAIL,
342: p_contact_point_purpose => NULL,
343: p_action_type => G_CREATE,

Line 368: fnd_oid_users.create_orig_system_reference(

364: then
365: raise l_tca_error;
366: end if;
367:
368: fnd_oid_users.create_orig_system_reference(
369: p_ldap_message => p_ldap_message,
370: p_tag => G_EMAIL,
371: p_owner_table_name => G_HZ_CONTACT_POINTS,
372: p_owner_table_id => x_contact_point_id,

Line 434: fnd_oid_users.get_location_rec(p_ldap_message => p_ldap_message,

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);
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)

Line 454: fnd_oid_users.create_party_site(

450: then
451: raise l_tca_error;
452: end if;
453:
454: fnd_oid_users.create_party_site(
455: p_ldap_message => p_ldap_message,
456: p_location_id => x_location_id,
457: x_return_status => x_return_status);
458:

Line 518: fnd_oid_users.get_party_site_rec(

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,
520: p_action_type => G_CREATE,
521: x_party_site_rec => x_party_site_rec,
522: x_return_status => x_return_status);

Line 544: fnd_oid_users.create_orig_system_reference(

540: then
541: raise l_tca_error;
542: end if;
543:
544: fnd_oid_users.create_orig_system_reference(
545: p_ldap_message => p_ldap_message,
546: p_tag => G_LOCATION,
547: p_owner_table_name => G_HZ_PARTY_SITES,
548: p_owner_table_id => x_party_site_id,

Line 606: fnd_oid_users.update_party(p_ldap_message => p_ldap_message,

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))
605: then
606: fnd_oid_users.update_party(p_ldap_message => p_ldap_message,
607: x_return_status => x_return_status);
608: end if;
609: --adding a check for '*UNKNOWN*' string as well.
610: -- bug 4411121

Line 613: fnd_oid_users.update_phone_contact_point(

609: --adding a check for '*UNKNOWN*' string as well.
610: -- bug 4411121
611: if (p_ldap_message.telephoneNumber is not null and p_ldap_message.telephoneNumber <> G_UNKNOWN)
612: then
613: fnd_oid_users.update_phone_contact_point(
614: p_ldap_message => p_ldap_message,
615: p_contact_point_purpose => G_BUSINESS,
616: x_return_status => x_return_status);
617: end if;

Line 621: fnd_oid_users.update_phone_contact_point(

617: end if;
618:
619: if (p_ldap_message.homePhone is not null and p_ldap_message.homePhone <> G_UNKNOWN)
620: then
621: fnd_oid_users.update_phone_contact_point(
622: p_ldap_message => p_ldap_message,
623: p_contact_point_purpose => G_PERSONAL,
624: x_return_status => x_return_status);
625: end if;

Line 629: fnd_oid_users.update_email_contact_point(

625: end if;
626:
627: if (p_ldap_message.mail is not null and p_ldap_message.mail <> G_UNKNOWN)
628: then
629: fnd_oid_users.update_email_contact_point(
630: p_ldap_message => p_ldap_message,
631: x_return_status => x_return_status);
632: end if;
633:

Line 642: fnd_oid_users.update_party_site(p_ldap_message => p_ldap_message,

638: (p_ldap_message.l is not null and p_ldap_message.l <> G_UNKNOWN) or
639: (p_ldap_message.physicalDeliveryOfficeName is not null and p_ldap_message.physicalDeliveryOfficeName <> G_UNKNOWN)
640: )
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

Line 690: fnd_oid_users.get_person_rec(p_ldap_message => p_ldap_message,

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,
692: x_person_rec => x_person_rec,
693: x_return_status => x_return_status);
694:

Line 771: fnd_oid_users.get_contact_point_rec(

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,
773: p_contact_point_type => G_PHONE,
774: p_contact_point_purpose => p_contact_point_purpose,
775: p_action_type => G_UPDATE,

Line 819: fnd_oid_users.create_phone_contact_point(

815: end if;
816:
817: else
818:
819: fnd_oid_users.create_phone_contact_point(
820: p_ldap_message => p_ldap_message,
821: p_contact_point_purpose => p_contact_point_purpose,
822: x_return_status => x_return_status);
823: end if;

Line 882: fnd_oid_users.get_contact_point_rec(

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,
884: p_contact_point_type => G_EMAIL,
885: p_contact_point_purpose => NULL,
886: p_action_type => G_UPDATE,

Line 917: fnd_oid_users.create_email_contact_point(p_ldap_message => p_ldap_message,

913: x_msg_data => x_msg_data);
914:
915: else
916:
917: fnd_oid_users.create_email_contact_point(p_ldap_message => p_ldap_message,
918: x_return_status => x_return_status);
919: end if;
920:
921: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

Line 980: fnd_oid_users.get_party_site_rec(

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,
982: p_action_type => G_UPDATE,
983: x_party_site_rec => x_party_site_rec,
984: x_return_status => x_return_status);

Line 1013: fnd_oid_users.get_location_rec(p_ldap_message => p_ldap_message,

1009: into p_object_version_number
1010: from hz_locations
1011: where location_id = l_location_id;
1012:
1013: fnd_oid_users.get_location_rec(p_ldap_message => p_ldap_message,
1014: x_location_rec => x_location_rec);
1015:
1016: x_location_rec.location_id := l_location_id;
1017:

Line 1048: fnd_oid_users.create_location(p_ldap_message => p_ldap_message,

1044: end if;
1045: end if;
1046: else
1047:
1048: fnd_oid_users.create_location(p_ldap_message => p_ldap_message,
1049: x_return_status => x_return_status);
1050:
1051: end if;
1052: if (x_return_status <> fnd_api.G_RET_STS_SUCCESS)

Line 1131: fnd_oid_users.get_orig_system_ref(

1127: x_person_rec.created_by_module := G_FND_OID_SYNCH;
1128:
1129: elsif (p_action_type = G_UPDATE)
1130: then
1131: fnd_oid_users.get_orig_system_ref(
1132: p_ldap_message => p_ldap_message,
1133: p_tag => G_PERSON,
1134: x_reference => l_orig_system_reference);
1135: hz_orig_system_ref_pub.get_owner_table_id(

Line 1237: fnd_oid_users.get_orig_system_ref(

1233: */
1234:
1235: if (p_contact_point_type = G_PHONE)
1236: then
1237: fnd_oid_users.get_orig_system_ref(
1238: p_ldap_message => p_ldap_message,
1239: p_tag => p_contact_point_purpose,
1240: x_reference => l_orig_system_reference);
1241: else

Line 1242: fnd_oid_users.get_orig_system_ref(

1238: p_ldap_message => p_ldap_message,
1239: p_tag => p_contact_point_purpose,
1240: x_reference => l_orig_system_reference);
1241: else
1242: fnd_oid_users.get_orig_system_ref(
1243: p_ldap_message => p_ldap_message,
1244: p_tag => p_contact_point_type,
1245: x_reference => l_orig_system_reference);
1246: end if;

Line 1426: fnd_oid_users.get_orig_system_ref(

1422: x_party_site_rec.party_id := l_party_id;
1423:
1424: elsif (p_action_type = G_UPDATE)
1425: then
1426: fnd_oid_users.get_orig_system_ref(
1427: p_ldap_message => p_ldap_message,
1428: p_tag => G_LOCATION,
1429: x_reference => l_orig_system_reference);
1430: hz_orig_system_ref_pub.get_owner_table_id(

Line 1546: fnd_oid_users.get_orig_system_ref(

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,
1548: p_tag => p_tag,
1549: x_reference => l_orig_system_reference);
1550:

Line 1574: fnd_oid_users.update_orig_system_reference(

1570:
1571: if (l_owner_table_id is not null)
1572: then
1573:
1574: fnd_oid_users.update_orig_system_reference(
1575: p_ldap_message => p_ldap_message,
1576: p_tag => p_tag,
1577: p_owner_table_name => p_owner_table_name,
1578: p_owner_table_id => p_owner_table_id,

Line 1660: fnd_oid_users.get_orig_system_ref(

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(
1661: p_ldap_message => p_ldap_message,
1662: p_tag => p_tag,
1663: x_reference => l_orig_system_reference);
1664:

Line 1751: --fnd_oid_users.hz_create(p_ldap_message => l_ldap_record,

1747: l_ldap_record.postalCode := '94065';
1748: l_ldap_record.st := 'ca';
1749: l_ldap_record.l := 'rs';
1750:
1751: --fnd_oid_users.hz_create(p_ldap_message => l_ldap_record,
1752: --x_return_status => l_return_status);
1753: fnd_oid_users.hz_update(p_ldap_message => l_ldap_record,
1754: x_return_status => l_return_status);
1755: commit;

Line 1753: fnd_oid_users.hz_update(p_ldap_message => l_ldap_record,

1749: l_ldap_record.l := 'rs';
1750:
1751: --fnd_oid_users.hz_create(p_ldap_message => l_ldap_record,
1752: --x_return_status => l_return_status);
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)

Line 1771: end fnd_oid_users;

1767: end if;
1768: end test;
1769: --
1770: -------------------------------------------------------------------------------
1771: end fnd_oid_users;