DBA Data[Home] [Help]

APPS.OKL_COPY_ASSET_PUB dependencies on FND_API

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73: l_renew_ref_yn VARCHAR2(3);
74:
75: BEGIN
76: savepoint copy_asset_lines_pub;
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78: -- Standard call to check for call compatibility.
79: IF NOT (FND_API.Compatible_API_Call (l_api_version,
80: p_api_version,
81: l_api_name,

Line 79: IF NOT (FND_API.Compatible_API_Call (l_api_version,

75: BEGIN
76: savepoint copy_asset_lines_pub;
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78: -- Standard call to check for call compatibility.
79: IF NOT (FND_API.Compatible_API_Call (l_api_version,
80: p_api_version,
81: l_api_name,
82: G_PKG_NAME)) THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: IF NOT (FND_API.Compatible_API_Call (l_api_version,
80: p_api_version,
81: l_api_name,
82: G_PKG_NAME)) THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
87: FND_MSG_PUB.initialize;

Line 86: IF (FND_API.to_Boolean( p_init_msg_list )) THEN

82: G_PKG_NAME)) THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89: l_from_cle_id := p_from_cle_id;
90: l_to_cle_id := p_to_cle_id;

Line 121: IF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN

117: p_copy_line_party_yn => p_copy_line_party_yn,
118: p_renew_ref_yn => p_renew_ref_yn,
119: p_trans_type => p_trans_type,
120: x_cle_id => x_cle_id);
121: IF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN
122: RAISE FND_API.G_EXC_ERROR;
123: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;

Line 122: RAISE FND_API.G_EXC_ERROR;

118: p_renew_ref_yn => p_renew_ref_yn,
119: p_trans_type => p_trans_type,
120: x_cle_id => x_cle_id);
121: IF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN
122: RAISE FND_API.G_EXC_ERROR;
123: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126: -- Verticle industry post- processing section

Line 123: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

119: p_trans_type => p_trans_type,
120: x_cle_id => x_cle_id);
121: IF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN
122: RAISE FND_API.G_EXC_ERROR;
123: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126: -- Verticle industry post- processing section
127: -- Customer post processing section

Line 124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

120: x_cle_id => x_cle_id);
121: IF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN
122: RAISE FND_API.G_EXC_ERROR;
123: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126: -- Verticle industry post- processing section
127: -- Customer post processing section
128: EXCEPTION

Line 129: When FND_API.G_EXC_ERROR then

125: END IF;
126: -- Verticle industry post- processing section
127: -- Customer post processing section
128: EXCEPTION
129: When FND_API.G_EXC_ERROR then
130: ROLLBACK TO copy_asset_lines_pub;
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
133: p_data => x_msg_data);

Line 131: x_return_status := FND_API.G_RET_STS_ERROR;

127: -- Customer post processing section
128: EXCEPTION
129: When FND_API.G_EXC_ERROR then
130: ROLLBACK TO copy_asset_lines_pub;
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
133: p_data => x_msg_data);
134: When FND_API.G_EXC_UNEXPECTED_ERROR then
135: ROLLBACK TO copy_asset_lines_pub;

Line 134: When FND_API.G_EXC_UNEXPECTED_ERROR then

130: ROLLBACK TO copy_asset_lines_pub;
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
133: p_data => x_msg_data);
134: When FND_API.G_EXC_UNEXPECTED_ERROR then
135: ROLLBACK TO copy_asset_lines_pub;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
138: p_data => x_msg_data);

Line 136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

132: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
133: p_data => x_msg_data);
134: When FND_API.G_EXC_UNEXPECTED_ERROR then
135: ROLLBACK TO copy_asset_lines_pub;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
138: p_data => x_msg_data);
139: When OTHERS then
140: ROLLBACK TO copy_asset_lines_pub;

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

137: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
138: p_data => x_msg_data);
139: When OTHERS then
140: ROLLBACK TO copy_asset_lines_pub;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_COPY_ASSET_PUB');
143: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
144: p_count => x_msg_count,
145: p_data => x_msg_data);

Line 143: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

139: When OTHERS then
140: ROLLBACK TO copy_asset_lines_pub;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_COPY_ASSET_PUB');
143: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
144: p_count => x_msg_count,
145: p_data => x_msg_data);
146:
147: END copy_asset_lines;

Line 172: x_return_status := FND_API.G_RET_STS_SUCCESS;

168: l_api_name CONSTANT VARCHAR2(30) := 'COPY_ASSET_LINES';
169: l_api_version CONSTANT NUMBER := 1;
170: i NUMBER := 0;
171: BEGIN
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173: IF p_from_cle_id_tbl.COUNT > 0 THEN
174: i := p_from_cle_id_tbl.FIRST;
175: LOOP
176: copy_asset_lines(p_api_version => p_api_version,

Line 195: When FND_API.G_EXC_ERROR then

191: i := p_from_cle_id_tbl.NEXT(i);
192: END LOOP;
193: END IF;
194: EXCEPTION
195: When FND_API.G_EXC_ERROR then
196: ROLLBACK TO copy_asset_lines_pub;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
199: p_data => x_msg_data);

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193: END IF;
194: EXCEPTION
195: When FND_API.G_EXC_ERROR then
196: ROLLBACK TO copy_asset_lines_pub;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
199: p_data => x_msg_data);
200: When FND_API.G_EXC_UNEXPECTED_ERROR then
201: ROLLBACK TO copy_asset_lines_pub;

Line 200: When FND_API.G_EXC_UNEXPECTED_ERROR then

196: ROLLBACK TO copy_asset_lines_pub;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
199: p_data => x_msg_data);
200: When FND_API.G_EXC_UNEXPECTED_ERROR then
201: ROLLBACK TO copy_asset_lines_pub;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
204: p_data => x_msg_data);

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
199: p_data => x_msg_data);
200: When FND_API.G_EXC_UNEXPECTED_ERROR then
201: ROLLBACK TO copy_asset_lines_pub;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
204: p_data => x_msg_data);
205: When OTHERS then
206: ROLLBACK TO copy_asset_lines_pub;

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

203: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
204: p_data => x_msg_data);
205: When OTHERS then
206: ROLLBACK TO copy_asset_lines_pub;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_COPY_ASSET_PUB');
209: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
210: p_count => x_msg_count,
211: p_data => x_msg_data);

Line 209: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

205: When OTHERS then
206: ROLLBACK TO copy_asset_lines_pub;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_COPY_ASSET_PUB');
209: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
210: p_count => x_msg_count,
211: p_data => x_msg_data);
212:
213: END copy_asset_lines;

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241: l_renew_ref_yn VARCHAR2(3);
242:
243: BEGIN
244: savepoint copy_all_lines_pub;
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: -- Standard call to check for call compatibility.
247: IF NOT (FND_API.Compatible_API_Call (l_api_version,
248: p_api_version,
249: l_api_name,

Line 247: IF NOT (FND_API.Compatible_API_Call (l_api_version,

243: BEGIN
244: savepoint copy_all_lines_pub;
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: -- Standard call to check for call compatibility.
247: IF NOT (FND_API.Compatible_API_Call (l_api_version,
248: p_api_version,
249: l_api_name,
250: G_PKG_NAME)) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

247: IF NOT (FND_API.Compatible_API_Call (l_api_version,
248: p_api_version,
249: l_api_name,
250: G_PKG_NAME)) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;
253: -- Initialize message list if p_init_msg_list is set to TRUE.
254: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
255: FND_MSG_PUB.initialize;

Line 254: IF (FND_API.to_Boolean( p_init_msg_list )) THEN

250: G_PKG_NAME)) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;
253: -- Initialize message list if p_init_msg_list is set to TRUE.
254: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
255: FND_MSG_PUB.initialize;
256: END IF;
257: l_from_cle_id_tbl := p_from_cle_id_tbl;
258: l_to_cle_id := p_to_cle_id;

Line 289: IF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN

285: p_copy_line_party_yn => l_copy_line_party_yn,
286: p_renew_ref_yn => l_renew_ref_yn,
287: p_trans_type => p_trans_type,
288: x_cle_id_tbl => x_cle_id_tbl);
289: IF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN
290: RAISE FND_API.G_EXC_ERROR;
291: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;

Line 290: RAISE FND_API.G_EXC_ERROR;

286: p_renew_ref_yn => l_renew_ref_yn,
287: p_trans_type => p_trans_type,
288: x_cle_id_tbl => x_cle_id_tbl);
289: IF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN
290: RAISE FND_API.G_EXC_ERROR;
291: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;
294: -- Verticle industry post- processing section

Line 291: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

287: p_trans_type => p_trans_type,
288: x_cle_id_tbl => x_cle_id_tbl);
289: IF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN
290: RAISE FND_API.G_EXC_ERROR;
291: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;
294: -- Verticle industry post- processing section
295: -- Customer post processing section

Line 292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

288: x_cle_id_tbl => x_cle_id_tbl);
289: IF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN
290: RAISE FND_API.G_EXC_ERROR;
291: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;
294: -- Verticle industry post- processing section
295: -- Customer post processing section
296: EXCEPTION

Line 297: When FND_API.G_EXC_ERROR then

293: END IF;
294: -- Verticle industry post- processing section
295: -- Customer post processing section
296: EXCEPTION
297: When FND_API.G_EXC_ERROR then
298: ROLLBACK TO copy_all_lines_pub;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
301: p_data => x_msg_data);

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: -- Customer post processing section
296: EXCEPTION
297: When FND_API.G_EXC_ERROR then
298: ROLLBACK TO copy_all_lines_pub;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
301: p_data => x_msg_data);
302: When FND_API.G_EXC_UNEXPECTED_ERROR then
303: ROLLBACK TO copy_all_lines_pub;

Line 302: When FND_API.G_EXC_UNEXPECTED_ERROR then

298: ROLLBACK TO copy_all_lines_pub;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
301: p_data => x_msg_data);
302: When FND_API.G_EXC_UNEXPECTED_ERROR then
303: ROLLBACK TO copy_all_lines_pub;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
306: p_data => x_msg_data);

Line 304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

300: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
301: p_data => x_msg_data);
302: When FND_API.G_EXC_UNEXPECTED_ERROR then
303: ROLLBACK TO copy_all_lines_pub;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
306: p_data => x_msg_data);
307: When OTHERS then
308: ROLLBACK TO copy_all_lines_pub;

Line 309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

305: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
306: p_data => x_msg_data);
307: When OTHERS then
308: ROLLBACK TO copy_all_lines_pub;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_COPY_ASSET_PUB');
311: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
312: p_count => x_msg_count,
313: p_data => x_msg_data);

Line 311: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

307: When OTHERS then
308: ROLLBACK TO copy_all_lines_pub;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_COPY_ASSET_PUB');
311: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
312: p_count => x_msg_count,
313: p_data => x_msg_data);
314:
315: END copy_all_lines;