DBA Data[Home] [Help]

APPS.CTO_CONFIGURED_ITEM_GRP dependencies on FND_API

Line 21: -- Default = FND_API.G_FALSE

17: -- Pre-reqs :1. table BOMC_TO_ORDER_LINES_TEMP/DMF J
18: -- Parameters :
19: -- IN : p_api_version IN NUMBER Required
20: -- p_init_msg_list IN VARCHAR2 Optional
21: -- Default = FND_API.G_FALSE
22: -- p_commit IN VARCHAR2 Optional
23: -- Default = FND_API.G_FALSE
24: -- Action IN VARCHAR2(30)
25: -- Source IN VARCHAR2(30)

Line 23: -- Default = FND_API.G_FALSE

19: -- IN : p_api_version IN NUMBER Required
20: -- p_init_msg_list IN VARCHAR2 Optional
21: -- Default = FND_API.G_FALSE
22: -- p_commit IN VARCHAR2 Optional
23: -- Default = FND_API.G_FALSE
24: -- Action IN VARCHAR2(30)
25: -- Source IN VARCHAR2(30)
26: -- p_cto_match_rec IN OUT CTO_MATCH_REC_TYPE .
27: -- .

Line 59: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

55: --
56: PROCEDURE MATCH_CONFIGURED_ITEM
57: (
58: p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
60: p_commit IN VARCHAR2 default FND_API.G_FALSE,
61: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,

Line 60: p_commit IN VARCHAR2 default FND_API.G_FALSE,

56: PROCEDURE MATCH_CONFIGURED_ITEM
57: (
58: p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
60: p_commit IN VARCHAR2 default FND_API.G_FALSE,
61: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,

Line 61: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

57: (
58: p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
60: p_commit IN VARCHAR2 default FND_API.G_FALSE,
61: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
65: p_Action IN VARCHAR2,

Line 93: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

89: PROCEDURE MATCH_CONFIGURED_ITEM
90: (
91: --std parameters
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
94: p_commit IN VARCHAR2 default FND_API.G_FALSE,
95: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,

Line 94: p_commit IN VARCHAR2 default FND_API.G_FALSE,

90: (
91: --std parameters
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
94: p_commit IN VARCHAR2 default FND_API.G_FALSE,
95: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,

Line 95: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

91: --std parameters
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
94: p_commit IN VARCHAR2 default FND_API.G_FALSE,
95: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: --program parameters

Line 165: x_return_status := FND_API.G_RET_STS_SUCCESS;

161: oss_error_code
162: FROM bom_cto_order_lines_gt;
163:
164: BEGIN
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: --Enable this call in future versions
168: lStmtNum:= 10;
169: IF NOT FND_API.Compatible_API_call(l_api_version,

Line 169: IF NOT FND_API.Compatible_API_call(l_api_version,

165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: --Enable this call in future versions
168: lStmtNum:= 10;
169: IF NOT FND_API.Compatible_API_call(l_api_version,
170: p_api_version,
171: l_api_name,
172: G_PKG_NAME)
173: THEN

Line 174: RAISE fnd_api.g_exc_unexpected_error;

170: p_api_version,
171: l_api_name,
172: G_PKG_NAME)
173: THEN
174: RAISE fnd_api.g_exc_unexpected_error;
175: END IF;
176:
177:
178: lStmtNum:=20;

Line 196: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

192: x_msg_count =>X_msg_count,
193: x_msg_data =>X_msg_data
194: );
195:
196: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
197:
198: -- IF PG_DEBUG <> 0 THEN
199: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Insert_into_bcol_gt', 1);
200: -- END IF;

Line 202: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

198: -- IF PG_DEBUG <> 0 THEN
199: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Insert_into_bcol_gt', 1);
200: -- END IF;
201:
202: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
203: RAISE fnd_api.g_exc_error;
204: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE fnd_api.g_exc_unexpected_error;
206: END IF;

Line 203: RAISE fnd_api.g_exc_error;

199: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Insert_into_bcol_gt', 1);
200: -- END IF;
201:
202: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
203: RAISE fnd_api.g_exc_error;
204: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE fnd_api.g_exc_unexpected_error;
206: END IF;
207:

Line 204: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

200: -- END IF;
201:
202: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
203: RAISE fnd_api.g_exc_error;
204: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE fnd_api.g_exc_unexpected_error;
206: END IF;
207:
208: END IF;

Line 205: RAISE fnd_api.g_exc_unexpected_error;

201:
202: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
203: RAISE fnd_api.g_exc_error;
204: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE fnd_api.g_exc_unexpected_error;
206: END IF;
207:
208: END IF;
209:

Line 233: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

229: x_msg_count => x_msg_count,
230: x_msg_data => x_msg_data
231: );
232:
233: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
234: --level1
235: -- IF PG_DEBUG <> 0 THEN
236: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag', 1);
237: -- END IF;

Line 238: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

234: --level1
235: -- IF PG_DEBUG <> 0 THEN
236: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag', 1);
237: -- END IF;
238: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE fnd_api.g_exc_error;
240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE fnd_api.g_exc_unexpected_error;
242: END IF;

Line 239: RAISE fnd_api.g_exc_error;

235: -- IF PG_DEBUG <> 0 THEN
236: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag', 1);
237: -- END IF;
238: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE fnd_api.g_exc_error;
240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE fnd_api.g_exc_unexpected_error;
242: END IF;
243:

Line 240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

236: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag', 1);
237: -- END IF;
238: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE fnd_api.g_exc_error;
240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE fnd_api.g_exc_unexpected_error;
242: END IF;
243:
244: lStmtNum:=60;

Line 241: RAISE fnd_api.g_exc_unexpected_error;

237: -- END IF;
238: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE fnd_api.g_exc_error;
240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE fnd_api.g_exc_unexpected_error;
242: END IF;
243:
244: lStmtNum:=60;
245: IF p_Source NOT IN ('CTO','GOP') THEN

Line 255: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

251: x_return_status => x_return_status,
252: x_msg_count => X_msg_count,
253: x_msg_data => X_msg_data
254: );
255: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
256: --level1
257: -- IF PG_DEBUG <> 0 THEN
258: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.prepare_bcol_temp_data', 1);
259: -- END IF;

Line 260: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

256: --level1
257: -- IF PG_DEBUG <> 0 THEN
258: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.prepare_bcol_temp_data', 1);
259: -- END IF;
260: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
261: RAISE fnd_api.g_exc_error;
262: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
263: RAISE fnd_api.g_exc_unexpected_error;
264: END IF;

Line 261: RAISE fnd_api.g_exc_error;

257: -- IF PG_DEBUG <> 0 THEN
258: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.prepare_bcol_temp_data', 1);
259: -- END IF;
260: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
261: RAISE fnd_api.g_exc_error;
262: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
263: RAISE fnd_api.g_exc_unexpected_error;
264: END IF;
265:

Line 262: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

258: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.prepare_bcol_temp_data', 1);
259: -- END IF;
260: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
261: RAISE fnd_api.g_exc_error;
262: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
263: RAISE fnd_api.g_exc_unexpected_error;
264: END IF;
265:
266: END IF;--source = not cto/gop

Line 263: RAISE fnd_api.g_exc_unexpected_error;

259: -- END IF;
260: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
261: RAISE fnd_api.g_exc_error;
262: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
263: RAISE fnd_api.g_exc_unexpected_error;
264: END IF;
265:
266: END IF;--source = not cto/gop
267:

Line 306: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

302: -- bug 16352937
303: x_hash_value => x_hash_value
304: );
305:
306: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
307: --level 3
308: IF PG_DEBUG <> 0 THEN
309: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.perform_match for line_id=>'
310: ||l_ato_line_tbl(i), 3);

Line 313: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

309: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.perform_match for line_id=>'
310: ||l_ato_line_tbl(i), 3);
311: END IF;
312:
313: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
314: RAISE fnd_api.g_exc_error;
315: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
316: RAISE fnd_api.g_exc_unexpected_error;
317: END IF;

Line 314: RAISE fnd_api.g_exc_error;

310: ||l_ato_line_tbl(i), 3);
311: END IF;
312:
313: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
314: RAISE fnd_api.g_exc_error;
315: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
316: RAISE fnd_api.g_exc_unexpected_error;
317: END IF;
318:

Line 315: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

311: END IF;
312:
313: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
314: RAISE fnd_api.g_exc_error;
315: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
316: RAISE fnd_api.g_exc_unexpected_error;
317: END IF;
318:
319: END LOOP;

Line 316: RAISE fnd_api.g_exc_unexpected_error;

312:
313: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
314: RAISE fnd_api.g_exc_error;
315: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
316: RAISE fnd_api.g_exc_unexpected_error;
317: END IF;
318:
319: END LOOP;
320:

Line 384: WHEN fnd_api.g_exc_error THEN

380: END LOOP;
381: END IF;--debug
382:
383: EXCEPTION
384: WHEN fnd_api.g_exc_error THEN
385: IF PG_DEBUG <> 0 THEN
386: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || 'Exception in stmt num: '
387: || to_char(lStmtNum), 1);
388: END IF;

Line 389: x_return_status := FND_API.G_RET_STS_ERROR;

385: IF PG_DEBUG <> 0 THEN
386: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || 'Exception in stmt num: '
387: || to_char(lStmtNum), 1);
388: END IF;
389: x_return_status := FND_API.G_RET_STS_ERROR;
390: -- Get message count and data
391: cto_msg_pub.count_and_get
392: ( p_msg_count => x_msg_count
393: , p_msg_data => x_msg_data

Line 395: WHEN fnd_api.g_exc_unexpected_error THEN

391: cto_msg_pub.count_and_get
392: ( p_msg_count => x_msg_count
393: , p_msg_data => x_msg_data
394: );
395: WHEN fnd_api.g_exc_unexpected_error THEN
396: IF PG_DEBUG <> 0 THEN
397: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || ' Unexpected Exception in stmt num: '
398: || to_char(lStmtNum), 1);
399: END IF;

Line 400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

396: IF PG_DEBUG <> 0 THEN
397: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || ' Unexpected Exception in stmt num: '
398: || to_char(lStmtNum), 1);
399: END IF;
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401: -- Get message count and data
402: cto_msg_pub.count_and_get
403: ( p_msg_count => x_msg_count
404: , p_msg_data => x_msg_data

Line 412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

408: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || 'Others Exception in stmt num: '
409: || to_char(lStmtNum), 1);
410: oe_debug_pub.add('error '||sqlerrm,1);
411: END IF;
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: -- Get message count and data
414: cto_msg_pub.count_and_get
415: ( p_msg_count => x_msg_count
416: , p_msg_data => x_msg_data