DBA Data[Home] [Help]

APPS.CTO_CONFIGURED_ITEM_GRP dependencies on OE_DEBUG_PUB

Line 147: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'CUSTOM_MATCH: ' || l_custom_match_profile, 1);

143: --call macth api
144: --l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');
145:
146: IF PG_DEBUG <> 0 THEN
147: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'CUSTOM_MATCH: ' || l_custom_match_profile, 1);
148: END IF;
149:
150:
151: IF p_Source <> 'GOP' THEN

Line 163: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Insert_into_bcol_gt', 1);

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;
165:
166:
167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 203: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag', 1);

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;
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

Line 226: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.prepare_bcol_temp_data', 1);

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;
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

Line 250: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'# of top most ato models=>'||sql%rowcount, 5);

246: AND config_item_id is null
247: AND bom_item_type = '1'; --implies item not re-used
248:
249: IF PG_DEBUG <> 0 THEN
250: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'# of top most ato models=>'||sql%rowcount, 5);
251: END IF;
252:
253: lStmtNum:=81;
254: l_last_index := l_ato_line_tbl.count;

Line 256: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'l_ato_line_tbl.count='||l_last_index, 5);

252:
253: lStmtNum:=81;
254: l_last_index := l_ato_line_tbl.count;
255: IF PG_DEBUG <> 0 THEN
256: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'l_ato_line_tbl.count='||l_last_index, 5);
257: END IF;
258:
259:
260: lStmtNum:=90;

Line 276: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.perform_match for line_id=>'

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);
278: END IF;
279:
280:

Line 308: Oe_debug_pub.add(' config_item_id --'||

304: END IF; --if model eixsts
305:
306: lStmtNum:= 120;
307: IF PG_DEBUG = 5 THEN
308: Oe_debug_pub.add(' config_item_id --'||
309: ' line_id --'||
310: ' link_to_line_id --'||
311: ' parent_ato_line_id --'||
312: ' gop_parent_ato_line_id --'||

Line 329: oe_debug_pub.add(

325: ' option_specific --'||
326: ' oss_error_code ',5);
327: FOR debug_rec in c_debug
328: LOOP
329: oe_debug_pub.add(
330: debug_rec.config_item_id ||' -- '||
331: debug_rec.line_id ||' -- '||
332: debug_rec.link_to_line_id ||' -- '||
333: debug_rec.parent_ato_line_id ||' -- '||

Line 358: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || 'Exception in stmt num: '

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;
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: -- Get message count and data

Line 369: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || ' Unexpected Exception in stmt num: '

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;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: -- Get message count and data

Line 382: oe_debug_pub.add('MATCH_CONFIGURED_ITEM: ' || 'Others Exception in stmt num: '

378: WHEN OTHERS then
379:
380: IF PG_DEBUG <> 0 THEN
381:
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;

Line 384: oe_debug_pub.add('error '||sqlerrm,1);

380: IF PG_DEBUG <> 0 THEN
381:
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