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.

[Home] [Help]

APPS.CTO_GOP_INTERFACE_PK dependencies on OE_DEBUG_PUB

Line 107: oe_debug_pub.add(' START TIME STAMP : '||to_char(sysdate,'hh:mi:ss')||' ',5);

103:
104:
105: BEGIN
106:
107: oe_debug_pub.add(' START TIME STAMP : '||to_char(sysdate,'hh:mi:ss')||' ',5);
108:
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111:

Line 127: oe_debug_pub.add('match profile =>'||l_match_profile,1);

123:
124:
125: --level1
126: IF PG_DEBUG <> 0 THEN
127: oe_debug_pub.add('match profile =>'||l_match_profile,1);
128: END IF;
129:
130: lStmtNum := 40;
131: l_last_index := p_match_rec_of_tab.line_id.count;

Line 139: oe_debug_pub.add('count before insert into bCOL =>'||l_count,1);

135: select count(*)
136: into l_count
137: from bom_cto_order_lines_gt;
138:
139: oe_debug_pub.add('count before insert into bCOL =>'||l_count,1);
140:
141: END IF;
142:
143:

Line 147: oe_debug_pub.add('line_id=>'||p_match_rec_of_tab.line_id(i)||

143:
144: --debug level 5
145: IF PG_DEBUG = 5 THEN
146: FOR i IN 1..l_last_index LOOP
147: oe_debug_pub.add('line_id=>'||p_match_rec_of_tab.line_id(i)||
148: 'QTY=>'||p_match_rec_of_tab.ordered_quantity(i)||
149: 'ship_frm_org=>'||p_match_rec_of_tab.SHIP_FROM_ORG_ID(i)||
150: 'validation_org=>'||p_match_rec_of_tab.Validation_org(i),5);
151: END LOOP;

Line 153: oe_debug_pub.add('Sql%row count ='||sql%rowcount,3);

149: 'ship_frm_org=>'||p_match_rec_of_tab.SHIP_FROM_ORG_ID(i)||
150: 'validation_org=>'||p_match_rec_of_tab.Validation_org(i),5);
151: END LOOP;
152:
153: oe_debug_pub.add('Sql%row count ='||sql%rowcount,3);
154: END IF;
155:
156:
157:

Line 214: oe_debug_pub.add(sql%rowcount||' rows inserted into bcol_gt',5);

210: p_match_rec_of_tab.validation_org(i)--3503764
211: );
212:
213: IF PG_DEBUG <> 0 THEN
214: oe_debug_pub.add(sql%rowcount||' rows inserted into bcol_gt',5);
215: END IF;
216:
217:
218: lStmtNum:=40;

Line 244: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.prepare_bcol_temp_data',1);

240: );
241: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
242: --level 1
243: -- IF PG_DEBUG <> 0 THEN
244: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.prepare_bcol_temp_data',1);
245: -- END IF;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE fnd_api.g_exc_error;
248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 267: oe_debug_pub.add('qty_per_parent_model is calculated for'||sql%rowcount||' rows in bcol_gt',5);

263: --to filter out ato item order lines
264: WHERE top_model_line_id is not null;
265:
266: IF PG_DEBUG <> 0 THEN
267: oe_debug_pub.add('qty_per_parent_model is calculated for'||sql%rowcount||' rows in bcol_gt',5);
268: END IF;
269:
270: --call reuse configuration API
271: lStmtNum:=70;

Line 275: oe_debug_pub.add('Create_And_Link_Item: ' ||

271: lStmtNum:=70;
272: lReuseProfile := FND_PROFILE.Value('CTO_REUSE_CONFIG'); --Bugfix 6642016
273:
274: IF PG_DEBUG <> 0 THEN
275: oe_debug_pub.add('Create_And_Link_Item: ' ||
276: ' Reuse Configuration profile: ' || to_char(lReuseProfile) , 5);
277: END IF; --Bugfix 6642016
278:
279: if ( nvl(lReuseProfile,1) = 1 ) then ----Bugfix 6642016

Line 289: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.CTO_REUSE_CONFIGURATION',1);

285: X_msg_data =>x_msg_data
286: ) ;
287: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
288: -- IF PG_DEBUG <> 0 THEN
289: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.CTO_REUSE_CONFIGURATION',1);
290: -- END IF;
291: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
292: RAISE fnd_api.g_exc_error;
293: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 316: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);

312: );
313:
314: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
315: IF PG_DEBUG <> 0 THEN
316: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);
317: END IF;
318: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
319: RAISE fnd_api.g_exc_error;
320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 347: oe_debug_pub.add('Updated '||sql%rowcount||' model rows with config_orgs or config_creation attribute',5);

343: WHERE GT.bom_item_type = '1'
344: AND GT.config_item_id is not null;
345:
346: IF PG_DEBUG <> 0 THEN
347: oe_debug_pub.add('Updated '||sql%rowcount||' model rows with config_orgs or config_creation attribute',5);
348: END IF;
349:
350:
351: END IF; -- l_pds_ods =4

Line 368: oe_debug_pub.add('SUCCESS after CTO_OSS_SOURCE_PK.GET_OSS_ORGS_LIST',1);

364:
365: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
366: --level 1
367: -- IF PG_DEBUG <> 0 THEN
368: oe_debug_pub.add('SUCCESS after CTO_OSS_SOURCE_PK.GET_OSS_ORGS_LIST',1);
369: -- END IF;
370: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
371: RAISE fnd_api.g_exc_error;
372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 400: oe_debug_pub.add('Line_id count=>'||p_match_rec_of_tab.line_id.count,5);

396: ORDER BY line_id; --Bugfix 6055375
397:
398:
399: IF PG_DEBUG <> 0 THEN
400: oe_debug_pub.add('Line_id count=>'||p_match_rec_of_tab.line_id.count,5);
401: oe_debug_pub.add('config_id count=>'||p_match_rec_of_tab.config_item_id.count,5);
402: oe_debug_pub.add('oss error code count=>'||p_match_rec_of_tab.oss_error_code.count,5);
403: oe_debug_pub.add('wip supply_type=>'||p_match_rec_of_tab.WIP_SUPPLY_TYPE.count,5);
404:

Line 401: oe_debug_pub.add('config_id count=>'||p_match_rec_of_tab.config_item_id.count,5);

397:
398:
399: IF PG_DEBUG <> 0 THEN
400: oe_debug_pub.add('Line_id count=>'||p_match_rec_of_tab.line_id.count,5);
401: oe_debug_pub.add('config_id count=>'||p_match_rec_of_tab.config_item_id.count,5);
402: oe_debug_pub.add('oss error code count=>'||p_match_rec_of_tab.oss_error_code.count,5);
403: oe_debug_pub.add('wip supply_type=>'||p_match_rec_of_tab.WIP_SUPPLY_TYPE.count,5);
404:
405: --oe_debug_pub.add('Matched item id=>'||p_match_rec_of_tab.config_item_id(1),5);

Line 402: oe_debug_pub.add('oss error code count=>'||p_match_rec_of_tab.oss_error_code.count,5);

398:
399: IF PG_DEBUG <> 0 THEN
400: oe_debug_pub.add('Line_id count=>'||p_match_rec_of_tab.line_id.count,5);
401: oe_debug_pub.add('config_id count=>'||p_match_rec_of_tab.config_item_id.count,5);
402: oe_debug_pub.add('oss error code count=>'||p_match_rec_of_tab.oss_error_code.count,5);
403: oe_debug_pub.add('wip supply_type=>'||p_match_rec_of_tab.WIP_SUPPLY_TYPE.count,5);
404:
405: --oe_debug_pub.add('Matched item id=>'||p_match_rec_of_tab.config_item_id(1),5);
406:

Line 403: oe_debug_pub.add('wip supply_type=>'||p_match_rec_of_tab.WIP_SUPPLY_TYPE.count,5);

399: IF PG_DEBUG <> 0 THEN
400: oe_debug_pub.add('Line_id count=>'||p_match_rec_of_tab.line_id.count,5);
401: oe_debug_pub.add('config_id count=>'||p_match_rec_of_tab.config_item_id.count,5);
402: oe_debug_pub.add('oss error code count=>'||p_match_rec_of_tab.oss_error_code.count,5);
403: oe_debug_pub.add('wip supply_type=>'||p_match_rec_of_tab.WIP_SUPPLY_TYPE.count,5);
404:
405: --oe_debug_pub.add('Matched item id=>'||p_match_rec_of_tab.config_item_id(1),5);
406:
407:

Line 405: --oe_debug_pub.add('Matched item id=>'||p_match_rec_of_tab.config_item_id(1),5);

401: oe_debug_pub.add('config_id count=>'||p_match_rec_of_tab.config_item_id.count,5);
402: oe_debug_pub.add('oss error code count=>'||p_match_rec_of_tab.oss_error_code.count,5);
403: oe_debug_pub.add('wip supply_type=>'||p_match_rec_of_tab.WIP_SUPPLY_TYPE.count,5);
404:
405: --oe_debug_pub.add('Matched item id=>'||p_match_rec_of_tab.config_item_id(1),5);
406:
407:
408: END IF;
409:

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

408: END IF;
409:
410: lStmtNum:=95;
411: IF PG_DEBUG = 5 THEN
412: Oe_debug_pub.add(' config_item_id --'||
413: ' line_id --'||
414: ' link_to_line_id --'||
415: ' parent_ato_line_id --'||
416: ' gop_parent_ato_line_id --'||

Line 434: oe_debug_pub.add(

430: ' option_specific --'||
431: ' oss_error_code ',5);
432: FOR debug_rec in c_debug
433: LOOP
434: oe_debug_pub.add(
435: debug_rec.config_item_id ||' -- '||
436: debug_rec.line_id ||' -- '||
437: debug_rec.link_to_line_id ||' -- '||
438: debug_rec.parent_ato_line_id ||' -- '||

Line 465: oe_debug_pub.add(' END TIME STAMP : '||to_char(sysdate,'hh:mi:ss')||' ',5);

461:
462: --need this when we make bcol_gt a session table
463: DELETE FROM bom_cto_order_lines_gt;
464:
465: oe_debug_pub.add(' END TIME STAMP : '||to_char(sysdate,'hh:mi:ss')||' ',5);
466:
467: EXCEPTION
468: WHEN fnd_api.g_exc_error THEN
469: IF PG_DEBUG <> 0 THEN

Line 470: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Exception in stmt num: '

466:
467: EXCEPTION
468: WHEN fnd_api.g_exc_error THEN
469: IF PG_DEBUG <> 0 THEN
470: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Exception in stmt num: '
471: || to_char(lStmtNum), 1);
472: END IF;
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: -- Get message count and data

Line 481: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || ' Unexpected Exception in stmt num: '

477: , p_msg_data => x_msg_data
478: );
479: WHEN fnd_api.g_exc_unexpected_error THEN
480: IF PG_DEBUG <> 0 THEN
481: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || ' Unexpected Exception in stmt num: '
482: || to_char(lStmtNum), 1);
483: END IF;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
485: -- Get message count and data

Line 492: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Others Exception in stmt num: '

488: , p_msg_data => x_msg_data
489: );
490: WHEN OTHERS then
491: IF PG_DEBUG <> 0 THEN
492: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Others Exception in stmt num: '
493: || to_char(lStmtNum), 1);
494: oe_debug_pub.add('error='||sqlerrm);
495: END IF;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 494: oe_debug_pub.add('error='||sqlerrm);

490: WHEN OTHERS then
491: IF PG_DEBUG <> 0 THEN
492: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Others Exception in stmt num: '
493: || to_char(lStmtNum), 1);
494: oe_debug_pub.add('error='||sqlerrm);
495: END IF;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: -- Get message count and data
498: cto_msg_pub.count_and_get