DBA Data[Home] [Help]

APPS.PON_USER_PROFILE_PKG dependencies on FND_LOG

Line 256: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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;

Line 257: FND_LOG.string( log_level => FND_LOG.level_statement,

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;

Line 624: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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;

Line 625: FND_LOG.string( log_level => FND_LOG.level_statement,

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;

Line 636: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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;

Line 637: FND_LOG.string( log_level => FND_LOG.level_statement,

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;

Line 653: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

Line 654: FND_LOG.string( log_level => FND_LOG.level_statement,

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;

Line 758: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

Line 759: FND_LOG.string( log_level => FND_LOG.level_statement,

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

Line 777: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN

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

Line 778: FND_LOG.string( log_level => FND_LOG.level_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
782: || 'x_dummy_data:' || x_dummy_data