DBA Data[Home] [Help]

APPS.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on OE_DEBUG_PUB

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

1224: 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
1225:
1226: if( bcol_tab(bcol_tab(i).parent_ato_line_id).config_creation = 3) then
1227:
1228: oe_debug_pub.add('populate_bcol: ' || 'INVALID MODEL SETUP exists for line id ' || bcol_tab(i).line_id
1229: || ' model item ' || bcol_tab(i).inventory_item_id
1230: || ' item type ' || bcol_tab(i).config_creation
1231: , 1 );
1232: oe_debug_pub.add('populate_bcol: ' || ' parent line id ' || bcol_tab(bcol_tab(i).parent_ato_line_id).line_id

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1731: 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);

1727: into l_top_model_id,lprogram_id,lconfig_item_id
1728: from bom_cto_order_lines
1729: where line_id=p_top_ato_line_id ;
1730:
1731: 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);
1732:
1733:
1734: oe_debug_pub.add ('Getting Validation Org.. ', 1) ;
1735:

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

1730:
1731: 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);
1732:
1733:
1734: oe_debug_pub.add ('Getting Validation Org.. ', 1) ;
1735:
1736:
1737: if lprogram_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID then
1738: lValidationOrg := CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG ;

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

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

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

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

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

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

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

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

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

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

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

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

Line 1979: oe_debug_pub.add(

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

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

2707: else
2708:
2709: if ( l_custom_match_profile = 2) then
2710: l_stmt_num := 10;
2711: oe_debug_pub.add('Standard Match.', 1);
2712: l_status := cto_match_config.check_config_match(
2713: l_next_rec.line_id,
2714: l_x_config_id,
2715: l_x_error_msg,

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

2727:
2728: l_stmt_num := 20;
2729:
2730: if (l_status = 0) then
2731: oe_debug_pub.add('Failed in Check Config Match for line id '
2732: || to_char(l_next_rec.line_id), 1);
2733:
2734: raise PROCESS_ERROR;
2735:

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

2798:
2799: l_stmt_num := 35;
2800:
2801: /*
2802: oe_debug_pub.add('Match for line id '
2803: || to_char(l_next_rec.line_id)
2804: || ' is ' || to_char(l_x_config_id) ,1);
2805: */
2806: