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_GOP_INTERFACE_PK dependencies on OE_DEBUG_PUB

Line 119: oe_debug_pub.add('Inside API call_match_item',5);

115: l_return_status VARCHAR2(2000);
116: l_msg_count NUMBER;
117: l_msg_data VARCHAR2(2000);
118: BEGIN
119: oe_debug_pub.add('Inside API call_match_item',5);
120:
121: --
122: -- bug 16352937
123: --

Line 134: oe_debug_pub.add('Inside API call_match_item l_hash_value :'||l_hash_value ,5);

130: p_Source => p_Source ,
131: p_cto_match_rec => p_cto_match_rec,
132: x_hash_value => l_hash_value);
133:
134: oe_debug_pub.add('Inside API call_match_item l_hash_value :'||l_hash_value ,5);
135:
136: --
137: -- bug 16311347
138: -- using the release lock API to release the lock instead of COMMIT

Line 146: oe_debug_pub.add('Inside API call_match_item After release lock' ,5);

142: x_msg_count => l_msg_count,
143: x_msg_data => l_msg_data,
144: p_hash_value => l_hash_value);
145:
146: oe_debug_pub.add('Inside API call_match_item After release lock' ,5);
147: --COMMIT;
148: END;
149:
150: PROCEDURE CTO_GOP_WRAPPER_API (

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

199:
200:
201: BEGIN
202:
203: oe_debug_pub.add(' START TIME STAMP : '||to_char(sysdate,'hh:mi:ss')||' ',5);
204:
205: x_return_status := FND_API.G_RET_STS_SUCCESS;
206:
207:

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

219:
220:
221: --level1
222: IF PG_DEBUG <> 0 THEN
223: oe_debug_pub.add('match profile =>'||l_match_profile,1);
224: END IF;
225:
226: lStmtNum := 40;
227: l_last_index := p_match_rec_of_tab.line_id.count;

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

231: select count(*)
232: into l_count
233: from bom_cto_order_lines_gt;
234:
235: oe_debug_pub.add('count before insert into bCOL =>'||l_count,1);
236:
237: END IF;
238:
239:

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

239:
240: --debug level 5
241: IF PG_DEBUG = 5 THEN
242: FOR i IN 1..l_last_index LOOP
243: oe_debug_pub.add('line_id=>'||p_match_rec_of_tab.line_id(i)||
244: 'QTY=>'||p_match_rec_of_tab.ordered_quantity(i)||
245: 'ship_frm_org=>'||p_match_rec_of_tab.SHIP_FROM_ORG_ID(i)||
246: 'validation_org=>'||p_match_rec_of_tab.Validation_org(i),5);
247: END LOOP;

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

245: 'ship_frm_org=>'||p_match_rec_of_tab.SHIP_FROM_ORG_ID(i)||
246: 'validation_org=>'||p_match_rec_of_tab.Validation_org(i),5);
247: END LOOP;
248:
249: oe_debug_pub.add('Sql%row count ='||sql%rowcount,3);
250: END IF;
251:
252:
253:

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

306: p_match_rec_of_tab.validation_org(i)--3503764
307: );
308:
309: IF PG_DEBUG <> 0 THEN
310: oe_debug_pub.add(sql%rowcount||' rows inserted into bcol_gt',5);
311: END IF;
312:
313:
314: lStmtNum:=40;

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

336: );
337: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
338: --level 1
339: -- IF PG_DEBUG <> 0 THEN
340: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.prepare_bcol_temp_data',1);
341: -- END IF;
342: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE fnd_api.g_exc_error;
344: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

371: WHERE top_model_line_id IS NOT NULL;
372: --End bugfix 9452600
373:
374: IF PG_DEBUG <> 0 THEN
375: oe_debug_pub.add('qty_per_parent_model is calculated for'||sql%rowcount||' rows in bcol_gt',5);
376: END IF;
377:
378: --call reuse configuration API
379: lStmtNum:=70;

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

379: lStmtNum:=70;
380: lReuseProfile := FND_PROFILE.Value('CTO_REUSE_CONFIG'); --Bugfix 6642016
381:
382: IF PG_DEBUG <> 0 THEN
383: oe_debug_pub.add('Create_And_Link_Item: ' ||
384: ' Reuse Configuration profile: ' || to_char(lReuseProfile) , 5);
385: END IF; --Bugfix 6642016
386:
387: if ( nvl(lReuseProfile,1) = 1 ) then ----Bugfix 6642016

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

393: X_msg_data =>x_msg_data
394: ) ;
395: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
396: -- IF PG_DEBUG <> 0 THEN
397: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.CTO_REUSE_CONFIGURATION',1);
398: -- END IF;
399: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
400: RAISE fnd_api.g_exc_error;
401: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 411: oe_debug_pub.add('Calling call_match_item API ',1);

407:
408: lStmtNum:=30;
409:
410: IF PG_DEBUG <> 0 THEN
411: oe_debug_pub.add('Calling call_match_item API ',1);
412: END IF;
413:
414: --
415: -- bug 14328455

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

428: p_cto_match_rec => p_match_rec_of_tab);
429:
430: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
431: IF PG_DEBUG <> 0 THEN
432: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);
433: END IF;
434: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
435: RAISE fnd_api.g_exc_error;
436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

459: WHERE GT.bom_item_type = '1'
460: AND GT.config_item_id is not null;
461:
462: IF PG_DEBUG <> 0 THEN
463: oe_debug_pub.add('Updated '||sql%rowcount||' model rows with config_orgs or config_creation attribute',5);
464: END IF;
465:
466:
467: END IF; -- l_pds_ods =4

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

480:
481: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
482: --level 1
483: -- IF PG_DEBUG <> 0 THEN
484: oe_debug_pub.add('SUCCESS after CTO_OSS_SOURCE_PK.GET_OSS_ORGS_LIST',1);
485: -- END IF;
486: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
487: RAISE fnd_api.g_exc_error;
488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 517: oe_debug_pub.add('CTOGOPIB: Before cleaning p_match_rec_of_tab');

513: ORDER BY line_id; --Bugfix 6055375*/
514:
515: --Bugfix 8636348: The collection needs to be cleaned up before repopulating
516: IF PG_DEBUG <> 0 THEN
517: oe_debug_pub.add('CTOGOPIB: Before cleaning p_match_rec_of_tab');
518: END IF;
519:
520: init_rec(p_match_rec_of_tab);
521:

Line 523: oe_debug_pub.add('CTOGOPIB: After cleaning p_match_rec_of_tab');

519:
520: init_rec(p_match_rec_of_tab);
521:
522: IF PG_DEBUG <> 0 THEN
523: oe_debug_pub.add('CTOGOPIB: After cleaning p_match_rec_of_tab');
524: END IF;
525:
526: select
527: CONFIG_ITEM_ID,

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

570: --End Bugfix 8636348
571:
572:
573: IF PG_DEBUG <> 0 THEN
574: oe_debug_pub.add('Line_id count=>'||p_match_rec_of_tab.line_id.count,5);
575: oe_debug_pub.add('config_id count=>'||p_match_rec_of_tab.config_item_id.count,5);
576: oe_debug_pub.add('oss error code count=>'||p_match_rec_of_tab.oss_error_code.count,5);
577: oe_debug_pub.add('wip supply_type=>'||p_match_rec_of_tab.WIP_SUPPLY_TYPE.count,5);
578:

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

571:
572:
573: IF PG_DEBUG <> 0 THEN
574: oe_debug_pub.add('Line_id count=>'||p_match_rec_of_tab.line_id.count,5);
575: oe_debug_pub.add('config_id count=>'||p_match_rec_of_tab.config_item_id.count,5);
576: oe_debug_pub.add('oss error code count=>'||p_match_rec_of_tab.oss_error_code.count,5);
577: oe_debug_pub.add('wip supply_type=>'||p_match_rec_of_tab.WIP_SUPPLY_TYPE.count,5);
578:
579: --oe_debug_pub.add('Matched item id=>'||p_match_rec_of_tab.config_item_id(1),5);

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

572:
573: IF PG_DEBUG <> 0 THEN
574: oe_debug_pub.add('Line_id count=>'||p_match_rec_of_tab.line_id.count,5);
575: oe_debug_pub.add('config_id count=>'||p_match_rec_of_tab.config_item_id.count,5);
576: oe_debug_pub.add('oss error code count=>'||p_match_rec_of_tab.oss_error_code.count,5);
577: oe_debug_pub.add('wip supply_type=>'||p_match_rec_of_tab.WIP_SUPPLY_TYPE.count,5);
578:
579: --oe_debug_pub.add('Matched item id=>'||p_match_rec_of_tab.config_item_id(1),5);
580: END IF;

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

573: IF PG_DEBUG <> 0 THEN
574: oe_debug_pub.add('Line_id count=>'||p_match_rec_of_tab.line_id.count,5);
575: oe_debug_pub.add('config_id count=>'||p_match_rec_of_tab.config_item_id.count,5);
576: oe_debug_pub.add('oss error code count=>'||p_match_rec_of_tab.oss_error_code.count,5);
577: oe_debug_pub.add('wip supply_type=>'||p_match_rec_of_tab.WIP_SUPPLY_TYPE.count,5);
578:
579: --oe_debug_pub.add('Matched item id=>'||p_match_rec_of_tab.config_item_id(1),5);
580: END IF;
581:

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

575: oe_debug_pub.add('config_id count=>'||p_match_rec_of_tab.config_item_id.count,5);
576: oe_debug_pub.add('oss error code count=>'||p_match_rec_of_tab.oss_error_code.count,5);
577: oe_debug_pub.add('wip supply_type=>'||p_match_rec_of_tab.WIP_SUPPLY_TYPE.count,5);
578:
579: --oe_debug_pub.add('Matched item id=>'||p_match_rec_of_tab.config_item_id(1),5);
580: END IF;
581:
582: lStmtNum:=95;
583: IF PG_DEBUG = 5 THEN

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

580: END IF;
581:
582: lStmtNum:=95;
583: IF PG_DEBUG = 5 THEN
584: Oe_debug_pub.add(' config_item_id --'||
585: ' line_id --'||
586: ' link_to_line_id --'||
587: ' parent_ato_line_id --'||
588: ' gop_parent_ato_line_id --'||

Line 606: oe_debug_pub.add(

602: ' option_specific --'||
603: ' oss_error_code ',5);
604: FOR debug_rec in c_debug
605: LOOP
606: oe_debug_pub.add(
607: debug_rec.config_item_id ||' -- '||
608: debug_rec.line_id ||' -- '||
609: debug_rec.link_to_line_id ||' -- '||
610: debug_rec.parent_ato_line_id ||' -- '||

Line 639: oe_debug_pub.add('CTOGOPIB: After deleting records from bcol_gt');

635: DELETE FROM bom_cto_order_lines_gt;
636:
637: --Bugfix 8636348: Adding this portion for debug purposes
638: IF PG_DEBUG <> 0 THEN
639: oe_debug_pub.add('CTOGOPIB: After deleting records from bcol_gt');
640: END IF;
641:
642: l_last_index := p_match_rec_of_tab.line_id.count;
643:

Line 645: oe_debug_pub.add('-----------------------------------------------------------');

641:
642: l_last_index := p_match_rec_of_tab.line_id.count;
643:
644: IF PG_DEBUG = 5 THEN
645: oe_debug_pub.add('-----------------------------------------------------------');
646: oe_debug_pub.add('CTOGOPIB: Printing values in the record we pass to GOP');
647: FOR i IN 1..l_last_index LOOP
648: oe_debug_pub.add('line_id=>'|| p_match_rec_of_tab.line_id(i)||
649: ' LINK_TO_LINE_ID=>'|| p_match_rec_of_tab.LINK_TO_LINE_ID(i)||

Line 646: oe_debug_pub.add('CTOGOPIB: Printing values in the record we pass to GOP');

642: l_last_index := p_match_rec_of_tab.line_id.count;
643:
644: IF PG_DEBUG = 5 THEN
645: oe_debug_pub.add('-----------------------------------------------------------');
646: oe_debug_pub.add('CTOGOPIB: Printing values in the record we pass to GOP');
647: FOR i IN 1..l_last_index LOOP
648: oe_debug_pub.add('line_id=>'|| p_match_rec_of_tab.line_id(i)||
649: ' LINK_TO_LINE_ID=>'|| p_match_rec_of_tab.LINK_TO_LINE_ID(i)||
650: ' ATO_LINE_ID=>'|| p_match_rec_of_tab.ATO_LINE_ID(i)||

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

644: IF PG_DEBUG = 5 THEN
645: oe_debug_pub.add('-----------------------------------------------------------');
646: oe_debug_pub.add('CTOGOPIB: Printing values in the record we pass to GOP');
647: FOR i IN 1..l_last_index LOOP
648: oe_debug_pub.add('line_id=>'|| p_match_rec_of_tab.line_id(i)||
649: ' LINK_TO_LINE_ID=>'|| p_match_rec_of_tab.LINK_TO_LINE_ID(i)||
650: ' ATO_LINE_ID=>'|| p_match_rec_of_tab.ATO_LINE_ID(i)||
651: ' TOP_MODEL_LINE_ID=>'|| p_match_rec_of_tab.TOP_MODEL_LINE_ID(i)||
652: ' PARENT_ATO_LINE_ID=>'|| p_match_rec_of_tab.PARENT_ATO_LINE_ID(i)||

Line 662: oe_debug_pub.add('-----------------------------------------------------------');

658: ' validation_org=>'|| p_match_rec_of_tab.Validation_org(i)||
659: ' PERFORM_MATCH=>'|| p_match_rec_of_tab.PERFORM_MATCH(i)||
660: ' PLAN_LEVEL=>'|| p_match_rec_of_tab.PLAN_LEVEL(i), 5);
661: END LOOP;
662: oe_debug_pub.add('-----------------------------------------------------------');
663: oe_debug_pub.add('CTOGOPIB: After printing values.');
664: END IF;
665: --End debugging. Bugfix 8636348.
666:

Line 663: oe_debug_pub.add('CTOGOPIB: After printing values.');

659: ' PERFORM_MATCH=>'|| p_match_rec_of_tab.PERFORM_MATCH(i)||
660: ' PLAN_LEVEL=>'|| p_match_rec_of_tab.PLAN_LEVEL(i), 5);
661: END LOOP;
662: oe_debug_pub.add('-----------------------------------------------------------');
663: oe_debug_pub.add('CTOGOPIB: After printing values.');
664: END IF;
665: --End debugging. Bugfix 8636348.
666:
667: oe_debug_pub.add(' END TIME STAMP : '||to_char(sysdate,'hh:mi:ss')||' ',5);

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

663: oe_debug_pub.add('CTOGOPIB: After printing values.');
664: END IF;
665: --End debugging. Bugfix 8636348.
666:
667: oe_debug_pub.add(' END TIME STAMP : '||to_char(sysdate,'hh:mi:ss')||' ',5);
668:
669: EXCEPTION
670: WHEN fnd_api.g_exc_error THEN
671: IF PG_DEBUG <> 0 THEN

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

668:
669: EXCEPTION
670: WHEN fnd_api.g_exc_error THEN
671: IF PG_DEBUG <> 0 THEN
672: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Exception in stmt num: '
673: || to_char(lStmtNum), 1);
674: END IF;
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: -- Get message count and data

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

679: , p_msg_data => x_msg_data
680: );
681: WHEN fnd_api.g_exc_unexpected_error THEN
682: IF PG_DEBUG <> 0 THEN
683: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || ' Unexpected Exception in stmt num: '
684: || to_char(lStmtNum), 1);
685: END IF;
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
687: -- Get message count and data

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

690: , p_msg_data => x_msg_data
691: );
692: WHEN OTHERS then
693: IF PG_DEBUG <> 0 THEN
694: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Others Exception in stmt num: '
695: || to_char(lStmtNum), 1);
696: oe_debug_pub.add('error='||sqlerrm);
697: END IF;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

692: WHEN OTHERS then
693: IF PG_DEBUG <> 0 THEN
694: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Others Exception in stmt num: '
695: || to_char(lStmtNum), 1);
696: oe_debug_pub.add('error='||sqlerrm);
697: END IF;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: -- Get message count and data
700: cto_msg_pub.count_and_get