DBA Data[Home] [Help]

APPS.EGO_RULES_UTIL_PUB dependencies on FND_LOG

Line 74: -- Leave starting point of this procedure at fnd_log_message

70: l_item_supp_id VARCHAR2(150);
71: l_item_supp_site_id VARCHAR2(150);
72:
73: BEGIN
74: -- Leave starting point of this procedure at fnd_log_message
75: l_stmt_num := 0;
76: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
77: fnd_log.string(FND_LOG.LEVEL_PROCEDURE
78: ,G_PKG_NAME||'.'||l_api_name

Line 76: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

72:
73: BEGIN
74: -- Leave starting point of this procedure at fnd_log_message
75: l_stmt_num := 0;
76: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
77: fnd_log.string(FND_LOG.LEVEL_PROCEDURE
78: ,G_PKG_NAME||'.'||l_api_name
79: ,'Enter '||G_PKG_NAME||'.'||l_api_name||' '
80: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss') );

Line 77: fnd_log.string(FND_LOG.LEVEL_PROCEDURE

73: BEGIN
74: -- Leave starting point of this procedure at fnd_log_message
75: l_stmt_num := 0;
76: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
77: fnd_log.string(FND_LOG.LEVEL_PROCEDURE
78: ,G_PKG_NAME||'.'||l_api_name
79: ,'Enter '||G_PKG_NAME||'.'||l_api_name||' '
80: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss') );
81: END IF; --for fnd_log

Line 81: END IF; --for fnd_log

77: fnd_log.string(FND_LOG.LEVEL_PROCEDURE
78: ,G_PKG_NAME||'.'||l_api_name
79: ,'Enter '||G_PKG_NAME||'.'||l_api_name||' '
80: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss') );
81: END IF; --for fnd_log
82:
83: -- Standard call to check for call compatibility.
84: l_stmt_num := 3;
85: IF NOT FND_API.Compatible_API_Call ( l_api_version

Line 144: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

140: END LOOP;
141: END IF;
142:
143: -- Example of leaving log messages
144: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
145: fnd_log.string(FND_LOG.LEVEL_STATEMENT
146: ,G_PKG_NAME||'.'||l_api_name
147: ,' p_rule_id=>'|| p_rule_id ||','
148: ||' p_data_level_name=>'|| p_data_level_name ||','

Line 145: fnd_log.string(FND_LOG.LEVEL_STATEMENT

141: END IF;
142:
143: -- Example of leaving log messages
144: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
145: fnd_log.string(FND_LOG.LEVEL_STATEMENT
146: ,G_PKG_NAME||'.'||l_api_name
147: ,' p_rule_id=>'|| p_rule_id ||','
148: ||' p_data_level_name=>'|| p_data_level_name ||','
149: ||' p_entity_type_name=>'|| p_entity_type_name ||','

Line 156: END IF; --fnd_log

152: ||' l_org_id=>'|| l_org_id ||','
153: ||' l_rev_id=>'|| l_rev_id ||','
154: ||' l_item_supp_id=>'|| l_item_supp_id ||','
155: ||' l_item_sup_site_id=>'|| l_item_supp_site_id );
156: END IF; --fnd_log
157:
158:
159:
160:

Line 179: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

175: -- Standard call to get message count and if count is 1, get message info.
176: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count
177: ,p_data => x_msg_data);
178:
179: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
180: fnd_log.string(FND_LOG.LEVEL_PROCEDURE
181: ,G_PKG_NAME||'.'||l_api_name
182: ,'Exit '||G_PKG_NAME||'.'||l_api_name||' '
183: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));

Line 180: fnd_log.string(FND_LOG.LEVEL_PROCEDURE

176: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count
177: ,p_data => x_msg_data);
178:
179: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
180: fnd_log.string(FND_LOG.LEVEL_PROCEDURE
181: ,G_PKG_NAME||'.'||l_api_name
182: ,'Exit '||G_PKG_NAME||'.'||l_api_name||' '
183: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
184: END IF; --for fnd_log

Line 184: END IF; --for fnd_log

180: fnd_log.string(FND_LOG.LEVEL_PROCEDURE
181: ,G_PKG_NAME||'.'||l_api_name
182: ,'Exit '||G_PKG_NAME||'.'||l_api_name||' '
183: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
184: END IF; --for fnd_log
185:
186:
187: EXCEPTION
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 191: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

187: EXCEPTION
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count
190: ,p_data => x_msg_data);
191: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
192: fnd_log.string(FND_LOG.LEVEL_EXCEPTION
193: ,G_PKG_NAME||'.'||l_api_name
194: ,G_PKG_NAME||'.'||l_api_name
195: ||' FND_API.G_EXC_EXCEPTION at l_stmt_num = '

Line 192: fnd_log.string(FND_LOG.LEVEL_EXCEPTION

188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count
190: ,p_data => x_msg_data);
191: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
192: fnd_log.string(FND_LOG.LEVEL_EXCEPTION
193: ,G_PKG_NAME||'.'||l_api_name
194: ,G_PKG_NAME||'.'||l_api_name
195: ||' FND_API.G_EXC_EXCEPTION at l_stmt_num = '
196: || l_stmt_num|| ': ' ||sqlerrm);

Line 197: END IF; --for fnd_log

193: ,G_PKG_NAME||'.'||l_api_name
194: ,G_PKG_NAME||'.'||l_api_name
195: ||' FND_API.G_EXC_EXCEPTION at l_stmt_num = '
196: || l_stmt_num|| ': ' ||sqlerrm);
197: END IF; --for fnd_log
198: x_rule_result := 'U';
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200: WHEN OTHERS THEN
201: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count

Line 203: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200: WHEN OTHERS THEN
201: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count
202: ,p_data => x_msg_data);
203: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
204: fnd_log.string(FND_LOG.LEVEL_EXCEPTION
205: ,G_PKG_NAME||'.'||l_api_name
206: ,G_PKG_NAME||'.'||l_api_name
207: ||' Others Exception at l_stmt_num = '

Line 204: fnd_log.string(FND_LOG.LEVEL_EXCEPTION

200: WHEN OTHERS THEN
201: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count
202: ,p_data => x_msg_data);
203: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
204: fnd_log.string(FND_LOG.LEVEL_EXCEPTION
205: ,G_PKG_NAME||'.'||l_api_name
206: ,G_PKG_NAME||'.'||l_api_name
207: ||' Others Exception at l_stmt_num = '
208: || l_stmt_num|| ': ' ||sqlerrm);

Line 209: END IF; --for fnd_log

205: ,G_PKG_NAME||'.'||l_api_name
206: ,G_PKG_NAME||'.'||l_api_name
207: ||' Others Exception at l_stmt_num = '
208: || l_stmt_num|| ': ' ||sqlerrm);
209: END IF; --for fnd_log
210: x_rule_result := 'U';
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: END Get_Run_Rule_Result;
213: