DBA Data[Home] [Help]

APPS.FUN_SEQ_UTILS dependencies on FND_LOG

Line 58: IF (p_level >= fnd_log.g_current_runtime_level) THEN

54: p_level IN NUMBER,
55: p_module IN VARCHAR2,
56: p_message_text IN VARCHAR2) IS
57: BEGIN
58: IF (p_level >= fnd_log.g_current_runtime_level) THEN
59: fnd_log.string(log_level => p_level,
60: module => p_module,
61: message => p_message_text);
62: END IF;

Line 59: fnd_log.string(log_level => p_level,

55: p_module IN VARCHAR2,
56: p_message_text IN VARCHAR2) IS
57: BEGIN
58: IF (p_level >= fnd_log.g_current_runtime_level) THEN
59: fnd_log.string(log_level => p_level,
60: module => p_module,
61: message => p_message_text);
62: END IF;
63: END Log;

Line 78: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

74: PROCEDURE Log_Statement(
75: p_module IN VARCHAR2,
76: p_message_text IN VARCHAR2) IS
77: BEGIN
78: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
79: log(p_level => fnd_log.level_statement,
80: p_module => p_module,
81: p_message_text => p_message_text);
82: END IF;

Line 79: log(p_level => fnd_log.level_statement,

75: p_module IN VARCHAR2,
76: p_message_text IN VARCHAR2) IS
77: BEGIN
78: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
79: log(p_level => fnd_log.level_statement,
80: p_module => p_module,
81: p_message_text => p_message_text);
82: END IF;
83: END Log_Statement;

Line 98: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

94: PROCEDURE Log_Procedure(
95: p_module IN VARCHAR2,
96: p_message_text IN VARCHAR2) IS
97: BEGIN
98: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
99: log(p_level => fnd_log.level_procedure,
100: p_module => p_module,
101: p_message_text => p_message_text);
102: END IF;

Line 99: log(p_level => fnd_log.level_procedure,

95: p_module IN VARCHAR2,
96: p_message_text IN VARCHAR2) IS
97: BEGIN
98: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
99: log(p_level => fnd_log.level_procedure,
100: p_module => p_module,
101: p_message_text => p_message_text);
102: END IF;
103: END Log_Procedure;

Line 118: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level) THEN

114: PROCEDURE Log_Event(
115: p_module IN VARCHAR2,
116: p_message_text IN VARCHAR2) IS
117: BEGIN
118: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level) THEN
119: log(p_level => fnd_log.level_event,
120: p_module => p_module,
121: p_message_text => p_message_text);
122: END IF;

Line 119: log(p_level => fnd_log.level_event,

115: p_module IN VARCHAR2,
116: p_message_text IN VARCHAR2) IS
117: BEGIN
118: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level) THEN
119: log(p_level => fnd_log.level_event,
120: p_module => p_module,
121: p_message_text => p_message_text);
122: END IF;
123: END Log_Event;

Line 138: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

134: PROCEDURE Log_Exception(
135: p_module IN VARCHAR2,
136: p_message_text IN VARCHAR2) IS
137: BEGIN
138: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
139: log(p_level => fnd_log.level_exception,
140: p_module => p_module,
141: p_message_text => p_message_text);
142: END IF;

Line 139: log(p_level => fnd_log.level_exception,

135: p_module IN VARCHAR2,
136: p_message_text IN VARCHAR2) IS
137: BEGIN
138: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
139: log(p_level => fnd_log.level_exception,
140: p_module => p_module,
141: p_message_text => p_message_text);
142: END IF;
143: END Log_Exception;

Line 157: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

153: PROCEDURE Log_Error(
154: p_module IN VARCHAR2,
155: p_message_text IN VARCHAR2) IS
156: BEGIN
157: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
158: log(p_level => fnd_log.level_error,
159: p_module => p_module,
160: p_message_text => p_message_text);
161: END IF;

Line 158: log(p_level => fnd_log.level_error,

154: p_module IN VARCHAR2,
155: p_message_text IN VARCHAR2) IS
156: BEGIN
157: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
158: log(p_level => fnd_log.level_error,
159: p_module => p_module,
160: p_message_text => p_message_text);
161: END IF;
162: END Log_Error;

Line 177: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

173: PROCEDURE Log_Unexpected(
174: p_module IN VARCHAR2,
175: p_message_text IN VARCHAR2) IS
176: BEGIN
177: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
178: log(p_level => fnd_log.level_unexpected,
179: p_module => p_module,
180: p_message_text => p_message_text);
181: END IF;

Line 178: log(p_level => fnd_log.level_unexpected,

174: p_module IN VARCHAR2,
175: p_message_text IN VARCHAR2) IS
176: BEGIN
177: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
178: log(p_level => fnd_log.level_unexpected,
179: p_module => p_module,
180: p_message_text => p_message_text);
181: END IF;
182: END Log_Unexpected;

Line 903: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

899: WHEN OTHERS THEN
900: --
901: -- Logging
902: --
903: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
904: fnd_log.string(
905: log_level => fnd_log.level_exception,
906: module => l_module,
907: message =>

Line 904: fnd_log.string(

900: --
901: -- Logging
902: --
903: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
904: fnd_log.string(
905: log_level => fnd_log.level_exception,
906: module => l_module,
907: message =>
908: 'p_seq_header_id: ' || p_seq_header_id || ', ' ||

Line 905: log_level => fnd_log.level_exception,

901: -- Logging
902: --
903: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
904: fnd_log.string(
905: log_level => fnd_log.level_exception,
906: module => l_module,
907: message =>
908: 'p_seq_header_id: ' || p_seq_header_id || ', ' ||
909: 'p_header_name: ' || p_header_name || ', ' ||

Line 987: IF fnd_log.level_error>= fnd_log.g_current_runtime_level THEN

983: --
984: -- If the system cannot lock the table, display the message to the user.
985: --
986: IF SQLCODE = -54 THEN
987: IF fnd_log.level_error>= fnd_log.g_current_runtime_level THEN
988:
989: fnd_message.set_name('FUN','FUN_SEQ_IC_TRX_LOCKED');
990: fnd_log.message(
991: log_level => fnd_log.level_error,

Line 990: fnd_log.message(

986: IF SQLCODE = -54 THEN
987: IF fnd_log.level_error>= fnd_log.g_current_runtime_level THEN
988:
989: fnd_message.set_name('FUN','FUN_SEQ_IC_TRX_LOCKED');
990: fnd_log.message(
991: log_level => fnd_log.level_error,
992: module => l_module,
993: pop_message => FALSE); -- Displayed to the user layer
994: fnd_message.raise_error;

Line 991: log_level => fnd_log.level_error,

987: IF fnd_log.level_error>= fnd_log.g_current_runtime_level THEN
988:
989: fnd_message.set_name('FUN','FUN_SEQ_IC_TRX_LOCKED');
990: fnd_log.message(
991: log_level => fnd_log.level_error,
992: module => l_module,
993: pop_message => FALSE); -- Displayed to the user layer
994: fnd_message.raise_error;
995: END IF;

Line 1000: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

996: --
997: -- Logging
998: --
999: ELSE
1000: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1001: fnd_log.string(
1002: log_level => fnd_log.level_exception,
1003: module => l_module,
1004: message => 'SQLERRM: ' || SQLERRM);

Line 1001: fnd_log.string(

997: -- Logging
998: --
999: ELSE
1000: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1001: fnd_log.string(
1002: log_level => fnd_log.level_exception,
1003: module => l_module,
1004: message => 'SQLERRM: ' || SQLERRM);
1005: END IF;

Line 1002: log_level => fnd_log.level_exception,

998: --
999: ELSE
1000: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1001: fnd_log.string(
1002: log_level => fnd_log.level_exception,
1003: module => l_module,
1004: message => 'SQLERRM: ' || SQLERRM);
1005: END IF;
1006: END IF;

Line 1058: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1054: WHEN OTHERS THEN
1055: --
1056: -- Logging
1057: --
1058: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1059: fnd_log.string(
1060: log_level => fnd_log.level_exception,
1061: module => l_module,
1062: message => 'p_seq_version_id: ' || p_seq_version_id || ', ' ||

Line 1059: fnd_log.string(

1055: --
1056: -- Logging
1057: --
1058: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1059: fnd_log.string(
1060: log_level => fnd_log.level_exception,
1061: module => l_module,
1062: message => 'p_seq_version_id: ' || p_seq_version_id || ', ' ||
1063: 'p_initial_value: ' || p_initial_value || ', ' ||

Line 1060: log_level => fnd_log.level_exception,

1056: -- Logging
1057: --
1058: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1059: fnd_log.string(
1060: log_level => fnd_log.level_exception,
1061: module => l_module,
1062: message => 'p_seq_version_id: ' || p_seq_version_id || ', ' ||
1063: 'p_initial_value: ' || p_initial_value || ', ' ||
1064: 'SQLERRM: ' || SQLERRM);

Line 1379: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1375: WHEN OTHERS THEN
1376: --
1377: -- Logging
1378: --
1379: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1380: fnd_log.string(
1381: log_level => fnd_log.level_exception,
1382: module => l_module,
1383: message => 'p_seq_version_id: ' || p_seq_version_id || ', ' ||

Line 1380: fnd_log.string(

1376: --
1377: -- Logging
1378: --
1379: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1380: fnd_log.string(
1381: log_level => fnd_log.level_exception,
1382: module => l_module,
1383: message => 'p_seq_version_id: ' || p_seq_version_id || ', ' ||
1384: 'SQLERRM: ' || SQLERRM);

Line 1381: log_level => fnd_log.level_exception,

1377: -- Logging
1378: --
1379: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1380: fnd_log.string(
1381: log_level => fnd_log.level_exception,
1382: module => l_module,
1383: message => 'p_seq_version_id: ' || p_seq_version_id || ', ' ||
1384: 'SQLERRM: ' || SQLERRM);
1385: END IF;

Line 1435: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1431: WHEN OTHERS THEN
1432: --
1433: -- Logging
1434: --
1435: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1436: fnd_log.string(
1437: log_level => fnd_log.level_exception,
1438: module => l_module,
1439: message => 'p_header_name: ' || p_header_name || ', ' ||

Line 1436: fnd_log.string(

1432: --
1433: -- Logging
1434: --
1435: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1436: fnd_log.string(
1437: log_level => fnd_log.level_exception,
1438: module => l_module,
1439: message => 'p_header_name: ' || p_header_name || ', ' ||
1440: 'SQLERRM: ' || SQLERRM);

Line 1437: log_level => fnd_log.level_exception,

1433: -- Logging
1434: --
1435: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1436: fnd_log.string(
1437: log_level => fnd_log.level_exception,
1438: module => l_module,
1439: message => 'p_header_name: ' || p_header_name || ', ' ||
1440: 'SQLERRM: ' || SQLERRM);
1441: END IF;