1686: x_msg_count,
1687: x_msg_data);
1688:
1689: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , x_msg_data ) ;
1690: FND_MESSAGE.parse_encoded( x_msg_data, v_appl_name, v_error_name ) ;
1691:
1692: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML ' , v_appl_name || ' err ' || v_error_name ) ;
1693:
1694: if( x_return_status = FND_API.G_RET_STS_ERROR ) then
2131: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' came into expected exception create_preconfig_item_ml at step ' || to_char( x_msg_count) ) ;
2132:
2133:
2134:
2135: -- x_msg_data := FND_MESSAGE.GET ;
2136:
2137: when FND_API.G_EXC_UNEXPECTED_ERROR then
2138: -- insert into my_debug_messages values ( ' came into unexpected exception create_preconfig_item_ml at step ' || v_step ) ;
2139: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' came into unexpected exception create_preconfig_item_ml at step ' || v_step ) ;
3887: WHEN OTHERS THEN
3888: DELETE from bom_explosion_temp;
3889: x_message := 'BOM_CONFIG_EXPLOSIONS_PKG.Insert_Mandatory_Components('
3890: || to_char(X_Stmt_Num) || '):';
3891: FND_MESSAGE.Set_Name('BOM','CZ_PLSQL_ERROR');
3892: FND_MESSAGE.Set_Token('PACKAGE',x_message);
3893: FND_MESSAGE.Set_Token('ORA_ERROR',SQLCODE);
3894: FND_MESSAGE.Set_Token('ORA_TEXT',substr(SQLERRM,1,100));
3895: x_message := FND_MESSAGE.Get;
3888: DELETE from bom_explosion_temp;
3889: x_message := 'BOM_CONFIG_EXPLOSIONS_PKG.Insert_Mandatory_Components('
3890: || to_char(X_Stmt_Num) || '):';
3891: FND_MESSAGE.Set_Name('BOM','CZ_PLSQL_ERROR');
3892: FND_MESSAGE.Set_Token('PACKAGE',x_message);
3893: FND_MESSAGE.Set_Token('ORA_ERROR',SQLCODE);
3894: FND_MESSAGE.Set_Token('ORA_TEXT',substr(SQLERRM,1,100));
3895: x_message := FND_MESSAGE.Get;
3896: return;
3889: x_message := 'BOM_CONFIG_EXPLOSIONS_PKG.Insert_Mandatory_Components('
3890: || to_char(X_Stmt_Num) || '):';
3891: FND_MESSAGE.Set_Name('BOM','CZ_PLSQL_ERROR');
3892: FND_MESSAGE.Set_Token('PACKAGE',x_message);
3893: FND_MESSAGE.Set_Token('ORA_ERROR',SQLCODE);
3894: FND_MESSAGE.Set_Token('ORA_TEXT',substr(SQLERRM,1,100));
3895: x_message := FND_MESSAGE.Get;
3896: return;
3897: END BOM_INS_MODEL_AND_MANDATORY;
3890: || to_char(X_Stmt_Num) || '):';
3891: FND_MESSAGE.Set_Name('BOM','CZ_PLSQL_ERROR');
3892: FND_MESSAGE.Set_Token('PACKAGE',x_message);
3893: FND_MESSAGE.Set_Token('ORA_ERROR',SQLCODE);
3894: FND_MESSAGE.Set_Token('ORA_TEXT',substr(SQLERRM,1,100));
3895: x_message := FND_MESSAGE.Get;
3896: return;
3897: END BOM_INS_MODEL_AND_MANDATORY;
3898:
3891: FND_MESSAGE.Set_Name('BOM','CZ_PLSQL_ERROR');
3892: FND_MESSAGE.Set_Token('PACKAGE',x_message);
3893: FND_MESSAGE.Set_Token('ORA_ERROR',SQLCODE);
3894: FND_MESSAGE.Set_Token('ORA_TEXT',substr(SQLERRM,1,100));
3895: x_message := FND_MESSAGE.Get;
3896: return;
3897: END BOM_INS_MODEL_AND_MANDATORY;
3898:
3899: