DBA Data[Home] [Help]

APPS.EGO_CUSTOM_SECURITY_PUB dependencies on FND_API

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

23: -- 'F' if user has no previlege
24: -- 'U' if there are unexpected errors
25: -- Oracle API Standard Parameters :
26: -- IN : p_api_version IN NUMBER Required
27: -- p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
28: -- Optional
29: -- p_commit IN VARCHAR2 default FND_API.G_FALSE
30: -- Optional
31: -- p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

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

25: -- Oracle API Standard Parameters :
26: -- IN : p_api_version IN NUMBER Required
27: -- p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
28: -- Optional
29: -- p_commit IN VARCHAR2 default FND_API.G_FALSE
30: -- Optional
31: -- p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
32: -- Optional
33: -- OUT : x_return_status OUT VARCHAR2(1)

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

27: -- p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
28: -- Optional
29: -- p_commit IN VARCHAR2 default FND_API.G_FALSE
30: -- Optional
31: -- p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
32: -- Optional
33: -- OUT : x_return_status OUT VARCHAR2(1)
34: -- x_msg_count OUT NUMBER
35: -- x_msg_data OUT VARCHAR2(2000)

Line 49: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

45: ,x_out_params_rec OUT NOCOPY EGO_CUSTOM_SECURITY_PUB.out_params_rec_type
46:
47: --standard parameters
48: ,p_api_version IN NUMBER
49: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
50: ,p_commit IN VARCHAR2 default FND_API.G_FALSE
51: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
52: ,x_return_status OUT NOCOPY VARCHAR2
53: ,x_msg_count OUT NOCOPY NUMBER

Line 50: ,p_commit IN VARCHAR2 default FND_API.G_FALSE

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

Line 51: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

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

Line 75: IF NOT FND_API.Compatible_API_Call ( l_api_version

71: END IF; --for fnd_log
72:
73: -- Standard call to check for call compatibility.
74: l_stmt_num := 3;
75: IF NOT FND_API.Compatible_API_Call ( l_api_version
76: ,p_api_version
77: ,l_api_name
78: ,G_PKG_NAME )
79: THEN

Line 80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

76: ,p_api_version
77: ,l_api_name
78: ,G_PKG_NAME )
79: THEN
80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
81: END IF;
82:
83: -- Initialize message list if p_init_msg_list is set to TRUE.
84: l_stmt_num := 5;

Line 85: IF FND_API.to_Boolean( p_init_msg_list ) THEN

81: END IF;
82:
83: -- Initialize message list if p_init_msg_list is set to TRUE.
84: l_stmt_num := 5;
85: IF FND_API.to_Boolean( p_init_msg_list ) THEN
86: FND_MSG_PUB.initialize;
87: END IF;
88:
89: -- Initialize OUT parameters

Line 90: x_return_status := FND_API.G_RET_STS_SUCCESS;

86: FND_MSG_PUB.initialize;
87: END IF;
88:
89: -- Initialize OUT parameters
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: x_out_params_rec.user_has_function := 'U';
92:
93: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
94: fnd_log.string(FND_LOG.LEVEL_STATEMENT

Line 114: IF FND_API.To_Boolean( p_commit ) THEN

110: -- Customer add their own code here
111:
112:
113: -- Standard check of p_commit
114: IF FND_API.To_Boolean( p_commit ) THEN
115: COMMIT WORK;
116: END IF;
117:
118: -- Standard call to get message count and if count is 1, get message info.

Line 131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

127: END IF; --for fnd_log
128:
129:
130: EXCEPTION
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count
133: ,p_data => x_msg_data);
134: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
135: fnd_log.string(FND_LOG.LEVEL_EXCEPTION

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

134: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
135: fnd_log.string(FND_LOG.LEVEL_EXCEPTION
136: ,G_PKG_NAME||'.'||l_api_name
137: ,G_PKG_NAME||'.'||l_api_name
138: ||' FND_API.G_EXC_EXCEPTION at l_stmt_num = '
139: || l_stmt_num|| ': ' ||sqlerrm);
140: END IF; --for fnd_log
141: x_out_params_rec.user_has_function := 'U';
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

138: ||' FND_API.G_EXC_EXCEPTION at l_stmt_num = '
139: || l_stmt_num|| ': ' ||sqlerrm);
140: END IF; --for fnd_log
141: x_out_params_rec.user_has_function := 'U';
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
143: WHEN OTHERS THEN
144: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count
145: ,p_data => x_msg_data);
146: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

150: ||' Others Exception at l_stmt_num = '
151: || l_stmt_num|| ': ' ||sqlerrm);
152: END IF; --for fnd_log
153: x_out_params_rec.user_has_function := 'U';
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
155: END check_custom_security;
156:
157: END EGO_CUSTOM_SECURITY_PUB;