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 1960: oe_debug_pub.add('Entered perform_match for =>'|| p_ato_line_id

1956: BEGIN
1957:
1958:
1959: /*IF PG_DEBUG <> 0 THEN
1960: oe_debug_pub.add('Entered perform_match for =>'|| p_ato_line_id
1961: ||'custm prof=>'||p_custom_match_profile,1);
1962: END IF;*/
1963: x_return_status := FND_API.G_RET_STS_SUCCESS;
1964:

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

1975:
1976:
1977:
1978: IF PG_DEBUG <> 0 THEN
1979: oe_debug_pub.add(' perform_match flag =>'||lPerformMatch
1980: ||'for line_id =>'||lNextRec.line_id,5
1981: );
1982: END IF;
1983:

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

2004:
2005: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: start time: ' ||
2006: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));*/
2007: IF PG_DEBUG <> 0 THEN
2008: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: start time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
2009: END IF; --Bugfix 6452747
2010:
2011: CTO_UTILITY_PK.lock_for_match(
2012: x_return_status => x_return_status,

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

2023:
2024: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: end time: ' ||
2025: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));*/
2026: IF PG_DEBUG <> 0 THEN
2027: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: end time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
2028: END IF; --Bugfix 6452747
2029:
2030: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2031: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');

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

2027: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: end time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
2028: END IF; --Bugfix 6452747
2029:
2030: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2031: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
2032: raise fnd_api.g_exc_unexpected_error;
2033: end if;
2034:
2035: --check for error cases

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

2034:
2035: --check for error cases
2036: if ( l_lock_status <> 0 ) THEN
2037: if (l_lock_status = 1) then -- timeout
2038: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');
2039: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
2040: raise fnd_api.g_exc_unexpected_error;
2041:
2042: elsif (l_lock_status = 2) then -- deadlock

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

2039: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
2040: raise fnd_api.g_exc_unexpected_error;
2041:
2042: elsif (l_lock_status = 2) then -- deadlock
2043: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
2044: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
2045: raise fnd_api.g_exc_unexpected_error;
2046:
2047: elsif (l_lock_status = 3) then -- parameter error

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

2044: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
2045: raise fnd_api.g_exc_unexpected_error;
2046:
2047: elsif (l_lock_status = 3) then -- parameter error
2048: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
2049: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
2050: raise fnd_api.g_exc_unexpected_error;
2051:
2052: elsif (l_lock_status = 4) then -- already locked.

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

2049: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
2050: raise fnd_api.g_exc_unexpected_error;
2051:
2052: elsif (l_lock_status = 4) then -- already locked.
2053: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');
2054: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');
2055: -- we shall not raise an error if we are already holding the lock.
2056:
2057: else -- internal error - not fault of user

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

2054: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');
2055: -- we shall not raise an error if we are already holding the lock.
2056:
2057: else -- internal error - not fault of user
2058: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');
2059: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');
2060: raise fnd_api.g_exc_unexpected_error;
2061: end if;
2062: else

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

2060: raise fnd_api.g_exc_unexpected_error;
2061: end if;
2062: else
2063: IF PG_DEBUG <> 0 THEN
2064: oe_debug_pub.add('match_and_create_all_items: ' || 'Successfully obtained lock for match.');
2065: END IF;
2066:
2067: end if;
2068: END IF;

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

2085: raise fnd_api.g_exc_error;
2086: end if;
2087: ELSIF lPerformMatch = 'C' THEN
2088: IF PG_DEBUG <> 0 THEN
2089: oe_debug_pub.add('match_and_create_all_items: ' || 'Custom Match.', 1);
2090: END IF;
2091:
2092: lStmtNum:=50;
2093: lStatus := CTO_CUSTOM_MATCH_PK.find_matching_config(

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

2113: where line_id = lNextRec.line_id
2114: and perform_match in ('Y','C');
2115: -- if the update fails, its not an error
2116:
2117: oe_debug_pub.add('perform_match: ' || 'updated to U : ' || to_char(lNextRec.Line_Id), 1);
2118:
2119: oe_debug_pub.add('perform_match: ' || 'rowcount : ' || to_char(sql%rowcount), 1);
2120:
2121: lStmtNum:=70;

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

2115: -- if the update fails, its not an error
2116:
2117: oe_debug_pub.add('perform_match: ' || 'updated to U : ' || to_char(lNextRec.Line_Id), 1);
2118:
2119: oe_debug_pub.add('perform_match: ' || 'rowcount : ' || to_char(sql%rowcount), 1);
2120:
2121: lStmtNum:=70;
2122: update bom_cto_order_lines_gt
2123: set perform_match = 'U'

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

2124: where line_id = lNextRec.parent_ato_line_id
2125: and perform_match in ( 'Y','C');
2126: -- if the update fails, its not an error
2127:
2128: oe_debug_pub.add('perform_match: ' || 'updated to U : ' || to_char(lNextRec.parent_ato_Line_Id), 1);
2129:
2130: oe_debug_pub.add('perform_match: ' || 'rowcount : ' || to_char(sql%rowcount), 1);
2131:
2132: elsif (lStatus = 1 and lXConfigId is not null) then

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

2126: -- if the update fails, its not an error
2127:
2128: oe_debug_pub.add('perform_match: ' || 'updated to U : ' || to_char(lNextRec.parent_ato_Line_Id), 1);
2129:
2130: oe_debug_pub.add('perform_match: ' || 'rowcount : ' || to_char(sql%rowcount), 1);
2131:
2132: elsif (lStatus = 1 and lXConfigId is not null) then
2133:
2134:

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

2142: -- Release the lock if match found rather than wait for commit/rollback.
2143: --
2144:
2145: IF PG_DEBUG <> 0 THEN
2146: oe_debug_pub.add('match_and_create_all_items: ' || 'Match found for line ' ||
2147: to_char(lNextRec.line_id) ||
2148: ' with config item ' ||
2149: to_char(lXConfigId), 1);
2150: END IF;

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

2155: x_Msg_Data => x_msg_data,
2156: p_hash_value => l_hash_value);
2157:
2158: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2159: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
2160: raise fnd_api.g_exc_unexpected_error;
2161: end if;
2162:
2163: --

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

2199:
2200:
2201:
2202:
2203: oe_debug_pub.add('perform_match: ' || 'Updated possible similar models to Y : '
2204: || to_char(sql%rowcount), 1);
2205:
2206:
2207:

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

2211:
2212: EXCEPTION
2213: WHEN fnd_api.g_exc_error THEN
2214: IF PG_DEBUG <> 0 THEN
2215: oe_debug_pub.add('perform_match: ' || 'Exception in stmt num: '
2216: || to_char(lStmtNum), 1);
2217: END IF;
2218: x_return_status := FND_API.G_RET_STS_ERROR;
2219: -- Get message count and data

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

2222: , p_msg_data => x_msg_data
2223: );
2224: WHEN fnd_api.g_exc_unexpected_error THEN
2225: IF PG_DEBUG <> 0 THEN
2226: oe_debug_pub.add('perform_match: ' || ' Unexpected Exception in stmt num: '
2227: || to_char(lStmtNum), 1);
2228: END IF;
2229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2230: -- Get message count and data

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

2234: );
2235: WHEN OTHERS then
2236:
2237: IF PG_DEBUG <> 0 THEN
2238: oe_debug_pub.add('perform_match: ' || 'Others Exception in stmt num: '
2239: || to_char(lStmtNum), 1);
2240: oe_debug_pub.add('errmsg'||sqlerrm,1);
2241: END IF;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2236:
2237: IF PG_DEBUG <> 0 THEN
2238: oe_debug_pub.add('perform_match: ' || 'Others Exception in stmt num: '
2239: || to_char(lStmtNum), 1);
2240: oe_debug_pub.add('errmsg'||sqlerrm,1);
2241: END IF;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: -- Get message count and data
2244: cto_msg_pub.count_and_get

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

2289:
2290: EXCEPTION
2291: WHEN fnd_api.g_exc_unexpected_error THEN
2292: IF PG_DEBUG <> 0 THEN
2293: oe_debug_pub.add('flag_reuse_config: ' || ' Unexpected Exception in stmt num: '
2294: || to_char(lStmtNum), 1);
2295: END IF;
2296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2297: /*-- Get message count and data

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

2303: WHEN OTHERS then
2304:
2305: IF PG_DEBUG <> 0 THEN
2306:
2307: oe_debug_pub.add('flag_reuse_config: ' || 'Others Exception in stmt num: '
2308: || to_char(lStmtNum), 1);
2309: oe_debug_pub.add('error='||sqlerrm,1);
2310:
2311: END IF;

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

2305: IF PG_DEBUG <> 0 THEN
2306:
2307: oe_debug_pub.add('flag_reuse_config: ' || 'Others Exception in stmt num: '
2308: || to_char(lStmtNum), 1);
2309: oe_debug_pub.add('error='||sqlerrm,1);
2310:
2311: END IF;
2312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2313:

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

2399: BEGIN
2400:
2401:
2402: IF PG_DEBUG <> 0 THEN
2403: oe_debug_pub.add('ENTERED reuse configuration',5);
2404: END IF;
2405: x_return_status := FND_API.G_RET_STS_SUCCESS;
2406:
2407:

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

2410: IF p_ato_line_id IS NOT NULL THEN
2411:
2412:
2413: IF PG_DEBUG <> 0 THEN
2414: oe_debug_pub.add('reuse for ato line=>'||p_ato_line_id,1);
2415: END IF;
2416:
2417: lStmtNum := 20;
2418:

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

2437: l_qty_per_parent_model
2438: FROM bom_cto_order_lines_gt
2439: WHERE ato_line_id = p_ato_line_id;
2440:
2441: oe_debug_pub.add('LINE_ID >>QTY_PER_PARENT_MODEL',5);
2442:
2443: FOR i in l_temp_line_id.first..l_temp_line_id.last LOOP
2444:
2445: oe_debug_pub.add(l_temp_line_id(i)||'>>'||l_qty_per_parent_model(i),5);

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

2441: oe_debug_pub.add('LINE_ID >>QTY_PER_PARENT_MODEL',5);
2442:
2443: FOR i in l_temp_line_id.first..l_temp_line_id.last LOOP
2444:
2445: oe_debug_pub.add(l_temp_line_id(i)||'>>'||l_qty_per_parent_model(i),5);
2446:
2447: END LOOP;
2448:
2449: oe_debug_pub.add('Picture of bcol_gt before reuse process',5);

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

2445: oe_debug_pub.add(l_temp_line_id(i)||'>>'||l_qty_per_parent_model(i),5);
2446:
2447: END LOOP;
2448:
2449: oe_debug_pub.add('Picture of bcol_gt before reuse process',5);
2450:
2451: FOR kiran_rec in c_gt_intial_pic
2452: LOOP
2453: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);

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

2449: oe_debug_pub.add('Picture of bcol_gt before reuse process',5);
2450:
2451: FOR kiran_rec in c_gt_intial_pic
2452: LOOP
2453: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);
2454: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);
2455: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2456: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2457: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);

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

2450:
2451: FOR kiran_rec in c_gt_intial_pic
2452: LOOP
2453: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);
2454: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);
2455: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2456: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2457: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);
2458: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);

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

2451: FOR kiran_rec in c_gt_intial_pic
2452: LOOP
2453: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);
2454: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);
2455: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2456: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2457: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);
2458: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);
2459: oe_debug_pub.add('reuse=>'||kiran_rec.reuse_config,5);

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

2452: LOOP
2453: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);
2454: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);
2455: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2456: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2457: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);
2458: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);
2459: oe_debug_pub.add('reuse=>'||kiran_rec.reuse_config,5);
2460:

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

2453: oe_debug_pub.add('LINE_ID=>'||kiran_rec.line_id,5);
2454: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);
2455: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2456: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2457: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);
2458: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);
2459: oe_debug_pub.add('reuse=>'||kiran_rec.reuse_config,5);
2460:
2461: END LOOP;

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

2454: oe_debug_pub.add('parent_LINE_ID=>'||kiran_rec.parent_ato_line_id,5);
2455: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2456: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2457: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);
2458: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);
2459: oe_debug_pub.add('reuse=>'||kiran_rec.reuse_config,5);
2460:
2461: END LOOP;
2462:

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

2455: oe_debug_pub.add('ato_LINE_ID=>'||kiran_rec.ato_line_id,5);
2456: oe_debug_pub.add('WS=>'||kiran_rec.wip_supply_type,5);
2457: oe_debug_pub.add('BIT=>'||kiran_rec.bom_item_type,5);
2458: oe_debug_pub.add('QPM=>'||kiran_rec.qty_per_parent_model,5);
2459: oe_debug_pub.add('reuse=>'||kiran_rec.reuse_config,5);
2460:
2461: END LOOP;
2462:
2463:

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

2468: ELSE --bulk call
2469:
2470:
2471: IF PG_DEBUG <> 0 THEN
2472: oe_debug_pub.add('reuse configuration BULK call',1);
2473: END IF;
2474:
2475:
2476: lStmtNum := 40;

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

2492:
2493:
2494:
2495: IF PG_DEBUG <> 0 THEN
2496: oe_debug_pub.add('IF count>1, re-use called for more than 1 order line',5);
2497: oe_debug_pub.add('l_ato_line_tbl.count=>'||l_ato_line_tbl.count,5);
2498: END IF;
2499:
2500:

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

2493:
2494:
2495: IF PG_DEBUG <> 0 THEN
2496: oe_debug_pub.add('IF count>1, re-use called for more than 1 order line',5);
2497: oe_debug_pub.add('l_ato_line_tbl.count=>'||l_ato_line_tbl.count,5);
2498: END IF;
2499:
2500:
2501: IF l_ato_line_tbl.count > 0 THEN

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

2519:
2520: IF l_bcol_ato_line_tbl.count > 0 THEN
2521:
2522: IF PG_DEBUG <> 0 THEN
2523: oe_debug_pub.add('Updating bcol (permanent table) with qty per parent model',5);
2524:
2525: END IF;
2526:
2527: FORALL j IN 1..l_bcol_ato_line_tbl.last

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

2620:
2621:
2622:
2623: IF PG_DEBUG <> 0 THEN
2624: oe_debug_pub.add('Some UN-reusable parent ato lines have been identified',5);
2625: FOR p_ato_idx in l_parent_ato_line_tbl.first..l_parent_ato_line_tbl.last
2626: LOOP
2627: oe_debug_pub.add('kiran'||l_parent_ato_line_tbl(p_ato_idx),5);
2628: END LOOP;

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

2623: IF PG_DEBUG <> 0 THEN
2624: oe_debug_pub.add('Some UN-reusable parent ato lines have been identified',5);
2625: FOR p_ato_idx in l_parent_ato_line_tbl.first..l_parent_ato_line_tbl.last
2626: LOOP
2627: oe_debug_pub.add('kiran'||l_parent_ato_line_tbl(p_ato_idx),5);
2628: END LOOP;
2629: END IF;
2630:
2631:

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

2643: g_reuse_tbl(bcol_rec.line_id).parent_ato_line_id := bcol_rec.parent_ato_line_id;
2644: g_reuse_tbl(bcol_rec.line_id).reuse_config := bcol_rec.reuse_config;
2645:
2646: IF PG_DEBUG <> 0 THEN
2647: oe_debug_pub.add('LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).line_id,5);
2648: oe_debug_pub.add('PARENT_ATO_LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).parent_ato_line_id,5);
2649: oe_debug_pub.add('REUSE_CONFIG_from_GT=>'||g_reuse_tbl(bcol_rec.line_id).reuse_config,5);
2650:
2651: END IF;

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

2644: g_reuse_tbl(bcol_rec.line_id).reuse_config := bcol_rec.reuse_config;
2645:
2646: IF PG_DEBUG <> 0 THEN
2647: oe_debug_pub.add('LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).line_id,5);
2648: oe_debug_pub.add('PARENT_ATO_LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).parent_ato_line_id,5);
2649: oe_debug_pub.add('REUSE_CONFIG_from_GT=>'||g_reuse_tbl(bcol_rec.line_id).reuse_config,5);
2650:
2651: END IF;
2652:

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

2645:
2646: IF PG_DEBUG <> 0 THEN
2647: oe_debug_pub.add('LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).line_id,5);
2648: oe_debug_pub.add('PARENT_ATO_LINE_ID=>'||g_reuse_tbl(bcol_rec.line_id).parent_ato_line_id,5);
2649: oe_debug_pub.add('REUSE_CONFIG_from_GT=>'||g_reuse_tbl(bcol_rec.line_id).reuse_config,5);
2650:
2651: END IF;
2652:
2653: End Loop;

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

2679: --OR previous element might have updated reuse to N
2680: IF g_reuse_tbl(l_parent_ato_line_tbl(i)).reuse_config= 'Y' THEN
2681:
2682: IF PG_DEBUG <> 0 THEN
2683: oe_debug_pub.add('calling flag_reuse_config for model_line_id=>'
2684: ||l_parent_ato_line_tbl(i),5);
2685: END IF;
2686:
2687: lStmtNum:= 110;

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

2699:
2700: IF g_model_line_tbl.EXISTS(1) THEN
2701:
2702: IF PG_DEBUG <> 0 THEN
2703: oe_debug_pub.add('updating reuse_flag to N for following model lines =>',5);
2704: END IF;
2705:
2706: FOR i IN g_model_line_tbl.FIRST..g_model_line_tbl.LAST LOOP
2707: IF PG_DEBUG <> 0 THEN

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

2704: END IF;
2705:
2706: FOR i IN g_model_line_tbl.FIRST..g_model_line_tbl.LAST LOOP
2707: IF PG_DEBUG <> 0 THEN
2708: oe_debug_pub.add(g_model_line_tbl(i),5);
2709: END IF;
2710:
2711: END LOOP;
2712:

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

2719: ELSE
2720:
2721:
2722: -- IF PG_DEBUG <> 0 THEN
2723: oe_debug_pub.add('All parent ato lines are re-usable',5);--5 level
2724: -- END IF;
2725: END IF; -- l_parent_ato_line_tbl.EXISTS(1)
2726:
2727: lStmtNum:=130;

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

2775:
2776: END IF;--if l_ato_line_tbl.count is > 0)
2777:
2778: IF PG_DEBUG = 5 THEN
2779: Oe_debug_pub.add('LINE_ID--'||'reuse_config--'||
2780: 'CONFIG_ITEM_ID--' ||'qty_per_parent_model--'
2781: ||'CIB--'||'ship_from_org--'||'validation_org');
2782: FOR debug_rec in c_debug
2783: LOOP

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

2780: 'CONFIG_ITEM_ID--' ||'qty_per_parent_model--'
2781: ||'CIB--'||'ship_from_org--'||'validation_org');
2782: FOR debug_rec in c_debug
2783: LOOP
2784: oe_debug_pub.add(debug_rec.line_id||'--'||debug_rec.reuse_config||'--'||
2785: debug_rec.config_item_id||'--'||debug_rec.qty_per_parent_model||'--'||
2786: debug_rec.config_creation||'--'||debug_rec.ship_from_org_id||'--'||
2787: debug_rec.validation_org
2788: ,5);

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

2793: EXCEPTION
2794:
2795: WHEN fnd_api.g_exc_error THEN
2796: IF PG_DEBUG <> 0 THEN
2797: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Exception in stmt num: '
2798: || to_char(lStmtNum), 1);
2799: END IF;
2800: x_return_status := FND_API.G_RET_STS_ERROR;
2801: -- Get message count and data

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

2804: , p_msg_data => x_msg_data
2805: );
2806: WHEN fnd_api.g_exc_unexpected_error THEN
2807: IF PG_DEBUG <> 0 THEN
2808: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || ' Unexpected Exception in stmt num: '
2809: || to_char(lStmtNum), 1);
2810: END IF;
2811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2812: -- Get message count and data

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

2817: WHEN OTHERS then
2818:
2819:
2820: IF PG_DEBUG <> 0 THEN
2821: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Others Exception in stmt num: '
2822: || to_char(lStmtNum), 1);
2823: oe_debug_pub.add('errmsg =>'||sqlerrm,1);
2824: END IF;
2825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2819:
2820: IF PG_DEBUG <> 0 THEN
2821: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Others Exception in stmt num: '
2822: || to_char(lStmtNum), 1);
2823: oe_debug_pub.add('errmsg =>'||sqlerrm,1);
2824: END IF;
2825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2826: -- Get message count and data
2827: cto_msg_pub.count_and_get

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

2879: )
2880: where bcol.ato_line_id <>bcol.line_id;
2881:
2882:
2883: oe_debug_pub.add('rowcount after update from bic=>'||sql%rowcount,5);
2884:
2885:
2886: --rowcount after insert of bom_item_type and wip_supply_type is l_rowcount;
2887:

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

2893: p_match_rec_of_tab.bom_item_type,
2894: p_match_rec_of_tab.wip_supply_type
2895: FROM bom_cto_order_lines_gt;
2896:
2897: oe_debug_pub.add('rowcount after select for BIT,WST=>'||sql%rowcount,5);
2898:
2899: --rowcount of bom_itemtype,wip_supply_typ after select l_rowcount;
2900: lStmtNum:=40;
2901: xfer_tab_to_rec(

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

2906: x_msg_data
2907: );
2908:
2909: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2910: oe_debug_pub.add('SUCCESS after xfer_tab_to_rec',5);
2911:
2912: --add retrun status and error mesages to these
2913: lStmtNum:=50;
2914: populate_parent_ato(

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

2918: x_msg_count => x_msg_count,
2919: x_msg_data => x_msg_data );
2920:
2921: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2922: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2923: || FND_API.G_RET_STS_ERROR,5);
2924: RAISE fnd_api.g_exc_error;
2925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2926: oe_debug_pub.add('status after after xfer_tab_to_rec=>'

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

2922: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2923: || FND_API.G_RET_STS_ERROR,5);
2924: RAISE fnd_api.g_exc_error;
2925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2926: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2927: || FND_API.G_RET_STS_UNEXP_ERROR,5);
2928: RAISE fnd_api.g_exc_unexpected_error;
2929: END IF;
2930:

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

2930:
2931:
2932:
2933: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2934: oe_debug_pub.add('SUCCESS after populate_parent_ato=>');
2935: lStmtNum:=60;
2936: populate_plan_level( P_tab_of_rec => l_tab_of_rec,
2937: x_return_status => x_return_status,
2938: x_msg_count => x_msg_count,

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

2937: x_return_status => x_return_status,
2938: x_msg_count => x_msg_count,
2939: x_msg_data => x_msg_data );
2940: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2941: oe_debug_pub.add('status after after populate_parent_ato=>'
2942: || FND_API.G_RET_STS_ERROR);
2943: RAISE fnd_api.g_exc_error;
2944: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2945: oe_debug_pub.add('status after after populate_parent_ato=>'

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

2941: oe_debug_pub.add('status after after populate_parent_ato=>'
2942: || FND_API.G_RET_STS_ERROR);
2943: RAISE fnd_api.g_exc_error;
2944: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2945: oe_debug_pub.add('status after after populate_parent_ato=>'
2946: || FND_API.G_RET_STS_UNEXP_ERROR );
2947: RAISE fnd_api.g_exc_unexpected_error;
2948: END IF;
2949:

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

2949:
2950:
2951:
2952: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2953: oe_debug_pub.add('SUCCESS after populate_plan_level=>');
2954:
2955: lStmtNum:=70;
2956: xfer_rec_to_tab(
2957: p_tab_of_rec => l_tab_of_rec ,

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

2961: x_msg_data => x_msg_data
2962: );
2963:
2964: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2965: oe_debug_pub.add('status after after populate_plan_level=>'
2966: || FND_API.G_RET_STS_ERROR);
2967: RAISE fnd_api.g_exc_error;
2968: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2969: oe_debug_pub.add('status after after populate_plan_level=>'

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

2965: oe_debug_pub.add('status after after populate_plan_level=>'
2966: || FND_API.G_RET_STS_ERROR);
2967: RAISE fnd_api.g_exc_error;
2968: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2969: oe_debug_pub.add('status after after populate_plan_level=>'
2970: || FND_API.G_RET_STS_UNEXP_ERROR );
2971: RAISE fnd_api.g_exc_unexpected_error;
2972: END IF;
2973:

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

2972: END IF;
2973:
2974:
2975: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2976: oe_debug_pub.add('SUCCESS after xfer_rec_to_tabl=>');
2977:
2978: lStmtNum:=80;
2979: --update the remaining columns into bcol_temp
2980:

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

2985: PLAN_LEVEL = p_match_rec_of_tab.PLAN_LEVEL (i)
2986: WHERE line_id = p_match_rec_of_tab.LINE_ID(i);
2987:
2988: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2989: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2990: || FND_API.G_RET_STS_ERROR);
2991: RAISE fnd_api.g_exc_error;
2992: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: oe_debug_pub.add('status after after xfer_rec_to_tab=>'

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

2989: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2990: || FND_API.G_RET_STS_ERROR);
2991: RAISE fnd_api.g_exc_error;
2992: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2994: || FND_API.G_RET_STS_UNEXP_ERROR );
2995: RAISE fnd_api.g_exc_unexpected_error;
2996: END IF;
2997:

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

2998:
2999: EXCEPTION
3000: WHEN fnd_api.g_exc_error THEN
3001: IF PG_DEBUG <> 0 THEN
3002: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Exception in stmt num: '
3003: || to_char(lStmtNum), 1);
3004: END IF;
3005: x_return_status := FND_API.G_RET_STS_ERROR;
3006: -- Get message count and data

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

3009: , p_msg_data => x_msg_data
3010: );
3011: WHEN fnd_api.g_exc_unexpected_error THEN
3012: IF PG_DEBUG <> 0 THEN
3013: oe_debug_pub.add(' prepare_bcol_temp_data: ' || ' Unexpected Exception in stmt num: '
3014: || to_char(lStmtNum), 1);
3015: END IF;
3016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3017: -- Get message count and data

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

3019: ( p_msg_count => x_msg_count
3020: , p_msg_data => x_msg_data
3021: );
3022: WHEN OTHERS then
3023: oe_debug_pub.add('errmsg'||sqlerrm);
3024: IF PG_DEBUG <> 0 THEN
3025: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Others Exception in stmt num: ' ||
3026: to_char(lStmtNum), 1);
3027: END IF;

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

3021: );
3022: WHEN OTHERS then
3023: oe_debug_pub.add('errmsg'||sqlerrm);
3024: IF PG_DEBUG <> 0 THEN
3025: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Others Exception in stmt num: ' ||
3026: to_char(lStmtNum), 1);
3027: END IF;
3028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3029: -- Get message count and data

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

3058: lStmtNum:=10;
3059: l_last_index := p_match_rec_of_tab.line_id.count;
3060: IF PG_DEBUG <> 0 THEN
3061:
3062: oe_debug_pub.add('Last index ='||l_last_index,3);
3063: oe_debug_pub.add('first index ='||p_match_rec_of_tab.line_id.first,3);
3064: END IF;
3065:
3066: -- rkaza. 11/30/2005. bug 4712706. This procedure is called during match

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

3059: l_last_index := p_match_rec_of_tab.line_id.count;
3060: IF PG_DEBUG <> 0 THEN
3061:
3062: oe_debug_pub.add('Last index ='||l_last_index,3);
3063: oe_debug_pub.add('first index ='||p_match_rec_of_tab.line_id.first,3);
3064: END IF;
3065:
3066: -- rkaza. 11/30/2005. bug 4712706. This procedure is called during match
3067: -- and reserve flow. Each transaction processes a bunch of top ato models

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

3076:
3077: delete from bom_cto_order_lines_gt;
3078:
3079: IF PG_DEBUG <> 0 THEN
3080: oe_debug_pub.add('insert into bcol_gt',5);
3081: END IF;
3082:
3083:
3084: lStmtNum:=20;

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

3128: );
3129:
3130:
3131: IF PG_DEBUG <> 0 THEN
3132: oe_debug_pub.add('Sql%row count ='||sql%rowcount,5);
3133: END IF;
3134:
3135:
3136:

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

3136:
3137: EXCEPTION
3138: WHEN fnd_api.g_exc_error THEN
3139: IF PG_DEBUG <> 0 THEN
3140: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Exception in stmt num: '
3141: || to_char(lStmtNum), 1);
3142: END IF;
3143: x_return_status := FND_API.G_RET_STS_ERROR;
3144: -- Get message count and data

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

3147: , p_msg_data => x_msg_data
3148: );
3149: WHEN fnd_api.g_exc_unexpected_error THEN
3150: IF PG_DEBUG <> 0 THEN
3151: oe_debug_pub.add('Insert_into_bcol_gt: ' || ' Unexpected Exception in stmt num: '
3152: || to_char(lStmtNum), 1);
3153: END IF;
3154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3155: -- Get message count and data

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

3157: ( p_msg_count => x_msg_count
3158: , p_msg_data => x_msg_data
3159: );
3160: WHEN OTHERS then
3161: oe_debug_pub.add('errmsg'||sqlerrm);
3162: IF PG_DEBUG <> 0 THEN
3163: oe_debug_pub.add('error='||sqlerrm);
3164: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Others Exception in stmt num: '
3165: || to_char(lStmtNum), 1);

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

3159: );
3160: WHEN OTHERS then
3161: oe_debug_pub.add('errmsg'||sqlerrm);
3162: IF PG_DEBUG <> 0 THEN
3163: oe_debug_pub.add('error='||sqlerrm);
3164: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Others Exception in stmt num: '
3165: || to_char(lStmtNum), 1);
3166: END IF;
3167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3160: WHEN OTHERS then
3161: oe_debug_pub.add('errmsg'||sqlerrm);
3162: IF PG_DEBUG <> 0 THEN
3163: oe_debug_pub.add('error='||sqlerrm);
3164: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Others Exception in stmt num: '
3165: || to_char(lStmtNum), 1);
3166: END IF;
3167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3168: -- Get message count and data

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

3221:
3222:
3223: BEGIN
3224: IF PG_DEBUG <> 0 THEN
3225: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'BEGIN Evaluate_N_Pop_Match_Flag',5);
3226: END IF;
3227:
3228: lStmtNum := 9;
3229: l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');

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

3228: lStmtNum := 9;
3229: l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');
3230:
3231: IF PG_DEBUG <> 0 THEN
3232: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'custome matc value=>'||l_custom_match_profile,5);
3233: END IF;
3234:
3235: --if custom match is also YES then
3236: --we should use 'C' instead of 'Y'

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

3236: --we should use 'C' instead of 'Y'
3237: IF l_custom_match_profile = 1 THEN
3238:
3239: IF PG_DEBUG <> 0 THEN
3240: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'setting l_profile vale to C',5);
3241: END IF;
3242: l_profile_value := 'C';
3243:
3244: END IF;

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

3246: lStmtNum := 10;
3247:
3248: l_count := p_match_flag_tab.count;
3249:
3250: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'Converting into sparse record structure indexed by line_id',5);
3251:
3252: lStmtNum := 20;
3253: i := p_match_flag_tab.first ;
3254:

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

3260: x_sparse_tab(l_sparse_index).line_id := p_match_flag_tab(i).line_id;
3261: x_sparse_tab(l_sparse_index).parent_ato_line_id := p_match_flag_tab(i).parent_ato_line_id;
3262: x_sparse_tab(l_sparse_index).ato_line_id := p_match_flag_tab(i).ato_line_id;
3263:
3264: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag:'||'original amtch flag=>'|| p_match_flag_tab(i).match_flag);
3265:
3266: x_sparse_tab(l_sparse_index).match_flag := nvl(p_match_flag_tab(i).match_flag,l_profile_value);
3267:
3268: i := p_match_flag_tab.next(i);

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

3331:
3332:
3333: --debug statement
3334: IF PG_DEBUG <> 0 THEN
3335: oe_debug_pub.add('LINE_ID =>'||' MATCH_FLAG');
3336:
3337: lStmtNum := 100;
3338: j := x_sparse_tab.first;
3339:

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

3340: lStmtNum := 110;
3341: WHILE j is not null --while loop C
3342: LOOP
3343:
3344: oe_debug_pub.add(x_sparse_tab(j).line_id ||' => '||x_sparse_tab(j).match_flag, 5);
3345:
3346: j := x_sparse_tab.next(j) ;
3347: END LOOP;
3348: END IF;--PG_DEBUG

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

3353:
3354: EXCEPTION
3355: WHEN fnd_api.g_exc_error THEN
3356: IF PG_DEBUG <> 0 THEN
3357: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Exception in stmt num: '
3358: || to_char(lStmtNum), 1);
3359: END IF;
3360: x_return_status := FND_API.G_RET_STS_ERROR;
3361: -- Get message count and data

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

3364: , p_msg_data => x_msg_data
3365: );
3366: WHEN fnd_api.g_exc_unexpected_error THEN
3367: IF PG_DEBUG <> 0 THEN
3368: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || ' Unexpected Exception in stmt num: '
3369: || to_char(lStmtNum), 1);
3370: END IF;
3371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3372: -- Get message count and data

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

3374: ( p_msg_count => x_msg_count
3375: , p_msg_data => x_msg_data
3376: );
3377: WHEN OTHERS then
3378: oe_debug_pub.add('errmsg'||sqlerrm);
3379: IF PG_DEBUG <> 0 THEN
3380: oe_debug_pub.add('error='||sqlerrm);
3381: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Others Exception in stmt num: '
3382: || to_char(lStmtNum), 1);

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

3376: );
3377: WHEN OTHERS then
3378: oe_debug_pub.add('errmsg'||sqlerrm);
3379: IF PG_DEBUG <> 0 THEN
3380: oe_debug_pub.add('error='||sqlerrm);
3381: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Others Exception in stmt num: '
3382: || to_char(lStmtNum), 1);
3383: END IF;
3384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3377: WHEN OTHERS then
3378: oe_debug_pub.add('errmsg'||sqlerrm);
3379: IF PG_DEBUG <> 0 THEN
3380: oe_debug_pub.add('error='||sqlerrm);
3381: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Others Exception in stmt num: '
3382: || to_char(lStmtNum), 1);
3383: END IF;
3384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3385: -- Get message count and data

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

3410:
3411: BEGIN
3412:
3413: IF PG_DEBUG <> 0 THEN
3414: oe_debug_pub.add('BEGIN xfer_match_flag_to_rec_of_tab: ', 5);
3415: END IF;
3416:
3417: lStmtNum :=10;
3418: j:= p_sparse_tab.first;

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

3430:
3431: EXCEPTION
3432: WHEN fnd_api.g_exc_error THEN
3433: IF PG_DEBUG <> 0 THEN
3434: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Exception in stmt num: '
3435: || to_char(lStmtNum), 1);
3436: END IF;
3437: x_return_status := FND_API.G_RET_STS_ERROR;
3438: -- Get message count and data

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

3441: , p_msg_data => x_msg_data
3442: );
3443: WHEN fnd_api.g_exc_unexpected_error THEN
3444: IF PG_DEBUG <> 0 THEN
3445: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || ' Unexpected Exception in stmt num: '
3446: || to_char(lStmtNum), 1);
3447: END IF;
3448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3449: -- Get message count and data

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

3451: ( p_msg_count => x_msg_count
3452: , p_msg_data => x_msg_data
3453: );
3454: WHEN OTHERS then
3455: oe_debug_pub.add('errmsg'||sqlerrm);
3456: IF PG_DEBUG <> 0 THEN
3457: oe_debug_pub.add('error='||sqlerrm);
3458: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Others Exception in stmt num: '
3459: || to_char(lStmtNum), 1);

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

3453: );
3454: WHEN OTHERS then
3455: oe_debug_pub.add('errmsg'||sqlerrm);
3456: IF PG_DEBUG <> 0 THEN
3457: oe_debug_pub.add('error='||sqlerrm);
3458: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Others Exception in stmt num: '
3459: || to_char(lStmtNum), 1);
3460: END IF;
3461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3454: WHEN OTHERS then
3455: oe_debug_pub.add('errmsg'||sqlerrm);
3456: IF PG_DEBUG <> 0 THEN
3457: oe_debug_pub.add('error='||sqlerrm);
3458: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Others Exception in stmt num: '
3459: || to_char(lStmtNum), 1);
3460: END IF;
3461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3462: -- Get message count and data

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

3501:
3502: BEGIN
3503:
3504: IF PG_DEBUG <> 0 THEN
3505: oe_debug_pub.add('ENTERED Update_BCOLGT_with_match_flag', 5);
3506: END IF;
3507:
3508: --added for re-arch
3509: --get match flag for all non-pahtom ato models

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

3528: WHERE bcol.bom_item_type = '1'-- used inverted commas to use index
3529: AND nvl(bcol.wip_supply_type,1) <> 6;
3530:
3531: IF PG_DEBUG <> 0 THEN
3532: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'Sql%row count ='||sql%rowcount,3);
3533: END IF;
3534:
3535:
3536: --prepare a record structure for input paremeter to

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

3564:
3565: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3566: --level1
3567: -- IF PG_DEBUG <> 0 THEN
3568: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||
3569: 'success after Evaluate_N_Pop_Match_Flag', 1);
3570: -- END IF;
3571:
3572: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

3588:
3589: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3590: --level1
3591: IF PG_DEBUG <> 0 THEN
3592: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'success after xfer_match_flag_to_rec_of_tab', 1);
3593: END IF;
3594:
3595: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3596: RAISE fnd_api.g_exc_error;

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

3605: WHERE line_id = l_match_flag_rec_of_tab.line_id (i);
3606:
3607:
3608: IF PG_DEBUG <> 0 THEN
3609: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'Sql%row count ='||sql%rowcount,3);
3610: END IF;
3611:
3612: EXCEPTION
3613: WHEN fnd_api.g_exc_error THEN

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

3611:
3612: EXCEPTION
3613: WHEN fnd_api.g_exc_error THEN
3614: IF PG_DEBUG <> 0 THEN
3615: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || 'Exception in stmt num: '
3616: || to_char(lStmtNum), 1);
3617: END IF;
3618: x_return_status := FND_API.G_RET_STS_ERROR;
3619: -- Get message count and data

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

3622: , p_msg_data => x_msg_data
3623: );
3624: WHEN fnd_api.g_exc_unexpected_error THEN
3625: IF PG_DEBUG <> 0 THEN
3626: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || ' Unexpected Exception in stmt num: '
3627: || to_char(lStmtNum), 1);
3628: END IF;
3629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3630: -- Get message count and data

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

3635: WHEN OTHERS then
3636:
3637: IF PG_DEBUG <> 0 THEN
3638:
3639: oe_debug_pub.add('Update_BCOLGT_with_match_flag' || 'Others Exception in stmt num: '
3640: || to_char(lStmtNum), 1);
3641: oe_debug_pub.add('error '||sqlerrm,1);
3642: END IF;
3643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3637: IF PG_DEBUG <> 0 THEN
3638:
3639: oe_debug_pub.add('Update_BCOLGT_with_match_flag' || 'Others Exception in stmt num: '
3640: || to_char(lStmtNum), 1);
3641: oe_debug_pub.add('error '||sqlerrm,1);
3642: END IF;
3643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3644: -- Get message count and data
3645: cto_msg_pub.count_and_get