252: AND nvl(posv.USER_END_DATE,sysdate) >= sysdate;
253: EXCEPTION --}
254: WHEN TOO_MANY_ROWS THEN --{
255: IF (g_fnd_debug = 'Y') THEN
256: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
257: FND_LOG.string( log_level => FND_LOG.level_statement,
258: module => g_module_prefix || 'retrieve_user_data',
259: message => '501: Multiple records for person ');
260: END IF;
253: EXCEPTION --}
254: WHEN TOO_MANY_ROWS THEN --{
255: IF (g_fnd_debug = 'Y') THEN
256: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
257: FND_LOG.string( log_level => FND_LOG.level_statement,
258: module => g_module_prefix || 'retrieve_user_data',
259: message => '501: Multiple records for person ');
260: END IF;
261: END IF;
620: from fnd_user
621: where user_name = p_username;
622:
623: IF (g_fnd_debug = 'Y') THEN
624: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
625: FND_LOG.string( log_level => FND_LOG.level_statement,
626: module => g_module_prefix || 'retrieve_user_data',
627: message => '10:' || p_username || ':' || l_user_id);
628: END IF;
621: where user_name = p_username;
622:
623: IF (g_fnd_debug = 'Y') THEN
624: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
625: FND_LOG.string( log_level => FND_LOG.level_statement,
626: module => g_module_prefix || 'retrieve_user_data',
627: message => '10:' || p_username || ':' || l_user_id);
628: END IF;
629: END IF;
632: -- check if a row exists in HR
633: l_enterprise_id := pos_party_management_pkg.get_emp_or_ctgt_wrkr_pty_id(l_user_id);
634:
635: IF (g_fnd_debug = 'Y') THEN
636: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
637: FND_LOG.string( log_level => FND_LOG.level_statement,
638: module => g_module_prefix || 'retrieve_user_data',
639: message => '20:l_enterprise_id:' || l_enterprise_id);
640: END IF;
633: l_enterprise_id := pos_party_management_pkg.get_emp_or_ctgt_wrkr_pty_id(l_user_id);
634:
635: IF (g_fnd_debug = 'Y') THEN
636: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
637: FND_LOG.string( log_level => FND_LOG.level_statement,
638: module => g_module_prefix || 'retrieve_user_data',
639: message => '20:l_enterprise_id:' || l_enterprise_id);
640: END IF;
641: END IF;
649: x_row_in_hr := 'N';
650: END;
651:
652: IF (g_fnd_debug = 'Y') THEN
653: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
654: FND_LOG.string( log_level => FND_LOG.level_statement,
655: module => g_module_prefix || 'retrieve_user_data',
656: message => 'l_user_id:' || l_user_id || ':l_enterprise_id:' ||
657: l_enterprise_id || ':x_row_in_hr:' || x_row_in_hr || ':p_username:' || p_username);
650: END;
651:
652: IF (g_fnd_debug = 'Y') THEN
653: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
654: FND_LOG.string( log_level => FND_LOG.level_statement,
655: module => g_module_prefix || 'retrieve_user_data',
656: message => 'l_user_id:' || l_user_id || ':l_enterprise_id:' ||
657: l_enterprise_id || ':x_row_in_hr:' || x_row_in_hr || ':p_username:' || p_username);
658: END IF;
754: end if; --} end if of x_vendor_relationship
755: end if; --} x_row_in_hr
756:
757: IF (g_fnd_debug = 'Y') THEN
758: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
759: FND_LOG.string( log_level => FND_LOG.level_statement,
760: module => g_module_prefix || 'retrieve_user_data',
761: message => 'x_status:' || x_status
762: || 'x_exception_msg:' || x_exception_msg
755: end if; --} x_row_in_hr
756:
757: IF (g_fnd_debug = 'Y') THEN
758: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
759: FND_LOG.string( log_level => FND_LOG.level_statement,
760: module => g_module_prefix || 'retrieve_user_data',
761: message => 'x_status:' || x_status
762: || 'x_exception_msg:' || x_exception_msg
763: || 'x_dummy_data:' || x_dummy_data
773: EXCEPTION
774: WHEN OTHERS THEN
775: --dbms_output.put_line('Other failure -- '||x_exception_msg);
776: IF (g_fnd_debug = 'Y') THEN
777: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
778: FND_LOG.string( log_level => FND_LOG.level_exception,
779: module => g_module_prefix || 'retrieve_user_data',
780: message => 'x_status:' || x_status
781: || 'x_exception_msg:' || x_exception_msg
774: WHEN OTHERS THEN
775: --dbms_output.put_line('Other failure -- '||x_exception_msg);
776: IF (g_fnd_debug = 'Y') THEN
777: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
778: FND_LOG.string( log_level => FND_LOG.level_exception,
779: module => g_module_prefix || 'retrieve_user_data',
780: message => 'x_status:' || x_status
781: || 'x_exception_msg:' || x_exception_msg
782: || 'x_dummy_data:' || x_dummy_data