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

Line 326: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

322: app_exception.raise_exception;
323: end if;
324: end if;
325:
326: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
327: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
328: c_log_head || l_api_name || '.before_upduser',
329: 'UpdateUser(): before updating user');
330: end if;

Line 327: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

323: end if;
324: end if;
325:
326: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
327: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
328: c_log_head || l_api_name || '.before_upduser',
329: 'UpdateUser(): before updating user');
330: end if;
331:

Line 369: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

365: fnd_function_security_cache.update_user(l_user_id);
366: end if;
367:
368:
369: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
370: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
371: 'Start calling ldap_wrapper_update_user');
372: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
373: 'x_user_name = '||x_user_name);

Line 370: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

366: end if;
367:
368:
369: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
370: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
371: 'Start calling ldap_wrapper_update_user');
372: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
373: 'x_user_name = '||x_user_name);
374: end if;

Line 372: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

368:
369: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
370: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
371: 'Start calling ldap_wrapper_update_user');
372: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
373: 'x_user_name = '||x_user_name);
374: end if;
375:
376: -- Enhancement 5027812

Line 415: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

411: end;
412: end if;
413: -- End bug 4318754, 4424225
414:
415: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
416: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
417: 'After calling ldap_wrapper_update_user');
418: end if;
419:

Line 416: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

412: end if;
413: -- End bug 4318754, 4424225
414:
415: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
416: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
417: 'After calling ldap_wrapper_update_user');
418: end if;
419:
420: -- Sync user change to LDAP

Line 742: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

738: pwd := '';
739: end if;
740:
741: -- Bug#4118749 - Create user in OID
742: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
743: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
744: 'Start calling ldap_wrapper_create_user');
745: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
746: 'x_user_name = '||x_user_name);

Line 743: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

739: end if;
740:
741: -- Bug#4118749 - Create user in OID
742: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
743: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
744: 'Start calling ldap_wrapper_create_user');
745: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
746: 'x_user_name = '||x_user_name);
747: end if;

Line 745: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

741: -- Bug#4118749 - Create user in OID
742: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
743: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
744: 'Start calling ldap_wrapper_create_user');
745: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
746: 'x_user_name = '||x_user_name);
747: end if;
748:
749: begin

Line 783: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

779: fnd_message.set_token('REASON', reason);
780: app_exception.raise_exception;
781: end;
782:
783: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
784: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
785: 'After calling ldap_wrapper_create_user');
786: end if;
787: else

Line 784: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

780: app_exception.raise_exception;
781: end;
782:
783: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
784: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
785: 'After calling ldap_wrapper_create_user');
786: end if;
787: else
788: l_user_guid := x_user_guid;

Line 798: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

794: set created_by = owner_id
795: where user_name = upper(x_user_name);
796:
797: -- update the rest of the data except password
798: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
799: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
800: c_log_head || l_api_name || '.call_upduser',
801: 'CreateUser(): calling fnd_user_pkg.UpdateUser');
802: end if;

Line 799: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

795: where user_name = upper(x_user_name);
796:
797: -- update the rest of the data except password
798: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
799: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
800: c_log_head || l_api_name || '.call_upduser',
801: 'CreateUser(): calling fnd_user_pkg.UpdateUser');
802: end if;
803:

Line 1261: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1257: exists_flag varchar2(1);
1258: reason varchar2(32000);
1259: begin
1260:
1261: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1262: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1263: c_log_head || l_api_name || '.before_updstmnt',
1264: 'LoadUser(): before update statement');
1265: end if;

Line 1262: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1258: reason varchar2(32000);
1259: begin
1260:
1261: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1262: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1263: c_log_head || l_api_name || '.before_updstmnt',
1264: 'LoadUser(): before update statement');
1265: end if;
1266: begin

Line 1299: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1295: else -- Must be new user
1296: -- insert the new user if x_session_number and x_start_date are provided
1297: if (x_unencrypted_password is not null) then
1298:
1299: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1300: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1301: c_log_head || l_api_name || '.call_creatuser',
1302: 'LoadUser(): calling CreateUser');
1303: end if;

Line 1300: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1296: -- insert the new user if x_session_number and x_start_date are provided
1297: if (x_unencrypted_password is not null) then
1298:
1299: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1300: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1301: c_log_head || l_api_name || '.call_creatuser',
1302: 'LoadUser(): calling CreateUser');
1303: end if;
1304: fnd_user_pkg.createuser(x_user_name,

Line 1361: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1357: exists_flag varchar2(1);
1358: reason varchar2(32000);
1359: begin
1360:
1361: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1362: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1363: c_log_head || l_api_name || '.before_updstmnt',
1364: 'LoadUser(): before update statement');
1365: end if;

Line 1362: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1358: reason varchar2(32000);
1359: begin
1360:
1361: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1362: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1363: c_log_head || l_api_name || '.before_updstmnt',
1364: 'LoadUser(): before update statement');
1365: end if;
1366: begin

Line 1397: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1393: else -- Must be new user
1394: -- insert the new user if x_session_number and x_start_date are provided
1395: if (x_unencrypted_password is not null) then
1396:
1397: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1398: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1399: c_log_head || l_api_name || '.call_creatuser',
1400: 'LoadUser(): calling CreateUser');
1401: end if;

Line 1398: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1394: -- insert the new user if x_session_number and x_start_date are provided
1395: if (x_unencrypted_password is not null) then
1396:
1397: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1398: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1399: c_log_head || l_api_name || '.call_creatuser',
1400: 'LoadUser(): calling CreateUser');
1401: end if;
1402: fnd_user_pkg.createuserparty(x_user_name,

Line 1634: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1630: where user_guid = userGuid;
1631:
1632: begin
1633:
1634: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1635: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1636: 'Start user_change');
1637: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1638: 'p_subscription_guid ='||p_subscription_guid);

Line 1635: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1631:
1632: begin
1633:
1634: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1635: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1636: 'Start user_change');
1637: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1638: 'p_subscription_guid ='||p_subscription_guid);
1639: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 1637: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1633:
1634: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1635: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1636: 'Start user_change');
1637: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1638: 'p_subscription_guid ='||p_subscription_guid);
1639: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1640: 'event_name ='||p_event.GetEventName);
1641: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 1639: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1635: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1636: 'Start user_change');
1637: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1638: 'p_subscription_guid ='||p_subscription_guid);
1639: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1640: 'event_name ='||p_event.GetEventName);
1641: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1642: 'parameter CHANGE_SOURCE ='||
1643: p_event.GetValueForParameter('CHANGE_SOURCE'));

Line 1641: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1637: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1638: 'p_subscription_guid ='||p_subscription_guid);
1639: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1640: 'event_name ='||p_event.GetEventName);
1641: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1642: 'parameter CHANGE_SOURCE ='||
1643: p_event.GetValueForParameter('CHANGE_SOURCE'));
1644: end if;
1645:

Line 1656: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1652:
1653: my_username := p_event.GetEventKey();
1654: my_mode := p_event.GetValueForParameter('CHANGE_TYPE');
1655:
1656: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1657: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1658: 'LDAP - event_key ='||my_username);
1659: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1660: 'LDAP - parameter CHANGE_TYPE ='||my_mode);

Line 1657: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1653: my_username := p_event.GetEventKey();
1654: my_mode := p_event.GetValueForParameter('CHANGE_TYPE');
1655:
1656: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1657: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1658: 'LDAP - event_key ='||my_username);
1659: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1660: 'LDAP - parameter CHANGE_TYPE ='||my_mode);
1661: end if;

Line 1659: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1655:
1656: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1657: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1658: 'LDAP - event_key ='||my_username);
1659: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1660: 'LDAP - parameter CHANGE_TYPE ='||my_mode);
1661: end if;
1662:
1663: if (my_mode = 'DELETE') then

Line 1754: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1750: -- start the synch loop.
1751: x_user_guid => old_guid,
1752: x_change_source => fnd_user_pkg.change_source_oid);
1753:
1754: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1755: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1756: 'LDAP - finished fnd_user_pkg.UpdateUser('||my_username||')');
1757: end if;
1758: end if;

Line 1755: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1751: x_user_guid => old_guid,
1752: x_change_source => fnd_user_pkg.change_source_oid);
1753:
1754: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1755: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1756: 'LDAP - finished fnd_user_pkg.UpdateUser('||my_username||')');
1757: end if;
1758: end if;
1759: end if;

Line 1768: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1764: my_cachekey := p_event.GetEventKey();
1765: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
1766: my_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1767: 'ORCLGUID');
1768: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1769: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1770: 'OID - event_key ='||my_cachekey);
1771: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1772: 'OID - entity_type ='||my_ent_type);

Line 1769: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1765: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
1766: my_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1767: 'ORCLGUID');
1768: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1769: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1770: 'OID - event_key ='||my_cachekey);
1771: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1772: 'OID - entity_type ='||my_ent_type);
1773: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 1771: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1767: 'ORCLGUID');
1768: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1769: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1770: 'OID - event_key ='||my_cachekey);
1771: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1772: 'OID - entity_type ='||my_ent_type);
1773: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1774: 'OID - guid ='||my_guid);
1775: end if;

Line 1773: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1769: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1770: 'OID - event_key ='||my_cachekey);
1771: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1772: 'OID - entity_type ='||my_ent_type);
1773: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1774: 'OID - guid ='||my_guid);
1775: end if;
1776:
1777: open existing_users(my_guid);

Line 1849: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1845: x_description => new_desc,
1846: x_email_address => new_email,
1847: x_fax => new_fax);
1848:
1849: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1850: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1851: 'OID - finished fnd_user_pkg.UpdateUser('||my_user||')');
1852: end if;
1853: end if;

Line 1850: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1846: x_email_address => new_email,
1847: x_fax => new_fax);
1848:
1849: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1850: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1851: 'OID - finished fnd_user_pkg.UpdateUser('||my_user||')');
1852: end if;
1853: end if;
1854: end if;

Line 1862: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1858: END LOOP;
1859: CLOSE existing_users;
1860: end if;
1861:
1862: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1863: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1864: 'End user_change');
1865: end if;
1866: return wf_rule.default_rule(p_subscription_guid, p_event);

Line 1863: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1859: CLOSE existing_users;
1860: end if;
1861:
1862: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1863: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1864: 'End user_change');
1865: end if;
1866: return wf_rule.default_rule(p_subscription_guid, p_event);
1867: end user_change;

Line 1895: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1891: l_api_name varchar2(30) := 'user_create_rf';
1892:
1893: begin
1894:
1895: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1896: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1897: 'Start user_create_rf');
1898: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1899: 'p_subscription_guid ='||p_subscription_guid);

Line 1896: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1892:
1893: begin
1894:
1895: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1896: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1897: 'Start user_create_rf');
1898: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1899: 'p_subscription_guid ='||p_subscription_guid);
1900: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 1898: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1894:
1895: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1896: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1897: 'Start user_create_rf');
1898: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1899: 'p_subscription_guid ='||p_subscription_guid);
1900: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1901: 'event_name ='||p_event.GetEventName);
1902: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 1900: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1896: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1897: 'Start user_create_rf');
1898: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1899: 'p_subscription_guid ='||p_subscription_guid);
1900: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1901: 'event_name ='||p_event.GetEventName);
1902: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1903: 'parameter CHANGE_SOURCE ='||
1904: p_event.GetValueForParameter('CHANGE_SOURCE'));

Line 1902: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1898: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1899: 'p_subscription_guid ='||p_subscription_guid);
1900: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1901: 'event_name ='||p_event.GetEventName);
1902: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1903: 'parameter CHANGE_SOURCE ='||
1904: p_event.GetValueForParameter('CHANGE_SOURCE'));
1905: end if;
1906: -- Ignore our own changes

Line 1914: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1910: -- If CHANGE_SOURCE is LDAP, it means it's raised from one-way sync code.
1911: elsif (p_event.GetValueForParameter('CHANGE_SOURCE') = 'LDAP') then
1912: my_username := p_event.GetEventKey();
1913:
1914: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1915: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1916: 'LDAP - event_key ='||my_username);
1917: end if;
1918:

Line 1915: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1911: elsif (p_event.GetValueForParameter('CHANGE_SOURCE') = 'LDAP') then
1912: my_username := p_event.GetEventKey();
1913:
1914: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1915: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1916: 'LDAP - event_key ='||my_username);
1917: end if;
1918:
1919: begin

Line 1931: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1927:
1928: -- user doesn't exist yet, we have work to do --
1929: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
1930:
1931: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1932: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1933: 'LDAP - entity_type ='||my_ent_type);
1934: end if;
1935:

Line 1932: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1928: -- user doesn't exist yet, we have work to do --
1929: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
1930:
1931: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1932: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1933: 'LDAP - entity_type ='||my_ent_type);
1934: end if;
1935:
1936: --

Line 1981: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1977: x_description => new_desc2,
1978: x_email_address => new_email2,
1979: x_fax => new_fax2);
1980:
1981: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1982: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1983: 'LDAP - finished fnd_user_pkg.CreateUser('||my_username||')');
1984: end if;
1985: end;

Line 1982: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1978: x_email_address => new_email2,
1979: x_fax => new_fax2);
1980:
1981: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1982: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1983: 'LDAP - finished fnd_user_pkg.CreateUser('||my_username||')');
1984: end if;
1985: end;
1986:

Line 1994: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

1990: my_cachekey := p_event.GetEventKey();
1991: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
1992: new_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1993: 'ORCLGUID');
1994: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1995: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1996: 'OID - event_key ='||my_cachekey);
1997: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1998: 'OID - entity_type ='||my_ent_type);

Line 1995: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1991: my_ent_type := wf_entity_mgr.get_entity_type(p_event.GetEventName());
1992: new_guid := wf_entity_mgr.get_attribute_value(my_ent_type, my_cachekey,
1993: 'ORCLGUID');
1994: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1995: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1996: 'OID - event_key ='||my_cachekey);
1997: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1998: 'OID - entity_type ='||my_ent_type);
1999: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 1997: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1993: 'ORCLGUID');
1994: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1995: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1996: 'OID - event_key ='||my_cachekey);
1997: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1998: 'OID - entity_type ='||my_ent_type);
1999: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2000: 'OID - guid ='||new_guid);
2001: end if;

Line 1999: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

1995: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1996: 'OID - event_key ='||my_cachekey);
1997: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1998: 'OID - entity_type ='||my_ent_type);
1999: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2000: 'OID - guid ='||new_guid);
2001: end if;
2002: begin
2003: select 'Y' into existing_user

Line 2038: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2034: x_description => new_desc,
2035: x_email_address => new_email,
2036: x_fax => new_fax);
2037:
2038: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2039: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2040: 'OID - finished fnd_user_pkg.CreateUser('||my_cachekey||')');
2041: end if;
2042:

Line 2039: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2035: x_email_address => new_email,
2036: x_fax => new_fax);
2037:
2038: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2039: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2040: 'OID - finished fnd_user_pkg.CreateUser('||my_cachekey||')');
2041: end if;
2042:
2043: --

Line 2053: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2049:
2050: end;
2051: end if;
2052:
2053: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2054: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2055: 'End user_create_rf');
2056: end if;
2057:

Line 2054: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2050: end;
2051: end if;
2052:
2053: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2054: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2055: 'End user_create_rf');
2056: end if;
2057:
2058: return wf_rule.default_rule(p_subscription_guid, p_event);

Line 2083: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2079: colnew(1) := '';
2080:
2081: tmpbuf := 'Start calling fnd_dictionary_pkg.updatepkcolumns('||
2082: old_name||','||new_name||')';
2083: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2084: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
2085: tmpbuf);
2086: end if;
2087: ret := fnd_dictionary_pkg.updatepkcolumns('FND', 'FND_USER', colnames, colold,

Line 2084: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

2080:
2081: tmpbuf := 'Start calling fnd_dictionary_pkg.updatepkcolumns('||
2082: old_name||','||new_name||')';
2083: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2084: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
2085: tmpbuf);
2086: end if;
2087: ret := fnd_dictionary_pkg.updatepkcolumns('FND', 'FND_USER', colnames, colold,
2088: colnew);

Line 2090: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2086: end if;
2087: ret := fnd_dictionary_pkg.updatepkcolumns('FND', 'FND_USER', colnames, colold,
2088: colnew);
2089: tmpbuf := 'Finished fnd_dictionary_pkg.updatepkcolumns';
2090: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2091: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
2092: tmpbuf);
2093: end if;
2094: exception

Line 2091: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

2087: ret := fnd_dictionary_pkg.updatepkcolumns('FND', 'FND_USER', colnames, colold,
2088: colnew);
2089: tmpbuf := 'Finished fnd_dictionary_pkg.updatepkcolumns';
2090: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2091: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
2092: tmpbuf);
2093: end if;
2094: exception
2095: when others then

Line 2139: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2135:
2136: begin
2137: -- fetch info for synch --
2138:
2139: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2140: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2141: 'Start user_synch');
2142: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2143: 'p_user_name = '||p_user_name);

Line 2140: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2136: begin
2137: -- fetch info for synch --
2138:
2139: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2140: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2141: 'Start user_synch');
2142: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2143: 'p_user_name = '||p_user_name);
2144: end if;

Line 2142: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2138:
2139: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2140: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2141: 'Start user_synch');
2142: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2143: 'p_user_name = '||p_user_name);
2144: end if;
2145:
2146: select user_id, email_address, description, fax, employee_id,

Line 2241: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2237: wf_event.AddParameterToList('WFSYNCH_OVERWRITE','TRUE',mylist);
2238:
2239: --
2240:
2241: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2242: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2243: 'Calling wf_local_synch.propagate_user');
2244: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2245: 'ORCLGUID = '|| my_guid);

Line 2242: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2238:
2239: --
2240:
2241: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2242: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2243: 'Calling wf_local_synch.propagate_user');
2244: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2245: 'ORCLGUID = '|| my_guid);
2246: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2244: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2240:
2241: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2242: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2243: 'Calling wf_local_synch.propagate_user');
2244: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2245: 'ORCLGUID = '|| my_guid);
2246: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2247: 'PER_PERSON_ID = '|| my_empid);
2248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2246: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2242: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2243: 'Calling wf_local_synch.propagate_user');
2244: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2245: 'ORCLGUID = '|| my_guid);
2246: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2247: 'PER_PERSON_ID = '|| my_empid);
2248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2249: 'PERSON_PARTY_ID = '|| my_partyid);
2250: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2244: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2245: 'ORCLGUID = '|| my_guid);
2246: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2247: 'PER_PERSON_ID = '|| my_empid);
2248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2249: 'PERSON_PARTY_ID = '|| my_partyid);
2250: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2251: 'DISPLAY_NAME(PARTY_NAME) = '|| ptyName);
2252: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 2250: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2246: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2247: 'PER_PERSON_ID = '|| my_empid);
2248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2249: 'PERSON_PARTY_ID = '|| my_partyid);
2250: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2251: 'DISPLAY_NAME(PARTY_NAME) = '|| ptyName);
2252: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2253: 'OLD_USER_NAME = '|| g_old_user_name);
2254: end if;

Line 2252: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2248: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2249: 'PERSON_PARTY_ID = '|| my_partyid);
2250: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2251: 'DISPLAY_NAME(PARTY_NAME) = '|| ptyName);
2252: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2253: 'OLD_USER_NAME = '|| g_old_user_name);
2254: end if;
2255: -- update wf and the entity manager --
2256: wf_local_synch.propagate_user('FND_USR',my_userid, myList, my_start, my_exp);

Line 2259: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2255: -- update wf and the entity manager --
2256: wf_local_synch.propagate_user('FND_USR',my_userid, myList, my_start, my_exp);
2257: -- end of unstub
2258:
2259: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2260: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2261: 'Finished wf_local_synch.propagate_user');
2262: end if;
2263: -- -----------------------------------------------------------------

Line 2260: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2256: wf_local_synch.propagate_user('FND_USR',my_userid, myList, my_start, my_exp);
2257: -- end of unstub
2258:
2259: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2260: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2261: 'Finished wf_local_synch.propagate_user');
2262: end if;
2263: -- -----------------------------------------------------------------
2264: -- since wf_local_synch is temporarily stubbed out, also make the

Line 2304: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

2300: dummy := fnd_user_pkg.set_old_user_name(NULL);
2301: dummy := fnd_user_pkg.set_old_person_party_id(NULL);
2302: dummy := fnd_user_pkg.set_old_user_guid(NULL);
2303:
2304: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2305: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2306: 'End user_synch');
2307: end if;
2308: exception

Line 2305: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

2301: dummy := fnd_user_pkg.set_old_person_party_id(NULL);
2302: dummy := fnd_user_pkg.set_old_user_guid(NULL);
2303:
2304: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2305: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
2306: 'End user_synch');
2307: end if;
2308: exception
2309: -- Bug 3617474: This NO_DATA_FOUND exception handler was placed in the event

Line 2596: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

2592: if (log_exception = 'Y') then
2593: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
2594: fnd_message.set_token('USER', user_name);
2595: fnd_message.set_token('CUSTID', l_customer_id);
2596: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2597: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2598: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
2599: end if;
2600: app_exception.raise_exception;

Line 2597: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2593: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
2594: fnd_message.set_token('USER', user_name);
2595: fnd_message.set_token('CUSTID', l_customer_id);
2596: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2597: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2598: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
2599: end if;
2600: app_exception.raise_exception;
2601: else

Line 2622: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

2618: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
2619: fnd_message.set_token('USER', user_name);
2620: fnd_message.set_token('PNAME', l_party_name);
2621: fnd_message.set_token('CUSTID', l_customer_id);
2622: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2623: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2624: c_log_head || l_api_name || '.not_in_hz_party_relationships',
2625: FALSE);
2626: end if;

Line 2623: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2619: fnd_message.set_token('USER', user_name);
2620: fnd_message.set_token('PNAME', l_party_name);
2621: fnd_message.set_token('CUSTID', l_customer_id);
2622: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2623: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2624: c_log_head || l_api_name || '.not_in_hz_party_relationships',
2625: FALSE);
2626: end if;
2627: app_exception.raise_exception;

Line 2640: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

2636: fnd_message.set_token('USER', user_name);
2637: fnd_message.set_token('PNAME', l_party_name);
2638: fnd_message.set_token('PARTYID', l_customer_id);
2639: fnd_message.set_token('PARTY_TYPE', l_party_type);
2640: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2641: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2642: c_log_head || l_api_name || '.bad_party_type', FALSE);
2643: end if;
2644: app_exception.raise_exception;

Line 2641: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2637: fnd_message.set_token('PNAME', l_party_name);
2638: fnd_message.set_token('PARTYID', l_customer_id);
2639: fnd_message.set_token('PARTY_TYPE', l_party_type);
2640: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2641: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2642: c_log_head || l_api_name || '.bad_party_type', FALSE);
2643: end if;
2644: app_exception.raise_exception;
2645: else

Line 2673: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

2669: if (log_exception = 'Y') then
2670: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
2671: fnd_message.set_token('USER', user_name);
2672: fnd_message.set_token('EMPID', l_employee_id);
2673: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2674: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2675: c_log_head || l_api_name || '.bad_empid', FALSE);
2676: end if;
2677: app_exception.raise_exception;

Line 2674: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2670: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
2671: fnd_message.set_token('USER', user_name);
2672: fnd_message.set_token('EMPID', l_employee_id);
2673: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2674: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2675: c_log_head || l_api_name || '.bad_empid', FALSE);
2676: end if;
2677: app_exception.raise_exception;
2678: else

Line 2699: if (fnd_log.LEVEL_EXCEPTION >=

2695: when no_data_found then
2696: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
2697: fnd_message.set_token('USER', user_name);
2698: fnd_message.set_token('CUSTID', l_customer_id);
2699: if (fnd_log.LEVEL_EXCEPTION >=
2700: fnd_log.g_current_runtime_level) then
2701: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2702: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
2703: end if;

Line 2700: fnd_log.g_current_runtime_level) then

2696: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
2697: fnd_message.set_token('USER', user_name);
2698: fnd_message.set_token('CUSTID', l_customer_id);
2699: if (fnd_log.LEVEL_EXCEPTION >=
2700: fnd_log.g_current_runtime_level) then
2701: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2702: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
2703: end if;
2704: app_exception.raise_exception;

Line 2701: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2697: fnd_message.set_token('USER', user_name);
2698: fnd_message.set_token('CUSTID', l_customer_id);
2699: if (fnd_log.LEVEL_EXCEPTION >=
2700: fnd_log.g_current_runtime_level) then
2701: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2702: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
2703: end if;
2704: app_exception.raise_exception;
2705: end;

Line 2716: if (fnd_log.LEVEL_EXCEPTION >=

2712: when no_data_found then
2713: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
2714: fnd_message.set_token('USER', user_name);
2715: fnd_message.set_token('EMPID', l_emp_person_party_id);
2716: if (fnd_log.LEVEL_EXCEPTION >=
2717: fnd_log.g_current_runtime_level) then
2718: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2719: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
2720: end if;

Line 2717: fnd_log.g_current_runtime_level) then

2713: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
2714: fnd_message.set_token('USER', user_name);
2715: fnd_message.set_token('EMPID', l_emp_person_party_id);
2716: if (fnd_log.LEVEL_EXCEPTION >=
2717: fnd_log.g_current_runtime_level) then
2718: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2719: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
2720: end if;
2721: app_exception.raise_exception;

Line 2718: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2714: fnd_message.set_token('USER', user_name);
2715: fnd_message.set_token('EMPID', l_emp_person_party_id);
2716: if (fnd_log.LEVEL_EXCEPTION >=
2717: fnd_log.g_current_runtime_level) then
2718: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2719: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
2720: end if;
2721: app_exception.raise_exception;
2722: end;

Line 2730: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

2726: fnd_message.set_token('CUSTID', l_customer_id);
2727: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
2728: fnd_message.set_token('EMPID', l_employee_id);
2729: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
2730: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2731: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2732: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
2733: end if;
2734: app_exception.raise_exception;

Line 2731: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2727: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
2728: fnd_message.set_token('EMPID', l_employee_id);
2729: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
2730: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2731: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2732: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
2733: end if;
2734: app_exception.raise_exception;
2735: else

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

2802: when no_data_found then
2803: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
2804: fnd_message.set_token('USER', user_name);
2805: fnd_message.set_token('PARTYID', l_person_party_id);
2806: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2807: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2808: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
2809: end if;
2810: app_exception.raise_exception;

Line 2807: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2803: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
2804: fnd_message.set_token('USER', user_name);
2805: fnd_message.set_token('PARTYID', l_person_party_id);
2806: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2807: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2808: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
2809: end if;
2810: app_exception.raise_exception;
2811: end;

Line 2817: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

2813: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
2814: fnd_message.set_token('USER', user_name);
2815: fnd_message.set_token('PARTYID', l_person_party_id);
2816: fnd_message.set_token('PARTY_TYPE', l_party_type);
2817: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2818: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2819: c_log_head || l_api_name || '.bad_party_type', FALSE);
2820: end if;
2821: app_exception.raise_exception;

Line 2818: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

2814: fnd_message.set_token('USER', user_name);
2815: fnd_message.set_token('PARTYID', l_person_party_id);
2816: fnd_message.set_token('PARTY_TYPE', l_party_type);
2817: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2818: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2819: c_log_head || l_api_name || '.bad_party_type', FALSE);
2820: end if;
2821: app_exception.raise_exception;
2822: end if;

Line 3150: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3146: -- Move ldap_wrapper synch call to here before we do FND user update
3147: begin
3148: tmpbuf := 'Calling ldap_wrapper_change_user_name to change '||
3149: x_old_user_name|| ' to '|| x_new_user_name;
3150: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3151: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3152: tmpbuf);
3153: end if;
3154: if (l_user_guid is not null) then

Line 3151: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

3147: begin
3148: tmpbuf := 'Calling ldap_wrapper_change_user_name to change '||
3149: x_old_user_name|| ' to '|| x_new_user_name;
3150: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3151: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3152: tmpbuf);
3153: end if;
3154: if (l_user_guid is not null) then
3155: ldap_wrapper_change_user_name(l_user_guid, upper(x_old_user_name),

Line 3179: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3175: -- FND_WEB_SEC.change_password having an autonomous transaction pragma.
3176: -- Password changes failed due to said change. See bug 2426407.
3177: -- handle password encryption with new username
3178: tmpbuf := 'Recrypting '||x_new_user_name|| ' password';
3179: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3180: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3181: tmpbuf);
3182: end if;
3183:

Line 3180: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

3176: -- Password changes failed due to said change. See bug 2426407.
3177: -- handle password encryption with new username
3178: tmpbuf := 'Recrypting '||x_new_user_name|| ' password';
3179: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3180: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3181: tmpbuf);
3182: end if;
3183:
3184: -- Only have to do password reencryption if is not EXTERNAL, INVALID or Hash mode

Line 3191: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3187: ret := fnd_user_pkg.SetReEncryptedPassword(x_new_user_name,newpass,'NEWKEY');
3188: end if;
3189:
3190: tmpbuf := 'updating fnd_user for new user_name '||x_new_user_name;
3191: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3192: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3193: tmpbuf);
3194: end if;
3195:

Line 3192: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

3188: end if;
3189:
3190: tmpbuf := 'updating fnd_user for new user_name '||x_new_user_name;
3191: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3192: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3193: tmpbuf);
3194: end if;
3195:
3196: -- In the below WHERE clause, 'upper' is added, otherwise if the

Line 3210: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3206: fnd_function_security_cache.update_user(l_user_id);
3207:
3208: -- propagate username change to WF and entity mgr
3209: tmpbuf := 'Start calling fnd_user_pkg.user_synch('||x_new_user_name||')';
3210: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3211: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3212: tmpbuf);
3213: end if;
3214: begin

Line 3211: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

3207:
3208: -- propagate username change to WF and entity mgr
3209: tmpbuf := 'Start calling fnd_user_pkg.user_synch('||x_new_user_name||')';
3210: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3211: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3212: tmpbuf);
3213: end if;
3214: begin
3215: fnd_user_pkg.user_synch(upper(x_new_user_name));

Line 3236: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

3232: where grantee_key = x_old_user_name
3233: and grantee_type = 'USER';
3234:
3235: tmpbuf := 'Finished fnd_user_pkg.user_synch';
3236: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3237: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3238: tmpbuf);
3239: end if;
3240:

Line 3237: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

3233: and grantee_type = 'USER';
3234:
3235: tmpbuf := 'Finished fnd_user_pkg.user_synch';
3236: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3237: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
3238: tmpbuf);
3239: end if;
3240:
3241: end;