DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_CST_TXN_COST_DETAILS_PKG

Line 3088: print_debug('Calling MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row', 9);

3084: -- inv_mmt_insert returns success
3085: -- Loop through the records of pl/sql table, if transaction cost is not null,
3086: -- call costing API to insert into MTL_CST_TXN_COST_DETAILS
3087: IF (l_debug = 1) THEN
3088: print_debug('Calling MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row', 9);
3089: END IF;
3090:
3091: IF (p_logical_trx_type_code = G_LOGTRXCODE_RETROPRICEUPD) THEN
3092: l_progress := 440;

Line 3125: MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row(

3121:
3122: IF l_process_enabled_flag = 'N'
3123: THEN
3124:
3125: MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row(
3126: X_Rowid => l_row_id
3127: , X_Transaction_Id => l_mtl_trx_tbl(i).transaction_id
3128: , X_Organization_Id => l_mtl_trx_tbl(i).organization_id
3129: , X_Cost_Element_Id => 1

Line 3140: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns error', 9);

3136: , X_Transaction_Cost => l_mtl_trx_tbl(i).old_po_price
3137: , X_Value_Change => l_mtl_trx_tbl(i).old_po_price-l_mtl_trx_tbl(i).new_po_price);
3138: IF (l_row_id is null or l_row_id < 0) THEN
3139: IF (l_debug = 1) THEN
3140: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns error', 9);
3141: print_debug('l_row_id = ' || l_row_id, 9);
3142: END IF;
3143: FND_MESSAGE.SET_NAME('INV', 'INV_INSERT_COST_ERR');
3144: FND_MSG_PUB.ADD;

Line 3165: MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row(

3161: print_debug('X_Last_Updated_By = ' || l_user_id, 9);
3162: print_debug('X_Inventory_Item_Id = ' || l_mtl_trx_tbl(i).inventory_item_id, 9);
3163: print_debug('X_Transaction_Cost = ' || l_mtl_trx_tbl(i).transaction_cost, 9);
3164: END IF;
3165: MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row(
3166: X_Rowid => l_row_id
3167: , X_Transaction_Id => l_mtl_trx_tbl(i).transaction_id
3168: , X_Organization_Id => l_mtl_trx_tbl(i).organization_id
3169: , X_Cost_Element_Id => 1

Line 3180: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns error', 9);

3176: , X_Transaction_Cost => l_mtl_trx_tbl(i).transaction_cost
3177: , X_Value_Change => null);
3178: IF (l_row_id is null or l_row_id < 0) THEN
3179: IF (l_debug = 1) THEN
3180: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns error', 9);
3181: print_debug('l_row_id = ' || l_row_id, 9);
3182: END IF;
3183: FND_MESSAGE.SET_NAME('INV', 'INV_INSERT_COST_ERR');
3184: FND_MSG_PUB.ADD;

Line 3188: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns success', 9);

3184: FND_MSG_PUB.ADD;
3185: RAISE FND_API.G_EXC_ERROR;
3186: ELSE
3187: IF (l_debug = 1) THEN
3188: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns success', 9);
3189: END IF;
3190: END IF;
3191: END IF;
3192: END LOOP;