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

Line 216: oe_debug_pub.add('match_and_create_all_items: ' || 'In Match_and_Create_all_Items for ato_line_id '

212: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
213:
214:
215: IF PG_DEBUG <> 0 THEN
216: oe_debug_pub.add('match_and_create_all_items: ' || 'In Match_and_Create_all_Items for ato_line_id '
217: || to_char(pModelLineId), 1);
218: END IF;
219:
220: l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');

Line 222: oe_debug_pub.add('match_and_create_all_items: ' || 'CUSTOM_MATCH: ' || l_custom_match_profile, 1);

218: END IF;
219:
220: l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');
221: IF PG_DEBUG <> 0 THEN
222: oe_debug_pub.add('match_and_create_all_items: ' || 'CUSTOM_MATCH: ' || l_custom_match_profile, 1);
223: END IF;
224:
225: /*-----------------------------------------------------+
226: This is the loop that traverses bom_cto_order_lines

Line 242: oe_debug_pub.add('match_and_create_all_items: ' || 'Match_and_create_all_items: Processing line_id '

238: from bom_cto_order_lines
239: where line_id = lNextRec.line_id;
240:
241: IF PG_DEBUG <> 0 THEN
242: oe_debug_pub.add('match_and_create_all_items: ' || 'Match_and_create_all_items: Processing line_id '
243: || to_char(lNextRec.line_id) ||
244: ' with perform_match value ' ||
245: lPerformMatch, 1);
246: END IF;

Line 261: oe_debug_pub.add('match_and_create_all_items: ' ||

257: xMsgData => xMsgData
258: );
259:
260: IF PG_DEBUG <> 0 THEN
261: oe_debug_pub.add('match_and_create_all_items: ' ||
262: 'Returned from create_item in stmt num 100 with status ' ||
263: to_char(lStatus), 1);
264: END IF;
265:

Line 276: oe_debug_pub.add('match_and_create_all_items: ' || 'conifg item id passed to ENI=>'||

272:
273: l_eni_star_record.inventory_item_id := lXConfigId;
274:
275: IF PG_DEBUG <> 0 THEN
276: oe_debug_pub.add('match_and_create_all_items: ' || 'conifg item id passed to ENI=>'||
277: l_eni_star_record.inventory_item_id , 5);
278: END IF;
279:
280: --follwoing API is maintained by PLM,DBI team present in Bom source control

Line 294: oe_debug_pub.add('match_and_create_all_items:' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'

290: --CTO has decided not to fail for error messages but just log messages
291: --refer bug 3124169 for more info
292: IF eni_return_status = 'S' THEN
293: IF PG_DEBUG <> 0 THEN
294: oe_debug_pub.add('match_and_create_all_items:' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
295: ||eni_return_status, 5);
296: END IF;
297: ELSE
298: IF PG_DEBUG <> 0 THEN

Line 299: oe_debug_pub.add('match_and_create_all_items: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'

295: ||eni_return_status, 5);
296: END IF;
297: ELSE
298: IF PG_DEBUG <> 0 THEN
299: oe_debug_pub.add('match_and_create_all_items: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
300: ||eni_return_status, 1);
301: oe_debug_pub.add('match_and_create_all_items: ' || 'IGNORING ABOVE ERROR', 1);
302: END IF;
303:

Line 301: oe_debug_pub.add('match_and_create_all_items: ' || 'IGNORING ABOVE ERROR', 1);

297: ELSE
298: IF PG_DEBUG <> 0 THEN
299: oe_debug_pub.add('match_and_create_all_items: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
300: ||eni_return_status, 1);
301: oe_debug_pub.add('match_and_create_all_items: ' || 'IGNORING ABOVE ERROR', 1);
302: END IF;
303:
304: END IF;
305:

Line 322: oe_debug_pub.add('match_and_create_all_items: ' ||

318: l_x_error_msg,
319: l_x_msg_name);
320:
321: IF PG_DEBUG <> 0 THEN
322: oe_debug_pub.add('match_and_create_all_items: ' ||
323: 'Returned from canning in stmt num 110 with status '
324: || to_char(lStatus), 1);
325: END IF;
326:

Line 350: oe_debug_pub.add('match_and_create_all_items: ' || 'Standard Match.', 1);

346:
347: lStmtNum := 120;
348: IF l_custom_match_profile = 2 THEN
349: IF PG_DEBUG <> 0 THEN
350: oe_debug_pub.add('match_and_create_all_items: ' || 'Standard Match.', 1);
351: END IF;
352: lStatus := check_config_match(
353: lNextRec.line_id,
354: lXConfigId,

Line 359: oe_debug_pub.add('match_and_create_all_items: ' || 'Returned from check_config_match with status '

355: l_x_error_msg,
356: l_x_msg_name);
357:
358: IF PG_DEBUG <> 0 THEN
359: oe_debug_pub.add('match_and_create_all_items: ' || 'Returned from check_config_match with status '
360: || to_char(lStatus), 1);
361: END IF;
362:
363: if lStatus <> 1 then

Line 368: oe_debug_pub.add('match_and_create_all_items: ' || 'Custom Match.', 1);

364: raise fnd_api.g_exc_error;
365: end if;
366: ELSE
367: IF PG_DEBUG <> 0 THEN
368: oe_debug_pub.add('match_and_create_all_items: ' || 'Custom Match.', 1);
369: END IF;
370: lStatus := CTO_CUSTOM_MATCH_PK.find_matching_config(
371: pModelLineId => lNextRec.line_id,
372: xMatchedItemId => lXConfigId,

Line 378: oe_debug_pub.add('match_and_create_all_items: ' || 'Returned from find_matching_config with status '

374: xMessageName => l_x_msg_name,
375: xTableName => l_x_table_name);
376:
377: IF PG_DEBUG <> 0 THEN
378: oe_debug_pub.add('match_and_create_all_items: ' || 'Returned from find_matching_config with status '
379: || to_char(lStatus), 1);
380: END IF;
381:
382: if lStatus <> 1 then

Line 391: oe_debug_pub.add('match_and_create_all_items: ' || 'No match for line ' ||

387:
388: if (lStatus = 1 and lXConfigId is null) then
389:
390: IF PG_DEBUG <> 0 THEN
391: oe_debug_pub.add('match_and_create_all_items: ' || 'No match for line ' ||
392: to_char(lNextRec.line_id), 1);
393: END IF;
394:
395: lStmtNum := 130;

Line 405: oe_debug_pub.add('match_and_create_all_items: ' ||

401: xMsgCount => xMsgCount,
402: xMsgData => xMsgData);
403:
404: IF PG_DEBUG <> 0 THEN
405: oe_debug_pub.add('match_and_create_all_items: ' ||
406: 'Returned from create_item in stmt num 130 with status '
407: || to_char(lStatus), 1);
408: END IF;
409:

Line 419: oe_debug_pub.add('match_and_create_all_items: ' || 'conifg item id passed to ENI=>'||

415: --start bugfix 3070429,3124169
416:
417: l_eni_star_record.inventory_item_id := lXConfigId;
418: IF PG_DEBUG <> 0 THEN
419: oe_debug_pub.add('match_and_create_all_items: ' || 'conifg item id passed to ENI=>'||
420: l_eni_star_record.inventory_item_id , 5);
421: END IF;
422:
423: --follwoing API is maintained by PLM,DBI team present in Bom source control

Line 437: oe_debug_pub.add('match_and_create_all_items:' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'

433: --CTO has decided not to fail for error messages but just log messages
434: --refer bug 3124169 for more info
435: IF eni_return_status = 'S' THEN
436: IF PG_DEBUG <> 0 THEN
437: oe_debug_pub.add('match_and_create_all_items:' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
438: ||eni_return_status, 5);
439: END IF;
440: ELSE
441: IF PG_DEBUG <> 0 THEN

Line 442: oe_debug_pub.add('match_and_create_all_items: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'

438: ||eni_return_status, 5);
439: END IF;
440: ELSE
441: IF PG_DEBUG <> 0 THEN
442: oe_debug_pub.add('match_and_create_all_items: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
443: ||eni_return_status, 1);
444: oe_debug_pub.add('match_and_create_all_items: ' || 'IGNORING ABOVE ERROR', 1);
445: END IF;
446:

Line 444: oe_debug_pub.add('match_and_create_all_items: ' || 'IGNORING ABOVE ERROR', 1);

440: ELSE
441: IF PG_DEBUG <> 0 THEN
442: oe_debug_pub.add('match_and_create_all_items: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
443: ||eni_return_status, 1);
444: oe_debug_pub.add('match_and_create_all_items: ' || 'IGNORING ABOVE ERROR', 1);
445: END IF;
446:
447: END IF;
448:

Line 466: oe_debug_pub.add('match_and_create_all_items: ' ||

462: l_x_error_msg,
463: l_x_msg_name);
464:
465: IF PG_DEBUG <> 0 THEN
466: oe_debug_pub.add('match_and_create_all_items: ' ||
467: 'Returned from canning in stmt num 140 with status '
468: || to_char(lStatus), 1);
469: END IF;
470:

Line 489: oe_debug_pub.add('match_and_create_all_items: ' || 'Match found for line ' ||

485:
486: elsif (lStatus = 1 and lXConfigId is not null) then
487:
488: IF PG_DEBUG <> 0 THEN
489: oe_debug_pub.add('match_and_create_all_items: ' || 'Match found for line ' ||
490: to_char(lNextRec.line_id) ||
491: ' with config item ' ||
492: to_char(lXConfigId), 1);
493: END IF;

Line 498: oe_debug_pub.add('Value of gMatch ' ||gMatch,1);

494:
495: /*bugfix 2986192 */
496: gMatch := 1;
497: IF PG_DEBUG <> 0 THEN
498: oe_debug_pub.add('Value of gMatch ' ||gMatch,1);
499: END IF;
500:
501: lStmtNum := 150;
502: lStatus := CTO_CONFIG_ITEM_PK.create_item(

Line 510: oe_debug_pub.add('match_and_create_all_items: ' ||

506: xMsgCount => xMsgCount,
507: xMsgData => xMsgData);
508:
509: IF PG_DEBUG <> 0 THEN
510: oe_debug_pub.add('match_and_create_all_items: ' ||
511: 'Returned from create_item in stmt num 150 with status '
512: || to_char(lStatus), 1);
513: END IF;
514:

Line 525: oe_debug_pub.add('match_and_create_all_items: ' || 'conifg item id passed to ENI=>'||

521:
522: l_eni_star_record.inventory_item_id := lXConfigId;
523:
524: IF PG_DEBUG <> 0 THEN
525: oe_debug_pub.add('match_and_create_all_items: ' || 'conifg item id passed to ENI=>'||
526: l_eni_star_record.inventory_item_id , 5);
527: END IF;
528:
529: --follwoing API is maintained by PLM,DBI team present in Bom source control

Line 543: oe_debug_pub.add('match_and_create_all_items:' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'

539: --CTO has decided not to fail for error messages but just log messages
540: --refer bug 3124169 for more info
541: IF eni_return_status = 'S' THEN
542: IF PG_DEBUG <> 0 THEN
543: oe_debug_pub.add('match_and_create_all_items:' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
544: ||eni_return_status, 5);
545: END IF;
546: ELSE
547: IF PG_DEBUG <> 0 THEN

Line 548: oe_debug_pub.add('match_and_create_all_items: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'

544: ||eni_return_status, 5);
545: END IF;
546: ELSE
547: IF PG_DEBUG <> 0 THEN
548: oe_debug_pub.add('match_and_create_all_items: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
549: ||eni_return_status, 1);
550: oe_debug_pub.add('match_and_create_all_items: ' || 'IGNORING ABOVE ERROR', 1);
551: END IF;
552:

Line 550: oe_debug_pub.add('match_and_create_all_items: ' || 'IGNORING ABOVE ERROR', 1);

546: ELSE
547: IF PG_DEBUG <> 0 THEN
548: oe_debug_pub.add('match_and_create_all_items: ' || 'ENI_CONFIG_ITEMS_PKG.Create_config_items returned=>'
549: ||eni_return_status, 1);
550: oe_debug_pub.add('match_and_create_all_items: ' || 'IGNORING ABOVE ERROR', 1);
551: END IF;
552:
553: END IF;
554:

Line 584: oe_debug_pub.add('match_and_create_all_items: ' || 'Exception in stmt num: ' || to_char(lStmtNum), 1);

580: EXCEPTION
581:
582: WHEN fnd_api.g_exc_error THEN
583: IF PG_DEBUG <> 0 THEN
584: oe_debug_pub.add('match_and_create_all_items: ' || 'Exception in stmt num: ' || to_char(lStmtNum), 1);
585: END IF;
586: xReturnStatus := FND_API.G_RET_STS_ERROR;
587: -- Get message count and data
588: cto_msg_pub.count_and_get

Line 594: oe_debug_pub.add('match_and_create_all_items: ' || ' Unexpected Exception in stmt num: ' || to_char(lStmtNum), 1);

590: , p_msg_data => xMsgData
591: );
592: WHEN fnd_api.g_exc_unexpected_error THEN
593: IF PG_DEBUG <> 0 THEN
594: oe_debug_pub.add('match_and_create_all_items: ' || ' Unexpected Exception in stmt num: ' || to_char(lStmtNum), 1);
595: END IF;
596: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR ;
597: -- Get message count and data
598: cto_msg_pub.count_and_get

Line 604: oe_debug_pub.add('errmsg'||sqlerrm);

600: , p_msg_data => xMsgData
601: );
602:
603: WHEN OTHERS then
604: oe_debug_pub.add('errmsg'||sqlerrm);
605: IF PG_DEBUG <> 0 THEN
606: oe_debug_pub.add('match_and_create_all_items: ' || 'Others Exception in stmt num: ' || to_char(lStmtNum), 1);
607: END IF;
608: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

Line 606: oe_debug_pub.add('match_and_create_all_items: ' || 'Others Exception in stmt num: ' || to_char(lStmtNum), 1);

602:
603: WHEN OTHERS then
604: oe_debug_pub.add('errmsg'||sqlerrm);
605: IF PG_DEBUG <> 0 THEN
606: oe_debug_pub.add('match_and_create_all_items: ' || 'Others Exception in stmt num: ' || to_char(lStmtNum), 1);
607: END IF;
608: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
609: -- Get message count and data
610: cto_msg_pub.count_and_get

Line 685: oe_debug_pub.add('entered Check_config_match=>' );

681: * ordered configuration in oe_order_lines_all.
682: ****************************************************************/
683:
684:
685: oe_debug_pub.add('entered Check_config_match=>' );
686:
687: l_stmt_num := 0;
688: if (p_model_line_id is NULL) then
689: raise PARAMETER_ERROR;

Line 711: oe_debug_pub.add ('check_config_match :: start time : '||to_char(l_start_time, 'MM-DD-YYYY HH24:MI:SS'));

707:
708: l_start_time := sysdate;
709:
710: IF PG_DEBUG <> 0 THEN
711: oe_debug_pub.add ('check_config_match :: start time : '||to_char(l_start_time, 'MM-DD-YYYY HH24:MI:SS'));
712: END IF;
713:
714: l_stmt_num := 100;
715: delete bom_ato_configs_temp;

Line 736: oe_debug_pub.add('l_component_count = '||l_component_count ||' l_component_sum = '||l_component_sum);

732: from bom_cto_order_lines_gt
733: where line_id = p_model_line_id;
734:
735: IF PG_DEBUG <> 0 THEN
736: oe_debug_pub.add('l_component_count = '||l_component_count ||' l_component_sum = '||l_component_sum);
737: oe_debug_pub.add(' l_base_model_id = '||l_base_model_id||' p_model_line_id = '||p_model_line_id);
738: END IF;
739:
740: l_stmt_num := 130;

Line 737: oe_debug_pub.add(' l_base_model_id = '||l_base_model_id||' p_model_line_id = '||p_model_line_id);

733: where line_id = p_model_line_id;
734:
735: IF PG_DEBUG <> 0 THEN
736: oe_debug_pub.add('l_component_count = '||l_component_count ||' l_component_sum = '||l_component_sum);
737: oe_debug_pub.add(' l_base_model_id = '||l_base_model_id||' p_model_line_id = '||p_model_line_id);
738: END IF;
739:
740: l_stmt_num := 130;
741: --

Line 801: oe_debug_pub.add ('Rows inserted into gtt :'||sql%rowcount);

797: and sum(component_item_id) = l_component_sum);
798:
799:
800: IF PG_DEBUG <> 0 THEN
801: oe_debug_pub.add ('Rows inserted into gtt :'||sql%rowcount);
802: oe_debug_pub.add ('check_config_match :: after bom_ato_configs_temp insert time : '||to_char(sysdate, 'MM-DD-YYYY HH24:MI:SS'));
803: END IF;
804:
805: l_stmt_num := 140;

Line 802: oe_debug_pub.add ('check_config_match :: after bom_ato_configs_temp insert time : '||to_char(sysdate, 'MM-DD-YYYY HH24:MI:SS'));

798:
799:
800: IF PG_DEBUG <> 0 THEN
801: oe_debug_pub.add ('Rows inserted into gtt :'||sql%rowcount);
802: oe_debug_pub.add ('check_config_match :: after bom_ato_configs_temp insert time : '||to_char(sysdate, 'MM-DD-YYYY HH24:MI:SS'));
803: END IF;
804:
805: l_stmt_num := 140;
806:

Line 867: oe_debug_pub.add('matched item=>'|| x_config_match_id,5);

863: and rownum = 1;
864:
865: if (x_config_match_id is not NULL) then
866: IF PG_DEBUG <> 0 THEN
867: oe_debug_pub.add('matched item=>'|| x_config_match_id,5);
868: END IF;
869:
870: --Begin bugfix 7203643
871: declare

Line 890: OE_DEBUG_PUB.add ('check_config_match: ' || 'Locked rows.');

886: OPEN config_rows;
887: CLOSE config_rows;
888:
889: IF PG_DEBUG <> 0 THEN
890: OE_DEBUG_PUB.add ('check_config_match: ' || 'Locked rows.');
891: END IF;
892:
893: l_stmt_num := 120;
894:

Line 902: OE_DEBUG_PUB.add ('check_config_match: ' || 'Could not lock for config id '|| x_config_match_id ||' for update.');

898:
899: exception
900: when record_locked then
901: IF PG_DEBUG <> 0 THEN
902: OE_DEBUG_PUB.add ('check_config_match: ' || 'Could not lock for config id '|| x_config_match_id ||' for update.');
903: OE_DEBUG_PUB.add ('check_config_match: ' || 'This config is being processed by another process. Not updating last_referenced_date.');
904: END IF;
905: end;
906: --End bugfix 7203643

Line 903: OE_DEBUG_PUB.add ('check_config_match: ' || 'This config is being processed by another process. Not updating last_referenced_date.');

899: exception
900: when record_locked then
901: IF PG_DEBUG <> 0 THEN
902: OE_DEBUG_PUB.add ('check_config_match: ' || 'Could not lock for config id '|| x_config_match_id ||' for update.');
903: OE_DEBUG_PUB.add ('check_config_match: ' || 'This config is being processed by another process. Not updating last_referenced_date.');
904: END IF;
905: end;
906: --End bugfix 7203643
907: end if;

Line 913: oe_debug_pub.add ('check_config_match :: end time : '||to_char(sysdate, 'MM-DD-YYYY HH24:MI:SS'));

909: --start (FP 4895615 )4526218
910: diff := (sysdate - l_start_time)*24*60*60;
911:
912: IF PG_DEBUG <> 0 THEN
913: oe_debug_pub.add ('check_config_match :: end time : '||to_char(sysdate, 'MM-DD-YYYY HH24:MI:SS'));
914: oe_debug_pub.add('Time taken : '||diff);
915: END IF;
916: --end (FP 4895615)4526218
917:

Line 914: oe_debug_pub.add('Time taken : '||diff);

910: diff := (sysdate - l_start_time)*24*60*60;
911:
912: IF PG_DEBUG <> 0 THEN
913: oe_debug_pub.add ('check_config_match :: end time : '||to_char(sysdate, 'MM-DD-YYYY HH24:MI:SS'));
914: oe_debug_pub.add('Time taken : '||diff);
915: END IF;
916: --end (FP 4895615)4526218
917:
918: return 1;

Line 923: oe_debug_pub.add ('check_config_match raised PARAMETER_ERROR',1);

919:
920: EXCEPTION
921: when PARAMETER_ERROR THEN
922: IF PG_DEBUG <> 0 THEN
923: oe_debug_pub.add ('check_config_match raised PARAMETER_ERROR',1);
924: END IF;
925:
926: x_error_message := 'CTO_MATCH_CONFIG.check_config_match' ||
927: 'Verify Parameters';

Line 936: oe_debug_pub.add ('check_config_match :No data found',1);

932:
933: when NO_DATA_FOUND then
934:
935: IF PG_DEBUG <> 0 THEN
936: oe_debug_pub.add ('check_config_match :No data found',1);
937: oe_debug_pub.add ('check_config_match :returning 1,success',1);
938: END IF;
939: return 1;
940:

Line 937: oe_debug_pub.add ('check_config_match :returning 1,success',1);

933: when NO_DATA_FOUND then
934:
935: IF PG_DEBUG <> 0 THEN
936: oe_debug_pub.add ('check_config_match :No data found',1);
937: oe_debug_pub.add ('check_config_match :returning 1,success',1);
938: END IF;
939: return 1;
940:
941: when OTHERS THEN

Line 944: oe_debug_pub.add ('check_config_match raised OTHERS exception:'||sqlerrm);

940:
941: when OTHERS THEN
942:
943: IF PG_DEBUG <> 0 THEN
944: oe_debug_pub.add ('check_config_match raised OTHERS exception:'||sqlerrm);
945: END IF;
946: x_error_message := 'CTO_MATCH_CONFIG.check_config_match' ||
947: to_char(l_stmt_num) || ':' ||
948: substrb(sqlerrm,1,150);

Line 1128: oe_debug_pub.add('can_configurations: ' || 'Not canning the configuration AS', 3);

1124:
1125: ELSE --flag is N
1126:
1127: IF PG_DEBUG <> 0 THEN
1128: oe_debug_pub.add('can_configurations: ' || 'Not canning the configuration AS', 3);
1129: oe_debug_pub.add('Assemble_to_order_flag is set to N ', 3);
1130:
1131:
1132:

Line 1129: oe_debug_pub.add('Assemble_to_order_flag is set to N ', 3);

1125: ELSE --flag is N
1126:
1127: IF PG_DEBUG <> 0 THEN
1128: oe_debug_pub.add('can_configurations: ' || 'Not canning the configuration AS', 3);
1129: oe_debug_pub.add('Assemble_to_order_flag is set to N ', 3);
1130:
1131:
1132:
1133: END IF;

Line 1142: oe_debug_pub.add('can_configurations: ' || 'Failed in can_configurations 1. ', 1);

1138: EXCEPTION
1139:
1140: when PARAMETER_ERROR then
1141: -- IF PG_DEBUG <> 0 THEN
1142: oe_debug_pub.add('can_configurations: ' || 'Failed in can_configurations 1. ', 1);
1143: -- END IF;
1144: error_msg := 'CTO_MATCH_CONFIG.can_configurations' ||
1145: to_char(l_stmt_num) || ':' ||
1146: 'Verify Parameters';

Line 1149: oe_debug_pub.add('can_configurations: ' || error_msg, 1);

1145: to_char(l_stmt_num) || ':' ||
1146: 'Verify Parameters';
1147: msg_name := 'CTO_MATCH_ERROR';
1148: -- IF PG_DEBUG <> 0 THEN
1149: oe_debug_pub.add('can_configurations: ' || error_msg, 1);
1150: -- END IF;
1151: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');
1152: return 0;
1153:

Line 1156: oe_debug_pub.add('can_configurations: ' || 'Failed in can_configurations 2. ', 1);

1152: return 0;
1153:
1154: when INSERT_ERROR then
1155: -- IF PG_DEBUG <> 0 THEN
1156: oe_debug_pub.add('can_configurations: ' || 'Failed in can_configurations 2. ', 1);
1157: -- END IF;
1158: error_msg := 'CTO_MATCH_CONFIG.can_configurations' ||
1159: 'Insert Error';
1160: msg_name := 'CTO_MATCH_ERROR';

Line 1162: oe_debug_pub.add('can_configurations: ' || error_msg, 1);

1158: error_msg := 'CTO_MATCH_CONFIG.can_configurations' ||
1159: 'Insert Error';
1160: msg_name := 'CTO_MATCH_ERROR';
1161: -- IF PG_DEBUG <> 0 THEN
1162: oe_debug_pub.add('can_configurations: ' || error_msg, 1);
1163: -- END IF;
1164: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');
1165: return 0;
1166:

Line 1168: oe_debug_pub.add('errmsg'||sqlerrm);

1164: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');
1165: return 0;
1166:
1167: when OTHERS then
1168: oe_debug_pub.add('errmsg'||sqlerrm);
1169: IF PG_DEBUG <> 0 THEN
1170: oe_debug_pub.add('can_configurations: ' || 'Failed in can_configurations 3. ', 1);
1171: END IF;
1172: error_msg := 'CTO_MATCH_CONFIG.can_configurations' ||

Line 1170: oe_debug_pub.add('can_configurations: ' || 'Failed in can_configurations 3. ', 1);

1166:
1167: when OTHERS then
1168: oe_debug_pub.add('errmsg'||sqlerrm);
1169: IF PG_DEBUG <> 0 THEN
1170: oe_debug_pub.add('can_configurations: ' || 'Failed in can_configurations 3. ', 1);
1171: END IF;
1172: error_msg := 'CTO_MATCH_CONFIG.can_configurations' ||
1173: to_char(l_stmt_num) || ':' ||
1174: substrb(sqlerrm,1,150);

Line 1176: oe_debug_pub.add('can_configurations: ' || error_msg, 1);

1172: error_msg := 'CTO_MATCH_CONFIG.can_configurations' ||
1173: to_char(l_stmt_num) || ':' ||
1174: substrb(sqlerrm,1,150);
1175: IF PG_DEBUG <> 0 THEN
1176: oe_debug_pub.add('can_configurations: ' || error_msg, 1);
1177: END IF;
1178: msg_name := 'CTO_MATCH_ERROR';
1179: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');
1180: return 0;

Line 1230: oe_debug_pub.add('ENTERED xfer_tab_to_rec',1);

1226: BEGIN
1227:
1228:
1229: IF PG_DEBUG <> 0 THEN
1230: oe_debug_pub.add('ENTERED xfer_tab_to_rec',1);
1231: END IF;
1232: x_return_status := FND_API.G_RET_STS_SUCCESS;
1233:
1234: lStmtNum :=10;

Line 1239: oe_debug_pub.add('count in table=>'|| l_count,5);

1235: l_count := p_match_rec_of_tab.LINE_ID.count;
1236:
1237:
1238: IF PG_DEBUG <> 0 THEN
1239: oe_debug_pub.add('count in table=>'|| l_count,5);
1240: END IF;
1241:
1242:
1243:

Line 1246: oe_debug_pub.add('no of records in table=>'|| l_count,5);--level 5

1242:
1243:
1244:
1245: IF PG_DEBUG <> 0 THEN
1246: oe_debug_pub.add('no of records in table=>'|| l_count,5);--level 5
1247: END IF;
1248: i := 1;
1249:
1250: lStmtNum:= 20;

Line 1278: oe_debug_pub.add('count in record structure=>'|| l_count,5);

1274: l_count := x_tab_of_rec.count;
1275:
1276:
1277: IF PG_DEBUG <> 0 THEN
1278: oe_debug_pub.add('count in record structure=>'|| l_count,5);
1279: END IF;
1280:
1281:
1282:

Line 1288: oe_debug_pub.add('xfer_tab_to_rec: ' || 'Exception in stmt num: '

1284:
1285: EXCEPTION
1286: WHEN fnd_api.g_exc_error THEN
1287: IF PG_DEBUG <> 0 THEN
1288: oe_debug_pub.add('xfer_tab_to_rec: ' || 'Exception in stmt num: '
1289: || to_char(lStmtNum), 1);
1290: END IF;
1291: x_return_status := FND_API.G_RET_STS_ERROR;
1292: -- Get message count and data

Line 1299: oe_debug_pub.add('xfer_tab_to_rec: ' || ' Unexpected Exception in stmt num: '

1295: , p_msg_data => x_msg_data
1296: );
1297: WHEN fnd_api.g_exc_unexpected_error THEN
1298: IF PG_DEBUG <> 0 THEN
1299: oe_debug_pub.add('xfer_tab_to_rec: ' || ' Unexpected Exception in stmt num: '
1300: || to_char(lStmtNum), 1);
1301:
1302: END IF;
1303:

Line 1313: oe_debug_pub.add('xfer_tab_to_rec: ' || 'Others Exception in stmt num: '

1309: );
1310: WHEN OTHERS then
1311:
1312: IF PG_DEBUG <> 0 THEN
1313: oe_debug_pub.add('xfer_tab_to_rec: ' || 'Others Exception in stmt num: '
1314: || to_char(lStmtNum), 1);
1315: END IF;
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317: oe_debug_pub.add('error mse'||sqlerrm);

Line 1317: oe_debug_pub.add('error mse'||sqlerrm);

1313: oe_debug_pub.add('xfer_tab_to_rec: ' || 'Others Exception in stmt num: '
1314: || to_char(lStmtNum), 1);
1315: END IF;
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317: oe_debug_pub.add('error mse'||sqlerrm);
1318: -- Get message count and data
1319: cto_msg_pub.count_and_get
1320: ( p_msg_count => x_msg_count
1321: , p_msg_data => x_msg_data

Line 1359: oe_debug_pub.add('Last index in p_tab_of_rec strcuture=>'||l_last_idx,5);

1355: l_count := p_tab_of_rec.count;
1356:
1357: IF PG_DEBUG <> 0 THEN
1358:
1359: oe_debug_pub.add('Last index in p_tab_of_rec strcuture=>'||l_last_idx,5);
1360: oe_debug_pub.add('first index in p_tab_of_rec strcuture=>'||j,5);
1361: oe_debug_pub.add('no of recs in p_tab_of_rec strcuture=>'||l_count,3);
1362:
1363: END IF;

Line 1360: oe_debug_pub.add('first index in p_tab_of_rec strcuture=>'||j,5);

1356:
1357: IF PG_DEBUG <> 0 THEN
1358:
1359: oe_debug_pub.add('Last index in p_tab_of_rec strcuture=>'||l_last_idx,5);
1360: oe_debug_pub.add('first index in p_tab_of_rec strcuture=>'||j,5);
1361: oe_debug_pub.add('no of recs in p_tab_of_rec strcuture=>'||l_count,3);
1362:
1363: END IF;
1364:

Line 1361: oe_debug_pub.add('no of recs in p_tab_of_rec strcuture=>'||l_count,3);

1357: IF PG_DEBUG <> 0 THEN
1358:
1359: oe_debug_pub.add('Last index in p_tab_of_rec strcuture=>'||l_last_idx,5);
1360: oe_debug_pub.add('first index in p_tab_of_rec strcuture=>'||j,5);
1361: oe_debug_pub.add('no of recs in p_tab_of_rec strcuture=>'||l_count,3);
1362:
1363: END IF;
1364:
1365:

Line 1377: oe_debug_pub.add('index '||' line_id '||' plan_level'

1373:
1374: --print only fi debug = 5
1375:
1376: IF PG_DEBUG <> 0 THEN
1377: oe_debug_pub.add('index '||' line_id '||' plan_level'
1378: || 'parent_ato '||'gop_parent',5);
1379: END IF;
1380:
1381: lStmtNum :=30;

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

1392:
1393: --print only fi debug = 5
1394:
1395: IF PG_DEBUG <> 0 THEN
1396: oe_debug_pub.add(i||'=>'||p_match_rec_of_tab.line_id(i)||'=>' ||
1397: p_match_rec_of_tab.plan_level(i)||'=>'||
1398: p_match_rec_of_tab.parent_ato_line_id(i)||'=>'||
1399: p_match_rec_of_tab.gop_parent_ato_line_id(i),5);
1400: END IF;

Line 1414: oe_debug_pub.add('xfer_rec_to_tab: ' || 'Exception in stmt num: '

1410: EXCEPTION
1411:
1412: WHEN fnd_api.g_exc_error THEN
1413: IF PG_DEBUG <> 0 THEN
1414: oe_debug_pub.add('xfer_rec_to_tab: ' || 'Exception in stmt num: '
1415: || to_char(lStmtNum), 1);
1416: END IF;
1417: x_return_status := FND_API.G_RET_STS_ERROR;
1418: -- Get message count and data

Line 1425: oe_debug_pub.add('xfer_rec_to_tab: ' || ' Unexpected Exception in stmt num: ' ||

1421: , p_msg_data => x_msg_data
1422: );
1423: WHEN fnd_api.g_exc_unexpected_error THEN
1424: IF PG_DEBUG <> 0 THEN
1425: oe_debug_pub.add('xfer_rec_to_tab: ' || ' Unexpected Exception in stmt num: ' ||
1426: to_char(lStmtNum), 1);
1427: END IF;
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1429: -- Get message count and data

Line 1436: oe_debug_pub.add('xfer_rec_to_tab: ' || 'Others Exception in stmt num: ' ||

1432: , p_msg_data => x_msg_data
1433: );
1434: WHEN OTHERS then
1435: IF PG_DEBUG <> 0 THEN
1436: oe_debug_pub.add('xfer_rec_to_tab: ' || 'Others Exception in stmt num: ' ||
1437: to_char(lStmtNum), 1);
1438: oe_debug_pub.add('errmessage' || sqlerrm,1);
1439: END IF;
1440:

Line 1438: oe_debug_pub.add('errmessage' || sqlerrm,1);

1434: WHEN OTHERS then
1435: IF PG_DEBUG <> 0 THEN
1436: oe_debug_pub.add('xfer_rec_to_tab: ' || 'Others Exception in stmt num: ' ||
1437: to_char(lStmtNum), 1);
1438: oe_debug_pub.add('errmessage' || sqlerrm,1);
1439: END IF;
1440:
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: -- Get message count and data

Line 1476: oe_debug_pub.add('Entered populate_parent_ato',5);

1472: BEGIN
1473:
1474: x_return_status := FND_API.G_RET_STS_SUCCESS;
1475: IF PG_DEBUG <> 0 THEN
1476: oe_debug_pub.add('Entered populate_parent_ato',5);
1477: END IF;
1478:
1479: v_step := 'Step C1' ;
1480:

Line 1485: oe_debug_pub.add('last index'|| l_last_idx,5);

1481: lStmtNum:=10;
1482: l_last_idx := P_tab_of_rec.last;
1483:
1484: IF PG_DEBUG <> 0 THEN
1485: oe_debug_pub.add('last index'|| l_last_idx,5);
1486: END IF;
1487:
1488:
1489: i := P_tab_of_rec.FIRST;

Line 1492: oe_debug_pub.add('first index'|| i,5);

1488:
1489: i := P_tab_of_rec.FIRST;
1490:
1491: IF PG_DEBUG <> 0 THEN
1492: oe_debug_pub.add('first index'|| i,5);
1493: END IF;
1494:
1495: lStmtNum:=20;
1496: LOOP

Line 1502: oe_debug_pub.add('populate_parent_ato: ' || 'present index=>'

1498: v_src_point := i ;
1499:
1500:
1501: IF PG_DEBUG <> 0 THEN
1502: oe_debug_pub.add('populate_parent_ato: ' || 'present index=>'
1503: || v_src_point,5);
1504: oe_debug_pub.add('populate_parent_ato: ' || 'ato line => '
1505: ||P_tab_of_rec(v_src_point).ato_line_id,5);
1506: oe_debug_pub.add('populate_parent_ato: ' || 'top line => '

Line 1504: oe_debug_pub.add('populate_parent_ato: ' || 'ato line => '

1500:
1501: IF PG_DEBUG <> 0 THEN
1502: oe_debug_pub.add('populate_parent_ato: ' || 'present index=>'
1503: || v_src_point,5);
1504: oe_debug_pub.add('populate_parent_ato: ' || 'ato line => '
1505: ||P_tab_of_rec(v_src_point).ato_line_id,5);
1506: oe_debug_pub.add('populate_parent_ato: ' || 'top line => '
1507: ||P_tab_of_rec(v_src_point).top_model_line_id,5);
1508:

Line 1506: oe_debug_pub.add('populate_parent_ato: ' || 'top line => '

1502: oe_debug_pub.add('populate_parent_ato: ' || 'present index=>'
1503: || v_src_point,5);
1504: oe_debug_pub.add('populate_parent_ato: ' || 'ato line => '
1505: ||P_tab_of_rec(v_src_point).ato_line_id,5);
1506: oe_debug_pub.add('populate_parent_ato: ' || 'top line => '
1507: ||P_tab_of_rec(v_src_point).top_model_line_id,5);
1508:
1509: END IF;
1510:

Line 1518: oe_debug_pub.add('populate_parent_ato: ' || ' processing '

1514: --filters out any individual embedded ato lines
1515: P_tab_of_rec(v_src_point).top_model_line_id is not null) THEN
1516:
1517: IF PG_DEBUG <> 0 THEN
1518: oe_debug_pub.add('populate_parent_ato: ' || ' processing '
1519: || to_char( v_src_point ) , 4 );
1520: END IF;
1521:
1522: /*

Line 1536: oe_debug_pub.add('populate_parent_ato: ' || 'top_most ato parent '

1532: P_tab_of_rec(v_src_point).ato_line_id )
1533: THEN
1534:
1535: IF PG_DEBUG <> 0 THEN
1536: oe_debug_pub.add('populate_parent_ato: ' || 'top_most ato parent '
1537: || to_char( v_src_point ),5);
1538: END IF;
1539: exit ;
1540: END IF ;

Line 1580: oe_debug_pub.add('populate_parent_ato: ' || v_raw_line_id(j)||

1576: P_tab_of_rec(v_raw_line_id(j)).parent_ato_line_id := v_src_point ;
1577:
1578:
1579: IF PG_DEBUG <> 0 THEN
1580: oe_debug_pub.add('populate_parent_ato: ' || v_raw_line_id(j)||
1581: ' parent '||v_src_point,5 );
1582: END IF;
1583:
1584: j := j -1 ;

Line 1600: oe_debug_pub.add('populate_parent_ato: ' || 'next index=>'|| i,5);

1596: i := P_tab_of_rec.next(i);
1597:
1598:
1599: IF PG_DEBUG <> 0 THEN
1600: oe_debug_pub.add('populate_parent_ato: ' || 'next index=>'|| i,5);
1601: END IF;
1602:
1603:
1604: END LOOP ; --end of first while

Line 1610: oe_debug_pub.add('--parent_ato_line_id--',5);

1606:
1607:
1608:
1609: IF PG_DEBUG <> 0 THEN
1610: oe_debug_pub.add('--parent_ato_line_id--',5);
1611: oe_debug_pub.add(' Line_id '||' => '||' parent_ato_line_id ',5);
1612:
1613: i := P_tab_of_rec.first;
1614: WHILE i is not null

Line 1611: oe_debug_pub.add(' Line_id '||' => '||' parent_ato_line_id ',5);

1607:
1608:
1609: IF PG_DEBUG <> 0 THEN
1610: oe_debug_pub.add('--parent_ato_line_id--',5);
1611: oe_debug_pub.add(' Line_id '||' => '||' parent_ato_line_id ',5);
1612:
1613: i := P_tab_of_rec.first;
1614: WHILE i is not null
1615: LOOP

Line 1616: oe_debug_pub.add(i||' => '||P_tab_of_rec(i).parent_ato_line_id,5);

1612:
1613: i := P_tab_of_rec.first;
1614: WHILE i is not null
1615: LOOP
1616: oe_debug_pub.add(i||' => '||P_tab_of_rec(i).parent_ato_line_id,5);
1617: i := P_tab_of_rec.NEXT(i);
1618: END LOOP;
1619:
1620: END IF;

Line 1646: oe_debug_pub.add('populate_parent_ato: ' || ' processing '

1642: --filters out any individual embedded ato lines
1643: P_tab_of_rec(v_src_point).top_model_line_id is not null) THEN
1644:
1645: IF PG_DEBUG <> 0 THEN
1646: oe_debug_pub.add('populate_parent_ato: ' || ' processing '
1647: || to_char( v_src_point ) , 4 );
1648: END IF;
1649: /*
1650: ** resolve parent ato line id for item.

Line 1720: oe_debug_pub.add('--gop parent_ato_line_id--',5);

1716:
1717:
1718:
1719: IF PG_DEBUG <> 0 THEN
1720: oe_debug_pub.add('--gop parent_ato_line_id--',5);
1721: oe_debug_pub.add(' Line_id '||' => '||' gop parent_ato_line_id ',5);
1722: i := P_tab_of_rec.first;
1723: WHILE i is not null
1724: LOOP

Line 1721: oe_debug_pub.add(' Line_id '||' => '||' gop parent_ato_line_id ',5);

1717:
1718:
1719: IF PG_DEBUG <> 0 THEN
1720: oe_debug_pub.add('--gop parent_ato_line_id--',5);
1721: oe_debug_pub.add(' Line_id '||' => '||' gop parent_ato_line_id ',5);
1722: i := P_tab_of_rec.first;
1723: WHILE i is not null
1724: LOOP
1725: oe_debug_pub.add(i||' => '||P_tab_of_rec(i).gop_parent_ato_line_id,5);

Line 1725: oe_debug_pub.add(i||' => '||P_tab_of_rec(i).gop_parent_ato_line_id,5);

1721: oe_debug_pub.add(' Line_id '||' => '||' gop parent_ato_line_id ',5);
1722: i := P_tab_of_rec.first;
1723: WHILE i is not null
1724: LOOP
1725: oe_debug_pub.add(i||' => '||P_tab_of_rec(i).gop_parent_ato_line_id,5);
1726: i := P_tab_of_rec.NEXT(i);
1727: END LOOP;
1728: END IF;--p debug
1729:

Line 1736: oe_debug_pub.add('populate_parent_ato: ' || 'Others Exception in stmt num: '

1732: EXCEPTION
1733: WHEN others THEN
1734:
1735: IF PG_DEBUG <> 0 THEN
1736: oe_debug_pub.add('populate_parent_ato: ' || 'Others Exception in stmt num: '
1737: || to_char(lStmtNum), 1);
1738: oe_debug_pub.add('errmsg'||sqlerrm,5);
1739: END IF;
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1738: oe_debug_pub.add('errmsg'||sqlerrm,5);

1734:
1735: IF PG_DEBUG <> 0 THEN
1736: oe_debug_pub.add('populate_parent_ato: ' || 'Others Exception in stmt num: '
1737: || to_char(lStmtNum), 1);
1738: oe_debug_pub.add('errmsg'||sqlerrm,5);
1739: END IF;
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: -- Get message count and data
1742: cto_msg_pub.count_and_get

Line 1771: oe_debug_pub.add('Entered populate_plan_level',5);

1767: begin
1768:
1769: x_return_status := FND_API.G_RET_STS_SUCCESS;
1770: IF PG_DEBUG <> 0 THEN
1771: oe_debug_pub.add('Entered populate_plan_level',5);
1772: END IF;
1773:
1774: /*
1775: ** Strategy: Resolve plan_level for each line item by setting it to 1 + plan_level of parent.

Line 1850: oe_debug_pub.add('--plan level--',5);

1846:
1847:
1848:
1849: IF PG_DEBUG <> 0 THEN
1850: oe_debug_pub.add('--plan level--',5);
1851: oe_debug_pub.add(' Line_id '||' => '||' plan_level ',5);
1852: i := P_tab_of_rec.first;
1853: WHILE i is not null
1854: LOOP

Line 1851: oe_debug_pub.add(' Line_id '||' => '||' plan_level ',5);

1847:
1848:
1849: IF PG_DEBUG <> 0 THEN
1850: oe_debug_pub.add('--plan level--',5);
1851: oe_debug_pub.add(' Line_id '||' => '||' plan_level ',5);
1852: i := P_tab_of_rec.first;
1853: WHILE i is not null
1854: LOOP
1855: oe_debug_pub.add(i||' => '||P_tab_of_rec(i).plan_level,5);

Line 1855: oe_debug_pub.add(i||' => '||P_tab_of_rec(i).plan_level,5);

1851: oe_debug_pub.add(' Line_id '||' => '||' plan_level ',5);
1852: i := P_tab_of_rec.first;
1853: WHILE i is not null
1854: LOOP
1855: oe_debug_pub.add(i||' => '||P_tab_of_rec(i).plan_level,5);
1856: i := P_tab_of_rec.NEXT(i);
1857: END LOOP;
1858:
1859: END IF;

Line 1865: oe_debug_pub.add('populate_plan_level : ' || 'Others Exception in stmt num: '

1861: EXCEPTION
1862: WHEN others THEN
1863:
1864: IF PG_DEBUG <> 0 THEN
1865: oe_debug_pub.add('populate_plan_level : ' || 'Others Exception in stmt num: '
1866: || to_char(lStmtNum), 1);
1867: oe_debug_pub.add('errmsg'||sqlerrm,5);
1868: END IF;
1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1867: oe_debug_pub.add('errmsg'||sqlerrm,5);

1863:
1864: IF PG_DEBUG <> 0 THEN
1865: oe_debug_pub.add('populate_plan_level : ' || 'Others Exception in stmt num: '
1866: || to_char(lStmtNum), 1);
1867: oe_debug_pub.add('errmsg'||sqlerrm,5);
1868: END IF;
1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1870: -- Get message count and data
1871: cto_msg_pub.count_and_get

Line 1930: oe_debug_pub.add('Entered perform_match for =>'|| p_ato_line_id

1926: BEGIN
1927:
1928:
1929: /*IF PG_DEBUG <> 0 THEN
1930: oe_debug_pub.add('Entered perform_match for =>'|| p_ato_line_id
1931: ||'custm prof=>'||p_custom_match_profile,1);
1932: END IF;*/
1933: x_return_status := FND_API.G_RET_STS_SUCCESS;
1934:

Line 1949: oe_debug_pub.add(' perform_match flag =>'||lPerformMatch

1945:
1946:
1947:
1948: IF PG_DEBUG <> 0 THEN
1949: oe_debug_pub.add(' perform_match flag =>'||lPerformMatch
1950: ||'for line_id =>'||lNextRec.line_id,5
1951: );
1952: END IF;
1953:

Line 1978: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: start time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);

1974:
1975: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: start time: ' ||
1976: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));*/
1977: IF PG_DEBUG <> 0 THEN
1978: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: start time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
1979: END IF; --Bugfix 6452747
1980:
1981: CTO_UTILITY_PK.lock_for_match(
1982: x_return_status => x_return_status,

Line 1992: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: end time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);

1988:
1989: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: end time: ' ||
1990: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));*/
1991: IF PG_DEBUG <> 0 THEN
1992: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: end time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
1993: END IF; --Bugfix 6452747
1994:
1995: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1996: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');

Line 1996: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');

1992: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: end time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
1993: END IF; --Bugfix 6452747
1994:
1995: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1996: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1997: raise fnd_api.g_exc_unexpected_error;
1998: end if;
1999:
2000: --check for error cases

Line 2003: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');

1999:
2000: --check for error cases
2001: if ( l_lock_status <> 0 ) THEN
2002: if (l_lock_status = 1) then -- timeout
2003: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');
2004: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
2005: raise fnd_api.g_exc_unexpected_error;
2006:
2007: elsif (l_lock_status = 2) then -- deadlock

Line 2008: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');

2004: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
2005: raise fnd_api.g_exc_unexpected_error;
2006:
2007: elsif (l_lock_status = 2) then -- deadlock
2008: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
2009: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
2010: raise fnd_api.g_exc_unexpected_error;
2011:
2012: elsif (l_lock_status = 3) then -- parameter error

Line 2013: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');

2009: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
2010: raise fnd_api.g_exc_unexpected_error;
2011:
2012: elsif (l_lock_status = 3) then -- parameter error
2013: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
2014: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
2015: raise fnd_api.g_exc_unexpected_error;
2016:
2017: elsif (l_lock_status = 4) then -- already locked.

Line 2018: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');

2014: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
2015: raise fnd_api.g_exc_unexpected_error;
2016:
2017: elsif (l_lock_status = 4) then -- already locked.
2018: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');
2019: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');
2020: -- we shall not raise an error if we are already holding the lock.
2021:
2022: else -- internal error - not fault of user

Line 2023: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');

2019: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');
2020: -- we shall not raise an error if we are already holding the lock.
2021:
2022: else -- internal error - not fault of user
2023: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');
2024: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');
2025: raise fnd_api.g_exc_unexpected_error;
2026: end if;
2027: else

Line 2029: oe_debug_pub.add('match_and_create_all_items: ' || 'Successfully obtained lock for match.');

2025: raise fnd_api.g_exc_unexpected_error;
2026: end if;
2027: else
2028: IF PG_DEBUG <> 0 THEN
2029: oe_debug_pub.add('match_and_create_all_items: ' || 'Successfully obtained lock for match.');
2030: END IF;
2031:
2032: end if;
2033: END IF;

Line 2054: oe_debug_pub.add('match_and_create_all_items: ' || 'Custom Match.', 1);

2050: raise fnd_api.g_exc_error;
2051: end if;
2052: ELSIF lPerformMatch = 'C' THEN
2053: IF PG_DEBUG <> 0 THEN
2054: oe_debug_pub.add('match_and_create_all_items: ' || 'Custom Match.', 1);
2055: END IF;
2056:
2057: lStmtNum:=50;
2058: lStatus := CTO_CUSTOM_MATCH_PK.find_matching_config(

Line 2082: oe_debug_pub.add('perform_match: ' || 'updated to U : ' || to_char(lNextRec.Line_Id), 1);

2078: where line_id = lNextRec.line_id
2079: and perform_match in ('Y','C');
2080: -- if the update fails, its not an error
2081:
2082: oe_debug_pub.add('perform_match: ' || 'updated to U : ' || to_char(lNextRec.Line_Id), 1);
2083:
2084: oe_debug_pub.add('perform_match: ' || 'rowcount : ' || to_char(sql%rowcount), 1);
2085:
2086: lStmtNum:=70;

Line 2084: oe_debug_pub.add('perform_match: ' || 'rowcount : ' || to_char(sql%rowcount), 1);

2080: -- if the update fails, its not an error
2081:
2082: oe_debug_pub.add('perform_match: ' || 'updated to U : ' || to_char(lNextRec.Line_Id), 1);
2083:
2084: oe_debug_pub.add('perform_match: ' || 'rowcount : ' || to_char(sql%rowcount), 1);
2085:
2086: lStmtNum:=70;
2087: update bom_cto_order_lines_gt
2088: set perform_match = 'U'

Line 2093: oe_debug_pub.add('perform_match: ' || 'updated to U : ' || to_char(lNextRec.parent_ato_Line_Id), 1);

2089: where line_id = lNextRec.parent_ato_line_id
2090: and perform_match in ( 'Y','C');
2091: -- if the update fails, its not an error
2092:
2093: oe_debug_pub.add('perform_match: ' || 'updated to U : ' || to_char(lNextRec.parent_ato_Line_Id), 1);
2094:
2095: oe_debug_pub.add('perform_match: ' || 'rowcount : ' || to_char(sql%rowcount), 1);
2096:
2097: elsif (lStatus = 1 and lXConfigId is not null) then

Line 2095: oe_debug_pub.add('perform_match: ' || 'rowcount : ' || to_char(sql%rowcount), 1);

2091: -- if the update fails, its not an error
2092:
2093: oe_debug_pub.add('perform_match: ' || 'updated to U : ' || to_char(lNextRec.parent_ato_Line_Id), 1);
2094:
2095: oe_debug_pub.add('perform_match: ' || 'rowcount : ' || to_char(sql%rowcount), 1);
2096:
2097: elsif (lStatus = 1 and lXConfigId is not null) then
2098:
2099:

Line 2111: oe_debug_pub.add('match_and_create_all_items: ' || 'Match found for line ' ||

2107: -- Release the lock if match found rather than wait for commit/rollback.
2108: --
2109:
2110: IF PG_DEBUG <> 0 THEN
2111: oe_debug_pub.add('match_and_create_all_items: ' || 'Match found for line ' ||
2112: to_char(lNextRec.line_id) ||
2113: ' with config item ' ||
2114: to_char(lXConfigId), 1);
2115: END IF;

Line 2124: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');

2120: x_Msg_Data => x_msg_data,
2121: p_hash_value => l_hash_value);
2122:
2123: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2124: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
2125: raise fnd_api.g_exc_unexpected_error;
2126: end if;
2127:
2128: --

Line 2168: oe_debug_pub.add('perform_match: ' || 'Updated possible similar models to Y : '

2164:
2165:
2166:
2167:
2168: oe_debug_pub.add('perform_match: ' || 'Updated possible similar models to Y : '
2169: || to_char(sql%rowcount), 1);
2170:
2171:
2172:

Line 2180: oe_debug_pub.add('perform_match: ' || 'Exception in stmt num: '

2176:
2177: EXCEPTION
2178: WHEN fnd_api.g_exc_error THEN
2179: IF PG_DEBUG <> 0 THEN
2180: oe_debug_pub.add('perform_match: ' || 'Exception in stmt num: '
2181: || to_char(lStmtNum), 1);
2182: END IF;
2183: x_return_status := FND_API.G_RET_STS_ERROR;
2184: -- Get message count and data

Line 2191: oe_debug_pub.add('perform_match: ' || ' Unexpected Exception in stmt num: '

2187: , p_msg_data => x_msg_data
2188: );
2189: WHEN fnd_api.g_exc_unexpected_error THEN
2190: IF PG_DEBUG <> 0 THEN
2191: oe_debug_pub.add('perform_match: ' || ' Unexpected Exception in stmt num: '
2192: || to_char(lStmtNum), 1);
2193: END IF;
2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2195: -- Get message count and data

Line 2203: oe_debug_pub.add('perform_match: ' || 'Others Exception in stmt num: '

2199: );
2200: WHEN OTHERS then
2201:
2202: IF PG_DEBUG <> 0 THEN
2203: oe_debug_pub.add('perform_match: ' || 'Others Exception in stmt num: '
2204: || to_char(lStmtNum), 1);
2205: oe_debug_pub.add('errmsg'||sqlerrm,1);
2206: END IF;
2207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2205: oe_debug_pub.add('errmsg'||sqlerrm,1);

2201:
2202: IF PG_DEBUG <> 0 THEN
2203: oe_debug_pub.add('perform_match: ' || 'Others Exception in stmt num: '
2204: || to_char(lStmtNum), 1);
2205: oe_debug_pub.add('errmsg'||sqlerrm,1);
2206: END IF;
2207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2208: -- Get message count and data
2209: cto_msg_pub.count_and_get

Line 2258: oe_debug_pub.add('flag_reuse_config: ' || ' Unexpected Exception in stmt num: '

2254:
2255: EXCEPTION
2256: WHEN fnd_api.g_exc_unexpected_error THEN
2257: IF PG_DEBUG <> 0 THEN
2258: oe_debug_pub.add('flag_reuse_config: ' || ' Unexpected Exception in stmt num: '
2259: || to_char(lStmtNum), 1);
2260: END IF;
2261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2262: /*-- Get message count and data

Line 2272: oe_debug_pub.add('flag_reuse_config: ' || 'Others Exception in stmt num: '

2268: WHEN OTHERS then
2269:
2270: IF PG_DEBUG <> 0 THEN
2271:
2272: oe_debug_pub.add('flag_reuse_config: ' || 'Others Exception in stmt num: '
2273: || to_char(lStmtNum), 1);
2274: oe_debug_pub.add('error='||sqlerrm,1);
2275:
2276: END IF;

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

2270: IF PG_DEBUG <> 0 THEN
2271:
2272: oe_debug_pub.add('flag_reuse_config: ' || 'Others Exception in stmt num: '
2273: || to_char(lStmtNum), 1);
2274: oe_debug_pub.add('error='||sqlerrm,1);
2275:
2276: END IF;
2277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2278:

Line 2368: oe_debug_pub.add('ENTERED reuse configuration',5);

2364: BEGIN
2365:
2366:
2367: IF PG_DEBUG <> 0 THEN
2368: oe_debug_pub.add('ENTERED reuse configuration',5);
2369: END IF;
2370: x_return_status := FND_API.G_RET_STS_SUCCESS;
2371:
2372:

Line 2379: oe_debug_pub.add('reuse for ato line=>'||p_ato_line_id,1);

2375: IF p_ato_line_id IS NOT NULL THEN
2376:
2377:
2378: IF PG_DEBUG <> 0 THEN
2379: oe_debug_pub.add('reuse for ato line=>'||p_ato_line_id,1);
2380: END IF;
2381:
2382: lStmtNum := 20;
2383:

Line 2406: oe_debug_pub.add('LINE_ID >>QTY_PER_PARENT_MODEL',5);

2402: l_qty_per_parent_model
2403: FROM bom_cto_order_lines_gt
2404: WHERE ato_line_id = p_ato_line_id;
2405:
2406: oe_debug_pub.add('LINE_ID >>QTY_PER_PARENT_MODEL',5);
2407:
2408: FOR i in l_temp_line_id.first..l_temp_line_id.last LOOP
2409:
2410: oe_debug_pub.add(l_temp_line_id(i)||'>>'||l_qty_per_parent_model(i),5);

Line 2410: oe_debug_pub.add(l_temp_line_id(i)||'>>'||l_qty_per_parent_model(i),5);

2406: oe_debug_pub.add('LINE_ID >>QTY_PER_PARENT_MODEL',5);
2407:
2408: FOR i in l_temp_line_id.first..l_temp_line_id.last LOOP
2409:
2410: oe_debug_pub.add(l_temp_line_id(i)||'>>'||l_qty_per_parent_model(i),5);
2411:
2412: END LOOP;
2413:
2414: oe_debug_pub.add('Picture of bcol_gt before reuse process',5);

Line 2414: oe_debug_pub.add('Picture of bcol_gt before reuse process',5);

2410: oe_debug_pub.add(l_temp_line_id(i)||'>>'||l_qty_per_parent_model(i),5);
2411:
2412: END LOOP;
2413:
2414: oe_debug_pub.add('Picture of bcol_gt before reuse process',5);
2415:
2416: FOR kiran_rec in c_gt_intial_pic
2417: LOOP
2418: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);

Line 2418: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);

2414: oe_debug_pub.add('Picture of bcol_gt before reuse process',5);
2415:
2416: FOR kiran_rec in c_gt_intial_pic
2417: LOOP
2418: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);
2419: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);
2420: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2421: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2422: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);

Line 2419: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);

2415:
2416: FOR kiran_rec in c_gt_intial_pic
2417: LOOP
2418: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);
2419: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);
2420: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2421: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2422: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);
2423: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);

Line 2420: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);

2416: FOR kiran_rec in c_gt_intial_pic
2417: LOOP
2418: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);
2419: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);
2420: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2421: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2422: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);
2423: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);
2424: oe_debug_pub.add('reuse=>'||kiran_rec.reuse_config,5);

Line 2421: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);

2417: LOOP
2418: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);
2419: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);
2420: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2421: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2422: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);
2423: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);
2424: oe_debug_pub.add('reuse=>'||kiran_rec.reuse_config,5);
2425:

Line 2422: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);

2418: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);
2419: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);
2420: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2421: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2422: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);
2423: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);
2424: oe_debug_pub.add('reuse=>'||kiran_rec.reuse_config,5);
2425:
2426: END LOOP;

Line 2423: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);

2419: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);
2420: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2421: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2422: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);
2423: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);
2424: oe_debug_pub.add('reuse=>'||kiran_rec.reuse_config,5);
2425:
2426: END LOOP;
2427:

Line 2424: oe_debug_pub.add('reuse=>'||kiran_rec.reuse_config,5);

2420: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2421: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2422: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);
2423: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);
2424: oe_debug_pub.add('reuse=>'||kiran_rec.reuse_config,5);
2425:
2426: END LOOP;
2427:
2428:

Line 2437: oe_debug_pub.add('reuse configuration BULK call',1);

2433: ELSE --bulk call
2434:
2435:
2436: IF PG_DEBUG <> 0 THEN
2437: oe_debug_pub.add('reuse configuration BULK call',1);
2438: END IF;
2439:
2440:
2441: lStmtNum := 40;

Line 2461: oe_debug_pub.add('IF count>1, re-use called for more than 1 order line',5);

2457:
2458:
2459:
2460: IF PG_DEBUG <> 0 THEN
2461: oe_debug_pub.add('IF count>1, re-use called for more than 1 order line',5);
2462: oe_debug_pub.add('l_ato_line_tbl.count=>'||l_ato_line_tbl.count,5);
2463: END IF;
2464:
2465:

Line 2462: oe_debug_pub.add('l_ato_line_tbl.count=>'||l_ato_line_tbl.count,5);

2458:
2459:
2460: IF PG_DEBUG <> 0 THEN
2461: oe_debug_pub.add('IF count>1, re-use called for more than 1 order line',5);
2462: oe_debug_pub.add('l_ato_line_tbl.count=>'||l_ato_line_tbl.count,5);
2463: END IF;
2464:
2465:
2466: IF l_ato_line_tbl.count > 0 THEN

Line 2488: oe_debug_pub.add('Updating bcol (permanent table) with qty per parent model',5);

2484:
2485: IF l_bcol_ato_line_tbl.count > 0 THEN
2486:
2487: IF PG_DEBUG <> 0 THEN
2488: oe_debug_pub.add('Updating bcol (permanent table) with qty per parent model',5);
2489:
2490: END IF;
2491:
2492: FORALL j IN 1..l_bcol_ato_line_tbl.last

Line 2589: oe_debug_pub.add('Some UN-reusable parent ato lines have been identified',5);

2585:
2586:
2587:
2588: IF PG_DEBUG <> 0 THEN
2589: oe_debug_pub.add('Some UN-reusable parent ato lines have been identified',5);
2590: FOR p_ato_idx in l_parent_ato_line_tbl.first..l_parent_ato_line_tbl.last
2591: LOOP
2592: oe_debug_pub.add('kiran'||l_parent_ato_line_tbl(p_ato_idx),5);
2593: END LOOP;

Line 2592: oe_debug_pub.add('kiran'||l_parent_ato_line_tbl(p_ato_idx),5);

2588: IF PG_DEBUG <> 0 THEN
2589: oe_debug_pub.add('Some UN-reusable parent ato lines have been identified',5);
2590: FOR p_ato_idx in l_parent_ato_line_tbl.first..l_parent_ato_line_tbl.last
2591: LOOP
2592: oe_debug_pub.add('kiran'||l_parent_ato_line_tbl(p_ato_idx),5);
2593: END LOOP;
2594: END IF;
2595:
2596:

Line 2612: oe_debug_pub.add('LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).line_id,5);

2608: g_reuse_tbl(bcol_rec.line_id).parent_ato_line_id := bcol_rec.parent_ato_line_id;
2609: g_reuse_tbl(bcol_rec.line_id).reuse_config := bcol_rec.reuse_config;
2610:
2611: IF PG_DEBUG <> 0 THEN
2612: oe_debug_pub.add('LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).line_id,5);
2613: oe_debug_pub.add('PARENT_ATO_LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).parent_ato_line_id,5);
2614: oe_debug_pub.add('REUSE_CONFIG_from_GT=>'||g_reuse_tbl(bcol_rec.line_id).reuse_config,5);
2615:
2616: END IF;

Line 2613: oe_debug_pub.add('PARENT_ATO_LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).parent_ato_line_id,5);

2609: g_reuse_tbl(bcol_rec.line_id).reuse_config := bcol_rec.reuse_config;
2610:
2611: IF PG_DEBUG <> 0 THEN
2612: oe_debug_pub.add('LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).line_id,5);
2613: oe_debug_pub.add('PARENT_ATO_LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).parent_ato_line_id,5);
2614: oe_debug_pub.add('REUSE_CONFIG_from_GT=>'||g_reuse_tbl(bcol_rec.line_id).reuse_config,5);
2615:
2616: END IF;
2617:

Line 2614: oe_debug_pub.add('REUSE_CONFIG_from_GT=>'||g_reuse_tbl(bcol_rec.line_id).reuse_config,5);

2610:
2611: IF PG_DEBUG <> 0 THEN
2612: oe_debug_pub.add('LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).line_id,5);
2613: oe_debug_pub.add('PARENT_ATO_LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).parent_ato_line_id,5);
2614: oe_debug_pub.add('REUSE_CONFIG_from_GT=>'||g_reuse_tbl(bcol_rec.line_id).reuse_config,5);
2615:
2616: END IF;
2617:
2618: End Loop;

Line 2648: oe_debug_pub.add('calling flag_reuse_config for model_line_id=>'

2644: --OR previous element might have updated reuse to N
2645: IF g_reuse_tbl(l_parent_ato_line_tbl(i)).reuse_config= 'Y' THEN
2646:
2647: IF PG_DEBUG <> 0 THEN
2648: oe_debug_pub.add('calling flag_reuse_config for model_line_id=>'
2649: ||l_parent_ato_line_tbl(i),5);
2650: END IF;
2651:
2652: lStmtNum:= 110;

Line 2668: oe_debug_pub.add('updating reuse_flag to N for following model lines =>',5);

2664:
2665: IF g_model_line_tbl.EXISTS(1) THEN
2666:
2667: IF PG_DEBUG <> 0 THEN
2668: oe_debug_pub.add('updating reuse_flag to N for following model lines =>',5);
2669: END IF;
2670:
2671: FOR i IN g_model_line_tbl.FIRST..g_model_line_tbl.LAST LOOP
2672: IF PG_DEBUG <> 0 THEN

Line 2673: oe_debug_pub.add(g_model_line_tbl(i),5);

2669: END IF;
2670:
2671: FOR i IN g_model_line_tbl.FIRST..g_model_line_tbl.LAST LOOP
2672: IF PG_DEBUG <> 0 THEN
2673: oe_debug_pub.add(g_model_line_tbl(i),5);
2674: END IF;
2675:
2676: END LOOP;
2677:

Line 2688: oe_debug_pub.add('All parent ato lines are re-usable',5);--5 level

2684: ELSE
2685:
2686:
2687: -- IF PG_DEBUG <> 0 THEN
2688: oe_debug_pub.add('All parent ato lines are re-usable',5);--5 level
2689: -- END IF;
2690: END IF; -- l_parent_ato_line_tbl.EXISTS(1)
2691:
2692: lStmtNum:=130;

Line 2744: Oe_debug_pub.add('LINE_ID--'||'reuse_config--'||

2740:
2741: END IF;--if l_ato_line_tbl.count is > 0)
2742:
2743: IF PG_DEBUG = 5 THEN
2744: Oe_debug_pub.add('LINE_ID--'||'reuse_config--'||
2745: 'CONFIG_ITEM_ID--' ||'qty_per_parent_model--'
2746: ||'CIB--'||'ship_from_org--'||'validation_org');
2747: FOR debug_rec in c_debug
2748: LOOP

Line 2749: oe_debug_pub.add(debug_rec.line_id||'--'||debug_rec.reuse_config||'--'||

2745: 'CONFIG_ITEM_ID--' ||'qty_per_parent_model--'
2746: ||'CIB--'||'ship_from_org--'||'validation_org');
2747: FOR debug_rec in c_debug
2748: LOOP
2749: oe_debug_pub.add(debug_rec.line_id||'--'||debug_rec.reuse_config||'--'||
2750: debug_rec.config_item_id||'--'||debug_rec.qty_per_parent_model||'--'||
2751: debug_rec.config_creation||'--'||debug_rec.ship_from_org_id||'--'||
2752: debug_rec.validation_org
2753: ,5);

Line 2762: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Exception in stmt num: '

2758: EXCEPTION
2759:
2760: WHEN fnd_api.g_exc_error THEN
2761: IF PG_DEBUG <> 0 THEN
2762: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Exception in stmt num: '
2763: || to_char(lStmtNum), 1);
2764: END IF;
2765: x_return_status := FND_API.G_RET_STS_ERROR;
2766: -- Get message count and data

Line 2773: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || ' Unexpected Exception in stmt num: '

2769: , p_msg_data => x_msg_data
2770: );
2771: WHEN fnd_api.g_exc_unexpected_error THEN
2772: IF PG_DEBUG <> 0 THEN
2773: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || ' Unexpected Exception in stmt num: '
2774: || to_char(lStmtNum), 1);
2775: END IF;
2776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2777: -- Get message count and data

Line 2786: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Others Exception in stmt num: '

2782: WHEN OTHERS then
2783:
2784:
2785: IF PG_DEBUG <> 0 THEN
2786: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Others Exception in stmt num: '
2787: || to_char(lStmtNum), 1);
2788: oe_debug_pub.add('errmsg =>'||sqlerrm,1);
2789: END IF;
2790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2788: oe_debug_pub.add('errmsg =>'||sqlerrm,1);

2784:
2785: IF PG_DEBUG <> 0 THEN
2786: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Others Exception in stmt num: '
2787: || to_char(lStmtNum), 1);
2788: oe_debug_pub.add('errmsg =>'||sqlerrm,1);
2789: END IF;
2790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2791: -- Get message count and data
2792: cto_msg_pub.count_and_get

Line 2848: oe_debug_pub.add('rowcount after update from bic=>'||sql%rowcount,5);

2844: )
2845: where bcol.ato_line_id <>bcol.line_id;
2846:
2847:
2848: oe_debug_pub.add('rowcount after update from bic=>'||sql%rowcount,5);
2849:
2850:
2851: --rowcount after insert of bom_item_type and wip_supply_type is l_rowcount;
2852:

Line 2862: oe_debug_pub.add('rowcount after select for BIT,WST=>'||sql%rowcount,5);

2858: p_match_rec_of_tab.bom_item_type,
2859: p_match_rec_of_tab.wip_supply_type
2860: FROM bom_cto_order_lines_gt;
2861:
2862: oe_debug_pub.add('rowcount after select for BIT,WST=>'||sql%rowcount,5);
2863:
2864: --rowcount of bom_itemtype,wip_supply_typ after select l_rowcount;
2865: lStmtNum:=40;
2866: xfer_tab_to_rec(

Line 2875: oe_debug_pub.add('SUCCESS after xfer_tab_to_rec',5);

2871: x_msg_data
2872: );
2873:
2874: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2875: oe_debug_pub.add('SUCCESS after xfer_tab_to_rec',5);
2876:
2877: --add retrun status and error mesages to these
2878: lStmtNum:=50;
2879: populate_parent_ato(

Line 2887: oe_debug_pub.add('status after after xfer_tab_to_rec=>'

2883: x_msg_count => x_msg_count,
2884: x_msg_data => x_msg_data );
2885:
2886: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2887: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2888: || FND_API.G_RET_STS_ERROR,5);
2889: RAISE fnd_api.g_exc_error;
2890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2891: oe_debug_pub.add('status after after xfer_tab_to_rec=>'

Line 2891: oe_debug_pub.add('status after after xfer_tab_to_rec=>'

2887: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2888: || FND_API.G_RET_STS_ERROR,5);
2889: RAISE fnd_api.g_exc_error;
2890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2891: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2892: || FND_API.G_RET_STS_UNEXP_ERROR,5);
2893: RAISE fnd_api.g_exc_unexpected_error;
2894: END IF;
2895:

Line 2899: oe_debug_pub.add('SUCCESS after populate_parent_ato=>');

2895:
2896:
2897:
2898: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2899: oe_debug_pub.add('SUCCESS after populate_parent_ato=>');
2900: lStmtNum:=60;
2901: populate_plan_level( P_tab_of_rec => l_tab_of_rec,
2902: x_return_status => x_return_status,
2903: x_msg_count => x_msg_count,

Line 2906: oe_debug_pub.add('status after after populate_parent_ato=>'

2902: x_return_status => x_return_status,
2903: x_msg_count => x_msg_count,
2904: x_msg_data => x_msg_data );
2905: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2906: oe_debug_pub.add('status after after populate_parent_ato=>'
2907: || FND_API.G_RET_STS_ERROR);
2908: RAISE fnd_api.g_exc_error;
2909: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2910: oe_debug_pub.add('status after after populate_parent_ato=>'

Line 2910: oe_debug_pub.add('status after after populate_parent_ato=>'

2906: oe_debug_pub.add('status after after populate_parent_ato=>'
2907: || FND_API.G_RET_STS_ERROR);
2908: RAISE fnd_api.g_exc_error;
2909: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2910: oe_debug_pub.add('status after after populate_parent_ato=>'
2911: || FND_API.G_RET_STS_UNEXP_ERROR );
2912: RAISE fnd_api.g_exc_unexpected_error;
2913: END IF;
2914:

Line 2918: oe_debug_pub.add('SUCCESS after populate_plan_level=>');

2914:
2915:
2916:
2917: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2918: oe_debug_pub.add('SUCCESS after populate_plan_level=>');
2919:
2920: lStmtNum:=70;
2921: xfer_rec_to_tab(
2922: p_tab_of_rec => l_tab_of_rec ,

Line 2930: oe_debug_pub.add('status after after populate_plan_level=>'

2926: x_msg_data => x_msg_data
2927: );
2928:
2929: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2930: oe_debug_pub.add('status after after populate_plan_level=>'
2931: || FND_API.G_RET_STS_ERROR);
2932: RAISE fnd_api.g_exc_error;
2933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2934: oe_debug_pub.add('status after after populate_plan_level=>'

Line 2934: oe_debug_pub.add('status after after populate_plan_level=>'

2930: oe_debug_pub.add('status after after populate_plan_level=>'
2931: || FND_API.G_RET_STS_ERROR);
2932: RAISE fnd_api.g_exc_error;
2933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2934: oe_debug_pub.add('status after after populate_plan_level=>'
2935: || FND_API.G_RET_STS_UNEXP_ERROR );
2936: RAISE fnd_api.g_exc_unexpected_error;
2937: END IF;
2938:

Line 2941: oe_debug_pub.add('SUCCESS after xfer_rec_to_tabl=>');

2937: END IF;
2938:
2939:
2940: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2941: oe_debug_pub.add('SUCCESS after xfer_rec_to_tabl=>');
2942:
2943: lStmtNum:=80;
2944: --update the remaining columns into bcol_temp
2945:

Line 2954: oe_debug_pub.add('status after after xfer_rec_to_tab=>'

2950: PLAN_LEVEL = p_match_rec_of_tab.PLAN_LEVEL (i)
2951: WHERE line_id = p_match_rec_of_tab.LINE_ID(i);
2952:
2953: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2954: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2955: || FND_API.G_RET_STS_ERROR);
2956: RAISE fnd_api.g_exc_error;
2957: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2958: oe_debug_pub.add('status after after xfer_rec_to_tab=>'

Line 2958: oe_debug_pub.add('status after after xfer_rec_to_tab=>'

2954: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2955: || FND_API.G_RET_STS_ERROR);
2956: RAISE fnd_api.g_exc_error;
2957: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2958: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2959: || FND_API.G_RET_STS_UNEXP_ERROR );
2960: RAISE fnd_api.g_exc_unexpected_error;
2961: END IF;
2962:

Line 2967: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Exception in stmt num: '

2963:
2964: EXCEPTION
2965: WHEN fnd_api.g_exc_error THEN
2966: IF PG_DEBUG <> 0 THEN
2967: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Exception in stmt num: '
2968: || to_char(lStmtNum), 1);
2969: END IF;
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: -- Get message count and data

Line 2978: oe_debug_pub.add(' prepare_bcol_temp_data: ' || ' Unexpected Exception in stmt num: '

2974: , p_msg_data => x_msg_data
2975: );
2976: WHEN fnd_api.g_exc_unexpected_error THEN
2977: IF PG_DEBUG <> 0 THEN
2978: oe_debug_pub.add(' prepare_bcol_temp_data: ' || ' Unexpected Exception in stmt num: '
2979: || to_char(lStmtNum), 1);
2980: END IF;
2981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2982: -- Get message count and data

Line 2988: oe_debug_pub.add('errmsg'||sqlerrm);

2984: ( p_msg_count => x_msg_count
2985: , p_msg_data => x_msg_data
2986: );
2987: WHEN OTHERS then
2988: oe_debug_pub.add('errmsg'||sqlerrm);
2989: IF PG_DEBUG <> 0 THEN
2990: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Others Exception in stmt num: ' ||
2991: to_char(lStmtNum), 1);
2992: END IF;

Line 2990: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Others Exception in stmt num: ' ||

2986: );
2987: WHEN OTHERS then
2988: oe_debug_pub.add('errmsg'||sqlerrm);
2989: IF PG_DEBUG <> 0 THEN
2990: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Others Exception in stmt num: ' ||
2991: to_char(lStmtNum), 1);
2992: END IF;
2993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2994: -- Get message count and data

Line 3027: oe_debug_pub.add('Last index ='||l_last_index,3);

3023: lStmtNum:=10;
3024: l_last_index := p_match_rec_of_tab.line_id.count;
3025: IF PG_DEBUG <> 0 THEN
3026:
3027: oe_debug_pub.add('Last index ='||l_last_index,3);
3028: oe_debug_pub.add('first index ='||p_match_rec_of_tab.line_id.first,3);
3029: END IF;
3030:
3031: -- rkaza. 11/30/2005. bug 4712706. This procedure is called during match

Line 3028: oe_debug_pub.add('first index ='||p_match_rec_of_tab.line_id.first,3);

3024: l_last_index := p_match_rec_of_tab.line_id.count;
3025: IF PG_DEBUG <> 0 THEN
3026:
3027: oe_debug_pub.add('Last index ='||l_last_index,3);
3028: oe_debug_pub.add('first index ='||p_match_rec_of_tab.line_id.first,3);
3029: END IF;
3030:
3031: -- rkaza. 11/30/2005. bug 4712706. This procedure is called during match
3032: -- and reserve flow. Each transaction processes a bunch of top ato models

Line 3045: oe_debug_pub.add('insert into bcol_gt',5);

3041:
3042: delete from bom_cto_order_lines_gt;
3043:
3044: IF PG_DEBUG <> 0 THEN
3045: oe_debug_pub.add('insert into bcol_gt',5);
3046: END IF;
3047:
3048:
3049: lStmtNum:=20;

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

3093: );
3094:
3095:
3096: IF PG_DEBUG <> 0 THEN
3097: oe_debug_pub.add('Sql%row count ='||sql%rowcount,5);
3098: END IF;
3099:
3100:
3101:

Line 3105: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Exception in stmt num: '

3101:
3102: EXCEPTION
3103: WHEN fnd_api.g_exc_error THEN
3104: IF PG_DEBUG <> 0 THEN
3105: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Exception in stmt num: '
3106: || to_char(lStmtNum), 1);
3107: END IF;
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: -- Get message count and data

Line 3116: oe_debug_pub.add('Insert_into_bcol_gt: ' || ' Unexpected Exception in stmt num: '

3112: , p_msg_data => x_msg_data
3113: );
3114: WHEN fnd_api.g_exc_unexpected_error THEN
3115: IF PG_DEBUG <> 0 THEN
3116: oe_debug_pub.add('Insert_into_bcol_gt: ' || ' Unexpected Exception in stmt num: '
3117: || to_char(lStmtNum), 1);
3118: END IF;
3119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3120: -- Get message count and data

Line 3126: oe_debug_pub.add('errmsg'||sqlerrm);

3122: ( p_msg_count => x_msg_count
3123: , p_msg_data => x_msg_data
3124: );
3125: WHEN OTHERS then
3126: oe_debug_pub.add('errmsg'||sqlerrm);
3127: IF PG_DEBUG <> 0 THEN
3128: oe_debug_pub.add('error='||sqlerrm);
3129: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Others Exception in stmt num: '
3130: || to_char(lStmtNum), 1);

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

3124: );
3125: WHEN OTHERS then
3126: oe_debug_pub.add('errmsg'||sqlerrm);
3127: IF PG_DEBUG <> 0 THEN
3128: oe_debug_pub.add('error='||sqlerrm);
3129: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Others Exception in stmt num: '
3130: || to_char(lStmtNum), 1);
3131: END IF;
3132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3129: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Others Exception in stmt num: '

3125: WHEN OTHERS then
3126: oe_debug_pub.add('errmsg'||sqlerrm);
3127: IF PG_DEBUG <> 0 THEN
3128: oe_debug_pub.add('error='||sqlerrm);
3129: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Others Exception in stmt num: '
3130: || to_char(lStmtNum), 1);
3131: END IF;
3132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3133: -- Get message count and data

Line 3190: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'BEGIN Evaluate_N_Pop_Match_Flag',5);

3186:
3187:
3188: BEGIN
3189: IF PG_DEBUG <> 0 THEN
3190: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'BEGIN Evaluate_N_Pop_Match_Flag',5);
3191: END IF;
3192:
3193: lStmtNum := 9;
3194: l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');

Line 3197: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'custome matc value=>'||l_custom_match_profile,5);

3193: lStmtNum := 9;
3194: l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');
3195:
3196: IF PG_DEBUG <> 0 THEN
3197: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'custome matc value=>'||l_custom_match_profile,5);
3198: END IF;
3199:
3200: --if custom match is also YES then
3201: --we should use 'C' instead of 'Y'

Line 3205: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'setting l_profile vale to C',5);

3201: --we should use 'C' instead of 'Y'
3202: IF l_custom_match_profile = 1 THEN
3203:
3204: IF PG_DEBUG <> 0 THEN
3205: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'setting l_profile vale to C',5);
3206: END IF;
3207: l_profile_value := 'C';
3208:
3209: END IF;

Line 3215: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'Converting into sparse record structure indexed by line_id',5);

3211: lStmtNum := 10;
3212:
3213: l_count := p_match_flag_tab.count;
3214:
3215: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'Converting into sparse record structure indexed by line_id',5);
3216:
3217: lStmtNum := 20;
3218: i := p_match_flag_tab.first ;
3219:

Line 3229: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'original amtch flag=>'|| p_match_flag_tab(i).match_flag);

3225: x_sparse_tab(l_sparse_index).line_id := p_match_flag_tab(i).line_id;
3226: x_sparse_tab(l_sparse_index).parent_ato_line_id := p_match_flag_tab(i).parent_ato_line_id;
3227: x_sparse_tab(l_sparse_index).ato_line_id := p_match_flag_tab(i).ato_line_id;
3228:
3229: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'original amtch flag=>'|| p_match_flag_tab(i).match_flag);
3230:
3231: x_sparse_tab(l_sparse_index).match_flag := nvl(p_match_flag_tab(i).match_flag,l_profile_value);
3232:
3233: i := p_match_flag_tab.next(i);

Line 3300: oe_debug_pub.add('LINE_ID =>'||' MATCH_FLAG');

3296:
3297:
3298: --debug statement
3299: IF PG_DEBUG <> 0 THEN
3300: oe_debug_pub.add('LINE_ID =>'||' MATCH_FLAG');
3301:
3302: lStmtNum := 100;
3303: j := x_sparse_tab.first;
3304:

Line 3309: oe_debug_pub.add(x_sparse_tab(j).line_id ||' => '||x_sparse_tab(j).match_flag, 5);

3305: lStmtNum := 110;
3306: WHILE j is not null --while loop C
3307: LOOP
3308:
3309: oe_debug_pub.add(x_sparse_tab(j).line_id ||' => '||x_sparse_tab(j).match_flag, 5);
3310:
3311: j := x_sparse_tab.next(j) ;
3312: END LOOP;
3313: END IF;--PG_DEBUG

Line 3322: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Exception in stmt num: '

3318:
3319: EXCEPTION
3320: WHEN fnd_api.g_exc_error THEN
3321: IF PG_DEBUG <> 0 THEN
3322: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Exception in stmt num: '
3323: || to_char(lStmtNum), 1);
3324: END IF;
3325: x_return_status := FND_API.G_RET_STS_ERROR;
3326: -- Get message count and data

Line 3333: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || ' Unexpected Exception in stmt num: '

3329: , p_msg_data => x_msg_data
3330: );
3331: WHEN fnd_api.g_exc_unexpected_error THEN
3332: IF PG_DEBUG <> 0 THEN
3333: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || ' Unexpected Exception in stmt num: '
3334: || to_char(lStmtNum), 1);
3335: END IF;
3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3337: -- Get message count and data

Line 3343: oe_debug_pub.add('errmsg'||sqlerrm);

3339: ( p_msg_count => x_msg_count
3340: , p_msg_data => x_msg_data
3341: );
3342: WHEN OTHERS then
3343: oe_debug_pub.add('errmsg'||sqlerrm);
3344: IF PG_DEBUG <> 0 THEN
3345: oe_debug_pub.add('error='||sqlerrm);
3346: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Others Exception in stmt num: '
3347: || to_char(lStmtNum), 1);

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

3341: );
3342: WHEN OTHERS then
3343: oe_debug_pub.add('errmsg'||sqlerrm);
3344: IF PG_DEBUG <> 0 THEN
3345: oe_debug_pub.add('error='||sqlerrm);
3346: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Others Exception in stmt num: '
3347: || to_char(lStmtNum), 1);
3348: END IF;
3349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3346: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Others Exception in stmt num: '

3342: WHEN OTHERS then
3343: oe_debug_pub.add('errmsg'||sqlerrm);
3344: IF PG_DEBUG <> 0 THEN
3345: oe_debug_pub.add('error='||sqlerrm);
3346: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Others Exception in stmt num: '
3347: || to_char(lStmtNum), 1);
3348: END IF;
3349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3350: -- Get message count and data

Line 3379: oe_debug_pub.add('BEGIN xfer_match_flag_to_rec_of_tab: ', 5);

3375:
3376: BEGIN
3377:
3378: IF PG_DEBUG <> 0 THEN
3379: oe_debug_pub.add('BEGIN xfer_match_flag_to_rec_of_tab: ', 5);
3380: END IF;
3381:
3382: lStmtNum :=10;
3383: j:= p_sparse_tab.first;

Line 3399: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Exception in stmt num: '

3395:
3396: EXCEPTION
3397: WHEN fnd_api.g_exc_error THEN
3398: IF PG_DEBUG <> 0 THEN
3399: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Exception in stmt num: '
3400: || to_char(lStmtNum), 1);
3401: END IF;
3402: x_return_status := FND_API.G_RET_STS_ERROR;
3403: -- Get message count and data

Line 3410: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || ' Unexpected Exception in stmt num: '

3406: , p_msg_data => x_msg_data
3407: );
3408: WHEN fnd_api.g_exc_unexpected_error THEN
3409: IF PG_DEBUG <> 0 THEN
3410: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || ' Unexpected Exception in stmt num: '
3411: || to_char(lStmtNum), 1);
3412: END IF;
3413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3414: -- Get message count and data

Line 3420: oe_debug_pub.add('errmsg'||sqlerrm);

3416: ( p_msg_count => x_msg_count
3417: , p_msg_data => x_msg_data
3418: );
3419: WHEN OTHERS then
3420: oe_debug_pub.add('errmsg'||sqlerrm);
3421: IF PG_DEBUG <> 0 THEN
3422: oe_debug_pub.add('error='||sqlerrm);
3423: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Others Exception in stmt num: '
3424: || to_char(lStmtNum), 1);

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

3418: );
3419: WHEN OTHERS then
3420: oe_debug_pub.add('errmsg'||sqlerrm);
3421: IF PG_DEBUG <> 0 THEN
3422: oe_debug_pub.add('error='||sqlerrm);
3423: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Others Exception in stmt num: '
3424: || to_char(lStmtNum), 1);
3425: END IF;
3426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3423: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Others Exception in stmt num: '

3419: WHEN OTHERS then
3420: oe_debug_pub.add('errmsg'||sqlerrm);
3421: IF PG_DEBUG <> 0 THEN
3422: oe_debug_pub.add('error='||sqlerrm);
3423: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Others Exception in stmt num: '
3424: || to_char(lStmtNum), 1);
3425: END IF;
3426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3427: -- Get message count and data

Line 3470: oe_debug_pub.add('ENTERED Update_BCOLGT_with_match_flag', 5);

3466:
3467: BEGIN
3468:
3469: IF PG_DEBUG <> 0 THEN
3470: oe_debug_pub.add('ENTERED Update_BCOLGT_with_match_flag', 5);
3471: END IF;
3472:
3473: --added for re-arch
3474: --get match flag for all non-pahtom ato models

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

3493: WHERE bcol.bom_item_type = '1'-- used inverted commas to use index
3494: AND nvl(bcol.wip_supply_type,1) <> 6;
3495:
3496: IF PG_DEBUG <> 0 THEN
3497: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'Sql%row count ='||sql%rowcount,3);
3498: END IF;
3499:
3500:
3501: --prepare a record structure for input paremeter to

Line 3533: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||

3529:
3530: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3531: --level1
3532: -- IF PG_DEBUG <> 0 THEN
3533: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||
3534: 'success after Evaluate_N_Pop_Match_Flag', 1);
3535: -- END IF;
3536:
3537: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3557: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'success after xfer_match_flag_to_rec_of_tab', 1);

3553:
3554: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3555: --level1
3556: IF PG_DEBUG <> 0 THEN
3557: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'success after xfer_match_flag_to_rec_of_tab', 1);
3558: END IF;
3559:
3560: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3561: RAISE fnd_api.g_exc_error;

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

3570: WHERE line_id = l_match_flag_rec_of_tab.line_id (i);
3571:
3572:
3573: IF PG_DEBUG <> 0 THEN
3574: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'Sql%row count ='||sql%rowcount,3);
3575: END IF;
3576:
3577: EXCEPTION
3578: WHEN fnd_api.g_exc_error THEN

Line 3580: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || 'Exception in stmt num: '

3576:
3577: EXCEPTION
3578: WHEN fnd_api.g_exc_error THEN
3579: IF PG_DEBUG <> 0 THEN
3580: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || 'Exception in stmt num: '
3581: || to_char(lStmtNum), 1);
3582: END IF;
3583: x_return_status := FND_API.G_RET_STS_ERROR;
3584: -- Get message count and data

Line 3591: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || ' Unexpected Exception in stmt num: '

3587: , p_msg_data => x_msg_data
3588: );
3589: WHEN fnd_api.g_exc_unexpected_error THEN
3590: IF PG_DEBUG <> 0 THEN
3591: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || ' Unexpected Exception in stmt num: '
3592: || to_char(lStmtNum), 1);
3593: END IF;
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3595: -- Get message count and data

Line 3604: oe_debug_pub.add('Update_BCOLGT_with_match_flag' || 'Others Exception in stmt num: '

3600: WHEN OTHERS then
3601:
3602: IF PG_DEBUG <> 0 THEN
3603:
3604: oe_debug_pub.add('Update_BCOLGT_with_match_flag' || 'Others Exception in stmt num: '
3605: || to_char(lStmtNum), 1);
3606: oe_debug_pub.add('error '||sqlerrm,1);
3607: END IF;
3608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3602: IF PG_DEBUG <> 0 THEN
3603:
3604: oe_debug_pub.add('Update_BCOLGT_with_match_flag' || 'Others Exception in stmt num: '
3605: || to_char(lStmtNum), 1);
3606: oe_debug_pub.add('error '||sqlerrm,1);
3607: END IF;
3608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3609: -- Get message count and data
3610: cto_msg_pub.count_and_get