DBA Data[Home] [Help]

APPS.EGO_RULES_UTIL_PUB dependencies on FND_API

Line 23: -- p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

19: -- 'F' if Rule_Result is FALSE
20: -- 'U' Defalut and if there are unexpected errors
21: -- Oracle API Standard Parameters :
22: -- IN : p_api_version IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
24: -- Optional
25: -- p_commit IN VARCHAR2 default FND_API.G_FALSE
26: -- Optional
27: -- p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

Line 25: -- p_commit IN VARCHAR2 default FND_API.G_FALSE

21: -- Oracle API Standard Parameters :
22: -- IN : p_api_version IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
24: -- Optional
25: -- p_commit IN VARCHAR2 default FND_API.G_FALSE
26: -- Optional
27: -- p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
28: -- Optional
29: -- OUT : x_return_status OUT VARCHAR2(1)

Line 27: -- p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

23: -- p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
24: -- Optional
25: -- p_commit IN VARCHAR2 default FND_API.G_FALSE
26: -- Optional
27: -- p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
28: -- Optional
29: -- OUT : x_return_status OUT VARCHAR2(1)
30: -- x_msg_count OUT NUMBER
31: -- x_msg_data OUT VARCHAR2(2000)

Line 51: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

47: ,x_rule_result OUT NOCOPY VARCHAR2
48:
49: --standard parameters
50: ,p_api_version IN NUMBER default 1.0
51: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
52: ,p_commit IN VARCHAR2 default FND_API.G_FALSE
53: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
54: ,x_return_status OUT NOCOPY VARCHAR2
55: ,x_msg_count OUT NOCOPY NUMBER

Line 52: ,p_commit IN VARCHAR2 default FND_API.G_FALSE

48:
49: --standard parameters
50: ,p_api_version IN NUMBER default 1.0
51: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
52: ,p_commit IN VARCHAR2 default FND_API.G_FALSE
53: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
54: ,x_return_status OUT NOCOPY VARCHAR2
55: ,x_msg_count OUT NOCOPY NUMBER
56: ,x_msg_data OUT NOCOPY VARCHAR2

Line 53: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

49: --standard parameters
50: ,p_api_version IN NUMBER default 1.0
51: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
52: ,p_commit IN VARCHAR2 default FND_API.G_FALSE
53: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
54: ,x_return_status OUT NOCOPY VARCHAR2
55: ,x_msg_count OUT NOCOPY NUMBER
56: ,x_msg_data OUT NOCOPY VARCHAR2
57: )

Line 85: IF NOT FND_API.Compatible_API_Call ( l_api_version

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
86: ,p_api_version
87: ,l_api_name
88: ,G_PKG_NAME )
89: THEN

Line 90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

86: ,p_api_version
87: ,l_api_name
88: ,G_PKG_NAME )
89: THEN
90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91: END IF;
92:
93: -- Initialize message list if p_init_msg_list is set to TRUE.
94: l_stmt_num := 5;

Line 95: IF FND_API.to_Boolean( p_init_msg_list ) THEN

91: END IF;
92:
93: -- Initialize message list if p_init_msg_list is set to TRUE.
94: l_stmt_num := 5;
95: IF FND_API.to_Boolean( p_init_msg_list ) THEN
96: FND_MSG_PUB.initialize;
97: END IF;
98:
99: -- Initialize OUT parameters

Line 100: x_return_status := FND_API.G_RET_STS_SUCCESS;

96: FND_MSG_PUB.initialize;
97: END IF;
98:
99: -- Initialize OUT parameters
100: x_return_status := FND_API.G_RET_STS_SUCCESS;
101: x_rule_result := 'U';
102:
103: -- Example of getting entity_keys from p_entity_key_pairs
104: l_index := p_entity_key_pairs.FIRST;

Line 171: IF FND_API.To_Boolean( p_commit ) THEN

167:
168:
169:
170: -- Standard check of p_commit
171: IF FND_API.To_Boolean( p_commit ) THEN
172: COMMIT WORK;
173: END IF;
174:
175: -- Standard call to get message count and if count is 1, get message info.

Line 188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

184: END IF; --for fnd_log
185:
186:
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

Line 195: ||' FND_API.G_EXC_EXCEPTION at l_stmt_num = '

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);
197: END IF; --for fnd_log
198: x_rule_result := 'U';
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
202: ,p_data => x_msg_data);
203: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
214: END EGO_RULES_UTIL_PUB;