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 OE_DEBUG_PUB

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

180: --call macth api
181: --l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');
182:
183: IF PG_DEBUG <> 0 THEN
184: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'CUSTOM_MATCH: ' || l_custom_match_profile, 1);
185: END IF;
186:
187: IF p_Source <> 'GOP' THEN
188: lStmtNum:=30;

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

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;
201:
202: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
203: RAISE fnd_api.g_exc_error;

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

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

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

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

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

277: AND config_item_id is null
278: AND bom_item_type = '1'; --implies item not re-used
279:
280: IF PG_DEBUG <> 0 THEN
281: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'# of top most ato models=>'||sql%rowcount, 5);
282: END IF;
283:
284: lStmtNum:=81;
285: l_last_index := l_ato_line_tbl.count;

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

284: lStmtNum:=81;
285: l_last_index := l_ato_line_tbl.count;
286:
287: IF PG_DEBUG <> 0 THEN
288: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'l_ato_line_tbl.count='||l_last_index, 5);
289: END IF;
290:
291: lStmtNum:=90;
292: FOR i in 1..l_last_index LOOP

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

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);
311: END IF;
312:
313: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

335: END IF; --if model eixsts
336:
337: lStmtNum:= 120;
338: IF PG_DEBUG = 5 THEN
339: Oe_debug_pub.add(' config_item_id --'||
340: ' line_id --'||
341: ' link_to_line_id --'||
342: ' parent_ato_line_id --'||
343: ' gop_parent_ato_line_id --'||

Line 360: oe_debug_pub.add(

356: ' option_specific --'||
357: ' oss_error_code ',5);
358: FOR debug_rec in c_debug
359: LOOP
360: oe_debug_pub.add(
361: debug_rec.config_item_id ||' -- '||
362: debug_rec.line_id ||' -- '||
363: debug_rec.link_to_line_id ||' -- '||
364: debug_rec.parent_ato_line_id ||' -- '||

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

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

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

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

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

404: , p_msg_data => x_msg_data
405: );
406: WHEN OTHERS then
407: IF PG_DEBUG <> 0 THEN
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;

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

406: WHEN OTHERS then
407: IF PG_DEBUG <> 0 THEN
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