DBA Data[Home] [Help]

APPS.OKC_TERMS_TMPL_APPROVAL_GRP dependencies on FND_API

Line 19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
28: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 69: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

65:
66: */
67: PROCEDURE start_approval (
68: p_api_version IN Number,
69: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
70: p_commit IN Varchar2 default FND_API.G_FALSE,
71: p_template_id IN Number,
72: p_object_version_number IN Number default NULL,
73: x_return_status OUT NOCOPY Varchar2,

Line 70: p_commit IN Varchar2 default FND_API.G_FALSE,

66: */
67: PROCEDURE start_approval (
68: p_api_version IN Number,
69: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
70: p_commit IN Varchar2 default FND_API.G_FALSE,
71: p_template_id IN Number,
72: p_object_version_number IN Number default NULL,
73: x_return_status OUT NOCOPY Varchar2,
74: x_msg_data OUT NOCOPY Varchar2,

Line 120: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

116: -- Standard Start of API savepoint
117: SAVEPOINT g_start_approval_GRP;
118:
119: -- Standard call to check for call compatibility.
120: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

117: SAVEPOINT g_start_approval_GRP;
118:
119: -- Standard call to check for call compatibility.
120: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124: -- Initialize message list if p_init_msg_list is set to TRUE.
125: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 125: IF FND_API.to_Boolean( p_init_msg_list ) THEN

121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124: -- Initialize message list if p_init_msg_list is set to TRUE.
125: IF FND_API.to_Boolean( p_init_msg_list ) THEN
126: FND_MSG_PUB.initialize;
127: END IF;
128:
129: -- Initialize API return status to success

Line 130: x_return_status := FND_API.G_RET_STS_SUCCESS;

126: FND_MSG_PUB.initialize;
127: END IF;
128:
129: -- Initialize API return status to success
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132:
133: /*IF (l_debug = 'Y') THEN
134: okc_debug.log('200: opening tmpl_csr', 2);

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

157: END IF;
158: CLOSE tmpl_csr;
159:
160: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:

Line 163: RAISE FND_API.G_EXC_ERROR;

159:
160: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166: OKC_TERMS_TMPL_APPROVAL_PVT.start_approval(
167: p_api_version => p_api_version,

Line 168: p_init_msg_list => FND_API.G_FALSE,

164: END IF;
165:
166: OKC_TERMS_TMPL_APPROVAL_PVT.start_approval(
167: p_api_version => p_api_version,
168: p_init_msg_list => FND_API.G_FALSE,
169: p_commit => FND_API.G_FALSE,
170: p_template_id => p_template_id,
171: p_object_version_number => l_tmpl_rec.object_version_number,
172: x_return_status => x_return_status,

Line 169: p_commit => FND_API.G_FALSE,

165:
166: OKC_TERMS_TMPL_APPROVAL_PVT.start_approval(
167: p_api_version => p_api_version,
168: p_init_msg_list => FND_API.G_FALSE,
169: p_commit => FND_API.G_FALSE,
170: p_template_id => p_template_id,
171: p_object_version_number => l_tmpl_rec.object_version_number,
172: x_return_status => x_return_status,
173: x_msg_data => x_msg_data,

Line 180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

176: p_validation_level => p_validation_level,
177: p_check_for_drafts => p_check_for_drafts,
178: x_sequence_id => x_sequence_id);
179: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
182: RAISE FND_API.G_EXC_ERROR;
183: END IF;
184:

Line 182: RAISE FND_API.G_EXC_ERROR;

178: x_sequence_id => x_sequence_id);
179: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
182: RAISE FND_API.G_EXC_ERROR;
183: END IF;
184:
185: IF FND_API.To_Boolean( p_commit ) THEN
186: COMMIT WORK;

Line 185: IF FND_API.To_Boolean( p_commit ) THEN

181: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
182: RAISE FND_API.G_EXC_ERROR;
183: END IF;
184:
185: IF FND_API.To_Boolean( p_commit ) THEN
186: COMMIT WORK;
187: END IF;
188:
189: -- Standard call to get message count and if count is 1, get message info.

Line 203: WHEN FND_API.G_EXC_ERROR THEN

199: END IF;
200:
201: EXCEPTION
202:
203: WHEN FND_API.G_EXC_ERROR THEN
204: /*IF (l_debug = 'Y') THEN
205: okc_debug.log('800: Leaving start_approval: OKC_API.G_EXCEPTION_ERROR Exception', 2);
206: END IF;*/
207:

Line 217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

213: ROLLBACK TO g_start_approval_grp;
214: x_return_status := G_RET_STS_ERROR ;
215: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
216:
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: /*IF (l_debug = 'Y') THEN
219: okc_debug.log('900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
220: END IF;*/
221: