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

Line 120: oe_debug_pub.add ('link_config: ' || 'Inside CTO_MANUAL_LINK_CONFIG.link_config..',2);

116: Validate model line.
117: +----------------------*/
118: l_stmt_num := 100;
119: IF PG_DEBUG <> 0 THEN
120: oe_debug_pub.add ('link_config: ' || 'Inside CTO_MANUAL_LINK_CONFIG.link_config..',2);
121:
122: oe_debug_pub.add ('link_config: ' || 'Calling CTO_WORKFLOW.validate_line..',2);
123: END IF;
124:

Line 122: oe_debug_pub.add ('link_config: ' || 'Calling CTO_WORKFLOW.validate_line..',2);

118: l_stmt_num := 100;
119: IF PG_DEBUG <> 0 THEN
120: oe_debug_pub.add ('link_config: ' || 'Inside CTO_MANUAL_LINK_CONFIG.link_config..',2);
121:
122: oe_debug_pub.add ('link_config: ' || 'Calling CTO_WORKFLOW.validate_line..',2);
123: END IF;
124:
125: if (CTO_WORKFLOW.validate_line(p_model_line_id) = FALSE) then
126:

Line 130: oe_debug_pub.add('link_config: ' || 'Model Line not valid.',1);

126:
127: cto_msg_pub.cto_message('BOM','CTO_LINE_STATUS_NOT_ELIGIBLE');
128: x_message_name := 'CTO_LINE_STATUS_NOT_ELIGIBLE';
129: IF PG_DEBUG <> 0 THEN
130: oe_debug_pub.add('link_config: ' || 'Model Line not valid.',1);
131: END IF;
132: return FALSE;
133:
134: end if;

Line 146: oe_debug_pub.add ('link_config: ' || 'Calling CTO_MATCH_AND_RESERVE.config_line_exists..',2);

142: /*------------------------------------------+
143: Link only if config line does not exist.
144: +-----------------------------------------*/
145: IF PG_DEBUG <> 0 THEN
146: oe_debug_pub.add ('link_config: ' || 'Calling CTO_MATCH_AND_RESERVE.config_line_exists..',2);
147: END IF;
148: l_stmt_num := 110;
149: if (CTO_MATCH_AND_RESERVE.config_line_exists(
150: p_model_line_id => p_model_line_id,

Line 156: oe_debug_pub.add('link_config: ' || 'Config Line Exists.', 1);

152: x_config_item_id => l_config_id) = TRUE)
153: then
154:
155: IF PG_DEBUG <> 0 THEN
156: oe_debug_pub.add('link_config: ' || 'Config Line Exists.', 1);
157: END IF;
158: cto_msg_pub.cto_message('BOM','CTO_CONFIG_ITEM_EXISTS');
159: x_message_name := 'CTO_CONFIG_ITEM_EXISTS';
160: return FALSE;

Line 171: oe_debug_pub.add('link_config: ' || 'APS version::'|| v_aps_version , 2);

167:
168:
169: v_aps_version := msc_atp_global.get_aps_version ;
170:
171: oe_debug_pub.add('link_config: ' || 'APS version::'|| v_aps_version , 2);
172:
173:
174:
175:

Line 182: oe_debug_pub.add('link_config: ' || 'Configuration Line does not exist.', 2);

178: /*------------------------------------+
179: Check Workflow status of model line.
180: +-------------------------------------*/
181: IF PG_DEBUG <> 0 THEN
182: oe_debug_pub.add('link_config: ' || 'Configuration Line does not exist.', 2);
183: END IF;
184: l_stmt_num := 120;
185: CTO_WORKFLOW_API_PK.get_activity_status(
186: itemtype => 'OEOL',

Line 202: oe_debug_pub.add

198: Model line workflow status
199: is not eligible for Link.
200: +-----------------------------*/
201: IF PG_DEBUG <> 0 THEN
202: oe_debug_pub.add
203: ('link_config: ' || 'Model Workflow Status not Eligible for Link.', 1);
204: END IF;
205:
206: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_WORKFLOW_STATUS');

Line 213: oe_debug_pub.add('link_config: ' || 'Workflow Status is: ' || l_active_activity, 2);

209:
210: end if;
211:
212: IF PG_DEBUG <> 0 THEN
213: oe_debug_pub.add('link_config: ' || 'Workflow Status is: ' || l_active_activity, 2);
214: END IF;
215:
216: -- Link the config item.
217: l_stmt_num := 130;

Line 219: oe_debug_pub.add('link_config: ' || 'Config Item: ' || to_char(p_config_item_id),2);

215:
216: -- Link the config item.
217: l_stmt_num := 130;
218: IF PG_DEBUG <> 0 THEN
219: oe_debug_pub.add('link_config: ' || 'Config Item: ' || to_char(p_config_item_id),2);
220: END IF;
221:
222:
223:

Line 227: oe_debug_pub.add('link_config: ' || '************ workflow need not necessarily be at CREATE_CONFIG_ITEM_ELIGIBLE as APS patchset J is installed '

223:
224: else
225:
226:
227: oe_debug_pub.add('link_config: ' || '************ workflow need not necessarily be at CREATE_CONFIG_ITEM_ELIGIBLE as APS patchset J is installed '
228: || ' and order is scheduled ' ,2);
229:
230:
231: end if ;

Line 244: oe_debug_pub.add ('link_config: ' || 'Failed in link_item function', 1);

240: xMsgData => x_message_data);
241:
242: IF (l_status <> 1) THEN
243: IF PG_DEBUG <> 0 THEN
244: oe_debug_pub.add ('link_config: ' || 'Failed in link_item function', 1);
245: END IF;
246: raise PROCESS_ERROR;
247: END IF;
248: IF PG_DEBUG <> 0 THEN

Line 249: oe_debug_pub.add ('link_config: ' || 'Success in link_item function', 1);

245: END IF;
246: raise PROCESS_ERROR;
247: END IF;
248: IF PG_DEBUG <> 0 THEN
249: oe_debug_pub.add ('link_config: ' || 'Success in link_item function', 1);
250: END IF;
251:
252:
253:

Line 265: oe_debug_pub.add('link_config: ' || 'Failed in call to start_model_workflow',1);

261: +-------------------------------*/
262: IF (CTO_WORKFLOW_API_PK.start_model_workflow(p_model_line_id) = FALSE)
263: THEN
264: IF PG_DEBUG <> 0 THEN
265: oe_debug_pub.add('link_config: ' || 'Failed in call to start_model_workflow',1);
266: END IF;
267: raise PROCESS_ERROR;
268: END IF;
269:

Line 271: oe_debug_pub.add ('link_config: ' || 'Getting config line id.', 2);

267: raise PROCESS_ERROR;
268: END IF;
269:
270: IF PG_DEBUG <> 0 THEN
271: oe_debug_pub.add ('link_config: ' || 'Getting config line id.', 2);
272: END IF;
273:
274:
275:

Line 280: oe_debug_pub.add ('link_config: ' || 'did not call cto_workflow_api_pk.start_model_workflow as l_active_activity

276:
277: else
278:
279:
280: oe_debug_pub.add ('link_config: ' || 'did not call cto_workflow_api_pk.start_model_workflow as l_active_activity
281: is not at CREATE_CONFIG_ITEM_ELIGIBLE.', 2);
282:
283: end if ;
284:

Line 294: oe_debug_pub.add ('link_config: ' || 'Config line id is ' || to_char(l_config_line_id), 2);

290: where ato_line_id = p_model_line_id
291: and item_type_code = 'CONFIG';
292:
293: IF PG_DEBUG <> 0 THEN
294: oe_debug_pub.add ('link_config: ' || 'Config line id is ' || to_char(l_config_line_id), 2);
295:
296: oe_debug_pub.add('link_config: ' || 'header ID: ' || to_char(l_header_id), 2);
297: END IF;
298:

Line 296: oe_debug_pub.add('link_config: ' || 'header ID: ' || to_char(l_header_id), 2);

292:
293: IF PG_DEBUG <> 0 THEN
294: oe_debug_pub.add ('link_config: ' || 'Config line id is ' || to_char(l_config_line_id), 2);
295:
296: oe_debug_pub.add('link_config: ' || 'header ID: ' || to_char(l_header_id), 2);
297: END IF;
298:
299:
300: l_stmt_num := 160;

Line 303: oe_debug_pub.add('link_config: ' || 'Calling display wf status API ',2);

299:
300: l_stmt_num := 160;
301: IF PG_DEBUG <> 0 THEN
302:
303: oe_debug_pub.add('link_config: ' || 'Calling display wf status API ',2);
304: END IF;
305:
306:
307: --bugfix 3755608 changed the call to display_wf_status from OM api

Line 311: oe_debug_pub.add('link_config: ' || 'Return from display_wf status'||l_return_status,1);

307: --bugfix 3755608 changed the call to display_wf_status from OM api
308: l_return_status := CTO_WORKFLOW_API_PK.display_wf_status( p_order_line_id => l_config_line_id );
309:
310: IF PG_DEBUG <> 0 THEN
311: oe_debug_pub.add('link_config: ' || 'Return from display_wf status'||l_return_status,1);
312: END IF;
313:
314: --Begin Bugfix 6398466
315:

Line 338: oe_debug_pub.add('link_config: ' || 'Delinked config did not have child configs. Updating only the top config.', 1);

334:
335: IF old_config_dtls.config_item_id.Count = 0 THEN
336:
337: IF PG_DEBUG <> 0 THEN
338: oe_debug_pub.add('link_config: ' || 'Delinked config did not have child configs. Updating only the top config.', 1);
339: END IF;
340:
341: l_stmt_num := 180;
342:

Line 349: oe_debug_pub.add('link_config: ' || 'Looking if bom for '|| p_config_item_id || 'exists in shipping org ' || old_config_dtls.ship_from_org_id(1), 1);

345: WHERE line_id = p_model_line_id;
346:
347: ELSE
348: IF PG_DEBUG <> 0 THEN
349: oe_debug_pub.add('link_config: ' || 'Looking if bom for '|| p_config_item_id || 'exists in shipping org ' || old_config_dtls.ship_from_org_id(1), 1);
350: END IF;
351:
352: BEGIN
353: l_stmt_num := 190;

Line 369: oe_debug_pub.add('link_config: ' || 'BOM not found in ship org ' || old_config_dtls.ship_from_org_id(1), 1);

365: END;
366:
367: IF l_bom_exists = 0 THEN
368: IF PG_DEBUG <> 0 THEN
369: oe_debug_pub.add('link_config: ' || 'BOM not found in ship org ' || old_config_dtls.ship_from_org_id(1), 1);
370: oe_debug_pub.add('link_config: ' || 'Going to call query sourcing orgs', 1);
371: END IF;
372:
373: IF PG_DEBUG <> 0 THEN

Line 370: oe_debug_pub.add('link_config: ' || 'Going to call query sourcing orgs', 1);

366:
367: IF l_bom_exists = 0 THEN
368: IF PG_DEBUG <> 0 THEN
369: oe_debug_pub.add('link_config: ' || 'BOM not found in ship org ' || old_config_dtls.ship_from_org_id(1), 1);
370: oe_debug_pub.add('link_config: ' || 'Going to call query sourcing orgs', 1);
371: END IF;
372:
373: IF PG_DEBUG <> 0 THEN
374: oe_debug_pub.add('link_config: ' || 'Top level model l_model_id= ' || l_model_id, 1);

Line 374: oe_debug_pub.add('link_config: ' || 'Top level model l_model_id= ' || l_model_id, 1);

370: oe_debug_pub.add('link_config: ' || 'Going to call query sourcing orgs', 1);
371: END IF;
372:
373: IF PG_DEBUG <> 0 THEN
374: oe_debug_pub.add('link_config: ' || 'Top level model l_model_id= ' || l_model_id, 1);
375: END IF;
376:
377: l_stmt_num := 200;
378: CTO_MSUTIL_PUB.query_sourcing_org_ms(

Line 388: oe_debug_pub.add(' Error in query_sourcing_org_ms.. ', 1);

384: , x_exp_error_code => x_exp_error_code
385: , x_return_status => x_return_status );
386:
387: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
388: oe_debug_pub.add(' Error in query_sourcing_org_ms.. ', 1);
389: raise PROCESS_ERROR;
390: END IF;
391:
392: l_stmt_num := 210;

Line 396: oe_debug_pub.add('****$$$$ org ' || v_t_sourcing_info.source_organization_id(i)

392: l_stmt_num := 210;
393:
394: FOR i IN 1..v_t_sourcing_info.sourcing_rule_id.Count LOOP
395: IF PG_DEBUG <> 0 THEN
396: oe_debug_pub.add('****$$$$ org ' || v_t_sourcing_info.source_organization_id(i)
397: || '****$$$$ rule ' || v_t_sourcing_info.sourcing_rule_id(i)
398: || '****$$$$ type ' || v_t_sourcing_info.source_type(i)
399: || '****$$$$ rank ' || v_t_sourcing_info.rank(i)
400: || '****$$$$ assig id ' || v_t_sourcing_info.assignment_id(i),1);

Line 408: oe_debug_pub.add('link_config: ' || 'Inside for loop****$$$$ org ' || l_org, 1);

404: FOR i IN 1..v_t_sourcing_info.sourcing_rule_id.Count LOOP
405: l_org := v_t_sourcing_info.source_organization_id(i);
406:
407: IF PG_DEBUG <> 0 THEN
408: oe_debug_pub.add('link_config: ' || 'Inside for loop****$$$$ org ' || l_org, 1);
409: oe_debug_pub.add('link_config: ' || 'Looking if bom for '|| p_config_item_id || 'exists in org ' || l_org, 1);
410: END IF;
411:
412: BEGIN

Line 409: oe_debug_pub.add('link_config: ' || 'Looking if bom for '|| p_config_item_id || 'exists in org ' || l_org, 1);

405: l_org := v_t_sourcing_info.source_organization_id(i);
406:
407: IF PG_DEBUG <> 0 THEN
408: oe_debug_pub.add('link_config: ' || 'Inside for loop****$$$$ org ' || l_org, 1);
409: oe_debug_pub.add('link_config: ' || 'Looking if bom for '|| p_config_item_id || 'exists in org ' || l_org, 1);
410: END IF;
411:
412: BEGIN
413:

Line 430: oe_debug_pub.add('link_config: ' || 'BOM found in org ' || l_org, 1);

426: END;
427:
428: IF flag = 1 THEN
429: IF PG_DEBUG <> 0 THEN
430: oe_debug_pub.add('link_config: ' || 'BOM found in org ' || l_org, 1);
431: END IF;
432:
433: EXIT;
434:

Line 441: oe_debug_pub.add('link_config: ' || 'BOM found in ship org ' || old_config_dtls.ship_from_org_id(1), 1);

437: END LOOP; --loop for i
438:
439: ELSE
440: IF PG_DEBUG <> 0 THEN
441: oe_debug_pub.add('link_config: ' || 'BOM found in ship org ' || old_config_dtls.ship_from_org_id(1), 1);
442: END IF;
443:
444: flag := 1;
445: l_org := old_config_dtls.ship_from_org_id(1);

Line 469: oe_debug_pub.add('link_config: ' || 'Printing values in new_config_dtls',1);

465:
466: l_stmt_num := 250;
467:
468: IF PG_DEBUG <> 0 THEN
469: oe_debug_pub.add('link_config: ' || 'Printing values in new_config_dtls',1);
470: END IF;
471:
472: FOR i IN 1..new_config_dtls.config_item_id.Count LOOP
473: IF PG_DEBUG <> 0 THEN

Line 474: oe_debug_pub.add('link_config: ' || i||' '||'Config '||new_config_dtls.config_item_id(i)||' Model '||new_config_dtls.base_item_id(i),1);

470: END IF;
471:
472: FOR i IN 1..new_config_dtls.config_item_id.Count LOOP
473: IF PG_DEBUG <> 0 THEN
474: oe_debug_pub.add('link_config: ' || i||' '||'Config '||new_config_dtls.config_item_id(i)||' Model '||new_config_dtls.base_item_id(i),1);
475: END IF;
476: END LOOP;
477:
478: IF new_config_dtls.config_item_id.Count = 0 THEN

Line 500: oe_debug_pub.add('link_config: ' || i||'old_config_dtls.base_item_id(i) '||old_config_dtls.base_item_id(i)||j||'new_config_dtls.base_item_id(j) '||new_config_dtls.base_item_id(j), 1);

496: FOR j IN 1..new_config_dtls.config_item_id.Count LOOP
497:
498: IF old_config_dtls.base_item_id(i) = new_config_dtls.base_item_id(j) THEN
499: IF PG_DEBUG <> 0 THEN
500: oe_debug_pub.add('link_config: ' || i||'old_config_dtls.base_item_id(i) '||old_config_dtls.base_item_id(i)||j||'new_config_dtls.base_item_id(j) '||new_config_dtls.base_item_id(j), 1);
501: oe_debug_pub.add('link_config: ' ||'Model '||old_config_dtls.base_item_id(i)||' exists in BOM of ' ||new_config_dtls.config_item_id(j), 1);
502: END IF;
503:
504: bmodel_exists := 1;

Line 501: oe_debug_pub.add('link_config: ' ||'Model '||old_config_dtls.base_item_id(i)||' exists in BOM of ' ||new_config_dtls.config_item_id(j), 1);

497:
498: IF old_config_dtls.base_item_id(i) = new_config_dtls.base_item_id(j) THEN
499: IF PG_DEBUG <> 0 THEN
500: oe_debug_pub.add('link_config: ' || i||'old_config_dtls.base_item_id(i) '||old_config_dtls.base_item_id(i)||j||'new_config_dtls.base_item_id(j) '||new_config_dtls.base_item_id(j), 1);
501: oe_debug_pub.add('link_config: ' ||'Model '||old_config_dtls.base_item_id(i)||' exists in BOM of ' ||new_config_dtls.config_item_id(j), 1);
502: END IF;
503:
504: bmodel_exists := 1;
505: l_stmt_num := 270;

Line 552: oe_debug_pub.add('link_config: ' || 'CTOLINKB: ' || l_stmt_num || ':' || x_error_message, 1);

548: when PROCESS_ERROR then
549: x_message_name := 'CTO_LINK_ERROR' ;
550: cto_msg_pub.cto_message('BOM', x_message_name);
551: IF PG_DEBUG <> 0 THEN
552: oe_debug_pub.add('link_config: ' || 'CTOLINKB: ' || l_stmt_num || ':' || x_error_message, 1);
553: END IF;
554: return FALSE;
555:
556: when OTHERS then

Line 561: oe_debug_pub.add('link_config: ' || x_error_message, 1);

557: x_message_name := 'CTO_LINK_ERROR';
558: cto_msg_pub.cto_message('BOM', x_message_name);
559: x_error_message := 'CTOLINKB:link_config : ' || to_char(l_stmt_num) || ':' || substrb(sqlerrm,1,100);
560: IF PG_DEBUG <> 0 THEN
561: oe_debug_pub.add('link_config: ' || x_error_message, 1);
562: END IF;
563: return FALSE;
564: END link_config;
565:

Line 583: oe_debug_pub.add('Validate_Link: ' || 'Invalid model line or config item',2);

579: BEGIN
580:
581: IF (p_model_line_id is null) OR (p_config_item_id is null) THEN
582: IF PG_DEBUG <> 0 THEN
583: oe_debug_pub.add('Validate_Link: ' || 'Invalid model line or config item',2);
584: END IF;
585: return(0);
586: END IF;
587:

Line 599: oe_debug_pub.add('Validate_Link: ' || 'Item to be linked is valid',2);

595: and msi.inventory_item_id = p_config_item_id;
596:
597: IF l_valid = 1 THEN
598: IF PG_DEBUG <> 0 THEN
599: oe_debug_pub.add('Validate_Link: ' || 'Item to be linked is valid',2);
600: END IF;
601: return(1);
602: ELSE
603: IF PG_DEBUG <> 0 THEN

Line 604: oe_debug_pub.add('Validate_Link: ' || 'Item to be linked is invalid',2);

600: END IF;
601: return(1);
602: ELSE
603: IF PG_DEBUG <> 0 THEN
604: oe_debug_pub.add('Validate_Link: ' || 'Item to be linked is invalid',2);
605: END IF;
606: x_message_name := 'CTO_LINK_ERROR';
607: x_error_message := 'CTLINKB:validate_link:not a valid link:';
608: return(0);

Line 614: oe_debug_pub.add('Validate_Link: ' || 'Item to be linked is invalid',1);

610:
611: EXCEPTION
612: when no_data_found then
613: IF PG_DEBUG <> 0 THEN
614: oe_debug_pub.add('Validate_Link: ' || 'Item to be linked is invalid',1);
615: END IF;
616: x_message_name := 'CTO_LINK_ERROR';
617: x_error_message := 'CTOLINKB:validate_link:ndf: '
618: ||substrb(sqlerrm,1,100);

Line 622: oe_debug_pub.add('Validate_Link: ' || 'Item to be linked is invalid::others exception',1);

618: ||substrb(sqlerrm,1,100);
619: return(0);
620: when others then
621: IF PG_DEBUG <> 0 THEN
622: oe_debug_pub.add('Validate_Link: ' || 'Item to be linked is invalid::others exception',1);
623: END IF;
624: x_message_name := 'CTO_LINK_ERROR';
625: x_error_message := 'CTOLINKB:validate_link:others: '
626: ||substrb(sqlerrm,1,100);

Line 663: oe_debug_pub.add('Inside get_all_configs', 1);

659:
660: BEGIN
661:
662: IF PG_DEBUG <> 0 THEN
663: oe_debug_pub.add('Inside get_all_configs', 1);
664: oe_debug_pub.add('Value of config id passed: '|| pconfigId, 1);
665: END IF;
666:
667: OPEN get_configs;

Line 664: oe_debug_pub.add('Value of config id passed: '|| pconfigId, 1);

660: BEGIN
661:
662: IF PG_DEBUG <> 0 THEN
663: oe_debug_pub.add('Inside get_all_configs', 1);
664: oe_debug_pub.add('Value of config id passed: '|| pconfigId, 1);
665: END IF;
666:
667: OPEN get_configs;
668:

Line 673: oe_debug_pub.add('l_index '||l_index, 1);

669: LOOP
670: l_index := new_config_dtls.config_item_id.Count + 1;
671:
672: IF PG_DEBUG <> 0 THEN
673: oe_debug_pub.add('l_index '||l_index, 1);
674: END IF;
675:
676: FETCH get_configs INTO new_config_dtls.config_item_id(l_index),
677: new_config_dtls.base_item_id(l_index);

Line 688: oe_debug_pub.add('Count '||new_config_dtls.config_item_id.count, 1);

684:
685: CLOSE get_configs;
686:
687: IF PG_DEBUG <> 0 THEN
688: oe_debug_pub.add('Count '||new_config_dtls.config_item_id.count, 1);
689: END IF;
690:
691: END get_all_configs;
692: