eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 55: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

51: PROCEDURE MATCH_CONFIGURED_ITEM
52: (
53: --std parameters
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
56: p_commit IN VARCHAR2 default FND_API.G_FALSE,
57: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,

Line 56: p_commit IN VARCHAR2 default FND_API.G_FALSE,

52: (
53: --std parameters
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
56: p_commit IN VARCHAR2 default FND_API.G_FALSE,
57: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,

Line 57: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

53: --std parameters
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
56: p_commit IN VARCHAR2 default FND_API.G_FALSE,
57: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
61:

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124:
125:
126:
127: BEGIN
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: --Enable this call in future versions
131: lStmtNum:= 10;
132: IF NOT FND_API.Compatible_API_call(l_api_version,

Line 132: IF NOT FND_API.Compatible_API_call(l_api_version,

128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: --Enable this call in future versions
131: lStmtNum:= 10;
132: IF NOT FND_API.Compatible_API_call(l_api_version,
133: p_api_version,
134: l_api_name,
135: G_PKG_NAME)
136: THEN

Line 137: RAISE fnd_api.g_exc_unexpected_error;

133: p_api_version,
134: l_api_name,
135: G_PKG_NAME)
136: THEN
137: RAISE fnd_api.g_exc_unexpected_error;
138: END IF;
139:
140:
141: lStmtNum:=20;

Line 160: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

156: x_msg_count =>X_msg_count,
157: x_msg_data =>X_msg_data
158: );
159:
160: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
161:
162: -- IF PG_DEBUG <> 0 THEN
163: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Insert_into_bcol_gt', 1);
164: -- END IF;

Line 167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

163: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Insert_into_bcol_gt', 1);
164: -- END IF;
165:
166:
167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
168: RAISE fnd_api.g_exc_error;
169: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
170: RAISE fnd_api.g_exc_unexpected_error;
171: END IF;

Line 168: RAISE fnd_api.g_exc_error;

164: -- END IF;
165:
166:
167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
168: RAISE fnd_api.g_exc_error;
169: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
170: RAISE fnd_api.g_exc_unexpected_error;
171: END IF;
172:

Line 169: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

165:
166:
167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
168: RAISE fnd_api.g_exc_error;
169: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
170: RAISE fnd_api.g_exc_unexpected_error;
171: END IF;
172:
173: END IF;

Line 170: RAISE fnd_api.g_exc_unexpected_error;

166:
167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
168: RAISE fnd_api.g_exc_error;
169: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
170: RAISE fnd_api.g_exc_unexpected_error;
171: END IF;
172:
173: END IF;
174:

Line 200: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

196: x_msg_count => x_msg_count,
197: x_msg_data => x_msg_data
198: );
199:
200: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
201: --level1
202: -- IF PG_DEBUG <> 0 THEN
203: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag', 1);
204: -- END IF;

Line 205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 206: RAISE fnd_api.g_exc_error;

202: -- IF PG_DEBUG <> 0 THEN
203: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag', 1);
204: -- END IF;
205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
206: RAISE fnd_api.g_exc_error;
207: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
208: RAISE fnd_api.g_exc_unexpected_error;
209: END IF;
210:

Line 207: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

203: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag', 1);
204: -- END IF;
205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
206: RAISE fnd_api.g_exc_error;
207: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
208: RAISE fnd_api.g_exc_unexpected_error;
209: END IF;
210:
211:

Line 208: RAISE fnd_api.g_exc_unexpected_error;

204: -- END IF;
205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
206: RAISE fnd_api.g_exc_error;
207: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
208: RAISE fnd_api.g_exc_unexpected_error;
209: END IF;
210:
211:
212: lStmtNum:=60;

Line 223: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

219: x_return_status => x_return_status,
220: x_msg_count => X_msg_count,
221: x_msg_data => X_msg_data
222: );
223: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
224: --level1
225: -- IF PG_DEBUG <> 0 THEN
226: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.prepare_bcol_temp_data', 1);
227: -- END IF;

Line 228: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

224: --level1
225: -- IF PG_DEBUG <> 0 THEN
226: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.prepare_bcol_temp_data', 1);
227: -- END IF;
228: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE fnd_api.g_exc_error;
230: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;

Line 229: RAISE fnd_api.g_exc_error;

225: -- IF PG_DEBUG <> 0 THEN
226: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.prepare_bcol_temp_data', 1);
227: -- END IF;
228: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE fnd_api.g_exc_error;
230: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;
233:

Line 230: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

226: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.prepare_bcol_temp_data', 1);
227: -- END IF;
228: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE fnd_api.g_exc_error;
230: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;
233:
234:

Line 231: RAISE fnd_api.g_exc_unexpected_error;

227: -- END IF;
228: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE fnd_api.g_exc_error;
230: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;
233:
234:
235: END IF;--source = not cto/gop

Line 273: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

269: x_msg_count => x_msg_count,
270: x_msg_data => x_msg_data
271: );
272:
273: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
274: --level 3
275: IF PG_DEBUG <> 0 THEN
276: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.perform_match for line_id=>'
277: ||l_ato_line_tbl(i), 3);

Line 281: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

277: ||l_ato_line_tbl(i), 3);
278: END IF;
279:
280:
281: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
282: RAISE fnd_api.g_exc_error;
283: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE fnd_api.g_exc_unexpected_error;
285: END IF;

Line 282: RAISE fnd_api.g_exc_error;

278: END IF;
279:
280:
281: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
282: RAISE fnd_api.g_exc_error;
283: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE fnd_api.g_exc_unexpected_error;
285: END IF;
286:

Line 283: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

279:
280:
281: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
282: RAISE fnd_api.g_exc_error;
283: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE fnd_api.g_exc_unexpected_error;
285: END IF;
286:
287: END LOOP;

Line 284: RAISE fnd_api.g_exc_unexpected_error;

280:
281: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
282: RAISE fnd_api.g_exc_error;
283: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE fnd_api.g_exc_unexpected_error;
285: END IF;
286:
287: END LOOP;
288:

Line 356: WHEN fnd_api.g_exc_error THEN

352:
353:
354:
355: EXCEPTION
356: WHEN fnd_api.g_exc_error THEN
357: IF PG_DEBUG <> 0 THEN
358: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || 'Exception in stmt num: '
359: || to_char(lStmtNum), 1);
360: END IF;

Line 361: x_return_status := FND_API.G_RET_STS_ERROR;

357: IF PG_DEBUG <> 0 THEN
358: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || 'Exception in stmt num: '
359: || to_char(lStmtNum), 1);
360: END IF;
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: -- Get message count and data
363: cto_msg_pub.count_and_get
364: ( p_msg_count => x_msg_count
365: , p_msg_data => x_msg_data

Line 367: WHEN fnd_api.g_exc_unexpected_error THEN

363: cto_msg_pub.count_and_get
364: ( p_msg_count => x_msg_count
365: , p_msg_data => x_msg_data
366: );
367: WHEN fnd_api.g_exc_unexpected_error THEN
368: IF PG_DEBUG <> 0 THEN
369: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || ' Unexpected Exception in stmt num: '
370: || to_char(lStmtNum), 1);
371: END IF;

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

368: IF PG_DEBUG <> 0 THEN
369: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || ' Unexpected Exception in stmt num: '
370: || to_char(lStmtNum), 1);
371: END IF;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: -- Get message count and data
374: cto_msg_pub.count_and_get
375: ( p_msg_count => x_msg_count
376: , p_msg_data => x_msg_data

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || 'Others Exception in stmt num: '
383: || to_char(lStmtNum), 1);
384: oe_debug_pub.add('error '||sqlerrm,1);
385: END IF;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: -- Get message count and data
388: cto_msg_pub.count_and_get
389: ( p_msg_count => x_msg_count
390: , p_msg_data => x_msg_data