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.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on OE_DEBUG_PUB

Line 1231: oe_debug_pub.add('populate_bcol: ' || 'INVALID MODEL SETUP exists for line id ' || bcol_tab(i).line_id

1227: if( bcol_tab(i).bom_item_type = 1 and nvl(bcol_tab(i).wip_supply_type, 1 ) <> 6 and bcol_tab(i).config_creation in (1, 2) ) then
1228:
1229: if( bcol_tab(bcol_tab(i).parent_ato_line_id).config_creation = 3) then
1230:
1231: oe_debug_pub.add('populate_bcol: ' || 'INVALID MODEL SETUP exists for line id ' || bcol_tab(i).line_id
1232: || ' model item ' || bcol_tab(i).inventory_item_id
1233: || ' item type ' || bcol_tab(i).config_creation
1234: , 1 );
1235: oe_debug_pub.add('populate_bcol: ' || ' parent line id ' || bcol_tab(bcol_tab(i).parent_ato_line_id).line_id

Line 1235: oe_debug_pub.add('populate_bcol: ' || ' parent line id ' || bcol_tab(bcol_tab(i).parent_ato_line_id).line_id

1231: oe_debug_pub.add('populate_bcol: ' || 'INVALID MODEL SETUP exists for line id ' || bcol_tab(i).line_id
1232: || ' model item ' || bcol_tab(i).inventory_item_id
1233: || ' item type ' || bcol_tab(i).config_creation
1234: , 1 );
1235: oe_debug_pub.add('populate_bcol: ' || ' parent line id ' || bcol_tab(bcol_tab(i).parent_ato_line_id).line_id
1236: || ' parent model item ' || bcol_tab(bcol_tab(i).parent_ato_line_id).inventory_item_id
1237: || ' parent item type ' || bcol_tab(bcol_tab(i).parent_ato_line_id).config_creation
1238: , 1 );
1239:

Line 1266: oe_debug_pub.add('populate_bcol: ' || ' preparing information for v_match_flag_tab ' , 3 );

1262: ** PENDING WORK!!!!
1263: */
1264:
1265: if( lMatchProfile = 1 ) then
1266: oe_debug_pub.add('populate_bcol: ' || ' preparing information for v_match_flag_tab ' , 3 );
1267: i :=bcol_tab.first ;
1268:
1269: while i is not null
1270: loop

Line 1285: oe_debug_pub.add('populate_bcol: ' || ' going to call cto_match_config.evaluate_n_pop_match_flag ' , 3 );

1281:
1282: end loop ;
1283:
1284:
1285: oe_debug_pub.add('populate_bcol: ' || ' going to call cto_match_config.evaluate_n_pop_match_flag ' , 3 );
1286:
1287: cto_match_config.evaluate_n_pop_match_flag( p_match_flag_tab => v_match_flag_tab
1288: , x_sparse_tab => v_sparse_tab
1289: , x_return_status => x_return_status

Line 1297: oe_debug_pub.add('populate_bcol: ' || ' populating match flag from results ' , 3 );

1293:
1294:
1295:
1296:
1297: oe_debug_pub.add('populate_bcol: ' || ' populating match flag from results ' , 3 );
1298:
1299: i := v_sparse_tab.first ;
1300:
1301: while i is not null

Line 1306: oe_debug_pub.add('populate_bcol: ' || i || ' match set to ' || bcol_tab(i).perform_match , 3 );

1302: loop
1303:
1304: bcol_tab(i).perform_match := v_sparse_tab(i).match_flag ;
1305:
1306: oe_debug_pub.add('populate_bcol: ' || i || ' match set to ' || bcol_tab(i).perform_match , 3 );
1307:
1308:
1309:
1310: if( bcol_tab(i).line_id = bcol_tab(i).ato_line_id ) then

Line 1311: oe_debug_pub.add('populate_bcol: ' || ' v_perform_match before ' || v_perform_match , 3 );

1307:
1308:
1309:
1310: if( bcol_tab(i).line_id = bcol_tab(i).ato_line_id ) then
1311: oe_debug_pub.add('populate_bcol: ' || ' v_perform_match before ' || v_perform_match , 3 );
1312: v_perform_match := bcol_tab(i).perform_match ;
1313: x_match_profile_on := bcol_tab(i).perform_match ;
1314:
1315: oe_debug_pub.add('populate_bcol: ' || ' v_perform_match after ' || v_perform_match , 3 );

Line 1315: oe_debug_pub.add('populate_bcol: ' || ' v_perform_match after ' || v_perform_match , 3 );

1311: oe_debug_pub.add('populate_bcol: ' || ' v_perform_match before ' || v_perform_match , 3 );
1312: v_perform_match := bcol_tab(i).perform_match ;
1313: x_match_profile_on := bcol_tab(i).perform_match ;
1314:
1315: oe_debug_pub.add('populate_bcol: ' || ' v_perform_match after ' || v_perform_match , 3 );
1316:
1317: end if ;
1318: i := v_sparse_tab.next(i) ;
1319:

Line 1322: oe_debug_pub.add('populate_bcol: ' || ' done populating match flag from results ' , 3 );

1318: i := v_sparse_tab.next(i) ;
1319:
1320: end loop ;
1321:
1322: oe_debug_pub.add('populate_bcol: ' || ' done populating match flag from results ' , 3 );
1323:
1324:
1325: else
1326:

Line 1327: oe_debug_pub.add('populate_bcol: ' || ' will not be calling cto_match_config.evaluate_n_pop_match_flag ' , 3 );

1323:
1324:
1325: else
1326:
1327: oe_debug_pub.add('populate_bcol: ' || ' will not be calling cto_match_config.evaluate_n_pop_match_flag ' , 3 );
1328:
1329: end if ;
1330:
1331:

Line 1457: oe_debug_pub.add ('Create_Preconfig_Item_ML:New: ' ||

1453:
1454:
1455: if x_return_status = FND_API.G_RET_STS_ERROR then
1456:
1457: oe_debug_pub.add ('Create_Preconfig_Item_ML:New: ' ||
1458: 'Failed in create_preconfig_item_ml with expected error.', 1);
1459:
1460: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' ,
1461: ':NEW: failed in create_preconfig_item_ml ' || x_msg_data ) ;

Line 1468: oe_debug_pub.add ('Create_Preconfig_Item_ML:New: ' ||

1464: raise FND_API.G_EXC_ERROR;
1465:
1466: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1467:
1468: oe_debug_pub.add ('Create_Preconfig_Item_ML:New: ' ||
1469: 'Failed in create_preconfig_item_ml with unexpected error.', 1);
1470:
1471: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1472: end if;

Line 1723: oe_debug_pub.add ('Getting top model item id.. ', 1) ;

1719: v_step := 'Step 9 ' ;
1720:
1721: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' copying model catalog group id from validation org ') ;
1722:
1723: oe_debug_pub.add ('Getting top model item id.. ', 1) ;
1724:
1725: -- Following statement will select top model item id.
1726: -- Since only one row is expected to be returned this is implemented
1727: -- as SELECT statement instead of using a CURSOR for multi-row

Line 1734: oe_debug_pub.add ('Top Model Id : '||to_char(l_top_model_id)||' Program_id : '||to_char(lprogram_id)||' Config Item Id : '||to_char(lconfig_item_id), 2);

1730: into l_top_model_id,lprogram_id,lconfig_item_id
1731: from bom_cto_order_lines
1732: where line_id=p_top_ato_line_id ;
1733:
1734: oe_debug_pub.add ('Top Model Id : '||to_char(l_top_model_id)||' Program_id : '||to_char(lprogram_id)||' Config Item Id : '||to_char(lconfig_item_id), 2);
1735:
1736:
1737: oe_debug_pub.add ('Getting Validation Org.. ', 1) ;
1738:

Line 1737: oe_debug_pub.add ('Getting Validation Org.. ', 1) ;

1733:
1734: oe_debug_pub.add ('Top Model Id : '||to_char(l_top_model_id)||' Program_id : '||to_char(lprogram_id)||' Config Item Id : '||to_char(lconfig_item_id), 2);
1735:
1736:
1737: oe_debug_pub.add ('Getting Validation Org.. ', 1) ;
1738:
1739:
1740: if lprogram_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID then
1741: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;

Line 1745: oe_debug_pub.add ('Validation Org : '||to_char(lValidationOrg), 2) ;

1741: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;
1742: end if;
1743:
1744:
1745: oe_debug_pub.add ('Validation Org : '||to_char(lValidationOrg), 2) ;
1746:
1747: -- Following statement will select item_catalog_grp_id
1748: -- of top model item id in validation org.
1749:

Line 1756: oe_debug_pub.add ('Item Catalog Group Id : '||to_char(licg_id), 2) ;

1752: from mtl_system_items
1753: where inventory_item_id = l_top_model_id
1754: and organization_id = lValidationOrg;
1755:
1756: oe_debug_pub.add ('Item Catalog Group Id : '||to_char(licg_id), 2) ;
1757:
1758: -- If the model item has catalog , that catalog group id
1759: -- is copied to preconfig item in all org
1760:

Line 1766: oe_debug_pub.add ('Updated catalog group id of preconfig item ' , 2) ;

1762: update mtl_system_items
1763: set item_catalog_group_id = licg_id
1764: where inventory_item_id = lconfig_item_id
1765: and nvl(item_catalog_group_id,0) = 0; --Bugfix 6043798
1766: oe_debug_pub.add ('Updated catalog group id of preconfig item ' , 2) ;
1767: end if;
1768:
1769: -- end fix 2394597
1770:

Line 1820: oe_debug_pub.add ('Create_All_Items returned with 0', 1) ;

1816:
1817:
1818:
1819: IF lStatus <> 1 then
1820: oe_debug_pub.add ('Create_All_Items returned with 0', 1) ;
1821: oe_debug_pub.add ('Create_All_Items returned with 0' || xMsgData , 1) ;
1822: oe_debug_pub.add ('Create_All_Items returned with 0' || to_char(xMsgCount) , 1) ;
1823:
1824: x_msg_count := xMsgCount ;

Line 1821: oe_debug_pub.add ('Create_All_Items returned with 0' || xMsgData , 1) ;

1817:
1818:
1819: IF lStatus <> 1 then
1820: oe_debug_pub.add ('Create_All_Items returned with 0', 1) ;
1821: oe_debug_pub.add ('Create_All_Items returned with 0' || xMsgData , 1) ;
1822: oe_debug_pub.add ('Create_All_Items returned with 0' || to_char(xMsgCount) , 1) ;
1823:
1824: x_msg_count := xMsgCount ;
1825: x_msg_data := xMsgData ;

Line 1822: oe_debug_pub.add ('Create_All_Items returned with 0' || to_char(xMsgCount) , 1) ;

1818:
1819: IF lStatus <> 1 then
1820: oe_debug_pub.add ('Create_All_Items returned with 0', 1) ;
1821: oe_debug_pub.add ('Create_All_Items returned with 0' || xMsgData , 1) ;
1822: oe_debug_pub.add ('Create_All_Items returned with 0' || to_char(xMsgCount) , 1) ;
1823:
1824: x_msg_count := xMsgCount ;
1825: x_msg_data := xMsgData ;
1826:

Line 1982: oe_debug_pub.add(

1978:
1979: -- insert into my_debug_messages values ( ' canned configuration ' || to_char( lNextRec.line_id ) ) ;
1980: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' canned configuration ' || to_char( lNextRec.line_id ) ) ;
1981:
1982: oe_debug_pub.add(
1983: 'Returned from canning in stmt num 110 with status '
1984: || to_char(lStatus), 1);
1985:
1986: if (lStatus <> 1) then

Line 2716: oe_debug_pub.add('Standard Match.', 1);

2712: else
2713:
2714: if ( l_custom_match_profile = 2) then
2715: l_stmt_num := 10;
2716: oe_debug_pub.add('Standard Match.', 1);
2717: l_status := cto_match_config.check_config_match(
2718: l_next_rec.line_id,
2719: l_x_config_id,
2720: l_x_error_msg,

Line 2736: oe_debug_pub.add('Failed in Check Config Match for line id '

2732:
2733: l_stmt_num := 20;
2734:
2735: if (l_status = 0) then
2736: oe_debug_pub.add('Failed in Check Config Match for line id '
2737: || to_char(l_next_rec.line_id), 1);
2738:
2739: raise PROCESS_ERROR;
2740:

Line 2807: oe_debug_pub.add('Match for line id '

2803:
2804: l_stmt_num := 35;
2805:
2806: /*
2807: oe_debug_pub.add('Match for line id '
2808: || to_char(l_next_rec.line_id)
2809: || ' is ' || to_char(l_x_config_id) ,1);
2810: */
2811: